ArcGIS REST Services Directory
Login
Home
>
services
>
Tables (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (Tables)
Tables:
Table:
v_qryGIS_new
(0)
Name:
v_qryGIS_new
Display Field:
StreetName
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
06e60cc5fce44ae587488e3c2b8081c2
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 )
Table:
InnerTrash
(1)
Name:
InnerTrash
Display Field:
STREETNAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
06e60cc5fce44ae587488e3c2b8081c2
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:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
STREETNAME
( type: esriFieldTypeString, alias: STREETNAME, length: 1073741822 )
COLLECTIONDAY
( type: esriFieldTypeString, alias: COLLECTIONDAY, length: 1073741822 )
FRADD
( type: esriFieldTypeInteger, alias: FRADD )
TOADD
( type: esriFieldTypeInteger, alias: TOADD )
Table:
q_WaterSewerBilling
(2)
Name:
q_WaterSewerBilling
Display Field:
STNAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
06e60cc5fce44ae587488e3c2b8081c2
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:
pk
( type: esriFieldTypeOID, alias: pk )
STNUM
( type: esriFieldTypeSmallInteger, alias: STNUM )
STNAME
( type: esriFieldTypeString, alias: STNAME, length: 50 )
STTYPE
( type: esriFieldTypeString, alias: STTYPE, length: 50 )
STSFX
( type: esriFieldTypeString, alias: STSFX, length: 50 )
ZIP
( type: esriFieldTypeString, alias: ZIP, length: 50 )
ddLONG
( type: esriFieldTypeDouble, alias: ddLONG )
ddLAT
( type: esriFieldTypeDouble, alias: ddLAT )
UTSVC
( type: esriFieldTypeString, alias: UTSVC, length: 50 )
UTLCID
( type: esriFieldTypeInteger, alias: UTLCID )
Address
( type: esriFieldTypeString, alias: Address, length: 50 )