{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "CatchBasin", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "
Stormwater combination inlets, curb inlets, and drop inlets owned by the City of Durham and available for adoption through the Adopt-A-Drain program managed by the Public Works Department.<\/SPAN><\/P> Definition query for export from Stormwater Nodes feature class managed by the Public Works Department:<\/SPAN><\/P> STATUS = 'Active' And (TYPE = 'COMBO INLET' Or TYPE = 'CURB INLET' Or TYPE = 'DROP INLET') And (OWNER = 'CITY' Or OWNER = 'CITY-ROW')<\/SPAN><\/P><\/DIV><\/DIV>",
"copyrightText": "City of Durham Public Works Department",
"editFieldsInfo": {
"creationDateField": "CreationDate",
"creatorField": "Creator",
"editDateField": "EditDate",
"editorField": "Editor",
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
}
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [
{
"id": 0,
"name": "GISDiv.GISDIV.PW_CatchBasinActivities",
"relatedTableId": 1,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "globalid",
"composite": false
}
],
"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,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsQueryWithDatumTransformation": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true
},
"hasMetadata": true,
"extent": {
"xmin": -8794580.67431737,
"ymin": 4282396.881866121,
"xmax": -8769573.911553705,
"ymax": 4324181.793164006,
"spatialReference": {
"wkid": 102100,
"latestWkid": 3857,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -20037700,
"falseY": -30241100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"sourceSpatialReference": {
"wkid": 102719,
"latestWkid": 2264,
"xyTolerance": 0.003280833333333333,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -121841900,
"falseY": -93659000,
"xyUnits": 3048.0060960121928,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
},
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
80,
168,
60,
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": true,
"hasZ": true,
"enableZDefaults": false,
"supportsVCSProjection": true,
"allowUpdateWithoutMValues": false,
"allowGeometryUpdates": true,
"allowTrueCurvesUpdates": true,
"onlyAllowTrueCurveUpdatesByTrueCurveClients": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": true,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "nickname",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "objectid",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "FACILITYID",
"type": "esriFieldTypeString",
"alias": "Asset ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "FACILITYID"
},
{
"name": "CreationDate",
"type": "esriFieldTypeDate",
"alias": "Creation date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "CreationDate"
},
{
"name": "Creator",
"type": "esriFieldTypeString",
"alias": "Creator",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "Creator"
},
{
"name": "EditDate",
"type": "esriFieldTypeDate",
"alias": "Last update",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "EditDate"
},
{
"name": "Editor",
"type": "esriFieldTypeString",
"alias": "Updated by",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "Editor"
},
{
"name": "adoptedby",
"type": "esriFieldTypeString",
"alias": "Adopted By",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "adoptedby"
},
{
"name": "adoptedon",
"type": "esriFieldTypeDate",
"alias": "Adopted On",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "adoptedon"
},
{
"name": "nickname",
"type": "esriFieldTypeString",
"alias": "Nickname",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "nickname"
},
{
"name": "LOCATION",
"type": "esriFieldTypeString",
"alias": "Nearest Address",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "LOCATION"
},
{
"name": "publicview",
"type": "esriFieldTypeString",
"alias": "Publicly Visible",
"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": "publicview"
},
{
"name": "TYPE",
"type": "esriFieldTypeString",
"alias": "Asset Type",
"domain": null,
"editable": true,
"nullable": true,
"length": 16,
"defaultValue": null,
"modelName": "TYPE"
},
{
"name": "ADOPTED",
"type": "esriFieldTypeString",
"alias": "Adopted",
"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": "ADOPTED"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SHAPE"
},
"indexes": [
{
"name": "R541_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_541",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S502_idx",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "CatchBasin",
"description": "",
"prototype": {
"attributes": {
"ADOPTED": null,
"FACILITYID": null,
"TYPE": null,
"publicview": null,
"LOCATION": null,
"nickname": null,
"adoptedby": null,
"adoptedon": null
}
},
"drawingTool": "esriFeatureEditToolPoint"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 8000,
"standardMaxRecordCountNoGeometry": 32000,
"maxRecordCountFactor": 1,
"serviceItemId": "b11fd882745845ad895ef9a472ecd7bc"
},
{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 5,
"name": "CatchBasinVolunteers",
"type": "Feature Layer",
"parentLayer": null,
"defaultVisibility": true,
"minScale": 0,
"maxScale": 0,
"canScaleSymbols": false,
"geometryType": "esriGeometryPoint",
"description": " A feature layer used to store catch basin volunteers and clearing activities for use in the Adopt-A-Drain program managed by the City of Durham Public Works Department.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user",
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
}
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [
{
"id": 1,
"name": "GISDiv.GISDIV.PW_CatchBasinActivities",
"relatedTableId": 1,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "globalid",
"composite": false
}
],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"extent",
"count"
],
"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,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true
},
"hasMetadata": true,
"extent": {
"xmin": "NaN",
"ymin": "NaN",
"xmax": "NaN",
"ymax": "NaN",
"spatialReference": {
"wkid": 102100,
"latestWkid": 3857,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -20037700,
"falseY": -30241100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"sourceSpatialReference": {
"wkid": 102719,
"latestWkid": 2264,
"xyTolerance": 0.003280833333333333,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -121841900,
"falseY": -93659000,
"xyUnits": 3048.0060960121928,
"falseZ": -100000,
"zUnits": 10000,
"falseM": 0,
"mUnits": 1
},
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
117,
53,
163,
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": true,
"enableZDefaults": false,
"supportsVCSProjection": true,
"allowGeometryUpdates": true,
"allowTrueCurvesUpdates": true,
"onlyAllowTrueCurveUpdatesByTrueCurveClients": true,
"hasAttachments": true,
"supportsAttachmentsByUploadId": true,
"supportsApplyEditsWithGlobalIds": true,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"objectIdField": "OBJECTID",
"globalIdField": "globalid",
"displayField": "pocfirstname",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "pocfirstname",
"type": "esriFieldTypeString",
"alias": "First Name",
"domain": null,
"editable": true,
"nullable": true,
"length": 150,
"defaultValue": null,
"modelName": "pocfirstname"
},
{
"name": "poclastname",
"type": "esriFieldTypeString",
"alias": "Last Name",
"domain": null,
"editable": true,
"nullable": true,
"length": 150,
"defaultValue": null,
"modelName": "poclastname"
},
{
"name": "pocfullname",
"type": "esriFieldTypeString",
"alias": "Full Name",
"domain": null,
"editable": true,
"nullable": true,
"length": 300,
"defaultValue": null,
"modelName": "pocfullname"
},
{
"name": "pocphone",
"type": "esriFieldTypeString",
"alias": "Phone Number",
"domain": null,
"editable": true,
"nullable": true,
"length": 15,
"defaultValue": null,
"modelName": "pocphone"
},
{
"name": "pocemail",
"type": "esriFieldTypeString",
"alias": "Email",
"domain": null,
"editable": true,
"nullable": true,
"length": 150,
"defaultValue": null,
"modelName": "pocemail"
},
{
"name": "fulladdr",
"type": "esriFieldTypeString",
"alias": "Address",
"domain": null,
"editable": true,
"nullable": true,
"length": 500,
"defaultValue": null,
"modelName": "fulladdr"
},
{
"name": "municipality",
"type": "esriFieldTypeString",
"alias": "Municipality",
"domain": null,
"editable": true,
"nullable": true,
"length": 150,
"defaultValue": null,
"modelName": "municipality"
},
{
"name": "state",
"type": "esriFieldTypeString",
"alias": "State",
"domain": null,
"editable": true,
"nullable": true,
"length": 2,
"defaultValue": null,
"modelName": "state"
},
{
"name": "zipcode",
"type": "esriFieldTypeString",
"alias": "Zip Code",
"domain": null,
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": null,
"modelName": "zipcode"
},
{
"name": "team",
"type": "esriFieldTypeString",
"alias": "Team",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "team"
},
{
"name": "username",
"type": "esriFieldTypeString",
"alias": "Username",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "username"
},
{
"name": "status",
"type": "esriFieldTypeString",
"alias": "Status",
"domain": {
"type": "codedValue",
"name": "ApprovalStatus",
"description": "Pending, Approved or Denied",
"codedValues": [
{
"name": "Pending",
"code": "Pending"
},
{
"name": "Approved",
"code": "Approved"
},
{
"name": "Denied",
"code": "Dened"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "status"
},
{
"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 By",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "Created On",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "Last Edited By",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "Last Edited On",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
},
{
"name": "orgorbiz",
"type": "esriFieldTypeString",
"alias": "Organization or Business?",
"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": "orgorbiz"
},
{
"name": "orgname",
"type": "esriFieldTypeString",
"alias": "Organization Name",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "orgname"
},
{
"name": "orgtype",
"type": "esriFieldTypeString",
"alias": "Organization Type",
"domain": {
"type": "codedValue",
"name": "OtherOrgType",
"description": "",
"codedValues": [
{
"name": "City/County",
"code": "City/County"
},
{
"name": "Civic/Club",
"code": "Civic/Club"
},
{
"name": "Corporate/Business",
"code": "Corporate/Business"
},
{
"name": "Facility",
"code": "Facility"
},
{
"name": "Faith-Based",
"code": "Faith-Based"
},
{
"name": "Individual",
"code": "Individual"
},
{
"name": "NonProfit",
"code": "NonProfit"
},
{
"name": "School",
"code": "School"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "orgtype"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Shape"
},
"indexes": [
{
"name": "R543_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_543",
"fields": "globalid",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S503_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "CatchBasinVolunteers",
"description": "",
"prototype": {
"attributes": {
"orgname": null,
"pocfirstname": null,
"poclastname": null,
"pocfullname": null,
"pocphone": null,
"pocemail": null,
"fulladdr": null,
"municipality": null,
"state": null,
"zipcode": null,
"team": null,
"username": null,
"status": null,
"orgtype": null,
"orgorbiz": null
}
},
"drawingTool": "esriFeatureEditToolPoint"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"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,
"serviceItemId": "b11fd882745845ad895ef9a472ecd7bc"
}
],
"tables": [
{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 1,
"name": "CatchBasinActivities",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user",
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
}
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [
{
"id": 0,
"name": "GISDiv.GISDIV.PW_CatchBasin",
"relatedTableId": 4,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "cbglobalid",
"composite": false
},
{
"id": 1,
"name": "GISDiv.GISDIV.PW_CatchBasinVolunteers",
"relatedTableId": 5,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "cbvglobalid",
"composite": false
}
],
"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,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "username",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "activitydate",
"type": "esriFieldTypeDate",
"alias": "Activity Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "activitydate"
},
{
"name": "cbglobalid",
"type": "esriFieldTypeGUID",
"alias": "Catch Basin GlobalID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "cbglobalid"
},
{
"name": "username",
"type": "esriFieldTypeString",
"alias": "Username",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "username"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "Created By",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "Created On",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "Last Edited By",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "Last Edited On",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
},
{
"name": "notes",
"type": "esriFieldTypeString",
"alias": "Notes",
"domain": null,
"editable": true,
"nullable": true,
"length": 4000,
"defaultValue": null,
"modelName": "notes"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
},
{
"name": "cbvglobalid",
"type": "esriFieldTypeGUID",
"alias": "Catch Basin Volunteer GlobalID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "cbvglobalid"
}
],
"indexes": [
{
"name": "R542_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_542",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "G1058cbvglobalid",
"fields": "cbvglobalid",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I1058cbglobalid",
"fields": "cbglobalid",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "CatchBasinActivities",
"description": "",
"prototype": {
"attributes": {
"cbvglobalid": null,
"activitydate": null,
"cbglobalid": null,
"username": null,
"notes": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 2000,
"maxRecordCountFactor": 1,
"serviceItemId": "b11fd882745845ad895ef9a472ecd7bc"
}
]
}