Name: Improvements

Display Field: PID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Feature Draw Order:

N/A

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: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PID ( type: esriFieldTypeString, alias: PID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PID )
• AccountNumber ( type: esriFieldTypeString, alias: AccountNumber, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AccountNumber )
• GPIN ( type: esriFieldTypeString, alias: GPIN, editable: true, nullable: false, length: 20, defaultValue: null, modelName: GPIN )
• PARCELID ( type: esriFieldTypeString, alias: PARCELID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PARCELID )
• BID ( type: esriFieldTypeString, alias: BID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BID )
• BUILDINGNUMBER ( type: esriFieldTypeString, alias: BUILDINGNUMBER, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BUILDINGNUMBER )
• STORIES ( type: esriFieldTypeString, alias: STORIES, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STORIES )
• EXTERIORWALL1 ( type: esriFieldTypeString, alias: EXTERIORWALL1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EXTERIORWALL1 )
• EXTERIORWALL2 ( type: esriFieldTypeString, alias: EXTERIORWALL2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EXTERIORWALL2 )
• FOUNDATION ( type: esriFieldTypeString, alias: FOUNDATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FOUNDATION )
• ROOFCOVER ( type: esriFieldTypeString, alias: ROOFCOVER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ROOFCOVER )
• ROOFTYPE ( type: esriFieldTypeString, alias: ROOFTYPE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ROOFTYPE )
• HEATTYPE ( type: esriFieldTypeString, alias: HEATTYPE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HEATTYPE )
• CENTRALAIR ( type: esriFieldTypeString, alias: CENTRALAIR, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CENTRALAIR )
• HEATTYPE2 ( type: esriFieldTypeString, alias: HEATTYPE2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HEATTYPE2 )
• CENTRALAIR2 ( type: esriFieldTypeString, alias: CENTRALAIR2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CENTRALAIR2 )
• HEATTYPE3 ( type: esriFieldTypeString, alias: HEATTYPE3, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HEATTYPE3 )
• CENTRALAIR3 ( type: esriFieldTypeString, alias: CENTRALAIR3, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CENTRALAIR3 )
• TOTALROOMS ( type: esriFieldTypeString, alias: TOTALROOMS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TOTALROOMS )
• NUMBERBEDROOMS ( type: esriFieldTypeString, alias: NUMBERBEDROOMS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NUMBERBEDROOMS )
• FULLBATHS ( type: esriFieldTypeString, alias: FULLBATHS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FULLBATHS )
• HALFBATHS ( type: esriFieldTypeString, alias: HALFBATHS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HALFBATHS )
• SINKS ( type: esriFieldTypeString, alias: SINKS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SINKS )
• SHOWERSTALLS ( type: esriFieldTypeString, alias: SHOWERSTALLS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SHOWERSTALLS )
• FIREPLACES ( type: esriFieldTypeString, alias: FIREPLACES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FIREPLACES )
• DORMERS ( type: esriFieldTypeString, alias: DORMERS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DORMERS )
• ATTICFLOOR ( type: esriFieldTypeString, alias: ATTICFLOOR, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ATTICFLOOR )
• ATTICSTAIRS ( type: esriFieldTypeString, alias: ATTICSTAIRS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ATTICSTAIRS )
• LIVINGAREA ( type: esriFieldTypeString, alias: LIVINGAREA, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LIVINGAREA )
• YEARBUILT ( type: esriFieldTypeString, alias: YEARBUILT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: YEARBUILT )
• REMODELCODE ( type: esriFieldTypeString, alias: REMODELCODE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: REMODELCODE )
• YEARREMODELED ( type: esriFieldTypeString, alias: YEARREMODELED, editable: true, nullable: true, length: 100, defaultValue: null, modelName: YEARREMODELED )
• COMMRSTYLE ( type: esriFieldTypeString, alias: COMMRSTYLE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COMMRSTYLE )
• COMMRSTORIES ( type: esriFieldTypeString, alias: COMMRSTORIES, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COMMRSTORIES )
• TOTALAREA ( type: esriFieldTypeString, alias: TOTALAREA, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TOTALAREA )
• OCCUPANCY1 ( type: esriFieldTypeString, alias: OCCUPANCY1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OCCUPANCY1 )
• OCCUPANCY2 ( type: esriFieldTypeString, alias: OCCUPANCY2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OCCUPANCY2 )
• OCCUPANCY3 ( type: esriFieldTypeString, alias: OCCUPANCY3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OCCUPANCY3 )
• FRONTWALL1 ( type: esriFieldTypeString, alias: FRONTWALL1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FRONTWALL1 )
• FRONTWALL2 ( type: esriFieldTypeString, alias: FRONTWALL2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FRONTWALL2 )
• HVAC1 ( type: esriFieldTypeString, alias: HVAC1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HVAC1 )
• HVAC2 ( type: esriFieldTypeString, alias: HVAC2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HVAC2 )
• HVAC3 ( type: esriFieldTypeString, alias: HVAC3, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HVAC3 )
• ELEVATORS ( type: esriFieldTypeString, alias: ELEVATORS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ELEVATORS )
• NUMELEVATORS ( type: esriFieldTypeString, alias: NUMELEVATORS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NUMELEVATORS )
• SPRINKLERS ( type: esriFieldTypeString, alias: SPRINKLERS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SPRINKLERS )
• BasementGarageDoors ( type: esriFieldTypeString, alias: BasementGarageDoors, editable: true, nullable: true, length: 40, defaultValue: null, modelName: BasementGarageDoors )
• BasementGarage ( type: esriFieldTypeString, alias: BasementGarage, editable: true, nullable: true, length: 40, defaultValue: null, modelName: BasementGarage )
• FinishedBasementPercent ( type: esriFieldTypeInteger, alias: FinishedBasementPercent, editable: true, nullable: true, defaultValue: null, modelName: FinishedBasementPercent )
• FoundationConstruction ( type: esriFieldTypeString, alias: FoundationConstruction, editable: true, nullable: true, length: 40, defaultValue: null, modelName: FoundationConstruction )
• BuildingClass ( type: esriFieldTypeString, alias: BuildingClass, editable: true, nullable: true, length: 40, defaultValue: null, modelName: BuildingClass )
• RESYEARBUILT ( type: esriFieldTypeString, alias: RESYEARBUILT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RESYEARBUILT )
• RESIDENTIALSTYLE ( type: esriFieldTypeString, alias: RESIDENTIALSTYLE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RESIDENTIALSTYLE )
• INTERIORWALL1 ( type: esriFieldTypeString, alias: INTERIORWALL1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INTERIORWALL1 )
• INTERIORFLOORCOVERING ( type: esriFieldTypeString, alias: INTERIORFLOORCOVERING, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INTERIORFLOORCOVERING )
• FIREPLACETYPE ( type: esriFieldTypeString, alias: FIREPLACETYPE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FIREPLACETYPE )
• COMYEARBUILT ( type: esriFieldTypeString, alias: COMYEARBUILT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMYEARBUILT )

