{
"tables": [
{
"supportsApplyEditsWithGlobalIds": true,
"maxRecordCount": 1000,
"attachmentProperties": [
{
"fieldName": "attachmentid",
"isEnabled": true,
"name": "id"
},
{
"fieldName": "globalid",
"isEnabled": true,
"name": "globalId"
},
{
"fieldName": "att_name",
"isEnabled": true,
"name": "name"
},
{
"fieldName": "data_size",
"isEnabled": true,
"name": "size"
},
{
"fieldName": "content_type",
"isEnabled": true,
"name": "contentType"
},
{
"fieldName": "keywords",
"isEnabled": false,
"name": "keywords"
},
{
"fieldName": "exifinfo",
"isEnabled": false,
"name": "exifInfo"
}
],
"attachmentFields": [
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "attachmentid",
"alias": "attachmentid",
"type": "esriFieldTypeOID"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"length": 38,
"name": "globalid",
"alias": "globalid",
"type": "esriFieldTypeGlobalID"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"length": 250,
"name": "att_name",
"alias": "att_name",
"type": "esriFieldTypeString"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "data_size",
"alias": "data_size",
"type": "esriFieldTypeInteger"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"length": 150,
"name": "content_type",
"alias": "content_type",
"type": "esriFieldTypeString"
}
],
"infoInEstimates": [
"extent",
"count"
],
"type": "Table",
"hasStaticData": false,
"supportsAttachmentsByUploadId": true,
"syncEnabled": false,
"relationships": [
{
"keyField": "projid",
"role": "esriRelRoleDestination",
"composite": false,
"name": "",
"relatedTableId": 0,
"id": "0",
"cardinality": "esriRelCardinalityOneToMany"
}
],
"supportsAttachmentsResizing": true,
"id": 1,
"supportsStatistics": true,
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"standardMaxRecordCount": 16000,
"isDataVersioned": false,
"templates": [
{
"name": "Project Comments",
"description": "",
"drawingTool": "esriFeatureEditToolNone",
"prototype": {
"attributes": {
"projid": null,
"comments": null,
"submitdt": null,
"name": " "
}
}
}
],
"supportsAdvancedQueries": true,
"currentVersion": 11.3,
"advancedEditingCapabilities": {
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportsReturnEditResults": true,
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportedApplyEditsUploadIDFormats": "JSON"
},
"objectIdField": "objectid",
"supportsQuantizationEditMode": true,
"name": "Project Comments",
"displayField": null,
"supportsCalculate": true,
"fields": [
{
"nullable": false,
"editable": false,
"defaultValue": null,
"length": 4,
"type": "esriFieldTypeOID",
"domain": null,
"name": "objectid",
"alias": "OBJECTID"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "projid",
"length": 38,
"alias": "Project Identifier",
"type": "esriFieldTypeGUID"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "comments",
"length": 255,
"alias": "Comments",
"type": "esriFieldTypeString"
},
{
"nullable": false,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "name",
"length": 150,
"alias": "Name",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"precision": 1,
"name": "submitdt",
"length": 29,
"alias": "Date Submitted",
"type": "esriFieldTypeDate"
},
{
"nullable": false,
"editable": false,
"defaultValue": "NEWID() WITH VALUES",
"length": 38,
"type": "esriFieldTypeGlobalID",
"domain": null,
"name": "globalid",
"alias": "GlobalID"
},
{
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"length": 255,
"name": "created_user",
"alias": "created_user",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"precision": 1,
"length": 29,
"name": "created_date",
"alias": "created_date",
"type": "esriFieldTypeDate"
},
{
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"length": 255,
"name": "last_edited_user",
"alias": "last_edited_user",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"precision": 1,
"length": 29,
"name": "last_edited_date",
"alias": "last_edited_date",
"type": "esriFieldTypeDate"
}
],
"maxRecordCountFactor": 1,
"dateFieldsTimeReference": {
"respectsDaylightSaving": false,
"timeZone": "UTC"
},
"supportsFieldDescriptionProperty": true,
"allowGeometryUpdates": true,
"isView": true,
"useStandardizedQueries": true,
"globalIdField": "globalid",
"description": "",
"syncCanReturnChanges": true,
"supportsAsyncDelete": true,
"isUpdatableView": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin"
],
"supportsRollbackOnFailureParameter": true,
"isDataReplicaTracked": false,
"supportsTruncate": false,
"indexes": [
{
"name": "r96_sde_rowid_uk",
"isUnique": true,
"description": "",
"fields": "objectid",
"isAcsending": true
},
{
"name": "uuid_96",
"isUnique": true,
"description": "",
"fields": "globalid",
"isAcsending": true
}
],
"supportedAppendSourceFilterFormats": "featureService",
"editFieldsInfo": {
"editDateField": "last_edited_date",
"editorField": "last_edited_user",
"creationDateField": "created_date",
"creatorField": "created_user"
},
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"GUIDFormat": "O",
"hasAttachments": true,
"queryBinsCapabilities": {
"supportedStatisticTypes": [
"count",
"sum",
"min",
"max",
"avg",
"stddev",
"var",
"percentile_cont",
"percentile_disc"
],
"supportsFixedIntervalBin": true,
"supportsAutoIntervalBin": true,
"supportsFixedBoundariesBin": true,
"supportsDateBin": true
},
"advancedQueryCapabilities": {
"supportsSqlExpression": true,
"supportsQueryWithResultType": true,
"supportsQueryRelatedPagination": true,
"supportsQueryWithCacheHint": false,
"supportsQueryWithDatumTransformation": true,
"supportsCurrentUserQueries": true,
"supportsQueryAttachmentsWithReturnUrl": true,
"supportsDefaultSR": true,
"supportsQueryDateBins": false,
"supportsQueryWithLodSR": false,
"supportsPaginationOnAggregatedQueries": true,
"supportsMaxRecordCountFactor": true,
"supportsPagination": true,
"supportsStatistics": true,
"supportsOrderBy": true,
"supportsFullTextSearch": false,
"supportsLod": false,
"supportsAdvancedQueryRelated": true,
"supportsQueryAttachments": true,
"supportsQueryAttachmentsCountOnly": true,
"supportsReturningQueryExtent": true,
"supportsOrderByOnlyOnLayerFields": false,
"supportsOutFieldSqlExpression": true,
"supportsTopFeaturesQuery": true,
"supportsDistinct": true,
"supportsQueryAnalytic": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true
},
"serviceItemId": "351345e10c5841debd887c89133cdc9f",
"supportsValidateSql": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": true,
"types": [],
"capabilities": "Query",
"supportsAppend": true,
"supportsExceedsLimitStatistics": true,
"sourceSchemaChangesAllowed": true,
"defaultVisibility": true,
"advancedQueryAnalyticCapabilities": {
"supportsAsync": true,
"supportsLinearRegression": true,
"supportsPercentileAnalytic": false
},
"hasMetadata": false,
"supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService",
"uniqueIdField": {
"isSystemMaintained": true,
"name": "OBJECTID"
},
"tileMaxRecordCount": 4000,
"typeIdField": "",
"supportsASyncCalculate": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"sqlParserVersion": "PG_11.2.0",
"copyrightText": "Esri",
"supportsLayerOverrides": true
}
],
"layers": [
{
"extent": {
"ymin": 4649021.74167815,
"xmin": -1.3536450080461381E7,
"ymax": 4667955.016783948,
"xmax": -1.3524761533928087E7,
"spatialReference": {"wkid": 102100}
},
"supportsApplyEditsWithGlobalIds": true,
"maxRecordCount": 1000,
"attachmentProperties": [
{
"fieldName": "attachmentid",
"isEnabled": true,
"name": "id"
},
{
"fieldName": "globalid",
"isEnabled": true,
"name": "globalId"
},
{
"fieldName": "att_name",
"isEnabled": true,
"name": "name"
},
{
"fieldName": "data_size",
"isEnabled": true,
"name": "size"
},
{
"fieldName": "content_type",
"isEnabled": true,
"name": "contentType"
},
{
"fieldName": "keywords",
"isEnabled": false,
"name": "keywords"
},
{
"fieldName": "exifinfo",
"isEnabled": false,
"name": "exifInfo"
}
],
"attachmentFields": [
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "attachmentid",
"alias": "attachmentid",
"type": "esriFieldTypeOID"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"length": 38,
"name": "globalid",
"alias": "globalid",
"type": "esriFieldTypeGlobalID"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"length": 250,
"name": "att_name",
"alias": "att_name",
"type": "esriFieldTypeString"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "data_size",
"alias": "data_size",
"type": "esriFieldTypeInteger"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"domain": null,
"length": 150,
"name": "content_type",
"alias": "content_type",
"type": "esriFieldTypeString"
}
],
"infoInEstimates": [
"extent",
"count"
],
"type": "Feature Layer",
"hasStaticData": false,
"supportsAttachmentsByUploadId": true,
"syncEnabled": false,
"relationships": [
{
"keyField": "globalid",
"role": "esriRelRoleOrigin",
"composite": false,
"name": "",
"relatedTableId": 1,
"id": "0",
"cardinality": "esriRelCardinalityOneToMany"
}
],
"supportsAttachmentsResizing": true,
"id": 0,
"supportsStatistics": true,
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"standardMaxRecordCount": 2000,
"isDataVersioned": false,
"templates": [],
"hasGeometryProperties": true,
"supportsAdvancedQueries": true,
"currentVersion": 11.3,
"hasZ": false,
"advancedEditingCapabilities": {
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportsReturnEditResults": true,
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportedApplyEditsUploadIDFormats": "JSON"
},
"objectIdField": "objectid",
"supportsQuantizationEditMode": true,
"viewSourceHasAttachments": true,
"name": "Infrastructure Projects",
"displayField": "projname",
"supportsCalculate": true,
"fields": [
{
"nullable": false,
"editable": false,
"defaultValue": null,
"length": 4,
"type": "esriFieldTypeOID",
"domain": null,
"name": "objectid",
"alias": "OBJECTID"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"length": 38,
"type": "esriFieldTypeGlobalID",
"domain": null,
"name": "globalid",
"alias": "GlobalID"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "projname",
"length": 255,
"alias": "Project Name",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "projdesc",
"length": 1000,
"alias": "Description",
"type": "esriFieldTypeString"
},
{
"nullable": false,
"editable": true,
"defaultValue": null,
"length": 50,
"description": "{\"fieldValueType\":\"\",\"value\":\"The predominant improvement justifying the project.\"}",
"type": "esriFieldTypeString",
"domain": {
"name": "InfrastructureProjects_787295bd29094dbb8f08d8f96a64f5e3_piProjectType",
"type": "codedValue",
"codedValues": [
{
"code": "Facilities",
"name": "Facilities"
},
{
"code": "Transportation",
"name": "Transportation"
},
{
"code": "Other",
"name": "Other"
},
{
"code": "Parks & Recreation",
"name": "Parks & Recreation"
},
{
"code": "Sewer",
"name": "Sewer"
},
{
"code": "Water",
"name": "Water"
},
{
"code": "Flood/Drainage",
"name": "Flood/Drainage"
}
]
},
"name": "projtype",
"alias": "Project Type"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"precision": 1,
"name": "planstart",
"length": 29,
"alias": "Planned Start Date",
"type": "esriFieldTypeDate"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"precision": 1,
"name": "planend",
"length": 29,
"alias": "Planned End Date",
"type": "esriFieldTypeDate"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "estcost",
"alias": "Estimated Cost",
"type": "esriFieldTypeDouble"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 255,
"description": "{\"fieldValueType\":\"\",\"value\":\"Project Manager\"}",
"type": "esriFieldTypeString",
"domain": null,
"name": "pocname",
"alias": "Project Manager"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "pocphone",
"length": 12,
"alias": "Contact Phone",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "pocemail",
"length": 255,
"alias": "Contact Email",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 255,
"description": "{\"fieldValueType\":\"\",\"value\":\"Project progression from beginning to end.\"}",
"type": "esriFieldTypeString",
"domain": {
"name": "InfrastructureProjects_787295bd29094dbb8f08d8f96a64f5e3_piProjectPhase",
"type": "codedValue",
"codedValues": [
{
"code": "PreDesign",
"name": "PreDesign"
},
{
"code": "Design (PA&ED)",
"name": "Design (PA&ED)"
},
{
"code": "Construction",
"name": "Construction"
},
{
"code": "Closeout",
"name": "Closeout"
},
{
"code": "Complete",
"name": "Complete"
},
{
"code": "Study",
"name": "Study"
},
{
"code": "Final Design (PS&E)",
"name": "Final Design (PS&E)"
},
{
"code": "Design Build/Install",
"name": "Design Build/Install"
},
{
"code": "Ongoing",
"name": "Ongoing"
}
]
},
"name": "projphase",
"alias": "Project Phase"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"precision": 1,
"name": "actstart",
"length": 29,
"alias": "Actual Start Date",
"type": "esriFieldTypeDate"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"precision": 1,
"name": "actend",
"length": 29,
"alias": "Actual End Date",
"type": "esriFieldTypeDate"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "docpath",
"length": 1000,
"alias": "Document Path",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 256,
"description": "{\"fieldValueType\":\"nameOrTitle\",\"value\":\"Department Name\"}",
"type": "esriFieldTypeString",
"domain": {
"name": "DEPARTMENT",
"type": "codedValue",
"codedValues": [
{
"code": "City Manager Office",
"name": "City Manager Office"
},
{
"code": "Community Development",
"name": "Community Development"
},
{
"code": "Economic Development & Housing",
"name": "Economic Development & Housing"
},
{
"code": "Fire",
"name": "Fire"
},
{
"code": "Parks & Recreation",
"name": "Parks & Recreation"
},
{
"code": "Police",
"name": "Police"
},
{
"code": "Public Works",
"name": "Public Works"
},
{
"code": "Capital Projects",
"name": "Capital Projects"
}
]
},
"name": "department",
"alias": "Department"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 256,
"description": "{\"fieldValueType\":\"\",\"value\":\"Subdivision\"}",
"type": "esriFieldTypeString",
"domain": {
"name": "WORKGROUP",
"type": "codedValue",
"codedValues": [
{
"code": "ADM - Accounts",
"name": "ADM - Accounts"
},
{
"code": "ADM - Budget",
"name": "ADM - Budget"
},
{
"code": "ADM - IT",
"name": "ADM - IT"
},
{
"code": "ADM - Public Finance",
"name": "ADM - Public Finance"
},
{
"code": "CD - Aministration",
"name": "CD - Aministration"
},
{
"code": "CD - Building",
"name": "CD - Building"
},
{
"code": "CD - Code Enforcement",
"name": "CD - Code Enforcement"
},
{
"code": "CD - Development Engineering",
"name": "CD - Development Engineering"
},
{
"code": "CD - Flood Protection",
"name": "CD - Flood Protection"
},
{
"code": "CD - Planning",
"name": "CD - Planning"
},
{
"code": "CM - City Clerk",
"name": "CM - City Clerk"
},
{
"code": "CM - Community Relations",
"name": "CM - Community Relations"
},
{
"code": "CM - Human Resources",
"name": "CM - Human Resources"
},
{
"code": "CM - Parking Management",
"name": "CM - Parking Management"
},
{
"code": "EDH - Economic Development & Housing",
"name": "EDH - Economic Development & Housing"
},
{
"code": "EDH - Port",
"name": "EDH - Port"
},
{
"code": "FI - Administration",
"name": "FI - Administration"
},
{
"code": "FI - Emergency Operations",
"name": "FI - Emergency Operations"
},
{
"code": "FI - HazMat/Prevention",
"name": "FI - HazMat/Prevention"
},
{
"code": "PD - Support Services",
"name": "PD - Support Services"
},
{
"code": "PD - Uniformed Services",
"name": "PD - Uniformed Services"
},
{
"code": "PR - Administration",
"name": "PR - Administration"
},
{
"code": "PR - Early Learning Services",
"name": "PR - Early Learning Services"
},
{
"code": "PR - Park Maintenance",
"name": "PR - Park Maintenance"
},
{
"code": "PR - Recreation",
"name": "PR - Recreation"
},
{
"code": "PW - Administration",
"name": "PW - Administration"
},
{
"code": "PW - Engineering",
"name": "PW - Engineering"
},
{
"code": "PW - Environmental Services",
"name": "PW - Environmental Services"
},
{
"code": "PW - Facilities Development",
"name": "PW - Facilities Development"
},
{
"code": "PW - Operations",
"name": "PW - Operations"
}
]
},
"name": "workgroup",
"alias": "Subdivision"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": {
"name": "ACCESSTYPE",
"type": "codedValue",
"codedValues": [
{
"code": "Employees",
"name": "Employees"
},
{
"code": "Public",
"name": "Public"
},
{
"code": "Maintenance",
"name": "Maintenance"
},
{
"code": "Security",
"name": "Security"
}
]
},
"name": "accesstype",
"length": 50,
"alias": "Access Type",
"type": "esriFieldTypeString"
},
{
"virtual": true,
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "SHAPE__Length",
"alias": "SHAPE__Length",
"type": "esriFieldTypeDouble"
},
{
"virtual": true,
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "SHAPE__Area",
"alias": "SHAPE__Area",
"type": "esriFieldTypeDouble"
}
],
"maxRecordCountFactor": 1,
"dateFieldsTimeReference": {
"respectsDaylightSaving": false,
"timeZone": "UTC"
},
"supportsFieldDescriptionProperty": true,
"hasM": false,
"allowGeometryUpdates": true,
"isView": true,
"useStandardizedQueries": true,
"globalIdField": "globalid",
"description": "",
"syncCanReturnChanges": true,
"supportsAsyncDelete": true,
"isUpdatableView": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin"
],
"geometryProperties": {
"shapeAreaFieldName": "SHAPE__Area",
"shapeLengthFieldName": "SHAPE__Length",
"units": "esriMeters"
},
"supportsRollbackOnFailureParameter": true,
"isDataReplicaTracked": false,
"standardMaxRecordCountNoGeometry": 16000,
"supportsTruncate": false,
"indexes": [
{
"name": "r92_sde_rowid_uk",
"isUnique": true,
"description": "",
"fields": "objectid",
"isAcsending": true
},
{
"name": "uuid_92",
"isUnique": true,
"description": "",
"fields": "globalid",
"isAcsending": true
},
{
"name": "a52_ix1",
"isUnique": false,
"description": "",
"fields": "shape",
"isAcsending": true
},
{
"name": "accesstype_Index",
"isUnique": false,
"description": "accesstype_Index",
"fields": "accesstype",
"isAscending": true
},
{
"name": "department_Index",
"isUnique": false,
"description": "department_Index",
"fields": "department",
"isAscending": true
}
],
"supportedAppendSourceFilterFormats": "featureService",
"editFieldsInfo": {
"editDateField": "last_edited_date",
"editorField": "last_edited_user",
"creationDateField": "created_date",
"creatorField": "created_user"
},
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"GUIDFormat": "O",
"minScale": 234814,
"hasAttachments": true,
"queryBinsCapabilities": {
"supportedStatisticTypes": [
"count",
"sum",
"min",
"max",
"avg",
"stddev",
"var",
"percentile_cont",
"percentile_disc"
],
"supportsFixedIntervalBin": true,
"supportsAutoIntervalBin": true,
"supportsFixedBoundariesBin": true,
"supportsDateBin": true
},
"advancedQueryCapabilities": {
"supportsSqlExpression": true,
"supportsQueryWithResultType": true,
"supportsQueryRelatedPagination": true,
"supportsQueryWithCacheHint": false,
"supportsQueryWithDatumTransformation": true,
"supportsCurrentUserQueries": true,
"supportsQueryAttachmentsWithReturnUrl": true,
"supportsDefaultSR": true,
"supportsQueryDateBins": false,
"supportsQueryWithLodSR": true,
"supportsPaginationOnAggregatedQueries": true,
"supportsPagination": true,
"supportsMaxRecordCountFactor": true,
"supportsStatistics": true,
"supportsOrderBy": true,
"supportsReturningGeometryProperties": true,
"supportsFullTextSearch": false,
"supportsQueryWithDistance": true,
"supportsLod": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryAttachments": true,
"supportsReturningQueryExtent": true,
"supportsQueryAttachmentsCountOnly": true,
"supportsOrderByOnlyOnLayerFields": false,
"supportsOutFieldSqlExpression": true,
"supportsTopFeaturesQuery": true,
"supportsReturningGeometryEnvelope": true,
"supportsDistinct": true,
"supportsReturningGeometryCentroid": true,
"supportsQueryAnalytic": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true
},
"serviceItemId": "351345e10c5841debd887c89133cdc9f",
"supportsValidateSql": true,
"supportsValidateSQL": true,
"allowUpdateWithoutMValues": true,
"supportsCoordinatesQuantization": true,
"types": [
{
"templates": [
{
"name": "Facilities",
"description": "",
"prototype": {
"attributes": {
"workgroup": null,
"accesstype": null,
"pocname": null,
"actend": null,
"actstart": null,
"pocphone": null,
"pocemail": null,
"planstart": null,
"projname": null,
"projdesc": null,
"projtype": "Facilities",
"estcost": null,
"projphase": null,
"department": null,
"planend": null,
"docpath": null
}
}
}
],
"name": "Facilities",
"id": "Facilities"
},
{
"templates": [
{
"name": "Parks & Recreation",
"description": "",
"prototype": {
"attributes": {
"workgroup": null,
"accesstype": null,
"pocname": null,
"actend": null,
"actstart": null,
"pocphone": null,
"pocemail": null,
"planstart": null,
"projname": null,
"projdesc": null,
"projtype": "Parks & Recreation",
"estcost": null,
"projphase": null,
"department": null,
"planend": null,
"docpath": null
}
}
}
],
"name": "Parks & Recreation",
"id": "Parks & Recreation"
},
{
"templates": [
{
"name": "Sewer",
"description": "",
"prototype": {
"attributes": {
"workgroup": null,
"accesstype": null,
"pocname": null,
"actend": null,
"actstart": null,
"pocphone": null,
"pocemail": null,
"planstart": null,
"projname": null,
"projdesc": null,
"projtype": "Sewer",
"estcost": null,
"projphase": null,
"department": null,
"planend": null,
"docpath": null
}
}
}
],
"name": "Sewer",
"id": "Sewer"
},
{
"templates": [
{
"name": "Transportation",
"description": "",
"prototype": {
"attributes": {
"workgroup": null,
"accesstype": null,
"pocname": null,
"actend": null,
"actstart": null,
"pocphone": null,
"pocemail": null,
"planstart": null,
"projname": null,
"projdesc": null,
"projtype": "Transportation",
"estcost": null,
"projphase": null,
"department": null,
"planend": null,
"docpath": null
}
}
}
],
"name": "Transportation",
"id": "Transportation"
},
{
"templates": [
{
"name": "Water",
"description": "",
"prototype": {
"attributes": {
"workgroup": null,
"accesstype": null,
"pocname": null,
"actend": null,
"actstart": null,
"pocphone": null,
"pocemail": null,
"planstart": null,
"projname": null,
"projdesc": null,
"projtype": "Water",
"estcost": null,
"projphase": null,
"department": null,
"planend": null,
"docpath": null
}
}
}
],
"name": "Water",
"id": "Water"
},
{
"templates": [
{
"name": "Other",
"description": "",
"prototype": {
"attributes": {
"workgroup": null,
"accesstype": null,
"pocname": null,
"actend": null,
"actstart": null,
"pocphone": null,
"pocemail": null,
"planstart": null,
"projname": null,
"projdesc": null,
"projtype": "Other",
"estcost": null,
"projphase": null,
"department": null,
"planend": null,
"docpath": null
}
}
}
],
"name": "Other",
"id": "Other"
}
],
"capabilities": "Query",
"maxScale": 0,
"supportsAppend": true,
"supportsExceedsLimitStatistics": true,
"sourceSchemaChangesAllowed": true,
"defaultVisibility": true,
"advancedQueryAnalyticCapabilities": {
"supportsAsync": true,
"supportsLinearRegression": true,
"supportsPercentileAnalytic": false
},
"hasMetadata": false,
"supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService",
"uniqueIdField": {
"isSystemMaintained": true,
"name": "OBJECTID"
},
"tileMaxRecordCount": 2000,
"typeIdField": "projtype",
"supportsASyncCalculate": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportsMultiScaleGeometry": true,
"sqlParserVersion": "PG_11.2.0",
"drawingInfo": {
"renderer": {
"field1": "projtype",
"defaultSymbol": null,
"uniqueValueInfos": [
{
"symbol": {
"outline": {
"color": [
255,
0,
0,
255
],
"width": 1.5,
"style": "esriSLSSolid",
"type": "esriSLS"
},
"color": null,
"style": "esriSFSSolid",
"type": "esriSFS"
},
"label": "Facilities",
"value": "Facilities"
},
{
"symbol": {
"outline": {
"color": [
85,
255,
0,
255
],
"width": 1.5,
"style": "esriSLSSolid",
"type": "esriSLS"
},
"color": null,
"style": "esriSFSSolid",
"type": "esriSFS"
},
"label": "Parks & Recreation",
"value": "Parks & Recreation"
},
{
"symbol": {
"outline": {
"color": [
255,
170,
0,
255
],
"width": 1.5,
"style": "esriSLSSolid",
"type": "esriSLS"
},
"color": null,
"style": "esriSFSSolid",
"type": "esriSFS"
},
"label": "Sewer",
"value": "Sewer"
},
{
"symbol": {
"outline": {
"color": [
197,
0,
255,
255
],
"width": 1.5,
"style": "esriSLSSolid",
"type": "esriSLS"
},
"color": null,
"style": "esriSFSSolid",
"type": "esriSFS"
},
"label": "Transportation",
"value": "Transportation"
},
{
"symbol": {
"outline": {
"color": [
0,
92,
230,
255
],
"width": 1.5,
"style": "esriSLSSolid",
"type": "esriSLS"
},
"color": null,
"style": "esriSFSSolid",
"type": "esriSFS"
},
"label": "Water",
"value": "Water"
},
{
"symbol": {
"outline": {
"color": [
26,
26,
26,
255
],
"width": 1.5,
"style": "esriSLSSolid",
"type": "esriSLS"
},
"color": null,
"style": "esriSFSSolid",
"type": "esriSFS"
},
"label": "Other",
"value": "Other"
}
],
"type": "uniqueValue"
},
"transparency": 20
},
"geometryField": {
"sqlType": "sqlTypeOther",
"nullable": true,
"editable": true,
"name": "shape",
"typeName": "st_geometry",
"length": 2147483647,
"type": "esriFieldTypeGeometry"
},
"copyrightText": "Esri",
"geometryType": "esriGeometryPolygon",
"supportsLayerOverrides": true
}
]
}