{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "2023 Sales", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkt2": "COMPOUNDCRS[\"\",PROJCRS[\"NAD_1983_UTM_Zone_14N\",BASEGEOGCRS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",ELLIPSOID[\"GRS_1980\",6378137.0,298.257222101,LENGTHUNIT[\"Meter\",1.0]]],PRIMEM[\"Greenwich\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],CS[ellipsoidal,2],ANGLEUNIT[\"Degree\",0.0174532925199433]],CONVERSION[\"Transverse_Mercator\",METHOD[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",1640416.666666667,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"False_Northing\",0.0,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"Central_Meridian\",-99.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Scale_Factor\",0.9996,SCALEUNIT[\"Unity\",1.0]],PARAMETER[\"Latitude_Of_Origin\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]]],CS[Cartesian,2],AXIS[\"Easting (X)\",east,ORDER[1]],AXIS[\"Northing (Y)\",north,ORDER[2]],LENGTHUNIT[\"Foot_US\",0.3048006096012192]],VERTCRS[\"NAVD_1988_Foot_US\",VDATUM[\"North_American_Vertical_Datum_1988\"],CS[vertical,1],AXIS[\"Gravity-related height (H)\",up,LENGTHUNIT[\"Foot_US\",0.3048006096012192]]]]", "wkt": "PROJCS[\"NAD_1983_UTM_Zone_14N\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-99.0],PARAMETER[\"Scale_Factor\",0.9996],PARAMETER[\"Latitude_Of_Origin\",0.0],UNIT[\"Foot_US\",0.3048006096012192]],VERTCS[\"NAVD_1988_Foot_US\",VDATUM[\"North_American_Vertical_Datum_1988\"],PARAMETER[\"Vertical_Shift\",0.0],PARAMETER[\"Direction\",1.0],UNIT[\"Foot_US\",0.3048006096012192]]", "xyTolerance": 0.003280833333333333, "zTolerance": 0.003280833333333333, "mTolerance": 0.001, "falseX": -16800800, "falseY": -32802000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988_Foot_US", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "DBO.GISSALESDATA.SALE_YEAR", "field2": "DBO.GISSALESDATA.PROPERTY_CLASS", "uniqueValueGroups": [ { "heading": "SALE_YEAR,PROPERTY_CLASS", "classes": [ { "label": "Residential, 2023", "description": "Residential, 2023", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 110, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "values": [ [ "2023", "05N" ], [ "2023", "06N" ], [ "2023", "24N" ], [ "2023", "25N" ] ] }, { "label": "Agricultural, 2023", "description": "Agricultural, 2023", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 255, 223, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "values": [ [ "2023", "05A" ], [ "2023", "20A" ], [ "2023", "21A" ], [ "2023", "24A" ], [ "2023", "25A" ], [ "2023", "08A" ] ] }, { "label": "Commercial, 2023", "description": "Commercial, 2023", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 185, 185, 185, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "values": [ [ "2023", "07N" ], [ "2023", "08N" ], [ "2023", "26N" ], [ "2023", "27N" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 110, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,05N", "label": "Residential, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 110, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,06N", "label": "Residential, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 110, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,24N", "label": "Residential, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 110, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,25N", "label": "Residential, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 255, 223, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,05A", "label": "Agricultural, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 255, 223, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,20A", "label": "Agricultural, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 255, 223, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,21A", "label": "Agricultural, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 255, 223, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,24A", "label": "Agricultural, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 255, 223, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,25A", "label": "Agricultural, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 255, 223, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,08A", "label": "Agricultural, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 185, 185, 185, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,07N", "label": "Commercial, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 185, 185, 185, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,08N", "label": "Commercial, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 185, 185, 185, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,26N", "label": "Commercial, 2023" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 185, 185, 185, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 167, 127, 255 ], "width": 0.4 } }, "value": "2023,27N", "label": "Commercial, 2023" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 248, 255 ], "toColor": [ 252, 210, 248, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 185, 252, 179, 255 ], "toColor": [ 185, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 223, 187, 255 ], "toColor": [ 252, 223, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 245, 252, 255 ], "toColor": [ 182, 245, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 196, 252, 255 ], "toColor": [ 179, 196, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 242, 252, 184, 255 ], "toColor": [ 242, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 197, 199, 255 ], "toColor": [ 252, 197, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 252, 221, 255 ], "toColor": [ 212, 252, 221, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 219, 182, 252, 255 ], "toColor": [ 219, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 224, 252, 255 ], "toColor": [ 215, 224, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 238, 255 ], "toColor": [ 252, 179, 238, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 247, 252, 212, 255 ], "toColor": [ 247, 252, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 226, 212, 255 ], "toColor": [ 252, 226, 212, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "\"$\" CONCAT [DBO.GISSALESDATA.SALE_PRICE] CONCAT NEWLINE CONCAT [DBO.Parcel.PID] CONCAT NEWLINE CONCAT [DBO.GISSALESDATA.SALE_DATE]", "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal", "removeDuplicates": "none", "multiPart": "labelPerPart", "deconflictionStrategy": "static", "repeatLabel": false, "allowOverrun": true, "stackLabel": false, "where": "DBO.Parcel.Location <> 'County'", "useCodedValues": true, "maxScale": 0, "minScale": 5000, "name": "Default", "priority": 1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "center", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 8, "style": "normal", "weight": "normal", "decoration": "none" } } }, { "labelExpression": "\"$\" CONCAT [DBO.GISSALESDATA.SALE_PRICE] CONCAT NEWLINE CONCAT [DBO.Parcel.PID] CONCAT NEWLINE CONCAT [DBO.GISSALESDATA.SALE_DATE]", "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal", "removeDuplicates": "all", "removeDuplicatesDistance": 0, "multiPart": "labelLargest", "deconflictionStrategy": "static", "repeatLabel": false, "allowOverrun": true, "stackLabel": false, "where": "DBO.Parcel.Location = 'County'", "useCodedValues": true, "maxScale": 5000, "minScale": 10000, "name": "Rural", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": false, "extent": { "xmin": 2185126.2180322446, "ymin": 1.565681040895699E7, "xmax": 2327527.83119433, "ymax": 1.5812114178401321E7, "spatialReference": { "wkt2": "COMPOUNDCRS[\"\",PROJCRS[\"NAD_1983_UTM_Zone_14N\",BASEGEOGCRS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",ELLIPSOID[\"GRS_1980\",6378137.0,298.257222101,LENGTHUNIT[\"Meter\",1.0]]],PRIMEM[\"Greenwich\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],CS[ellipsoidal,2],ANGLEUNIT[\"Degree\",0.0174532925199433]],CONVERSION[\"Transverse_Mercator\",METHOD[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",1640416.666666667,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"False_Northing\",0.0,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"Central_Meridian\",-99.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Scale_Factor\",0.9996,SCALEUNIT[\"Unity\",1.0]],PARAMETER[\"Latitude_Of_Origin\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]]],CS[Cartesian,2],AXIS[\"Easting (X)\",east,ORDER[1]],AXIS[\"Northing (Y)\",north,ORDER[2]],LENGTHUNIT[\"Foot_US\",0.3048006096012192]],VERTCRS[\"NAVD88_height_(ftUS)\",VDATUM[\"North_American_Vertical_Datum_1988\"],CS[vertical,1],AXIS[\"Gravity-related height (H)\",up,LENGTHUNIT[\"Foot_US\",0.3048006096012192]]]]", "wkt": "PROJCS[\"NAD_1983_UTM_Zone_14N\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-99.0],PARAMETER[\"Scale_Factor\",0.9996],PARAMETER[\"Latitude_Of_Origin\",0.0],UNIT[\"Foot_US\",0.3048006096012192]],VERTCS[\"NAVD88_height_(ftUS)\",VDATUM[\"North_American_Vertical_Datum_1988\"],PARAMETER[\"Vertical_Shift\",0.0],PARAMETER[\"Direction\",1.0],UNIT[\"Foot_US\",0.3048006096012192]]", "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -16800800, "falseY": -32802000, "xyUnits": 1.3729649495062786E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "DBO.Parcel.PID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "DBO.Parcel.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DBO.Parcel.PID", "type": "esriFieldTypeString", "alias": "PID", "length": 14, "domain": null }, { "name": "DBO.Parcel.Plat", "type": "esriFieldTypeString", "alias": "Plat", "length": 254, "domain": null }, { "name": "DBO.Parcel.SchoolDist", "type": "esriFieldTypeString", "alias": "SchoolDist", "length": 50, "domain": { "type": "codedValue", "name": "WS1_SchoolDist", "description": "School District name and number (Sioux Falls 49-5)", "codedValues": [ { "name": "Alcester-Hudson 61-1", "code": "61-1" }, { "name": "Beresford 61-2", "code": "61-2" }, { "name": "Canton 41-1", "code": "41-1" }, { "name": "Centerville 60-1", "code": "60-1" }, { "name": "Harrisburg 41-2", "code": "41-2" }, { "name": "Lennox 41-4", "code": "41-4" }, { "name": "Sioux Falls 49-5", "code": "49-5" }, { "name": "Tea 41-5", "code": "41-5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DBO.Parcel.Township", "type": "esriFieldTypeString", "alias": "Township", "length": 20, "domain": { "type": "codedValue", "name": "WS1_Township", "description": "The name of the township", "codedValues": [ { "name": "Brooklyn", "code": "Brooklyn" }, { "name": "Canton", "code": "Canton" }, { "name": "Dayton", "code": "Dayton" }, { "name": "Delapre", "code": "Delapre" }, { "name": "Delaware", "code": "Delaware" }, { "name": "Grant", "code": "Grant" }, { "name": "Highland", "code": "Highland" }, { "name": "LaValley", "code": "LaValley" }, { "name": "Lincoln", "code": "Lincoln" }, { "name": "Lynn", "code": "Lynn" }, { "name": "Norway", "code": "Norway" }, { "name": "Perry", "code": "Perry" }, { "name": "Pleasant", "code": "Pleasant" }, { "name": "Springdale", "code": "Springdale" }, { "name": "Fairview", "code": "Fairview" }, { "name": "Eden", "code": "Eden" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DBO.Parcel.STR", "type": "esriFieldTypeString", "alias": "STR", "length": 11, "domain": null }, { "name": "DBO.Parcel.Location", "type": "esriFieldTypeString", "alias": "Location", "length": 13, "domain": { "type": "codedValue", "name": "WS1_Location", "description": "All cities plus County", "codedValues": [ { "name": "Beresford", "code": "Beresford" }, { "name": "Canton", "code": "Canton" }, { "name": "County", "code": "County" }, { "name": "Fairview", "code": "Fairview" }, { "name": "Harrisburg", "code": "Harrisburg" }, { "name": "Hudson", "code": "Hudson" }, { "name": "Lennox", "code": "Lennox" }, { "name": "Sioux Falls", "code": "Sioux Falls" }, { "name": "Tea", "code": "Tea" }, { "name": "Worthing", "code": "Worthing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DBO.Parcel.Address", "type": "esriFieldTypeString", "alias": "Address", "length": 39, "domain": null }, { "name": "DBO.Parcel.PO_Zip", "type": "esriFieldTypeString", "alias": "PO_Zip", "length": 21, "domain": { "type": "codedValue", "name": "WS1_Post Office", "description": "Location", "codedValues": [ { "name": "Tea - 57064", "code": "57064" }, { "name": "Harrisburg - 57032", "code": "57032" }, { "name": "Lennox - 57039", "code": "57039" }, { "name": "Worthing - 57077", "code": "57077" }, { "name": "Canton - 57013", "code": "57013" }, { "name": "Fairview - 57027", "code": "57027" }, { "name": "Hudson - 57034", "code": "57034" }, { "name": "Beresford - 57004", "code": "57004" }, { "name": "Centerville - 57014", "code": "57014" }, { "name": "Alcester - 57001", "code": "57001" }, { "name": "Davis - 57021", "code": "57021" }, { "name": "Sioux Falls - 57108", "code": "57108" }, { "name": "Sioux Falls - 57106", "code": "57106" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DBO.Parcel.SubdivAuth", "type": "esriFieldTypeString", "alias": "SubdivAuth", "length": 21, "domain": null }, { "name": "DBO.Parcel.Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "length": 23, "domain": null }, { "name": "DBO.Parcel.LegalDesc", "type": "esriFieldTypeString", "alias": "LegalDesc", "length": 125, "domain": null }, { "name": "DBO.Parcel.SqFtCalc", "type": "esriFieldTypeDouble", "alias": "SqFtCalc", "domain": null }, { "name": "DBO.Parcel.AcreCalc", "type": "esriFieldTypeDouble", "alias": "AcreCalc", "domain": null }, { "name": "DBO.Parcel.AcreDiff", "type": "esriFieldTypeDouble", "alias": "AcreDiff", "domain": null }, { "name": "DBO.Parcel.Subdiv", "type": "esriFieldTypeString", "alias": "Subdiv", "length": 35, "domain": null }, { "name": "DBO.Parcel.SubNumber", "type": "esriFieldTypeString", "alias": "SubNumber", "length": 9, "domain": null }, { "name": "DBO.Parcel.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "DBO.Parcel.Lot", "type": "esriFieldTypeString", "alias": "Lot", "length": 4, "domain": null }, { "name": "DBO.Parcel.Block", "type": "esriFieldTypeString", "alias": "Block", "length": 4, "domain": null }, { "name": "DBO.Parcel.PIDalt", "type": "esriFieldTypeString", "alias": "PIDalt", "length": 14, "domain": null }, { "name": "DBO.Parcel.SqFtDiff", "type": "esriFieldTypeDouble", "alias": "SqFtDiff", "domain": null }, { "name": "DBO.Parcel.Calcs", "type": "esriFieldTypeDouble", "alias": "Calcs", "domain": null }, { "name": "DBO.Parcel.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "DBO.Parcel.MiscDeed", "type": "esriFieldTypeString", "alias": "MiscDeed", "length": 63, "domain": null }, { "name": "DBO.Parcel.Zoning_Auth", "type": "esriFieldTypeString", "alias": "Zoning Authority", "length": 50, "domain": null }, { "name": "DBO.Parcel.S", "type": "esriFieldTypeString", "alias": "S", "length": 2, "domain": null }, { "name": "DBO.Parcel.T", "type": "esriFieldTypeString", "alias": "T", "length": 3, "domain": null }, { "name": "DBO.Parcel.R", "type": "esriFieldTypeString", "alias": "R", "length": 2, "domain": null }, { "name": "DBO.Parcel.Tract", "type": "esriFieldTypeString", "alias": "Tract", "length": 4, "domain": null }, { "name": "DBO.Parcel.Incode", "type": "esriFieldTypeString", "alias": "Incode", "length": 14, "domain": null }, { "name": "DBO.GIS_Parcels.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "DBO.GIS_Parcels.Parcel_ID", "type": "esriFieldTypeString", "alias": "Parcel_ID", "length": 26, "domain": null }, { "name": "DBO.GIS_Parcels.District", "type": "esriFieldTypeString", "alias": "District", "length": 6, "domain": null }, { "name": "DBO.GIS_Parcels.Name", "type": "esriFieldTypeString", "alias": "Name", "length": 30, "domain": null }, { "name": "DBO.GIS_Parcels.Add1", "type": "esriFieldTypeString", "alias": "Add1", "length": 30, "domain": null }, { "name": "DBO.GIS_Parcels.Add2", "type": "esriFieldTypeString", "alias": "Add2", "length": 30, "domain": null }, { "name": "DBO.GIS_Parcels.Add3", "type": "esriFieldTypeString", "alias": "Add3", "length": 30, "domain": null }, { "name": "DBO.GIS_Parcels.Zip", "type": "esriFieldTypeInteger", "alias": "Zip", "domain": null }, { "name": "DBO.GIS_Parcels.ReAcres", "type": "esriFieldTypeDouble", "alias": "ReAcres", "domain": null }, { "name": "DBO.GIS_Parcels.ReInqAddre", "type": "esriFieldTypeString", "alias": "ReInqAddre", "length": 64, "domain": null }, { "name": "DBO.GIS_Parcels.ReInqAddre_1", "type": "esriFieldTypeString", "alias": "ReInqAddre_1", "length": 10, "domain": null }, { "name": "DBO.GIS_Parcels.SoilRating", "type": "esriFieldTypeString", "alias": "SoilRating", "length": 4, "domain": null }, { "name": "DBO.GIS_Parcels.Class1", "type": "esriFieldTypeString", "alias": "Class1", "length": 8, "domain": null }, { "name": "DBO.GIS_Parcels.Value1", "type": "esriFieldTypeInteger", "alias": "Value1", "domain": null }, { "name": "DBO.GIS_Parcels.Class2", "type": "esriFieldTypeString", "alias": "Class2", "length": 8, "domain": null }, { "name": "DBO.GIS_Parcels.Value12", "type": "esriFieldTypeInteger", "alias": "Value12", "domain": null }, { "name": "DBO.GIS_Parcels.Class3", "type": "esriFieldTypeString", "alias": "Class3", "length": 8, "domain": null }, { "name": "DBO.GIS_Parcels.Value13", "type": "esriFieldTypeInteger", "alias": "Value13", "domain": null }, { "name": "DBO.GIS_Parcels.Class4", "type": "esriFieldTypeString", "alias": "Class4", "length": 8, "domain": null }, { "name": "DBO.GIS_Parcels.Value14", "type": "esriFieldTypeInteger", "alias": "Value14", "domain": null }, { "name": "DBO.GIS_Parcels.Class5", "type": "esriFieldTypeString", "alias": "Class5", "length": 8, "domain": null }, { "name": "DBO.GIS_Parcels.Value15", "type": "esriFieldTypeInteger", "alias": "Value15", "domain": null }, { "name": "DBO.GIS_Parcels.Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 70, "domain": null }, { "name": "DBO.GIS_Parcels.STR", "type": "esriFieldTypeString", "alias": "STR", "length": 12, "domain": null }, { "name": "DBO.GIS_Parcels.Legal1", "type": "esriFieldTypeString", "alias": "Legal1", "length": 21, "domain": null }, { "name": "DBO.GIS_Parcels.Legal2", "type": "esriFieldTypeString", "alias": "Legal2", "length": 21, "domain": null }, { "name": "DBO.GIS_Parcels.Legal3", "type": "esriFieldTypeString", "alias": "Legal3", "length": 21, "domain": null }, { "name": "DBO.GIS_Parcels.Legal4", "type": "esriFieldTypeString", "alias": "Legal4", "length": 21, "domain": null }, { "name": "DBO.GIS_Parcels.REComments", "type": "esriFieldTypeString", "alias": "REComments", "length": 70, "domain": null }, { "name": "DBO.GIS_Parcels.RECommen_1", "type": "esriFieldTypeString", "alias": "RECommen_1", "length": 70, "domain": null }, { "name": "DBO.GIS_Parcels.RECommen_2", "type": "esriFieldTypeString", "alias": "RECommen_2", "length": 70, "domain": null }, { "name": "DBO.GIS_Parcels.RECommen_3", "type": "esriFieldTypeString", "alias": "RECommen_3", "length": 70, "domain": null }, { "name": "DBO.GIS_Parcels.RECommen_4", "type": "esriFieldTypeString", "alias": "RECommen_4", "length": 70, "domain": null }, { "name": "DBO.GIS_Parcels.TIFDIST", "type": "esriFieldTypeString", "alias": "TIFDIST", "length": 5, "domain": null }, { "name": "DBO.GIS_Parcels.SqFeet", "type": "esriFieldTypeDouble", "alias": "SqFeet", "domain": null }, { "name": "DBO.GISSALESDATA.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "DBO.GISSALESDATA.PARCEL", "type": "esriFieldTypeString", "alias": "PARCEL", "length": 26, "domain": null }, { "name": "DBO.GISSALESDATA.SALE_DATE", "type": "esriFieldTypeInteger", "alias": "SALE_DATE", "domain": null }, { "name": "DBO.GISSALESDATA.SALE_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "SALE_YEAR", "domain": null }, { "name": "DBO.GISSALESDATA.SEQUENCE", "type": "esriFieldTypeInteger", "alias": "SEQUENCE", "domain": null }, { "name": "DBO.GISSALESDATA.LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 25, "domain": null }, { "name": "DBO.GISSALESDATA.SUBLOCATION", "type": "esriFieldTypeString", "alias": "SUBLOCATION", "length": 25, "domain": null }, { "name": "DBO.GISSALESDATA.TAXING_DISTRICT", "type": "esriFieldTypeString", "alias": "TAXING_DISTRICT", "length": 6, "domain": null }, { "name": "DBO.GISSALESDATA.SCHOOL_DISTRICT", "type": "esriFieldTypeString", "alias": "SCHOOL_DISTRICT", "length": 4, "domain": null }, { "name": "DBO.GISSALESDATA.SECTION_", "type": "esriFieldTypeString", "alias": "SECTION_", "length": 3, "domain": null }, { "name": "DBO.GISSALESDATA.TOWNSHIP", "type": "esriFieldTypeString", "alias": "TOWNSHIP", "length": 4, "domain": null }, { "name": "DBO.GISSALESDATA.RANGE", "type": "esriFieldTypeString", "alias": "RANGE", "length": 3, "domain": null }, { "name": "DBO.GISSALESDATA.SELLERS_NAME", "type": "esriFieldTypeString", "alias": "SELLERS_NAME", "length": 30, "domain": null }, { "name": "DBO.GISSALESDATA.BUYERS_NAME", "type": "esriFieldTypeString", "alias": "BUYERS_NAME", "length": 30, "domain": null }, { "name": "DBO.GISSALESDATA.RECORD_NUMBER", "type": "esriFieldTypeString", "alias": "RECORD_NUMBER", "length": 25, "domain": null }, { "name": "DBO.GISSALESDATA.INSTRUMENT_TYPE", "type": "esriFieldTypeString", "alias": "INSTRUMENT_TYPE", "length": 1, "domain": null }, { "name": "DBO.GISSALESDATA.BOOK", "type": "esriFieldTypeString", "alias": "BOOK", "length": 5, "domain": null }, { "name": "DBO.GISSALESDATA.PAGE", "type": "esriFieldTypeString", "alias": "PAGE", "length": 5, "domain": null }, { "name": "DBO.GISSALESDATA.SALE_TYPE", "type": "esriFieldTypeSmallInteger", "alias": "SALE_TYPE", "domain": null }, { "name": "DBO.GISSALESDATA.SALE_PRICE", "type": "esriFieldTypeInteger", "alias": "SALE_PRICE", "domain": null }, { "name": "DBO.GISSALESDATA.TRANSFER_FEE", "type": "esriFieldTypeDouble", "alias": "TRANSFER_FEE", "domain": null }, { "name": "DBO.GISSALESDATA.REJECT_CODE", "type": "esriFieldTypeString", "alias": "REJECT_CODE", "length": 1, "domain": null }, { "name": "DBO.GISSALESDATA.PROPERTY_CLASS", "type": "esriFieldTypeString", "alias": "PROPERTY_CLASS", "length": 3, "domain": null }, { "name": "DBO.GISSALESDATA.ASSESSED_LAND_VALUE", "type": "esriFieldTypeInteger", "alias": "ASSESSED_LAND_VALUE", "domain": null }, { "name": "DBO.GISSALESDATA.ASSESSED_BLDG_VALUE", "type": "esriFieldTypeInteger", "alias": "ASSESSED_BLDG_VALUE", "domain": null }, { "name": "DBO.GISSALESDATA.ACRES", "type": "esriFieldTypeSingle", "alias": "ACRES", "domain": null }, { "name": "DBO.GISSALESDATA.LEGAL_DESCRIPTION", "type": "esriFieldTypeString", "alias": "LEGAL_DESCRIPTION", "length": 21, "domain": null }, { "name": "DBO.GISSALESDATA.COMMENT1", "type": "esriFieldTypeString", "alias": "COMMENT1", "length": 70, "domain": null }, { "name": "DBO.GISSALESDATA.COMMENT2", "type": "esriFieldTypeString", "alias": "COMMENT2", "length": 70, "domain": null }, { "name": "DBO.GISSALESDATA.YEAR_BUILT", "type": "esriFieldTypeSmallInteger", "alias": "YEAR_BUILT", "domain": null }, { "name": "DBO.GISSALESDATA.BASEMENT", "type": "esriFieldTypeString", "alias": "BASEMENT", "length": 6, "domain": null }, { "name": "DBO.GISSALESDATA.SQUARE_FEET", "type": "esriFieldTypeString", "alias": "SQUARE_FEET", "length": 9, "domain": null }, { "name": "DBO.GISSALESDATA.ACERE_LOT_SIZE", "type": "esriFieldTypeString", "alias": "ACERE_LOT_SIZE", "length": 20, "domain": null }, { "name": "DBO.GISSALESDATA.CONSTRUCTION", "type": "esriFieldTypeString", "alias": "CONSTRUCTION", "length": 15, "domain": null }, { "name": "DBO.GISSALESDATA.A_C", "type": "esriFieldTypeString", "alias": "A_C", "length": 1, "domain": null }, { "name": "DBO.GISSALESDATA.BEDROOMS", "type": "esriFieldTypeString", "alias": "BEDROOMS", "length": 4, "domain": null }, { "name": "DBO.GISSALESDATA.FIREPLACE", "type": "esriFieldTypeString", "alias": "FIREPLACE", "length": 4, "domain": null }, { "name": "DBO.GISSALESDATA.BATH", "type": "esriFieldTypeString", "alias": "BATH", "length": 6, "domain": null }, { "name": "DBO.GISSALESDATA.GARAGE_CODE", "type": "esriFieldTypeString", "alias": "GARAGE_CODE", "length": 2, "domain": null }, { "name": "DBO.GISSALESDATA.GARAGE_SIZE", "type": "esriFieldTypeString", "alias": "GARAGE_SIZE", "length": 2, "domain": null }, { "name": "DBO.GISSALESDATA.GRADE", "type": "esriFieldTypeString", "alias": "GRADE", "length": 6, "domain": null }, { "name": "DBO.GISSALESDATA.SALES_RATIO", "type": "esriFieldTypeSingle", "alias": "SALES_RATIO", "domain": null }, { "name": "DBO.GISSALESDATA.NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 30, "domain": null }, { "name": "DBO.GISSALESDATA.ADDRESS_1", "type": "esriFieldTypeString", "alias": "ADDRESS_1", "length": 30, "domain": null }, { "name": "DBO.GISSALESDATA.ADDRESS_2", "type": "esriFieldTypeString", "alias": "ADDRESS_2", "length": 30, "domain": null }, { "name": "DBO.GISSALESDATA.ADDRESS_3", "type": "esriFieldTypeString", "alias": "ADDRESS_3", "length": 30, "domain": null }, { "name": "DBO.GISSALESDATA.ZIP_CODE", "type": "esriFieldTypeInteger", "alias": "ZIP_CODE", "domain": null }, { "name": "DBO.GISSALESDATA.SITE_HOUSE", "type": "esriFieldTypeString", "alias": "SITE_HOUSE", "length": 10, "domain": null }, { "name": "DBO.GISSALESDATA.SITE_PREDIRECTION", "type": "esriFieldTypeString", "alias": "SITE_PREDIRECTION", "length": 2, "domain": null }, { "name": "DBO.GISSALESDATA.SITE_STREET", "type": "esriFieldTypeString", "alias": "SITE_STREET", "length": 28, "domain": null }, { "name": "DBO.GISSALESDATA.SITE_SUFFIX", "type": "esriFieldTypeString", "alias": "SITE_SUFFIX", "length": 4, "domain": null }, { "name": "DBO.GISSALESDATA.SITE_DIRECTION", "type": "esriFieldTypeString", "alias": "SITE_DIRECTION", "length": 2, "domain": null }, { "name": "DBO.GISSALESDATA.SITE_UNIT_DESC", "type": "esriFieldTypeString", "alias": "SITE_UNIT_DESC", "length": 4, "domain": null }, { "name": "DBO.GISSALESDATA.SITE_UNIT", "type": "esriFieldTypeString", "alias": "SITE_UNIT", "length": 8, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "DBO.Parcel.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R141_pk", "fields": "DBO.Parcel.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_141", "fields": "DBO.Parcel.GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_141", "fields": "DBO.Parcel.GlobalID,DBO.Parcel.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S135_idx", "fields": "DBO.Parcel.Shape", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R370_SDE_ROWID_UK", "fields": "DBO.GIS_Parcels.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R347_SDE_ROWID_UK", "fields": "DBO.GISSALESDATA.OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }