{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 21, "name": "D4_POD_Well_Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspector1", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "inspector1", "type": "esriFieldTypeString", "alias": "Inspector 1", "length": 255, "domain": { "type": "codedValue", "name": "D4_INSPECTOR", "description": "", "codedValues": [ { "name": "Alfred Perrault", "code": "AP" }, { "name": "Amanda Kelly", "code": "AK" }, { "name": "Caitlyn Owens", "code": "CO" }, { "name": "Carlos Benavides", "code": "CB" }, { "name": "Christina Hernandez", "code": "CH" }, { "name": "Craig Cathey", "code": "CC" }, { "name": "Darien Pruitt", "code": "DP" }, { "name": "Dayna Campbell", "code": "DC" }, { "name": "Dustyn Hennesay", "code": "DH" }, { "name": "Glen Montoya", "code": "GM" }, { "name": "Jamie Pirtle", "code": "JP" }, { "name": "JR Hennessey", "code": "JH" }, { "name": "Kate Fauske Maynard", "code": "KFM" }, { "name": "Liliana Gallegos", "code": "LG" }, { "name": "Lilyan Sensiba", "code": "LS" }, { "name": "Marlyann Lozano-Enriquez", "code": "MLE" }, { "name": "Oscar Esparza Jr.", "code": "OE" }, { "name": "Ramona Cuaron", "code": "RC" }, { "name": "Ryan Serrano", "code": "RS" }, { "name": "Sarah Rodriguez", "code": "SR" }, { "name": "Sylvana Garay", "code": "SG" }, { "name": "Yvette Lopez", "code": "YL" }, { "name": "Other", "code": "OTHER" }, { "name": "Donna Martinez", "code": "DM" }, { "name": "Jennifer Yebra", "code": "JY" }, { "name": "Edward Misquez", "code": "EM" }, { "name": "Anita Tafoya", "code": "AT" }, { "name": "Shannon Rees", "code": "SKR" }, { "name": "Konnor Riddle", "code": "KR" }, { "name": "Cody Craig", "code": "C2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "inspector2", "type": "esriFieldTypeString", "alias": "Inspector 2", "length": 255, "domain": { "type": "codedValue", "name": "D4_INSPECTOR", "description": "", "codedValues": [ { "name": "Alfred Perrault", "code": "AP" }, { "name": "Amanda Kelly", "code": "AK" }, { "name": "Caitlyn Owens", "code": "CO" }, { "name": "Carlos Benavides", "code": "CB" }, { "name": "Christina Hernandez", "code": "CH" }, { "name": "Craig Cathey", "code": "CC" }, { "name": "Darien Pruitt", "code": "DP" }, { "name": "Dayna Campbell", "code": "DC" }, { "name": "Dustyn Hennesay", "code": "DH" }, { "name": "Glen Montoya", "code": "GM" }, { "name": "Jamie Pirtle", "code": "JP" }, { "name": "JR Hennessey", "code": "JH" }, { "name": "Kate Fauske Maynard", "code": "KFM" }, { "name": "Liliana Gallegos", "code": "LG" }, { "name": "Lilyan Sensiba", "code": "LS" }, { "name": "Marlyann Lozano-Enriquez", "code": "MLE" }, { "name": "Oscar Esparza Jr.", "code": "OE" }, { "name": "Ramona Cuaron", "code": "RC" }, { "name": "Ryan Serrano", "code": "RS" }, { "name": "Sarah Rodriguez", "code": "SR" }, { "name": "Sylvana Garay", "code": "SG" }, { "name": "Yvette Lopez", "code": "YL" }, { "name": "Other", "code": "OTHER" }, { "name": "Donna Martinez", "code": "DM" }, { "name": "Jennifer Yebra", "code": "JY" }, { "name": "Edward Misquez", "code": "EM" }, { "name": "Anita Tafoya", "code": "AT" }, { "name": "Shannon Rees", "code": "SKR" }, { "name": "Konnor Riddle", "code": "KR" }, { "name": "Cody Craig", "code": "C2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "inspdate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "owner_present", "type": "esriFieldTypeString", "alias": "Owner Present", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ownercontacted", "type": "esriFieldTypeString", "alias": "Owner Contacted", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "locationdesc", "type": "esriFieldTypeString", "alias": "Location Description", "length": 500, "domain": null }, { "name": "insppurpose", "type": "esriFieldTypeString", "alias": "Inspection Purpose", "length": 255, "domain": { "type": "codedValue", "name": "D4_INSPECTION_PURPOSE", "description": "Inspection Purpose", "codedValues": [ { "name": "Verify Reading", "code": "VERIREAD" }, { "name": "Meter Installation", "code": "METRINST" }, { "name": "Obtain Reading", "code": "OBTREAD" }, { "name": "Field Report", "code": "FELDRPT" }, { "name": "Red Tagged", "code": "RT" }, { "name": "Verify Compliance", "code": "VERICOMP" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "pod_status", "type": "esriFieldTypeString", "alias": "POD Status", "length": 255, "domain": { "type": "codedValue", "name": "D4_POD_STATUS", "description": "POD Status", "codedValues": [ { "name": "Fully Equipped", "code": "FLEQP" }, { "name": "Partially Equipped", "code": "PTEQP" }, { "name": "Open to Atmosphere", "code": "OPN" }, { "name": "Pending", "code": "PEN" }, { "name": "Active", "code": "ACT" }, { "name": "Inactive", "code": "INC" }, { "name": "Capped", "code": "CAP" }, { "name": "Plugged", "code": "PLG" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTHER" }, { "name": "Emergency", "code": "EMG" }, { "name": "Not Drilled", "code": "NTD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "well_tag", "type": "esriFieldTypeString", "alias": "Well Tag", "length": 10, "domain": null }, { "name": "recentuse", "type": "esriFieldTypeString", "alias": "Recent Use", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "currentpump", "type": "esriFieldTypeString", "alias": "Currently Pumping", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "prcntfullpipe", "type": "esriFieldTypeDouble", "alias": "Percent Full Pipe", "domain": null }, { "name": "dist_sys_info", "type": "esriFieldTypeString", "alias": "Distribution System", "length": 500, "domain": null }, { "name": "pipe_dia", "type": "esriFieldTypeDouble", "alias": "Pipe Diameter", "domain": null }, { "name": "unob_upstrm", "type": "esriFieldTypeString", "alias": "Unobstructed Pipe Upstream", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "strgtvane_up", "type": "esriFieldTypeString", "alias": "Straightening Vanes Upstream", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "measurement_up", "type": "esriFieldTypeDouble", "alias": "Measurement Upstream", "domain": null }, { "name": "unob_dwnstrm", "type": "esriFieldTypeString", "alias": "Unobstructed Pipe Downstream", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "strgtvane_down", "type": "esriFieldTypeString", "alias": "Straightening Vanes Downstream", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "measurement_down", "type": "esriFieldTypeDouble", "alias": "Measurement Downstream", "domain": null }, { "name": "out_valves_b4_meter", "type": "esriFieldTypeString", "alias": "Diversions Before Meter", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 500, "domain": null }, { "name": "otherobservation", "type": "esriFieldTypeString", "alias": "Other Observation", "length": 500, "domain": null }, { "name": "issueresolved", "type": "esriFieldTypeString", "alias": "Issue Resolved", "length": 255, "domain": { "type": "codedValue", "name": "D4_QUESTION", "description": "Direct Answer Short Question", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "completiondate", "type": "esriFieldTypeDate", "alias": "Completion Date", "length": 8, "domain": null }, { "name": "parentguid", "type": "esriFieldTypeGUID", "alias": "Parent GUID", "length": 38, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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 } ], "indexes": [ { "name": "g56parentguid", "fields": "parentguid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "uuid_30", "fields": "globalid,objectid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "D4_POD", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "parentguid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{8F700C73-676F-4E89-A708-CC25DB06ACBA}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1780927458000 }, "serviceItemId": "aa080c2888664fb38e795b8f0f1ff4bf" }