{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 28,
"name": "tCableType",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "ASSETID",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "ASSETID",
"type": "esriFieldTypeString",
"alias": "ASSET ID",
"length": 50,
"domain": null
},
{
"name": "NUMBEROFWIRES",
"type": "esriFieldTypeSmallInteger",
"alias": "NUMBER OF WIRES",
"domain": {
"type": "range",
"name": "DomNum1to12",
"description": "Numbers 1 to 12",
"range": [
1,
12
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "CABLETYPE",
"type": "esriFieldTypeString",
"alias": "CABLE TYPE",
"length": 50,
"domain": {
"type": "codedValue",
"name": "tDomCabletype",
"description": "Cable types",
"codedValues": [
{
"name": "Aluminum Cable 2 2 4",
"code": "ac224"
},
{
"name": "Aluminum Cable 6 2",
"code": "ac62"
},
{
"name": "Camera Cable",
"code": "CAM"
},
{
"name": "Conductor Number 1",
"code": "1c"
},
{
"name": "Conductor Number 12",
"code": "12c"
},
{
"name": "Conductor Number 19",
"code": "19c"
},
{
"name": "Conductor Number 20",
"code": "20c"
},
{
"name": "Conductor Number 24",
"code": "24c"
},
{
"name": "Conductor Number 25",
"code": "25c"
},
{
"name": "Conductor Number 3",
"code": "3c"
},
{
"name": "Conductor Number 4",
"code": "4c"
},
{
"name": "Conductor Number 5",
"code": "5c"
},
{
"name": "Conductor Number 6",
"code": "6c"
},
{
"name": "Conductor Number 7",
"code": "7c"
},
{
"name": "Frequency Shift Keying cable 6 pair",
"code": "fsk6pr"
},
{
"name": "Light Department cable",
"code": "ldcable"
},
{
"name": "Loop Wire",
"code": "LW"
},
{
"name": "Premption Cable",
"code": "PRE"
},
{
"name": "Trace Wire",
"code": "TW"
},
{
"name": "Twisted shielded pair",
"code": "tsp"
},
{
"name": "Wire Number 4",
"code": "No4"
},
{
"name": "Wire Number 6",
"code": "No6"
},
{
"name": "Wire Number 8",
"code": "No8"
},
{
"name": "12SM",
"code": "12SM"
},
{
"name": "24SM",
"code": "24SM"
},
{
"name": "12SM/12MM",
"code": "12SM/12MM"
},
{
"name": "24SM/12MM",
"code": "24SM/12MM"
},
{
"name": "24SM/24MM",
"code": "24SM/24MM"
},
{
"name": "48SM/12MM",
"code": "48SM/12MM"
},
{
"name": "60SM/12MM",
"code": "60SM/12MM"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "STATUS",
"length": 50,
"domain": null
},
{
"name": "COMMENTS",
"type": "esriFieldTypeString",
"alias": "COMMENTS",
"length": 100,
"domain": null
},
{
"name": "Rel_GUID",
"type": "esriFieldTypeGUID",
"alias": "Rel_GUID",
"length": 38,
"domain": null
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "INSTALLYEAR",
"type": "esriFieldTypeSmallInteger",
"alias": "INSTALL YEAR",
"domain": {
"type": "codedValue",
"name": "Year",
"description": "Year",
"codedValues": [
{
"name": "2030",
"code": 2030
},
{
"name": "2029",
"code": 2029
},
{
"name": "2028",
"code": 2028
},
{
"name": "2027",
"code": 2027
},
{
"name": "2026",
"code": 2026
},
{
"name": "2025",
"code": 2025
},
{
"name": "2024",
"code": 2024
},
{
"name": "2023",
"code": 2023
},
{
"name": "2022",
"code": 2022
},
{
"name": "2021",
"code": 2021
},
{
"name": "2020",
"code": 2020
},
{
"name": "2019",
"code": 2019
},
{
"name": "2018",
"code": 2018
},
{
"name": "2017",
"code": 2017
},
{
"name": "2016",
"code": 2016
},
{
"name": "2015",
"code": 2015
},
{
"name": "2014",
"code": 2014
},
{
"name": "2013",
"code": 2013
},
{
"name": "2012",
"code": 2012
},
{
"name": "2011",
"code": 2011
},
{
"name": "2010",
"code": 2010
},
{
"name": "2009",
"code": 2009
},
{
"name": "2008",
"code": 2008
},
{
"name": "2007",
"code": 2007
},
{
"name": "2006",
"code": 2006
},
{
"name": "2005",
"code": 2005
},
{
"name": "2004",
"code": 2004
},
{
"name": "2003",
"code": 2003
},
{
"name": "2002",
"code": 2002
},
{
"name": "2001",
"code": 2001
},
{
"name": "2000",
"code": 2000
},
{
"name": "1999",
"code": 1999
},
{
"name": "1998",
"code": 1998
},
{
"name": "1997",
"code": 1997
},
{
"name": "1996",
"code": 1996
},
{
"name": "1995",
"code": 1995
},
{
"name": "1994",
"code": 1994
},
{
"name": "1993",
"code": 1993
},
{
"name": "1992",
"code": 1992
},
{
"name": "1991",
"code": 1991
},
{
"name": "1990",
"code": 1990
},
{
"name": "1989",
"code": 1989
},
{
"name": "1988",
"code": 1988
},
{
"name": "1987",
"code": 1987
},
{
"name": "1986",
"code": 1986
},
{
"name": "1985",
"code": 1985
},
{
"name": "1984",
"code": 1984
},
{
"name": "1983",
"code": 1983
},
{
"name": "1982",
"code": 1982
},
{
"name": "1981",
"code": 1981
},
{
"name": "1980",
"code": 1980
},
{
"name": "1979",
"code": 1979
},
{
"name": "1978",
"code": 1978
},
{
"name": "1977",
"code": 1977
},
{
"name": "1976",
"code": 1976
},
{
"name": "1975",
"code": 1975
},
{
"name": "1974",
"code": 1974
},
{
"name": "1973",
"code": 1973
},
{
"name": "1972",
"code": 1972
},
{
"name": "1971",
"code": 1971
},
{
"name": "1970",
"code": 1970
},
{
"name": "1969",
"code": 1969
},
{
"name": "1968",
"code": 1968
},
{
"name": "1967",
"code": 1967
},
{
"name": "1966",
"code": 1966
},
{
"name": "1965",
"code": 1965
},
{
"name": "1964",
"code": 1964
},
{
"name": "1963",
"code": 1963
},
{
"name": "1962",
"code": 1962
},
{
"name": "1961",
"code": 1961
},
{
"name": "1960",
"code": 1960
},
{
"name": "1959",
"code": 1959
},
{
"name": "1958",
"code": 1958
},
{
"name": "1957",
"code": 1957
},
{
"name": "1956",
"code": 1956
},
{
"name": "1955",
"code": 1955
},
{
"name": "1954",
"code": 1954
},
{
"name": "1953",
"code": 1953
},
{
"name": "1952",
"code": 1952
},
{
"name": "1951",
"code": 1951
},
{
"name": "1950",
"code": 1950
},
{
"name": "1949",
"code": 1949
},
{
"name": "1948",
"code": 1948
},
{
"name": "1947",
"code": 1947
},
{
"name": "1946",
"code": 1946
},
{
"name": "1945",
"code": 1945
},
{
"name": "1944",
"code": 1944
},
{
"name": "1943",
"code": 1943
},
{
"name": "1942",
"code": 1942
},
{
"name": "1941",
"code": 1941
},
{
"name": "1940",
"code": 1940
},
{
"name": "1939",
"code": 1939
},
{
"name": "1938",
"code": 1938
},
{
"name": "1937",
"code": 1937
},
{
"name": "1936",
"code": 1936
},
{
"name": "1935",
"code": 1935
},
{
"name": "1934",
"code": 1934
},
{
"name": "1933",
"code": 1933
},
{
"name": "1932",
"code": 1932
},
{
"name": "1931",
"code": 1931
},
{
"name": "1930",
"code": 1930
},
{
"name": "1929",
"code": 1929
},
{
"name": "1928",
"code": 1928
},
{
"name": "1927",
"code": 1927
},
{
"name": "1926",
"code": 1926
},
{
"name": "1925",
"code": 1925
},
{
"name": "1924",
"code": 1924
},
{
"name": "1923",
"code": 1923
},
{
"name": "1922",
"code": 1922
},
{
"name": "1921",
"code": 1921
},
{
"name": "1920",
"code": 1920
},
{
"name": "1919",
"code": 1919
},
{
"name": "1918",
"code": 1918
},
{
"name": "1917",
"code": 1917
},
{
"name": "1916",
"code": 1916
},
{
"name": "1915",
"code": 1915
},
{
"name": "1914",
"code": 1914
},
{
"name": "1913",
"code": 1913
},
{
"name": "1912",
"code": 1912
},
{
"name": "1911",
"code": 1911
},
{
"name": "1910",
"code": 1910
},
{
"name": "1909",
"code": 1909
},
{
"name": "1908",
"code": 1908
},
{
"name": "1907",
"code": 1907
},
{
"name": "1906",
"code": 1906
},
{
"name": "1905",
"code": 1905
},
{
"name": "1904",
"code": 1904
},
{
"name": "1903",
"code": 1903
},
{
"name": "1902",
"code": 1902
},
{
"name": "1901",
"code": 1901
},
{
"name": "1900",
"code": 1900
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"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
}
],
"indexes": [
{
"name": "R5169_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_OID_5169",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 1,
"name": "tConduit",
"relatedTableId": 9,
"role": "esriRelRoleDestination",
"keyField": "Rel_GUID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 5000,
"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
}
}