{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "taxlot", "role": "esriRelRoleDestination", "composite": false, "name": "General Information", "relatedTableId": 0, "id": 7, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_ASSESSOR_ACCOUNT", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "zip": null, "address": null, "city": null, "taxlot": " ", "percent_good": null, "house_number": null, "street_name": null, "sa": null, "lot": null, "subdivision": null, "ugb": null, "unit_number": null, "subdiv_code": null, "ma": null, "legallot": null, "street_type": null, "block": null, "nh": null, "state": null, "firepatrol": null, "direction": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_ASSESSOR_ACCOUNT", "displayField": "street_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "taxlot", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "taxlot", "length": 20, "alias": "TaxLot", "type": "esriFieldTypeString" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 100, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "house_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "house_number", "length": 10, "alias": "House_Number", "type": "esriFieldTypeString" }, { "modelName": "direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direction", "length": 10, "alias": "Direction", "type": "esriFieldTypeString" }, { "modelName": "street_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "street_name", "length": 30, "alias": "Street_Name", "type": "esriFieldTypeString" }, { "modelName": "street_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "street_type", "length": 30, "alias": "Street_Type", "type": "esriFieldTypeString" }, { "modelName": "unit_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit_number", "length": 30, "alias": "Unit_Number", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 30, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 30, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 15, "alias": "Zip", "type": "esriFieldTypeString" }, { "modelName": "subdiv_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subdiv_code", "length": 15, "alias": "Subdiv_Code", "type": "esriFieldTypeString" }, { "modelName": "subdivision", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subdivision", "length": 150, "alias": "Subdivision", "type": "esriFieldTypeString" }, { "modelName": "block", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "block", "length": 15, "alias": "Block", "type": "esriFieldTypeString" }, { "modelName": "lot", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lot", "length": 20, "alias": "Lot", "type": "esriFieldTypeString" }, { "modelName": "ma", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ma", "length": 5, "alias": "MA", "type": "esriFieldTypeString" }, { "modelName": "sa", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sa", "length": 5, "alias": "SA", "type": "esriFieldTypeString" }, { "modelName": "percent_good", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percent_good", "length": 5, "alias": "Percent_Good", "type": "esriFieldTypeString" }, { "modelName": "legallot", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legallot", "length": 5, "alias": "LegalLot", "type": "esriFieldTypeString" }, { "modelName": "ugb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ugb", "length": 10, "alias": "UGB", "type": "esriFieldTypeString" }, { "modelName": "firepatrol", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firepatrol", "length": 10, "alias": "FirePatrol", "type": "esriFieldTypeString" }, { "modelName": "nh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nh", "length": 5, "alias": "NH", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g244359taxlot", "isUnique": false, "description": "", "fields": "taxlot", "isAscending": true }, { "name": "r109707_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "taxlot", "role": "esriRelRoleDestination", "composite": false, "name": "Serial Number", "relatedTableId": 0, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_DEADNUMBERS", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "account_id": null, "year": null, "taxlot": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_DEADNUMBERS", "displayField": "taxlot", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "taxlot", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "taxlot", "length": 15, "alias": "taxlot", "type": "esriFieldTypeString" }, { "modelName": "year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year", "alias": "year", "type": "esriFieldTypeInteger" }, { "modelName": "account_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "account_id", "alias": "account_id", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g244360taxlot", "isUnique": false, "description": "", "fields": "taxlot", "isAscending": true }, { "name": "r109708_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "taxlot", "role": "esriRelRoleDestination", "composite": false, "name": "Improvement", "relatedTableId": 0, "id": 6, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_IMPROVEMENTS", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "taxlot": " ", "total_sqft_2": null, "stat_class_1": null, "property_class": null, "total_sqft_1": null, "outcode_1_3_description": null, "garage_sqft_2": null, "outcode_1_2_description": null, "garage_sqft_1": null, "land_size_acres": null, "outcode_1_1_description": null, "impr_id_2": null, "impr_id_1": null, "outcode_1_1": null, "stat_class_desc_2": null, "stat_class_desc_1": null, "outcode_1_2": null, "outcode_2_1": null, "outcode_1_3": null, "outcode_2_2": null, "outcode_2_3": null, "bathrooms": null, "year_appr": null, "bedrooms": null, "outcode_2_3_description": null, "stat_class_2": null, "outcode_2_2_description": null, "outcode_2_1_description": null, "year_built_1": null, "year_built_2": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_IMPROVEMENTS", "displayField": "taxlot", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "taxlot", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "taxlot", "length": 20, "alias": "Taxlot", "type": "esriFieldTypeString" }, { "modelName": "land_size_acres", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "land_size_acres", "alias": "Land_Size_Acres", "type": "esriFieldTypeDouble" }, { "modelName": "year_appr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_appr", "length": 4, "alias": "Year_Appr", "type": "esriFieldTypeString" }, { "modelName": "property_class", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_class", "length": 6, "alias": "Property_Class", "type": "esriFieldTypeString" }, { "modelName": "impr_id_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "impr_id_1", "alias": "impr_ID_1", "type": "esriFieldTypeInteger" }, { "modelName": "stat_class_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stat_class_1", "length": 3, "alias": "Stat_Class_1", "type": "esriFieldTypeString" }, { "modelName": "stat_class_desc_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stat_class_desc_1", "length": 250, "alias": "Stat_Class_Desc_1", "type": "esriFieldTypeString" }, { "modelName": "total_sqft_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_sqft_1", "alias": "Total_Sqft_1", "type": "esriFieldTypeInteger" }, { "modelName": "year_built_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_built_1", "length": 4, "alias": "Year_Built_1", "type": "esriFieldTypeString" }, { "modelName": "garage_sqft_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "garage_sqft_1", "alias": "Garage_Sqft_1", "type": "esriFieldTypeInteger" }, { "modelName": "impr_id_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "impr_id_2", "alias": "impr_ID_2", "type": "esriFieldTypeInteger" }, { "modelName": "stat_class_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stat_class_2", "length": 3, "alias": "Stat_Class_2", "type": "esriFieldTypeString" }, { "modelName": "stat_class_desc_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stat_class_desc_2", "length": 250, "alias": "Stat_Class_Desc_2", "type": "esriFieldTypeString" }, { "modelName": "total_sqft_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_sqft_2", "alias": "Total_Sqft_2", "type": "esriFieldTypeInteger" }, { "modelName": "year_built_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_built_2", "length": 4, "alias": "Year_Built_2", "type": "esriFieldTypeString" }, { "modelName": "garage_sqft_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "garage_sqft_2", "alias": "Garage_Sqft_2", "type": "esriFieldTypeInteger" }, { "modelName": "outcode_1_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_1_1", "length": 4, "alias": "Outcode_1_1", "type": "esriFieldTypeString" }, { "modelName": "outcode_1_1_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_1_1_description", "length": 30, "alias": "Outcode_1_1_Description", "type": "esriFieldTypeString" }, { "modelName": "outcode_1_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_1_2", "length": 4, "alias": "Outcode_1_2", "type": "esriFieldTypeString" }, { "modelName": "outcode_1_2_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_1_2_description", "length": 30, "alias": "Outcode_1_2_Description", "type": "esriFieldTypeString" }, { "modelName": "outcode_1_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_1_3", "length": 4, "alias": "Outcode_1_3", "type": "esriFieldTypeString" }, { "modelName": "outcode_1_3_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_1_3_description", "length": 30, "alias": "Outcode_1_3_Description", "type": "esriFieldTypeString" }, { "modelName": "outcode_2_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_2_1", "length": 4, "alias": "Outcode_2_1", "type": "esriFieldTypeString" }, { "modelName": "outcode_2_1_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_2_1_description", "length": 30, "alias": "Outcode_2_1_Description", "type": "esriFieldTypeString" }, { "modelName": "outcode_2_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_2_2", "length": 4, "alias": "Outcode_2_2", "type": "esriFieldTypeString" }, { "modelName": "outcode_2_2_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_2_2_description", "length": 30, "alias": "Outcode_2_2_Description", "type": "esriFieldTypeString" }, { "modelName": "outcode_2_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_2_3", "length": 4, "alias": "Outcode_2_3", "type": "esriFieldTypeString" }, { "modelName": "outcode_2_3_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcode_2_3_description", "length": 30, "alias": "Outcode_2_3_Description", "type": "esriFieldTypeString" }, { "modelName": "bedrooms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bedrooms", "alias": "Bedrooms", "type": "esriFieldTypeDouble" }, { "modelName": "bathrooms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bathrooms", "alias": "Bathrooms", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g244361taxlot", "isUnique": false, "description": "", "fields": "taxlot", "isAscending": true }, { "name": "r109709_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "map_taxlot", "role": "esriRelRoleDestination", "composite": false, "name": "Mailing Address", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_MAILING", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "owner": null, "in_care_of": null, "m_state": null, "map_taxlot": " ", "agent": null, "m_zip": null, "account_id": " ", "m_city": null, "m_address": null, "m_citystzip": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_MAILING", "displayField": "map_taxlot", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "map_taxlot", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "map_taxlot", "length": 15, "alias": "MAP_TAXLOT", "type": "esriFieldTypeString" }, { "modelName": "account_id", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "account_id", "length": 10, "alias": "ACCOUNT_ID", "type": "esriFieldTypeString" }, { "modelName": "owner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner", "length": 50, "alias": "OWNER", "type": "esriFieldTypeString" }, { "modelName": "agent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "agent", "length": 50, "alias": "AGENT", "type": "esriFieldTypeString" }, { "modelName": "in_care_of", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "in_care_of", "length": 50, "alias": "IN_CARE_OF", "type": "esriFieldTypeString" }, { "modelName": "m_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "m_address", "length": 50, "alias": "M_ADDRESS", "type": "esriFieldTypeString" }, { "modelName": "m_citystzip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "m_citystzip", "length": 50, "alias": "M_CITYSTZIP", "type": "esriFieldTypeString" }, { "modelName": "m_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "m_city", "length": 50, "alias": "M_CITY", "type": "esriFieldTypeString" }, { "modelName": "m_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "m_state", "length": 50, "alias": "M_STATE", "type": "esriFieldTypeString" }, { "modelName": "m_zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "m_zip", "length": 50, "alias": "M_ZIP", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g244363map_taxlo", "isUnique": false, "description": "", "fields": "map_taxlot", "isAscending": true }, { "name": "r109711_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "map_taxlot", "role": "esriRelRoleDestination", "composite": false, "name": "Owns", "relatedTableId": 0, "id": 5, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_OWNERS", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "map_taxlot": null, "name_type": null, "ownership_type": null, "name": null, "s_i_type": null, "s_i_number": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_OWNERS", "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "map_taxlot", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "map_taxlot", "length": 50, "alias": "MAP_TAXLOT", "type": "esriFieldTypeString" }, { "modelName": "name_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name_type", "length": 50, "alias": "NAME_TYPE", "type": "esriFieldTypeString" }, { "modelName": "name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 250, "alias": "NAME", "type": "esriFieldTypeString" }, { "modelName": "ownership_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownership_type", "length": 50, "alias": "OWNERSHIP_TYPE", "type": "esriFieldTypeString" }, { "modelName": "s_i_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "s_i_type", "length": 50, "alias": "S_I_TYPE", "type": "esriFieldTypeString" }, { "modelName": "s_i_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "s_i_number", "length": 50, "alias": "S_I_NUMBER", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g244364map_taxlo", "isUnique": false, "description": "", "fields": "map_taxlot", "isAscending": true }, { "name": "r109712_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "taxlot", "role": "esriRelRoleDestination", "composite": false, "name": "Stat Class or Property Class", "relatedTableId": 0, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_PCSTAT", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "total_sqft": null, "taxlot": " ", "stat_class": null, "year_built": null, "property_class": null, "stat_class_desc": null, "uniqueid": " ", "rmv_impr": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_PCSTAT", "displayField": "uniqueid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "uniqueid", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 350, "alias": "UniqueID", "type": "esriFieldTypeString" }, { "modelName": "taxlot", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "taxlot", "length": 50, "alias": "TAXLOT", "type": "esriFieldTypeString" }, { "modelName": "property_class", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_class", "length": 50, "alias": "PROPERTY_CLASS", "type": "esriFieldTypeString" }, { "modelName": "stat_class", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stat_class", "length": 50, "alias": "STAT_CLASS", "type": "esriFieldTypeString" }, { "modelName": "stat_class_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stat_class_desc", "length": 250, "alias": "STAT_CLASS_DESC", "type": "esriFieldTypeString" }, { "modelName": "year_built", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_built", "length": 50, "alias": "YEAR_BUILT", "type": "esriFieldTypeString" }, { "modelName": "total_sqft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_sqft", "length": 50, "alias": "TOTAL_SQFT", "type": "esriFieldTypeString" }, { "modelName": "rmv_impr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rmv_impr", "alias": "RMV_IMPR", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g244362taxlot", "isUnique": false, "description": "", "fields": "taxlot", "isAscending": true }, { "name": "r109710_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "taxlot", "role": "esriRelRoleDestination", "composite": false, "name": "Roll Values", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_ROLLVALUES", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "taxlot": " ", "rmv_land": null, "rmv_total": null, "av_total": null, "rmv_impr": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_ROLLVALUES", "displayField": "taxlot", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "taxlot", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "taxlot", "length": 20, "alias": "Taxlot", "type": "esriFieldTypeString" }, { "modelName": "rmv_land", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rmv_land", "alias": "RMV_Land", "type": "esriFieldTypeDouble" }, { "modelName": "rmv_impr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rmv_impr", "alias": "RMV_Impr", "type": "esriFieldTypeDouble" }, { "modelName": "rmv_total", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rmv_total", "alias": "RMV_Total", "type": "esriFieldTypeDouble" }, { "modelName": "av_total", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "av_total", "alias": "AV_Total", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g244365taxlot", "isUnique": false, "description": "", "fields": "taxlot", "isAscending": true }, { "name": "r109713_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_SALES", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "reject_code_2": null, "buyer_2": null, "taxlot": " ", "buyer_1": null, "sales_date_1": null, "sales_date_2": null, "reject_description_2": null, "book_page_1": null, "reject_description_1": null, "total_sales_price_1": null, "total_sales_price_2": null, "seller_1": null, "seller_2": null, "reject_code_1": null, "book_page_2": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_SALES", "displayField": "taxlot", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "taxlot", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "taxlot", "length": 20, "alias": "Taxlot", "type": "esriFieldTypeString" }, { "modelName": "book_page_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "book_page_1", "length": 20, "alias": "Book_Page_1", "type": "esriFieldTypeString" }, { "modelName": "reject_code_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reject_code_1", "length": 3, "alias": "Reject_Code_1", "type": "esriFieldTypeString" }, { "modelName": "reject_description_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reject_description_1", "length": 100, "alias": "Reject_Description_1", "type": "esriFieldTypeString" }, { "modelName": "total_sales_price_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_sales_price_1", "alias": "Total_Sales_Price_1", "type": "esriFieldTypeDouble" }, { "modelName": "sales_date_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sales_date_1", "length": 29, "alias": "Sales_Date_1", "type": "esriFieldTypeDate" }, { "modelName": "seller_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "seller_1", "length": 250, "alias": "Seller_1", "type": "esriFieldTypeString" }, { "modelName": "buyer_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "buyer_1", "length": 250, "alias": "Buyer_1", "type": "esriFieldTypeString" }, { "modelName": "book_page_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "book_page_2", "length": 20, "alias": "Book_Page_2", "type": "esriFieldTypeString" }, { "modelName": "reject_code_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reject_code_2", "length": 3, "alias": "Reject_Code_2", "type": "esriFieldTypeString" }, { "modelName": "reject_description_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reject_description_2", "length": 100, "alias": "Reject_Description_2", "type": "esriFieldTypeString" }, { "modelName": "total_sales_price_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_sales_price_2", "alias": "Total_Sales_Price_2", "type": "esriFieldTypeDouble" }, { "modelName": "sales_date_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sales_date_2", "length": 29, "alias": "Sales_Date_2", "type": "esriFieldTypeDate" }, { "modelName": "seller_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "seller_2", "length": 250, "alias": "Seller_2", "type": "esriFieldTypeString" }, { "modelName": "buyer_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "buyer_2", "length": 250, "alias": "Buyer_2", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r109714_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "taxlot", "role": "esriRelRoleDestination", "composite": false, "name": "Serial Number", "relatedTableId": 0, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 9, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "GIS_SERIALXREF", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "account_id": 0, "taxlot": " ", "account_status": " " } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "GIS_SERIALXREF", "displayField": "taxlot", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "taxlot", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "taxlot", "length": 15, "alias": "taxlot", "type": "esriFieldTypeString" }, { "modelName": "account_id", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "account_id", "alias": "account_id", "type": "esriFieldTypeDouble" }, { "modelName": "account_status", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "account_status", "length": 1, "alias": "account_status", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g244367taxlot", "isUnique": false, "description": "", "fields": "taxlot", "isAscending": true }, { "name": "r109715_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 5405456.468099996, "xmin": -1.35811156965E7, "ymax": 5526538.506999999, "xmax": -1.3346827759100001E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "taxlot", "role": "esriRelRoleOrigin", "composite": false, "name": "Has Mailing Address of", "relatedTableId": 4, "id": 0, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "taxlot", "role": "esriRelRoleOrigin", "composite": false, "name": "Has Roll Values of", "relatedTableId": 7, "id": 1, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "taxlot", "role": "esriRelRoleOrigin", "composite": false, "name": "Contains Serial Numbers", "relatedTableId": 9, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "taxlot", "role": "esriRelRoleOrigin", "composite": false, "name": "Contains Serial Numbers", "relatedTableId": 2, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "taxlot", "role": "esriRelRoleOrigin", "composite": false, "name": "Has Stat Class or Property Class of", "relatedTableId": 6, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "taxlot", "role": "esriRelRoleOrigin", "composite": false, "name": "Is Owned by", "relatedTableId": 5, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "taxlot", "role": "esriRelRoleOrigin", "composite": false, "name": "Has Improvement", "relatedTableId": 3, "id": 6, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "taxlot", "role": "esriRelRoleOrigin", "composite": false, "name": "General Information for", "relatedTableId": 1, "id": 7, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Taxlot", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "parcel": null, "sixteenth": null, "taxlot": null, "range": null, "mapsup": null, "section": null, "mapnumber": null, "township": null, "dial": null, "quarter": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Taxlot", "allowTrueCurvesUpdates": false, "displayField": "taxlot", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "TAXLOT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "taxlot", "length": 13, "alias": "TAXLOT", "type": "esriFieldTypeString" }, { "modelName": "TOWNSHIP", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "township", "length": 2, "alias": "TOWNSHIP", "type": "esriFieldTypeString" }, { "modelName": "RANGE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "range", "length": 2, "alias": "RANGE", "type": "esriFieldTypeString" }, { "modelName": "SECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "section", "length": 2, "alias": "SECTION", "type": "esriFieldTypeString" }, { "modelName": "QUARTER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "quarter", "length": 1, "alias": "QUARTER", "type": "esriFieldTypeString" }, { "modelName": "SIXTEENTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sixteenth", "length": 1, "alias": "SIXTEENTH", "type": "esriFieldTypeString" }, { "modelName": "PARCEL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcel", "length": 5, "alias": "PARCEL", "type": "esriFieldTypeString" }, { "modelName": "MAPSUP", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mapsup", "length": 5, "alias": "MAPSUP", "type": "esriFieldTypeString" }, { "modelName": "MAPNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mapnumber", "length": 20, "alias": "MAPNUMBER", "type": "esriFieldTypeString" }, { "modelName": "dial", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dial", "length": 65, "alias": "DIAL", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "The taxlot layer contains all parcels in Deschutes County, as found on the county Assessor's Maps. The taxlot layer is the basis for many other layers; that is, other layers were built using the taxlot layer as the location control.", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "i244369taxlot", "isUnique": false, "description": "", "fields": "taxlot", "isAscending": true }, { "name": "a94682_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 1155581.108577, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8d0b7b050ada480884dcf78fed23d969", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": false, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 190, 255 ], "width": 0.4, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 0, 0, 0, 0 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "Shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "Deschutes County - Assessor's Office", "zDefault": 0, "geometryType": "esriGeometryPolygon" } ] }