{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 7, "name": "saddress_TBL", "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, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "StrtName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LRSN", "type": "esriFieldTypeInteger", "alias": "LRSN", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "LRSN" }, { "name": "TranType", "type": "esriFieldTypeInteger", "alias": "TranType", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TranType" }, { "name": "AddrSeq", "type": "esriFieldTypeInteger", "alias": "AddrSeq", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "AddrSeq" }, { "name": "EffDate", "type": "esriFieldTypeDate", "alias": "EffDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "EffDate" }, { "name": "StrtDir", "type": "esriFieldTypeString", "alias": "StrtDir", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "StrtDir" }, { "name": "StrtName", "type": "esriFieldTypeString", "alias": "StrtName", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "StrtName" }, { "name": "StrtType", "type": "esriFieldTypeString", "alias": "StrtType", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "StrtType" }, { "name": "StrtSufx", "type": "esriFieldTypeString", "alias": "StrtSufx", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "StrtSufx" }, { "name": "StrtNum", "type": "esriFieldTypeInteger", "alias": "StrtNum", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "StrtNum" }, { "name": "SNumSufx", "type": "esriFieldTypeString", "alias": "SNumSufx", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "SNumSufx" }, { "name": "UnitNum", "type": "esriFieldTypeString", "alias": "UnitNum", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UnitNum" }, { "name": "StrtSide", "type": "esriFieldTypeString", "alias": "StrtSide", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "StrtSide" }, { "name": "StrtCity", "type": "esriFieldTypeString", "alias": "StrtCity", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "StrtCity" }, { "name": "StrtZip", "type": "esriFieldTypeString", "alias": "StrtZip", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "StrtZip" }, { "name": "StrtCode", "type": "esriFieldTypeString", "alias": "StrtCode", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StrtCode" }, { "name": "GPSx", "type": "esriFieldTypeInteger", "alias": "GPSx", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "GPSx" }, { "name": "GPSy", "type": "esriFieldTypeInteger", "alias": "GPSy", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "GPSy" }, { "name": "GPSz", "type": "esriFieldTypeInteger", "alias": "GPSz", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "GPSz" }, { "name": "StrtSeq", "type": "esriFieldTypeString", "alias": "StrtSeq", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "StrtSeq" }, { "name": "ImprCode", "type": "esriFieldTypeString", "alias": "ImprCode", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "ImprCode" }, { "name": "LandSeq", "type": "esriFieldTypeString", "alias": "LandSeq", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "LandSeq" }, { "name": "CensusTract", "type": "esriFieldTypeString", "alias": "CensusTract", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CensusTract" }, { "name": "CensusBlock", "type": "esriFieldTypeString", "alias": "CensusBlock", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CensusBlock" }, { "name": "PlanDist", "type": "esriFieldTypeString", "alias": "PlanDist", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "PlanDist" }, { "name": "FloodPl", "type": "esriFieldTypeString", "alias": "FloodPl", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "FloodPl" }, { "name": "FreeFormAddr", "type": "esriFieldTypeString", "alias": "FreeFormAddr", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "FreeFormAddr" }, { "name": "Code911", "type": "esriFieldTypeString", "alias": "Code911", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Code911" }, { "name": "ZonCode", "type": "esriFieldTypeString", "alias": "ZonCode", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ZonCode" }, { "name": "ZonDesc", "type": "esriFieldTypeString", "alias": "ZonDesc", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ZonDesc" }, { "name": "int1", "type": "esriFieldTypeInteger", "alias": "int1", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "int1" }, { "name": "int2", "type": "esriFieldTypeInteger", "alias": "int2", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "int2" }, { "name": "int3", "type": "esriFieldTypeInteger", "alias": "int3", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "int3" }, { "name": "LastUpd", "type": "esriFieldTypeDate", "alias": "LastUpd", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "LastUpd" }, { "name": "UserID", "type": "esriFieldTypeString", "alias": "UserID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "UserID" }, { "name": "char2a", "type": "esriFieldTypeString", "alias": "char2a", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "char2a" }, { "name": "char10a", "type": "esriFieldTypeString", "alias": "char10a", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "char10a" }, { "name": "DistNum", "type": "esriFieldTypeString", "alias": "DistNum", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "DistNum" }, { "name": "EffEnd", "type": "esriFieldTypeDate", "alias": "EffEnd", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "EffEnd" } ], "indexes": [ { "name": "R573_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "saddress_TBL", "description": "", "prototype": { "attributes": { "DistNum": null, "EffEnd": null, "LRSN": 0, "TranType": 0, "AddrSeq": 0, "EffDate": null, "StrtDir": null, "StrtName": null, "StrtType": null, "StrtSufx": null, "StrtNum": 0, "SNumSufx": null, "UnitNum": null, "StrtSide": null, "StrtCity": null, "StrtZip": null, "StrtCode": null, "GPSx": 0, "GPSy": 0, "GPSz": 0, "StrtSeq": null, "ImprCode": null, "LandSeq": null, "CensusTract": null, "CensusBlock": null, "PlanDist": null, "FloodPl": null, "FreeFormAddr": null, "Code911": null, "ZonCode": null, "ZonDesc": null, "int1": 0, "int2": 0, "int3": 0, "LastUpd": null, "UserID": null, "char2a": null, "char10a": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }