{
"layers": [
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 0,
"name": "DC Boundary",
"type": "Feature Layer",
"parentLayer": null,
"defaultVisibility": true,
"minScale": 0,
"maxScale": 0,
"canScaleSymbols": false,
"geometryType": "esriGeometryPolygon",
"description": "<DIV STYLE=\"text-align:Left;\"><DIV><DIV><P><SPAN>The Washington DC boundary was created by connecting all of the boundary stone locations into a single polygon.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>",
"copyrightText": "Department of Buildings",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"extent",
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": true,
"supportsQuantizationEditMode": true,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"supportsDatumTransformation": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": true,
"supportsSqlExpression": true,
"supportsQueryWithDatumTransformation": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasGeometryProperties": true,
"geometryProperties": {
"shapeAreaFieldName": "Shape__Area",
"shapeLengthFieldName": "Shape__Length",
"units": "esriMeters"
},
"hasMetadata": true,
"extent": {
"xmin": 389612.306999996,
"ymin": 124868.954999998,
"xmax": 407880.11999999697,
"ymax": 147558.136999998,
"spatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.002,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 1000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"sourceSpatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.002,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 1000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
130,
130,
130,
0
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"hasM": false,
"hasZ": false,
"allowGeometryUpdates": true,
"allowTrueCurvesUpdates": false,
"onlyAllowTrueCurveUpdatesByTrueCurveClients": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"objectIdField": "OBJECTID",
"globalIdField": "GLOBALID",
"displayField": "CITY_NAME",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "CITY_FIPS",
"type": "esriFieldTypeDouble",
"alias": "CITY_FIPS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CITY_FIPS"
},
{
"name": "CITY_NAME",
"type": "esriFieldTypeString",
"alias": "CITY_NAME",
"domain": null,
"editable": true,
"nullable": true,
"length": 25,
"defaultValue": null,
"modelName": "CITY_NAME"
},
{
"name": "STATE_FIPS",
"type": "esriFieldTypeDouble",
"alias": "STATE_FIPS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "STATE_FIPS"
},
{
"name": "STATE_NAME",
"type": "esriFieldTypeString",
"alias": "STATE_NAME",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "STATE_NAME"
},
{
"name": "STATE_CITY",
"type": "esriFieldTypeDouble",
"alias": "STATE_CITY",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "STATE_CITY"
},
{
"name": "CAPITAL",
"type": "esriFieldTypeString",
"alias": "CAPITAL",
"domain": null,
"editable": true,
"nullable": true,
"length": 1,
"defaultValue": null,
"modelName": "CAPITAL"
},
{
"name": "WEB_URL",
"type": "esriFieldTypeString",
"alias": "WEB_URL",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "WEB_URL"
},
{
"name": "AREAKM",
"type": "esriFieldTypeDouble",
"alias": "AREAKM",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "AREAKM"
},
{
"name": "AREAMILES",
"type": "esriFieldTypeDouble",
"alias": "AREAMILES",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "AREAMILES"
},
{
"name": "SE_ANNO_CAD_DATA",
"type": "esriFieldTypeBlob",
"alias": "SE_ANNO_CAD_DATA",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SE_ANNO_CAD_DATA"
},
{
"name": "GIS_ID",
"type": "esriFieldTypeString",
"alias": "GIS_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "GIS_ID"
},
{
"name": "GLOBALID",
"type": "esriFieldTypeGlobalID",
"alias": "GLOBALID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GLOBALID"
},
{
"name": "CREATOR",
"type": "esriFieldTypeString",
"alias": "CREATOR",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "CREATOR"
},
{
"name": "CREATED",
"type": "esriFieldTypeDate",
"alias": "CREATED",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "CREATED"
},
{
"name": "EDITOR",
"type": "esriFieldTypeString",
"alias": "EDITOR",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "EDITOR"
},
{
"name": "EDITED",
"type": "esriFieldTypeDate",
"alias": "EDITED",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "EDITED"
},
{
"name": "Shape__Area",
"type": "esriFieldTypeDouble",
"alias": "SHAPE.AREA",
"domain": null,
"editable": false,
"required": true,
"nullable": true,
"defaultValue": null,
"modelName": "SHAPE.AREA"
},
{
"name": "Shape__Length",
"type": "esriFieldTypeDouble",
"alias": "SHAPE.LEN",
"domain": null,
"editable": false,
"required": true,
"nullable": true,
"defaultValue": null,
"modelName": "SHAPE.LEN"
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Shape"
},
"indexes": [
{
"name": "R1026_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_1026",
"fields": "GLOBALID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "A626_IX1",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "DC Boundary",
"description": "",
"prototype": {
"attributes": {
"EDITED": null,
"CITY_FIPS": null,
"CITY_NAME": null,
"STATE_FIPS": null,
"STATE_NAME": null,
"STATE_CITY": null,
"CAPITAL": null,
"WEB_URL": null,
"AREAKM": null,
"AREAMILES": null,
"SE_ANNO_CAD_DATA": null,
"GIS_ID": null,
"EDITOR": null,
"CREATOR": null,
"CREATED": null
}
},
"drawingTool": "esriFeatureEditToolPolygon"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"standardMaxRecordCount": 4000,
"tileMaxRecordCount": 4000,
"standardMaxRecordCountNoGeometry": 32000,
"maxRecordCountFactor": 1
}
],
"tables": [
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 1,
"name": "StormTrak Costing",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "ID",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "ID",
"type": "esriFieldTypeInteger",
"alias": "ID",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "ID"
},
{
"name": "TIER_TYPE",
"type": "esriFieldTypeString",
"alias": "TIER_TYPE",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "TIER_TYPE"
},
{
"name": "SEASON",
"type": "esriFieldTypeString",
"alias": "SEASON",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "SEASON"
},
{
"name": "EVENT_ID",
"type": "esriFieldTypeString",
"alias": "EVENT_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "EVENT_ID"
},
{
"name": "GROUP1",
"type": "esriFieldTypeString",
"alias": "GROUP1",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "GROUP1"
},
{
"name": "GROUP2",
"type": "esriFieldTypeString",
"alias": "GROUP2",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "GROUP2"
},
{
"name": "GROUP3",
"type": "esriFieldTypeString",
"alias": "GROUP3",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "GROUP3"
},
{
"name": "RESOURCE_ASSETS",
"type": "esriFieldTypeInteger",
"alias": "RESOURCE_ASSETS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "RESOURCE_ASSETS"
},
{
"name": "DEPLOYED_OPEN_SHIFT",
"type": "esriFieldTypeDouble",
"alias": "DEPLOYED_OPEN_SHIFT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DEPLOYED_OPEN_SHIFT"
},
{
"name": "COST_OPEN_SHIFT",
"type": "esriFieldTypeDouble",
"alias": "COST_OPEN_SHIFT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "COST_OPEN_SHIFT"
},
{
"name": "DEPLOYED_PRIOR_SHIFTS",
"type": "esriFieldTypeInteger",
"alias": "DEPLOYED_PRIOR_SHIFTS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DEPLOYED_PRIOR_SHIFTS"
},
{
"name": "COST_PRIOR_SHIFTS",
"type": "esriFieldTypeDouble",
"alias": "COST_PRIOR_SHIFTS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "COST_PRIOR_SHIFTS"
},
{
"name": "CUMULATIVE_REGULAR_TIME_COSTS",
"type": "esriFieldTypeDouble",
"alias": "CUMULATIVE_REGULAR_TIME_COSTS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CUMULATIVE_REGULAR_TIME_COSTS"
},
{
"name": "CUMULATIVE_OVERTIME_COSTS",
"type": "esriFieldTypeDouble",
"alias": "CUMULATIVE_OVERTIME_COSTS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CUMULATIVE_OVERTIME_COSTS"
},
{
"name": "INVENTORY_BALANCE",
"type": "esriFieldTypeDouble",
"alias": "INVENTORY_BALANCE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "INVENTORY_BALANCE"
},
{
"name": "INVENTORY_VALUE",
"type": "esriFieldTypeDouble",
"alias": "INVENTORY_VALUE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "INVENTORY_VALUE"
},
{
"name": "ROAD_TREATMENT_QUANTITY_USED",
"type": "esriFieldTypeDouble",
"alias": "ROAD_TREATMENT_QUANTITY_USED",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ROAD_TREATMENT_QUANTITY_USED"
},
{
"name": "ROAD_TREATMENT_COST",
"type": "esriFieldTypeDouble",
"alias": "ROAD_TREATMENT_COST",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ROAD_TREATMENT_COST"
},
{
"name": "VEHICLE_REPAIRS",
"type": "esriFieldTypeInteger",
"alias": "VEHICLE_REPAIRS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "VEHICLE_REPAIRS"
},
{
"name": "TOTAL_COST",
"type": "esriFieldTypeDouble",
"alias": "TOTAL_COST",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "TOTAL_COST"
},
{
"name": "CHART_QUANTITY",
"type": "esriFieldTypeDouble",
"alias": "CHART_QUANTITY",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CHART_QUANTITY"
},
{
"name": "CHART_COST",
"type": "esriFieldTypeDouble",
"alias": "CHART_COST",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CHART_COST"
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "StormTrak Costing",
"description": "",
"prototype": {
"attributes": {
"CHART_QUANTITY": null,
"ID": 0,
"TIER_TYPE": null,
"SEASON": null,
"EVENT_ID": null,
"GROUP1": null,
"GROUP2": null,
"GROUP3": null,
"RESOURCE_ASSETS": null,
"DEPLOYED_OPEN_SHIFT": null,
"COST_OPEN_SHIFT": null,
"DEPLOYED_PRIOR_SHIFTS": null,
"COST_PRIOR_SHIFTS": null,
"CUMULATIVE_REGULAR_TIME_COSTS": null,
"CUMULATIVE_OVERTIME_COSTS": null,
"INVENTORY_BALANCE": null,
"INVENTORY_VALUE": null,
"ROAD_TREATMENT_QUANTITY_USED": null,
"ROAD_TREATMENT_COST": null,
"VEHICLE_REPAIRS": null,
"TOTAL_COST": null,
"CHART_COST": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 2,
"name": "StormTrak Dispatch",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "ROUTE_NAME",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "STORMTRAK_DISPATCH_ID",
"type": "esriFieldTypeInteger",
"alias": "STORMTRAK_DISPATCH_ID",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "STORMTRAK_DISPATCH_ID"
},
{
"name": "EVENT_ID",
"type": "esriFieldTypeInteger",
"alias": "EVENT_ID",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "EVENT_ID"
},
{
"name": "SHIFT_ID",
"type": "esriFieldTypeInteger",
"alias": "SHIFT_ID",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SHIFT_ID"
},
{
"name": "VEHICLE_ID",
"type": "esriFieldTypeString",
"alias": "VEHICLE_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "VEHICLE_ID"
},
{
"name": "PERSON_ID",
"type": "esriFieldTypeInteger",
"alias": "PERSON_ID",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "PERSON_ID"
},
{
"name": "ROUTE_ID",
"type": "esriFieldTypeString",
"alias": "ROUTE_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "ROUTE_ID"
},
{
"name": "SNOW_TITLE",
"type": "esriFieldTypeString",
"alias": "SNOW_TITLE",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "SNOW_TITLE"
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "STATUS",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "STATUS"
},
{
"name": "VEHICLE_VIN",
"type": "esriFieldTypeString",
"alias": "VEHICLE_VIN",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "VEHICLE_VIN"
},
{
"name": "DISPATCHED_AT",
"type": "esriFieldTypeDate",
"alias": "DISPATCHED_AT",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "DISPATCHED_AT"
},
{
"name": "RECALLED_AT",
"type": "esriFieldTypeDate",
"alias": "RECALLED_AT",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "RECALLED_AT"
},
{
"name": "ZONE",
"type": "esriFieldTypeInteger",
"alias": "ZONE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ZONE"
},
{
"name": "ROUTE_NAME",
"type": "esriFieldTypeString",
"alias": "ROUTE_NAME",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "ROUTE_NAME"
},
{
"name": "DRIVER_NAME",
"type": "esriFieldTypeString",
"alias": "DRIVER_NAME",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "DRIVER_NAME"
},
{
"name": "STORMTRAK_VEHICLE_ID",
"type": "esriFieldTypeString",
"alias": "STORMTRAK_VEHICLE_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "STORMTRAK_VEHICLE_ID"
},
{
"name": "AGENCY",
"type": "esriFieldTypeString",
"alias": "AGENCY",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "AGENCY"
},
{
"name": "ALTERNATE_VEHICLE_ID",
"type": "esriFieldTypeString",
"alias": "ALTERNATE_VEHICLE_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "ALTERNATE_VEHICLE_ID"
},
{
"name": "EMPLOYEE_ID",
"type": "esriFieldTypeString",
"alias": "EMPLOYEE_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "EMPLOYEE_ID"
},
{
"name": "DRIVER_PHONE_NUMBER",
"type": "esriFieldTypeString",
"alias": "DRIVER_PHONE_NUMBER",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "DRIVER_PHONE_NUMBER"
},
{
"name": "NORMALIZED_ROUTE_NAME",
"type": "esriFieldTypeString",
"alias": "NORMALIZED_ROUTE_NAME",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "NORMALIZED_ROUTE_NAME"
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "StormTrak Dispatch",
"description": "",
"prototype": {
"attributes": {
"DRIVER_PHONE_NUMBER": null,
"STORMTRAK_DISPATCH_ID": 0,
"EVENT_ID": 0,
"SHIFT_ID": null,
"VEHICLE_ID": null,
"PERSON_ID": null,
"ROUTE_ID": null,
"SNOW_TITLE": null,
"STATUS": null,
"VEHICLE_VIN": null,
"DISPATCHED_AT": null,
"RECALLED_AT": null,
"ZONE": null,
"ROUTE_NAME": null,
"DRIVER_NAME": null,
"STORMTRAK_VEHICLE_ID": null,
"AGENCY": null,
"ALTERNATE_VEHICLE_ID": null,
"EMPLOYEE_ID": null,
"NORMALIZED_ROUTE_NAME": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 3,
"name": "StormTrak Events",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "SNOW_EVENT_NUMBER",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "SNOW_EVENT_NUMBER",
"type": "esriFieldTypeInteger",
"alias": "SNOW_EVENT_NUMBER",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "SNOW_EVENT_NUMBER"
},
{
"name": "SNOW_EVENT_LOG_ID",
"type": "esriFieldTypeInteger",
"alias": "SNOW_EVENT_LOG_ID",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "SNOW_EVENT_LOG_ID"
},
{
"name": "STORM_TYPE",
"type": "esriFieldTypeString",
"alias": "STORM_TYPE",
"domain": null,
"editable": true,
"nullable": false,
"length": 100,
"defaultValue": null,
"modelName": "STORM_TYPE"
},
{
"name": "MOBILIZATION_TYPE",
"type": "esriFieldTypeString",
"alias": "MOBILIZATION_TYPE",
"domain": null,
"editable": true,
"nullable": false,
"length": 100,
"defaultValue": null,
"modelName": "MOBILIZATION_TYPE"
},
{
"name": "SNOW_SEASON",
"type": "esriFieldTypeString",
"alias": "SNOW_SEASON",
"domain": null,
"editable": true,
"nullable": false,
"length": 100,
"defaultValue": null,
"modelName": "SNOW_SEASON"
},
{
"name": "EVENT_START",
"type": "esriFieldTypeDate",
"alias": "EVENT_START",
"domain": null,
"editable": true,
"nullable": false,
"length": 8,
"defaultValue": null,
"modelName": "EVENT_START"
},
{
"name": "EVENT_END",
"type": "esriFieldTypeDate",
"alias": "EVENT_END",
"domain": null,
"editable": true,
"nullable": false,
"length": 8,
"defaultValue": null,
"modelName": "EVENT_END"
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "STATUS",
"domain": null,
"editable": true,
"nullable": false,
"length": 100,
"defaultValue": null,
"modelName": "STATUS"
},
{
"name": "COMMENTS",
"type": "esriFieldTypeString",
"alias": "COMMENTS",
"domain": null,
"editable": true,
"nullable": true,
"length": 500,
"defaultValue": null,
"modelName": "COMMENTS"
},
{
"name": "TOTAL_STORM_COST",
"type": "esriFieldTypeDouble",
"alias": "TOTAL_STORM_COST",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "TOTAL_STORM_COST"
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "StormTrak Events",
"description": "",
"prototype": {
"attributes": {
"COMMENTS": null,
"SNOW_EVENT_NUMBER": 0,
"SNOW_EVENT_LOG_ID": 0,
"STORM_TYPE": " ",
"MOBILIZATION_TYPE": " ",
"SNOW_SEASON": " ",
"EVENT_START": -2209161600000,
"EVENT_END": -2209161600000,
"STATUS": " ",
"TOTAL_STORM_COST": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 4,
"name": "Snow Asset In Maintenance",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "ASSET_NUMBER",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "ASSET_NUMBER",
"type": "esriFieldTypeString",
"alias": "ASSET_NUMBER",
"domain": null,
"editable": true,
"nullable": false,
"length": 20,
"defaultValue": null,
"modelName": "ASSET_NUMBER"
},
{
"name": "YEAR",
"type": "esriFieldTypeInteger",
"alias": "YEAR",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "YEAR"
},
{
"name": "MAKE",
"type": "esriFieldTypeString",
"alias": "MAKE",
"domain": null,
"editable": true,
"nullable": false,
"length": 60,
"defaultValue": null,
"modelName": "MAKE"
},
{
"name": "MODEL",
"type": "esriFieldTypeString",
"alias": "MODEL",
"domain": null,
"editable": true,
"nullable": false,
"length": 60,
"defaultValue": null,
"modelName": "MODEL"
},
{
"name": "LICENSE",
"type": "esriFieldTypeString",
"alias": "LICENSE",
"domain": null,
"editable": true,
"nullable": false,
"length": 10,
"defaultValue": null,
"modelName": "LICENSE"
},
{
"name": "SERIAL_NUMBER",
"type": "esriFieldTypeString",
"alias": "SERIAL_NUMBER",
"domain": null,
"editable": true,
"nullable": false,
"length": 25,
"defaultValue": null,
"modelName": "SERIAL_NUMBER"
},
{
"name": "CLASS",
"type": "esriFieldTypeString",
"alias": "CLASS",
"domain": null,
"editable": true,
"nullable": false,
"length": 10,
"defaultValue": null,
"modelName": "CLASS"
},
{
"name": "CLASS_DESC",
"type": "esriFieldTypeString",
"alias": "CLASS_DESC",
"domain": null,
"editable": true,
"nullable": false,
"length": 256,
"defaultValue": null,
"modelName": "CLASS_DESC"
},
{
"name": "VEHICLE_INMAINTENANCE",
"type": "esriFieldTypeString",
"alias": "VEHICLE_INMAINTENANCE",
"domain": null,
"editable": true,
"nullable": false,
"length": 3,
"defaultValue": null,
"modelName": "VEHICLE_INMAINTENANCE"
},
{
"name": "START_DATETIME",
"type": "esriFieldTypeDate",
"alias": "START_DATETIME",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "START_DATETIME"
},
{
"name": "STATUSDESC",
"type": "esriFieldTypeString",
"alias": "STATUSDESC",
"domain": null,
"editable": true,
"nullable": true,
"length": 60,
"defaultValue": null,
"modelName": "STATUSDESC"
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Snow Asset In Maintenance",
"description": "",
"prototype": {
"attributes": {
"START_DATETIME": null,
"ASSET_NUMBER": " ",
"YEAR": 0,
"MAKE": " ",
"MODEL": " ",
"LICENSE": " ",
"SERIAL_NUMBER": " ",
"CLASS": " ",
"CLASS_DESC": " ",
"VEHICLE_INMAINTENANCE": " ",
"STATUSDESC": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 5,
"name": "StormTrak Costing G3",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "TIER_TYPE",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "ID",
"type": "esriFieldTypeInteger",
"alias": "ID",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "ID"
},
{
"name": "TIER_TYPE",
"type": "esriFieldTypeString",
"alias": "TIER_TYPE",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "TIER_TYPE"
},
{
"name": "SEASON",
"type": "esriFieldTypeString",
"alias": "SEASON",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "SEASON"
},
{
"name": "EVENT_ID",
"type": "esriFieldTypeString",
"alias": "EVENT_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "EVENT_ID"
},
{
"name": "GROUP1",
"type": "esriFieldTypeString",
"alias": "GROUP1",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "GROUP1"
},
{
"name": "GROUP2",
"type": "esriFieldTypeString",
"alias": "GROUP2",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "GROUP2"
},
{
"name": "GROUP3",
"type": "esriFieldTypeString",
"alias": "GROUP3",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "GROUP3"
},
{
"name": "RESOURCE_ASSETS",
"type": "esriFieldTypeInteger",
"alias": "RESOURCE_ASSETS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "RESOURCE_ASSETS"
},
{
"name": "DEPLOYED_OPEN_SHIFT",
"type": "esriFieldTypeDouble",
"alias": "DEPLOYED_OPEN_SHIFT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DEPLOYED_OPEN_SHIFT"
},
{
"name": "COST_OPEN_SHIFT",
"type": "esriFieldTypeDouble",
"alias": "COST_OPEN_SHIFT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "COST_OPEN_SHIFT"
},
{
"name": "DEPLOYED_PRIOR_SHIFTS",
"type": "esriFieldTypeInteger",
"alias": "DEPLOYED_PRIOR_SHIFTS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DEPLOYED_PRIOR_SHIFTS"
},
{
"name": "COST_PRIOR_SHIFTS",
"type": "esriFieldTypeDouble",
"alias": "COST_PRIOR_SHIFTS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "COST_PRIOR_SHIFTS"
},
{
"name": "CUMULATIVE_REGULAR_TIME_COSTS",
"type": "esriFieldTypeDouble",
"alias": "CUMULATIVE_REGULAR_TIME_COSTS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CUMULATIVE_REGULAR_TIME_COSTS"
},
{
"name": "CUMULATIVE_OVERTIME_COSTS",
"type": "esriFieldTypeDouble",
"alias": "CUMULATIVE_OVERTIME_COSTS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CUMULATIVE_OVERTIME_COSTS"
},
{
"name": "INVENTORY_BALANCE",
"type": "esriFieldTypeDouble",
"alias": "INVENTORY_BALANCE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "INVENTORY_BALANCE"
},
{
"name": "INVENTORY_VALUE",
"type": "esriFieldTypeDouble",
"alias": "INVENTORY_VALUE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "INVENTORY_VALUE"
},
{
"name": "ROAD_TREATMENT_QUANTITY_USED",
"type": "esriFieldTypeDouble",
"alias": "ROAD_TREATMENT_QUANTITY_USED",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ROAD_TREATMENT_QUANTITY_USED"
},
{
"name": "ROAD_TREATMENT_COST",
"type": "esriFieldTypeDouble",
"alias": "ROAD_TREATMENT_COST",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ROAD_TREATMENT_COST"
},
{
"name": "VEHICLE_REPAIRS",
"type": "esriFieldTypeInteger",
"alias": "VEHICLE_REPAIRS",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "VEHICLE_REPAIRS"
},
{
"name": "TOTAL_COST",
"type": "esriFieldTypeDouble",
"alias": "TOTAL_COST",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "TOTAL_COST"
},
{
"name": "CHART_QUANTITY",
"type": "esriFieldTypeDouble",
"alias": "CHART_QUANTITY",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CHART_QUANTITY"
},
{
"name": "CHART_COST",
"type": "esriFieldTypeDouble",
"alias": "CHART_COST",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CHART_COST"
},
{
"name": "SWITCH",
"type": "esriFieldTypeString",
"alias": "SWITCH",
"domain": null,
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": null,
"modelName": "SWITCH"
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "StormTrak Costing G3",
"description": "",
"prototype": {
"attributes": {
"CHART_COST": null,
"SWITCH": null,
"ID": 0,
"TIER_TYPE": null,
"SEASON": null,
"EVENT_ID": null,
"GROUP1": null,
"GROUP2": null,
"GROUP3": null,
"RESOURCE_ASSETS": null,
"DEPLOYED_OPEN_SHIFT": null,
"COST_OPEN_SHIFT": null,
"DEPLOYED_PRIOR_SHIFTS": null,
"COST_PRIOR_SHIFTS": null,
"CUMULATIVE_REGULAR_TIME_COSTS": null,
"CUMULATIVE_OVERTIME_COSTS": null,
"INVENTORY_BALANCE": null,
"INVENTORY_VALUE": null,
"ROAD_TREATMENT_QUANTITY_USED": null,
"ROAD_TREATMENT_COST": null,
"VEHICLE_REPAIRS": null,
"TOTAL_COST": null,
"CHART_QUANTITY": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 6,
"name": "StormTrak Vehicle Repair",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "NOTES",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "ID",
"type": "esriFieldTypeInteger",
"alias": "ID",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "ID"
},
{
"name": "SNOWEVENTLOGID",
"type": "esriFieldTypeInteger",
"alias": "SNOWEVENTLOGID",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SNOWEVENTLOGID"
},
{
"name": "NOTES",
"type": "esriFieldTypeString",
"alias": "NOTES",
"domain": null,
"editable": true,
"nullable": true,
"length": 4000,
"defaultValue": null,
"modelName": "NOTES"
},
{
"name": "PROBLEMDATE",
"type": "esriFieldTypeDate",
"alias": "PROBLEMDATE",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "PROBLEMDATE"
},
{
"name": "PROBLEMTIME",
"type": "esriFieldTypeDate",
"alias": "PROBLEMTIME",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "PROBLEMTIME"
},
{
"name": "PROBLEM",
"type": "esriFieldTypeString",
"alias": "PROBLEM",
"domain": null,
"editable": true,
"nullable": true,
"length": 2000,
"defaultValue": null,
"modelName": "PROBLEM"
},
{
"name": "REPAIRDATE",
"type": "esriFieldTypeDate",
"alias": "REPAIRDATE",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "REPAIRDATE"
},
{
"name": "REPAIRTIME",
"type": "esriFieldTypeDate",
"alias": "REPAIRTIME",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "REPAIRTIME"
},
{
"name": "REPAIR",
"type": "esriFieldTypeString",
"alias": "REPAIR",
"domain": null,
"editable": true,
"nullable": true,
"length": 2000,
"defaultValue": null,
"modelName": "REPAIR"
},
{
"name": "REPAIRCOMPLETEFLAG",
"type": "esriFieldTypeString",
"alias": "REPAIRCOMPLETEFLAG",
"domain": null,
"editable": true,
"nullable": true,
"length": 1,
"defaultValue": null,
"modelName": "REPAIRCOMPLETEFLAG"
},
{
"name": "VEHICLETYPE",
"type": "esriFieldTypeString",
"alias": "VEHICLETYPE",
"domain": null,
"editable": true,
"nullable": true,
"length": 40,
"defaultValue": null,
"modelName": "VEHICLETYPE"
},
{
"name": "STORMTRAKVEHICLEID",
"type": "esriFieldTypeString",
"alias": "STORMTRAKVEHICLEID",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "STORMTRAKVEHICLEID"
},
{
"name": "AGENCY",
"type": "esriFieldTypeString",
"alias": "AGENCY",
"domain": null,
"editable": true,
"nullable": true,
"length": 6,
"defaultValue": null,
"modelName": "AGENCY"
},
{
"name": "SHIFT",
"type": "esriFieldTypeInteger",
"alias": "SHIFT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SHIFT"
},
{
"name": "VEHICLETAG",
"type": "esriFieldTypeInteger",
"alias": "VEHICLETAG",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "VEHICLETAG"
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "StormTrak Vehicle Repair",
"description": "",
"prototype": {
"attributes": {
"SHIFT": null,
"VEHICLETAG": null,
"ID": 0,
"SNOWEVENTLOGID": null,
"NOTES": null,
"PROBLEMDATE": null,
"PROBLEMTIME": null,
"PROBLEM": null,
"REPAIRDATE": null,
"REPAIRTIME": null,
"REPAIR": null,
"REPAIRCOMPLETEFLAG": null,
"VEHICLETYPE": null,
"STORMTRAKVEHICLEID": null,
"AGENCY": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
}
]
}