ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
Public
>
OPEN_DB_TABLES (MapServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (Public/OPEN_DB_TABLES)
Layers:
Layer:
Madison City Boundary
(0)
Name:
Madison City Boundary
Display Field:
MCD
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 699508.1346771121
YMin: 399135.570670858
XMax: 921250.0734101981
YMax: 562832.2639461011
Spatial Reference: 103412 (8193)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[225, 225, 225, 255]
Outline:
Style:
esriSLSSolid
Color:
[0, 0, 0, 255]
Width:
0
Label:
Description:
Transparency:
0
Labeling Info:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
MCD
( type: esriFieldTypeString, alias: MCD, length: 50 ,
Coded Values:
[C-MAD: City of Madison] , [C-FIT: City of Fitchburg] , [C-MID: City of Middleton]
, ...12 more...
)
SHAPE.STArea()
( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
SHAPE.STLength()
( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
Tables:
Table:
City Calendar of Events
(3)
Name:
City Calendar of Events
Display Field:
Calendar
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
EventId
( type: esriFieldTypeOID, alias: EventId )
Calendar
( type: esriFieldTypeString, alias: Calendar, length: 50 )
Title
( type: esriFieldTypeString, alias: Title, length: 150 )
Location
( type: esriFieldTypeString, alias: Location, length: 200 )
Description
( type: esriFieldTypeString, alias: Description, length: 1073741822 )
StartDate
( type: esriFieldTypeDate, alias: StartDate, length: 8 )
EndDate
( type: esriFieldTypeDate, alias: EndDate, length: 8 )
EventTime
( type: esriFieldTypeString, alias: EventTime, length: 50 )
Category
( type: esriFieldTypeString, alias: Category, length: 50 )
HandicapAccessible
( type: esriFieldTypeString, alias: HandicapAccessible, length: 4 )
ASLProvided
( type: esriFieldTypeString, alias: ASLProvided, length: 4 )
District
( type: esriFieldTypeString, alias: District, length: 20 )
Cost
( type: esriFieldTypeString, alias: Cost, length: 50 )
URL
( type: esriFieldTypeString, alias: URL, length: 100 )
Contact
( type: esriFieldTypeString, alias: Contact, length: 1073741822 )
AdditionalInformation
( type: esriFieldTypeString, alias: AdditionalInformation, length: 500 )
CitySponsored
( type: esriFieldTypeSmallInteger, alias: CitySponsored )
Table:
Current Year Tax Roll
(4)
Name:
Current Year Tax Roll
Display Field:
TaxYear
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
Id
( type: esriFieldTypeOID, alias: Id )
TaxYear
( type: esriFieldTypeString, alias: TaxYear, length: 50 )
Parcel
( type: esriFieldTypeString, alias: Parcel, length: 50 )
address
( type: esriFieldTypeString, alias: address, length: 11 )
AssessedValueLand
( type: esriFieldTypeDouble, alias: AssessedValueLand )
AssessedValueImprovement
( type: esriFieldTypeDouble, alias: AssessedValueImprovement )
TotalAssessedValue
( type: esriFieldTypeDouble, alias: TotalAssessedValue )
MortgageHolder
( type: esriFieldTypeString, alias: MortgageHolder, length: 50 )
MillRate
( type: esriFieldTypeDouble, alias: MillRate )
EstFairMkt
( type: esriFieldTypeDouble, alias: EstFairMkt )
DrainageDist
( type: esriFieldTypeString, alias: DrainageDist, length: 30 )
DrainageAmt
( type: esriFieldTypeDouble, alias: DrainageAmt )
AvgAsmtRatio
( type: esriFieldTypeDouble, alias: AvgAsmtRatio )
EstFairMktLand
( type: esriFieldTypeDouble, alias: EstFairMktLand )
EstFairMktImp
( type: esriFieldTypeDouble, alias: EstFairMktImp )
SchoolLevyTax
( type: esriFieldTypeDouble, alias: SchoolLevyTax )
TaxJuris1
( type: esriFieldTypeString, alias: TaxJuris1, length: 50 )
TaxJuris2
( type: esriFieldTypeString, alias: TaxJuris2, length: 50 )
TaxJuris3
( type: esriFieldTypeString, alias: TaxJuris3, length: 50 )
TaxJuris4
( type: esriFieldTypeString, alias: TaxJuris4, length: 50 )
TaxJuris5
( type: esriFieldTypeString, alias: TaxJuris5, length: 50 )
PriorNet1
( type: esriFieldTypeDouble, alias: PriorNet1 )
CurNet1
( type: esriFieldTypeDouble, alias: CurNet1 )
PctTaxChange1
( type: esriFieldTypeDouble, alias: PctTaxChange1 )
PriorNet2
( type: esriFieldTypeDouble, alias: PriorNet2 )
CurNet2
( type: esriFieldTypeDouble, alias: CurNet2 )
PctTaxChange2
( type: esriFieldTypeDouble, alias: PctTaxChange2 )
PriorNet3
( type: esriFieldTypeDouble, alias: PriorNet3 )
CurNet3
( type: esriFieldTypeDouble, alias: CurNet3 )
PctTaxChange3
( type: esriFieldTypeDouble, alias: PctTaxChange3 )
PriorNet4
( type: esriFieldTypeDouble, alias: PriorNet4 )
CurNet4
( type: esriFieldTypeDouble, alias: CurNet4 )
PctTaxChange4
( type: esriFieldTypeDouble, alias: PctTaxChange4 )
PriorNet5
( type: esriFieldTypeDouble, alias: PriorNet5 )
CurNet5
( type: esriFieldTypeDouble, alias: CurNet5 )
PctTaxChange5
( type: esriFieldTypeDouble, alias: PctTaxChange5 )
PriorTotal
( type: esriFieldTypeDouble, alias: PriorTotal )
CurTotal
( type: esriFieldTypeDouble, alias: CurTotal )
PctTaxChangeTotal
( type: esriFieldTypeDouble, alias: PctTaxChangeTotal )
PriorDollarCR
( type: esriFieldTypeDouble, alias: PriorDollarCR )
CurDollarCR
( type: esriFieldTypeDouble, alias: CurDollarCR )
PctDollarCR
( type: esriFieldTypeDouble, alias: PctDollarCR )
PriorLottery
( type: esriFieldTypeDouble, alias: PriorLottery )
CurLottery
( type: esriFieldTypeDouble, alias: CurLottery )
PctLottery
( type: esriFieldTypeDouble, alias: PctLottery )
PriorNetTotal
( type: esriFieldTypeDouble, alias: PriorNetTotal )
CurNetTotal
( type: esriFieldTypeDouble, alias: CurNetTotal )
PctNetTotal
( type: esriFieldTypeDouble, alias: PctNetTotal )
OtherDesc1
( type: esriFieldTypeString, alias: OtherDesc1, length: 100 )
OtherDesc2
( type: esriFieldTypeString, alias: OtherDesc2, length: 100 )
OtherDesc3
( type: esriFieldTypeString, alias: OtherDesc3, length: 100 )
OtherDesc4
( type: esriFieldTypeString, alias: OtherDesc4, length: 100 )
OtherDesc5
( type: esriFieldTypeString, alias: OtherDesc5, length: 100 )
OtherDesc6
( type: esriFieldTypeString, alias: OtherDesc6, length: 100 )
OtherDesc7
( type: esriFieldTypeString, alias: OtherDesc7, length: 100 )
OtherDesc8
( type: esriFieldTypeString, alias: OtherDesc8, length: 100 )
OtherDesc9
( type: esriFieldTypeString, alias: OtherDesc9, length: 100 )
OtherDesc10
( type: esriFieldTypeString, alias: OtherDesc10, length: 100 )
OtherDesc11
( type: esriFieldTypeString, alias: OtherDesc11, length: 100 )
OtherAmt1
( type: esriFieldTypeDouble, alias: OtherAmt1 )
OtherAmt2
( type: esriFieldTypeDouble, alias: OtherAmt2 )
OtherAmt3
( type: esriFieldTypeDouble, alias: OtherAmt3 )
OtherAmt4
( type: esriFieldTypeDouble, alias: OtherAmt4 )
OtherAmt5
( type: esriFieldTypeDouble, alias: OtherAmt5 )
OtherAmt6
( type: esriFieldTypeDouble, alias: OtherAmt6 )
OtherAmt7
( type: esriFieldTypeDouble, alias: OtherAmt7 )
OtherAmt8
( type: esriFieldTypeDouble, alias: OtherAmt8 )
OtherAmt9
( type: esriFieldTypeDouble, alias: OtherAmt9 )
OtherAmt10
( type: esriFieldTypeDouble, alias: OtherAmt10 )
OtherAmt11
( type: esriFieldTypeDouble, alias: OtherAmt11 )
FirstDueDate
( type: esriFieldTypeString, alias: FirstDueDate, length: 30 )
SecondDueDate
( type: esriFieldTypeString, alias: SecondDueDate, length: 30 )
ThirdDueDate
( type: esriFieldTypeString, alias: ThirdDueDate, length: 30 )
FourthDueDate
( type: esriFieldTypeString, alias: FourthDueDate, length: 30 )
FullDueDate
( type: esriFieldTypeString, alias: FullDueDate, length: 30 )
FirstAmt
( type: esriFieldTypeDouble, alias: FirstAmt )
SecondAmt
( type: esriFieldTypeDouble, alias: SecondAmt )
ThirdAmt
( type: esriFieldTypeDouble, alias: ThirdAmt )
FourthAmt
( type: esriFieldTypeDouble, alias: FourthAmt )
FullAmt
( type: esriFieldTypeDouble, alias: FullAmt )
Table:
PHMDC Restaurant Establishment
(5)
Name:
PHMDC Restaurant Establishment
Display Field:
DoingBusinessAsName
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
LicenseNbr
( type: esriFieldTypeString, alias: LicenseNbr, length: 30 )
LicenseAppStatus
( type: esriFieldTypeString, alias: LicenseAppStatus, length: 30 )
DoingBusinessAsName
( type: esriFieldTypeString, alias: DoingBusinessAsName, length: 255 )
LicExpirationDate
( type: esriFieldTypeDate, alias: LicExpirationDate, length: 8 )
LicExpirationStatus
( type: esriFieldTypeString, alias: LicExpirationStatus, length: 30 )
AddressFull
( type: esriFieldTypeString, alias: AddressFull, length: 500 )
AddrStreetNo
( type: esriFieldTypeInteger, alias: AddrStreetNo )
AddrStreetDir
( type: esriFieldTypeString, alias: AddrStreetDir, length: 2 )
AddrStreetName
( type: esriFieldTypeString, alias: AddrStreetName, length: 40 )
AddrStreetType
( type: esriFieldTypeString, alias: AddrStreetType, length: 30 )
AddrUnit
( type: esriFieldTypeString, alias: AddrUnit, length: 30 )
PrimarilyRestaurant
( type: esriFieldTypeString, alias: PrimarilyRestaurant, length: 1 )
RetailFoodEstab
( type: esriFieldTypeString, alias: RetailFoodEstab, length: 1 )
RestaurantMobileCart
( type: esriFieldTypeString, alias: RestaurantMobileCart, length: 1 )
RestaurantMobileBase
( type: esriFieldTypeString, alias: RestaurantMobileBase, length: 1 )
RetailMobileCart
( type: esriFieldTypeString, alias: RetailMobileCart, length: 1 )
RetailMobileBase
( type: esriFieldTypeString, alias: RetailMobileBase, length: 1 )
FarmersMarket
( type: esriFieldTypeString, alias: FarmersMarket, length: 1 )
RecDate
( type: esriFieldTypeDate, alias: RecDate, length: 8 )
EstablishmentType
( type: esriFieldTypeString, alias: EstablishmentType, length: 40 )
AddrCity
( type: esriFieldTypeString, alias: AddrCity, length: 50 )
ESRI_OID
( type: esriFieldTypeOID, alias: ESRI_OID )
Table:
PHMDC Restaurant Inspection
(7)
Name:
PHMDC Restaurant Inspection
Display Field:
LicenseNbr
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
LicenseNbr
( type: esriFieldTypeString, alias: LicenseNbr, length: 30 )
InspectionNbr
( type: esriFieldTypeInteger, alias: InspectionNbr )
InspectionType
( type: esriFieldTypeString, alias: InspectionType, length: 255 )
InspectionDate
( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
InspecDispositionStatus
( type: esriFieldTypeString, alias: InspecDispositionStatus, length: 30 )
InspecResultStatus
( type: esriFieldTypeString, alias: InspecResultStatus, length: 500 )
InspecResultStatusDate
( type: esriFieldTypeDate, alias: InspecResultStatusDate, length: 8 )
InspecResultType
( type: esriFieldTypeString, alias: InspecResultType, length: 30 )
RecDate
( type: esriFieldTypeDate, alias: RecDate, length: 8 )
ID
( type: esriFieldTypeOID, alias: ID )
Table:
PHMDC Restaurant Guidesheet 2023
(10)
Name:
PHMDC Restaurant Guidesheet 2023
Display Field:
LicenseNbr
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GuidesheetID
( type: esriFieldTypeOID, alias: GuidesheetID )
LicenseNbr
( type: esriFieldTypeString, alias: LicenseNbr, length: 30 )
InspectionNbr
( type: esriFieldTypeInteger, alias: InspectionNbr )
GUIDESHEET_SEQ_NBR
( type: esriFieldTypeInteger, alias: GUIDESHEET_SEQ_NBR )
GUIDE_TYPE
( type: esriFieldTypeString, alias: GUIDE_TYPE, length: 250 )
GUIDE_ITEM_DISPLAY_ORDER
( type: esriFieldTypeSmallInteger, alias: GUIDE_ITEM_DISPLAY_ORDER )
GUIDE_ITEM_TEXT
( type: esriFieldTypeString, alias: GUIDE_ITEM_TEXT, length: 2000 )
GUIDE_ITEM_STATUS
( type: esriFieldTypeString, alias: GUIDE_ITEM_STATUS, length: 30 )
GUIDE_ITEM_COMMENT
( type: esriFieldTypeString, alias: GUIDE_ITEM_COMMENT, length: 2000 )
RepeatViolation
( type: esriFieldTypeString, alias: RepeatViolation, length: 15 )
CorrectedOnsite
( type: esriFieldTypeString, alias: CorrectedOnsite, length: 15 )
RecDate
( type: esriFieldTypeDate, alias: RecDate, length: 8 )
ComplianceDate
( type: esriFieldTypeString, alias: ComplianceDate, length: 50 )
InspectionDate
( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
Table:
PHMDC Restaurant Guidesheet 2022
(11)
Name:
PHMDC Restaurant Guidesheet 2022
Display Field:
LicenseNbr
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GuidesheetID
( type: esriFieldTypeOID, alias: GuidesheetID )
LicenseNbr
( type: esriFieldTypeString, alias: LicenseNbr, length: 30 )
InspectionNbr
( type: esriFieldTypeInteger, alias: InspectionNbr )
GUIDESHEET_SEQ_NBR
( type: esriFieldTypeInteger, alias: GUIDESHEET_SEQ_NBR )
GUIDE_TYPE
( type: esriFieldTypeString, alias: GUIDE_TYPE, length: 250 )
GUIDE_ITEM_DISPLAY_ORDER
( type: esriFieldTypeSmallInteger, alias: GUIDE_ITEM_DISPLAY_ORDER )
GUIDE_ITEM_TEXT
( type: esriFieldTypeString, alias: GUIDE_ITEM_TEXT, length: 2000 )
GUIDE_ITEM_STATUS
( type: esriFieldTypeString, alias: GUIDE_ITEM_STATUS, length: 30 )
GUIDE_ITEM_COMMENT
( type: esriFieldTypeString, alias: GUIDE_ITEM_COMMENT, length: 2000 )
RepeatViolation
( type: esriFieldTypeString, alias: RepeatViolation, length: 15 )
CorrectedOnsite
( type: esriFieldTypeString, alias: CorrectedOnsite, length: 15 )
RecDate
( type: esriFieldTypeDate, alias: RecDate, length: 8 )
ComplianceDate
( type: esriFieldTypeString, alias: ComplianceDate, length: 50 )
InspectionDate
( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
Table:
PHMDC Restaurant Guidesheet 2021
(12)
Name:
PHMDC Restaurant Guidesheet 2021
Display Field:
LicenseNbr
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GuidesheetID
( type: esriFieldTypeOID, alias: GuidesheetID )
LicenseNbr
( type: esriFieldTypeString, alias: LicenseNbr, length: 30 )
InspectionNbr
( type: esriFieldTypeInteger, alias: InspectionNbr )
GUIDESHEET_SEQ_NBR
( type: esriFieldTypeInteger, alias: GUIDESHEET_SEQ_NBR )
GUIDE_TYPE
( type: esriFieldTypeString, alias: GUIDE_TYPE, length: 250 )
GUIDE_ITEM_DISPLAY_ORDER
( type: esriFieldTypeSmallInteger, alias: GUIDE_ITEM_DISPLAY_ORDER )
GUIDE_ITEM_TEXT
( type: esriFieldTypeString, alias: GUIDE_ITEM_TEXT, length: 2000 )
GUIDE_ITEM_STATUS
( type: esriFieldTypeString, alias: GUIDE_ITEM_STATUS, length: 30 )
GUIDE_ITEM_COMMENT
( type: esriFieldTypeString, alias: GUIDE_ITEM_COMMENT, length: 2000 )
RepeatViolation
( type: esriFieldTypeString, alias: RepeatViolation, length: 15 )
CorrectedOnsite
( type: esriFieldTypeString, alias: CorrectedOnsite, length: 15 )
RecDate
( type: esriFieldTypeDate, alias: RecDate, length: 8 )
ComplianceDate
( type: esriFieldTypeString, alias: ComplianceDate, length: 50 )
InspectionDate
( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
Table:
PHMDC Restaurant Guidesheet 2020
(13)
Name:
PHMDC Restaurant Guidesheet 2020
Display Field:
LicenseNbr
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GuidesheetID
( type: esriFieldTypeOID, alias: GuidesheetID )
LicenseNbr
( type: esriFieldTypeString, alias: LicenseNbr, length: 30 )
InspectionNbr
( type: esriFieldTypeInteger, alias: InspectionNbr )
GUIDESHEET_SEQ_NBR
( type: esriFieldTypeInteger, alias: GUIDESHEET_SEQ_NBR )
GUIDE_TYPE
( type: esriFieldTypeString, alias: GUIDE_TYPE, length: 250 )
GUIDE_ITEM_DISPLAY_ORDER
( type: esriFieldTypeSmallInteger, alias: GUIDE_ITEM_DISPLAY_ORDER )
GUIDE_ITEM_TEXT
( type: esriFieldTypeString, alias: GUIDE_ITEM_TEXT, length: 2000 )
GUIDE_ITEM_STATUS
( type: esriFieldTypeString, alias: GUIDE_ITEM_STATUS, length: 30 )
GUIDE_ITEM_COMMENT
( type: esriFieldTypeString, alias: GUIDE_ITEM_COMMENT, length: 2000 )
RepeatViolation
( type: esriFieldTypeString, alias: RepeatViolation, length: 15 )
CorrectedOnsite
( type: esriFieldTypeString, alias: CorrectedOnsite, length: 15 )
RecDate
( type: esriFieldTypeDate, alias: RecDate, length: 8 )
ComplianceDate
( type: esriFieldTypeString, alias: ComplianceDate, length: 50 )
InspectionDate
( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
Table:
PHMDC Restaurant Guidesheet 2019
(14)
Name:
PHMDC Restaurant Guidesheet 2019
Display Field:
LicenseNbr
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GuidesheetID
( type: esriFieldTypeOID, alias: GuidesheetID )
LicenseNbr
( type: esriFieldTypeString, alias: LicenseNbr, length: 30 )
InspectionNbr
( type: esriFieldTypeInteger, alias: InspectionNbr )
GUIDESHEET_SEQ_NBR
( type: esriFieldTypeInteger, alias: GUIDESHEET_SEQ_NBR )
GUIDE_TYPE
( type: esriFieldTypeString, alias: GUIDE_TYPE, length: 250 )
GUIDE_ITEM_DISPLAY_ORDER
( type: esriFieldTypeSmallInteger, alias: GUIDE_ITEM_DISPLAY_ORDER )
GUIDE_ITEM_TEXT
( type: esriFieldTypeString, alias: GUIDE_ITEM_TEXT, length: 2000 )
GUIDE_ITEM_STATUS
( type: esriFieldTypeString, alias: GUIDE_ITEM_STATUS, length: 30 )
GUIDE_ITEM_COMMENT
( type: esriFieldTypeString, alias: GUIDE_ITEM_COMMENT, length: 2000 )
RepeatViolation
( type: esriFieldTypeString, alias: RepeatViolation, length: 15 )
CorrectedOnsite
( type: esriFieldTypeString, alias: CorrectedOnsite, length: 15 )
RecDate
( type: esriFieldTypeDate, alias: RecDate, length: 8 )
ComplianceDate
( type: esriFieldTypeString, alias: ComplianceDate, length: 50 )
InspectionDate
( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )