View In:   ArcGIS Online Map Viewer

Name: Sales2023

Display Field: account

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 2f8375c3376244daa5d311aea2275a00

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 3236488.8198025525
YMin: 1380468.609267056
XMax: 3503323.4757647216
YMax: 1632246.5076131374
Spatial Reference: 102654  (2232)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: saletype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Cml
  Label: Cml
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [29, 102, 175, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Lnd
  Label: Lnd
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [112, 138, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Res
  Label: Res
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 211, 127, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: saletype

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• account ( modelName: account, nullable: true, editable: true, defaultValue: null, length: 10, alias: account, type: esriFieldTypeString )
• saletype ( modelName: saletype, nullable: true, editable: true, defaultValue: null, length: 3, alias: SaleType, type: esriFieldTypeString )
• subdiv ( modelName: subdiv, nullable: true, editable: true, defaultValue: null, length: 100, alias: subdiv, type: esriFieldTypeString )
• nbhd ( modelName: nbhd, nullable: true, editable: true, defaultValue: null, alias: NBHD, type: esriFieldTypeDouble )
• statedarea ( modelName: statedarea, nullable: true, editable: true, defaultValue: null, length: 50, alias: statedarea, type: esriFieldTypeString )
• saledate_1 ( modelName: saledate_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: SaleDate, type: esriFieldTypeString )
• adjsaleprice ( modelName: adjsaleprice, nullable: true, editable: true, defaultValue: null, length: 255, alias: AdjSalePrice, type: esriFieldTypeString )
• internalid ( modelName: internalid, nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNALID, type: esriFieldTypeString )
• locaddress ( modelName: locaddress, nullable: true, editable: true, defaultValue: null, length: 254, alias: locaddress, type: esriFieldTypeString )
• loccity ( modelName: loccity, nullable: true, editable: true, defaultValue: null, length: 40, alias: loccity, type: esriFieldTypeString )
• loczip ( modelName: loczip, nullable: true, editable: true, defaultValue: null, length: 10, alias: loczip, type: esriFieldTypeString )
• business ( modelName: business, nullable: true, editable: true, defaultValue: null, length: 100, alias: business, type: esriFieldTypeString )
• res ( modelName: res, nullable: true, editable: true, defaultValue: null, alias: res, type: esriFieldTypeInteger )
• outbldg ( modelName: outbldg, nullable: true, editable: true, defaultValue: null, alias: outbldg, type: esriFieldTypeInteger )
• yearbuilt ( modelName: yearbuilt, nullable: true, editable: true, defaultValue: null, length: 50, alias: yearbuilt, type: esriFieldTypeString )
• yrblt ( modelName: yrblt, nullable: true, editable: true, defaultValue: null, alias: YrBlt, type: esriFieldTypeDouble )
• resdsgn ( modelName: resdsgn, nullable: true, editable: true, defaultValue: null, length: 255, alias: ResDsgn, type: esriFieldTypeString )
• bedrooms ( modelName: bedrooms, nullable: true, editable: true, defaultValue: null, alias: Bedrooms, type: esriFieldTypeDouble )
• baths ( modelName: baths, nullable: true, editable: true, defaultValue: null, alias: Baths, type: esriFieldTypeDouble )
• book ( modelName: book, nullable: true, editable: true, defaultValue: null, length: 10, alias: book, type: esriFieldTypeString )
• page ( modelName: page, nullable: true, editable: true, defaultValue: null, length: 30, alias: page, type: esriFieldTypeString )
• receptnum ( modelName: receptnum, nullable: true, editable: true, defaultValue: null, length: 50, alias: receptnum, type: esriFieldTypeString )
• ressubarea ( modelName: ressubarea, nullable: true, editable: true, defaultValue: null, alias: ResSubArea, type: esriFieldTypeDouble )
• walkout ( modelName: walkout, nullable: true, editable: true, defaultValue: null, length: 255, alias: Walkout, type: esriFieldTypeString )
• bsmtfinarea ( modelName: bsmtfinarea, nullable: true, editable: true, defaultValue: null, alias: BsmtFinArea, type: esriFieldTypeDouble )
• bsmtunfarea ( modelName: bsmtunfarea, nullable: true, editable: true, defaultValue: null, alias: BsmtUnfArea, type: esriFieldTypeDouble )
• effyrblt ( modelName: effyrblt, nullable: true, editable: true, defaultValue: null, alias: EffYrBlt, type: esriFieldTypeDouble )
• mfghome ( modelName: mfghome, nullable: true, editable: true, defaultValue: null, length: 255, alias: MfgHome, type: esriFieldTypeString )
• quality ( modelName: quality, nullable: true, editable: true, defaultValue: null, length: 255, alias: Quality, type: esriFieldTypeString )
• condition ( modelName: condition, nullable: true, editable: true, defaultValue: null, length: 255, alias: Condition, type: esriFieldTypeString )
• fireplacefuel ( modelName: fireplacefuel, nullable: true, editable: true, defaultValue: null, length: 255, alias: FireplaceFuel, type: esriFieldTypeString )
• fireplace ( modelName: fireplace, nullable: true, editable: true, defaultValue: null, alias: Fireplace, type: esriFieldTypeDouble )
• garagetype ( modelName: garagetype, nullable: true, editable: true, defaultValue: null, length: 255, alias: GarageType, type: esriFieldTypeString )
• garagearea ( modelName: garagearea, nullable: true, editable: true, defaultValue: null, length: 255, alias: GarageArea, type: esriFieldTypeString )
• garage2type ( modelName: garage2type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Garage2Type, type: esriFieldTypeString )
• garage2area ( modelName: garage2area, nullable: true, editable: true, defaultValue: null, alias: Garage2Area, type: esriFieldTypeDouble )
• extwalltype ( modelName: extwalltype, nullable: true, editable: true, defaultValue: null, length: 255, alias: ExtWallType, type: esriFieldTypeString )
• cooling ( modelName: cooling, nullable: true, editable: true, defaultValue: null, length: 255, alias: Cooling, type: esriFieldTypeString )
• heatfuel ( modelName: heatfuel, nullable: true, editable: true, defaultValue: null, length: 255, alias: HeatFuel, type: esriFieldTypeString )
• heattype ( modelName: heattype, nullable: true, editable: true, defaultValue: null, length: 255, alias: HeatType, type: esriFieldTypeString )
• percmpl ( modelName: percmpl, nullable: true, editable: true, defaultValue: null, length: 255, alias: PerCmpl, type: esriFieldTypeString )
• roofcvr ( modelName: roofcvr, nullable: true, editable: true, defaultValue: null, length: 255, alias: RoofCvr, type: esriFieldTypeString )
• roofdsgn ( modelName: roofdsgn, nullable: true, editable: true, defaultValue: null, length: 255, alias: RoofDsgn, type: esriFieldTypeString )
• stovefuel ( modelName: stovefuel, nullable: true, editable: true, defaultValue: null, length: 255, alias: StoveFuel, type: esriFieldTypeString )
• carport ( modelName: carport, nullable: true, editable: true, defaultValue: null, alias: Carport, type: esriFieldTypeDouble )
• pavasph ( modelName: pavasph, nullable: true, editable: true, defaultValue: null, alias: PavAsph, type: esriFieldTypeDouble )
• pavconc ( modelName: pavconc, nullable: true, editable: true, defaultValue: null, alias: PavConc, type: esriFieldTypeDouble )
• prchencarea ( modelName: prchencarea, nullable: true, editable: true, defaultValue: null, alias: PrchEncArea, type: esriFieldTypeDouble )
• prchopenarea ( modelName: prchopenarea, nullable: true, editable: true, defaultValue: null, alias: PrchOpenArea, type: esriFieldTypeDouble )
• terracearea ( modelName: terracearea, nullable: true, editable: true, defaultValue: null, alias: TerraceArea, type: esriFieldTypeDouble )
• upperarea ( modelName: upperarea, nullable: true, editable: true, defaultValue: null, alias: UpperArea, type: esriFieldTypeDouble )
• balcarea ( modelName: balcarea, nullable: true, editable: true, defaultValue: null, alias: BalcArea, type: esriFieldTypeDouble )
• deckarea ( modelName: deckarea, nullable: true, editable: true, defaultValue: null, alias: DeckArea, type: esriFieldTypeDouble )
• abvgndarea ( modelName: abvgndarea, nullable: true, editable: true, defaultValue: null, alias: AbvGndArea, type: esriFieldTypeDouble )
• deckbalprchter ( modelName: deckbalprchter, nullable: true, editable: true, defaultValue: null, alias: DeckBalPrchTer, type: esriFieldTypeDouble )
• pavingarea ( modelName: pavingarea, nullable: true, editable: true, defaultValue: null, alias: PavingArea, type: esriFieldTypeDouble )
• gararea ( modelName: gararea, nullable: true, editable: true, defaultValue: null, alias: GarArea, type: esriFieldTypeDouble )
• xfobval ( modelName: xfobval, nullable: true, editable: true, defaultValue: null, alias: XFOBVal, type: esriFieldTypeDouble )
• parcelid ( modelName: parcelid, nullable: true, editable: true, defaultValue: null, length: 30, alias: parcelid, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
• saledateonly ( nullable: true, editable: true, defaultValue: null, alias: SaleDateOnly, type: esriFieldTypeDateOnly )
• saledatefull ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: saledatefull, type: esriFieldTypeDate )

Types:

ID: Cml
Name: Cml
Domains:
Templates:
• Name: Cml
  Description:
  Prototype:
  nbhd: null
  abvgndarea: null
  xfobval: null
  loccity: null
  percmpl: null
  prchopenarea: null
  subdiv: null
  parcelid: null
  outbldg: null
  effyrblt: null
  saledate_1: null
  deckbalprchter: null
  res: null
  extwalltype: null
  pavasph: null
  stovefuel: null
  pavconc: null
  ressubarea: null
  statedarea: null
  bsmtunfarea: null
  quality: null
  bedrooms: null
  garage2type: null
  internalid: null
  condition: null
  resdsgn: null
  roofcvr: null
  cooling: null
  bsmtfinarea: null
  page: null
  mfghome: null
  terracearea: null
  heattype: null
  book: null
  garagearea: null
  walkout: null
  fireplace: null
  heatfuel: null
  balcarea: null
  roofdsgn: null
  receptnum: null
  carport: null
  adjsaleprice: null
  business: null
  garagetype: null
  locaddress: null
  yearbuilt: null
  yrblt: null
  baths: null
  garage2area: null
  saletype: Cml
  loczip: null
  gararea: null
  fireplacefuel: null
  deckarea: null
  pavingarea: null
  upperarea: null
  account: null
  prchencarea: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Lnd
Name: Lnd
Domains:
Templates:
• Name: Lnd
  Description:
  Prototype:
  nbhd: null
  abvgndarea: null
  xfobval: null
  loccity: null
  percmpl: null
  prchopenarea: null
  subdiv: null
  parcelid: null
  outbldg: null
  effyrblt: null
  saledate_1: null
  deckbalprchter: null
  res: null
  extwalltype: null
  pavasph: null
  stovefuel: null
  pavconc: null
  ressubarea: null
  statedarea: null
  bsmtunfarea: null
  quality: null
  bedrooms: null
  garage2type: null
  internalid: null
  condition: null
  resdsgn: null
  roofcvr: null
  cooling: null
  bsmtfinarea: null
  page: null
  mfghome: null
  terracearea: null
  heattype: null
  book: null
  garagearea: null
  walkout: null
  fireplace: null
  heatfuel: null
  balcarea: null
  roofdsgn: null
  receptnum: null
  carport: null
  adjsaleprice: null
  business: null
  garagetype: null
  locaddress: null
  yearbuilt: null
  yrblt: null
  baths: null
  garage2area: null
  saletype: Lnd
  loczip: null
  gararea: null
  fireplacefuel: null
  deckarea: null
  pavingarea: null
  upperarea: null
  account: null
  prchencarea: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Res
Name: Res
Domains:
Templates:
• Name: Res
  Description:
  Prototype:
  nbhd: null
  abvgndarea: null
  xfobval: null
  loccity: null
  percmpl: null
  prchopenarea: null
  subdiv: null
  parcelid: null
  outbldg: null
  effyrblt: null
  saledate_1: null
  deckbalprchter: null
  res: null
  extwalltype: null
  pavasph: null
  stovefuel: null
  pavconc: null
  ressubarea: null
  statedarea: null
  bsmtunfarea: null
  quality: null
  bedrooms: null
  garage2type: null
  internalid: null
  condition: null
  resdsgn: null
  roofcvr: null
  cooling: null
  bsmtfinarea: null
  page: null
  mfghome: null
  terracearea: null
  heattype: null
  book: null
  garagearea: null
  walkout: null
  fireplace: null
  heatfuel: null
  balcarea: null
  roofdsgn: null
  receptnum: null
  carport: null
  adjsaleprice: null
  business: null
  garagetype: null
  locaddress: null
  yearbuilt: null
  yrblt: null
  baths: null
  garage2area: null
  saletype: Res
  loczip: null
  gararea: null
  fireplacefuel: null
  deckarea: null
  pavingarea: null
  upperarea: null
  account: null
  prchencarea: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata