美国地质调查局提供的LC8卫星图像数据解析

需积分: 50 7 下载量 142 浏览量 更新于2024-09-04 收藏 8KB TXT 举报
"LC08_L1TP_122042_20180417_20180501_01_T1_MTL.txt" 是一个 Landsat 8 遥感图像的元数据文件,源自美国地质调查局(U.S. Geological Survey)。该文件描述了2018年4月17日在江西赣州拍摄的卫星图像,具有低云覆盖,可用ENVI软件进行处理。提供者愿意分享ENVI入门教程视频和素材包,并且可以提供多年的遥感数据。 Landsat 8是美国地球观测卫星系统的一部分,配备有 Operational Land Imager (OLI) 和 Thermal Infrared Sensor (TIRS) 传感器,用于获取地表的多光谱和热红外数据。文件中的标签“遥感图像”表明这是一次关于地球表面的远程探测数据。 元数据文件详细列出了图像的各种信息: 1. **LANDSAT_SCENE_ID** 和 **LANDSAT_PRODUCT_ID**:这两个标识符指定了特定的Landsat 8影像,这里是"LC81220422018107LGN00"和"LC08_L1TP_122042_20180417_20180501_01_T1",后者包含了路径、行号、采集日期和产品类型。 2. **COLLECTION_NUMBER** 和 **COLLECTION_CATEGORY**:“01”表示数据集的版本,"T1"表示一级标准处理,意味着数据经过了严格的几何校正和辐射校正。 3. **ELEVATION_SOURCE**:“GLS2000”指明了地形高程数据的来源,即全球陆地表面2000(Global Land Surface 2000)。 4. **OUTPUT_FORMAT**:“GEOTIFF”说明了图像的输出格式,GeoTIFF是一种地理标记的TIFF图像格式,包含有空间参考信息。 5. **SPACECRAFT_ID** 和 **SENSOR_ID**:“LANDSAT_8”和"OLI_TIRS"表明数据来自Landsat 8卫星的OLI和TIRS传感器。 6. **WRS_PATH** 和 **WRS_ROW**:122和42是World Reference System的路径和行号,用于定位卫星图像在全局网格中的位置。 7. **DATE_ACQUIRED** 和 **SCENE_CENTER_TIME**:图像采集日期为2018年4月17日,中心时间是格林尼治标准时间的02:50:36.9524270。 8. **CORNER_*** 系列参数提供了图像四个角的经纬度坐标和投影坐标,用于构建图像的空间参考框架。 通过这些元数据,用户可以准确地知道图像的地理覆盖范围、采集时间、数据质量和处理级别,从而有效地进行地球表面的分析和研究,如环境监测、气候变化分析、土地覆盖变化检测等。结合ENVI软件,可以进一步对遥感图像进行影像解译、分类、目标检测等高级处理。

