Name: SDE.DBO.Adata

Display Field: name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
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, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• schno ( type: esriFieldTypeInteger, alias: schno, editable: true, nullable: true, defaultValue: null, modelName: schno )
• ppi ( type: esriFieldTypeString, alias: ppi, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ppi )
• subcode ( type: esriFieldTypeInteger, alias: subcode, editable: true, nullable: true, defaultValue: null, modelName: subcode )
• subdesc ( type: esriFieldTypeString, alias: subdesc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subdesc )
• filing ( type: esriFieldTypeInteger, alias: filing, editable: true, nullable: true, defaultValue: null, modelName: filing )
• phase ( type: esriFieldTypeInteger, alias: phase, editable: true, nullable: true, defaultValue: null, modelName: phase )
• block ( type: esriFieldTypeString, alias: block, editable: true, nullable: true, length: 255, defaultValue: null, modelName: block )
• lot ( type: esriFieldTypeString, alias: lot, editable: true, nullable: true, length: 255, defaultValue: null, modelName: lot )
• legal1 ( type: esriFieldTypeString, alias: legal1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: legal1 )
• legal2 ( type: esriFieldTypeString, alias: legal2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: legal2 )
• legal3 ( type: esriFieldTypeString, alias: legal3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: legal3 )
• legal4 ( type: esriFieldTypeString, alias: legal4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: legal4 )
• legal_etal ( type: esriFieldTypeString, alias: legal_etal, editable: true, nullable: true, length: 255, defaultValue: null, modelName: legal_etal )
• econ ( type: esriFieldTypeString, alias: econ, editable: true, nullable: true, length: 255, defaultValue: null, modelName: econ )
• nhood ( type: esriFieldTypeString, alias: nhood, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nhood )
• house ( type: esriFieldTypeString, alias: house, editable: true, nullable: true, length: 255, defaultValue: null, modelName: house )
• pdir ( type: esriFieldTypeString, alias: pdir, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pdir )
• name ( type: esriFieldTypeString, alias: name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: name )
• suff ( type: esriFieldTypeString, alias: suff, editable: true, nullable: true, length: 255, defaultValue: null, modelName: suff )
• sdir ( type: esriFieldTypeString, alias: sdir, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sdir )
• unit ( type: esriFieldTypeString, alias: unit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: unit )
• town ( type: esriFieldTypeString, alias: town, editable: true, nullable: true, length: 255, defaultValue: null, modelName: town )
• num ( type: esriFieldTypeString, alias: num, editable: true, nullable: true, length: 255, defaultValue: null, modelName: num )
• abst1 ( type: esriFieldTypeInteger, alias: abst1, editable: true, nullable: true, defaultValue: null, modelName: abst1 )
• abst2 ( type: esriFieldTypeInteger, alias: abst2, editable: true, nullable: true, defaultValue: null, modelName: abst2 )
• abst3 ( type: esriFieldTypeInteger, alias: abst3, editable: true, nullable: true, defaultValue: null, modelName: abst3 )
• abst4 ( type: esriFieldTypeInteger, alias: abst4, editable: true, nullable: true, defaultValue: null, modelName: abst4 )
• more_abst ( type: esriFieldTypeString, alias: more_abst, editable: true, nullable: true, length: 255, defaultValue: null, modelName: more_abst )
• totlandval ( type: esriFieldTypeString, alias: totlandval, editable: true, nullable: true, length: 255, defaultValue: null, modelName: totlandval )
• totimpval ( type: esriFieldTypeString, alias: totimpval, editable: true, nullable: true, length: 255, defaultValue: null, modelName: totimpval )
• totactval ( type: esriFieldTypeString, alias: totactval, editable: true, nullable: true, length: 255, defaultValue: null, modelName: totactval )
• totassval ( type: esriFieldTypeString, alias: totassval, editable: true, nullable: true, length: 255, defaultValue: null, modelName: totassval )
• tax_year ( type: esriFieldTypeString, alias: tax_year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tax_year )
• tax_area ( type: esriFieldTypeString, alias: tax_area, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tax_area )
• mills ( type: esriFieldTypeString, alias: mills, editable: true, nullable: true, length: 255, defaultValue: null, modelName: mills )
• p_ownerf ( type: esriFieldTypeString, alias: p_ownerf, editable: true, nullable: true, length: 255, defaultValue: null, modelName: p_ownerf )
• p_ownerl ( type: esriFieldTypeString, alias: p_ownerl, editable: true, nullable: true, length: 255, defaultValue: null, modelName: p_ownerl )
• s_ownerf ( type: esriFieldTypeString, alias: s_ownerf, editable: true, nullable: true, length: 255, defaultValue: null, modelName: s_ownerf )
• s_ownerl ( type: esriFieldTypeString, alias: s_ownerl, editable: true, nullable: true, length: 255, defaultValue: null, modelName: s_ownerl )
• owner_etal ( type: esriFieldTypeString, alias: owner_etal, editable: true, nullable: true, length: 255, defaultValue: null, modelName: owner_etal )
• care_of ( type: esriFieldTypeString, alias: care_of, editable: true, nullable: true, length: 255, defaultValue: null, modelName: care_of )
• address ( type: esriFieldTypeString, alias: address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: address )
• city ( type: esriFieldTypeString, alias: city, editable: true, nullable: true, length: 255, defaultValue: null, modelName: city )
• state ( type: esriFieldTypeString, alias: state, editable: true, nullable: true, length: 255, defaultValue: null, modelName: state )
• zip ( type: esriFieldTypeString, alias: zip, editable: true, nullable: true, length: 255, defaultValue: null, modelName: zip )
• recno1 ( type: esriFieldTypeString, alias: recno1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: recno1 )
• recdate1 ( type: esriFieldTypeString, alias: recdate1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: recdate1 )
• rectype1 ( type: esriFieldTypeString, alias: rectype1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rectype1 )
• docfee1 ( type: esriFieldTypeString, alias: docfee1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: docfee1 )
• recno2 ( type: esriFieldTypeString, alias: recno2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: recno2 )
• recdate2 ( type: esriFieldTypeString, alias: recdate2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: recdate2 )
• rectype2 ( type: esriFieldTypeString, alias: rectype2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rectype2 )
• docfee2 ( type: esriFieldTypeString, alias: docfee2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: docfee2 )
• recno3 ( type: esriFieldTypeString, alias: recno3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: recno3 )
• recdate3 ( type: esriFieldTypeString, alias: recdate3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: recdate3 )
• rectype3 ( type: esriFieldTypeString, alias: rectype3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rectype3 )
• docfee3 ( type: esriFieldTypeString, alias: docfee3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: docfee3 )
• recno4 ( type: esriFieldTypeString, alias: recno4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: recno4 )
• recdate4 ( type: esriFieldTypeString, alias: recdate4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: recdate4 )
• rectype4 ( type: esriFieldTypeString, alias: rectype4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rectype4 )
• docfee4 ( type: esriFieldTypeString, alias: docfee4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: docfee4 )
• more_recs ( type: esriFieldTypeString, alias: more_recs, editable: true, nullable: true, length: 255, defaultValue: null, modelName: more_recs )
• acres ( type: esriFieldTypeString, alias: acres, editable: true, nullable: true, length: 255, defaultValue: null, modelName: acres )
• sqft ( type: esriFieldTypeString, alias: sqft, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sqft )
• zoning ( type: esriFieldTypeString, alias: zoning, editable: true, nullable: true, length: 255, defaultValue: null, modelName: zoning )
• water ( type: esriFieldTypeString, alias: water, editable: true, nullable: true, length: 255, defaultValue: null, modelName: water )
• sewer ( type: esriFieldTypeString, alias: sewer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sewer )
• utils ( type: esriFieldTypeString, alias: utils, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utils )
• access ( type: esriFieldTypeString, alias: access, editable: true, nullable: true, length: 255, defaultValue: null, modelName: access )
• topo ( type: esriFieldTypeString, alias: topo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: topo )
• scenic_view ( type: esriFieldTypeString, alias: scenic_view, editable: true, nullable: true, length: 255, defaultValue: null, modelName: scenic_view )
• cover ( type: esriFieldTypeString, alias: cover, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cover )
• hydro ( type: esriFieldTypeString, alias: hydro, editable: true, nullable: true, length: 255, defaultValue: null, modelName: hydro )
• misc ( type: esriFieldTypeString, alias: misc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: misc )
• impno ( type: esriFieldTypeString, alias: impno, editable: true, nullable: true, length: 255, defaultValue: null, modelName: impno )
• numstructs ( type: esriFieldTypeString, alias: numstructs, editable: true, nullable: true, length: 255, defaultValue: null, modelName: numstructs )
• proptype ( type: esriFieldTypeString, alias: proptype, editable: true, nullable: true, length: 255, defaultValue: null, modelName: proptype )
• style ( type: esriFieldTypeString, alias: style, editable: true, nullable: true, length: 255, defaultValue: null, modelName: style )
• styledesc ( type: esriFieldTypeString, alias: styledesc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: styledesc )
• units ( type: esriFieldTypeString, alias: units, editable: true, nullable: true, length: 255, defaultValue: null, modelName: units )
• year_blt ( type: esriFieldTypeString, alias: year_blt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: year_blt )
• adj_year_blt ( type: esriFieldTypeString, alias: adj_year_blt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: adj_year_blt )
• grade ( type: esriFieldTypeString, alias: grade, editable: true, nullable: true, length: 255, defaultValue: null, modelName: grade )
• cond ( type: esriFieldTypeString, alias: cond, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cond )
• xwall ( type: esriFieldTypeString, alias: xwall, editable: true, nullable: true, length: 255, defaultValue: null, modelName: xwall )
• heat ( type: esriFieldTypeString, alias: heat, editable: true, nullable: true, length: 255, defaultValue: null, modelName: heat )
• first_sqft ( type: esriFieldTypeString, alias: first_sqft, editable: true, nullable: true, length: 255, defaultValue: null, modelName: first_sqft )
• second_sqft ( type: esriFieldTypeString, alias: second_sqft, editable: true, nullable: true, length: 255, defaultValue: null, modelName: second_sqft )
• third_sqft ( type: esriFieldTypeString, alias: third_sqft, editable: true, nullable: true, length: 255, defaultValue: null, modelName: third_sqft )
• addn ( type: esriFieldTypeString, alias: addn, editable: true, nullable: true, length: 255, defaultValue: null, modelName: addn )
• fin_half ( type: esriFieldTypeString, alias: fin_half, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fin_half )
• fin_bsmt ( type: esriFieldTypeString, alias: fin_bsmt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fin_bsmt )
• unfin_bsmt ( type: esriFieldTypeString, alias: unfin_bsmt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: unfin_bsmt )
• sfla ( type: esriFieldTypeString, alias: sfla, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sfla )
• basement ( type: esriFieldTypeString, alias: basement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: basement )
• garage ( type: esriFieldTypeString, alias: garage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: garage )
• cars ( type: esriFieldTypeString, alias: cars, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cars )
• garage_size ( type: esriFieldTypeString, alias: garage_size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: garage_size )
• rooms ( type: esriFieldTypeString, alias: rooms, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rooms )
• beds ( type: esriFieldTypeString, alias: beds, editable: true, nullable: true, length: 255, defaultValue: null, modelName: beds )
• lofts ( type: esriFieldTypeString, alias: lofts, editable: true, nullable: true, length: 255, defaultValue: null, modelName: lofts )
• kitchen ( type: esriFieldTypeString, alias: kitchen, editable: true, nullable: true, length: 255, defaultValue: null, modelName: kitchen )
• m_baths ( type: esriFieldTypeString, alias: m_baths, editable: true, nullable: true, length: 255, defaultValue: null, modelName: m_baths )
• f_baths ( type: esriFieldTypeString, alias: f_baths, editable: true, nullable: true, length: 255, defaultValue: null, modelName: f_baths )
• t_baths ( type: esriFieldTypeString, alias: t_baths, editable: true, nullable: true, length: 255, defaultValue: null, modelName: t_baths )
• h_baths ( type: esriFieldTypeString, alias: h_baths, editable: true, nullable: true, length: 255, defaultValue: null, modelName: h_baths )
• q_baths ( type: esriFieldTypeString, alias: q_baths, editable: true, nullable: true, length: 255, defaultValue: null, modelName: q_baths )
• bath_tot ( type: esriFieldTypeString, alias: bath_tot, editable: true, nullable: true, length: 255, defaultValue: null, modelName: bath_tot )
• title ( type: esriFieldTypeString, alias: title, editable: true, nullable: true, length: 255, defaultValue: null, modelName: title )
• floor ( type: esriFieldTypeString, alias: floor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: floor )
• unit_position ( type: esriFieldTypeString, alias: unit_position, editable: true, nullable: true, length: 255, defaultValue: null, modelName: unit_position )
• biztype1 ( type: esriFieldTypeString, alias: biztype1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: biztype1 )
• biztype2 ( type: esriFieldTypeString, alias: biztype2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: biztype2 )
• biztype3 ( type: esriFieldTypeString, alias: biztype3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: biztype3 )
• more_com ( type: esriFieldTypeString, alias: more_com, editable: true, nullable: true, length: 255, defaultValue: null, modelName: more_com )
• n_leases ( type: esriFieldTypeString, alias: n_leases, editable: true, nullable: true, length: 255, defaultValue: null, modelName: n_leases )
• xcond ( type: esriFieldTypeString, alias: xcond, editable: true, nullable: true, length: 255, defaultValue: null, modelName: xcond )

