{ "currentVersion": 10.71, "id": 27, "name": "v4.L.GCS_Parcel_JoinTable", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "TaxParcel", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PARCELID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "STREETNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "STATEID", "type": "esriFieldTypeString", "alias": "State ID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "STATEID" }, { "name": "PARCELID", "type": "esriFieldTypeString", "alias": "Parcel ID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PARCELID" }, { "name": "TAXPARCELID", "type": "esriFieldTypeString", "alias": "Tax Parcel ID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "TAXPARCELID" }, { "name": "PARCELDATE", "type": "esriFieldTypeString", "alias": "Parcel Date", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PARCELDATE" }, { "name": "TAXROLLYEAR", "type": "esriFieldTypeString", "alias": "Tax Roll Year", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TAXROLLYEAR" }, { "name": "OWNERNME1", "type": "esriFieldTypeString", "alias": "Primary Owner Name", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "OWNERNME1" }, { "name": "OWNERNME2", "type": "esriFieldTypeString", "alias": "Secondary Owner Name", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "OWNERNME2" }, { "name": "PSTLADRESS", "type": "esriFieldTypeString", "alias": "Full Mailing Address", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PSTLADRESS" }, { "name": "SITEADRESS", "type": "esriFieldTypeString", "alias": "Full Physical Address", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "SITEADRESS" }, { "name": "ADDNUMPREFIX", "type": "esriFieldTypeString", "alias": "Address Number Prefix", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ADDNUMPREFIX" }, { "name": "ADDNUM", "type": "esriFieldTypeString", "alias": "Address Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ADDNUM" }, { "name": "ADDNUMSUFFIX", "type": "esriFieldTypeString", "alias": "Address Number Suffix", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ADDNUMSUFFIX" }, { "name": "PREFIX", "type": "esriFieldTypeString", "alias": "Prefix", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PREFIX" }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "Street Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STREETNAME" }, { "name": "STREETTYPE", "type": "esriFieldTypeString", "alias": "Street Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STREETTYPE" }, { "name": "SUFFIX", "type": "esriFieldTypeString", "alias": "Suffix", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUFFIX" }, { "name": "LANDMARKNAME", "type": "esriFieldTypeString", "alias": "Landmark Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LANDMARKNAME" }, { "name": "UNITTYPE", "type": "esriFieldTypeString", "alias": "Unit Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNITTYPE" }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "Unit ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNITID" }, { "name": "PLACENAME", "type": "esriFieldTypeString", "alias": "Place Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PLACENAME" }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "Zip Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ZIPCODE" }, { "name": "ZIP4", "type": "esriFieldTypeString", "alias": "Zip Code Plus 4", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ZIP4" }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STATE" }, { "name": "SCHOOLDIST", "type": "esriFieldTypeString", "alias": "School District", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SCHOOLDIST" }, { "name": "SCHOOLDISTNO", "type": "esriFieldTypeString", "alias": "School District Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SCHOOLDISTNO" }, { "name": "IMPROVED", "type": "esriFieldTypeString", "alias": "Improved Structure", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "IMPROVED" }, { "name": "CNTASSDVALUE", "type": "esriFieldTypeString", "alias": "Total Assessed Value", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CNTASSDVALUE" }, { "name": "LNDVALUE", "type": "esriFieldTypeString", "alias": "Assessed Value of Land", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LNDVALUE" }, { "name": "IMPVALUE", "type": "esriFieldTypeString", "alias": "Assessed Value of Improvements", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "IMPVALUE" }, { "name": "FORESTVALUE", "type": "esriFieldTypeString", "alias": "Assessed Forested Value", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FORESTVALUE" }, { "name": "ESTFMKVALUE", "type": "esriFieldTypeString", "alias": "Estimated Fair Market Value", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ESTFMKVALUE" }, { "name": "NETPRPTA", "type": "esriFieldTypeString", "alias": "Net Property Tax", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NETPRPTA" }, { "name": "GRSPRPTA", "type": "esriFieldTypeString", "alias": "Gross Property Tax", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GRSPRPTA" }, { "name": "PROPCLASS", "type": "esriFieldTypeString", "alias": "Class of Property", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "PROPCLASS" }, { "name": "AUXCLASS", "type": "esriFieldTypeString", "alias": "Auxiliary Class of Property", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "AUXCLASS" }, { "name": "ASSDACRES", "type": "esriFieldTypeString", "alias": "Assessed Acres", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ASSDACRES" }, { "name": "DEEDACRES", "type": "esriFieldTypeString", "alias": "Deeded Acres", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DEEDACRES" }, { "name": "GISACRES", "type": "esriFieldTypeString", "alias": "GIS Acres", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GISACRES" }, { "name": "CONAME", "type": "esriFieldTypeString", "alias": "County Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONAME" }, { "name": "LOADDATE", "type": "esriFieldTypeString", "alias": "Load Date", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LOADDATE" }, { "name": "PARCELFIPS", "type": "esriFieldTypeString", "alias": "Parcel Source FIPS", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PARCELFIPS" }, { "name": "PARCELSRC", "type": "esriFieldTypeString", "alias": "Parcel Source", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PARCELSRC" }, { "name": "ConversionDate", "type": "esriFieldTypeDate", "alias": "ConversionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConversionDate" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "MFLVALUE", "type": "esriFieldTypeString", "alias": "MFLVALUE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MFLVALUE" } ], "indexes": [ { "name": "R324_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ParcelID", "fields": "PARCELID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "TaxParcelID", "fields": "TAXPARCELID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "OWNERNME1", "fields": "OWNERNME1", "isAscending": true, "isUnique": false, "description": "" }, { "name": "OWNERNME2", "fields": "OWNERNME2", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PSTLADRESS", "fields": "PSTLADRESS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "SITEADRESS", "fields": "SITEADRESS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ADDNUM", "fields": "ADDNUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PREFIX", "fields": "PREFIX", "isAscending": true, "isUnique": false, "description": "" }, { "name": "STREETNAME", "fields": "STREETNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "STREETTYPE", "fields": "STREETTYPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "SUFFIX", "fields": "SUFFIX", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UNITTYPE", "fields": "UNITTYPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UNITID", "fields": "UNITID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PLACENAME", "fields": "PLACENAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ZIPCODE", "fields": "ZIPCODE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "STATE", "fields": "STATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "SCHOOLDIST", "fields": "SCHOOLDIST", "isAscending": true, "isUnique": false, "description": "" }, { "name": "SCHOOLDISTNO", "fields": "SCHOOLDISTNO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IMPROVED", "fields": "IMPROVED", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CNTASSDVALUE", "fields": "CNTASSDVALUE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "LNDVALUE", "fields": "LNDVALUE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IMPVALUE", "fields": "IMPVALUE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ESTFMKVALUE", "fields": "ESTFMKVALUE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "NETPRPTA", "fields": "NETPRPTA", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GRSPRPTA", "fields": "GRSPRPTA", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PROPCLASS", "fields": "PROPCLASS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "AUXCLASS", "fields": "AUXCLASS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ASSDACRES", "fields": "ASSDACRES", "isAscending": true, "isUnique": false, "description": "" }, { "name": "DEEDACRES", "fields": "DEEDACRES", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_324", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "MFLVALUE", "fields": "MFLVALUE", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "v4.L.GCS_Parcel_JoinTable", "description": "", "prototype": { "attributes": { "MFLVALUE": null, "ConversionDate": null, "STATEID": null, "PARCELID": null, "TAXPARCELID": null, "PARCELDATE": null, "TAXROLLYEAR": null, "OWNERNME1": null, "OWNERNME2": null, "PSTLADRESS": null, "SITEADRESS": null, "ADDNUMPREFIX": null, "ADDNUM": null, "ADDNUMSUFFIX": null, "PREFIX": null, "STREETNAME": null, "STREETTYPE": null, "SUFFIX": null, "LANDMARKNAME": null, "UNITTYPE": null, "UNITID": null, "PLACENAME": null, "ZIPCODE": null, "ZIP4": null, "STATE": null, "SCHOOLDIST": null, "SCHOOLDISTNO": null, "IMPROVED": null, "CNTASSDVALUE": null, "LNDVALUE": null, "IMPVALUE": null, "FORESTVALUE": null, "ESTFMKVALUE": null, "NETPRPTA": null, "GRSPRPTA": null, "PROPCLASS": null, "AUXCLASS": null, "ASSDACRES": null, "DEEDACRES": null, "GISACRES": null, "CONAME": null, "LOADDATE": null, "PARCELFIPS": null, "PARCELSRC": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 10000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 10000, "tileMaxRecordCount": 10000, "maxRecordCountFactor": 1 }