{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 56,
"name": "HydrantInspectionTable",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "STREETNAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "FACILITYID",
"type": "esriFieldTypeString",
"alias": "Facility Identifier",
"length": 20,
"domain": null
},
{
"name": "DATE",
"type": "esriFieldTypeDate",
"alias": "Today's Date",
"length": 8,
"domain": null
},
{
"name": "LOCDESC",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 200,
"domain": null
},
{
"name": "ROTATION",
"type": "esriFieldTypeDouble",
"alias": "Rotation",
"domain": null
},
{
"name": "MANUFACTURER",
"type": "esriFieldTypeString",
"alias": "Manufacturer",
"length": 30,
"domain": {
"type": "codedValue",
"name": "wHydrantManufacturer",
"description": "The name of the hydrant manufacturer",
"codedValues": [
{
"name": "American Darling",
"code": "American Darling"
},
{
"name": "American Standard",
"code": "American Standard"
},
{
"name": "AVK",
"code": "AVK"
},
{
"name": "Clow Corporation",
"code": "Clow Corporation"
},
{
"name": "Corey",
"code": "Corey"
},
{
"name": "Dresser",
"code": "Dresser"
},
{
"name": "Eddy",
"code": "Eddy"
},
{
"name": "Iowa Valve",
"code": "Iowa Valve"
},
{
"name": "Kennedy Valve",
"code": "Kennedy Valve"
},
{
"name": "M&H Valve",
"code": "M&H Valve"
},
{
"name": "M&H Valve / Dresser",
"code": "M&H Valve / Dresser"
},
{
"name": "Mueller Company",
"code": "Mueller Company"
},
{
"name": "Other",
"code": "Other"
},
{
"name": "Traverse City",
"code": "Traverse City"
},
{
"name": "Unknown",
"code": "Unknown"
},
{
"name": "US Pipe",
"code": "US Pipe"
},
{
"name": "Waterous",
"code": "Waterous"
},
{
"name": "Wood-Matthews",
"code": "Wood-Matthews"
},
{
"name": "Anniston",
"code": "Anniston"
},
{
"name": "AVF",
"code": "AVF"
},
{
"name": "Hydrant Post",
"code": "Hydrant Post"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "MAINTENANCE",
"type": "esriFieldTypeString",
"alias": "Maintenance Required",
"length": 150,
"domain": {
"type": "codedValue",
"name": "wHydrantMaint",
"description": "Maintenance condition of a fire hydrant",
"codedValues": [
{
"name": "Repaint",
"code": "Repaint"
},
{
"name": "Pressure Gage Attached",
"code": "Pressure Gage Attached"
},
{
"name": "Trim Vegetation",
"code": "Trim Vegetation"
},
{
"name": "Service Required",
"code": "Service Required"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "LASTSERVICE",
"type": "esriFieldTypeDate",
"alias": "Last Service Date",
"length": 8,
"domain": null
},
{
"name": "ENABLED",
"type": "esriFieldTypeSmallInteger",
"alias": "Enabled",
"domain": {
"type": "codedValue",
"name": "EnabledDomain",
"description": "Geometric Network Enabled domain",
"codedValues": [
{
"name": "False",
"code": 0
},
{
"name": "True",
"code": 1
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ACTIVEFLAG",
"type": "esriFieldTypeSmallInteger",
"alias": "Active Flag",
"domain": {
"type": "codedValue",
"name": "BooleanDomain",
"description": "A 0/1 boolean domain",
"codedValues": [
{
"name": "False",
"code": 0
},
{
"name": "True",
"code": 1
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "OWNEDBY",
"type": "esriFieldTypeSmallInteger",
"alias": "Owned By",
"domain": {
"type": "codedValue",
"name": "AssetOwner",
"description": "The owner of the asset",
"codedValues": [
{
"name": "City of Wylie",
"code": 1
},
{
"name": "Private",
"code": -1
},
{
"name": "Other",
"code": -2
},
{
"name": "NTMWD",
"code": 2
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "MAINTBY",
"type": "esriFieldTypeSmallInteger",
"alias": "Managed By",
"domain": {
"type": "codedValue",
"name": "AssetManager",
"description": "The manager of the asset",
"codedValues": [
{
"name": "Private",
"code": -1
},
{
"name": "Other",
"code": -2
},
{
"name": "City of Wylie",
"code": 1
},
{
"name": "NTMWD",
"code": 2
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "LASTUPDATE",
"type": "esriFieldTypeDate",
"alias": "Last Update Date",
"length": 8,
"domain": null
},
{
"name": "LASTEDITOR",
"type": "esriFieldTypeString",
"alias": "Last Editor",
"length": 50,
"domain": null
},
{
"name": "PRESSURE",
"type": "esriFieldTypeInteger",
"alias": "Pressure",
"domain": null
},
{
"name": "COLOR",
"type": "esriFieldTypeString",
"alias": "Color",
"length": 50,
"domain": {
"type": "codedValue",
"name": "wHydrantColor",
"description": "Waterline color code",
"codedValues": [
{
"name": "Blue",
"code": "Blue"
},
{
"name": "Red",
"code": "Red"
},
{
"name": "Silver",
"code": "Silver"
},
{
"name": "Yellow",
"code": "Yellow"
},
{
"name": "White & Black",
"code": "White & Black"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "COMMENTS",
"type": "esriFieldTypeString",
"alias": "Comments",
"length": 50,
"domain": null
},
{
"name": "EMPLNUM",
"type": "esriFieldTypeInteger",
"alias": "Employee Number",
"domain": null
},
{
"name": "IN_SERV",
"type": "esriFieldTypeString",
"alias": "In Service",
"length": 5,
"domain": {
"type": "codedValue",
"name": "wHydrantYesorNo",
"description": "Yes or No for Hydrant In Service",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "MARKED",
"type": "esriFieldTypeString",
"alias": "Marked",
"length": 5,
"domain": {
"type": "codedValue",
"name": "YesNo",
"description": "A yes/no indicator",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
},
{
"name": "N/A",
"code": "N/A"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STRNUM",
"type": "esriFieldTypeInteger",
"alias": "Street Number",
"domain": null
},
{
"name": "STREETNAME",
"type": "esriFieldTypeString",
"alias": "Street Name",
"length": 100,
"domain": null
},
{
"name": "YEAR",
"type": "esriFieldTypeInteger",
"alias": "Year",
"domain": null
},
{
"name": "HYDRANTID",
"type": "esriFieldTypeString",
"alias": "Hydrant ID",
"length": 100,
"domain": null
},
{
"name": "CALLBOX",
"type": "esriFieldTypeString",
"alias": "Call Box Number",
"length": 100,
"domain": null
},
{
"name": "WATERDISTRICT",
"type": "esriFieldTypeString",
"alias": "Water District",
"length": 50,
"domain": null
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255,
"domain": null
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8,
"domain": null
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255,
"domain": null
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8,
"domain": null
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
},
{
"name": "Locked",
"type": "esriFieldTypeString",
"alias": "Locked",
"length": 255,
"domain": {
"type": "codedValue",
"name": "YesNo",
"description": "A yes/no indicator",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
},
{
"name": "N/A",
"code": "N/A"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Crew",
"type": "esriFieldTypeString",
"alias": "Crew",
"length": 255,
"domain": {
"type": "codedValue",
"name": "HydrantCrews",
"description": "Used for Hydrant Inspection Crew Assigner",
"codedValues": [
{
"name": "A1",
"code": "A1"
},
{
"name": "A2",
"code": "A2"
},
{
"name": "A3",
"code": "A3"
},
{
"name": "B1",
"code": "B1"
},
{
"name": "B2",
"code": "B2"
},
{
"name": "B3",
"code": "B3"
},
{
"name": "C1",
"code": "C1"
},
{
"name": "C2",
"code": "C2"
},
{
"name": "C3",
"code": "C3"
},
{
"name": "A4",
"code": "A4"
},
{
"name": "B4",
"code": "B4"
},
{
"name": "C4",
"code": "C4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Complete",
"type": "esriFieldTypeString",
"alias": "Complete",
"length": 255,
"domain": {
"type": "codedValue",
"name": "YesNo",
"description": "A yes/no indicator",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
},
{
"name": "N/A",
"code": "N/A"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
}
],
"indexes": [
{
"name": "R909_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_909",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_909",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "GDB_8252_HYDRANT",
"fields": "HYDRANTID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 0,
"name": "HydrantInspection",
"relatedTableId": 0,
"role": "esriRelRoleDestination",
"keyField": "HYDRANTID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, PBF",
"isDataVersioned": true,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": null,
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"serviceItemId": "f9f519917e434d6d94a5be7da606f76f"
}