Name: tb_allbuildings

Display Field: extwall

Type: Table

Geometry Type: N/A

Description:

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: 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
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 )
• yearid ( type: esriFieldTypeSmallInteger, alias: yearid, editable: false, nullable: false, defaultValue: null, modelName: yearid )
• propertyid ( type: esriFieldTypeInteger, alias: propertyid, editable: false, nullable: false, defaultValue: null, modelName: propertyid )
• buildingid ( type: esriFieldTypeInteger, alias: buildingid, editable: false, nullable: false, defaultValue: null, modelName: buildingid )
• versionid ( type: esriFieldTypeInteger, alias: versionid, editable: false, nullable: true, defaultValue: null, modelName: versionid )
• buildingsequence ( type: esriFieldTypeInteger, alias: buildingsequence, editable: false, nullable: true, defaultValue: null, modelName: buildingsequence )
• extwall ( type: esriFieldTypeString, alias: extwall, editable: false, nullable: true, length: 100, defaultValue: null, modelName: extwall )
• storyheight ( type: esriFieldTypeString, alias: storyheight, editable: false, nullable: true, length: 50, defaultValue: null, modelName: storyheight )
• buildingtypecode ( type: esriFieldTypeString, alias: buildingtypecode, editable: false, nullable: true, length: 10, defaultValue: null, modelName: buildingtypecode )
• buildingtype ( type: esriFieldTypeString, alias: buildingtype, editable: false, nullable: true, length: 100, defaultValue: null, modelName: buildingtype )
• foundation ( type: esriFieldTypeString, alias: foundation, editable: false, nullable: true, length: 100, defaultValue: null, modelName: foundation )
• internalwall ( type: esriFieldTypeString, alias: internalwall, editable: false, nullable: true, length: 100, defaultValue: null, modelName: internalwall )
• roofcover ( type: esriFieldTypeString, alias: roofcover, editable: false, nullable: true, length: 100, defaultValue: null, modelName: roofcover )
• heat ( type: esriFieldTypeString, alias: heat, editable: false, nullable: true, length: 100, defaultValue: null, modelName: heat )
• heatfuel ( type: esriFieldTypeString, alias: heatfuel, editable: false, nullable: true, length: 100, defaultValue: null, modelName: heatfuel )
• frame ( type: esriFieldTypeString, alias: frame, editable: false, nullable: true, length: 50, defaultValue: null, modelName: frame )
• yearbuilt ( type: esriFieldTypeSmallInteger, alias: yearbuilt, editable: false, nullable: true, defaultValue: null, modelName: yearbuilt )
• effectiveyearbuilt ( type: esriFieldTypeSmallInteger, alias: effectiveyearbuilt, editable: false, nullable: true, defaultValue: null, modelName: effectiveyearbuilt )
• fullbath ( type: esriFieldTypeSmallInteger, alias: fullbath, editable: false, nullable: true, defaultValue: null, modelName: fullbath )
• halfbath ( type: esriFieldTypeSmallInteger, alias: halfbath, editable: false, nullable: true, defaultValue: null, modelName: halfbath )
• threequarterbath ( type: esriFieldTypeInteger, alias: threequarterbath, editable: false, nullable: true, defaultValue: null, modelName: threequarterbath )
• fireplaces ( type: esriFieldTypeInteger, alias: fireplaces, editable: false, nullable: true, defaultValue: null, modelName: fireplaces )
• basementgarage ( type: esriFieldTypeInteger, alias: basementgarage, editable: false, nullable: true, defaultValue: null, modelName: basementgarage )
• percentheated ( type: esriFieldTypeSingle, alias: percentheated, editable: false, nullable: true, defaultValue: null, modelName: percentheated )
• percentairconditioned ( type: esriFieldTypeSingle, alias: percentairconditioned, editable: false, nullable: true, defaultValue: null, modelName: percentairconditioned )
• commercialunits ( type: esriFieldTypeInteger, alias: commercialunits, editable: false, nullable: true, defaultValue: null, modelName: commercialunits )
• residentialunits ( type: esriFieldTypeInteger, alias: residentialunits, editable: false, nullable: true, defaultValue: null, modelName: residentialunits )
• condofloorsinbuilding ( type: esriFieldTypeInteger, alias: condofloorsinbuilding, editable: false, nullable: true, defaultValue: null, modelName: condofloorsinbuilding )
• finishedarea ( type: esriFieldTypeInteger, alias: finishedarea, editable: false, nullable: true, defaultValue: null, modelName: finishedarea )
• totalarea ( type: esriFieldTypeInteger, alias: totalarea, editable: false, nullable: true, defaultValue: null, modelName: totalarea )
• bedrooms ( type: esriFieldTypeInteger, alias: bedrooms, editable: false, nullable: true, defaultValue: null, modelName: bedrooms )
• grade ( type: esriFieldTypeString, alias: grade, editable: false, nullable: true, length: 100, defaultValue: null, modelName: grade )
• base_area ( type: esriFieldTypeInteger, alias: base_area, editable: false, nullable: true, defaultValue: null, modelName: base_area )
• semi_finished_basement ( type: esriFieldTypeInteger, alias: semi_finished_basement, editable: false, nullable: true, defaultValue: null, modelName: semi_finished_basement )
• unfinished_garage ( type: esriFieldTypeInteger, alias: unfinished_garage, editable: false, nullable: true, defaultValue: null, modelName: unfinished_garage )
• finished_garage ( type: esriFieldTypeInteger, alias: finished_garage, editable: false, nullable: true, defaultValue: null, modelName: finished_garage )
• finished_attic ( type: esriFieldTypeInteger, alias: finished_attic, editable: false, nullable: true, defaultValue: null, modelName: finished_attic )
• total_garage_area ( type: esriFieldTypeInteger, alias: total_garage_area, editable: false, nullable: true, defaultValue: null, modelName: total_garage_area )
• total_carport_area ( type: esriFieldTypeInteger, alias: total_carport_area, editable: false, nullable: true, defaultValue: null, modelName: total_carport_area )
• buildingcategorydescription ( type: esriFieldTypeString, alias: buildingcategorydescription, editable: false, nullable: true, length: 50, defaultValue: null, modelName: buildingcategorydescription )
• heat2description ( type: esriFieldTypeString, alias: heat2description, editable: false, nullable: true, length: 50, defaultValue: null, modelName: heat2description )
• parcelid ( type: esriFieldTypeString, alias: parcelid, editable: false, nullable: true, length: 100, defaultValue: null, modelName: parcelid )

Templates:

• Name: tb_allbuildings
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

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

Child Resources:   Field Groups   Contingent Values

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