{ "currentVersion": 10.71, "id": 62, "name": "SPAN", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 33, 0, 133, 255 ], "width": 1 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.3693249735E7, "ymin": 5667894.597499996, "xmax": -1.36683801461E7, "ymax": 5683902.737199999, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "route_name", "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": "enabled", "type": "esriFieldTypeInteger", "alias": "Enabled", "domain": null }, { "name": "clli", "type": "esriFieldTypeString", "alias": "CLLI", "length": 100, "domain": null }, { "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": "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": "calculatedlength", "type": "esriFieldTypeDouble", "alias": "Calculated Length", "domain": null }, { "name": "measuredlength", "type": "esriFieldTypeDouble", "alias": "Measured Length", "domain": null }, { "name": "install_method", "type": "esriFieldTypeString", "alias": "Installation Method", "length": 50, "domain": { "type": "codedValue", "name": "SpanInstallMethod", "description": "Span Install Method", "codedValues": [ { "name": "Trench", "code": "TRENCH" }, { "name": "Bore", "code": "BORE" }, { "name": "Casing", "code": "CASING" }, { "name": "Aerial Strand", "code": "AERIAL_STRAND" }, { "name": "Aerial Inner Duct", "code": "AERIAL_INNER_DUCT" }, { "name": "Bridge Span", "code": "BRIDGE_SPAN" }, { "name": "Direct Bury", "code": "DIRECT_BURY" }, { "name": "Tunnel", "code": "TUNNEL" }, { "name": "ADSS", "code": "ADSS" }, { "name": "OPGW", "code": "OPGW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "from_structure", "type": "esriFieldTypeString", "alias": "From Structure", "length": 255, "domain": null }, { "name": "to_structure", "type": "esriFieldTypeString", "alias": "To Structure", "length": 255, "domain": null }, { "name": "joint_type", "type": "esriFieldTypeString", "alias": "Joint Type", "length": 50, "domain": null }, { "name": "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_material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": { "type": "codedValue", "name": "DuctMaterial", "description": "Duct Material", "codedValues": [ { "name": "HDPE", "code": "HDPE" }, { "name": "Split HDPE", "code": "SPLITHDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Split PVC", "code": "SPLITPVC" }, { "name": "Steel", "code": "STEEL" }, { "name": "Black Iron Pipe", "code": "BLACKIRONPIPE" }, { "name": "Black Steel Pipe", "code": "BLACKSTEELPIPE" }, { "name": "Cast Iron Pipe", "code": "CASTIRONPIPE" }, { "name": "Clay Sewer Pipe", "code": "CLAYSEWERPIPE" }, { "name": "Flex Duct", "code": "FLEXDUCT" }, { "name": "Steel Casing", "code": "STEELCASING" }, { "name": "Terracotta", "code": "TERRACOTTA" }, { "name": "Wood", "code": "WOOD" }, { "name": "Quad", "code": "QUAD" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "spanunitcount", "type": "esriFieldTypeInteger", "alias": "Span Unit Count", "domain": null }, { "name": "color", "type": "esriFieldTypeInteger", "alias": "Color", "domain": { "type": "codedValue", "name": "SpanColor", "description": "Span Color", "codedValues": [ { "name": "Purple", "code": 1 }, { "name": "Light Blue", "code": 2 }, { "name": "Light Gray", "code": 3 }, { "name": "Yellow", "code": 4 }, { "name": "Blue", "code": 5 }, { "name": "Brown", "code": 6 }, { "name": "Black", "code": 7 }, { "name": "Green", "code": 8 }, { "name": "Orange", "code": 9 }, { "name": "Red", "code": 10 }, { "name": "White", "code": 11 }, { "name": "Grey", "code": 12 }, { "name": "Light Red", "code": 13 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "initialunitconfig", "type": "esriFieldTypeString", "alias": "Initial Unit Configuration", "length": 1073741822, "domain": null }, { "name": "installationdate", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "accountcode", "type": "esriFieldTypeString", "alias": "Account Code", "length": 100, "domain": null }, { "name": "segmentid", "type": "esriFieldTypeString", "alias": "Segment ID", "length": 90, "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": "type", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": { "type": "codedValue", "name": "SpanType", "description": "Span Type", "codedValues": [ { "name": "Duct", "code": "DUCT" }, { "name": "Inner Duct", "code": "INNERDUCT" }, { "name": "Micro Duct", "code": "MICRODUCT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "contract_id", "type": "esriFieldTypeString", "alias": "Contract Number", "length": 20, "domain": null }, { "name": "duct_diameter", "type": "esriFieldTypeDouble", "alias": "duct_diameter", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "shape.STLength()", "type": "esriFieldTypeDouble", "alias": "shape.STLength()", "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": "level_name_begin", "type": "esriFieldTypeString", "alias": "level_name_begin", "length": 50, "domain": null }, { "name": "level_name_end", "type": "esriFieldTypeString", "alias": "level_name_end", "length": 50, "domain": null }, { "name": "structure1ipid", "type": "esriFieldTypeString", "alias": "structure1ipid", "length": 255, "domain": null }, { "name": "structure2ipid", "type": "esriFieldTypeString", "alias": "structure2ipid", "length": 255, "domain": null }, { "name": "fill_ratio", "type": "esriFieldTypeDouble", "alias": "Fill Ratio", "domain": null }, { "name": "spandiametertemplateid", "type": "esriFieldTypeInteger", "alias": "Span Diameter Template ID", "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": "R396_pk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_396", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I768clli", "fields": "clli", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I768ipid", "fields": "ipid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I768joint_type", "fields": "joint_type", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I768segmentid", "fields": "segmentid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I768threegisid", "fields": "threegisid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S168_idx", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 88, "name": "SPAN_UNIT", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "SEGMENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 89, "name": "QAQC_ANALYZED_RESULTS", "relatedTableId": 37, "role": "esriRelRoleOrigin", "keyField": "THREEGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 90, "name": "ASSEMBLY", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "THREEGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 91, "name": "ATTACHMENTS", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "THREEGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 92, "name": "CONTRACTS", "relatedTableId": 30, "role": "esriRelRoleOrigin", "keyField": "threegisid", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 53, "name": "FIBERCABLE", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "SEGMENTID", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "relationshipTableId": 50, "keyFieldInRelationshipTable": "SPANSEGMENTIDFKEY" } ], "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 }