Name: Wicomico.SDE.SDATDATA

Display Field: ownname1

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1be1065bd0514892929d1259036e6e4d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, alias: OBJECTID, type: esriFieldTypeOID )
• jurscode ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Jurisdiction Code (MDP Field: JURSCODE), type: esriFieldTypeString )
• cntynam ( nullable: true, editable: true, defaultValue: null, length: 50, alias: County Name (MDP Field: CNTYNAME), type: esriFieldTypeString )
• acctid ( nullable: true, editable: true, defaultValue: null, length: 16, alias: MDP_ACCTID, type: esriFieldTypeString )
• sdat_link ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Real Property Search Link, type: esriFieldTypeString )
• google_link ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: FINDER Online Link, type: esriFieldTypeString )
• mdp_link ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Search Google Maps for this Location, type: esriFieldTypeString )
• geogcode ( nullable: true, editable: true, defaultValue: null, alias: RECORD KEY: Geographic Code (MDP Field: GEOGCODE. SDAT Field #5), type: esriFieldTypeInteger )
• ooi ( nullable: true, editable: true, defaultValue: null, length: 1, alias: RECORD KEY: Owner Occupancy Code (MDP Field: OOI. SDAT Field #6), type: esriFieldTypeString )
• ownname1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: RECORD KEY: Owner's Name(MDP Field: OWNNAME1. SDAT Field # 7), type: esriFieldTypeString )
• ownname2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: RECORD KEY: Owner's Name 2nd Line (MDP Field: OWNNAME2. SDAT Field #8), type: esriFieldTypeString )
• ownadd1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: OWNER MAILING ADDRESS: Address 1st Line (MDP Field: OWNADD1. SDAT Field #10), type: esriFieldTypeString )
• ownadd2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: OWNER MAILING ADDRESS: Address 2nd Line (MDP Field: OWNADD2. SDAT Field #11), type: esriFieldTypeString )
• owncity ( nullable: true, editable: true, defaultValue: null, length: 50, alias: OWNER MAILING ADDRESS: City (MDP Field: OWNCITY. SDAT Field #12), type: esriFieldTypeString )
• ownstate ( nullable: true, editable: true, defaultValue: null, length: 50, alias: OWNER MAILING ADDRESS: State Code (MDP Field: OWNSTATE. SDAT Field #13), type: esriFieldTypeString )
• ownerzip ( nullable: true, editable: true, defaultValue: null, length: 10, alias: OWNER MAILING ADDRESS: Zip Code (MDP Field: OWNERZIP. SDAT Field #14), type: esriFieldTypeString )
• ownzip2 ( nullable: true, editable: true, defaultValue: null, length: 50, alias: OWNER MAILING ADDRESS: Zip +4 Code (MDP Field: OWNZIP2. SDAT Field #15), type: esriFieldTypeString )
• legal1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: LEGAL DESCRIPTION: Line 1 (MDP Field: LEGAL1. SDAT Field #17), type: esriFieldTypeString )
• legal2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: LEGAL DESCRIPTION: Line 2 (MDP Field: LEGAL2. SDAT Field #18), type: esriFieldTypeString )
• legal3 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: LEGAL DESCRIPTION: Line 3 (MDP Field: LEGAL3. SDAT Field #19), type: esriFieldTypeString )
• premsnum ( nullable: true, editable: true, defaultValue: null, alias: PREMISE ADDRESS: Number (MDP Field: PREMSNUM. SDAT Field #20), type: esriFieldTypeInteger )
• premssuff ( nullable: true, editable: true, defaultValue: null, length: 15, alias: PREMISE ADDRESS: Number Suffix (SDAT Field #21), type: esriFieldTypeString )
• premsdir ( nullable: true, editable: true, defaultValue: null, length: 10, alias: PREMISE ADDRESS: Direction (MDP Field: PREMSDIR. SDAT Field #22), type: esriFieldTypeString )
• premsnam ( nullable: true, editable: true, defaultValue: null, length: 50, alias: PREMISE ADDRESS: Name (MDP Field: PREMSNAM. SDAT Field #23), type: esriFieldTypeString )
• premstyp ( nullable: true, editable: true, defaultValue: null, length: 50, alias: PREMISE ADDRESS: Type (MDP Field: PREMSTYP. SDAT Field #24), type: esriFieldTypeString )
• premcity ( nullable: true, editable: true, defaultValue: null, length: 50, alias: PREMISE ADDRESS: City (MDP Field: PREMCITY. SDAT Field #25), type: esriFieldTypeString )
• premzip ( nullable: true, editable: true, defaultValue: null, length: 50, alias: PREMISE ADDRESS: Zip Code (MDP Field: PREMZIP. SDAT Field #26), type: esriFieldTypeString )
• condo ( nullable: true, editable: true, defaultValue: null, length: 50, alias: PREMISE ADDRESS: Condominium Unit No. (SDAT Field #28), type: esriFieldTypeString )
• dr1clerk ( nullable: true, editable: true, defaultValue: null, length: 50, alias: DEED REFERENCE 1: Clerk Initials (MDP Field: DR1CLERK. SDAT Field #29), type: esriFieldTypeString )
• dr1liber ( nullable: true, editable: true, defaultValue: null, length: 50, alias: DEED REFERENCE 1: Liber (MDP Field: DR1LIBER. SDAT Field #30), type: esriFieldTypeString )
• dr1folio ( nullable: true, editable: true, defaultValue: null, length: 50, alias: DEED REFERENCE 1: Folio (MDP Field: DR1FOLIO. SDAT Field #31), type: esriFieldTypeString )
• towncode ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Town Code (MDP Field: TOWNCODE/DESCTOWN. SDAT Field #36), type: esriFieldTypeString )
• subdivsn ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Subdivision Code (MDP Field: SUBDIVSN. SDAT Field #37), type: esriFieldTypeString )
• platnum ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Plat Number (MDP Field: PLAT. SDAT Field #38), type: esriFieldTypeString )
• section ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Section (MDP Field: SECTION. SDAT Field #39), type: esriFieldTypeString )
• block ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Block (MDP Field: BLOCK. SDAT Field #40), type: esriFieldTypeString )
• lot ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Lot (MDP Field: LOT. SDAT Field #41), type: esriFieldTypeString )
• map ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Map (MDP Field: MAP. SDAT Field #42), type: esriFieldTypeString )
• grid ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Grid (MDP Field: GRID. SDAT Field #43), type: esriFieldTypeString )
• parcel ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Parcel (MDP Field: PARCEL. SDAT Field #44), type: esriFieldTypeString )
• zoning ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Zoning Code (MDP Field: ZONING. SDAT Field #45), type: esriFieldTypeString )
• exclass ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Exempt Class (MDP Field: EXCLASS/DESCEXCL. SDAT Field #49), type: esriFieldTypeString )
• resityp ( nullable: true, editable: true, defaultValue: null, length: 10, alias: MDP Street Address Type Code (MDP Field: RESITYP), type: esriFieldTypeString )
• desclu ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Land Use Code (MDP Field: LU/DESCLU. SDAT Field #50), type: esriFieldTypeString )
• pfuw ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROPERTY FACTORS: Utilities - Water (MDP Field: PFUW. SDAT Field #63), type: esriFieldTypeString )
• pfus ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROPERTY FACTORS: Utilities - Sewer (MDP Field: PFUS. SDAT Field #64), type: esriFieldTypeString )
• pflw ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROPERTY FACTORS: Location - Waterfront (MDP Field: PFLW. SDAT Field #65), type: esriFieldTypeString )
• pfsp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROPERTY FACTORS: Street - Paved (MDP Field: PFSP. SDAT Field #67), type: esriFieldTypeString )
• pfsu ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROPERTY FACTORS: Street - Unpaved (MDP Field: PFSU. SDAT Field #68), type: esriFieldTypeString )
• pfic ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROPERTY FACTORS: Influence - Commer/Indust. (MDP Field: PFIC. SDAT Field #69), type: esriFieldTypeString )
• tradate ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SALES SEGMENT 1: Transfer Date (YYYY.MM.DD) (MDP Field: TRADATE. SDAT Field #89), type: esriFieldTypeString )
• bldg_units ( nullable: true, editable: true, defaultValue: null, length: 50, alias: C.A.M.A. SYSTEM DATA: Number of Dwelling Units (MDP Field: BLDG_UNITS. SDAT Field #239), type: esriFieldTypeString )
• base_landval ( nullable: true, editable: true, defaultValue: null, alias: BASE CYCLE DATA: Land Value (SDAT Field #154), type: esriFieldTypeDouble )
• base_impval ( nullable: true, editable: true, defaultValue: null, alias: BASE CYCLE DATA: Improvements Value (SDAT Field #155), type: esriFieldTypeDouble )
• curr_landval ( nullable: true, editable: true, defaultValue: null, alias: CURRENT CYCLE DATA: Land Value (MDP Field Names: NFMLNDVL, CURLNDVL, and SALLNDVL. SDAT Field #164), type: esriFieldTypeDouble )
• curr_impval ( nullable: true, editable: true, defaultValue: null, alias: CURRENT CYCLE DATA: Improvements Value (MDP Field Names: NFMIMPVL, CURIMPVL, and SALIMPVL. SDAT Field #165), type: esriFieldTypeDouble )
• curr_assessment ( nullable: true, editable: true, defaultValue: null, alias: CURRENT ASSESSMENT YEAR: Total Assessment (SDAT Field #172), type: esriFieldTypeDouble )
• prior_assessment ( nullable: true, editable: true, defaultValue: null, length: 50, alias: PRIOR ASSESSMENT YEAR: Total Assessment (SDAT Field #161), type: esriFieldTypeString )
• entzndat ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SPECIAL DATES AND DATA: Enterprise Zone Date (YYYY.MM.DD) (MDP Field: ENTZNDAT. SDAT Field #215), type: esriFieldTypeString )
• entznassm ( nullable: true, editable: true, defaultValue: null, alias: SPECIAL DATES AND DATA: Enterprise Zone Assessment (MDP Field: ENTZNASSM. SDAT Field #216), type: esriFieldTypeDouble )
• crtarcod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SPECIAL DATES AND DATA: Critical Area Code (MDP Field: CRTARCOD. SDAT Field #223), type: esriFieldTypeString )
• last_updated ( nullable: true, editable: true, defaultValue: null, alias: Date of Most Recent Open Data Portal Record Update, type: esriFieldTypeInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )

Templates:

• Name: Wicomico.SDE.SDATDATA
  Description:
  Prototype:
  premcity: null
  ooi: null
  section: null
  legal3: null
  curr_impval: null
  geogcode: null
  legal1: null
  legal2: null
  curr_landval: null
  entznassm: null
  ownadd1: null
  zoning: null
  ownadd2: null
  block: null
  mdp_link: null
  ownzip2: null
  pfus: null
  subdivsn: null
  last_updated: null
  parcel: null
  pfic: null
  bldg_units: null
  condo: null
  ownstate: null
  ownerzip: null
  pfuw: null
  tradate: null
  premzip: null
  curr_assessment: null
  cntynam: null
  desclu: null
  pflw: null
  jurscode: null
  premssuff: null
  premsnum: null
  base_impval: null
  resityp: null
  acctid: null
  google_link: null
  dr1folio: null
  prior_assessment: null
  owncity: null
  lot: null
  dr1liber: null
  towncode: null
  ownname1: null
  ownname2: null
  sdat_link: null
  map: null
  platnum: null
  exclass: null
  pfsp: null
  premsnam: null
  pfsu: null
  dr1clerk: null
  base_landval: null
  grid: null
  entzndat: null
  crtarcod: null
  premstyp: null
  premsdir: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Wicomico.SDE.Parcels_SDAT (0) -- Related To: Wicomico.SDE.ParcelsSDAT (0)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata