{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 20, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "SalesF", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "bdrms": null, "rooms": null, "zdp": null, "padr": null, "topo": null, "pin": null, "bssize": null, "ycd": null, "xday": null, "ususe7": null, "parcel": null, "stacks": null, "grtext": null, "roads": null, "saltyp": null, "zd": null, "nhstat": null, "sqrft": null, "pubutl": null, "dspsiz": null, "priutl": null, "hfbath": null, "rf": null, "grade": null, "opens": null, "nhcode": null, "acres": null, "unuse6": null, "fcd": null, "bi": null, "unuse2": null, "unuse3": null, "rftxt": null, "unuse4": null, "unuse5": null, "salpri": null, "unuse1": null, "grsize": null, "vcd": null, "num1": null, "saltp": null, "land": null, "class": null, "grcode": null, "st": null, "rem1": null, "bldg": null, "xyear": null, "lotsiz": null, "zcon": null, "xmonth": null, "baths": null, "salyr": null, "salmn": null, "zage": null, "insul": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.2, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "SalesF", "displayField": "pin", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "ObjectID" }, { "modelName": "xyear", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "xyear", "alias": "XYEAR", "type": "esriFieldTypeDouble" }, { "modelName": "xmonth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "xmonth", "alias": "XMONTH", "type": "esriFieldTypeDouble" }, { "modelName": "xday", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "xday", "alias": "XDAY", "type": "esriFieldTypeDouble" }, { "modelName": "parcel", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcel", "alias": "PARCEL", "type": "esriFieldTypeDouble" }, { "modelName": "pin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin", "length": 255, "alias": "PIN", "type": "esriFieldTypeString" }, { "modelName": "padr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "padr", "length": 255, "alias": "PADR", "type": "esriFieldTypeString" }, { "modelName": "saltyp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "saltyp", "length": 255, "alias": "SALTYP", "type": "esriFieldTypeString" }, { "modelName": "num1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "num1", "alias": "NUM1", "type": "esriFieldTypeDouble" }, { "modelName": "salmn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "salmn", "alias": "SALMN", "type": "esriFieldTypeDouble" }, { "modelName": "salyr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "salyr", "alias": "SALYR", "type": "esriFieldTypeDouble" }, { "modelName": "salpri", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "salpri", "alias": "SALPRI", "type": "esriFieldTypeDouble" }, { "modelName": "sqrft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sqrft", "alias": "SQRFT", "type": "esriFieldTypeDouble" }, { "modelName": "lotsiz", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lotsiz", "alias": "LOTSIZ", "type": "esriFieldTypeDouble" }, { "modelName": "dspsiz", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dspsiz", "alias": "DSPSIZ", "type": "esriFieldTypeDouble" }, { "modelName": "unuse1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unuse1", "length": 255, "alias": "UNUSE1", "type": "esriFieldTypeString" }, { "modelName": "acres", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "acres", "alias": "ACRES", "type": "esriFieldTypeDouble" }, { "modelName": "st", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "st", "alias": "ST", "type": "esriFieldTypeDouble" }, { "modelName": "bi", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bi", "length": 255, "alias": "BI", "type": "esriFieldTypeString" }, { "modelName": "zage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zage", "length": 255, "alias": "ZAGE", "type": "esriFieldTypeString" }, { "modelName": "zcon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zcon", "length": 255, "alias": "ZCON", "type": "esriFieldTypeString" }, { "modelName": "bdrms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bdrms", "alias": "BDRMS", "type": "esriFieldTypeDouble" }, { "modelName": "bssize", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bssize", "alias": "BSSIZE", "type": "esriFieldTypeDouble" }, { "modelName": "fcd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fcd", "length": 255, "alias": "FCD", "type": "esriFieldTypeString" }, { "modelName": "ycd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ycd", "length": 255, "alias": "YCD", "type": "esriFieldTypeString" }, { "modelName": "grsize", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "grsize", "alias": "GRSIZE", "type": "esriFieldTypeDouble" }, { "modelName": "grcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "grcode", "length": 255, "alias": "GRCODE", "type": "esriFieldTypeString" }, { "modelName": "grtext", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "grtext", "length": 255, "alias": "GRTEXT", "type": "esriFieldTypeString" }, { "modelName": "rf", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rf", "length": 255, "alias": "RF", "type": "esriFieldTypeString" }, { "modelName": "rftxt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rftxt", "length": 255, "alias": "RFTXT", "type": "esriFieldTypeString" }, { "modelName": "unuse2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unuse2", "length": 255, "alias": "UNUSE2", "type": "esriFieldTypeString" }, { "modelName": "rooms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rooms", "alias": "ROOMS", "type": "esriFieldTypeDouble" }, { "modelName": "baths", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "baths", "length": 255, "alias": "BATHS", "type": "esriFieldTypeString" }, { "modelName": "hfbath", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hfbath", "length": 255, "alias": "HFBATH", "type": "esriFieldTypeString" }, { "modelName": "unuse3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unuse3", "length": 255, "alias": "UNUSE3", "type": "esriFieldTypeString" }, { "modelName": "stacks", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stacks", "length": 255, "alias": "STACKS", "type": "esriFieldTypeString" }, { "modelName": "opens", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "opens", "length": 255, "alias": "OPENS", "type": "esriFieldTypeString" }, { "modelName": "insul", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "insul", "length": 255, "alias": "INSUL", "type": "esriFieldTypeString" }, { "modelName": "zd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zd", "alias": "ZD", "type": "esriFieldTypeDouble" }, { "modelName": "zdp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zdp", "length": 255, "alias": "ZDP", "type": "esriFieldTypeString" }, { "modelName": "grade", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "grade", "length": 255, "alias": "GRADE", "type": "esriFieldTypeString" }, { "modelName": "unuse4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unuse4", "length": 255, "alias": "UNUSE4", "type": "esriFieldTypeString" }, { "modelName": "roads", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roads", "length": 255, "alias": "ROADS", "type": "esriFieldTypeString" }, { "modelName": "nhstat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nhstat", "length": 255, "alias": "NHSTAT", "type": "esriFieldTypeString" }, { "modelName": "nhcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nhcode", "length": 255, "alias": "NHCODE", "type": "esriFieldTypeString" }, { "modelName": "topo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "topo", "length": 255, "alias": "TOPO", "type": "esriFieldTypeString" }, { "modelName": "pubutl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pubutl", "length": 255, "alias": "PUBUTL", "type": "esriFieldTypeString" }, { "modelName": "unuse5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unuse5", "length": 255, "alias": "UNUSE5", "type": "esriFieldTypeString" }, { "modelName": "priutl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priutl", "length": 255, "alias": "PRIUTL", "type": "esriFieldTypeString" }, { "modelName": "unuse6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unuse6", "length": 255, "alias": "UNUSE6", "type": "esriFieldTypeString" }, { "modelName": "class", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "class", "alias": "CLASS", "type": "esriFieldTypeDouble" }, { "modelName": "rem1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rem1", "length": 255, "alias": "REM1", "type": "esriFieldTypeString" }, { "modelName": "saltp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "saltp", "alias": "SALTP", "type": "esriFieldTypeDouble" }, { "modelName": "land", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "land", "alias": "LAND", "type": "esriFieldTypeDouble" }, { "modelName": "ususe7", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ususe7", "length": 255, "alias": "USUSE7", "type": "esriFieldTypeString" }, { "modelName": "bldg", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bldg", "alias": "BLDG", "type": "esriFieldTypeDouble" }, { "modelName": "vcd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "vcd", "length": 255, "alias": "VCD", "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, "supportsTruncate": true, "indexes": [ { "name": "r40_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "07fb928858e1423e84ea63654d721c51", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [] }