{ "tables": [{ "preferredTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" }, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": "This data is entered and edited through the Mowing Inspection Dashboard. Information from this table is joined with the x_MowingAreaCurrentBid feature class and x_MowingAreaCurrentBid_ContractorCompletion_vw to create the x_MowingAreaCurrentBid_Contractor_Inspection_vw. Inspections are joined to the mowing area polygon based on FacilityID and to the contractor completion entries based on GlobalID/ParentGUID.", "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [], "indexes": [ { "name": "R2279_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_2279", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "GDB_79067_Parent", "isUnique": false, "description": "", "fields": "ParentGUID", "isAscending": true }, { "name": "FacilityID", "isUnique": false, "description": "", "fields": "FacilityID", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.7.0", "isDataArchived": false, "id": 1, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithDistance": true, "supportsQueryWithCacheHint": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "288eddca4ba44a68873af9cbe1a49567", "capabilities": "Map,Query,Data", "hasLastEditTime": false, "supportsExceedsLimitStatistics": true, "standardMaxRecordCount": 32000, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "tileMaxRecordCount": 2000, "currentVersion": 12.1, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "x_MowingAreaCurrentBid_INSPECTION", "displayField": "Status", "copyrightText": "City of Johnson City, TN\nPeggi Ward (Public Works GIS)\nEllen Lester (IT GIS)", "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PassFail", "description": "", "type": "codedValue", "codedValues": [ { "code": "Passed", "name": "Passed" }, { "code": "Failed", "name": "Failed" }, { "code": "Pending", "name": "Pending" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Status", "length": 255, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "ParentGUID", "length": 38, "alias": "ParentGUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "domain": null, "name": "AttachmentGUID", "length": 38, "alias": "AttachmentGUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "domain": null, "name": "MowingZone", "length": 10, "alias": "MowingZone", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FacilityID", "length": 20, "alias": "FacilityID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "GeneralLocation", "length": 255, "alias": "General Location", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Category", "length": 20, "alias": "Category", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DetailedLocation", "length": 255, "alias": "Detailed Location", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "WorkDescription", "length": 255, "alias": "WorkDescription", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MowedArea", "length": 20, "alias": "Mowed Area (Acres)", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PenaltyFee", "length": 20, "alias": "PenaltyFee", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ContractorCompletionDate", "length": 8, "alias": "Contractor Completion Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "DateInspected", "length": 8, "alias": "Date Inspected", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" } }], "layers": [{ "extent": { "ymin": 712071.68976147473, "xmin": 2986110.4020039737, "ymax": 781707.5521298945, "xmax": 3054649.9742421359, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333331, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2274, "zTolerance": 0.001, "wkid": 102736, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -121521300, "falseY": -93934000, "falseZ": -100000 } }, "maxRecordCount": 2000, "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "type": "Feature Layer", "maxSelectionCount": 2000, "subtypes": [], "relationships": [], "cimVersion": "3.7.0", "isDataArchived": false, "id": 0, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333331, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2274, "zTolerance": 0.001, "wkid": 102736, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -121521300, "falseY": -93934000, "falseZ": -100000 }, "subtypeFieldName": null, "supportsStatistics": true, "hasLastEditTime": false, "standardMaxRecordCount": 4000, "isDataVersioned": false, "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "subLayers": [], "currentVersion": 12.1, "referenceScale": 0, "canScaleSymbols": false, "name": "MowingAreaCurrentBid", "displayField": "GENERALLOC", "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "GENERALLOC", "length": 50, "alias": "General Location", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MOWEDAREA", "length": 50, "alias": "Mowed Area", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CATEGORY", "length": 50, "alias": "Category", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LENGTH", "alias": "LENGTH", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "ROADSIDEWIDTH", "alias": "Roadside Width", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "MEDIANWIDTH", "alias": "Median Width", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "DETAILLOC", "length": 250, "alias": "Detailed Location", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "SUBAREA", "length": 50, "alias": "Sub Area", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ZONE", "length": 50, "alias": "Mowing Zone", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "WORKDESC", "length": 350, "alias": "Work Description", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ACRES_GCALC", "alias": "ACRES_GCALC", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CHECK_", "length": 250, "alias": "CHECK_", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "x_MowResponsibility", "description": "Contractor or individual bid", "type": "codedValue", "codedValues": [ { "code": "Individual Bid", "name": "Individual Bid" }, { "code": "Contractor", "name": "Contractor" }, { "code": "Washington County", "name": "Washington County" }, { "code": "Internal", "name": "Internal" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Responsibility", "length": 25, "alias": "Responsibility", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PENALTYFEE", "alias": "Penalty Fee", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FACILITYID", "length": 255, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CYCLE", "alias": "Cycle", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "Comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "x_MowDepartment", "description": "Department responsible for mowing areas or contracting", "type": "codedValue", "codedValues": [ { "code": "Public Works", "name": "Public Works" }, { "code": "Parks & Recreation", "name": "Parks & Recreation" }, { "code": "Not Internal", "name": "Not Internal" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "DEPARTMENT", "length": 50, "alias": "Department", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, { "nullable": true, "domain": null, "name": "Shape.STArea()", "alias": "Shape.STArea()", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Shape.STLength()", "alias": "Shape.STLength()", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Agreement", "length": 255, "alias": "Agreement", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "AgreementDate", "length": 8, "alias": "Agreement Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "ChangeOrder", "alias": "Change Order", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "ChangeOrderDate", "length": 8, "alias": "Change Order Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "DueDate", "length": 8, "alias": "Due Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "BidYear", "length": 255, "alias": "Bid Year", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" }, "preferredTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" }, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": 0, "xyTolerance": 0.0032808333333333331, "mUnits": 1, "zUnits": 1, "latestWkid": 2274, "zTolerance": 0.001, "wkid": 102736, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -121521300, "falseY": -93934000, "falseZ": 0 }, "description": "", "canModifyLayer": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "standardMaxRecordCountNoGeometry": 32000, "indexes": [ { "name": "R2278_pk", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_2278", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "S1657_idx", "isUnique": true, "description": "", "fields": "Shape", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "supportsDatumTransformation": true, "minScale": 0, "supportsDynamicLegends": true, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsStatistics": true, "supportsTrueCurve": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "serviceItemId": "288eddca4ba44a68873af9cbe1a49567", "supportsCoordinatesQuantization": true, "capabilities": "Map,Query,Data", "maxScale": 0, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "tileMaxRecordCount": 4000, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, geoJSON, PBF", "hasLabels": false, "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.69999999999999996, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 252, 199, 206, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "name": "Shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon" }] }