{ "currentVersion": 10.71, "id": 10, "name": "Route", "type": "Feature Layer", "description": "Layer contains all the Route Features", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 500000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "aerial", "field2": null, "field3": null, "defaultSymbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 72, 128, 0, 255 ], "width": 1 }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 2 }, "value": "", "label": "Future", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 2 }, "value": "Leased", "label": "Leased", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 61, 255, 255, 255 ], "width": 2 }, "value": "Abandoned", "label": "Abandoned", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 85, 255, 0, 255 ], "width": 2 }, "value": "No", "label": "Underground", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 2 }, "value": "Yes", "label": "Aerial", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.3691592634100001E7, "ymin": 5638804.630000003, "xmax": -1.36488148484E7, "ymax": 5707250.202799998, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "cable_type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "creationuser", "type": "esriFieldTypeString", "alias": "Creation User", "length": 50, "domain": null }, { "name": "datecreated", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "lastuser", "type": "esriFieldTypeString", "alias": "Last User", "length": 50, "domain": null }, { "name": "datemodified", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "inventory_status_code", "type": "esriFieldTypeString", "alias": "Inventory Status Code", "length": 150, "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Installed", "code": "Installed" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Design Complete", "code": "DesignComplete" }, { "name": "Installed, As-Built", "code": "InstalledAsBuilt" }, { "name": "Planned", "code": "Planned" }, { "name": "Do Not Build", "code": "Do Not Build" }, { "name": "Existing", "code": "Existing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "route_name", "type": "esriFieldTypeString", "alias": "Route Name", "length": 255, "domain": null }, { "name": "span_name", "type": "esriFieldTypeString", "alias": "Span Name", "length": 255, "domain": null }, { "name": "segment_name", "type": "esriFieldTypeString", "alias": "Segment Name", "length": 255, "domain": null }, { "name": "new_segment_name", "type": "esriFieldTypeString", "alias": "New Segment Name", "length": 255, "domain": null }, { "name": "segment_type", "type": "esriFieldTypeString", "alias": "Segment Type", "length": 255, "domain": { "type": "codedValue", "name": "SpanSegmentType", "description": "Span Segment Type", "codedValues": [ { "name": "Lateral", "code": "LATERAL" }, { "name": "Segment", "code": "SEGMENT" }, { "name": "Span", "code": "SPAN" }, { "name": "Span Segment", "code": "SPAN_SEGMENT" }, { "name": "Spur", "code": "SPUR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "branch_name", "type": "esriFieldTypeString", "alias": "Branch Name", "length": 255, "domain": null }, { "name": "route_disposition", "type": "esriFieldTypeString", "alias": "Route Disposition", "length": 255, "domain": null }, { "name": "route_protected", "type": "esriFieldTypeString", "alias": "Route Protected", "length": 5, "domain": { "type": "codedValue", "name": "YesNoText", "description": "Yes\\No Text Values", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "duct_diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "DuctDiameter", "description": "Duct Diameter", "codedValues": [ { "name": "1 inch", "code": 1 }, { "name": "1.19 inch", "code": 1.19 }, { "name": "1.25 inch", "code": 1.25 }, { "name": "1.5 inch", "code": 1.5 }, { "name": "2 inch", "code": 2 }, { "name": "3 inch", "code": 3 }, { "name": "4 inch", "code": 4 }, { "name": "Various", "code": -1 }, { "name": "Unknown", "code": -1.1 }, { "name": "5 inch", "code": 5 }, { "name": "6 inch", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "duct_count", "type": "esriFieldTypeInteger", "alias": "Duct Count", "domain": null }, { "name": "ducts_available", "type": "esriFieldTypeInteger", "alias": "Ducts Available", "domain": null }, { "name": "inner_duct_count", "type": "esriFieldTypeInteger", "alias": "Inner Duct Count", "domain": null }, { "name": "inner_ducts_available", "type": "esriFieldTypeInteger", "alias": "Inner Ducts Available", "domain": null }, { "name": "fiber_status", "type": "esriFieldTypeString", "alias": "Fiber Status", "length": 255, "domain": { "type": "codedValue", "name": "RouteFiberStatus", "description": "Route Fiber Status", "codedValues": [ { "name": "Owned Fiber", "code": "OWNED_FIBER" }, { "name": "Leased Fiber", "code": "LEASED_FIBER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sequence", "type": "esriFieldTypeInteger", "alias": "Sequence", "domain": null }, { "name": "sequence_lock", "type": "esriFieldTypeInteger", "alias": "Sequence Lock", "domain": null }, { "name": "installation_method", "type": "esriFieldTypeString", "alias": "Installation Method", "length": 50, "domain": { "type": "codedValue", "name": "InstallationMethod", "description": "Installation Method", "codedValues": [ { "name": "Aerial", "code": "Aerial" }, { "name": "Underground", "code": "Underground" }, { "name": "DirectBuried", "code": "DirectBuried" }, { "name": "Indoor", "code": "Indoor" }, { "name": "Rod & Roped", "code": "R&R" }, { "name": "Congested", "code": "Congested" }, { "name": "Collapsed", "code": "Collapsed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "installationdate", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "length": 50, "domain": { "type": "codedValue", "name": "USAStates", "description": "USA States", "codedValues": [ { "name": "Alabama", "code": "AL" }, { "name": "Alaska", "code": "AK" }, { "name": "Arizona", "code": "AZ" }, { "name": "Arkansas", "code": "AR" }, { "name": "California", "code": "CA" }, { "name": "Colorado", "code": "CO" }, { "name": "Connecticut", "code": "CT" }, { "name": "Delaware", "code": "DE" }, { "name": "District of Columbia", "code": "DC" }, { "name": "Florida", "code": "FL" }, { "name": "Georgia", "code": "GA" }, { "name": "Hawaii", "code": "HI" }, { "name": "Idaho", "code": "ID" }, { "name": "Illinois", "code": "IL" }, { "name": "Indiana", "code": "IN" }, { "name": "Iowa", "code": "IA" }, { "name": "Kansas", "code": "KS" }, { "name": "Kentucky", "code": "KY" }, { "name": "Loisiana", "code": "LA" }, { "name": "Maine", "code": "ME" }, { "name": "Maryland", "code": "MD" }, { "name": "Massachusettes", "code": "MA" }, { "name": "Michigan", "code": "MI" }, { "name": "Minnesota", "code": "MN" }, { "name": "Mississippi", "code": "MS" }, { "name": "Missouri", "code": "MO" }, { "name": "Montana", "code": "MT" }, { "name": "Nebraska", "code": "NE" }, { "name": "Nevada", "code": "NV" }, { "name": "New Hampshire", "code": "NH" }, { "name": "New Jersey", "code": "NJ" }, { "name": "New Mexico", "code": "NM" }, { "name": "New York", "code": "NY" }, { "name": "North Carolina", "code": "NC" }, { "name": "North Dakota", "code": "ND" }, { "name": "Ohio", "code": "OH" }, { "name": "Oklahoma", "code": "OK" }, { "name": "Oregon", "code": "OR" }, { "name": "Pennsylvania", "code": "PA" }, { "name": "Rhode Island", "code": "RI" }, { "name": "South Carolina", "code": "SC" }, { "name": "South Dakota", "code": "SD" }, { "name": "Tennessee", "code": "TN" }, { "name": "Texas", "code": "TX" }, { "name": "Utah", "code": "UT" }, { "name": "Vermont", "code": "VT" }, { "name": "Virginia", "code": "VA" }, { "name": "Washington", "code": "WA" }, { "name": "West Virginia", "code": "WV" }, { "name": "Wisconsin", "code": "WI" }, { "name": "Wyoming", "code": "WY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "audited_flag", "type": "esriFieldTypeString", "alias": "Audited Flag", "length": 255, "domain": { "type": "codedValue", "name": "AuditFlag", "description": "Audit Flag", "codedValues": [ { "name": "Market Knowledge", "code": "M" }, { "name": "As-Builts", "code": "A" }, { "name": "Field Verified", "code": "F" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "audited_logon_id", "type": "esriFieldTypeString", "alias": "Audited Logon ID", "length": 255, "domain": null }, { "name": "audited_timestamp", "type": "esriFieldTypeDate", "alias": "Audit Date", "length": 8, "domain": null }, { "name": "gns_mns", "type": "esriFieldTypeString", "alias": "GNS MNS", "length": 50, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "ipid", "type": "esriFieldTypeString", "alias": "IPID", "length": 90, "domain": null }, { "name": "hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "id", "type": "esriFieldTypeGUID", "alias": "ID", "length": 38, "domain": null }, { "name": "threegisid", "type": "esriFieldTypeGUID", "alias": "3-GIS ID", "length": 38, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "edittrackinguser", "type": "esriFieldTypeString", "alias": "EDITTRACKINGUSER", "length": 255, "domain": null }, { "name": "edittrackingdate", "type": "esriFieldTypeDate", "alias": "EDITTRACKINGDATE", "length": 8, "domain": null }, { "name": "cable_type", "type": "esriFieldTypeString", "alias": "Cable Type", "length": 50, "domain": null }, { "name": "adss", "type": "esriFieldTypeString", "alias": "adss", "length": 50, "domain": null }, { "name": "manufacture", "type": "esriFieldTypeString", "alias": "manufacture", "length": 50, "domain": null }, { "name": "fiber_count", "type": "esriFieldTypeString", "alias": "fiber_count", "length": 50, "domain": null }, { "name": "year_mark", "type": "esriFieldTypeDate", "alias": "year_mark", "length": 8, "domain": null }, { "name": "segment_id", "type": "esriFieldTypeString", "alias": "segment_id", "length": 50, "domain": null }, { "name": "aerial", "type": "esriFieldTypeString", "alias": "Overhead", "length": 50, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 50, "domain": null }, { "name": "shape_length_1", "type": "esriFieldTypeDouble", "alias": "shape_length_1", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "shape.STLength()", "type": "esriFieldTypeDouble", "alias": "shape.STLength()", "domain": null }, { "name": "calculatedlength", "type": "esriFieldTypeDouble", "alias": "Calculated Length", "domain": null }, { "name": "createworkorderid", "type": "esriFieldTypeString", "alias": "createworkorderid", "length": 50, "domain": null }, { "name": "editworkorderid", "type": "esriFieldTypeString", "alias": "editworkorderid", "length": 50, "domain": null }, { "name": "level_begin", "type": "esriFieldTypeInteger", "alias": "level_begin", "domain": null }, { "name": "level_end", "type": "esriFieldTypeInteger", "alias": "level_end", "domain": null }, { "name": "groupid", "type": "esriFieldTypeString", "alias": "Group ID", "length": 90, "domain": null }, { "name": "planningid", "type": "esriFieldTypeGUID", "alias": "Planning Id", "length": 38, "domain": null }, { "name": "isdelete", "type": "esriFieldTypeSmallInteger", "alias": "Is Delete", "domain": null }, { "name": "timestamp", "type": "esriFieldTypeDate", "alias": "Timestamp", "length": 8, "domain": null }, { "name": "clonetype", "type": "esriFieldTypeString", "alias": "Clone Type", "length": 50, "domain": null }, { "name": "isplanning", "type": "esriFieldTypeSmallInteger", "alias": "Is Planning", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R411_pk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_411", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I783ipid", "fields": "ipid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I783threegisid", "fields": "threegisid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S183_idx", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 57, "name": "QAQC_ANALYZED_RESULTS", "relatedTableId": 37, "role": "esriRelRoleOrigin", "keyField": "THREEGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 58, "name": "GISTRAINING.DBO.ASSEMBLY", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "THREEGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }