{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 40, "name": "DOCUMENT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FILE_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 50, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 255, "domain": null }, { "name": "DOCUMENT_PERFORMANCE", "type": "esriFieldTypeString", "alias": "DOCUMENT_PERFORMANCE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_DOCUMENT_PERFORMANCE_CL", "description": "A code listing of the level of acceptance of the reporting status of an operator regarding the performance or completion of an activity.", "codedValues": [ { "name": "Accepted with Conditions", "code": "Accepted with Conditions" }, { "name": "Approved as Final", "code": "Approved as Final" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Planned", "code": "Planned" }, { "name": "Rejected", "code": "Rejected" }, { "name": "Submitted for Review", "code": "Submitted for Review" }, { "name": "Under Revision", "code": "Under Revision" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Verified as Unknown", "code": "Verified as Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DOCUMENT_TYPE", "type": "esriFieldTypeString", "alias": "DOCUMENT_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_DOCUMENT_TYPE_CL", "description": "A code listing of the document types commonly found in pipeline operations. Type does not describe the file format but rather the contents and purpose of the document in support of or pertaining to pipeline operations.", "codedValues": [ { "name": "Alignment Sheet", "code": "Alignment Sheet" }, { "name": "Continuous Surface", "code": "Continuous Surface" }, { "name": "CP Inspection Report", "code": "CP Inspection Report" }, { "name": "Diagram", "code": "Diagram" }, { "name": "Engineering Assessment", "code": "Engineering Assessment" }, { "name": "Final Report", "code": "Final Report" }, { "name": "Inline Inspection Report", "code": "Inline Inspection Report" }, { "name": "Inspection Tally", "code": "Inspection Tally" }, { "name": "Isometric", "code": "Isometric" }, { "name": "MAOP Assignment", "code": "MAOP Assignment" }, { "name": "Map", "code": "Map" }, { "name": "MOC Document", "code": "MOC Document" }, { "name": "P and ID Diagram", "code": "P and ID Diagram" }, { "name": "Picture", "code": "Picture" }, { "name": "Pipe Tally", "code": "Pipe Tally" }, { "name": "Piping Diagram", "code": "Piping Diagram" }, { "name": "Preliminary Report", "code": "Preliminary Report" }, { "name": "ROV Inspection Report", "code": "ROV Inspection Report" }, { "name": "Schematic", "code": "Schematic" }, { "name": "Survey Results", "code": "Survey Results" }, { "name": "Testing Results", "code": "Testing Results" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Verified as unknown", "code": "Verified as unknown" }, { "name": "Video", "code": "Video" }, { "name": "Visual Inspection Report", "code": "Visual Inspection Report" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FILE_NAME", "type": "esriFieldTypeString", "alias": "FILE_NAME", "length": 255, "domain": null }, { "name": "FILE_PATH_URI", "type": "esriFieldTypeString", "alias": "FILE_PATH_URI", "length": 255, "domain": null }, { "name": "FILE_SYSTEM_TYPE", "type": "esriFieldTypeString", "alias": "FILE_SYSTEM_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_FILE_SYSTEM_TYPE_CL", "description": "A code listing whose values indicate the type of repository that the document is stored in. A repository can be a network file system or a separate document management system or cloud block storage (such as Amazon S3).", "codedValues": [ { "name": "AWS S3", "code": "AWS S3" }, { "name": "Documentum", "code": "Documentum" }, { "name": "Dropbox", "code": "Dropbox" }, { "name": "FileNet", "code": "FileNet" }, { "name": "Google Drive", "code": "Google Drive" }, { "name": "Network Drive", "code": "Network Drive" }, { "name": "Portal", "code": "Portal" }, { "name": "SharePoint", "code": "SharePoint" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Verified as unknown", "code": "Verified as unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FROM_DATE", "type": "esriFieldTypeDate", "alias": "FROM_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 50, "domain": null }, { "name": "MIME_TYPE", "type": "esriFieldTypeString", "alias": "MIME_TYPE", "length": 90, "domain": { "type": "codedValue", "name": "WS2_MIME_TYPE_CL", "description": "Example listing of the file types of documents that can be attached to any table in PODS 7.0.", "codedValues": [ { "name": "3GPP audio container without video (.3gp)", "code": "audio/3gpp" }, { "name": "3GPP audio/video container (.3gp)", "code": "video/3gpp" }, { "name": "3GPP2 audio container without video (.3g2)", "code": "audio/3gpp2" }, { "name": "3GPP2 audio/video container (.3g2)", "code": "video/3gpp2" }, { "name": "7-zip archive (.7z)", "code": "application/x-7z-compressed" }, { "name": "AAC audio (.aac)", "code": "audio/aac" }, { "name": "AbiWord document (.abw)", "code": "application/x-abiword" }, { "name": "Adobe Portable Document Format (PDF) (.pdf)", "code": "application/pdf" }, { "name": "Amazon Kindle eBook format (.azw)", "code": "application/vnd.amazon.ebook" }, { "name": "Any kind of binary data (.bin)", "code": "application/octet-stream" }, { "name": "Apple Installer Package (.mpkg)", "code": "application/vnd.apple.installer+xml" }, { "name": "Archive document (multiple files embedded) (.arc)", "code": "application/x-freearc" }, { "name": "AVI: Audio Video Interleave (.avi)", "code": "video/x-msvideo" }, { "name": "Bourne shell script (.sh)", "code": "application/x-sh" }, { "name": "BZip archive (.bz)", "code": "application/x-bzip" }, { "name": "BZip2 archive (.bz2)", "code": "application/x-bzip2" }, { "name": "C-Shell script (.csh)", "code": "application/x-csh" }, { "name": "Cascading Style Sheets (CSS) (.css)", "code": "text/css" }, { "name": "Comma-separated values (CSV) (.csv)", "code": "text/csv" }, { "name": "ECMAScript (RFC 4329 Section 8.2) (.es)", "code": "application/ecmascript" }, { "name": "Electronic publication (EPUB) (.epub)", "code": "application/epub+zip" }, { "name": "Graphics Interchange Format (GIF) (.gif)", "code": "image/gif" }, { "name": "HyperText Markup Language (HTML)(.htm,/html)", "code": "text/html" }, { "name": "iCalendar format (.ics)", "code": "text/calendar" }, { "name": "Icon format (.ico)", "code": "image/x-icon" }, { "name": "Java Archive (JAR) (.jar)", "code": "application/java-archive" }, { "name": "JavaScript (RFC 4329 Section 8.2) (.js)", "code": "application/javascript" }, { "name": "JPEG images (.jpg,.jpeg)", "code": "image/jpeg" }, { "name": "JSON format (.json)", "code": "application/json" }, { "name": "Microsoft Excel (.xls)", "code": "application/vnd.ms-excel" }, { "name": "Microsoft Excel (OpenXML) (.xlsx)", "code": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }, { "name": "Microsoft PowerPoint (.ppt)", "code": "application/vnd.ms-powerpoint" }, { "name": "Microsoft PowerPoint (OpenXML) (.pptx)", "code": "application/vnd.openxmlformats-officedocument.presentationml.presentation" }, { "name": "Microsoft Visio (.vsd)", "code": "application/vnd.visio" }, { "name": "Microsoft Word (.doc)", "code": "application/msword" }, { "name": "Microsoft Word (OpenXML) (.docx)", "code": "application/vnd.openxmlformats-officedocument.wordprocessingml.document" }, { "name": "MPEG Video (.mpeg)", "code": "video/mpeg" }, { "name": "MS Embedded OpenType fonts (.eot)", "code": "application/vnd.ms-fontobject" }, { "name": "Musical Instrument Digital Interface (.mid,.midi)", "code": "audio/midi" }, { "name": "OGG (.ogx)", "code": "application/ogg" }, { "name": "OGG audio (.oga)", "code": "audio/ogg" }, { "name": "OGG video (.ogv)", "code": "video/ogg" }, { "name": "OpenDocument presentation document (.odp)", "code": "application/vnd.oasis.opendocument.presentation" }, { "name": "OpenDocument spreadsheet document (.ods)", "code": "application/vnd.oasis.opendocument.spreadsheet" }, { "name": "OpenDocument text document (.odt)", "code": "application/vnd.oasis.opendocument.text" }, { "name": "OpenType font (.otf)", "code": "font/otf" }, { "name": "Portable Network Graphics (.png)", "code": "image/png" }, { "name": "RAR archive (.rar)", "code": "application/x-rar-compressed" }, { "name": "Rich Text Format (RTF) (.rtf)", "code": "application/rtf" }, { "name": "Scalable Vector Graphics (SVG) (.svg)", "code": "image/svg+xml" }, { "name": "Small web format or Adobe Flash document (.swf)", "code": "application/x-shockwave-flash" }, { "name": "Tagged Image File Format (TIFF)(.tif,.tiff)", "code": "image/tiff" }, { "name": "Tape Archive (TAR) (.tar)", "code": "application/x-tar" }, { "name": "TrueType Font (.ttf)", "code": "font/ttf" }, { "name": "Typescript file (.ts)", "code": "application/typescript" }, { "name": "Waveform Audio Format (.wav)", "code": "audio/wav" }, { "name": "Web Open Font Format (WOFF) (.woff)", "code": "font/woff" }, { "name": "Web Open Font Format (WOFF) (.woff2)", "code": "font/woff2" }, { "name": "WEBM audio (.weba)", "code": "audio/webm" }, { "name": "WEBM video (.webm)", "code": "video/webm" }, { "name": "WEBP image (.webp)", "code": "image/webp" }, { "name": "XHTML (.xhtml)", "code": "application/xhtml+xml" }, { "name": "XML (.xml)", "code": "application/xml" }, { "name": "XUL (.xul)", "code": "application/vnd.mozilla.xul+xml" }, { "name": "ZIP archive (.zip)", "code": "application/zip" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRESERVE_RELATE_IDENTIFIER", "type": "esriFieldTypeGUID", "alias": "PRESERVE_RELATE_IDENTIFIER", "length": 38, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": { "type": "codedValue", "name": "WS2_HISTORIC_STATE_CL", "description": "Indicates if the record is the most recent version a feature or event representation. Modern GIS systems support the notion of in-line history where current and historic versions of records are managed in a single table. As these features are updated, the attributes defined by including the HISTORY data type are modified for those features. The FROM_DATE and TO_DATE fields show a life-span of each version of the record. The historical records have both the FROM_DATE and TO_DATE fields set and the STATUS field set to Historic. The current record has the FROM_DATE set, but the TO_DATE field is NULL. The STATUS field is set to Current. As new versions of records are added, the previous version TO_DATE is set to the FROM_DATE of the most recent record. \nA good example of this is changing pipe records to reflect a pipe replacement. This example also brings into play how the LAYER_METADATA table can be used to manage gap and overlap situations. A section of pipeline is removed. In the GIS, the existing pipe segment is split into three pieces and the middle PIPE_SEGMENT record attributes are set as follows: TO_DATE is set to Now and STATUS is set to Historic. For the PIPE_SEGMENT table there is a LAYER_METADATA record set with the following attributes: DEFINITION_QUERY= STATUS=Current, ALLOW_GAP=No, ALLOW_OVERLAP=Yes. If a QA routine is run against the PIPE_SEGMENT layer it will return a gap violation because there is a gap between two active PIPE_SEGMENT records (since the middle record has been set to Historic. A new PIPE_SEGMENT record is inserted with different business attributes (wall thickness, grade etc.) and it fills in the gap between the two active records. The FROM_DATE for this new record is set to Now, and the STATUS is set to Current. There are now four PIPE_SEGMENT records for this pipeline. One is Historic, three are Current. Two are completely coincident with each other but one is the Current record and the other is the Historic record. Now when the QA process is re-run looking for errors in the PIPE_SEGMENT table and neither the gap or overlap situations occur because there are now gaps in Current records and there are no overlaps in Current records.", "codedValues": [ { "name": "Current", "code": "Current" }, { "name": "Historic", "code": "Historic" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Verified as unknown", "code": "Verified as unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TO_DATE", "type": "esriFieldTypeDate", "alias": "TO_DATE", "length": 8, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeGUID", "alias": "UNIQUE_ID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G175UNIQUE_ID", "fields": "UNIQUE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 35, "name": "documentBoundary", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 51, "name": "documentCrossRef", "relatedTableId": 41, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "documentRange", "relatedTableId": 152, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "0b6ea39373374d868246e69ee986e7a0" }