{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 40, "name": "VisionExtract", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "street_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PID", "type": "esriFieldTypeInteger", "alias": "PID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "PID" }, { "name": "tax_map_number", "type": "esriFieldTypeString", "alias": "tax_map_number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "tax_map_number" }, { "name": "street_number", "type": "esriFieldTypeString", "alias": "street_number", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "street_number" }, { "name": "street_suffix", "type": "esriFieldTypeString", "alias": "street_suffix", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "street_suffix" }, { "name": "street_name", "type": "esriFieldTypeString", "alias": "street_name", "domain": null, "editable": true, "nullable": true, "length": 46, "defaultValue": null, "modelName": "street_name" }, { "name": "zip_code", "type": "esriFieldTypeString", "alias": "zip_code", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "zip_code" }, { "name": "year_built", "type": "esriFieldTypeString", "alias": "year_built", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "year_built" }, { "name": "residential", "type": "esriFieldTypeString", "alias": "residential", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "residential" }, { "name": "commercial", "type": "esriFieldTypeString", "alias": "commercial", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "commercial" }, { "name": "property_desc", "type": "esriFieldTypeString", "alias": "property_desc", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "property_desc" }, { "name": "stories", "type": "esriFieldTypeString", "alias": "stories", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "stories" }, { "name": "rooms", "type": "esriFieldTypeString", "alias": "rooms", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "rooms" }, { "name": "bedrooms", "type": "esriFieldTypeString", "alias": "bedrooms", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "bedrooms" }, { "name": "baths", "type": "esriFieldTypeString", "alias": "baths", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "baths" }, { "name": "fireplaces", "type": "esriFieldTypeString", "alias": "fireplaces", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "fireplaces" }, { "name": "split_level", "type": "esriFieldTypeString", "alias": "split_level", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "split_level" }, { "name": "split_foyer", "type": "esriFieldTypeString", "alias": "split_foyer", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "split_foyer" }, { "name": "central_heat", "type": "esriFieldTypeString", "alias": "central_heat", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "central_heat" }, { "name": "central_air", "type": "esriFieldTypeString", "alias": "central_air", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "central_air" }, { "name": "type_of_roof", "type": "esriFieldTypeString", "alias": "type_of_roof", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "type_of_roof" }, { "name": "type_of_exterior", "type": "esriFieldTypeString", "alias": "type_of_exterior", "domain": null, "editable": true, "nullable": true, "length": 122, "defaultValue": null, "modelName": "type_of_exterior" }, { "name": "type_of_basement", "type": "esriFieldTypeString", "alias": "type_of_basement", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "type_of_basement" }, { "name": "type_of_floors", "type": "esriFieldTypeString", "alias": "type_of_floors", "domain": null, "editable": true, "nullable": true, "length": 122, "defaultValue": null, "modelName": "type_of_floors" }, { "name": "type_of_walls", "type": "esriFieldTypeString", "alias": "type_of_walls", "domain": null, "editable": true, "nullable": true, "length": 81, "defaultValue": null, "modelName": "type_of_walls" }, { "name": "type_of_heat", "type": "esriFieldTypeString", "alias": "type_of_heat", "domain": null, "editable": true, "nullable": true, "length": 81, "defaultValue": null, "modelName": "type_of_heat" }, { "name": "class_code", "type": "esriFieldTypeString", "alias": "class_code", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "class_code" }, { "name": "zoning", "type": "esriFieldTypeString", "alias": "zoning", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "zoning" }, { "name": "neighborhood", "type": "esriFieldTypeString", "alias": "neighborhood", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "neighborhood" }, { "name": "property_use", "type": "esriFieldTypeString", "alias": "property_use", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "property_use" }, { "name": "sqft_of_main", "type": "esriFieldTypeInteger", "alias": "sqft_of_main", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sqft_of_main" }, { "name": "desc_of_main_land", "type": "esriFieldTypeString", "alias": "desc_of_main_land", "domain": null, "editable": true, "nullable": true, "length": 53, "defaultValue": null, "modelName": "desc_of_main_land" }, { "name": "size_of_main_land", "type": "esriFieldTypeDouble", "alias": "size_of_main_land", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "size_of_main_land" }, { "name": "public_water", "type": "esriFieldTypeString", "alias": "public_water", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "public_water" }, { "name": "public_sewer", "type": "esriFieldTypeString", "alias": "public_sewer", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "public_sewer" }, { "name": "flood_plain", "type": "esriFieldTypeString", "alias": "flood_plain", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "flood_plain" }, { "name": "owner", "type": "esriFieldTypeString", "alias": "owner", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "owner" }, { "name": "owner_address1", "type": "esriFieldTypeString", "alias": "owner_address1", "domain": null, "editable": true, "nullable": true, "length": 85, "defaultValue": null, "modelName": "owner_address1" }, { "name": "owner_address2", "type": "esriFieldTypeString", "alias": "owner_address2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "owner_address2" }, { "name": "owner_city_state", "type": "esriFieldTypeString", "alias": "owner_city_state", "domain": null, "editable": true, "nullable": true, "length": 52, "defaultValue": null, "modelName": "owner_city_state" }, { "name": "owner_zip", "type": "esriFieldTypeString", "alias": "owner_zip", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "owner_zip" }, { "name": "deed_book_ref", "type": "esriFieldTypeString", "alias": "deed_book_ref", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "deed_book_ref" }, { "name": "sale_price", "type": "esriFieldTypeString", "alias": "sale_price", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "sale_price" }, { "name": "date_of_transfer", "type": "esriFieldTypeString", "alias": "date_of_transfer", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "date_of_transfer" }, { "name": "prev_owner", "type": "esriFieldTypeString", "alias": "prev_owner", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "prev_owner" }, { "name": "prev_deed_book", "type": "esriFieldTypeString", "alias": "prev_deed_book", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "prev_deed_book" }, { "name": "prev_consideration", "type": "esriFieldTypeString", "alias": "prev_consideration", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "prev_consideration" }, { "name": "prev_date_of_transfer", "type": "esriFieldTypeString", "alias": "prev_date_of_transfer", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "prev_date_of_transfer" }, { "name": "improvement_assessment", "type": "esriFieldTypeDouble", "alias": "improvement_assessment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "improvement_assessment" }, { "name": "land_assessment", "type": "esriFieldTypeDouble", "alias": "land_assessment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "land_assessment" }, { "name": "total_assessment", "type": "esriFieldTypeDouble", "alias": "total_assessment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "total_assessment" }, { "name": "legal_description", "type": "esriFieldTypeString", "alias": "legal_description", "domain": null, "editable": true, "nullable": true, "length": 3500, "defaultValue": null, "modelName": "legal_description" }, { "name": "internet_suppress", "type": "esriFieldTypeString", "alias": "internet_suppress", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "internet_suppress" }, { "name": "FullAddress", "type": "esriFieldTypeString", "alias": "FullAddress", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FullAddress" }, { "name": "AcreageInt", "type": "esriFieldTypeDouble", "alias": "AcreageInt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AcreageInt" }, { "name": "RIM_FILE_PATH", "type": "esriFieldTypeString", "alias": "RIM_FILE_PATH", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "RIM_FILE_PATH" }, { "name": "RIM_LAST_UPDATE", "type": "esriFieldTypeDate", "alias": "RIM_LAST_UPDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RIM_LAST_UPDATE" }, { "name": "Last_Rundate", "type": "esriFieldTypeDate", "alias": "Last_Rundate", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "Last_Rundate" } ], "indexes": [ { "name": "R7409_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_104211_tax_m", "fields": "tax_map_number", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "VisionExtract", "description": "", "prototype": { "attributes": { "RIM_LAST_UPDATE": null, "PID": 0, "tax_map_number": null, "street_number": null, "street_suffix": null, "street_name": null, "zip_code": null, "year_built": null, "residential": null, "commercial": null, "property_desc": null, "stories": null, "rooms": null, "bedrooms": null, "baths": null, "fireplaces": null, "split_level": null, "split_foyer": null, "central_heat": null, "central_air": null, "type_of_roof": null, "type_of_exterior": null, "type_of_basement": null, "type_of_floors": null, "type_of_walls": null, "type_of_heat": null, "class_code": null, "zoning": null, "neighborhood": null, "property_use": null, "sqft_of_main": null, "desc_of_main_land": null, "size_of_main_land": null, "public_water": null, "public_sewer": null, "flood_plain": null, "owner": null, "owner_address1": null, "owner_address2": null, "owner_city_state": null, "owner_zip": null, "deed_book_ref": null, "sale_price": null, "date_of_transfer": null, "prev_owner": null, "prev_deed_book": null, "prev_consideration": null, "prev_date_of_transfer": null, "improvement_assessment": null, "land_assessment": null, "total_assessment": null, "legal_description": null, "internet_suppress": null, "FullAddress": null, "AcreageInt": null, "RIM_FILE_PATH": null, "Last_Rundate": -2209161600000 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "3a2b5db5ec68464c998167b78bb4f05e" }