Name: v_qryGIS_new

Display Field: StreetName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: abbee040ea764d119e945c6f6082cf50

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

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

Fields:

• PropertyID ( type: esriFieldTypeOID, alias: PropertyID )
• YearID ( type: esriFieldTypeSmallInteger, alias: YearID )
• BuildingSequence ( type: esriFieldTypeInteger, alias: BuildingSequence )
• ParcelID ( type: esriFieldTypeString, alias: ParcelID, length: 100 )
• LandUseCode ( type: esriFieldTypeString, alias: LandUseCode, length: 50 )
• LandUseCodeDescription ( type: esriFieldTypeString, alias: LandUseCodeDescription, length: 50 )
• SalePrice ( type: esriFieldTypeDouble, alias: SalePrice )
• SaleDate ( type: esriFieldTypeDate, alias: SaleDate, length: 8 )
• Baths ( type: esriFieldTypeSingle, alias: Baths )
• Beds ( type: esriFieldTypeString, alias: Beds, length: 10 )
• StreetName ( type: esriFieldTypeString, alias: StreetName, length: 255 )
• StreetNumber ( type: esriFieldTypeString, alias: StreetNumber, length: 50 )
• LocationCity ( type: esriFieldTypeString, alias: LocationCity, length: 50 )
• Owner1 ( type: esriFieldTypeString, alias: Owner1, length: 600 )
• Owner2 ( type: esriFieldTypeString, alias: Owner2, length: 600 )
• Owner3 ( type: esriFieldTypeString, alias: Owner3, length: 600 )
• BillingAddress ( type: esriFieldTypeString, alias: BillingAddress, length: 255 )
• BillingAddress2 ( type: esriFieldTypeString, alias: BillingAddress2, length: 255 )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, length: 50 )
• State ( type: esriFieldTypeString, alias: State, length: 50 )
• Grantor ( type: esriFieldTypeString, alias: Grantor, length: 100 )
• City ( type: esriFieldTypeString, alias: City, length: 50 )
• FormattedLocation ( type: esriFieldTypeString, alias: FormattedLocation, length: 255 )
• District ( type: esriFieldTypeString, alias: District, length: 50 )
• TransferBook ( type: esriFieldTypeString, alias: TransferBook, length: 20 )
• TransferPage ( type: esriFieldTypeString, alias: TransferPage, length: 20 )
• ImprovedStatusDescription ( type: esriFieldTypeString, alias: ImprovedStatusDescription, length: 50 )
• BuildingID ( type: esriFieldTypeInteger, alias: BuildingID )
• BuildingTypeDescription ( type: esriFieldTypeString, alias: BuildingTypeDescription, length: 50 )
• ExteriorWallDescription ( type: esriFieldTypeString, alias: ExteriorWallDescription, length: 50 )
• HeatFuelDescription ( type: esriFieldTypeString, alias: HeatFuelDescription, length: 50 )
• HeatDescription ( type: esriFieldTypeString, alias: HeatDescription, length: 50 )
• PercentHeated ( type: esriFieldTypeSingle, alias: PercentHeated )
• PercentAirConditioned ( type: esriFieldTypeSingle, alias: PercentAirConditioned )
• StoryHeightDescription ( type: esriFieldTypeString, alias: StoryHeightDescription, length: 50 )
• FoundationDescription ( type: esriFieldTypeString, alias: FoundationDescription, length: 50 )
• CommercialUnits ( type: esriFieldTypeInteger, alias: CommercialUnits )
• ResidentialUnits ( type: esriFieldTypeInteger, alias: ResidentialUnits )
• RoofStructureDescription ( type: esriFieldTypeString, alias: RoofStructureDescription, length: 50 )
• RoofCoverDescription ( type: esriFieldTypeString, alias: RoofCoverDescription, length: 50 )
• QualityDescription ( type: esriFieldTypeString, alias: QualityDescription, length: 50 )
• YearBuilt ( type: esriFieldTypeSmallInteger, alias: YearBuilt )
• EffectiveYearBuilt ( type: esriFieldTypeSmallInteger, alias: EffectiveYearBuilt )
• CondoName ( type: esriFieldTypeString, alias: CondoName, length: 50 )
• ComplexDescription ( type: esriFieldTypeString, alias: ComplexDescription, length: 50 )
• FullBath ( type: esriFieldTypeSmallInteger, alias: FullBath )
• FullBathRatingDescription ( type: esriFieldTypeString, alias: FullBathRatingDescription, length: 50 )
• HalfBath ( type: esriFieldTypeSmallInteger, alias: HalfBath )
• HalfBathRatingDescription ( type: esriFieldTypeString, alias: HalfBathRatingDescription, length: 50 )
• Kitchen ( type: esriFieldTypeSmallInteger, alias: Kitchen )
• KitchenRatingDescription ( type: esriFieldTypeString, alias: KitchenRatingDescription, length: 50 )
• FirePlaces ( type: esriFieldTypeInteger, alias: FirePlaces )
• Units ( type: esriFieldTypeInteger, alias: Units )
• Rooms ( type: esriFieldTypeInteger, alias: Rooms )
• Bedrooms ( type: esriFieldTypeInteger, alias: Bedrooms )
• InactiveFlag ( type: esriFieldTypeSmallInteger, alias: InactiveFlag )
• UserBuildingReference ( type: esriFieldTypeString, alias: UserBuildingReference, length: 50 )
• TotalLandValue ( type: esriFieldTypeDouble, alias: TotalLandValue )
• TotalAssessedValue ( type: esriFieldTypeDouble, alias: TotalAssessedValue )
• CuOCity ( type: esriFieldTypeString, alias: CuOCity, length: 50 )
• CuOPostal ( type: esriFieldTypeString, alias: CuOPostal, length: 50 )
• CuOState ( type: esriFieldTypeString, alias: CuOState, length: 50 )
• CurrentOwner ( type: esriFieldTypeString, alias: CurrentOwner, length: 600 )
• YearBlt ( type: esriFieldTypeSmallInteger, alias: YearBlt )
• NumberofBedrooms ( type: esriFieldTypeString, alias: NumberofBedrooms, length: 10 )
• TotalUnits ( type: esriFieldTypeInteger, alias: TotalUnits )
• LandUse ( type: esriFieldTypeString, alias: LandUse, length: 50 )
• TotalFinishedArea ( type: esriFieldTypeDouble, alias: TotalFinishedArea )
• TotalLandArea ( type: esriFieldTypeDouble, alias: TotalLandArea )
• GISKey ( type: esriFieldTypeInteger, alias: GISKey )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata