{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "QSALES", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var qualified = ['Q', 'QC', 'QD', 'QL', 'QM', 'QO', 'QP']\nif (includes(qualified, $feature.QUAL_CODE)){\nvar 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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "OWNER_NAME1", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARID", "type": "esriFieldTypeString", "alias": "PARID", "length": 17, "domain": null }, { "name": "ACRES", "type": "esriFieldTypeDouble", "alias": "ACRES", "domain": null }, { "name": "PAO.PARCEL_DETAILS.AREA", "type": "esriFieldTypeDouble", "alias": "PAO.PARCEL_DETAILS.AREA", "domain": null }, { "name": "CONDO", "type": "esriFieldTypeString", "alias": "CONDO", "length": 200, "domain": null }, { "name": "PARCEL_NUMBER", "type": "esriFieldTypeString", "alias": "PARCEL_NUMBER", "length": 30, "domain": null }, { "name": "OWNER_NAME1", "type": "esriFieldTypeString", "alias": "OWNER_NAME1", "length": 40, "domain": null }, { "name": "OWNER_NAME2", "type": "esriFieldTypeString", "alias": "OWNER_NAME2", "length": 2000, "domain": null }, { "name": "STREET_NUMBER", "type": "esriFieldTypeString", "alias": "STREET_NUMBER", "length": 20, "domain": null }, { "name": "STREET_FRACTION", "type": "esriFieldTypeString", "alias": "STREET_FRACTION", "length": 6, "domain": null }, { "name": "PRE_DIR", "type": "esriFieldTypeString", "alias": "PRE_DIR", "length": 2, "domain": null }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "length": 30, "domain": null }, { "name": "STREET_SUFFIX_ABBR", "type": "esriFieldTypeString", "alias": "STREET_SUFFIX_ABBR", "length": 8, "domain": null }, { "name": "POST_DIR", "type": "esriFieldTypeString", "alias": "POST_DIR", "length": 8, "domain": null }, { "name": "SITE_ADDR_STR", "type": "esriFieldTypeString", "alias": "SITE_ADDR_STR", "length": 121, "domain": null }, { "name": "MUNICIPALITY", "type": "esriFieldTypeString", "alias": "MUNICIPALITY", "length": 40, "domain": null }, { "name": "NBHD", "type": "esriFieldTypeString", "alias": "NBHD", "length": 8, "domain": null }, { "name": "PADDR1", "type": "esriFieldTypeString", "alias": "PADDR1", "length": 121, "domain": null }, { "name": "PADDR2", "type": "esriFieldTypeString", "alias": "PADDR2", "length": 80, "domain": null }, { "name": "PADDR3", "type": "esriFieldTypeString", "alias": "PADDR3", "length": 123, "domain": null }, { "name": "CITYNAME", "type": "esriFieldTypeString", "alias": "CITYNAME", "length": 40, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "length": 2, "domain": null }, { "name": "ZIP1", "type": "esriFieldTypeString", "alias": "ZIP1", "length": 5, "domain": null }, { "name": "ZIP2", "type": "esriFieldTypeString", "alias": "ZIP2", "length": 4, "domain": null }, { "name": "SALEKEY", "type": "esriFieldTypeInteger", "alias": "SALEKEY", "domain": null }, { "name": "CRA", "type": "esriFieldTypeString", "alias": "CRA", "length": 20, "domain": null }, { "name": "SALE_DATE", "type": "esriFieldTypeDate", "alias": "SALE_DATE", "length": 8, "domain": null }, { "name": "BOOK", "type": "esriFieldTypeString", "alias": "BOOK", "length": 8, "domain": null }, { "name": "PAGE", "type": "esriFieldTypeString", "alias": "PAGE", "length": 8, "domain": null }, { "name": "PRICE", "type": "esriFieldTypeString", "alias": "PRICE", "length": 20, "domain": null }, { "name": "INSTRUMENT", "type": "esriFieldTypeString", "alias": "INSTRUMENT", "length": 2, "domain": null }, { "name": "TOTAL_MARKET", "type": "esriFieldTypeDouble", "alias": "TOTAL_MARKET", "domain": null }, { "name": "MKT_NOT_CAPPED", "type": "esriFieldTypeDouble", "alias": "MKT_NOT_CAPPED", "domain": null }, { "name": "MKT_CAPPED", "type": "esriFieldTypeDouble", "alias": "MKT_CAPPED", "domain": null }, { "name": "CAP_ADJ_VAL", "type": "esriFieldTypeDouble", "alias": "CAP_ADJ_VAL", "domain": null }, { "name": "AG_USE_VAL", "type": "esriFieldTypeDouble", "alias": "AG_USE_VAL", "domain": null }, { "name": "ASSESSED_VAL", "type": "esriFieldTypeDouble", "alias": "ASSESSED_VAL", "domain": null }, { "name": "EXEMPTION", "type": "esriFieldTypeDouble", "alias": "EXEMPTION", "domain": null }, { "name": "TOTAL_VALUE", "type": "esriFieldTypeDouble", "alias": "TOTAL_VALUE", "domain": null }, { "name": "TOTAL_TAXABLE", "type": "esriFieldTypeDouble", "alias": "TOTAL_TAXABLE", "domain": null }, { "name": "HMSTD_FLG", "type": "esriFieldTypeString", "alias": "HMSTD_FLG", "length": 2000, "domain": null }, { "name": "SUBDIV_NAME", "type": "esriFieldTypeString", "alias": "SUBDIV_NAME", "length": 2000, "domain": null }, { "name": "YEAR_ADDED", "type": "esriFieldTypeString", "alias": "YEAR_ADDED", "length": 20, "domain": null }, { "name": "LAND_MARKET", "type": "esriFieldTypeDouble", "alias": "LAND_MARKET", "domain": null }, { "name": "IMPRV_MRKT", "type": "esriFieldTypeDouble", "alias": "IMPRV_MRKT", "domain": null }, { "name": "PROPERTY_USE", "type": "esriFieldTypeString", "alias": "PROPERTY_USE", "length": 40, "domain": null }, { "name": "MONTHS_SINCE_SALE", "type": "esriFieldTypeDouble", "alias": "MONTHS_SINCE_SALE", "domain": null }, { "name": "CONFID_FLG", "type": "esriFieldTypeString", "alias": "CONFID_FLG", "length": 1, "domain": null }, { "name": "QUAL_CODE", "type": "esriFieldTypeString", "alias": "QUAL_CODE", "length": 2, "domain": null }, { "name": "Q_SALE_DATE", "type": "esriFieldTypeDate", "alias": "Q_SALE_DATE", "length": 8, "domain": null }, { "name": "LEGAL1", "type": "esriFieldTypeString", "alias": "LEGAL1", "length": 60, "domain": null }, { "name": "LEGAL2", "type": "esriFieldTypeString", "alias": "LEGAL2", "length": 60, "domain": null }, { "name": "LEGAL3", "type": "esriFieldTypeString", "alias": "LEGAL3", "length": 60, "domain": null }, { "name": "GEOMETRY", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GEOMETRY.AREA", "type": "esriFieldTypeDouble", "alias": "GEOMETRY.AREA", "domain": null }, { "name": "GEOMETRY.LEN", "type": "esriFieldTypeDouble", "alias": "GEOMETRY.LEN", "domain": null } ], "geometryField": { "name": "GEOMETRY", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R719_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A613_IX1", "fields": "GEOMETRY", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "GEOMETRY.AREA", "shapeLengthFieldName": "GEOMETRY.LEN", "units": "esriMeters" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7263fb6d4b8147a3b8d605eada262449" } ], "tables": [] }