Templates:

• Name: SDE.DBO.Adata
  Description:
  Prototype:
  n_leases: null
  xcond: null
  schno: null
  ppi: null
  subcode: null
  subdesc: null
  filing: null
  phase: null
  block: null
  lot: null
  legal1: null
  legal2: null
  legal3: null
  legal4: null
  legal_etal: null
  econ: null
  nhood: null
  house: null
  pdir: null
  name: null
  suff: null
  sdir: null
  unit: null
  town: null
  num: null
  abst1: null
  abst2: null
  abst3: null
  abst4: null
  more_abst: null
  totlandval: null
  totimpval: null
  totactval: null
  totassval: null
  tax_year: null
  tax_area: null
  mills: null
  p_ownerf: null
  p_ownerl: null
  s_ownerf: null
  s_ownerl: null
  owner_etal: null
  care_of: null
  address: null
  city: null
  state: null
  zip: null
  recno1: null
  recdate1: null
  rectype1: null
  docfee1: null
  recno2: null
  recdate2: null
  rectype2: null
  docfee2: null
  recno3: null
  recdate3: null
  rectype3: null
  docfee3: null
  recno4: null
  recdate4: null
  rectype4: null
  docfee4: null
  more_recs: null
  acres: null
  sqft: null
  zoning: null
  water: null
  sewer: null
  utils: null
  access: null
  topo: null
  scenic_view: null
  cover: null
  hydro: null
  misc: null
  impno: null
  numstructs: null
  proptype: null
  style: null
  styledesc: null
  units: null
  year_blt: null
  adj_year_blt: null
  grade: null
  cond: null
  xwall: null
  heat: null
  first_sqft: null
  second_sqft: null
  third_sqft: null
  addn: null
  fin_half: null
  fin_bsmt: null
  unfin_bsmt: null
  sfla: null
  basement: null
  garage: null
  cars: null
  garage_size: null
  rooms: null
  beds: null
  lofts: null
  kitchen: null
  m_baths: null
  f_baths: null
  t_baths: null
  h_baths: null
  q_baths: null
  bath_tot: null
  title: null
  floor: null
  unit_position: null
  biztype1: null
  biztype2: null
  biztype3: null
  more_com: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE.DBO.Parcels (0) -- Related To: SDE.DBO.Parcels (0)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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