{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 55, "name": "CAMA", "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": "ID", "globalIdField": "", "displayField": "PIN", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "ID" }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PIN" }, { "name": "AppUpdD", "type": "esriFieldTypeDate", "alias": "AppUpdD", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "AppUpdD" }, { "name": "DistNum", "type": "esriFieldTypeDouble", "alias": "DistNum", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DistNum" }, { "name": "SecPlat", "type": "esriFieldTypeString", "alias": "SecPlat", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SecPlat" }, { "name": "PropClas", "type": "esriFieldTypeDouble", "alias": "PropClas", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PropClas" }, { "name": "MailAddr", "type": "esriFieldTypeString", "alias": "MailAddr", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailAddr" }, { "name": "Owner1", "type": "esriFieldTypeString", "alias": "Owner1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Owner1" }, { "name": "Owner2", "type": "esriFieldTypeString", "alias": "Owner2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Owner2" }, { "name": "MailCity", "type": "esriFieldTypeString", "alias": "MailCity", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailCity" }, { "name": "MailStat", "type": "esriFieldTypeString", "alias": "MailStat", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailStat" }, { "name": "MailZip", "type": "esriFieldTypeString", "alias": "MailZip", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailZip" }, { "name": "PCDesc", "type": "esriFieldTypeString", "alias": "PCDesc", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PCDesc" }, { "name": "PlatBook", "type": "esriFieldTypeString", "alias": "PlatBook", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PlatBook" }, { "name": "PlatPage", "type": "esriFieldTypeString", "alias": "PlatPage", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PlatPage" }, { "name": "LandVal1", "type": "esriFieldTypeDouble", "alias": "LandVal1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LandVal1" }, { "name": "Legal1", "type": "esriFieldTypeString", "alias": "Legal1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Legal1" }, { "name": "Legal2", "type": "esriFieldTypeString", "alias": "Legal2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Legal2" }, { "name": "DwlgVal1", "type": "esriFieldTypeDouble", "alias": "DwlgVal1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DwlgVal1" }, { "name": "TotVal1", "type": "esriFieldTypeDouble", "alias": "TotVal1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotVal1" }, { "name": "LandVal2", "type": "esriFieldTypeDouble", "alias": "LandVal2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LandVal2" }, { "name": "Acres", "type": "esriFieldTypeDouble", "alias": "Acres", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Acres" }, { "name": "DwlgVal2", "type": "esriFieldTypeDouble", "alias": "DwlgVal2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DwlgVal2" }, { "name": "TotVal2", "type": "esriFieldTypeDouble", "alias": "TotVal2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotVal2" }, { "name": "Sale1D", "type": "esriFieldTypeDate", "alias": "Sale1D", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Sale1D" }, { "name": "Sale1Amt", "type": "esriFieldTypeDouble", "alias": "Sale1Amt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Sale1Amt" }, { "name": "Doc1Ref", "type": "esriFieldTypeString", "alias": "Doc1Ref", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Doc1Ref" }, { "name": "Grantor1", "type": "esriFieldTypeString", "alias": "Grantor1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Grantor1" }, { "name": "Grantor2", "type": "esriFieldTypeString", "alias": "Grantor2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Grantor2" }, { "name": "Grantor3", "type": "esriFieldTypeString", "alias": "Grantor3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Grantor3" }, { "name": "SqFt", "type": "esriFieldTypeDouble", "alias": "SqFt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SqFt" }, { "name": "LandDes1", "type": "esriFieldTypeString", "alias": "LandDes1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LandDes1" }, { "name": "LandDes2", "type": "esriFieldTypeString", "alias": "LandDes2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LandDes2" }, { "name": "LandDes3", "type": "esriFieldTypeString", "alias": "LandDes3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LandDes3" }, { "name": "Elec", "type": "esriFieldTypeString", "alias": "Elec", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Elec" }, { "name": "LandDes4", "type": "esriFieldTypeString", "alias": "LandDes4", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LandDes4" }, { "name": "LandDes5", "type": "esriFieldTypeString", "alias": "LandDes5", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LandDes5" }, { "name": "Gas", "type": "esriFieldTypeString", "alias": "Gas", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Gas" }, { "name": "Water", "type": "esriFieldTypeString", "alias": "Water", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Water" }, { "name": "Sewer", "type": "esriFieldTypeString", "alias": "Sewer", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Sewer" }, { "name": "StreetSD", "type": "esriFieldTypeString", "alias": "StreetSD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StreetSD" }, { "name": "NumDwlg", "type": "esriFieldTypeDouble", "alias": "NumDwlg", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumDwlg" }, { "name": "NumOth", "type": "esriFieldTypeDouble", "alias": "NumOth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumOth" }, { "name": "NumImp", "type": "esriFieldTypeDouble", "alias": "NumImp", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumImp" }, { "name": "ImprType", "type": "esriFieldTypeString", "alias": "ImprType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ImprType" }, { "name": "Stories", "type": "esriFieldTypeString", "alias": "Stories", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Stories" }, { "name": "UseCode", "type": "esriFieldTypeString", "alias": "UseCode", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UseCode" }, { "name": "UseDesc", "type": "esriFieldTypeString", "alias": "UseDesc", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UseDesc" }, { "name": "YrBuilt", "type": "esriFieldTypeDouble", "alias": "YrBuilt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YrBuilt" }, { "name": "FinSize", "type": "esriFieldTypeDouble", "alias": "FinSize", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FinSize" }, { "name": "Foundat", "type": "esriFieldTypeString", "alias": "Foundat", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Foundat" }, { "name": "ConstFr", "type": "esriFieldTypeString", "alias": "ConstFr", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ConstFr" }, { "name": "CondCode", "type": "esriFieldTypeString", "alias": "CondCode", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CondCode" }, { "name": "ExtDesc1", "type": "esriFieldTypeString", "alias": "ExtDesc1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ExtDesc1" }, { "name": "ExtDesc2", "type": "esriFieldTypeString", "alias": "ExtDesc2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ExtDesc2" }, { "name": "CondDesc", "type": "esriFieldTypeString", "alias": "CondDesc", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CondDesc" }, { "name": "NumRms", "type": "esriFieldTypeDouble", "alias": "NumRms", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumRms" }, { "name": "RoofDesc", "type": "esriFieldTypeString", "alias": "RoofDesc", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RoofDesc" }, { "name": "RoofMatD", "type": "esriFieldTypeString", "alias": "RoofMatD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RoofMatD" }, { "name": "NumBdRms", "type": "esriFieldTypeDouble", "alias": "NumBdRms", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumBdRms" }, { "name": "Num3Baths", "type": "esriFieldTypeDouble", "alias": "Num3Baths", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Num3Baths" }, { "name": "Num2Baths", "type": "esriFieldTypeDouble", "alias": "Num2Baths", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Num2Baths" }, { "name": "HeatDesc", "type": "esriFieldTypeString", "alias": "HeatDesc", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "HeatDesc" }, { "name": "CentrlAC", "type": "esriFieldTypeString", "alias": "CentrlAC", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CentrlAC" }, { "name": "Attic", "type": "esriFieldTypeString", "alias": "Attic", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Attic" }, { "name": "AtticFin", "type": "esriFieldTypeDouble", "alias": "AtticFin", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AtticFin" }, { "name": "AttGarSF", "type": "esriFieldTypeString", "alias": "AttGarSF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AttGarSF" }, { "name": "BsmtArea", "type": "esriFieldTypeDouble", "alias": "BsmtArea", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BsmtArea" }, { "name": "BsmtFin", "type": "esriFieldTypeDouble", "alias": "BsmtFin", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BsmtFin" }, { "name": "DetGarSF", "type": "esriFieldTypeString", "alias": "DetGarSF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DetGarSF" }, { "name": "DeckSF", "type": "esriFieldTypeDouble", "alias": "DeckSF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DeckSF" }, { "name": "ObyItem1", "type": "esriFieldTypeString", "alias": "ObyItem1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ObyItem1" }, { "name": "ObyItem2", "type": "esriFieldTypeString", "alias": "ObyItem2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ObyItem2" }, { "name": "ObyItem3", "type": "esriFieldTypeString", "alias": "ObyItem3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ObyItem3" }, { "name": "ObyItem4", "type": "esriFieldTypeString", "alias": "ObyItem4", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ObyItem4" }, { "name": "ObyNum", "type": "esriFieldTypeDouble", "alias": "ObyNum", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ObyNum" }, { "name": "landuse", "type": "esriFieldTypeString", "alias": "landuse", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "landuse" }, { "name": "Sketch", "type": "esriFieldTypeString", "alias": "Sketch", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Sketch" }, { "name": "UF18", "type": "esriFieldTypeString", "alias": "UF18", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UF18" } ], "indexes": [ { "name": "R22_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "ID" }, { "name": "I29UseCode", "isAscending": true, "isUnique": false, "description": "", "fields": "UseCode" }, { "name": "I29ObyNum", "isAscending": true, "isUnique": false, "description": "", "fields": "ObyNum" }, { "name": "I29NumRms", "isAscending": true, "isUnique": false, "description": "", "fields": "NumRms" }, { "name": "I29NumOth", "isAscending": true, "isUnique": false, "description": "", "fields": "NumOth" }, { "name": "I29NumImp", "isAscending": true, "isUnique": false, "description": "", "fields": "NumImp" }, { "name": "I29NumDwlg", "isAscending": true, "isUnique": false, "description": "", "fields": "NumDwlg" }, { "name": "I29NumBdRms", "isAscending": true, "isUnique": false, "description": "", "fields": "NumBdRms" }, { "name": "I29Num3Baths", "isAscending": true, "isUnique": false, "description": "", "fields": "Num3Baths" }, { "name": "I29Num2Baths", "isAscending": true, "isUnique": false, "description": "", "fields": "Num2Baths" }, { "name": "I29DistNum", "isAscending": true, "isUnique": false, "description": "", "fields": "DistNum" }, { "name": "I29CondCode", "isAscending": true, "isUnique": false, "description": "", "fields": "CondCode" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CAMA", "description": "", "prototype": { "attributes": { "Sketch": null, "PIN": null, "AppUpdD": null, "DistNum": null, "SecPlat": null, "PropClas": null, "MailAddr": null, "Owner1": null, "Owner2": null, "MailCity": null, "MailStat": null, "MailZip": null, "PCDesc": null, "PlatBook": null, "PlatPage": null, "LandVal1": null, "Legal1": null, "Legal2": null, "DwlgVal1": null, "TotVal1": null, "LandVal2": null, "Acres": null, "DwlgVal2": null, "TotVal2": null, "Sale1D": null, "Sale1Amt": null, "Doc1Ref": null, "Grantor1": null, "Grantor2": null, "Grantor3": null, "SqFt": null, "LandDes1": null, "LandDes2": null, "LandDes3": null, "Elec": null, "LandDes4": null, "LandDes5": null, "Gas": null, "Water": null, "Sewer": null, "StreetSD": null, "NumDwlg": null, "NumOth": null, "NumImp": null, "ImprType": null, "Stories": null, "UseCode": null, "UseDesc": null, "YrBuilt": null, "FinSize": null, "Foundat": null, "ConstFr": null, "CondCode": null, "ExtDesc1": null, "ExtDesc2": null, "CondDesc": null, "NumRms": null, "RoofDesc": null, "RoofMatD": null, "NumBdRms": null, "Num3Baths": null, "Num2Baths": null, "HeatDesc": null, "CentrlAC": null, "Attic": null, "AtticFin": null, "AttGarSF": null, "BsmtArea": null, "BsmtFin": null, "DetGarSF": null, "DeckSF": null, "ObyItem1": null, "ObyItem2": null, "ObyItem3": null, "ObyItem4": null, "ObyNum": null, "landuse": null, "UF18": 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 }