{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Report", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "LARA_SDE.LARA_ADMIN.releaseReports", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{CD4D0D66-7C04-4229-8733-72412C1293E7}" }, { "id": 1, "name": "LARA_SDE.LARA_ADMIN.facilities", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "facilityid", "composite": false, "catalogID": "{CC0C032F-A3FB-4CCB-B238-742298B1F092}" }, { "id": 2, "name": "LARA_SDE.LARA_ADMIN.facilities", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "parentglobalid", "composite": false, "catalogID": "{A3BAB7EE-3EBE-4D92-814C-B06D8AEE78AA}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1722255045000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "poclastname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "report_id", "type": "esriFieldTypeString", "alias": "Report No", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "report_id" }, { "name": "facilityid", "type": "esriFieldTypeGUID", "alias": "Facility ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "facilityid" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "x", "type": "esriFieldTypeDouble", "alias": "x", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "x" }, { "name": "y", "type": "esriFieldTypeDouble", "alias": "y", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "y" }, { "name": "pocphoneext", "type": "esriFieldTypeString", "alias": "pocphoneext", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "pocphoneext" }, { "name": "status_date", "type": "esriFieldTypeDate", "alias": "Status Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "status_date" }, { "name": "epoch_created", "type": "esriFieldTypeDouble", "alias": "epoch_created", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "epoch_created" }, { "name": "poccompany", "type": "esriFieldTypeString", "alias": "Company Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "poccompany" }, { "name": "poccompanyaddr", "type": "esriFieldTypeString", "alias": "Company Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "poccompanyaddr" }, { "name": "poctitle", "type": "esriFieldTypeString", "alias": "Title", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "poctitle" }, { "name": "cosigner_name", "type": "esriFieldTypeString", "alias": "Cosigner Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "cosigner_name" }, { "name": "cosigner_title", "type": "esriFieldTypeString", "alias": "Cosigner Title", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "cosigner_title" }, { "name": "cosigner_phone", "type": "esriFieldTypeString", "alias": "Cosigner Phone", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "cosigner_phone" }, { "name": "cosigner_email", "type": "esriFieldTypeString", "alias": "Cosigner Email", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "cosigner_email" }, { "name": "cosigner_date", "type": "esriFieldTypeDate", "alias": "Cosigner Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "cosigner_date" }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "accela_ref_id" }, { "name": "earliest_closure_date", "type": "esriFieldTypeDate", "alias": "Earliest Closure Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "earliest_closure_date" }, { "name": "actual_closure_date", "type": "esriFieldTypeDate", "alias": "Actual Closure Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "actual_closure_date" }, { "name": "upgrade_due_date", "type": "esriFieldTypeDate", "alias": "Upgrade Due Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "upgrade_due_date" }, { "name": "closure_due_date", "type": "esriFieldTypeDate", "alias": "Closure Due Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "closure_due_date" }, { "name": "inspector_id", "type": "esriFieldTypeString", "alias": "Inspector ID", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "inspector_id" }, { "name": "revisionid", "type": "esriFieldTypeGUID", "alias": "Revision ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "revisionid" }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "Activity ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "parentglobalid" }, { "name": "insp_ref_facility_no", "type": "esriFieldTypeString", "alias": "Facility No", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "insp_ref_facility_no" }, { "name": "confirmation_sent_date", "type": "esriFieldTypeDate", "alias": "Confirmation Sent Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "confirmation_sent_date" }, { "name": "submitdate", "type": "esriFieldTypeDate", "alias": "Submit Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "submitdate" }, { "name": "expiration_date", "type": "esriFieldTypeDate", "alias": "Expiration Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "expiration_date" }, { "name": "insp_ref_tank_no", "type": "esriFieldTypeString", "alias": "Inspection Report Tank Nos", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "insp_ref_tank_no" }, { "name": "accela_hist_action_on_after", "type": "esriFieldTypeDate", "alias": "Accela Action On or After", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "accela_hist_action_on_after" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "UUID_601", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_12394_facili", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Report", "description": "", "prototype": { "attributes": { "insp_ref_tank_no": null, "expiration_date": null, "report_id": null, "facilityid": null, "submitdate": null, "accela_hist_action_on_after": null, "x": 0, "y": 0, "pocphoneext": null, "status_date": null, "epoch_created": null, "poccompany": null, "poccompanyaddr": null, "poctitle": null, "cosigner_name": null, "cosigner_title": null, "cosigner_phone": null, "cosigner_email": null, "cosigner_date": null, "accela_ref_id": null, "earliest_closure_date": null, "actual_closure_date": null, "upgrade_due_date": null, "closure_due_date": null, "inspector_id": null, "revisionid": null, "parentglobalid": null, "insp_ref_facility_no": null, "confirmation_sent_date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Tank", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "LARA_SDE.LARA_ADMIN.releaseReports", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{C47AA12D-7063-41E3-A0E4-1FE98963606D}" }, { "id": 4, "name": "LARA_SDE.LARA_ADMIN.customers", "relatedTableId": 47, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "a_operator_id", "composite": false, "catalogID": "{477C628B-5DA7-4CA0-9EA1-77D50BDEB695}" }, { "id": 5, "name": "LARA_SDE.LARA_ADMIN.customers", "relatedTableId": 47, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "b_operator_id", "composite": false, "catalogID": "{34A8F938-8CB5-4CC3-A6B8-A46E058D441C}" }, { "id": 6, "name": "LARA_SDE.LARA_ADMIN.customers", "relatedTableId": 47, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "tank_owner_id", "composite": false, "catalogID": "{8B1F6796-A9E2-4714-9BAC-EFF415C02F09}" }, { "id": 7, "name": "LARA_SDE.LARA_ADMIN.facilities", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "facilityid", "composite": false, "catalogID": "{10C987CC-7ECE-4FE3-B7DF-96C18FE10CAD}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1744053598000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "tcp_imp_curr_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "closed_by", "type": "esriFieldTypeString", "alias": "Tank Closed By", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "closed_by" }, { "name": "closure_dt", "type": "esriFieldTypeDate", "alias": "Closure Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "closure_dt" }, { "name": "comp_qty", "type": "esriFieldTypeSmallInteger", "alias": "Compartment Qty", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "comp_qty" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "facilityid", "type": "esriFieldTypeGUID", "alias": "Facility ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "facilityid" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "inst_date", "type": "esriFieldTypeDate", "alias": "Installation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "inst_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "tagged", "type": "esriFieldTypeString", "alias": "Tagged?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tagged" }, { "name": "tank_capacity", "type": "esriFieldTypeDouble", "alias": "Tank Capacity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tank_capacity" }, { "name": "tank_no", "type": "esriFieldTypeString", "alias": "Tank No.", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tank_no" }, { "name": "tank_status", "type": "esriFieldTypeString", "alias": "Tank Status", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "tank_status" }, { "name": "tank_substance", "type": "esriFieldTypeString", "alias": "Substance", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tank_substance" }, { "name": "not_removed_comment", "type": "esriFieldTypeString", "alias": "Closing Additional Info", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "not_removed_comment" }, { "name": "fin_res_type", "type": "esriFieldTypeString", "alias": "fin_res_type", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "fin_res_type" }, { "name": "x", "type": "esriFieldTypeDouble", "alias": "x", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "x" }, { "name": "y", "type": "esriFieldTypeDouble", "alias": "y", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "y" }, { "name": "registration_date", "type": "esriFieldTypeDate", "alias": "registration_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "registration_date" }, { "name": "renewal_date", "type": "esriFieldTypeDate", "alias": "renewal_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "renewal_date" }, { "name": "inspectionid", "type": "esriFieldTypeGUID", "alias": "inspectionid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "inspectionid" }, { "name": "submittedby", "type": "esriFieldTypeString", "alias": "Submitted By", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "submittedby" }, { "name": "epoch_created", "type": "esriFieldTypeDouble", "alias": "epoch_created", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "epoch_created" }, { "name": "a_operator_id", "type": "esriFieldTypeGUID", "alias": "Class A Operator ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "a_operator_id" }, { "name": "b_operator_id", "type": "esriFieldTypeGUID", "alias": "Class B Operator ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "b_operator_id" }, { "name": "tank_owner_id", "type": "esriFieldTypeGUID", "alias": "Owner ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "tank_owner_id" }, { "name": "resp_party_id", "type": "esriFieldTypeGUID", "alias": "Responsible Party ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "resp_party_id" }, { "name": "tank_substance_other", "type": "esriFieldTypeString", "alias": "Tank Substance Other", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tank_substance_other" }, { "name": "public_act", "type": "esriFieldTypeString", "alias": "Public Act", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "public_act" }, { "name": "manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "manufacturer" }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "accela_ref_id" }, { "name": "coord_source", "type": "esriFieldTypeString", "alias": "Tank Coordinate Source", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "coord_source" }, { "name": "tank_insp_ref_id", "type": "esriFieldTypeString", "alias": "Tank Inspection Ref ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tank_insp_ref_id" }, { "name": "tank_compliance_status", "type": "esriFieldTypeString", "alias": "Compliance Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tank_compliance_status" }, { "name": "last_insp_typ", "type": "esriFieldTypeString", "alias": "Last Inspection Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_insp_typ" }, { "name": "last_insp_result", "type": "esriFieldTypeString", "alias": "Last Inspection Result", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_insp_result" }, { "name": "serial_number", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "serial_number" }, { "name": "manufacture_year", "type": "esriFieldTypeSmallInteger", "alias": "Manufacture Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "manufacture_year" }, { "name": "accela_hist_billable_tank", "type": "esriFieldTypeString", "alias": "Accela Billable Tank", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_billable_tank" }, { "name": "accela_hist_region", "type": "esriFieldTypeString", "alias": "Accela Region", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_region" }, { "name": "accela_hist_rpf_exempt", "type": "esriFieldTypeString", "alias": "Accela RPF Exempt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_rpf_exempt" }, { "name": "accela_hist_flcl_req_met", "type": "esriFieldTypeString", "alias": "Accela FLCL Requirements Met", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_flcl_req_met" }, { "name": "accela_hist_billable_owner", "type": "esriFieldTypeString", "alias": "Accela Billable Owner", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_billable_owner" }, { "name": "accela_hist_first_tank", "type": "esriFieldTypeString", "alias": "Accela First Tank", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_first_tank" }, { "name": "accela_hist_inspect_approve", "type": "esriFieldTypeString", "alias": "Accela Inspected & Approved", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_inspect_approve" }, { "name": "accela_hist_engineer_inspect", "type": "esriFieldTypeString", "alias": "Accela Engineer Inspected", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_engineer_inspect" }, { "name": "accela_hist_new_chan_upg", "type": "esriFieldTypeString", "alias": "Accela New/Upgrade/Change in Service", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_new_chan_upg" }, { "name": "accela_hist_nrt", "type": "esriFieldTypeString", "alias": "Accela NRT Tank", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_nrt" }, { "name": "accela_hist_sump_test", "type": "esriFieldTypeString", "alias": "Accela Sump Test", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_sump_test" }, { "name": "accela_hist_owner_type", "type": "esriFieldTypeString", "alias": "Accela Owner Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_owner_type" }, { "name": "accela_hist_change_in_service", "type": "esriFieldTypeString", "alias": "Accela Change Service", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_change_in_service" }, { "name": "accela_hist_tank_removed", "type": "esriFieldTypeString", "alias": "Accela Tank Removed From Ground", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_tank_removed" }, { "name": "accela_hist_tribe_name", "type": "esriFieldTypeString", "alias": "Accela Name of Tribe", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_tribe_name" }, { "name": "accela_hist_owned_tribe", "type": "esriFieldTypeString", "alias": "Accela Owned By NA Tribe", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_owned_tribe" }, { "name": "accela_hist_comm_facility", "type": "esriFieldTypeString", "alias": "Accela Type of Commercial Facility", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_comm_facility" }, { "name": "accela_hist_notification_date", "type": "esriFieldTypeString", "alias": "Accela Notification Date", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_notification_date" }, { "name": "accela_hist_registration_date", "type": "esriFieldTypeDate", "alias": "Accela Registration Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "accela_hist_registration_date" }, { "name": "accela_hist_action_on_tank", "type": "esriFieldTypeString", "alias": "Accela Action on Tank", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_action_on_tank" }, { "name": "accela_hist_comment_clarif", "type": "esriFieldTypeString", "alias": "Accela Comments Clarfication", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_comment_clarif" }, { "name": "accela_hist_inert_filled", "type": "esriFieldTypeString", "alias": "Accela Tank Filled with Inert Material", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_inert_filled" }, { "name": "accela_hist_pipe_rel_detect", "type": "esriFieldTypeString", "alias": "Accela Piping Release Detection", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "accela_hist_pipe_rel_detect" }, { "name": "accela_hist_rel_detect", "type": "esriFieldTypeString", "alias": "Accela Release Detection", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_rel_detect" }, { "name": "tank_change_type", "type": "esriFieldTypeString", "alias": "Tank Change Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tank_change_type" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "UUID_595", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_12388_facili", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Tank", "description": "", "prototype": { "attributes": { "accela_hist_rel_detect": null, "closed_by": null, "closure_dt": null, "comp_qty": null, "accela_hist_inert_filled": null, "facilityid": null, "tank_change_type": null, "inst_date": null, "accela_hist_comment_clarif": null, "accela_hist_pipe_rel_detect": null, "tagged": null, "tank_capacity": null, "tank_no": null, "tank_status": null, "tank_substance": null, "not_removed_comment": null, "fin_res_type": null, "x": 0, "y": 0, "registration_date": null, "renewal_date": null, "inspectionid": null, "submittedby": null, "epoch_created": null, "a_operator_id": null, "b_operator_id": null, "tank_owner_id": null, "resp_party_id": null, "tank_substance_other": null, "public_act": null, "manufacturer": null, "accela_ref_id": null, "coord_source": null, "tank_insp_ref_id": null, "tank_compliance_status": null, "last_insp_typ": null, "last_insp_result": null, "serial_number": null, "manufacture_year": null, "accela_hist_billable_tank": null, "accela_hist_region": null, "accela_hist_rpf_exempt": null, "accela_hist_flcl_req_met": null, "accela_hist_billable_owner": null, "accela_hist_first_tank": null, "accela_hist_inspect_approve": null, "accela_hist_engineer_inspect": null, "accela_hist_new_chan_upg": null, "accela_hist_nrt": null, "accela_hist_sump_test": null, "accela_hist_owner_type": null, "accela_hist_change_in_service": null, "accela_hist_tank_removed": null, "accela_hist_tribe_name": null, "accela_hist_owned_tribe": null, "accela_hist_comm_facility": null, "accela_hist_notification_date": null, "accela_hist_registration_date": null, "accela_hist_action_on_tank": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Facility", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "LARA_SDE.LARA_ADMIN.reports", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{CC0C032F-A3FB-4CCB-B238-742298B1F092}" }, { "id": 7, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{10C987CC-7ECE-4FE3-B7DF-96C18FE10CAD}" }, { "id": 2, "name": "LARA_SDE.LARA_ADMIN.reports", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{A3BAB7EE-3EBE-4D92-814C-B06D8AEE78AA}" }, { "id": 8, "name": "LARA_SDE.LARA_ADMIN.customers", "relatedTableId": 47, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ownerid", "composite": false, "catalogID": "{A4C39B8C-4908-4D51-BC6F-E93A966A0682}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1722249248000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "facility_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "facility_no", "type": "esriFieldTypeString", "alias": "Facility No", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "facility_no" }, { "name": "facility_name", "type": "esriFieldTypeString", "alias": "Facility Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "facility_name" }, { "name": "county", "type": "esriFieldTypeString", "alias": "Facility County", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "county" }, { "name": "ownerid", "type": "esriFieldTypeGUID", "alias": "Owner ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "ownerid" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "x", "type": "esriFieldTypeDouble", "alias": "x", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "x" }, { "name": "y", "type": "esriFieldTypeDouble", "alias": "y", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "y" }, { "name": "facility_type", "type": "esriFieldTypeString", "alias": "facility_type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "facility_type" }, { "name": "location_contact_id", "type": "esriFieldTypeGUID", "alias": "Location Contact ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "location_contact_id" }, { "name": "expirationdt", "type": "esriFieldTypeDate", "alias": "Expiration Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "expirationdt" }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "accela_ref_id" }, { "name": "program_region", "type": "esriFieldTypeString", "alias": "Program Region", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "program_region" }, { "name": "fac_insp_ref_id", "type": "esriFieldTypeString", "alias": "Facility Inspection Ref ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fac_insp_ref_id" }, { "name": "fac_compliance_status", "type": "esriFieldTypeString", "alias": "Facility Compliance Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fac_compliance_status" }, { "name": "fac_last_insp_dt", "type": "esriFieldTypeDate", "alias": "Facility Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "fac_last_insp_dt" }, { "name": "fac_last_insp_typ", "type": "esriFieldTypeString", "alias": "Facility Inspection Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fac_last_insp_typ" }, { "name": "fac_last_insp_result", "type": "esriFieldTypeString", "alias": "Facility Inspection Result", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fac_last_insp_result" }, { "name": "fr_reporting_year", "type": "esriFieldTypeSmallInteger", "alias": "FR Reporting Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "fr_reporting_year" }, { "name": "fr_expiration_dt", "type": "esriFieldTypeDate", "alias": "FR Expiration Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "fr_expiration_dt" }, { "name": "fr_exempt", "type": "esriFieldTypeString", "alias": "FR Exempt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fr_exempt" }, { "name": "fr_type_of_insurance", "type": "esriFieldTypeString", "alias": "FR Type of Insurance", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fr_type_of_insurance" }, { "name": "fr_revoked", "type": "esriFieldTypeString", "alias": "FR Revoked", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fr_revoked" }, { "name": "fr_revoked_year", "type": "esriFieldTypeSmallInteger", "alias": "FR Revoked Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "fr_revoked_year" }, { "name": "fr_revoked_egle_dt", "type": "esriFieldTypeDate", "alias": "FR Revoked Date EGLE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "fr_revoked_egle_dt" }, { "name": "hmsi_full_name", "type": "esriFieldTypeString", "alias": "HMSI Full Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "hmsi_full_name" }, { "name": "accela_hist_billing_code", "type": "esriFieldTypeString", "alias": "Accela Billing Code", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_billing_code" }, { "name": "accela_hist_region", "type": "esriFieldTypeString", "alias": "Accela Region", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_region" }, { "name": "insp_ref_tank_no", "type": "esriFieldTypeString", "alias": "Inspection Report Tank Nos", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "insp_ref_tank_no" }, { "name": "accela_hist_billable_owner", "type": "esriFieldTypeString", "alias": "Accela Billable Owners", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_billable_owner" }, { "name": "accela_hist_owner_type", "type": "esriFieldTypeString", "alias": "Accela Owner Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "accela_hist_owner_type" }, { "name": "address1", "type": "esriFieldTypeString", "alias": "Address 1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "address1" }, { "name": "address2", "type": "esriFieldTypeString", "alias": "Address 2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "address2" }, { "name": "city", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "city" }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "state" }, { "name": "zipcode", "type": "esriFieldTypeString", "alias": "Zip Code", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "zipcode" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "UUID_597", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IX_FAC_FNO", "fields": "facility_no", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Facility", "description": "", "prototype": { "attributes": { "state": null, "city": null, "facility_no": null, "facility_name": null, "county": null, "ownerid": null, "address2": null, "address1": null, "zipcode": null, "x": 0, "y": 0, "facility_type": null, "location_contact_id": null, "expirationdt": null, "accela_ref_id": null, "program_region": null, "fac_insp_ref_id": null, "fac_compliance_status": null, "fac_last_insp_dt": null, "fac_last_insp_typ": null, "fac_last_insp_result": null, "fr_reporting_year": null, "fr_expiration_dt": null, "fr_exempt": null, "fr_type_of_insurance": null, "fr_revoked": null, "fr_revoked_year": null, "fr_revoked_egle_dt": null, "hmsi_full_name": null, "accela_hist_billing_code": null, "accela_hist_region": null, "insp_ref_tank_no": null, "accela_hist_billable_owner": null, "accela_hist_owner_type": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 20, "name": "Release Reports", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "tankid", "composite": false, "catalogID": "{C47AA12D-7063-41E3-A0E4-1FE98963606D}" }, { "id": 0, "name": "LARA_SDE.LARA_ADMIN.reports", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "reportid", "composite": false, "catalogID": "{CD4D0D66-7C04-4229-8733-72412C1293E7}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1720691583000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "release_no", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "release_status", "type": "esriFieldTypeString", "alias": "Release Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "release_status" }, { "name": "reportid", "type": "esriFieldTypeGUID", "alias": "Report ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "reportid" }, { "name": "tankid", "type": "esriFieldTypeGUID", "alias": "Tank ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "tankid" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "contractor_name", "type": "esriFieldTypeString", "alias": "Contractor Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "contractor_name" }, { "name": "contractor_contact", "type": "esriFieldTypeString", "alias": "Contractor Contact", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "contractor_contact" }, { "name": "contractor_phone", "type": "esriFieldTypeString", "alias": "Contractor Phone", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "contractor_phone" }, { "name": "equip_related", "type": "esriFieldTypeString", "alias": "Equipment Related", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "equip_related" }, { "name": "release_status_dt", "type": "esriFieldTypeDate", "alias": "release_status_dt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "release_status_dt" }, { "name": "release_discovered_date", "type": "esriFieldTypeDate", "alias": "release_discovered_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "release_discovered_date" }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "accela_ref_id" }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "Activity ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "parentglobalid" } ], "indexes": [ { "name": "UUID_493", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G11751reportid", "fields": "reportid", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Release Reports", "description": "", "prototype": { "attributes": { "accela_ref_id": null, "release_discovered_date": null, "release_status": null, "reportid": null, "tankid": null, "parentglobalid": null, "contractor_name": null, "contractor_contact": null, "contractor_phone": null, "equip_related": null, "release_status_dt": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 47, "name": "customers", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 8, "name": "LARA_SDE.LARA_ADMIN.facilities", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GlobalID", "composite": false, "catalogID": "{A4C39B8C-4908-4D51-BC6F-E93A966A0682}" }, { "id": 5, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "GlobalID", "composite": false, "catalogID": "{34A8F938-8CB5-4CC3-A6B8-A46E058D441C}" }, { "id": 4, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "GlobalID", "composite": false, "catalogID": "{477C628B-5DA7-4CA0-9EA1-77D50BDEB695}" }, { "id": 6, "name": "LARA_SDE.LARA_ADMIN.tanks", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "GlobalID", "composite": false, "catalogID": "{8B1F6796-A9E2-4714-9BAC-EFF415C02F09}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1720691981000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "comp_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "comp_name", "type": "esriFieldTypeString", "alias": "Company Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "comp_name" }, { "name": "first_name", "type": "esriFieldTypeString", "alias": "First Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "first_name" }, { "name": "last_name", "type": "esriFieldTypeString", "alias": "Last Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "last_name" }, { "name": "address1", "type": "esriFieldTypeString", "alias": "Address 1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "address1" }, { "name": "address2", "type": "esriFieldTypeString", "alias": "Address 2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "address2" }, { "name": "city", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "city" }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "state" }, { "name": "zip_code", "type": "esriFieldTypeString", "alias": "Zip Code", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "zip_code" }, { "name": "email", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "email" }, { "name": "phone", "type": "esriFieldTypeString", "alias": "Phone", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "phone" }, { "name": "title", "type": "esriFieldTypeString", "alias": "Job Title", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "title" }, { "name": "middle_name", "type": "esriFieldTypeString", "alias": "Middle Name", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "middle_name" }, { "name": "suffix", "type": "esriFieldTypeString", "alias": "Suffix", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "suffix" }, { "name": "trade_name", "type": "esriFieldTypeString", "alias": "Trade Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "trade_name" }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "Activity ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "parentglobalid" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "customers", "description": "", "prototype": { "attributes": { "trade_name": null, "suffix": null, "parentglobalid": null, "comp_name": null, "first_name": null, "last_name": null, "address1": null, "address2": null, "city": null, "state": null, "zip_code": null, "email": null, "phone": null, "title": null, "middle_name": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }