Name: Wicomico.SDE.SDATDATA

Display Field: ownname1

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON

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: false
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Wicomico.SDE.SDATDATA
  Description:
  Prototype:
  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
  
  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