{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "Madison City Boundary", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 103412, "latestWkid": 8193 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 225, 225, 225, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 699508.1346771121, "ymin": 399135.570670858, "xmax": 921250.0734101981, "ymax": 562832.2639461011, "spatialReference": { "wkid": 103412, "latestWkid": 8193 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "MCD", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "MCD", "type": "esriFieldTypeString", "alias": "MCD", "length": 50, "domain": { "type": "codedValue", "name": "WS5_MCD_Code", "description": "MCD Code", "codedValues": [ { "name": "City of Madison", "code": "C-MAD" }, { "name": "City of Fitchburg", "code": "C-FIT" }, { "name": "City of Middleton", "code": "C-MID" }, { "name": "City of Monona", "code": "C-MON" }, { "name": "Town of Blooming Grove", "code": "T-BLO" }, { "name": "Town of Burke", "code": "T-BUR" }, { "name": "Town of Dunn", "code": "T-DUN" }, { "name": "Town of Madison", "code": "T-MAD" }, { "name": "Town of Middleton", "code": "T-MID" }, { "name": "Town of Springfield", "code": "T-SPR" }, { "name": "Town of Verona", "code": "T-VER" }, { "name": "Town of Westport", "code": "T-WES" }, { "name": "Village of Mapple Bluff", "code": "V-MAP" }, { "name": "Village of McFarland", "code": "V-MCF" }, { "name": "Village of Shorewood Hills", "code": "V-SHO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R3196_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S3077_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.91, "id": 2, "name": "Police Incident Reports", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "IncidentType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "IncidentID", "type": "esriFieldTypeOID", "alias": "IncidentID", "domain": null }, { "name": "IncidentType", "type": "esriFieldTypeString", "alias": "IncidentType", "length": 50, "domain": null }, { "name": "CaseNumber", "type": "esriFieldTypeString", "alias": "CaseNumber", "length": 50, "domain": null }, { "name": "IncidentDate", "type": "esriFieldTypeDate", "alias": "IncidentDate", "length": 8, "domain": null }, { "name": "Suspect", "type": "esriFieldTypeString", "alias": "Suspect", "length": 750, "domain": null }, { "name": "Arrested", "type": "esriFieldTypeString", "alias": "Arrested", "length": 750, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 100, "domain": null }, { "name": "Victim", "type": "esriFieldTypeString", "alias": "Victim", "length": 750, "domain": null }, { "name": "Details", "type": "esriFieldTypeString", "alias": "Details", "length": 1073741822, "domain": null }, { "name": "ReleasedBy", "type": "esriFieldTypeString", "alias": "ReleasedBy", "length": 50, "domain": null }, { "name": "DateModified", "type": "esriFieldTypeDate", "alias": "DateModified", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } }, { "currentVersion": 10.91, "id": 3, "name": "City Calendar of Events", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Calendar", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "EventId", "type": "esriFieldTypeOID", "alias": "EventId", "domain": null }, { "name": "Calendar", "type": "esriFieldTypeString", "alias": "Calendar", "length": 50, "domain": null }, { "name": "Title", "type": "esriFieldTypeString", "alias": "Title", "length": 150, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 200, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 1073741822, "domain": null }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "length": 8, "domain": null }, { "name": "EndDate", "type": "esriFieldTypeDate", "alias": "EndDate", "length": 8, "domain": null }, { "name": "EventTime", "type": "esriFieldTypeString", "alias": "EventTime", "length": 50, "domain": null }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 50, "domain": null }, { "name": "HandicapAccessible", "type": "esriFieldTypeString", "alias": "HandicapAccessible", "length": 4, "domain": null }, { "name": "ASLProvided", "type": "esriFieldTypeString", "alias": "ASLProvided", "length": 4, "domain": null }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "length": 20, "domain": null }, { "name": "Cost", "type": "esriFieldTypeString", "alias": "Cost", "length": 50, "domain": null }, { "name": "URL", "type": "esriFieldTypeString", "alias": "URL", "length": 100, "domain": null }, { "name": "Contact", "type": "esriFieldTypeString", "alias": "Contact", "length": 1073741822, "domain": null }, { "name": "AdditionalInformation", "type": "esriFieldTypeString", "alias": "AdditionalInformation", "length": 500, "domain": null }, { "name": "CitySponsored", "type": "esriFieldTypeSmallInteger", "alias": "CitySponsored", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } }, { "currentVersion": 10.91, "id": 4, "name": "Current Year Tax Roll", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TaxYear", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Id", "type": "esriFieldTypeOID", "alias": "Id", "domain": null }, { "name": "TaxYear", "type": "esriFieldTypeString", "alias": "TaxYear", "length": 50, "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 50, "domain": null }, { "name": "address", "type": "esriFieldTypeString", "alias": "address", "length": 11, "domain": null }, { "name": "AssessedValueLand", "type": "esriFieldTypeDouble", "alias": "AssessedValueLand", "domain": null }, { "name": "AssessedValueImprovement", "type": "esriFieldTypeDouble", "alias": "AssessedValueImprovement", "domain": null }, { "name": "TotalAssessedValue", "type": "esriFieldTypeDouble", "alias": "TotalAssessedValue", "domain": null }, { "name": "MortgageHolder", "type": "esriFieldTypeString", "alias": "MortgageHolder", "length": 50, "domain": null }, { "name": "MillRate", "type": "esriFieldTypeDouble", "alias": "MillRate", "domain": null }, { "name": "EstFairMkt", "type": "esriFieldTypeDouble", "alias": "EstFairMkt", "domain": null }, { "name": "DrainageDist", "type": "esriFieldTypeString", "alias": "DrainageDist", "length": 30, "domain": null }, { "name": "DrainageAmt", "type": "esriFieldTypeDouble", "alias": "DrainageAmt", "domain": null }, { "name": "AvgAsmtRatio", "type": "esriFieldTypeDouble", "alias": "AvgAsmtRatio", "domain": null }, { "name": "EstFairMktLand", "type": "esriFieldTypeDouble", "alias": "EstFairMktLand", "domain": null }, { "name": "EstFairMktImp", "type": "esriFieldTypeDouble", "alias": "EstFairMktImp", "domain": null }, { "name": "SchoolLevyTax", "type": "esriFieldTypeDouble", "alias": "SchoolLevyTax", "domain": null }, { "name": "TaxJuris1", "type": "esriFieldTypeString", "alias": "TaxJuris1", "length": 50, "domain": null }, { "name": "TaxJuris2", "type": "esriFieldTypeString", "alias": "TaxJuris2", "length": 50, "domain": null }, { "name": "TaxJuris3", "type": "esriFieldTypeString", "alias": "TaxJuris3", "length": 50, "domain": null }, { "name": "TaxJuris4", "type": "esriFieldTypeString", "alias": "TaxJuris4", "length": 50, "domain": null }, { "name": "TaxJuris5", "type": "esriFieldTypeString", "alias": "TaxJuris5", "length": 50, "domain": null }, { "name": "PriorNet1", "type": "esriFieldTypeDouble", "alias": "PriorNet1", "domain": null }, { "name": "CurNet1", "type": "esriFieldTypeDouble", "alias": "CurNet1", "domain": null }, { "name": "PctTaxChange1", "type": "esriFieldTypeDouble", "alias": "PctTaxChange1", "domain": null }, { "name": "PriorNet2", "type": "esriFieldTypeDouble", "alias": "PriorNet2", "domain": null }, { "name": "CurNet2", "type": "esriFieldTypeDouble", "alias": "CurNet2", "domain": null }, { "name": "PctTaxChange2", "type": "esriFieldTypeDouble", "alias": "PctTaxChange2", "domain": null }, { "name": "PriorNet3", "type": "esriFieldTypeDouble", "alias": "PriorNet3", "domain": null }, { "name": "CurNet3", "type": "esriFieldTypeDouble", "alias": "CurNet3", "domain": null }, { "name": "PctTaxChange3", "type": "esriFieldTypeDouble", "alias": "PctTaxChange3", "domain": null }, { "name": "PriorNet4", "type": "esriFieldTypeDouble", "alias": "PriorNet4", "domain": null }, { "name": "CurNet4", "type": "esriFieldTypeDouble", "alias": "CurNet4", "domain": null }, { "name": "PctTaxChange4", "type": "esriFieldTypeDouble", "alias": "PctTaxChange4", "domain": null }, { "name": "PriorNet5", "type": "esriFieldTypeDouble", "alias": "PriorNet5", "domain": null }, { "name": "CurNet5", "type": "esriFieldTypeDouble", "alias": "CurNet5", "domain": null }, { "name": "PctTaxChange5", "type": "esriFieldTypeDouble", "alias": "PctTaxChange5", "domain": null }, { "name": "PriorTotal", "type": "esriFieldTypeDouble", "alias": "PriorTotal", "domain": null }, { "name": "CurTotal", "type": "esriFieldTypeDouble", "alias": "CurTotal", "domain": null }, { "name": "PctTaxChangeTotal", "type": "esriFieldTypeDouble", "alias": "PctTaxChangeTotal", "domain": null }, { "name": "PriorDollarCR", "type": "esriFieldTypeDouble", "alias": "PriorDollarCR", "domain": null }, { "name": "CurDollarCR", "type": "esriFieldTypeDouble", "alias": "CurDollarCR", "domain": null }, { "name": "PctDollarCR", "type": "esriFieldTypeDouble", "alias": "PctDollarCR", "domain": null }, { "name": "PriorLottery", "type": "esriFieldTypeDouble", "alias": "PriorLottery", "domain": null }, { "name": "CurLottery", "type": "esriFieldTypeDouble", "alias": "CurLottery", "domain": null }, { "name": "PctLottery", "type": "esriFieldTypeDouble", "alias": "PctLottery", "domain": null }, { "name": "PriorNetTotal", "type": "esriFieldTypeDouble", "alias": "PriorNetTotal", "domain": null }, { "name": "CurNetTotal", "type": "esriFieldTypeDouble", "alias": "CurNetTotal", "domain": null }, { "name": "PctNetTotal", "type": "esriFieldTypeDouble", "alias": "PctNetTotal", "domain": null }, { "name": "OtherDesc1", "type": "esriFieldTypeString", "alias": "OtherDesc1", "length": 100, "domain": null }, { "name": "OtherDesc2", "type": "esriFieldTypeString", "alias": "OtherDesc2", "length": 100, "domain": null }, { "name": "OtherDesc3", "type": "esriFieldTypeString", "alias": "OtherDesc3", "length": 100, "domain": null }, { "name": "OtherDesc4", "type": "esriFieldTypeString", "alias": "OtherDesc4", "length": 100, "domain": null }, { "name": "OtherDesc5", "type": "esriFieldTypeString", "alias": "OtherDesc5", "length": 100, "domain": null }, { "name": "OtherDesc6", "type": "esriFieldTypeString", "alias": "OtherDesc6", "length": 100, "domain": null }, { "name": "OtherDesc7", "type": "esriFieldTypeString", "alias": "OtherDesc7", "length": 100, "domain": null }, { "name": "OtherDesc8", "type": "esriFieldTypeString", "alias": "OtherDesc8", "length": 100, "domain": null }, { "name": "OtherDesc9", "type": "esriFieldTypeString", "alias": "OtherDesc9", "length": 100, "domain": null }, { "name": "OtherDesc10", "type": "esriFieldTypeString", "alias": "OtherDesc10", "length": 100, "domain": null }, { "name": "OtherDesc11", "type": "esriFieldTypeString", "alias": "OtherDesc11", "length": 100, "domain": null }, { "name": "OtherAmt1", "type": "esriFieldTypeDouble", "alias": "OtherAmt1", "domain": null }, { "name": "OtherAmt2", "type": "esriFieldTypeDouble", "alias": "OtherAmt2", "domain": null }, { "name": "OtherAmt3", "type": "esriFieldTypeDouble", "alias": "OtherAmt3", "domain": null }, { "name": "OtherAmt4", "type": "esriFieldTypeDouble", "alias": "OtherAmt4", "domain": null }, { "name": "OtherAmt5", "type": "esriFieldTypeDouble", "alias": "OtherAmt5", "domain": null }, { "name": "OtherAmt6", "type": "esriFieldTypeDouble", "alias": "OtherAmt6", "domain": null }, { "name": "OtherAmt7", "type": "esriFieldTypeDouble", "alias": "OtherAmt7", "domain": null }, { "name": "OtherAmt8", "type": "esriFieldTypeDouble", "alias": "OtherAmt8", "domain": null }, { "name": "OtherAmt9", "type": "esriFieldTypeDouble", "alias": "OtherAmt9", "domain": null }, { "name": "OtherAmt10", "type": "esriFieldTypeDouble", "alias": "OtherAmt10", "domain": null }, { "name": "OtherAmt11", "type": "esriFieldTypeDouble", "alias": "OtherAmt11", "domain": null }, { "name": "FirstDueDate", "type": "esriFieldTypeString", "alias": "FirstDueDate", "length": 30, "domain": null }, { "name": "SecondDueDate", "type": "esriFieldTypeString", "alias": "SecondDueDate", "length": 30, "domain": null }, { "name": "ThirdDueDate", "type": "esriFieldTypeString", "alias": "ThirdDueDate", "length": 30, "domain": null }, { "name": "FourthDueDate", "type": "esriFieldTypeString", "alias": "FourthDueDate", "length": 30, "domain": null }, { "name": "FullDueDate", "type": "esriFieldTypeString", "alias": "FullDueDate", "length": 30, "domain": null }, { "name": "FirstAmt", "type": "esriFieldTypeDouble", "alias": "FirstAmt", "domain": null }, { "name": "SecondAmt", "type": "esriFieldTypeDouble", "alias": "SecondAmt", "domain": null }, { "name": "ThirdAmt", "type": "esriFieldTypeDouble", "alias": "ThirdAmt", "domain": null }, { "name": "FourthAmt", "type": "esriFieldTypeDouble", "alias": "FourthAmt", "domain": null }, { "name": "FullAmt", "type": "esriFieldTypeDouble", "alias": "FullAmt", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.91, "id": 5, "name": "PHMDC Restaurant Establishment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DoingBusinessAsName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LicenseNbr", "type": "esriFieldTypeString", "alias": "LicenseNbr", "length": 30, "domain": null }, { "name": "LicenseAppStatus", "type": "esriFieldTypeString", "alias": "LicenseAppStatus", "length": 30, "domain": null }, { "name": "DoingBusinessAsName", "type": "esriFieldTypeString", "alias": "DoingBusinessAsName", "length": 255, "domain": null }, { "name": "LicExpirationDate", "type": "esriFieldTypeDate", "alias": "LicExpirationDate", "length": 8, "domain": null }, { "name": "LicExpirationStatus", "type": "esriFieldTypeString", "alias": "LicExpirationStatus", "length": 30, "domain": null }, { "name": "AddressFull", "type": "esriFieldTypeString", "alias": "AddressFull", "length": 500, "domain": null }, { "name": "AddrStreetNo", "type": "esriFieldTypeInteger", "alias": "AddrStreetNo", "domain": null }, { "name": "AddrStreetDir", "type": "esriFieldTypeString", "alias": "AddrStreetDir", "length": 2, "domain": null }, { "name": "AddrStreetName", "type": "esriFieldTypeString", "alias": "AddrStreetName", "length": 40, "domain": null }, { "name": "AddrStreetType", "type": "esriFieldTypeString", "alias": "AddrStreetType", "length": 30, "domain": null }, { "name": "AddrUnit", "type": "esriFieldTypeString", "alias": "AddrUnit", "length": 30, "domain": null }, { "name": "PrimarilyRestaurant", "type": "esriFieldTypeString", "alias": "PrimarilyRestaurant", "length": 1, "domain": null }, { "name": "RetailFoodEstab", "type": "esriFieldTypeString", "alias": "RetailFoodEstab", "length": 1, "domain": null }, { "name": "RestaurantMobileCart", "type": "esriFieldTypeString", "alias": "RestaurantMobileCart", "length": 1, "domain": null }, { "name": "RestaurantMobileBase", "type": "esriFieldTypeString", "alias": "RestaurantMobileBase", "length": 1, "domain": null }, { "name": "RetailMobileCart", "type": "esriFieldTypeString", "alias": "RetailMobileCart", "length": 1, "domain": null }, { "name": "RetailMobileBase", "type": "esriFieldTypeString", "alias": "RetailMobileBase", "length": 1, "domain": null }, { "name": "FarmersMarket", "type": "esriFieldTypeString", "alias": "FarmersMarket", "length": 1, "domain": null }, { "name": "RecDate", "type": "esriFieldTypeDate", "alias": "RecDate", "length": 8, "domain": null }, { "name": "EstablishmentType", "type": "esriFieldTypeString", "alias": "EstablishmentType", "length": 40, "domain": null }, { "name": "AddrCity", "type": "esriFieldTypeString", "alias": "AddrCity", "length": 50, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": [ { "name": "PK_RestaurantEstablishment", "fields": "LicenseNbr", "isAscending": true, "isUnique": true, "description": "" }, { "name": "Alt_ID", "fields": "LicenseNbr", "isAscending": true, "isUnique": false, "description": "" }, { "name": "DBA", "fields": "DoingBusinessAsName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "StreetName", "fields": "AddrStreetName", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } }, { "currentVersion": 10.91, "id": 7, "name": "PHMDC Restaurant Inspection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LicenseNbr", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LicenseNbr", "type": "esriFieldTypeString", "alias": "LicenseNbr", "length": 30, "domain": null }, { "name": "InspectionNbr", "type": "esriFieldTypeInteger", "alias": "InspectionNbr", "domain": null }, { "name": "InspectionType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 255, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "InspecDispositionStatus", "type": "esriFieldTypeString", "alias": "InspecDispositionStatus", "length": 30, "domain": null }, { "name": "InspecResultStatus", "type": "esriFieldTypeString", "alias": "InspecResultStatus", "length": 500, "domain": null }, { "name": "InspecResultStatusDate", "type": "esriFieldTypeDate", "alias": "InspecResultStatusDate", "length": 8, "domain": null }, { "name": "InspecResultType", "type": "esriFieldTypeString", "alias": "InspecResultType", "length": 30, "domain": null }, { "name": "RecDate", "type": "esriFieldTypeDate", "alias": "RecDate", "length": 8, "domain": null }, { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null } ], "indexes": [ { "name": "PK_RestaurantInspection", "fields": "ID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } }, { "currentVersion": 10.91, "id": 10, "name": "PHMDC Restaurant Guidesheet 2023", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LicenseNbr", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GuidesheetID", "type": "esriFieldTypeOID", "alias": "GuidesheetID", "domain": null }, { "name": "LicenseNbr", "type": "esriFieldTypeString", "alias": "LicenseNbr", "length": 30, "domain": null }, { "name": "InspectionNbr", "type": "esriFieldTypeInteger", "alias": "InspectionNbr", "domain": null }, { "name": "GUIDESHEET_SEQ_NBR", "type": "esriFieldTypeInteger", "alias": "GUIDESHEET_SEQ_NBR", "domain": null }, { "name": "GUIDE_TYPE", "type": "esriFieldTypeString", "alias": "GUIDE_TYPE", "length": 250, "domain": null }, { "name": "GUIDE_ITEM_DISPLAY_ORDER", "type": "esriFieldTypeSmallInteger", "alias": "GUIDE_ITEM_DISPLAY_ORDER", "domain": null }, { "name": "GUIDE_ITEM_TEXT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_TEXT", "length": 2000, "domain": null }, { "name": "GUIDE_ITEM_STATUS", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_STATUS", "length": 30, "domain": null }, { "name": "GUIDE_ITEM_COMMENT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_COMMENT", "length": 2000, "domain": null }, { "name": "RepeatViolation", "type": "esriFieldTypeString", "alias": "RepeatViolation", "length": 15, "domain": null }, { "name": "CorrectedOnsite", "type": "esriFieldTypeString", "alias": "CorrectedOnsite", "length": 15, "domain": null }, { "name": "RecDate", "type": "esriFieldTypeDate", "alias": "RecDate", "length": 8, "domain": null }, { "name": "ComplianceDate", "type": "esriFieldTypeString", "alias": "ComplianceDate", "length": 50, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } }, { "currentVersion": 10.91, "id": 11, "name": "PHMDC Restaurant Guidesheet 2022", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LicenseNbr", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GuidesheetID", "type": "esriFieldTypeOID", "alias": "GuidesheetID", "domain": null }, { "name": "LicenseNbr", "type": "esriFieldTypeString", "alias": "LicenseNbr", "length": 30, "domain": null }, { "name": "InspectionNbr", "type": "esriFieldTypeInteger", "alias": "InspectionNbr", "domain": null }, { "name": "GUIDESHEET_SEQ_NBR", "type": "esriFieldTypeInteger", "alias": "GUIDESHEET_SEQ_NBR", "domain": null }, { "name": "GUIDE_TYPE", "type": "esriFieldTypeString", "alias": "GUIDE_TYPE", "length": 250, "domain": null }, { "name": "GUIDE_ITEM_DISPLAY_ORDER", "type": "esriFieldTypeSmallInteger", "alias": "GUIDE_ITEM_DISPLAY_ORDER", "domain": null }, { "name": "GUIDE_ITEM_TEXT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_TEXT", "length": 2000, "domain": null }, { "name": "GUIDE_ITEM_STATUS", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_STATUS", "length": 30, "domain": null }, { "name": "GUIDE_ITEM_COMMENT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_COMMENT", "length": 2000, "domain": null }, { "name": "RepeatViolation", "type": "esriFieldTypeString", "alias": "RepeatViolation", "length": 15, "domain": null }, { "name": "CorrectedOnsite", "type": "esriFieldTypeString", "alias": "CorrectedOnsite", "length": 15, "domain": null }, { "name": "RecDate", "type": "esriFieldTypeDate", "alias": "RecDate", "length": 8, "domain": null }, { "name": "ComplianceDate", "type": "esriFieldTypeString", "alias": "ComplianceDate", "length": 50, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } }, { "currentVersion": 10.91, "id": 12, "name": "PHMDC Restaurant Guidesheet 2021", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LicenseNbr", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GuidesheetID", "type": "esriFieldTypeOID", "alias": "GuidesheetID", "domain": null }, { "name": "LicenseNbr", "type": "esriFieldTypeString", "alias": "LicenseNbr", "length": 30, "domain": null }, { "name": "InspectionNbr", "type": "esriFieldTypeInteger", "alias": "InspectionNbr", "domain": null }, { "name": "GUIDESHEET_SEQ_NBR", "type": "esriFieldTypeInteger", "alias": "GUIDESHEET_SEQ_NBR", "domain": null }, { "name": "GUIDE_TYPE", "type": "esriFieldTypeString", "alias": "GUIDE_TYPE", "length": 250, "domain": null }, { "name": "GUIDE_ITEM_DISPLAY_ORDER", "type": "esriFieldTypeSmallInteger", "alias": "GUIDE_ITEM_DISPLAY_ORDER", "domain": null }, { "name": "GUIDE_ITEM_TEXT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_TEXT", "length": 2000, "domain": null }, { "name": "GUIDE_ITEM_STATUS", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_STATUS", "length": 30, "domain": null }, { "name": "GUIDE_ITEM_COMMENT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_COMMENT", "length": 2000, "domain": null }, { "name": "RepeatViolation", "type": "esriFieldTypeString", "alias": "RepeatViolation", "length": 15, "domain": null }, { "name": "CorrectedOnsite", "type": "esriFieldTypeString", "alias": "CorrectedOnsite", "length": 15, "domain": null }, { "name": "RecDate", "type": "esriFieldTypeDate", "alias": "RecDate", "length": 8, "domain": null }, { "name": "ComplianceDate", "type": "esriFieldTypeString", "alias": "ComplianceDate", "length": 50, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } }, { "currentVersion": 10.91, "id": 13, "name": "PHMDC Restaurant Guidesheet 2020", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LicenseNbr", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GuidesheetID", "type": "esriFieldTypeOID", "alias": "GuidesheetID", "domain": null }, { "name": "LicenseNbr", "type": "esriFieldTypeString", "alias": "LicenseNbr", "length": 30, "domain": null }, { "name": "InspectionNbr", "type": "esriFieldTypeInteger", "alias": "InspectionNbr", "domain": null }, { "name": "GUIDESHEET_SEQ_NBR", "type": "esriFieldTypeInteger", "alias": "GUIDESHEET_SEQ_NBR", "domain": null }, { "name": "GUIDE_TYPE", "type": "esriFieldTypeString", "alias": "GUIDE_TYPE", "length": 250, "domain": null }, { "name": "GUIDE_ITEM_DISPLAY_ORDER", "type": "esriFieldTypeSmallInteger", "alias": "GUIDE_ITEM_DISPLAY_ORDER", "domain": null }, { "name": "GUIDE_ITEM_TEXT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_TEXT", "length": 2000, "domain": null }, { "name": "GUIDE_ITEM_STATUS", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_STATUS", "length": 30, "domain": null }, { "name": "GUIDE_ITEM_COMMENT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_COMMENT", "length": 2000, "domain": null }, { "name": "RepeatViolation", "type": "esriFieldTypeString", "alias": "RepeatViolation", "length": 15, "domain": null }, { "name": "CorrectedOnsite", "type": "esriFieldTypeString", "alias": "CorrectedOnsite", "length": 15, "domain": null }, { "name": "RecDate", "type": "esriFieldTypeDate", "alias": "RecDate", "length": 8, "domain": null }, { "name": "ComplianceDate", "type": "esriFieldTypeString", "alias": "ComplianceDate", "length": 50, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } }, { "currentVersion": 10.91, "id": 14, "name": "PHMDC Restaurant Guidesheet 2019", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LicenseNbr", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GuidesheetID", "type": "esriFieldTypeOID", "alias": "GuidesheetID", "domain": null }, { "name": "LicenseNbr", "type": "esriFieldTypeString", "alias": "LicenseNbr", "length": 30, "domain": null }, { "name": "InspectionNbr", "type": "esriFieldTypeInteger", "alias": "InspectionNbr", "domain": null }, { "name": "GUIDESHEET_SEQ_NBR", "type": "esriFieldTypeInteger", "alias": "GUIDESHEET_SEQ_NBR", "domain": null }, { "name": "GUIDE_TYPE", "type": "esriFieldTypeString", "alias": "GUIDE_TYPE", "length": 250, "domain": null }, { "name": "GUIDE_ITEM_DISPLAY_ORDER", "type": "esriFieldTypeSmallInteger", "alias": "GUIDE_ITEM_DISPLAY_ORDER", "domain": null }, { "name": "GUIDE_ITEM_TEXT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_TEXT", "length": 2000, "domain": null }, { "name": "GUIDE_ITEM_STATUS", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_STATUS", "length": 30, "domain": null }, { "name": "GUIDE_ITEM_COMMENT", "type": "esriFieldTypeString", "alias": "GUIDE_ITEM_COMMENT", "length": 2000, "domain": null }, { "name": "RepeatViolation", "type": "esriFieldTypeString", "alias": "RepeatViolation", "length": 15, "domain": null }, { "name": "CorrectedOnsite", "type": "esriFieldTypeString", "alias": "CorrectedOnsite", "length": 15, "domain": null }, { "name": "RecDate", "type": "esriFieldTypeDate", "alias": "RecDate", "length": 8, "domain": null }, { "name": "ComplianceDate", "type": "esriFieldTypeString", "alias": "ComplianceDate", "length": 50, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true } } ] }