{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 1, "name": "Wicomico.SDE.SDATDATA", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Wicomico.SDE.Parcels_SDAT", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "acctid", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsDistinct": true, "supportsPagination": true, "supportsOrderBy": true, "supportsPaginationOnAggregatedQueries": true, "supportsQueryWithResultType": true, "supportsHavingClause": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": false, "supportsOrderByOnlyOnLayerFields": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "ownname1", "typeIdField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "nullable": false, "editable": false }, { "name": "jurscode", "type": "esriFieldTypeString", "alias": "Jurisdiction Code (MDP Field: JURSCODE)", "domain": null, "editable": true, "nullable": true, "length": 4 }, { "name": "cntynam", "type": "esriFieldTypeString", "alias": "County Name (MDP Field: CNTYNAME)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "acctid", "type": "esriFieldTypeString", "alias": "MDP_ACCTID", "domain": null, "editable": true, "nullable": true, "length": 16 }, { "name": "sdat_link", "type": "esriFieldTypeString", "alias": "Real Property Search Link", "domain": null, "editable": true, "nullable": true, "length": 2147483647 }, { "name": "google_link", "type": "esriFieldTypeString", "alias": "FINDER Online Link", "domain": null, "editable": true, "nullable": true, "length": 2147483647 }, { "name": "mdp_link", "type": "esriFieldTypeString", "alias": "Search Google Maps for this Location", "domain": null, "editable": true, "nullable": true, "length": 2147483647 }, { "name": "geogcode", "type": "esriFieldTypeInteger", "alias": "RECORD KEY: Geographic Code (MDP Field: GEOGCODE. SDAT Field #5)", "domain": null, "editable": true, "nullable": true }, { "name": "ooi", "type": "esriFieldTypeString", "alias": "RECORD KEY: Owner Occupancy Code (MDP Field: OOI. SDAT Field #6)", "domain": null, "editable": true, "nullable": true, "length": 1 }, { "name": "ownname1", "type": "esriFieldTypeString", "alias": "RECORD KEY: Owner's Name(MDP Field: OWNNAME1. SDAT Field # 7)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "ownname2", "type": "esriFieldTypeString", "alias": "RECORD KEY: Owner's Name 2nd Line (MDP Field: OWNNAME2. SDAT Field #8)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "ownadd1", "type": "esriFieldTypeString", "alias": "OWNER MAILING ADDRESS: Address 1st Line (MDP Field: OWNADD1. SDAT Field #10)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "ownadd2", "type": "esriFieldTypeString", "alias": "OWNER MAILING ADDRESS: Address 2nd Line (MDP Field: OWNADD2. SDAT Field #11)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "owncity", "type": "esriFieldTypeString", "alias": "OWNER MAILING ADDRESS: City (MDP Field: OWNCITY. SDAT Field #12)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "ownstate", "type": "esriFieldTypeString", "alias": "OWNER MAILING ADDRESS: State Code (MDP Field: OWNSTATE. SDAT Field #13)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "ownerzip", "type": "esriFieldTypeString", "alias": "OWNER MAILING ADDRESS: Zip Code (MDP Field: OWNERZIP. SDAT Field #14)", "domain": null, "editable": true, "nullable": true, "length": 10 }, { "name": "ownzip2", "type": "esriFieldTypeString", "alias": "OWNER MAILING ADDRESS: Zip +4 Code (MDP Field: OWNZIP2. SDAT Field #15)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "legal1", "type": "esriFieldTypeString", "alias": "LEGAL DESCRIPTION: Line 1 (MDP Field: LEGAL1. SDAT Field #17)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "legal2", "type": "esriFieldTypeString", "alias": "LEGAL DESCRIPTION: Line 2 (MDP Field: LEGAL2. SDAT Field #18)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "legal3", "type": "esriFieldTypeString", "alias": "LEGAL DESCRIPTION: Line 3 (MDP Field: LEGAL3. SDAT Field #19)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "premsnum", "type": "esriFieldTypeInteger", "alias": "PREMISE ADDRESS: Number (MDP Field: PREMSNUM. SDAT Field #20)", "domain": null, "editable": true, "nullable": true }, { "name": "premssuff", "type": "esriFieldTypeString", "alias": "PREMISE ADDRESS: Number Suffix (SDAT Field #21)", "domain": null, "editable": true, "nullable": true, "length": 15 }, { "name": "premsdir", "type": "esriFieldTypeString", "alias": "PREMISE ADDRESS: Direction (MDP Field: PREMSDIR. SDAT Field #22)", "domain": null, "editable": true, "nullable": true, "length": 10 }, { "name": "premsnam", "type": "esriFieldTypeString", "alias": "PREMISE ADDRESS: Name (MDP Field: PREMSNAM. SDAT Field #23)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "premstyp", "type": "esriFieldTypeString", "alias": "PREMISE ADDRESS: Type (MDP Field: PREMSTYP. SDAT Field #24)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "premcity", "type": "esriFieldTypeString", "alias": "PREMISE ADDRESS: City (MDP Field: PREMCITY. SDAT Field #25)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "premzip", "type": "esriFieldTypeString", "alias": "PREMISE ADDRESS: Zip Code (MDP Field: PREMZIP. SDAT Field #26)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "condo", "type": "esriFieldTypeString", "alias": "PREMISE ADDRESS: Condominium Unit No. (SDAT Field #28)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "dr1clerk", "type": "esriFieldTypeString", "alias": "DEED REFERENCE 1: Clerk Initials (MDP Field: DR1CLERK. SDAT Field #29)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "dr1liber", "type": "esriFieldTypeString", "alias": "DEED REFERENCE 1: Liber (MDP Field: DR1LIBER. SDAT Field #30)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "dr1folio", "type": "esriFieldTypeString", "alias": "DEED REFERENCE 1: Folio (MDP Field: DR1FOLIO. SDAT Field #31)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "towncode", "type": "esriFieldTypeString", "alias": "Town Code (MDP Field: TOWNCODE/DESCTOWN. SDAT Field #36)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "subdivsn", "type": "esriFieldTypeString", "alias": "Subdivision Code (MDP Field: SUBDIVSN. SDAT Field #37)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "platnum", "type": "esriFieldTypeString", "alias": "Plat Number (MDP Field: PLAT. SDAT Field #38)", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "section", "type": "esriFieldTypeString", "alias": "Section (MDP Field: SECTION. SDAT Field #39)", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "block", "type": "esriFieldTypeString", "alias": "Block (MDP Field: BLOCK. SDAT Field #40)", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "lot", "type": "esriFieldTypeString", "alias": "Lot (MDP Field: LOT. SDAT Field #41)", "domain": null, "editable": true, "nullable": true, "length": 10 }, { "name": "map", "type": "esriFieldTypeString", "alias": "Map (MDP Field: MAP. SDAT Field #42)", "domain": null, "editable": true, "nullable": true, "length": 10 }, { "name": "grid", "type": "esriFieldTypeString", "alias": "Grid (MDP Field: GRID. SDAT Field #43)", "domain": null, "editable": true, "nullable": true, "length": 10 }, { "name": "parcel", "type": "esriFieldTypeString", "alias": "Parcel (MDP Field: PARCEL. SDAT Field #44)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "zoning", "type": "esriFieldTypeString", "alias": "Zoning Code (MDP Field: ZONING. SDAT Field #45)", "domain": null, "editable": true, "nullable": true, "length": 10 }, { "name": "exclass", "type": "esriFieldTypeString", "alias": "Exempt Class (MDP Field: EXCLASS/DESCEXCL. SDAT Field #49)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "resityp", "type": "esriFieldTypeString", "alias": "MDP Street Address Type Code (MDP Field: RESITYP)", "domain": null, "editable": true, "nullable": true, "length": 10 }, { "name": "desclu", "type": "esriFieldTypeString", "alias": "Land Use Code (MDP Field: LU/DESCLU. SDAT Field #50)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "pfuw", "type": "esriFieldTypeString", "alias": "PROPERTY FACTORS: Utilities - Water (MDP Field: PFUW. SDAT Field #63)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "pfus", "type": "esriFieldTypeString", "alias": "PROPERTY FACTORS: Utilities - Sewer (MDP Field: PFUS. SDAT Field #64)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "pflw", "type": "esriFieldTypeString", "alias": "PROPERTY FACTORS: Location - Waterfront (MDP Field: PFLW. SDAT Field #65)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "pfsp", "type": "esriFieldTypeString", "alias": "PROPERTY FACTORS: Street - Paved (MDP Field: PFSP. SDAT Field #67)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "pfsu", "type": "esriFieldTypeString", "alias": "PROPERTY FACTORS: Street - Unpaved (MDP Field: PFSU. SDAT Field #68)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "pfic", "type": "esriFieldTypeString", "alias": "PROPERTY FACTORS: Influence - Commer/Indust. (MDP Field: PFIC. SDAT Field #69)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "tradate", "type": "esriFieldTypeString", "alias": "SALES SEGMENT 1: Transfer Date (YYYY.MM.DD) (MDP Field: TRADATE. SDAT Field #89)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "bldg_units", "type": "esriFieldTypeString", "alias": "C.A.M.A. SYSTEM DATA: Number of Dwelling Units (MDP Field: BLDG_UNITS. SDAT Field #239)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "base_landval", "type": "esriFieldTypeDouble", "alias": "BASE CYCLE DATA: Land Value (SDAT Field #154)", "domain": null, "editable": true, "nullable": true }, { "name": "base_impval", "type": "esriFieldTypeDouble", "alias": "BASE CYCLE DATA: Improvements Value (SDAT Field #155)", "domain": null, "editable": true, "nullable": true }, { "name": "curr_landval", "type": "esriFieldTypeDouble", "alias": "CURRENT CYCLE DATA: Land Value (MDP Field Names: NFMLNDVL, CURLNDVL, and SALLNDVL. SDAT Field #164)", "domain": null, "editable": true, "nullable": true }, { "name": "curr_impval", "type": "esriFieldTypeDouble", "alias": "CURRENT CYCLE DATA: Improvements Value (MDP Field Names: NFMIMPVL, CURIMPVL, and SALIMPVL. SDAT Field #165)", "domain": null, "editable": true, "nullable": true }, { "name": "curr_assessment", "type": "esriFieldTypeDouble", "alias": "CURRENT ASSESSMENT YEAR: Total Assessment (SDAT Field #172)", "domain": null, "editable": true, "nullable": true }, { "name": "prior_assessment", "type": "esriFieldTypeString", "alias": "PRIOR ASSESSMENT YEAR: Total Assessment (SDAT Field #161)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "entzndat", "type": "esriFieldTypeString", "alias": "SPECIAL DATES AND DATA: Enterprise Zone Date (YYYY.MM.DD) (MDP Field: ENTZNDAT. SDAT Field #215)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "entznassm", "type": "esriFieldTypeDouble", "alias": "SPECIAL DATES AND DATA: Enterprise Zone Assessment (MDP Field: ENTZNASSM. SDAT Field #216)", "domain": null, "editable": true, "nullable": true }, { "name": "crtarcod", "type": "esriFieldTypeString", "alias": "SPECIAL DATES AND DATA: Critical Area Code (MDP Field: CRTARCOD. SDAT Field #223)", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "last_updated", "type": "esriFieldTypeInteger", "alias": "Date of Most Recent Open Data Portal Record Update", "domain": null, "editable": true, "nullable": true }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38 } ], "indexes": [ { "name": "i52acctid", "fields": "acctid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r30_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_30", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Wicomico.SDE.SDATDATA", "description": "", "prototype": { "attributes": { "last_updated": null, "crtarcod": null, "jurscode": null, "cntynam": null, "acctid": null, "sdat_link": null, "google_link": null, "mdp_link": null, "geogcode": null, "ooi": null, "ownname1": null, "ownname2": null, "ownadd1": null, "ownadd2": null, "owncity": null, "ownstate": null, "ownerzip": null, "ownzip2": null, "legal1": null, "legal2": null, "legal3": null, "premsnum": null, "premssuff": null, "premsdir": null, "premsnam": null, "premstyp": null, "premcity": null, "premzip": null, "condo": null, "dr1clerk": null, "dr1liber": null, "dr1folio": null, "towncode": null, "subdivsn": null, "platnum": null, "section": null, "block": null, "lot": null, "map": null, "grid": null, "parcel": null, "zoning": null, "exclass": null, "resityp": null, "desclu": null, "pfuw": null, "pfus": null, "pflw": null, "pfsp": null, "pfsu": null, "pfic": null, "tradate": null, "bldg_units": null, "base_landval": null, "base_impval": null, "curr_landval": null, "curr_impval": null, "curr_assessment": null, "prior_assessment": null, "entzndat": null, "entznassm": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "useStandardizedQueries": true, "standardMaxRecordCount": 16000, "tileMaxRecordCount": 4000, "maxRecordCountFactor": 1, "supportedQueryFormats": "JSON, geoJSON", "maxRecordCount": 2000, "allowGeometryUpdates": true, "capabilities": "Query", "enableZDefaults": true, "zDefault": 0, "allowUpdateWithoutMValues": true, "serviceItemId": "1be1065bd0514892929d1259036e6e4d", "hasMetadata": true, "supportsAttachmentsByUploadId": true, "supportsAsyncDelete": true, "sqlParserVersion": "PG_10.6.1" }