{
"layers": [
{
"currentVersion": 10.9,
"cimVersion": "2.7.0",
"id": 0,
"name": "Street Work Orders",
"type": "Feature Layer",
"parentLayer": null,
"defaultVisibility": true,
"minScale": 0,
"maxScale": 0,
"canScaleSymbols": false,
"geometryType": "esriGeometryPoint",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user"
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [],
"isDataVersioned": true,
"isDataArchived": false,
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": false,
"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,
"supportsQueryAttachments": true,
"supportsQueryAttachmentsWithReturnUrl": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsQueryWithDatumTransformation": true,
"supportsLod": false,
"supportsQueryWithLodSR": false
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
]
},
"hasMetadata": true,
"extent": {
"xmin": 1371432.6868970953,
"ymin": 271154.49483577907,
"xmax": 1458606.4302001782,
"ymax": 517640.8214159459,
"spatialReference": {
"wkid": 102697,
"latestWkid": 102697,
"xyTolerance": 0.00328083333333333,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -16806900,
"falseY": -45827300,
"xyUnits": 3048.00609601219,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"sourceSpatialReference": {
"wkid": 102697,
"latestWkid": 102697,
"xyTolerance": 0.00328083333333333,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -16806900,
"falseY": -45827300,
"xyUnits": 3048.00609601219,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
153,
47,
135,
255
],
"size": 4,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"hasM": false,
"hasZ": false,
"allowGeometryUpdates": false,
"allowTrueCurvesUpdates": false,
"onlyAllowTrueCurveUpdatesByTrueCurveClients": false,
"hasAttachments": true,
"supportsAttachmentsByUploadId": true,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "WORKTYPE",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "WORKTYPE",
"type": "esriFieldTypeString",
"alias": "Work Type",
"domain": {
"type": "codedValue",
"name": "StreetWorkType",
"description": "Streets work type",
"codedValues": [
{
"name": "AdoptAStreet",
"code": "AdoptAStreet"
},
{
"name": "Banners",
"code": "Banners"
},
{
"name": "Barricades",
"code": "Barricades"
},
{
"name": "Bridge Work",
"code": "Bridge Work"
},
{
"name": "Brush Hog",
"code": "Brush Hog"
},
{
"name": "Christmas Lights/Decorations",
"code": "Christmas Lights/Decorations"
},
{
"name": "CID Work",
"code": "CID Work"
},
{
"name": "City Hall Grounds Maintenance",
"code": "City Hall Grounds Maintenance"
},
{
"name": "Clean Up Spring/Fall",
"code": "Clean Up Spring/Fall"
},
{
"name": "Cleaning Ditches",
"code": "Cleaning Ditches"
},
{
"name": "Computer Work",
"code": "Computer Work"
},
{
"name": "Concrete/Curb Work/Sidewalk",
"code": "Concrete/Curb Work/Sidewalk"
},
{
"name": "Crack Seal",
"code": "Crack Seal"
},
{
"name": "Delineators",
"code": "Delineators"
},
{
"name": "Emergency Signage",
"code": "Emergency Signage"
},
{
"name": "Equipment Maintenance",
"code": "Equipment Maintenance"
},
{
"name": "FEMA",
"code": "FEMA"
},
{
"name": "Flags on Gretna",
"code": "Flags on Gretna"
},
{
"name": "Guardrail",
"code": "Guardrail"
},
{
"name": "Handrail",
"code": "Handrail"
},
{
"name": "Hauling Material",
"code": "Hauling Material"
},
{
"name": "Inspections/Checks",
"code": "Inspections/Checks"
},
{
"name": "Landscaping",
"code": "Landscaping"
},
{
"name": "Moving/Transporting Equip/Items",
"code": "Moving/Transporting Equip/Items"
},
{
"name": "Mowing",
"code": "Mowing"
},
{
"name": "Mow Crew Mowing",
"code": "Mow Crew Mowing"
},
{
"name": "Other",
"code": "Other"
},
{
"name": "Parades (other)",
"code": "Parades (other)"
},
{
"name": "Parking Blocks",
"code": "Parking Blocks"
},
{
"name": "Paver Repairs",
"code": "Paver Repairs"
},
{
"name": "PD/FD Assistance",
"code": "PD/FD Assistance"
},
{
"name": "Potholes",
"code": "Potholes"
},
{
"name": "Purchasing",
"code": "Purchasing"
},
{
"name": "Road Kill Removal",
"code": "Road Kill Removal"
},
{
"name": "Safety/Other Meetings",
"code": "Safety/Other Meetings"
},
{
"name": "Shop Maintenance",
"code": "Shop Maintenance"
},
{
"name": "SideArm Mowing",
"code": "SideArm Mowing"
},
{
"name": "Snow Event",
"code": "Snow Event"
},
{
"name": "Snow Plow Maintenance",
"code": "Snow Plow Maintenance"
},
{
"name": "Spraying",
"code": "Spraying"
},
{
"name": "Storm Drain Maintenance",
"code": "Storm Drain Maintenance"
},
{
"name": "Storm Drain Repair",
"code": "Storm Drain Repair"
},
{
"name": "Street Lights",
"code": "Street Lights"
},
{
"name": "Street Patching",
"code": "Street Patching"
},
{
"name": "Striping",
"code": "Striping"
},
{
"name": "Sweeping",
"code": "Sweeping"
},
{
"name": "Traffic Signals",
"code": "Traffic Signals"
},
{
"name": "Trail Work",
"code": "Trail Work"
},
{
"name": "Training",
"code": "Training"
},
{
"name": "Trash Pickup",
"code": "Trash Pickup"
},
{
"name": "Tree Trimming",
"code": "Tree Trimming"
},
{
"name": "Utilities Patch/Repair",
"code": "Utilities Patch/Repair"
},
{
"name": "Special Event",
"code": "Special Event"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "WORKTYPE"
},
{
"name": "COMMENTS",
"type": "esriFieldTypeString",
"alias": "Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 1000,
"defaultValue": null,
"modelName": "COMMENTS"
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"domain": {
"type": "codedValue",
"name": "mMaintenanceStatus",
"description": "Maintenance Status",
"codedValues": [
{
"name": "Submitted",
"code": "Submitted"
},
{
"name": "Assigned",
"code": "Assigned"
},
{
"name": "In Progress",
"code": "In Progress"
},
{
"name": "On Hold",
"code": "On Hold"
},
{
"name": "Complete",
"code": "Complete"
},
{
"name": "Canceled",
"code": "Canceled"
},
{
"name": "On Break",
"code": "On Break"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "STATUS"
},
{
"name": "PRIORITY",
"type": "esriFieldTypeString",
"alias": "Priority",
"domain": {
"type": "codedValue",
"name": "StreetWorkOrderPriority",
"description": "Streets work order priority",
"codedValues": [
{
"name": "1",
"code": "1"
},
{
"name": "2",
"code": "2"
},
{
"name": "3",
"code": "3"
},
{
"name": "4",
"code": "4"
},
{
"name": "5",
"code": "5"
},
{
"name": "6",
"code": "6"
},
{
"name": "7",
"code": "7"
},
{
"name": "8",
"code": "8"
},
{
"name": "9",
"code": "9"
},
{
"name": "10",
"code": "10"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "PRIORITY"
},
{
"name": "DUEDATE",
"type": "esriFieldTypeDate",
"alias": "Due Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "DUEDATE"
},
{
"name": "WORKORDERNUMBER",
"type": "esriFieldTypeString",
"alias": "Work Order Number",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "WORKORDERNUMBER"
},
{
"name": "ASSIGNEE",
"type": "esriFieldTypeString",
"alias": "Assignee",
"domain": {
"type": "codedValue",
"name": "StreetAssigneeTeam",
"description": "Street Assignee Team",
"codedValues": [
{
"name": "Team 1 (Blue)",
"code": "Team 1"
},
{
"name": "Team 2 (Green)",
"code": "Team 2"
},
{
"name": "Team 3 (Orange)",
"code": "Team 3"
},
{
"name": "Team 4 (Red)",
"code": "Team 4"
},
{
"name": "Unassigned",
"code": "Unassigned"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "ASSIGNEE"
},
{
"name": "COMPLETIONDATE",
"type": "esriFieldTypeDate",
"alias": "Date Completed",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "COMPLETIONDATE"
},
{
"name": "STARTDATE",
"type": "esriFieldTypeDate",
"alias": "Date Started",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "STARTDATE"
},
{
"name": "TITLE",
"type": "esriFieldTypeString",
"alias": "Job title",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "TITLE"
},
{
"name": "DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Job Description",
"domain": null,
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "DESCRIPTION"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
},
{
"name": "NEARADDR",
"type": "esriFieldTypeString",
"alias": "Nearest address",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "NEARADDR"
},
{
"name": "INDVASSIGNEE",
"type": "esriFieldTypeString",
"alias": "Individual assignee",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "INDVASSIGNEE"
},
{
"name": "DIMENSIONS",
"type": "esriFieldTypeString",
"alias": "Dimensions",
"domain": null,
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "DIMENSIONS"
},
{
"name": "INCIDENTAL",
"type": "esriFieldTypeString",
"alias": "Incidental",
"domain": {
"type": "codedValue",
"name": "YesNo",
"description": "A yes/no indicator",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "INCIDENTAL"
},
{
"name": "HISTORICSURVEYRECORD",
"type": "esriFieldTypeGUID",
"alias": "Historic Survey Record",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "HISTORICSURVEYRECORD"
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null,
"editable": false,
"nullable": true,
"defaultValue": null,
"modelName": "SHAPE"
},
"indexes": [
{
"name": "R1430_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_1430",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_1430",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S1045_idx",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Street Work Orders",
"description": "",
"prototype": {
"attributes": {}
},
"drawingTool": "esriFeatureEditToolPoint"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"capabilities": "Query",
"useStandardizedQueries": true,
"attachmentProperties": [
{
"name": "id",
"fieldName": "ATTACHMENTID",
"isEnabled": true
},
{
"name": "globalId",
"fieldName": "GLOBALID",
"isEnabled": true
},
{
"name": "name",
"fieldName": "ATT_NAME",
"isEnabled": true
},
{
"name": "size",
"fieldName": "DATA_SIZE",
"isEnabled": true
},
{
"name": "contentType",
"fieldName": "CONTENT_TYPE",
"isEnabled": true
},
{
"name": "keywords",
"fieldName": "KEYWORDS",
"isEnabled": false
},
{
"name": "exifInfo",
"fieldName": "EXIFINFO",
"isEnabled": false
}
],
"attachmentFields": [
{
"name": "ATTACHMENTID",
"type": "esriFieldTypeOID",
"alias": "ATTACHMENTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null
},
{
"name": "GLOBALID",
"type": "esriFieldTypeGlobalID",
"alias": "GLOBALID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null
},
{
"name": "ATT_NAME",
"type": "esriFieldTypeString",
"alias": "ATT_NAME",
"domain": null,
"editable": true,
"nullable": false,
"length": 250,
"defaultValue": null
},
{
"name": "DATA_SIZE",
"type": "esriFieldTypeInteger",
"alias": "DATA_SIZE",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null
},
{
"name": "CONTENT_TYPE",
"type": "esriFieldTypeString",
"alias": "CONTENT_TYPE",
"domain": null,
"editable": true,
"nullable": false,
"length": 150,
"defaultValue": null
}
],
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 8000,
"standardMaxRecordCountNoGeometry": 32000,
"maxRecordCountFactor": 1
}
],
"tables": [
{
"currentVersion": 10.9,
"cimVersion": "2.7.0",
"id": 1,
"name": "Streets Equipment",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user"
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": true,
"isDataArchived": false,
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": false,
"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,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
]
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "NAME",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "NAME",
"type": "esriFieldTypeString",
"alias": "Name",
"domain": null,
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "NAME"
},
{
"name": "ACTIVE",
"type": "esriFieldTypeString",
"alias": "Active",
"domain": {
"type": "codedValue",
"name": "YesNo",
"description": "A yes/no indicator",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "ACTIVE"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
}
],
"indexes": [
{
"name": "R1429_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Streets Equipment",
"description": "",
"prototype": {
"attributes": {
"ACTIVE": null,
"NAME": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"capabilities": "Query",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 10.9,
"cimVersion": "2.7.0",
"id": 2,
"name": "Street Crew",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user"
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": true,
"isDataArchived": false,
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": false,
"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,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
]
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "NAME",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "NAME",
"type": "esriFieldTypeString",
"alias": "Name",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "NAME"
},
{
"name": "ACTIVE",
"type": "esriFieldTypeString",
"alias": "Active (Yes/No)",
"domain": {
"type": "codedValue",
"name": "YesNo",
"description": "A yes/no indicator",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "ACTIVE"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
},
{
"name": "EMAIL",
"type": "esriFieldTypeString",
"alias": "Email",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "EMAIL"
},
{
"name": "TEAM",
"type": "esriFieldTypeString",
"alias": "Team",
"domain": {
"type": "codedValue",
"name": "StreetAssigneeTeam",
"description": "Street Assignee Team",
"codedValues": [
{
"name": "Team 1 (Blue)",
"code": "Team 1"
},
{
"name": "Team 2 (Green)",
"code": "Team 2"
},
{
"name": "Team 3 (Orange)",
"code": "Team 3"
},
{
"name": "Team 4 (Red)",
"code": "Team 4"
},
{
"name": "Unassigned",
"code": "Unassigned"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 25,
"defaultValue": null,
"modelName": "TEAM"
}
],
"indexes": [
{
"name": "R1401_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Street Crew",
"description": "",
"prototype": {
"attributes": {
"EMAIL": null,
"TEAM": null,
"NAME": null,
"ACTIVE": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"capabilities": "Query",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 10.9,
"cimVersion": "2.7.0",
"id": 3,
"name": "Street Work Types",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user"
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": true,
"isDataArchived": false,
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": false,
"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,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
]
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "CATEGORY",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "CATEGORY",
"type": "esriFieldTypeString",
"alias": "Work category",
"domain": {
"type": "codedValue",
"name": "StreetWorkTypes",
"description": "Street work types",
"codedValues": [
{
"name": "General",
"code": "General"
},
{
"name": "CID",
"code": "CID"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "CATEGORY"
},
{
"name": "TYPE",
"type": "esriFieldTypeString",
"alias": "Type",
"domain": null,
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "TYPE"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
}
],
"indexes": [
{
"name": "R1428_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Street Work Types",
"description": "",
"prototype": {
"attributes": {
"TYPE": null,
"CATEGORY": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"capabilities": "Query",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
}
]
}