{
"layers": [],
"tables": [
{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 3,
"name": "Structure Inspection Table",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"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": 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,
"supportsQueryAttachments": true,
"supportsQueryAttachmentsWithReturnUrl": 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": true,
"supportsAttachmentsByUploadId": true,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "globalid",
"displayField": "typeofinspection",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "struc_id",
"type": "esriFieldTypeInteger",
"alias": "Structure ID",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "struc_id"
},
{
"name": "typeofinspection",
"type": "esriFieldTypeString",
"alias": "Type of Inspection",
"domain": {
"type": "codedValue",
"name": "SWMTypeInsp",
"description": "Type of Inspection",
"codedValues": [
{
"name": "Routine",
"code": "Routine"
},
{
"name": "Complaint",
"code": "Complaint"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "typeofinspection"
},
{
"name": "majorissue",
"type": "esriFieldTypeString",
"alias": "Major Issue (1)",
"domain": {
"type": "codedValue",
"name": "SWMMajIssuePoint",
"description": "Major Issues Structure",
"codedValues": [
{
"name": "Blockage",
"code": "Blockage"
},
{
"name": "Erosion",
"code": "Erosion"
},
{
"name": "Sedimentation",
"code": "Sedimentation"
},
{
"name": "Structure damage",
"code": "Structure_damage"
},
{
"name": "Grate Top Missing",
"code": "Grate_Top_Missing"
},
{
"name": "Manhole Lid Missing",
"code": "Manhole_Lid_Missing"
},
{
"name": "Could Not Inspect",
"code": "Could_Not_Inspect"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "majorissue"
},
{
"name": "majorissue2",
"type": "esriFieldTypeString",
"alias": "Major Issue (2)",
"domain": {
"type": "codedValue",
"name": "SWMMajIssuePoint",
"description": "Major Issues Structure",
"codedValues": [
{
"name": "Blockage",
"code": "Blockage"
},
{
"name": "Erosion",
"code": "Erosion"
},
{
"name": "Sedimentation",
"code": "Sedimentation"
},
{
"name": "Structure damage",
"code": "Structure_damage"
},
{
"name": "Grate Top Missing",
"code": "Grate_Top_Missing"
},
{
"name": "Manhole Lid Missing",
"code": "Manhole_Lid_Missing"
},
{
"name": "Could Not Inspect",
"code": "Could_Not_Inspect"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "majorissue2"
},
{
"name": "majorissue3",
"type": "esriFieldTypeString",
"alias": "Major Issue (3)",
"domain": {
"type": "codedValue",
"name": "SWMMajIssuePoint",
"description": "Major Issues Structure",
"codedValues": [
{
"name": "Blockage",
"code": "Blockage"
},
{
"name": "Erosion",
"code": "Erosion"
},
{
"name": "Sedimentation",
"code": "Sedimentation"
},
{
"name": "Structure damage",
"code": "Structure_damage"
},
{
"name": "Grate Top Missing",
"code": "Grate_Top_Missing"
},
{
"name": "Manhole Lid Missing",
"code": "Manhole_Lid_Missing"
},
{
"name": "Could Not Inspect",
"code": "Could_Not_Inspect"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "majorissue3"
},
{
"name": "inspectorcomment",
"type": "esriFieldTypeString",
"alias": "Inspector Comment",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "inspectorcomment"
},
{
"name": "globalid",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "globalid"
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "System-maintained ObjectID"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "Inspected by",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "Inspection date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "Last edited by",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "Last edited date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
},
{
"name": "ORIG_GLOBALID",
"type": "esriFieldTypeGUID",
"alias": "ORIG_GLOBALID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "ORIG_GLOBALID"
}
],
"indexes": [
{
"name": "R1591_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_1591",
"fields": "globalid",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "G48735struc_id",
"fields": "struc_id",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I48735ORIG_GLOBA",
"fields": "ORIG_GLOBALID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_1591",
"fields": "globalid,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Structure Inspection Table",
"description": "",
"prototype": {
"attributes": {
"last_edited_date": null,
"struc_id": null,
"typeofinspection": null,
"majorissue": null,
"majorissue2": null,
"majorissue3": null,
"inspectorcomment": null,
"ORIG_GLOBALID": null,
"last_edited_user": null,
"created_user": null,
"created_date": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"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": 2000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 5,
"name": "Segment Inspection Table",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"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": 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,
"supportsQueryAttachments": true,
"supportsQueryAttachmentsWithReturnUrl": 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": true,
"supportsAttachmentsByUploadId": true,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "globalid",
"displayField": "typeofinspection",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "seg_id",
"type": "esriFieldTypeInteger",
"alias": "Segment ID",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "seg_id"
},
{
"name": "typeofinspection",
"type": "esriFieldTypeString",
"alias": "Type of Inspection",
"domain": {
"type": "codedValue",
"name": "SWMTypeInsp",
"description": "Type of Inspection",
"codedValues": [
{
"name": "Routine",
"code": "Routine"
},
{
"name": "Complaint",
"code": "Complaint"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "typeofinspection"
},
{
"name": "majorissue",
"type": "esriFieldTypeString",
"alias": "Major Issue (1)",
"domain": {
"type": "codedValue",
"name": "SWMMajIssueSeg",
"description": "Major Issues Segment",
"codedValues": [
{
"name": "Sinkhole forming",
"code": "Sinkhole_forming"
},
{
"name": "Pipe Separation",
"code": "Pipe_Separation"
},
{
"name": "Blockage/Debris",
"code": "Blockage_or_Debris"
},
{
"name": "Major erosion",
"code": "Major_erosion"
},
{
"name": "Major sedimentation",
"code": "Major_sedimentation"
},
{
"name": "Encroachment in easement",
"code": "Encroachment_in_easement"
},
{
"name": "Displaced rip rap",
"code": "Displaced_rip_rap"
},
{
"name": "Vegetation issue",
"code": "Vegetation_issue"
},
{
"name": "Could not inspect",
"code": "Could_not_inspect"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "majorissue"
},
{
"name": "majorissue2",
"type": "esriFieldTypeString",
"alias": "Major Issue (2)",
"domain": {
"type": "codedValue",
"name": "SWMMajIssueSeg",
"description": "Major Issues Segment",
"codedValues": [
{
"name": "Sinkhole forming",
"code": "Sinkhole_forming"
},
{
"name": "Pipe Separation",
"code": "Pipe_Separation"
},
{
"name": "Blockage/Debris",
"code": "Blockage_or_Debris"
},
{
"name": "Major erosion",
"code": "Major_erosion"
},
{
"name": "Major sedimentation",
"code": "Major_sedimentation"
},
{
"name": "Encroachment in easement",
"code": "Encroachment_in_easement"
},
{
"name": "Displaced rip rap",
"code": "Displaced_rip_rap"
},
{
"name": "Vegetation issue",
"code": "Vegetation_issue"
},
{
"name": "Could not inspect",
"code": "Could_not_inspect"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "majorissue2"
},
{
"name": "majorissue3",
"type": "esriFieldTypeString",
"alias": "Major Issue (3)",
"domain": {
"type": "codedValue",
"name": "SWMMajIssueSeg",
"description": "Major Issues Segment",
"codedValues": [
{
"name": "Sinkhole forming",
"code": "Sinkhole_forming"
},
{
"name": "Pipe Separation",
"code": "Pipe_Separation"
},
{
"name": "Blockage/Debris",
"code": "Blockage_or_Debris"
},
{
"name": "Major erosion",
"code": "Major_erosion"
},
{
"name": "Major sedimentation",
"code": "Major_sedimentation"
},
{
"name": "Encroachment in easement",
"code": "Encroachment_in_easement"
},
{
"name": "Displaced rip rap",
"code": "Displaced_rip_rap"
},
{
"name": "Vegetation issue",
"code": "Vegetation_issue"
},
{
"name": "Could not inspect",
"code": "Could_not_inspect"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "majorissue3"
},
{
"name": "inspectorcomment",
"type": "esriFieldTypeString",
"alias": "Inspector Comment",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "inspectorcomment"
},
{
"name": "globalid",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "globalid"
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "System-maintained ObjectID"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "Inspected by",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "Inspection date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "Last edited by",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "Last edited date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
},
{
"name": "ORIG_GLOBALID",
"type": "esriFieldTypeGUID",
"alias": "ORIG_GLOBALID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "ORIG_GLOBALID"
}
],
"indexes": [
{
"name": "R1593_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_1593",
"fields": "globalid",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "G48737seg_id",
"fields": "seg_id",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I48737ORIG_GLOBA",
"fields": "ORIG_GLOBALID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_1593",
"fields": "globalid,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Segment Inspection Table",
"description": "",
"prototype": {
"attributes": {
"last_edited_date": null,
"seg_id": null,
"typeofinspection": null,
"majorissue": null,
"majorissue2": null,
"majorissue3": null,
"inspectorcomment": null,
"ORIG_GLOBALID": null,
"last_edited_user": null,
"created_user": null,
"created_date": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"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": 2000,
"maxRecordCountFactor": 1
}
]
}