{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "SALES", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -9004189.1324, "ymin": 3038848.4847, "xmax": -8908992.4602, "ymax": 3119837.4074, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var saledate = $feature.Q_SALE_DATE\nvar timeSinceSale = IIF(IsEmpty(saledate), 3600, DateDiff(Today(), saledate, 'months'))\nwhen(\ntimeSinceSale > 3599, \"Last sale date unknown\",\ntimeSinceSale > 36, \"More than 3 years\",\ntimeSinceSale > 24, \"Between 2 and 3 years\",\ntimeSinceSale > 12, \"Between 1 and 2 years\",\ntimeSinceSale > 6, \"Between 6 months and 1 year\",\n\"Less than 6 months\");", "valueExpressionTitle": "Time since last sale", "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 254, 254, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 254, 254, 0, 127 ], "width": 0.7 } }, "value": "Less than 6 months", "label": "Less than 6 months" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 254, 190, 190, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 254, 190, 190, 127 ], "width": 0.7 } }, "value": "Between 6 months and 1 year", "label": "Between 6 months and 1 year" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 1, 93, 228, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 1, 93, 228, 127 ], "width": 0.7 } }, "value": "Between 1 and 2 years", "label": "Between 1 and 2 years" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 229, 1, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 229, 1, 0, 127 ], "width": 0.7 } }, "value": "Between 2 and 3 years", "label": "Between 2 and 3 years" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 228, 151, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 228, 151, 0, 127 ], "width": 0.7 } }, "value": "More than 3 years", "label": "More than 3 years" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 255, 255, 0, 255 ], "toColor": [ 255, 255, 0, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 255, 191, 191, 255 ], "toColor": [ 255, 191, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 0, 91, 227, 255 ], "toColor": [ 0, 91, 227, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 230, 0, 0, 255 ], "toColor": [ 230, 0, 0, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 151, 0, 255 ], "toColor": [ 227, 151, 0, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "OWNER_NAME1", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PARID", "type": "esriFieldTypeString", "alias": "PARID", "domain": null, "editable": true, "nullable": true, "length": 17, "defaultValue": null, "modelName": "PARID" }, { "name": "ACRES", "type": "esriFieldTypeDouble", "alias": "ACRES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACRES" }, { "name": "PAO.PARCEL_DETAILS.AREA", "type": "esriFieldTypeDouble", "alias": "PAO.PARCEL_DETAILS.AREA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PAO.PARCEL_DETAILS.AREA" }, { "name": "CONDO", "type": "esriFieldTypeString", "alias": "CONDO", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "CONDO" }, { "name": "PARCEL_NUMBER", "type": "esriFieldTypeString", "alias": "PARCEL_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PARCEL_NUMBER" }, { "name": "OWNER_NAME1", "type": "esriFieldTypeString", "alias": "OWNER_NAME1", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "OWNER_NAME1" }, { "name": "OWNER_NAME2", "type": "esriFieldTypeString", "alias": "OWNER_NAME2", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "OWNER_NAME2" }, { "name": "STREET_NUMBER", "type": "esriFieldTypeString", "alias": "STREET_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "STREET_NUMBER" }, { "name": "STREET_FRACTION", "type": "esriFieldTypeString", "alias": "STREET_FRACTION", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "STREET_FRACTION" }, { "name": "PRE_DIR", "type": "esriFieldTypeString", "alias": "PRE_DIR", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "PRE_DIR" }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "STREET_NAME" }, { "name": "STREET_SUFFIX_ABBR", "type": "esriFieldTypeString", "alias": "STREET_SUFFIX_ABBR", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "STREET_SUFFIX_ABBR" }, { "name": "POST_DIR", "type": "esriFieldTypeString", "alias": "POST_DIR", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "POST_DIR" }, { "name": "SITE_ADDR_STR", "type": "esriFieldTypeString", "alias": "SITE_ADDR_STR", "domain": null, "editable": true, "nullable": true, "length": 121, "defaultValue": null, "modelName": "SITE_ADDR_STR" }, { "name": "MUNICIPALITY", "type": "esriFieldTypeString", "alias": "MUNICIPALITY", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "MUNICIPALITY" }, { "name": "NBHD", "type": "esriFieldTypeString", "alias": "NBHD", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "NBHD" }, { "name": "PADDR1", "type": "esriFieldTypeString", "alias": "PADDR1", "domain": null, "editable": true, "nullable": true, "length": 121, "defaultValue": null, "modelName": "PADDR1" }, { "name": "PADDR2", "type": "esriFieldTypeString", "alias": "PADDR2", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "PADDR2" }, { "name": "PADDR3", "type": "esriFieldTypeString", "alias": "PADDR3", "domain": null, "editable": true, "nullable": true, "length": 123, "defaultValue": null, "modelName": "PADDR3" }, { "name": "CITYNAME", "type": "esriFieldTypeString", "alias": "CITYNAME", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "CITYNAME" }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "STATE" }, { "name": "ZIP1", "type": "esriFieldTypeString", "alias": "ZIP1", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ZIP1" }, { "name": "ZIP2", "type": "esriFieldTypeString", "alias": "ZIP2", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "ZIP2" }, { "name": "SALEKEY", "type": "esriFieldTypeInteger", "alias": "SALEKEY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SALEKEY" }, { "name": "CRA", "type": "esriFieldTypeString", "alias": "CRA", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CRA" }, { "name": "SALE_DATE", "type": "esriFieldTypeDate", "alias": "SALE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SALE_DATE" }, { "name": "BOOK", "type": "esriFieldTypeString", "alias": "BOOK", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BOOK" }, { "name": "PAGE", "type": "esriFieldTypeString", "alias": "PAGE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PAGE" }, { "name": "PRICE", "type": "esriFieldTypeString", "alias": "PRICE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PRICE" }, { "name": "INSTRUMENT", "type": "esriFieldTypeString", "alias": "INSTRUMENT", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "INSTRUMENT" }, { "name": "TOTAL_MARKET", "type": "esriFieldTypeDouble", "alias": "TOTAL_MARKET", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_MARKET" }, { "name": "MKT_NOT_CAPPED", "type": "esriFieldTypeDouble", "alias": "MKT_NOT_CAPPED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MKT_NOT_CAPPED" }, { "name": "MKT_CAPPED", "type": "esriFieldTypeDouble", "alias": "MKT_CAPPED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MKT_CAPPED" }, { "name": "CAP_ADJ_VAL", "type": "esriFieldTypeDouble", "alias": "CAP_ADJ_VAL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CAP_ADJ_VAL" }, { "name": "AG_USE_VAL", "type": "esriFieldTypeDouble", "alias": "AG_USE_VAL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AG_USE_VAL" }, { "name": "ASSESSED_VAL", "type": "esriFieldTypeDouble", "alias": "ASSESSED_VAL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ASSESSED_VAL" }, { "name": "EXEMPTION", "type": "esriFieldTypeDouble", "alias": "EXEMPTION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXEMPTION" }, { "name": "TOTAL_VALUE", "type": "esriFieldTypeDouble", "alias": "TOTAL_VALUE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_VALUE" }, { "name": "TOTAL_TAXABLE", "type": "esriFieldTypeDouble", "alias": "TOTAL_TAXABLE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_TAXABLE" }, { "name": "HMSTD_FLG", "type": "esriFieldTypeString", "alias": "HMSTD_FLG", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "HMSTD_FLG" }, { "name": "SUBDIV_NAME", "type": "esriFieldTypeString", "alias": "SUBDIV_NAME", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "SUBDIV_NAME" }, { "name": "YEAR_ADDED", "type": "esriFieldTypeString", "alias": "YEAR_ADDED", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "YEAR_ADDED" }, { "name": "LAND_MARKET", "type": "esriFieldTypeDouble", "alias": "LAND_MARKET", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LAND_MARKET" }, { "name": "IMPRV_MRKT", "type": "esriFieldTypeDouble", "alias": "IMPRV_MRKT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IMPRV_MRKT" }, { "name": "PROPERTY_USE", "type": "esriFieldTypeString", "alias": "PROPERTY_USE", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "PROPERTY_USE" }, { "name": "MONTHS_SINCE_SALE", "type": "esriFieldTypeDouble", "alias": "MONTHS_SINCE_SALE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MONTHS_SINCE_SALE" }, { "name": "CONFID_FLG", "type": "esriFieldTypeString", "alias": "CONFID_FLG", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CONFID_FLG" }, { "name": "QUAL_CODE", "type": "esriFieldTypeString", "alias": "QUAL_CODE", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "QUAL_CODE" }, { "name": "Q_SALE_DATE", "type": "esriFieldTypeDate", "alias": "Q_SALE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Q_SALE_DATE" }, { "name": "LEGAL1", "type": "esriFieldTypeString", "alias": "LEGAL1", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "LEGAL1" }, { "name": "LEGAL2", "type": "esriFieldTypeString", "alias": "LEGAL2", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "LEGAL2" }, { "name": "LEGAL3", "type": "esriFieldTypeString", "alias": "LEGAL3", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "LEGAL3" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "GEOMETRY.AREA", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "GEOMETRY.AREA" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "GEOMETRY.LEN", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "GEOMETRY.LEN" } ], "geometryField": { "name": "GEOMETRY", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GEOMETRY" }, "indexes": [ { "name": "R719_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A613_IX1", "fields": "GEOMETRY", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "SALES", "description": "", "prototype": { "attributes": { "LEGAL3": null, "LEGAL2": null, "PARID": null, "ACRES": null, "PAO.PARCEL_DETAILS.AREA": null, "CONDO": null, "PARCEL_NUMBER": null, "OWNER_NAME1": null, "OWNER_NAME2": null, "STREET_NUMBER": null, "STREET_FRACTION": null, "PRE_DIR": null, "STREET_NAME": null, "STREET_SUFFIX_ABBR": null, "POST_DIR": null, "SITE_ADDR_STR": null, "MUNICIPALITY": null, "NBHD": null, "PADDR1": null, "PADDR2": null, "PADDR3": null, "CITYNAME": null, "STATE": null, "ZIP1": null, "ZIP2": null, "SALEKEY": null, "CRA": null, "SALE_DATE": null, "BOOK": null, "PAGE": null, "PRICE": null, "INSTRUMENT": null, "TOTAL_MARKET": null, "MKT_NOT_CAPPED": null, "MKT_CAPPED": null, "CAP_ADJ_VAL": null, "AG_USE_VAL": null, "ASSESSED_VAL": null, "EXEMPTION": null, "TOTAL_VALUE": null, "TOTAL_TAXABLE": null, "HMSTD_FLG": null, "SUBDIV_NAME": null, "YEAR_ADDED": null, "LAND_MARKET": null, "IMPRV_MRKT": null, "PROPERTY_USE": null, "MONTHS_SINCE_SALE": null, "CONFID_FLG": null, "QUAL_CODE": null, "Q_SALE_DATE": null, "LEGAL1": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 5000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "958b8b1962b24f878e6506717f77f0f5" } ], "tables": [] }