优化以下Oracle语句: SELECT SUBSTR(msn.serial_number, 1, 10) genset_sn, msi2.segment1 Genset_BOM_NUM, msi2.inventory_item_id, msi.segment1 key_component, mut1.serial_number component_sn, msi.description component_desc, wdj.date_completed, (SELECT MAX(aps.vendor_name) FROM ap_suppliers aps, bom_resources bor, mtl_unit_transactions mut, po_headers_all poh, po_lines_all pol, wip_osp_resources_val_v wor WHERE aps.vendor_id = poh.vendor_id AND bor.resource_id = wor.resource_id AND poh.po_header_id = pol.po_header_id AND pol.item_id = bor.purchase_item_id AND wor.wip_entity_id = mut.transaction_source_id AND mut.serial_number = mut1.serial_number AND mut.inventory_item_id = mut1.inventory_item_id AND mut.organization_id = mut1.organization_id AND mut.receipt_issue_type = 2 AND mut.transaction_source_type_id = 5 ) supplier FROM mtl_material_transactions mmt1, mtl_material_transactions mmt2, mtl_parameters mpa, mtl_serial_numbers msn, mtl_system_items msi, mtl_system_items msi2, mtl_transaction_types mtt1, mtl_transaction_types mtt2, mtl_unit_transactions mut1, mtl_unit_transactions mut2, wip_discrete_jobs_v wdj WHERE mmt1.inventory_item_id = mut1.inventory_item_id AND mmt1.organization_id = mut1.organization_id AND WDJ.PRIMARY_ITEM_ID = msi2.INVENTORY_ITEM_ID AND mmt1.transaction_id = mut1.transaction_id AND mmt1.transaction_source_id = wdj.wip_entity_id AND mmt1.transaction_type_id = mtt1.transaction_type_id AND mtt1.transaction_type_name = 'WIP Issue' AND NOT EXISTS (SELECT 'WIP Negative Issue or WIP Return' FROM mtl_material_transactions mmt3, mtl_transaction_types mtt3, mtl_unit_transactions mut3 WHERE mmt3.transaction_id = mut3.transaction_id AND mmt3.transaction_type_id = mtt3.transaction_type_id AND mmt3.transaction_date > mmt1.transaction_date AND mtt3.transaction_type_name IN ('WIP Negative Issue', 'WIP Return') AND mut3.serial_number = mut1.serial_number AND mut3.inventory_item_id = mut1.inventory_item_id) AND mmt2.transaction_id = mut2.transaction_id AND mmt2.transaction_source_id = wdj.wip_entity_id AND mmt2.transaction_type_id = mtt2.transaction_type_id AND mtt2.transaction_type_name = 'WIP Completion' AND mpa.organization_code = 'WHP' AND msn.current_organization_id = mpa.organization_id AND LENGTH(msn.serial_number) >= 10 AND msi.inventory_item_id = mmt1.inventory_item_id AND msi.organization_id = mmt1.organization_id AND (msi.planning_make_buy_code = 2 OR msi.segment1 LIKE 'SO%') AND mut2.serial_number = msn.serial_number AND mut2.inventory_item_id = msn.inventory_item_id AND mut2.organization_id = mpa.organization_id AND msi2.ORGANIZATION_ID = '323'

2023-07-15 上传

优化sql:SELECT we.organization_id ,we.wip_entity_id ,case when wl.line_id is null then we.wip_entity_name else '' end wip_entity_name ,we.primary_item_id ,mtt.transaction_type_name ,mmt.transaction_date ,bd.department_code ,mmt.inventory_item_id ,mmt.subinventory_code ,mta.reference_account ,br.resource_code ,lu2.meaning as line_type_name ,mta.base_transaction_value ,mta.cost_element_id ,flv.meaning as cost_element ,wdj.class_code job_type_code ,ml.meaning job_type_name FROM (select * from gerp.mtl_material_transactions where substr(transaction_date,1,7) >= '2023-06' and transaction_source_type_id = 5) mmt inner join gerp.wip_entities we on mmt.organization_id = we.organization_id inner join gerp.mtl_transaction_accounts mta on mta.transaction_source_id = we.wip_entity_id and mta.transaction_id = mmt.transaction_id and mta.transaction_source_type_id = 5 inner join gerp.mtl_transaction_types mtt on mtt.transaction_type_id = mmt.transaction_type_id inner join mfg_lookups lu2 on lu2.lookup_code = mta.accounting_line_type and lu2.lookup_type = 'CST_ACCOUNTING_LINE_TYPE' inner join gerp.mtl_system_items_b msi on msi.inventory_item_id = mmt.inventory_item_id and msi.organization_id = mta.organization_id left join gerp.bom_departments bd on bd.department_id = mmt.department_id left join gerp.bom_resources br on br.resource_id = mta.resource_id left join gerp.wip_lines wl on wl.line_id = mmt.repetitive_line_id left join gerp.wip_discrete_jobs wdj on wdj.wip_entity_id = mta.transaction_source_id left join gerp.fnd_lookup_values_vl flv on cast(mta.cost_element_id as string) = flv.lookup_code and flv.lookup_type = 'CST_COST_CODE_TYPE' left join mfg_lookups ml on ml.lookup_code = wdj.job_type and ml.lookup_type = 'WIP_DISCRETE_JOB' 。其中mmt,we,mta,msi,wdj数据量很大

2023-06-10 上传