{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Instruments", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TOWN_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LAYOUT_ID", "type": "esriFieldTypeOID", "alias": "LAYOUT_ID", "domain": null }, { "name": "Layout_Suffix", "type": "esriFieldTypeString", "alias": "Layout_Suffix", "length": 50, "domain": null }, { "name": "PREFIX_NUMBER", "type": "esriFieldTypeInteger", "alias": "PREFIX_NUMBER", "domain": null }, { "name": "STREET_ROUTE", "type": "esriFieldTypeString", "alias": "STREET_ROUTE", "length": 75, "domain": null }, { "name": "BOARD_DATE", "type": "esriFieldTypeDate", "alias": "BOARD_DATE", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 255, "domain": null }, { "name": "Sheets", "type": "esriFieldTypeInteger", "alias": "Sheets", "domain": null }, { "name": "STATION_FROM", "type": "esriFieldTypeString", "alias": "STATION_FROM", "length": 50, "domain": null }, { "name": "STATION_TO", "type": "esriFieldTypeString", "alias": "STATION_TO", "length": 50, "domain": null }, { "name": "STA_TO_STA", "type": "esriFieldTypeString", "alias": "STA_TO_STA", "length": 200, "domain": null }, { "name": "Consultant", "type": "esriFieldTypeString", "alias": "Consultant", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "ProjisNumber", "type": "esriFieldTypeInteger", "alias": "ProjisNumber", "domain": null }, { "name": "CountyVote", "type": "esriFieldTypeDate", "alias": "CountyVote", "length": 8, "domain": null }, { "name": "DATE_ENTERED", "type": "esriFieldTypeDate", "alias": "DATE_ENTERED", "length": 8, "domain": null }, { "name": "AMEND", "type": "esriFieldTypeString", "alias": "AMEND", "length": 10, "domain": null }, { "name": "WHO_ADD", "type": "esriFieldTypeString", "alias": "WHO_ADD", "length": 50, "domain": null }, { "name": "D_ADD", "type": "esriFieldTypeDate", "alias": "D_ADD", "length": 8, "domain": null }, { "name": "WHO_MOD", "type": "esriFieldTypeString", "alias": "WHO_MOD", "length": 50, "domain": null }, { "name": "D_MOD", "type": "esriFieldTypeDate", "alias": "D_MOD", "length": 8, "domain": null }, { "name": "LAYOUT_NUMBER", "type": "esriFieldTypeInteger", "alias": "LAYOUT_NUMBER", "domain": null }, { "name": "Registry", "type": "esriFieldTypeString", "alias": "Registry", "length": 255, "domain": null }, { "name": "Instrument_Bk_No", "type": "esriFieldTypeInteger", "alias": "Instrument_Bk_No", "domain": null }, { "name": "Instrument_Pg_No", "type": "esriFieldTypeInteger", "alias": "Instrument_Pg_No", "domain": null }, { "name": "Plan_Bk_No", "type": "esriFieldTypeInteger", "alias": "Plan_Bk_No", "domain": null }, { "name": "Plan_Pg_No", "type": "esriFieldTypeInteger", "alias": "Plan_Pg_No", "domain": null }, { "name": "Reg_Instr_Bk_No", "type": "esriFieldTypeInteger", "alias": "Reg_Instr_Bk_No", "domain": null }, { "name": "Reg_Instr_Pg_No", "type": "esriFieldTypeInteger", "alias": "Reg_Instr_Pg_No", "domain": null }, { "name": "Reg_Plan_Bk_No", "type": "esriFieldTypeInteger", "alias": "Reg_Plan_Bk_No", "domain": null }, { "name": "Reg_Plan_Pg_No", "type": "esriFieldTypeInteger", "alias": "Reg_Plan_Pg_No", "domain": null }, { "name": "TOWN_NAME", "type": "esriFieldTypeString", "alias": "TOWN_NAME", "length": 255, "domain": null }, { "name": "Entered_By", "type": "esriFieldTypeString", "alias": "Entered By", "length": 255, "domain": null }, { "name": "ContactName", "type": "esriFieldTypeString", "alias": "Contact Name", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "Sample", "type": "esriFieldTypeSmallInteger", "alias": "Sample", "domain": null }, { "name": "Reviewers_Remarks", "type": "esriFieldTypeString", "alias": "Reviewers Remarks", "length": 250, "domain": null }, { "name": "Supervisor_Remarks", "type": "esriFieldTypeString", "alias": "Supervisor Remarks", "length": 250, "domain": null }, { "name": "Origin", "type": "esriFieldTypeString", "alias": "Origin", "length": 255, "domain": null }, { "name": "AD_LIST_DATE", "type": "esriFieldTypeDate", "alias": "AD List Date", "length": 8, "domain": null }, { "name": "Sample_Date", "type": "esriFieldTypeDate", "alias": "Sample Date", "length": 8, "domain": null }, { "name": "Submit_Date", "type": "esriFieldTypeDate", "alias": "Submit Date", "length": 8, "domain": null }, { "name": "Review1", "type": "esriFieldTypeDate", "alias": "1st Review", "length": 8, "domain": null }, { "name": "Resubmit1", "type": "esriFieldTypeDate", "alias": "1st Resubmission", "length": 8, "domain": null }, { "name": "Review2", "type": "esriFieldTypeDate", "alias": "2nd Review", "length": 8, "domain": null }, { "name": "Resubmit2", "type": "esriFieldTypeDate", "alias": "2nd Resubmission", "length": 8, "domain": null }, { "name": "Review3", "type": "esriFieldTypeDate", "alias": "3rd Review", "length": 8, "domain": null }, { "name": "LOS_DATE", "type": "esriFieldTypeDate", "alias": "LOS Date", "length": 8, "domain": null }, { "name": "Approximate_Stations", "type": "esriFieldTypeString", "alias": "Approximate Stations", "length": 255, "domain": null }, { "name": "Contact_Number", "type": "esriFieldTypeString", "alias": "Contact Number", "length": 255, "domain": null }, { "name": "All_Initials", "type": "esriFieldTypeString", "alias": "INITIALS", "length": 255, "domain": { "type": "codedValue", "name": "Initials", "description": "Initials for all fields requiring initials", "codedValues": [ { "name": "QT", "code": 1 }, { "name": "KJD", "code": 2 }, { "name": "MPC", "code": 3 }, { "name": "MR", "code": 5 }, { "name": "JL", "code": 6 }, { "name": "PB", "code": 7 }, { "name": "RA", "code": 8 }, { "name": "JS", "code": 4 }, { "name": "MT", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Initials_1st_Review", "type": "esriFieldTypeString", "alias": "1st REVIEW INITIALS", "length": 255, "domain": { "type": "codedValue", "name": "Initials", "description": "Initials for all fields requiring initials", "codedValues": [ { "name": "QT", "code": 1 }, { "name": "KJD", "code": 2 }, { "name": "MPC", "code": 3 }, { "name": "MR", "code": 5 }, { "name": "JL", "code": 6 }, { "name": "PB", "code": 7 }, { "name": "RA", "code": 8 }, { "name": "JS", "code": 4 }, { "name": "MT", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Initials_2nd_Reivew", "type": "esriFieldTypeString", "alias": "2nd REVIEW INITIALS", "length": 255, "domain": { "type": "codedValue", "name": "Initials", "description": "Initials for all fields requiring initials", "codedValues": [ { "name": "QT", "code": 1 }, { "name": "KJD", "code": 2 }, { "name": "MPC", "code": 3 }, { "name": "MR", "code": 5 }, { "name": "JL", "code": 6 }, { "name": "PB", "code": 7 }, { "name": "RA", "code": 8 }, { "name": "JS", "code": 4 }, { "name": "MT", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Initials_3rd_Review", "type": "esriFieldTypeString", "alias": "3rd REVIEW INITIALS", "length": 255, "domain": { "type": "codedValue", "name": "Initials", "description": "Initials for all fields requiring initials", "codedValues": [ { "name": "QT", "code": 1 }, { "name": "KJD", "code": 2 }, { "name": "MPC", "code": 3 }, { "name": "MR", "code": 5 }, { "name": "JL", "code": 6 }, { "name": "PB", "code": 7 }, { "name": "RA", "code": 8 }, { "name": "JS", "code": 4 }, { "name": "MT", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Project_Status", "type": "esriFieldTypeString", "alias": "STATUS", "length": 255, "domain": { "type": "codedValue", "name": "Status_13", "description": "Project Status", "codedValues": [ { "name": "Open", "code": 2 }, { "name": "Hold", "code": 1 }, { "name": "Moved", "code": 4 }, { "name": "Completed", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Initiated_By", "type": "esriFieldTypeString", "alias": "ENTERED BY", "length": 255, "domain": { "type": "codedValue", "name": "Initials", "description": "Initials for all fields requiring initials", "codedValues": [ { "name": "QT", "code": 1 }, { "name": "KJD", "code": 2 }, { "name": "MPC", "code": 3 }, { "name": "MR", "code": 5 }, { "name": "JL", "code": 6 }, { "name": "PB", "code": 7 }, { "name": "RA", "code": 8 }, { "name": "JS", "code": 4 }, { "name": "MT", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADV_LIST", "type": "esriFieldTypeSmallInteger", "alias": "ADV LIST", "domain": { "type": "codedValue", "name": "Ad_List", "description": "AD List", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOS_1", "type": "esriFieldTypeSmallInteger", "alias": "los", "domain": { "type": "codedValue", "name": "Yes-No_8", "description": "Yes/No field", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ABP_1", "type": "esriFieldTypeSmallInteger", "alias": "ABP_1", "domain": { "type": "codedValue", "name": "Yes-No_8", "description": "Yes/No field", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ARRA_1", "type": "esriFieldTypeSmallInteger", "alias": "ARRA_1", "domain": { "type": "codedValue", "name": "Yes-No_8", "description": "Yes/No field", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ARRA_CAND_1", "type": "esriFieldTypeSmallInteger", "alias": "ARRA_CAND_1", "domain": { "type": "codedValue", "name": "Yes-No_8", "description": "Yes/No field", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PLS_No", "type": "esriFieldTypeInteger", "alias": "PLS No", "domain": null }, { "name": "SurveyorConsultant", "type": "esriFieldTypeString", "alias": "Surveyor Consultant", "length": 50, "domain": null }, { "name": "Layout_ID_Double", "type": "esriFieldTypeDouble", "alias": "Layout_ID_Double", "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 }, { "name": "Right_Of_Way_Name", "type": "esriFieldTypeString", "alias": "Right_Of_Way_Name", "length": 100, "domain": null }, { "name": "Right_Of_Way_Date", "type": "esriFieldTypeDate", "alias": "Right_Of_Way_Date", "length": 8, "domain": null }, { "name": "To_Oread_Name", "type": "esriFieldTypeString", "alias": "To_Oread_Name", "length": 100, "domain": null }, { "name": "To_Oread_Date", "type": "esriFieldTypeDate", "alias": "To_Oread_Date", "length": 8, "domain": null }, { "name": "DB_Date", "type": "esriFieldTypeDate", "alias": "DB_Date", "length": 8, "domain": null }, { "name": "Plan_Date", "type": "esriFieldTypeDate", "alias": "Plan_Date", "length": 8, "domain": null }, { "name": "Inst_Date", "type": "esriFieldTypeDate", "alias": "Inst_Date", "length": 8, "domain": null }, { "name": "Georef_Date", "type": "esriFieldTypeDate", "alias": "Georef_Date", "length": 8, "domain": null }, { "name": "Mylar_Remarks", "type": "esriFieldTypeString", "alias": "Mylar_Remarks", "length": 300, "domain": null } ], "indexes": [ { "name": "R807_SDE_ROWID_UK", "fields": "LAYOUT_ID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G697Layout_ID_Do", "fields": "Layout_ID_Double", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "LayoutPlans", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "Layout_ID_Double", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AE6D5D6B-B098-49B6-8947-EA1E312957CF}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }