Name: vw_Parcel_Details

Display Field: LocationStreetName

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: false

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:

• RowID ( type: esriFieldTypeDouble, alias: RowID, editable: true, nullable: true, defaultValue: null, modelName: RowID )
• ParcelID ( type: esriFieldTypeString, alias: ParcelID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: ParcelID )
• CardNumber ( type: esriFieldTypeInteger, alias: CardNumber, editable: true, nullable: true, defaultValue: null, modelName: CardNumber )
• AccountNumber ( type: esriFieldTypeDouble, alias: AccountNumber, editable: true, nullable: true, defaultValue: null, modelName: AccountNumber )
• LocationAddressForDisplay ( type: esriFieldTypeString, alias: LocationAddressForDisplay, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LocationAddressForDisplay )
• LocationAddressNumber ( type: esriFieldTypeInteger, alias: LocationAddressNumber, editable: true, nullable: true, defaultValue: null, modelName: LocationAddressNumber )
• LocationPreDirection ( type: esriFieldTypeString, alias: LocationPreDirection, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LocationPreDirection )
• LocationStreetName ( type: esriFieldTypeString, alias: LocationStreetName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationStreetName )
• LocationStreetSuffix ( type: esriFieldTypeString, alias: LocationStreetSuffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LocationStreetSuffix )
• LocationUnitNumber ( type: esriFieldTypeString, alias: LocationUnitNumber, editable: true, nullable: true, length: 6, defaultValue: null, modelName: LocationUnitNumber )
• ND_DataBuildingExteriorType ( type: esriFieldTypeString, alias: ND_DataBuildingExteriorType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ND_DataBuildingExteriorType )
• ND_YearBuilt ( type: esriFieldTypeString, alias: ND_YearBuilt, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ND_YearBuilt )
• ND_ExteriorWall_1Desc ( type: esriFieldTypeString, alias: ND_ExteriorWall_1Desc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ND_ExteriorWall_1Desc )
• ND_ExteriorWall_2Desc ( type: esriFieldTypeString, alias: ND_ExteriorWall_2Desc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ND_ExteriorWall_2Desc )
• ND_RoofStructureDescr ( type: esriFieldTypeString, alias: ND_RoofStructureDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ND_RoofStructureDescr )
• ND_TotalBedroms ( type: esriFieldTypeString, alias: ND_TotalBedroms, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ND_TotalBedroms )
• ND_TotalFullBaths ( type: esriFieldTypeString, alias: ND_TotalFullBaths, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ND_TotalFullBaths )
• ND_TotalHalfBaths ( type: esriFieldTypeString, alias: ND_TotalHalfBaths, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ND_TotalHalfBaths )
• BuildingTypeDescription ( type: esriFieldTypeString, alias: BuildingTypeDescription, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BuildingTypeDescription )
• YearBuilt ( type: esriFieldTypeString, alias: YearBuilt, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YearBuilt )
• TotalFinSqFt ( type: esriFieldTypeInteger, alias: TotalFinSqFt, editable: true, nullable: true, defaultValue: null, modelName: TotalFinSqFt )
• StyleDescr ( type: esriFieldTypeString, alias: StyleDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StyleDescr )
• TotalBedrooms ( type: esriFieldTypeInteger, alias: TotalBedrooms, editable: true, nullable: true, defaultValue: null, modelName: TotalBedrooms )
• TotalFullBaths ( type: esriFieldTypeInteger, alias: TotalFullBaths, editable: true, nullable: true, defaultValue: null, modelName: TotalFullBaths )
• TotalHalfBaths ( type: esriFieldTypeInteger, alias: TotalHalfBaths, editable: true, nullable: true, defaultValue: null, modelName: TotalHalfBaths )
• AirConditionTypeDesc ( type: esriFieldTypeString, alias: AirConditionTypeDesc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AirConditionTypeDesc )
• BuildingBasementGarage ( type: esriFieldTypeInteger, alias: BuildingBasementGarage, editable: true, nullable: true, defaultValue: null, modelName: BuildingBasementGarage )
• FoundationTypeDescr ( type: esriFieldTypeString, alias: FoundationTypeDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FoundationTypeDescr )
• RoofStructureDescr ( type: esriFieldTypeString, alias: RoofStructureDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoofStructureDescr )
• RoofCoverDescr ( type: esriFieldTypeString, alias: RoofCoverDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoofCoverDescr )
• ExteriorWallDescrPrimary ( type: esriFieldTypeString, alias: ExteriorWallDescrPrimary, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExteriorWallDescrPrimary )
• ExteriorWallDescrSecondary ( type: esriFieldTypeString, alias: ExteriorWallDescrSecondary, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExteriorWallDescrSecondary )
• InteriorWallDescrPrimary ( type: esriFieldTypeString, alias: InteriorWallDescrPrimary, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InteriorWallDescrPrimary )
• InteriorWallDescrSecondary ( type: esriFieldTypeString, alias: InteriorWallDescrSecondary, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InteriorWallDescrSecondary )
• FloorCoverDescrPrimary ( type: esriFieldTypeString, alias: FloorCoverDescrPrimary, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FloorCoverDescrPrimary )
• FloorCoverDescrSecondary ( type: esriFieldTypeString, alias: FloorCoverDescrSecondary, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FloorCoverDescrSecondary )
• HeatTypeDescr ( type: esriFieldTypeString, alias: HeatTypeDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HeatTypeDescr )
• HeatFuelDescr ( type: esriFieldTypeString, alias: HeatFuelDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HeatFuelDescr )
• FirePlaceDescr ( type: esriFieldTypeString, alias: FirePlaceDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FirePlaceDescr )
• SketchImage ( type: esriFieldTypeBlob, alias: SketchImage, editable: true, nullable: true, defaultValue: null, modelName: SketchImage )
• BedroomsBaseLevel ( type: esriFieldTypeInteger, alias: BedroomsBaseLevel, editable: true, nullable: true, defaultValue: null, modelName: BedroomsBaseLevel )
• BedroomsLowerLevel ( type: esriFieldTypeInteger, alias: BedroomsLowerLevel, editable: true, nullable: true, defaultValue: null, modelName: BedroomsLowerLevel )
• BedroomsUpperLevel ( type: esriFieldTypeInteger, alias: BedroomsUpperLevel, editable: true, nullable: true, defaultValue: null, modelName: BedroomsUpperLevel )
• BuildingName ( type: esriFieldTypeString, alias: BuildingName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BuildingName )
• FullBathBaseLevel ( type: esriFieldTypeInteger, alias: FullBathBaseLevel, editable: true, nullable: true, defaultValue: null, modelName: FullBathBaseLevel )
• FullBathLowerLevel ( type: esriFieldTypeInteger, alias: FullBathLowerLevel, editable: true, nullable: true, defaultValue: null, modelName: FullBathLowerLevel )
• FullBathUpperLevel ( type: esriFieldTypeInteger, alias: FullBathUpperLevel, editable: true, nullable: true, defaultValue: null, modelName: FullBathUpperLevel )
• HalfBathBaseLevel ( type: esriFieldTypeInteger, alias: HalfBathBaseLevel, editable: true, nullable: true, defaultValue: null, modelName: HalfBathBaseLevel )
• HalfBathLowerLevel ( type: esriFieldTypeInteger, alias: HalfBathLowerLevel, editable: true, nullable: true, defaultValue: null, modelName: HalfBathLowerLevel )
• HalfBathUpperLevel ( type: esriFieldTypeInteger, alias: HalfBathUpperLevel, editable: true, nullable: true, defaultValue: null, modelName: HalfBathUpperLevel )
• SubFloorDescr ( type: esriFieldTypeString, alias: SubFloorDescr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SubFloorDescr )
• ParcelCardRowID ( type: esriFieldTypeInteger, alias: ParcelCardRowID, editable: true, nullable: false, defaultValue: null, modelName: ParcelCardRowID )
• ParcelBuildingRowID ( type: esriFieldTypeInteger, alias: ParcelBuildingRowID, editable: true, nullable: true, defaultValue: null, modelName: ParcelBuildingRowID )
• SumThisCardSFYIOnlyValue ( type: esriFieldTypeDouble, alias: SumThisCardSFYIOnlyValue, editable: true, nullable: true, defaultValue: null, modelName: SumThisCardSFYIOnlyValue )
• SumThisCardBuildingOnlyValue ( type: esriFieldTypeDouble, alias: SumThisCardBuildingOnlyValue, editable: true, nullable: true, defaultValue: null, modelName: SumThisCardBuildingOnlyValue )
• ParcelID_LocationAddress_details ( type: esriFieldTypeString, alias: ParcelID_LocationAddress_details, editable: true, nullable: true, length: 123, defaultValue: null, modelName: ParcelID_LocationAddress_details )
• AirConditionPercent ( type: esriFieldTypeInteger, alias: AirConditionPercent, editable: true, nullable: true, defaultValue: null, modelName: AirConditionPercent )
• HeatingPercent ( type: esriFieldTypeInteger, alias: HeatingPercent, editable: true, nullable: true, defaultValue: null, modelName: HeatingPercent )
• ThisCard_VacantLand ( type: esriFieldTypeInteger, alias: ThisCard_VacantLand, editable: true, nullable: true, defaultValue: null, modelName: ThisCard_VacantLand )
• ND_VacantLandDescription ( type: esriFieldTypeString, alias: ND_VacantLandDescription, editable: true, nullable: false, length: 19, defaultValue: null, modelName: ND_VacantLandDescription )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID, editable: false, nullable: false, defaultValue: null, modelName: ESRI_OID )

Templates:

• Name: vw_Parcel_Details
  Description:
  Prototype:
  ThisCard_VacantLand: null
  RowID: null
  ParcelID:
  CardNumber: null
  AccountNumber: null
  LocationAddressForDisplay: null
  LocationAddressNumber: null
  LocationPreDirection: null
  LocationStreetName: null
  LocationStreetSuffix: null
  LocationUnitNumber: null
  ND_DataBuildingExteriorType: null
  ND_YearBuilt: null
  ND_ExteriorWall_1Desc: null
  ND_ExteriorWall_2Desc: null
  ND_RoofStructureDescr: null
  ND_TotalBedroms: null
  ND_TotalFullBaths: null
  ND_TotalHalfBaths: null
  BuildingTypeDescription: null
  YearBuilt: null
  TotalFinSqFt: null
  StyleDescr: null
  TotalBedrooms: null
  TotalFullBaths: null
  TotalHalfBaths: null
  AirConditionTypeDesc: null
  BuildingBasementGarage: null
  FoundationTypeDescr: null
  RoofStructureDescr: null
  RoofCoverDescr: null
  ExteriorWallDescrPrimary: null
  ExteriorWallDescrSecondary: null
  InteriorWallDescrPrimary: null
  InteriorWallDescrSecondary: null
  FloorCoverDescrPrimary: null
  FloorCoverDescrSecondary: null
  HeatTypeDescr: null
  HeatFuelDescr: null
  FirePlaceDescr: null
  SketchImage: null
  BedroomsBaseLevel: null
  BedroomsLowerLevel: null
  BedroomsUpperLevel: null
  BuildingName: null
  FullBathBaseLevel: null
  FullBathLowerLevel: null
  FullBathUpperLevel: null
  HalfBathBaseLevel: null
  HalfBathLowerLevel: null
  HalfBathUpperLevel: null
  SubFloorDescr: null
  ParcelCardRowID: 0
  ParcelBuildingRowID: null
  SumThisCardSFYIOnlyValue: null
  SumThisCardBuildingOnlyValue: null
  ParcelID_LocationAddress_details: null
  AirConditionPercent: null
  HeatingPercent: null
  ND_VacantLandDescription:
  
  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