{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "1/1/2017-12/31/2023 Sales", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 103161, "latestWkid": 6588, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "classBreaks", "authoringInfo": { "type": "classedColor", "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 62, 161, 207, 255 ], "toColor": [ 241, 250, 122, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 241, 250, 122, 255 ], "toColor": [ 240, 36, 29, 255 ] } ] }, "classificationMethod": "esriClassifyManual" }, "field": "ChambersCADWeb.DBO.Sales.Adjusted_Price", "classificationMethod": "esriClassifyManual", "minValue": 81, "classBreakInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 40, 146, 199, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 100000, "label": "0 - 100,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 140, 184, 164, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 200000, "label": "100,001 - 200,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 215, 227, 125, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 400000, "label": "200,001 - 400,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 207, 81, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 500000, "label": "400,001 - 500,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 247, 122, 45, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 1200000, "label": "500,001 - 1,200,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 232, 21, 21, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 14546000, "label": "1,200,001 - 14,546,000" } ], "legendOptions": {"order": "ascendingValues"} }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": { "expression": "\"PID: \" + $feature['ChambersCADWeb.DBO.TaxParcels.Name'] +textformatting.newline+ \"Sale Date: \" + Text($feature['ChambersCADWeb.DBO.Sales.Sale_Date'], 'M/D/Y') +textformatting.newline+ \"Bld Sqft: \" + Text($feature['ChambersCADWeb.DBO.Sales.Building_Sqft'], '#,###') +textformatting.newline+ \"Sale: $\" + Text($feature['ChambersCADWeb.DBO.Sales.Adjusted_Price'], '#,###')+textformatting.newline+ \"Market Value: $\" + Text($feature['ChambersCADWeb.DBO.Sales.Market_Value'], '#,###') +textformatting.newline+\r\n\"Market Sales Ratio: \" + Round($feature['ChambersCADWeb.DBO.Sales.Market_Value']/$feature['ChambersCADWeb.DBO.Sales.Adjusted_Price'],4) +textformatting.newline+ \"Current Value: $\" + Text($feature['ChambersCADWeb.DBO.Sales.Land_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Land_Nhs'] +$feature['ChambersCADWeb.DBO.Sales.Land_1d1'] + $feature['ChambersCADWeb.DBO.Sales.Land_1d'] + $feature['ChambersCADWeb.DBO.Sales.Personal_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Personal_Nhs'] + $feature['ChambersCADWeb.DBO.Sales.New_Personal_Hs'] + $feature['ChambersCADWeb.DBO.Sales.New_Personal_Nhs'] + $feature['ChambersCADWeb.DBO.Sales.Improvement_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Improvement_Nhs']+$feature['ChambersCADWeb.DBO.Sales.New_Improvement_Hs']+$feature['ChambersCADWeb.DBO.Sales.New_Improvement_Nhs']+$feature['ChambersCADWeb.DBO.Sales.New_Land_Hs'], '#,###') + textformatting.newline+ \"Current Sales Ratio: \" + Round(($feature['ChambersCADWeb.DBO.Sales.Land_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Land_Nhs'] +$feature['ChambersCADWeb.DBO.Sales.Land_1d1'] + $feature['ChambersCADWeb.DBO.Sales.Land_1d'] + $feature['ChambersCADWeb.DBO.Sales.Personal_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Personal_Nhs'] + $feature['ChambersCADWeb.DBO.Sales.New_Personal_Hs'] + $feature['ChambersCADWeb.DBO.Sales.New_Personal_Nhs'] + $feature['ChambersCADWeb.DBO.Sales.Improvement_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Improvement_Nhs']+$feature['ChambersCADWeb.DBO.Sales.New_Improvement_Hs']+$feature['ChambersCADWeb.DBO.Sales.New_Improvement_Nhs']+$feature['ChambersCADWeb.DBO.Sales.New_Land_Hs']) / $feature['ChambersCADWeb.DBO.Sales.Adjusted_Price'],4)", "title": "Custom" }, "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal", "multiPart": "labelLargest", "allowOverrun": false, "deconflictionStrategy": "dynamic", "repeatLabel": false, "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Default", "priority": 2, "symbol": { "type": "esriTS", "color": [ 56, 168, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "baseline", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 255 ], "haloSize": 2, "font": { "family": "Arial", "size": 12, "style": "italic", "weight": "bold", "decoration": "none" } } } ] }, "defaultVisibility": false, "extent": { "xmin": -1.0574900469827643E7, "ymin": 3440874.248603545, "xmax": -1.0501790951890342E7, "ymax": 3491693.6159381387, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ChambersCADWeb.DBO.TaxParcels.Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ChambersCADWeb.DBO.TaxParcels.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ChambersCADWeb.DBO.TaxParcels.Name", "type": "esriFieldTypeString", "alias": "Parcel Identification Number", "length": 50, "domain": null }, { "name": "ChambersCADWeb.DBO.TaxParcels.StatedArea", "type": "esriFieldTypeString", "alias": "Stated Area", "length": 50, "domain": null }, { "name": "ChambersCADWeb.DBO.TaxParcels.Parcel_CAMA", "type": "esriFieldTypeDouble", "alias": "Parcel_CAMA", "domain": null }, { "name": "ChambersCADWeb.DBO.TaxParcels.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Active", "type": "esriFieldTypeDouble", "alias": "Is_Active", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Parcel_Id", "type": "esriFieldTypeDouble", "alias": "Parcel_Id", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sequence", "type": "esriFieldTypeDouble", "alias": "Sequence", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Alternate_Sale_Id", "type": "esriFieldTypeDouble", "alias": "Alternate_Sale_Id", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Alternate_Parcel_Id", "type": "esriFieldTypeDouble", "alias": "Alternate_Parcel_Id", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Primary_Sale", "type": "esriFieldTypeDouble", "alias": "Is_Primary_Sale", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sale_Check", "type": "esriFieldTypeDouble", "alias": "Sale_Check", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Seller_Owner_Id", "type": "esriFieldTypeString", "alias": "Seller_Owner_Id", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Seller", "type": "esriFieldTypeString", "alias": "Seller", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Buyer_Owner_Id", "type": "esriFieldTypeString", "alias": "Buyer_Owner_Id", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Buyer", "type": "esriFieldTypeString", "alias": "Buyer", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sale_Date", "type": "esriFieldTypeDate", "alias": "Sale_Date", "length": 8, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Price", "type": "esriFieldTypeDouble", "alias": "Price", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Adjusted_Price", "type": "esriFieldTypeDouble", "alias": "Adjusted_Price", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Multi_Parcel_Sale", "type": "esriFieldTypeDouble", "alias": "Is_Multi_Parcel_Sale", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.User_Code1", "type": "esriFieldTypeString", "alias": "User_Code1", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.User_Code2", "type": "esriFieldTypeString", "alias": "User_Code2", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.File_Number", "type": "esriFieldTypeDouble", "alias": "File_Number", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Volume", "type": "esriFieldTypeDouble", "alias": "Volume", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Page", "type": "esriFieldTypeDouble", "alias": "Page", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Deed_Date", "type": "esriFieldTypeDate", "alias": "Deed_Date", "length": 8, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Neighborhood", "type": "esriFieldTypeString", "alias": "Neighborhood", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Building_Year_Built", "type": "esriFieldTypeDouble", "alias": "Building_Year_Built", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Building_Sqft", "type": "esriFieldTypeDouble", "alias": "Building_Sqft", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Acres", "type": "esriFieldTypeDouble", "alias": "Acres", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Front_Ft", "type": "esriFieldTypeDouble", "alias": "Land_Front_Ft", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Rear_Ft", "type": "esriFieldTypeDouble", "alias": "Land_Rear_Ft", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Lot_Depth", "type": "esriFieldTypeDouble", "alias": "Land_Lot_Depth", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Sqft", "type": "esriFieldTypeDouble", "alias": "Land_Sqft", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Market_Value", "type": "esriFieldTypeDouble", "alias": "Market_Value", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Extra1", "type": "esriFieldTypeDouble", "alias": "Extra1", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Extra2", "type": "esriFieldTypeString", "alias": "Extra2", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sale_Source", "type": "esriFieldTypeString", "alias": "Sale_Source", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Deed_Type", "type": "esriFieldTypeString", "alias": "Deed_Type", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Arms_Length", "type": "esriFieldTypeString", "alias": "Arms_Length", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Valid_Transaction", "type": "esriFieldTypeDouble", "alias": "Is_Valid_Transaction", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Confidential_Old", "type": "esriFieldTypeString", "alias": "Confidential_Old", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Confidential", "type": "esriFieldTypeDouble", "alias": "Is_Confidential", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sale_Id", "type": "esriFieldTypeDouble", "alias": "Sale_Id", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Hs", "type": "esriFieldTypeDouble", "alias": "Land_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Nhs", "type": "esriFieldTypeDouble", "alias": "Land_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Land_Hs", "type": "esriFieldTypeDouble", "alias": "New_Land_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Land_Nhs", "type": "esriFieldTypeDouble", "alias": "New_Land_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Productivity_Market", "type": "esriFieldTypeDouble", "alias": "Land_Productivity_Market", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_1d1", "type": "esriFieldTypeDouble", "alias": "Land_1d1", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_1d", "type": "esriFieldTypeDouble", "alias": "Land_1d", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Timber", "type": "esriFieldTypeDouble", "alias": "Land_Timber", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Personal_Hs", "type": "esriFieldTypeDouble", "alias": "Personal_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Personal_Nhs", "type": "esriFieldTypeDouble", "alias": "Personal_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Personal_Hs", "type": "esriFieldTypeDouble", "alias": "New_Personal_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Personal_Nhs", "type": "esriFieldTypeDouble", "alias": "New_Personal_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Improvement_Hs", "type": "esriFieldTypeDouble", "alias": "Improvement_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Improvement_Nhs", "type": "esriFieldTypeDouble", "alias": "Improvement_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Improvement_Hs", "type": "esriFieldTypeDouble", "alias": "New_Improvement_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Improvement_Nhs", "type": "esriFieldTypeDouble", "alias": "New_Improvement_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Improvement_Hs_Ceiling_Affe", "type": "esriFieldTypeDouble", "alias": "New_Improvement_Hs_Ceiling_Affected", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Income_Land", "type": "esriFieldTypeDouble", "alias": "Income_Land", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Income_Improvement", "type": "esriFieldTypeDouble", "alias": "Income_Improvement", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Income_New_Improvement", "type": "esriFieldTypeDouble", "alias": "Income_New_Improvement", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Use_Income_Value", "type": "esriFieldTypeDouble", "alias": "Use_Income_Value", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sales_Ratio", "type": "esriFieldTypeString", "alias": "Sales_Ratio", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Current_Ratio", "type": "esriFieldTypeString", "alias": "Current_Ratio", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Current_Value", "type": "esriFieldTypeDouble", "alias": "Current_Value", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Multi_Parcel_Current_Value", "type": "esriFieldTypeDouble", "alias": "Multi_Parcel_Current_Value", "domain": null } ], "geometryField": { "name": "ChambersCADWeb.DBO.TaxParcels.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R20_pk", "fields": "ChambersCADWeb.DBO.TaxParcels.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "Parcel_CAMAIndex", "fields": "ChambersCADWeb.DBO.TaxParcels.Parcel_CAMA", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S9_idx", "fields": "ChambersCADWeb.DBO.TaxParcels.SHAPE", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R54_SDE_ROWID_UK", "fields": "ChambersCADWeb.DBO.Sales.OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "9872b871aa254e6fa952ca706da0627e" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "1/1/2024-4/28/2025 Sales", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 103161, "latestWkid": 6588, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "classBreaks", "authoringInfo": { "type": "classedColor", "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 62, 161, 207, 255 ], "toColor": [ 241, 250, 122, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 241, 250, 122, 255 ], "toColor": [ 240, 36, 29, 255 ] } ] }, "classificationMethod": "esriClassifyManual" }, "field": "ChambersCADWeb.DBO.Sales.Adjusted_Price", "classificationMethod": "esriClassifyManual", "minValue": 0, "classBreakInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 40, 146, 199, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 0, "label": "0" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 129, 179, 171, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 100000, "label": "1 - 100,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 191, 212, 138, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 200000, "label": "100,001 - 200,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 250, 250, 100, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 400000, "label": "200,001 - 400,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 179, 68, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 500000, "label": "400,001 - 500,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 247, 110, 42, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 1200000, "label": "500,001 - 1,200,000" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 232, 21, 21, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "classMaxValue": 14546000, "label": "1,200,001 - 14,546,000" } ], "legendOptions": {"order": "ascendingValues"} }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": { "expression": "\"PID: \" + $feature['ChambersCADWeb.DBO.TaxParcels.Name'] +textformatting.newline+ \"Sale Date: \" + Text($feature['ChambersCADWeb.DBO.Sales.Sale_Date'], 'M/D/Y') +textformatting.newline+ \"Bld Sqft: \" + Text($feature['ChambersCADWeb.DBO.Sales.Building_Sqft'], '#,###') +textformatting.newline+ \"Sale: $\" + Text($feature['ChambersCADWeb.DBO.Sales.Adjusted_Price'], '#,###')+textformatting.newline+ \"Market Value: $\" + Text($feature['ChambersCADWeb.DBO.Sales.Market_Value'], '#,###') +textformatting.newline+\r\n\"Market Sales Ratio: \" + Round($feature['ChambersCADWeb.DBO.Sales.Market_Value']/$feature['ChambersCADWeb.DBO.Sales.Adjusted_Price'],4) +textformatting.newline+ \"Current Value: $\" + Text($feature['ChambersCADWeb.DBO.Sales.Land_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Land_Nhs'] +$feature['ChambersCADWeb.DBO.Sales.Land_1d1'] + $feature['ChambersCADWeb.DBO.Sales.Land_1d'] + $feature['ChambersCADWeb.DBO.Sales.Personal_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Personal_Nhs'] + $feature['ChambersCADWeb.DBO.Sales.New_Personal_Hs'] + $feature['ChambersCADWeb.DBO.Sales.New_Personal_Nhs'] + $feature['ChambersCADWeb.DBO.Sales.Improvement_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Improvement_Nhs']+$feature['ChambersCADWeb.DBO.Sales.New_Improvement_Hs']+$feature['ChambersCADWeb.DBO.Sales.New_Improvement_Nhs']+$feature['ChambersCADWeb.DBO.Sales.New_Land_Hs'], '#,###') + textformatting.newline+ \"Current Sales Ratio: \" + Round(($feature['ChambersCADWeb.DBO.Sales.Land_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Land_Nhs'] +$feature['ChambersCADWeb.DBO.Sales.Land_1d1'] + $feature['ChambersCADWeb.DBO.Sales.Land_1d'] + $feature['ChambersCADWeb.DBO.Sales.Personal_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Personal_Nhs'] + $feature['ChambersCADWeb.DBO.Sales.New_Personal_Hs'] + $feature['ChambersCADWeb.DBO.Sales.New_Personal_Nhs'] + $feature['ChambersCADWeb.DBO.Sales.Improvement_Hs'] + $feature['ChambersCADWeb.DBO.Sales.Improvement_Nhs']+$feature['ChambersCADWeb.DBO.Sales.New_Improvement_Hs']+$feature['ChambersCADWeb.DBO.Sales.New_Improvement_Nhs']+$feature['ChambersCADWeb.DBO.Sales.New_Land_Hs']) / $feature['ChambersCADWeb.DBO.Sales.Adjusted_Price'],4)", "title": "Custom" }, "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal", "multiPart": "labelLargest", "allowOverrun": false, "deconflictionStrategy": "dynamic", "repeatLabel": false, "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Default", "priority": 4, "symbol": { "type": "esriTS", "color": [ 56, 168, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "baseline", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 255 ], "haloSize": 2, "font": { "family": "Arial", "size": 12, "style": "italic", "weight": "bold", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": -1.0574900469827643E7, "ymin": 3440874.248603545, "xmax": -1.0501790951890342E7, "ymax": 3491693.6159381387, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ChambersCADWeb.DBO.TaxParcels.Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ChambersCADWeb.DBO.TaxParcels.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ChambersCADWeb.DBO.TaxParcels.Name", "type": "esriFieldTypeString", "alias": "Parcel Identification Number", "length": 50, "domain": null }, { "name": "ChambersCADWeb.DBO.TaxParcels.StatedArea", "type": "esriFieldTypeString", "alias": "Stated Area", "length": 50, "domain": null }, { "name": "ChambersCADWeb.DBO.TaxParcels.Parcel_CAMA", "type": "esriFieldTypeDouble", "alias": "Parcel_CAMA", "domain": null }, { "name": "ChambersCADWeb.DBO.TaxParcels.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Active", "type": "esriFieldTypeDouble", "alias": "Is_Active", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Parcel_Id", "type": "esriFieldTypeDouble", "alias": "Parcel_Id", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sequence", "type": "esriFieldTypeDouble", "alias": "Sequence", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Alternate_Sale_Id", "type": "esriFieldTypeDouble", "alias": "Alternate_Sale_Id", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Alternate_Parcel_Id", "type": "esriFieldTypeDouble", "alias": "Alternate_Parcel_Id", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Primary_Sale", "type": "esriFieldTypeDouble", "alias": "Is_Primary_Sale", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sale_Check", "type": "esriFieldTypeDouble", "alias": "Sale_Check", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Seller_Owner_Id", "type": "esriFieldTypeString", "alias": "Seller_Owner_Id", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Seller", "type": "esriFieldTypeString", "alias": "Seller", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Buyer_Owner_Id", "type": "esriFieldTypeString", "alias": "Buyer_Owner_Id", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Buyer", "type": "esriFieldTypeString", "alias": "Buyer", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sale_Date", "type": "esriFieldTypeDate", "alias": "Sale_Date", "length": 8, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Adjusted_Price", "type": "esriFieldTypeDouble", "alias": "Adjusted_Price", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Price", "type": "esriFieldTypeDouble", "alias": "Price", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Multi_Parcel_Sale", "type": "esriFieldTypeDouble", "alias": "Is_Multi_Parcel_Sale", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.User_Code1", "type": "esriFieldTypeString", "alias": "User_Code1", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.User_Code2", "type": "esriFieldTypeString", "alias": "User_Code2", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.File_Number", "type": "esriFieldTypeDouble", "alias": "File_Number", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Volume", "type": "esriFieldTypeDouble", "alias": "Volume", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Page", "type": "esriFieldTypeDouble", "alias": "Page", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Deed_Date", "type": "esriFieldTypeDate", "alias": "Deed_Date", "length": 8, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Neighborhood", "type": "esriFieldTypeString", "alias": "Neighborhood", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Building_Year_Built", "type": "esriFieldTypeDouble", "alias": "Building_Year_Built", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Building_Sqft", "type": "esriFieldTypeDouble", "alias": "Building_Sqft", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Acres", "type": "esriFieldTypeDouble", "alias": "Acres", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Front_Ft", "type": "esriFieldTypeDouble", "alias": "Land_Front_Ft", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Rear_Ft", "type": "esriFieldTypeDouble", "alias": "Land_Rear_Ft", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Lot_Depth", "type": "esriFieldTypeDouble", "alias": "Land_Lot_Depth", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Sqft", "type": "esriFieldTypeDouble", "alias": "Land_Sqft", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Market_Value", "type": "esriFieldTypeDouble", "alias": "Market_Value", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Extra1", "type": "esriFieldTypeDouble", "alias": "Extra1", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Extra2", "type": "esriFieldTypeString", "alias": "Extra2", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sale_Source", "type": "esriFieldTypeString", "alias": "Sale_Source", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Deed_Type", "type": "esriFieldTypeString", "alias": "Deed_Type", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Arms_Length", "type": "esriFieldTypeString", "alias": "Arms_Length", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Valid_Transaction", "type": "esriFieldTypeDouble", "alias": "Is_Valid_Transaction", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Confidential_Old", "type": "esriFieldTypeString", "alias": "Confidential_Old", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Is_Confidential", "type": "esriFieldTypeDouble", "alias": "Is_Confidential", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sale_Id", "type": "esriFieldTypeDouble", "alias": "Sale_Id", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Hs", "type": "esriFieldTypeDouble", "alias": "Land_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Nhs", "type": "esriFieldTypeDouble", "alias": "Land_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Land_Hs", "type": "esriFieldTypeDouble", "alias": "New_Land_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Land_Nhs", "type": "esriFieldTypeDouble", "alias": "New_Land_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Productivity_Market", "type": "esriFieldTypeDouble", "alias": "Land_Productivity_Market", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_1d1", "type": "esriFieldTypeDouble", "alias": "Land_1d1", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_1d", "type": "esriFieldTypeDouble", "alias": "Land_1d", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Land_Timber", "type": "esriFieldTypeDouble", "alias": "Land_Timber", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Personal_Hs", "type": "esriFieldTypeDouble", "alias": "Personal_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Personal_Nhs", "type": "esriFieldTypeDouble", "alias": "Personal_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Personal_Hs", "type": "esriFieldTypeDouble", "alias": "New_Personal_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Personal_Nhs", "type": "esriFieldTypeDouble", "alias": "New_Personal_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Improvement_Hs", "type": "esriFieldTypeDouble", "alias": "Improvement_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Improvement_Nhs", "type": "esriFieldTypeDouble", "alias": "Improvement_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Improvement_Hs", "type": "esriFieldTypeDouble", "alias": "New_Improvement_Hs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Improvement_Nhs", "type": "esriFieldTypeDouble", "alias": "New_Improvement_Nhs", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.New_Improvement_Hs_Ceiling_Affe", "type": "esriFieldTypeDouble", "alias": "New_Improvement_Hs_Ceiling_Affected", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Income_Land", "type": "esriFieldTypeDouble", "alias": "Income_Land", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Income_Improvement", "type": "esriFieldTypeDouble", "alias": "Income_Improvement", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Income_New_Improvement", "type": "esriFieldTypeDouble", "alias": "Income_New_Improvement", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Use_Income_Value", "type": "esriFieldTypeDouble", "alias": "Use_Income_Value", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Sales_Ratio", "type": "esriFieldTypeString", "alias": "Sales_Ratio", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Current_Ratio", "type": "esriFieldTypeString", "alias": "Current_Ratio", "length": 255, "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Current_Value", "type": "esriFieldTypeDouble", "alias": "Current_Value", "domain": null }, { "name": "ChambersCADWeb.DBO.Sales.Multi_Parcel_Current_Value", "type": "esriFieldTypeDouble", "alias": "Multi_Parcel_Current_Value", "domain": null } ], "geometryField": { "name": "ChambersCADWeb.DBO.TaxParcels.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R20_pk", "fields": "ChambersCADWeb.DBO.TaxParcels.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "Parcel_CAMAIndex", "fields": "ChambersCADWeb.DBO.TaxParcels.Parcel_CAMA", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S9_idx", "fields": "ChambersCADWeb.DBO.TaxParcels.SHAPE", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R54_SDE_ROWID_UK", "fields": "ChambersCADWeb.DBO.Sales.OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "9872b871aa254e6fa952ca706da0627e" } ], "tables": [] }