{ "currentVersion": 10.91, "id": 27, "name": "SPAN", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 255, 255 ], "width": 3 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": [ { "labelPlacement": "esriServerLinePlacementAboveAlong", "where": null, "labelExpression": "[CALCULATEDLENGTH]", "useCodedValues": true, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 8, "style": "normal", "weight": "normal", "decoration": "none" } }, "minScale": 0, "maxScale": 0 } ] }, "defaultVisibility": false, "extent": { "xmin": -1.02758237865E7, "ymin": 3492636.8038000017, "xmax": -1.02215921986E7, "ymax": 4717627.129699998, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SPAN_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": "Routed, Not Yet Designed", "code": "Route" }, { "name": "Design Complete, Not Able to Build", "code": "HoldBuild" }, { "name": "Design Complete", "code": "DesignComplete" }, { "name": "Installed, As-Built", "code": "InstalledAsBuilt" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Planned", "code": "Planned" }, { "name": "Installed", "code": "Installed" } ], "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": "Casing", "code": "CASING" }, { "name": "ADSS", "code": "ADSS" }, { "name": "Tunnel", "code": "TUNNEL" }, { "name": "Bridge Span", "code": "BRIDGE_SPAN" }, { "name": "Aerial Strand", "code": "AERIAL_STRAND" }, { "name": "Trench", "code": "TRENCH" }, { "name": "Aerial Inner Duct", "code": "AERIAL_INNER_DUCT" }, { "name": "OPGW", "code": "OPGW" }, { "name": "Bore", "code": "BORE" }, { "name": "Direct Bury", "code": "DIRECT_BURY" } ], "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": "DUCT_DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "DuctDiameter", "description": "Duct Diameter", "codedValues": [ { "name": "Various", "code": -1 }, { "name": "1.25 inch", "code": 1.25 }, { "name": "1 inch", "code": 1 }, { "name": "1.19 inch", "code": 1.19 }, { "name": "3 inch", "code": 3 }, { "name": "4 inch", "code": 4 }, { "name": "5 inch", "code": 5 }, { "name": "1.5 inch", "code": 1.5 }, { "name": "2 inch", "code": 2 }, { "name": "6 inch", "code": 6 }, { "name": "Unknown", "code": -1.1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DUCT_MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": { "type": "codedValue", "name": "DuctMaterial", "description": "Duct Material", "codedValues": [ { "name": "Steel", "code": "STEEL" }, { "name": "Flex Duct", "code": "FLEXDUCT" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Black Iron Pipe", "code": "BLACKIRONPIPE" }, { "name": "Steel Casing", "code": "STEELCASING" }, { "name": "Split PVC", "code": "SPLITPVC" }, { "name": "Terracotta", "code": "TERRACOTTA" }, { "name": "HDPE", "code": "HDPE" }, { "name": "Split HDPE", "code": "SPLITHDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Wood", "code": "WOOD" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Quad", "code": "QUAD" }, { "name": "Cast Iron Pipe", "code": "CASTIRONPIPE" }, { "name": "Black Steel Pipe", "code": "BLACKSTEELPIPE" }, { "name": "Clay Sewer Pipe", "code": "CLAYSEWERPIPE" } ], "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": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "contract_id", "type": "esriFieldTypeString", "alias": "Contract Number", "length": 20, "domain": null }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "DuctDiameter", "description": "Duct Diameter", "codedValues": [ { "name": "Various", "code": -1 }, { "name": "1.25 inch", "code": 1.25 }, { "name": "1 inch", "code": 1 }, { "name": "1.19 inch", "code": 1.19 }, { "name": "3 inch", "code": 3 }, { "name": "4 inch", "code": 4 }, { "name": "5 inch", "code": 5 }, { "name": "1.5 inch", "code": 1.5 }, { "name": "2 inch", "code": 2 }, { "name": "6 inch", "code": 6 }, { "name": "Unknown", "code": -1.1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "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": { "type": "codedValue", "name": "SpanDiameterTemplate", "description": "Span Diameter Template", "codedValues": [ { "name": "3/4\"", "code": 1 }, { "name": "1\"", "code": 2 }, { "name": "1 1/4\"", "code": 3 }, { "name": "1 1/2\"", "code": 4 }, { "name": "2\"", "code": 5 }, { "name": "3\"", "code": 6 }, { "name": "4\"", "code": 7 }, { "name": "5\"", "code": 8 }, { "name": "6\"", "code": 9 }, { "name": "10\"", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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 }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R114_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_114", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I209CLLI", "fields": "CLLI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I209IPID", "fields": "IPID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I209JOINT_TYPE", "fields": "JOINT_TYPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I209SEGMENTID", "fields": "SEGMENTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "TGS_SPAN", "fields": "THREEGISID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S36_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 99, "name": "ATTACHMENTS", "relatedTableId": 30, "role": "esriRelRoleOrigin", "keyField": "THREEGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 100, "name": "SPAN_UNIT", "relatedTableId": 39, "role": "esriRelRoleOrigin", "keyField": "SEGMENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 57, "name": "FIBERCABLE", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "SEGMENTID", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "relationshipTableId": 51, "keyFieldInRelationshipTable": "SPANSEGMENTIDFKEY" }, { "id": 101, "name": "QAQC_ANALYZED_RESULTS", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "THREEGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 102, "name": "ASSEMBLY", "relatedTableId": 36, "role": "esriRelRoleOrigin", "keyField": "THREEGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 103, "name": "Contracts", "relatedTableId": 31, "role": "esriRelRoleOrigin", "keyField": "threegisid", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "relationshipTableId": 109, "keyFieldInRelationshipTable": "SPAN_threegisid" }, { "id": 33, "name": "Structure", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "segmentid", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "relationshipTableId": 112, "keyFieldInRelationshipTable": "ipid" }, { "id": 42, "name": "Pole", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "segmentid", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "relationshipTableId": 111, "keyFieldInRelationshipTable": "ipid" }, { "id": 48, "name": "Building", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "segmentid", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "relationshipTableId": 107, "keyFieldInRelationshipTable": "ipid" }, { "id": 75, "name": "BuildingOutline", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "segmentid", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "relationshipTableId": 108, "keyFieldInRelationshipTable": "ipid" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "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, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }