{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "AppraisalRecords", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "PLANO.Parcels", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "appraisalKey", "composite": false, "catalogID": "{B0BACB55-7D86-4C05-A8FF-F28E23109B21}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746088371000 }, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "situsStreetName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "propYear", "type": "esriFieldTypeInteger", "alias": "Property Appraisal Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "propYear" }, { "name": "propID", "type": "esriFieldTypeString", "alias": "Property ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "propID" }, { "name": "geoID", "type": "esriFieldTypeString", "alias": "Geographical ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "geoID" }, { "name": "appraisalKey", "type": "esriFieldTypeString", "alias": "Appraisal Key", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "appraisalKey" }, { "name": "situsFullAdd", "type": "esriFieldTypeString", "alias": "Situs Full Address", "domain": null, "editable": true, "nullable": true, "length": 114, "defaultValue": null, "modelName": "situsFullAdd" }, { "name": "situsStreetNum", "type": "esriFieldTypeString", "alias": "situsStreetNum", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "situsStreetNum" }, { "name": "situsStreetPrefix", "type": "esriFieldTypeString", "alias": "Situs Street Prefix", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "situsStreetPrefix" }, { "name": "situsStreetName", "type": "esriFieldTypeString", "alias": "Situs Street Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "situsStreetName" }, { "name": "situsStreetSuffix", "type": "esriFieldTypeString", "alias": "Situs Street Suffix", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "situsStreetSuffix" }, { "name": "situsUnit", "type": "esriFieldTypeString", "alias": "Situs Unit Number", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "situsUnit" }, { "name": "situsCity", "type": "esriFieldTypeString", "alias": "Situs City", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "situsCity" }, { "name": "situsZip", "type": "esriFieldTypeString", "alias": "Situs ZIP Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "situsZip" }, { "name": "ownerID", "type": "esriFieldTypeString", "alias": "Owner ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ownerID" }, { "name": "ownerConfFlag", "type": "esriFieldTypeString", "alias": "Owner Confidential Flag", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ownerConfFlag" }, { "name": "dbaName", "type": "esriFieldTypeString", "alias": "Business Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "dbaName" }, { "name": "udiPropFlag", "type": "esriFieldTypeString", "alias": "Undivided Interest Property Flag", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "udiPropFlag" }, { "name": "ownershipPct", "type": "esriFieldTypeDouble", "alias": "Ownership Percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ownershipPct" }, { "name": "ownerName", "type": "esriFieldTypeString", "alias": "Owner Name", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "ownerName" }, { "name": "ownerNameAddtl", "type": "esriFieldTypeString", "alias": "Owner Additional Name ", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "ownerNameAddtl" }, { "name": "ownerAddrLine1", "type": "esriFieldTypeString", "alias": "Owner Address Line 1", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "ownerAddrLine1" }, { "name": "ownerAddrLine2", "type": "esriFieldTypeString", "alias": "Owner Address Line 2", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "ownerAddrLine2" }, { "name": "ownerAddrCity", "type": "esriFieldTypeString", "alias": "Owner City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ownerAddrCity" }, { "name": "ownerAddrState", "type": "esriFieldTypeString", "alias": "Owner State", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ownerAddrState" }, { "name": "ownerAddrZip", "type": "esriFieldTypeString", "alias": "Owner ZIP Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ownerAddrZip" }, { "name": "ownerAddrCountry", "type": "esriFieldTypeString", "alias": "Owner Country", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ownerAddrCountry" }, { "name": "legalDescription", "type": "esriFieldTypeString", "alias": "Legal Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "legalDescription" }, { "name": "subdvName", "type": "esriFieldTypeString", "alias": "Subdivision Name", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "subdvName" }, { "name": "subdvCode", "type": "esriFieldTypeString", "alias": "Subdivision Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "subdvCode" }, { "name": "subdvBlock", "type": "esriFieldTypeString", "alias": "Subdivision Block", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "subdvBlock" }, { "name": "subdvLot", "type": "esriFieldTypeString", "alias": "Subdivision Lot", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "subdvLot" }, { "name": "propType", "type": "esriFieldTypeString", "alias": "Property Type", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "propType" }, { "name": "propSubType", "type": "esriFieldTypeString", "alias": "Property Sub Type", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "propSubType" }, { "name": "propCategoryCode", "type": "esriFieldTypeString", "alias": "Property Category Code", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "propCategoryCode" }, { "name": "propUseCode", "type": "esriFieldTypeString", "alias": "Property Use Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "propUseCode" }, { "name": "propStatus", "type": "esriFieldTypeString", "alias": "Property Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "propStatus" }, { "name": "comPropFlag", "type": "esriFieldTypeString", "alias": "Commercial Property Flag", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "comPropFlag" }, { "name": "landSizeAcres", "type": "esriFieldTypeDouble", "alias": "Land Size Acreage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "landSizeAcres" }, { "name": "landSizeSqft", "type": "esriFieldTypeDouble", "alias": "Land Size Square Feet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "landSizeSqft" }, { "name": "landAgAcres", "type": "esriFieldTypeDouble", "alias": "Land Agricultural Acreage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "landAgAcres" }, { "name": "imprvYearBuilt", "type": "esriFieldTypeSmallInteger", "alias": "Improvement Year Built", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "imprvYearBuilt" }, { "name": "imprvEffYearBuilt", "type": "esriFieldTypeSmallInteger", "alias": "Improvement Effective Year Built", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "imprvEffYearBuilt" }, { "name": "imprvMainArea", "type": "esriFieldTypeDouble", "alias": "Improvement Main Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "imprvMainArea" }, { "name": "imprvUnits", "type": "esriFieldTypeInteger", "alias": "Improvement Number of Units", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "imprvUnits" }, { "name": "imprvPoolFlag", "type": "esriFieldTypeString", "alias": "Swimming Pool Flag", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "imprvPoolFlag" }, { "name": "imprvClassCd", "type": "esriFieldTypeString", "alias": "Improvement Class Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "imprvClassCd" }, { "name": "entityCodes", "type": "esriFieldTypeString", "alias": "All Entity Codes", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "entityCodes" }, { "name": "entitySchoolCode", "type": "esriFieldTypeString", "alias": "School Entity Code", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "entitySchoolCode" }, { "name": "exemptCodes", "type": "esriFieldTypeString", "alias": "Exemption Codes", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "exemptCodes" }, { "name": "exemptHmstdFlag", "type": "esriFieldTypeString", "alias": "Homestead Exemption Flag", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "exemptHmstdFlag" }, { "name": "entityMUD", "type": "esriFieldTypeString", "alias": "MUD Flag", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "entityMUD" }, { "name": "entityTIF", "type": "esriFieldTypeString", "alias": "TIF Flag", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "entityTIF" }, { "name": "countyLineSplit", "type": "esriFieldTypeString", "alias": "Split by County Line", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "countyLineSplit" }, { "name": "taxAgentID", "type": "esriFieldTypeString", "alias": "Tax Agency ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "taxAgentID" }, { "name": "taxAgentName", "type": "esriFieldTypeString", "alias": "Tax Agency Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "taxAgentName" }, { "name": "deedTypeCd", "type": "esriFieldTypeString", "alias": "Deed Type Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "deedTypeCd" }, { "name": "deedNum", "type": "esriFieldTypeString", "alias": "Deed Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "deedNum" }, { "name": "deedBook", "type": "esriFieldTypeString", "alias": "Deed Book Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "deedBook" }, { "name": "deedPage", "type": "esriFieldTypeString", "alias": "Deed Page Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "deedPage" }, { "name": "deedEffDate", "type": "esriFieldTypeDate", "alias": "Deed Effective Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "deedEffDate" }, { "name": "certValYear", "type": "esriFieldTypeSmallInteger", "alias": "Certified Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValYear" }, { "name": "certValImprv", "type": "esriFieldTypeDouble", "alias": "Certified Improvement Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValImprv" }, { "name": "certValLand", "type": "esriFieldTypeDouble", "alias": "Certified Land Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValLand" }, { "name": "certValMarket", "type": "esriFieldTypeDouble", "alias": "Certified Market Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValMarket" }, { "name": "certValAgLoss", "type": "esriFieldTypeDouble", "alias": "Certified Agricultural Loss", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValAgLoss" }, { "name": "certValAppraised", "type": "esriFieldTypeDouble", "alias": "Certified Appraised Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValAppraised" }, { "name": "certValHSCapLoss", "type": "esriFieldTypeDouble", "alias": "Certified Homestead Cap Loss", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValHSCapLoss" }, { "name": "certValNHSCapLoss", "type": "esriFieldTypeDouble", "alias": "Certified Non-Homestead Cap Loss", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValNHSCapLoss" }, { "name": "certValAssessed", "type": "esriFieldTypeDouble", "alias": "Certified Assessed Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "certValAssessed" }, { "name": "URL", "type": "esriFieldTypeString", "alias": "Appraisal URL", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "URL" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user", "required": true }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date", "required": true }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user", "required": true }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "UUID_3628", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_5440_apprais", "fields": "appraisalKey", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "AppraisalRecords", "description": "", "prototype": { "attributes": { "certValAssessed": null, "URL": null, "propYear": null, "propID": null, "geoID": null, "appraisalKey": null, "situsFullAdd": null, "situsStreetNum": null, "situsStreetPrefix": null, "situsStreetName": null, "situsStreetSuffix": null, "situsUnit": null, "situsCity": null, "situsZip": null, "ownerID": null, "ownerConfFlag": null, "dbaName": null, "udiPropFlag": null, "ownershipPct": null, "ownerName": null, "ownerNameAddtl": null, "ownerAddrLine1": null, "ownerAddrLine2": null, "ownerAddrCity": null, "ownerAddrState": null, "ownerAddrZip": null, "ownerAddrCountry": null, "legalDescription": null, "subdvName": null, "subdvCode": null, "subdvBlock": null, "subdvLot": null, "propType": null, "propSubType": null, "propCategoryCode": null, "propUseCode": null, "propStatus": null, "comPropFlag": null, "landSizeAcres": null, "landSizeSqft": null, "landAgAcres": null, "imprvYearBuilt": null, "imprvEffYearBuilt": null, "imprvMainArea": null, "imprvUnits": null, "imprvPoolFlag": null, "imprvClassCd": null, "entityCodes": null, "entitySchoolCode": null, "exemptCodes": null, "exemptHmstdFlag": null, "entityMUD": null, "entityTIF": null, "countyLineSplit": null, "taxAgentID": null, "taxAgentName": null, "deedTypeCd": null, "deedNum": null, "deedBook": null, "deedPage": null, "deedEffDate": null, "certValYear": null, "certValImprv": null, "certValLand": null, "certValMarket": null, "certValAgLoss": null, "certValAppraised": null, "certValHSCapLoss": null, "certValNHSCapLoss": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "userTypeExtensions": [ "advancedEditing" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }