{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Report", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 63, 137, 64, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -88.56293849999997, "ymin": 5.6843418860808015E-14, "xmax": 5.6843418860808015E-14, "ymax": 47.23537500000003, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "poclastname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "report_id", "type": "esriFieldTypeString", "alias": "Report No", "length": 255, "domain": null }, { "name": "facilityid", "type": "esriFieldTypeGUID", "alias": "Facility ID", "length": 38, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "x", "type": "esriFieldTypeDouble", "alias": "x", "domain": null }, { "name": "y", "type": "esriFieldTypeDouble", "alias": "y", "domain": null }, { "name": "pocphoneext", "type": "esriFieldTypeString", "alias": "pocphoneext", "length": 50, "domain": null }, { "name": "status_date", "type": "esriFieldTypeDate", "alias": "Status Date", "length": 8, "domain": null }, { "name": "epoch_created", "type": "esriFieldTypeDouble", "alias": "epoch_created", "domain": null }, { "name": "poccompany", "type": "esriFieldTypeString", "alias": "Company Name", "length": 255, "domain": null }, { "name": "poccompanyaddr", "type": "esriFieldTypeString", "alias": "Company Address", "length": 255, "domain": null }, { "name": "poctitle", "type": "esriFieldTypeString", "alias": "Title", "length": 255, "domain": null }, { "name": "cosigner_name", "type": "esriFieldTypeString", "alias": "Cosigner Name", "length": 255, "domain": null }, { "name": "cosigner_title", "type": "esriFieldTypeString", "alias": "Cosigner Title", "length": 255, "domain": null }, { "name": "cosigner_phone", "type": "esriFieldTypeString", "alias": "Cosigner Phone", "length": 255, "domain": null }, { "name": "cosigner_email", "type": "esriFieldTypeString", "alias": "Cosigner Email", "length": 255, "domain": null }, { "name": "cosigner_date", "type": "esriFieldTypeDate", "alias": "Cosigner Date", "length": 8, "domain": null }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "length": 50, "domain": null }, { "name": "earliest_closure_date", "type": "esriFieldTypeDate", "alias": "Earliest Closure Date", "length": 8, "domain": null }, { "name": "actual_closure_date", "type": "esriFieldTypeDate", "alias": "Actual Closure Date", "length": 8, "domain": null }, { "name": "upgrade_due_date", "type": "esriFieldTypeDate", "alias": "Upgrade Due Date", "length": 8, "domain": null }, { "name": "closure_due_date", "type": "esriFieldTypeDate", "alias": "Closure Due Date", "length": 8, "domain": null }, { "name": "inspector_id", "type": "esriFieldTypeString", "alias": "Inspector ID", "length": 128, "domain": null }, { "name": "revisionid", "type": "esriFieldTypeGUID", "alias": "Revision ID", "length": 38, "domain": null }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "Activity ID", "length": 38, "domain": null }, { "name": "insp_ref_facility_no", "type": "esriFieldTypeString", "alias": "Facility No", "length": 1000, "domain": null }, { "name": "confirmation_sent_date", "type": "esriFieldTypeDate", "alias": "Confirmation Sent Date", "length": 8, "domain": null }, { "name": "submitdate", "type": "esriFieldTypeDate", "alias": "Submit Date", "length": 8, "domain": null }, { "name": "expiration_date", "type": "esriFieldTypeDate", "alias": "Expiration Date", "length": 8, "domain": null }, { "name": "insp_ref_tank_no", "type": "esriFieldTypeString", "alias": "Inspection Report Tank Nos", "length": 1000, "domain": null }, { "name": "accela_hist_action_on_after", "type": "esriFieldTypeDate", "alias": "Accela Action On or After", "length": 8, "domain": null } ], "geometryField": {}, "indexes": [ { "name": "UUID_601", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_12394_facili", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "LARA_SDE.LARA_ADMIN.releaseReports", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CD4D0D66-7C04-4229-8733-72412C1293E7}" }, { "id": 1, "name": "LARA_SDE.LARA_ADMIN.facilities", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "facilityid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CC0C032F-A3FB-4CCB-B238-742298B1F092}" }, { "id": 2, "name": "LARA_SDE.LARA_ADMIN.facilities", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "parentglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A3BAB7EE-3EBE-4D92-814C-B06D8AEE78AA}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1722255045000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Tank", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 175, 56, 156, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -88.56293183999998, "ymin": 5.6843418860808015E-14, "xmax": 5.6843418860808015E-14, "ymax": 47.12202037000003, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "tcp_imp_curr_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "closed_by", "type": "esriFieldTypeString", "alias": "Tank Closed By", "length": 128, "domain": null }, { "name": "closure_dt", "type": "esriFieldTypeDate", "alias": "Closure Date", "length": 8, "domain": null }, { "name": "comp_qty", "type": "esriFieldTypeSmallInteger", "alias": "Compartment Qty", "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "facilityid", "type": "esriFieldTypeGUID", "alias": "Facility ID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "inst_date", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "tagged", "type": "esriFieldTypeString", "alias": "Tagged?", "length": 255, "domain": null }, { "name": "tank_capacity", "type": "esriFieldTypeDouble", "alias": "Tank Capacity", "domain": null }, { "name": "tank_no", "type": "esriFieldTypeString", "alias": "Tank No.", "length": 255, "domain": null }, { "name": "tank_status", "type": "esriFieldTypeString", "alias": "Tank Status", "length": 35, "domain": null }, { "name": "tank_substance", "type": "esriFieldTypeString", "alias": "Substance", "length": 255, "domain": null }, { "name": "not_removed_comment", "type": "esriFieldTypeString", "alias": "Closing Additional Info", "length": 1000, "domain": null }, { "name": "fin_res_type", "type": "esriFieldTypeString", "alias": "fin_res_type", "length": 1000, "domain": null }, { "name": "x", "type": "esriFieldTypeDouble", "alias": "x", "domain": null }, { "name": "y", "type": "esriFieldTypeDouble", "alias": "y", "domain": null }, { "name": "registration_date", "type": "esriFieldTypeDate", "alias": "registration_date", "length": 8, "domain": null }, { "name": "renewal_date", "type": "esriFieldTypeDate", "alias": "renewal_date", "length": 8, "domain": null }, { "name": "inspectionid", "type": "esriFieldTypeGUID", "alias": "inspectionid", "length": 38, "domain": null }, { "name": "submittedby", "type": "esriFieldTypeString", "alias": "Submitted By", "length": 128, "domain": null }, { "name": "epoch_created", "type": "esriFieldTypeDouble", "alias": "epoch_created", "domain": null }, { "name": "a_operator_id", "type": "esriFieldTypeGUID", "alias": "Class A Operator ID", "length": 38, "domain": null }, { "name": "b_operator_id", "type": "esriFieldTypeGUID", "alias": "Class B Operator ID", "length": 38, "domain": null }, { "name": "tank_owner_id", "type": "esriFieldTypeGUID", "alias": "Owner ID", "length": 38, "domain": null }, { "name": "resp_party_id", "type": "esriFieldTypeGUID", "alias": "Responsible Party ID", "length": 38, "domain": null }, { "name": "tank_substance_other", "type": "esriFieldTypeString", "alias": "Tank Substance Other", "length": 255, "domain": null }, { "name": "public_act", "type": "esriFieldTypeString", "alias": "Public Act", "length": 255, "domain": null }, { "name": "manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "length": 50, "domain": null }, { "name": "coord_source", "type": "esriFieldTypeString", "alias": "Tank Coordinate Source", "length": 255, "domain": null }, { "name": "tank_insp_ref_id", "type": "esriFieldTypeString", "alias": "Tank Inspection Ref ID", "length": 255, "domain": null }, { "name": "tank_compliance_status", "type": "esriFieldTypeString", "alias": "Compliance Status", "length": 255, "domain": null }, { "name": "last_insp_typ", "type": "esriFieldTypeString", "alias": "Last Inspection Type", "length": 255, "domain": null }, { "name": "last_insp_result", "type": "esriFieldTypeString", "alias": "Last Inspection Result", "length": 255, "domain": null }, { "name": "serial_number", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 255, "domain": null }, { "name": "manufacture_year", "type": "esriFieldTypeSmallInteger", "alias": "Manufacture Year", "domain": null }, { "name": "accela_hist_billable_tank", "type": "esriFieldTypeString", "alias": "Accela Billable Tank", "length": 255, "domain": null }, { "name": "accela_hist_region", "type": "esriFieldTypeString", "alias": "Accela Region", "length": 255, "domain": null }, { "name": "accela_hist_rpf_exempt", "type": "esriFieldTypeString", "alias": "Accela RPF Exempt", "length": 255, "domain": null }, { "name": "accela_hist_flcl_req_met", "type": "esriFieldTypeString", "alias": "Accela FLCL Requirements Met", "length": 255, "domain": null }, { "name": "accela_hist_billable_owner", "type": "esriFieldTypeString", "alias": "Accela Billable Owner", "length": 255, "domain": null }, { "name": "accela_hist_first_tank", "type": "esriFieldTypeString", "alias": "Accela First Tank", "length": 255, "domain": null }, { "name": "accela_hist_inspect_approve", "type": "esriFieldTypeString", "alias": "Accela Inspected & Approved", "length": 255, "domain": null }, { "name": "accela_hist_engineer_inspect", "type": "esriFieldTypeString", "alias": "Accela Engineer Inspected", "length": 255, "domain": null }, { "name": "accela_hist_new_chan_upg", "type": "esriFieldTypeString", "alias": "Accela New/Upgrade/Change in Service", "length": 255, "domain": null }, { "name": "accela_hist_nrt", "type": "esriFieldTypeString", "alias": "Accela NRT Tank", "length": 255, "domain": null }, { "name": "accela_hist_sump_test", "type": "esriFieldTypeString", "alias": "Accela Sump Test", "length": 255, "domain": null }, { "name": "accela_hist_owner_type", "type": "esriFieldTypeString", "alias": "Accela Owner Type", "length": 255, "domain": null }, { "name": "accela_hist_change_in_service", "type": "esriFieldTypeString", "alias": "Accela Change Service", "length": 255, "domain": null }, { "name": "accela_hist_tank_removed", "type": "esriFieldTypeString", "alias": "Accela Tank Removed From Ground", "length": 255, "domain": null }, { "name": "accela_hist_tribe_name", "type": "esriFieldTypeString", "alias": "Accela Name of Tribe", "length": 255, "domain": null }, { "name": "accela_hist_owned_tribe", "type": "esriFieldTypeString", "alias": "Accela Owned By NA Tribe", "length": 255, "domain": null }, { "name": "accela_hist_comm_facility", "type": "esriFieldTypeString", "alias": "Accela Type of Commercial Facility", "length": 255, "domain": null }, { "name": "accela_hist_notification_date", "type": "esriFieldTypeString", "alias": "Accela Notification Date", "length": 255, "domain": null }, { "name": "accela_hist_registration_date", "type": "esriFieldTypeDate", "alias": "Accela Registration Date", "length": 8, "domain": null }, { "name": "accela_hist_action_on_tank", "type": "esriFieldTypeString", "alias": "Accela Action on Tank", "length": 255, "domain": null }, { "name": "accela_hist_comment_clarif", "type": "esriFieldTypeString", "alias": "Accela Comments Clarfication", "length": 255, "domain": null }, { "name": "accela_hist_inert_filled", "type": "esriFieldTypeString", "alias": "Accela Tank Filled with Inert Material", "length": 255, "domain": null }, { "name": "accela_hist_pipe_rel_detect", "type": "esriFieldTypeString", "alias": "Accela Piping Release Detection", "length": 2000, "domain": null }, { "name": "accela_hist_rel_detect", "type": "esriFieldTypeString", "alias": "Accela Release Detection", "length": 255, "domain": null }, { "name": "tank_change_type", "type": "esriFieldTypeString", "alias": "Tank Change Type", "length": 255, "domain": null } ], "geometryField": {}, "indexes": [ { "name": "UUID_595", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_12388_facili", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "LARA_SDE.LARA_ADMIN.releaseReports", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C47AA12D-7063-41E3-A0E4-1FE98963606D}" }, { "id": 4, "name": "LARA_SDE.LARA_ADMIN.customers", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "a_operator_id", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{477C628B-5DA7-4CA0-9EA1-77D50BDEB695}" }, { "id": 5, "name": "LARA_SDE.LARA_ADMIN.customers", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "b_operator_id", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{34A8F938-8CB5-4CC3-A6B8-A46E058D441C}" }, { "id": 6, "name": "LARA_SDE.LARA_ADMIN.customers", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "tank_owner_id", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{8B1F6796-A9E2-4714-9BAC-EFF415C02F09}" }, { "id": 7, "name": "LARA_SDE.LARA_ADMIN.facilities", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "facilityid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{10C987CC-7ECE-4FE3-B7DF-96C18FE10CAD}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1744053598000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Facility", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 160, 117, 38, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -86.22134499999999, "ymin": 42.271768000000066, "xmax": -83.11951399999998, "ymax": 45.15302800000006, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "facility_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "facility_no", "type": "esriFieldTypeString", "alias": "Facility No", "length": 255, "domain": null }, { "name": "facility_name", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 255, "domain": null }, { "name": "county", "type": "esriFieldTypeString", "alias": "Facility County", "length": 50, "domain": null }, { "name": "ownerid", "type": "esriFieldTypeGUID", "alias": "Owner ID", "length": 38, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "x", "type": "esriFieldTypeDouble", "alias": "x", "domain": null }, { "name": "y", "type": "esriFieldTypeDouble", "alias": "y", "domain": null }, { "name": "facility_type", "type": "esriFieldTypeString", "alias": "facility_type", "length": 255, "domain": null }, { "name": "location_contact_id", "type": "esriFieldTypeGUID", "alias": "Location Contact ID", "length": 38, "domain": null }, { "name": "expirationdt", "type": "esriFieldTypeDate", "alias": "Expiration Date", "length": 8, "domain": null }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "length": 50, "domain": null }, { "name": "program_region", "type": "esriFieldTypeString", "alias": "Program Region", "length": 255, "domain": null }, { "name": "fac_insp_ref_id", "type": "esriFieldTypeString", "alias": "Facility Inspection Ref ID", "length": 255, "domain": null }, { "name": "fac_compliance_status", "type": "esriFieldTypeString", "alias": "Facility Compliance Status", "length": 255, "domain": null }, { "name": "fac_last_insp_dt", "type": "esriFieldTypeDate", "alias": "Facility Inspection Date", "length": 8, "domain": null }, { "name": "fac_last_insp_typ", "type": "esriFieldTypeString", "alias": "Facility Inspection Type", "length": 255, "domain": null }, { "name": "fac_last_insp_result", "type": "esriFieldTypeString", "alias": "Facility Inspection Result", "length": 255, "domain": null }, { "name": "fr_reporting_year", "type": "esriFieldTypeSmallInteger", "alias": "FR Reporting Year", "domain": null }, { "name": "fr_expiration_dt", "type": "esriFieldTypeDate", "alias": "FR Expiration Date", "length": 8, "domain": null }, { "name": "fr_exempt", "type": "esriFieldTypeString", "alias": "FR Exempt", "length": 255, "domain": null }, { "name": "fr_type_of_insurance", "type": "esriFieldTypeString", "alias": "FR Type of Insurance", "length": 255, "domain": null }, { "name": "fr_revoked", "type": "esriFieldTypeString", "alias": "FR Revoked", "length": 255, "domain": null }, { "name": "fr_revoked_year", "type": "esriFieldTypeSmallInteger", "alias": "FR Revoked Year", "domain": null }, { "name": "fr_revoked_egle_dt", "type": "esriFieldTypeDate", "alias": "FR Revoked Date EGLE", "length": 8, "domain": null }, { "name": "hmsi_full_name", "type": "esriFieldTypeString", "alias": "HMSI Full Name", "length": 255, "domain": null }, { "name": "accela_hist_billing_code", "type": "esriFieldTypeString", "alias": "Accela Billing Code", "length": 255, "domain": null }, { "name": "accela_hist_region", "type": "esriFieldTypeString", "alias": "Accela Region", "length": 255, "domain": null }, { "name": "insp_ref_tank_no", "type": "esriFieldTypeString", "alias": "Inspection Report Tank Nos", "length": 1000, "domain": null }, { "name": "accela_hist_billable_owner", "type": "esriFieldTypeString", "alias": "Accela Billable Owners", "length": 255, "domain": null }, { "name": "accela_hist_owner_type", "type": "esriFieldTypeString", "alias": "Accela Owner Type", "length": 255, "domain": null }, { "name": "address1", "type": "esriFieldTypeString", "alias": "Address 1", "length": 255, "domain": null }, { "name": "address2", "type": "esriFieldTypeString", "alias": "Address 2", "length": 255, "domain": null }, { "name": "city", "type": "esriFieldTypeString", "alias": "City", "length": 255, "domain": null }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "length": 255, "domain": null }, { "name": "zipcode", "type": "esriFieldTypeString", "alias": "Zip Code", "length": 255, "domain": null } ], "geometryField": {}, "indexes": [ { "name": "UUID_597", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IX_FAC_FNO", "fields": "facility_no", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "LARA_SDE.LARA_ADMIN.reports", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CC0C032F-A3FB-4CCB-B238-742298B1F092}" }, { "id": 7, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{10C987CC-7ECE-4FE3-B7DF-96C18FE10CAD}" }, { "id": 2, "name": "LARA_SDE.LARA_ADMIN.reports", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A3BAB7EE-3EBE-4D92-814C-B06D8AEE78AA}" }, { "id": 8, "name": "LARA_SDE.LARA_ADMIN.customers", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "ownerid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A4C39B8C-4908-4D51-BC6F-E93A966A0682}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1722249248000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 20, "name": "Release Reports", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "release_no", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "release_status", "type": "esriFieldTypeString", "alias": "Release Status", "length": 255, "domain": null }, { "name": "reportid", "type": "esriFieldTypeGUID", "alias": "Report ID", "length": 38, "domain": null }, { "name": "tankid", "type": "esriFieldTypeGUID", "alias": "Tank ID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "contractor_name", "type": "esriFieldTypeString", "alias": "Contractor Name", "length": 255, "domain": null }, { "name": "contractor_contact", "type": "esriFieldTypeString", "alias": "Contractor Contact", "length": 255, "domain": null }, { "name": "contractor_phone", "type": "esriFieldTypeString", "alias": "Contractor Phone", "length": 255, "domain": null }, { "name": "equip_related", "type": "esriFieldTypeString", "alias": "Equipment Related", "length": 255, "domain": null }, { "name": "release_status_dt", "type": "esriFieldTypeDate", "alias": "release_status_dt", "length": 8, "domain": null }, { "name": "release_discovered_date", "type": "esriFieldTypeDate", "alias": "release_discovered_date", "length": 8, "domain": null }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "length": 50, "domain": null }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "Activity ID", "length": 38, "domain": null } ], "indexes": [ { "name": "UUID_493", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G11751reportid", "fields": "reportid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "tankid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C47AA12D-7063-41E3-A0E4-1FE98963606D}" }, { "id": 0, "name": "LARA_SDE.LARA_ADMIN.reports", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "reportid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CD4D0D66-7C04-4229-8733-72412C1293E7}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1720691583000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 47, "name": "customers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "comp_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "comp_name", "type": "esriFieldTypeString", "alias": "Company Name", "length": 150, "domain": null }, { "name": "first_name", "type": "esriFieldTypeString", "alias": "First Name", "length": 150, "domain": null }, { "name": "last_name", "type": "esriFieldTypeString", "alias": "Last Name", "length": 150, "domain": null }, { "name": "address1", "type": "esriFieldTypeString", "alias": "Address 1", "length": 255, "domain": null }, { "name": "address2", "type": "esriFieldTypeString", "alias": "Address 2", "length": 255, "domain": null }, { "name": "city", "type": "esriFieldTypeString", "alias": "City", "length": 255, "domain": null }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "zip_code", "type": "esriFieldTypeString", "alias": "Zip Code", "length": 5, "domain": null }, { "name": "email", "type": "esriFieldTypeString", "alias": "Email", "length": 100, "domain": null }, { "name": "phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 15, "domain": null }, { "name": "title", "type": "esriFieldTypeString", "alias": "Job Title", "length": 255, "domain": null }, { "name": "middle_name", "type": "esriFieldTypeString", "alias": "Middle Name", "length": 70, "domain": null }, { "name": "suffix", "type": "esriFieldTypeString", "alias": "Suffix", "length": 10, "domain": null }, { "name": "trade_name", "type": "esriFieldTypeString", "alias": "Trade Name", "length": 255, "domain": null }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "Activity ID", "length": 38, "domain": null } ], "indexes": [ { "name": "UUID_487", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_487", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_CUST_FMLS", "fields": "first_name,middle_name,last_name,suffix", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_CUST_TN", "fields": "trade_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_CUST_GID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "LARA_SDE.LARA_ADMIN.facilities", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A4C39B8C-4908-4D51-BC6F-E93A966A0682}" }, { "id": 5, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{34A8F938-8CB5-4CC3-A6B8-A46E058D441C}" }, { "id": 4, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{477C628B-5DA7-4CA0-9EA1-77D50BDEB695}" }, { "id": 6, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{8B1F6796-A9E2-4714-9BAC-EFF415C02F09}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1720691981000 } } ] }