Name: tbl_ParcelBuilding

Display Field: BuildingName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 561eec4e04ea4491a68ac3d238d6264d

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

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

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:

• ParcelBuildingRowID ( type: esriFieldTypeOID, alias: ParcelBuildingRowID, editable: false, nullable: false, defaultValue: null, modelName: ParcelBuildingRowID )
• ParcelID ( type: esriFieldTypeString, alias: ParcelID, editable: false, nullable: false, length: 20, defaultValue: null, modelName: ParcelID )
• CardNumber ( type: esriFieldTypeInteger, alias: CardNumber, editable: false, nullable: true, defaultValue: null, modelName: CardNumber )
• BuildingName ( type: esriFieldTypeString, alias: BuildingName, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BuildingName )
• BuildingTypeDescription ( type: esriFieldTypeString, alias: BuildingTypeDescription, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BuildingTypeDescription )
• BuildingStyleStoryDescription ( type: esriFieldTypeString, alias: BuildingStyleStoryDescription, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BuildingStyleStoryDescription )
• YearBuilt ( type: esriFieldTypeString, alias: YearBuilt, editable: false, nullable: true, length: 4, defaultValue: null, modelName: YearBuilt )
• FoundationTypeDescr ( type: esriFieldTypeString, alias: FoundationTypeDescr, editable: false, nullable: true, length: 50, defaultValue: null, modelName: FoundationTypeDescr )
• SubFloorDescr ( type: esriFieldTypeString, alias: SubFloorDescr, editable: false, nullable: true, length: 50, defaultValue: null, modelName: SubFloorDescr )
• ExteriorWallDescrPrimary ( type: esriFieldTypeString, alias: ExteriorWallDescrPrimary, editable: false, nullable: true, length: 50, defaultValue: null, modelName: ExteriorWallDescrPrimary )
• ExteriorWallDescrSecondary ( type: esriFieldTypeString, alias: ExteriorWallDescrSecondary, editable: false, nullable: true, length: 50, defaultValue: null, modelName: ExteriorWallDescrSecondary )
• RoofStructureDescr ( type: esriFieldTypeString, alias: RoofStructureDescr, editable: false, nullable: true, length: 50, defaultValue: null, modelName: RoofStructureDescr )
• RoofCoverDescr ( type: esriFieldTypeString, alias: RoofCoverDescr, editable: false, nullable: true, length: 50, defaultValue: null, modelName: RoofCoverDescr )
• InteriorWallDescrPrimary ( type: esriFieldTypeString, alias: InteriorWallDescrPrimary, editable: false, nullable: true, length: 50, defaultValue: null, modelName: InteriorWallDescrPrimary )
• InteriorWallDescrSecondary ( type: esriFieldTypeString, alias: InteriorWallDescrSecondary, editable: false, nullable: true, length: 50, defaultValue: null, modelName: InteriorWallDescrSecondary )
• FloorCoverDescrPrimary ( type: esriFieldTypeString, alias: FloorCoverDescrPrimary, editable: false, nullable: true, length: 50, defaultValue: null, modelName: FloorCoverDescrPrimary )
• FloorCoverDescrSecondary ( type: esriFieldTypeString, alias: FloorCoverDescrSecondary, editable: false, nullable: true, length: 50, defaultValue: null, modelName: FloorCoverDescrSecondary )
• HeatFuelDescr ( type: esriFieldTypeString, alias: HeatFuelDescr, editable: false, nullable: true, length: 50, defaultValue: null, modelName: HeatFuelDescr )
• HeatTypeDescr ( type: esriFieldTypeString, alias: HeatTypeDescr, editable: false, nullable: true, length: 50, defaultValue: null, modelName: HeatTypeDescr )
• AirConditionTypeDesc ( type: esriFieldTypeString, alias: AirConditionTypeDesc, editable: false, nullable: true, length: 50, defaultValue: null, modelName: AirConditionTypeDesc )
• FirePlaceDescr ( type: esriFieldTypeString, alias: FirePlaceDescr, editable: false, nullable: true, length: 50, defaultValue: null, modelName: FirePlaceDescr )
• BedroomsLowerLevel ( type: esriFieldTypeInteger, alias: BedroomsLowerLevel, editable: false, nullable: true, defaultValue: null, modelName: BedroomsLowerLevel )
• BedroomsBaseLevel ( type: esriFieldTypeInteger, alias: BedroomsBaseLevel, editable: false, nullable: true, defaultValue: null, modelName: BedroomsBaseLevel )
• BedroomsUpperLevel ( type: esriFieldTypeInteger, alias: BedroomsUpperLevel, editable: false, nullable: true, defaultValue: null, modelName: BedroomsUpperLevel )
• HalfBathLowerLevel ( type: esriFieldTypeInteger, alias: HalfBathLowerLevel, editable: false, nullable: true, defaultValue: null, modelName: HalfBathLowerLevel )
• HalfBathBaseLevel ( type: esriFieldTypeInteger, alias: HalfBathBaseLevel, editable: false, nullable: true, defaultValue: null, modelName: HalfBathBaseLevel )
• HalfBathUpperLevel ( type: esriFieldTypeInteger, alias: HalfBathUpperLevel, editable: false, nullable: true, defaultValue: null, modelName: HalfBathUpperLevel )
• FullBathLowerLevel ( type: esriFieldTypeInteger, alias: FullBathLowerLevel, editable: false, nullable: true, defaultValue: null, modelName: FullBathLowerLevel )
• FullBathBaseLevel ( type: esriFieldTypeInteger, alias: FullBathBaseLevel, editable: false, nullable: true, defaultValue: null, modelName: FullBathBaseLevel )
• FullBathUpperLevel ( type: esriFieldTypeInteger, alias: FullBathUpperLevel, editable: false, nullable: true, defaultValue: null, modelName: FullBathUpperLevel )
• BasementGarage ( type: esriFieldTypeInteger, alias: BasementGarage, editable: false, nullable: true, defaultValue: null, modelName: BasementGarage )
• SumTotalFinishedSqFt ( type: esriFieldTypeInteger, alias: SumTotalFinishedSqFt, editable: false, nullable: true, defaultValue: null, modelName: SumTotalFinishedSqFt )
• SumTotalNumberBedrooms ( type: esriFieldTypeInteger, alias: SumTotalNumberBedrooms, editable: false, nullable: true, defaultValue: null, modelName: SumTotalNumberBedrooms )
• SumTotalNumberFullBaths ( type: esriFieldTypeInteger, alias: SumTotalNumberFullBaths, editable: false, nullable: true, defaultValue: null, modelName: SumTotalNumberFullBaths )
• SumTotalNumberHalfBaths ( type: esriFieldTypeInteger, alias: SumTotalNumberHalfBaths, editable: false, nullable: true, defaultValue: null, modelName: SumTotalNumberHalfBaths )
• AirConditionPercent ( type: esriFieldTypeInteger, alias: AirConditionPercent, editable: false, nullable: true, defaultValue: null, modelName: AirConditionPercent )
• HeatingPercent ( type: esriFieldTypeInteger, alias: HeatingPercent, editable: false, nullable: true, defaultValue: null, modelName: HeatingPercent )
• SketchImage ( type: esriFieldTypeBlob, alias: SketchImage, editable: false, nullable: true, defaultValue: null, modelName: SketchImage )

Templates:

• Name: tbl_ParcelBuilding
  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:

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