Templates:

• Name: Improvements
  Description:
  Prototype:
  FIREPLACETYPE: null
  PID: null
  AccountNumber: null
  GPIN:
  PARCELID: null
  BID: null
  BUILDINGNUMBER: null
  STORIES: null
  EXTERIORWALL1: null
  EXTERIORWALL2: null
  FOUNDATION: null
  ROOFCOVER: null
  ROOFTYPE: null
  HEATTYPE: null
  CENTRALAIR: null
  HEATTYPE2: null
  CENTRALAIR2: null
  HEATTYPE3: null
  CENTRALAIR3: null
  TOTALROOMS: null
  NUMBERBEDROOMS: null
  FULLBATHS: null
  HALFBATHS: null
  SINKS: null
  SHOWERSTALLS: null
  FIREPLACES: null
  DORMERS: null
  ATTICFLOOR: null
  ATTICSTAIRS: null
  LIVINGAREA: null
  YEARBUILT: null
  REMODELCODE: null
  YEARREMODELED: null
  COMMRSTYLE: null
  COMMRSTORIES: null
  TOTALAREA: null
  OCCUPANCY1: null
  OCCUPANCY2: null
  OCCUPANCY3: null
  FRONTWALL1: null
  FRONTWALL2: null
  HVAC1: null
  HVAC2: null
  HVAC3: null
  ELEVATORS: null
  NUMELEVATORS: null
  SPRINKLERS: null
  BasementGarageDoors: null
  BasementGarage: null
  FinishedBasementPercent: null
  FoundationConstruction: null
  BuildingClass: null
  RESYEARBUILT: null
  RESIDENTIALSTYLE: null
  INTERIORWALL1: null
  INTERIORFLOORCOVERING: null
  COMYEARBUILT: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata