A collection of all the SQL views, functions, and data types used by Landsat FACT.
- All functions
- add_function
- delete_user_aoi_by_nid
- edit_function
- get_acres_aoi_alert_subscription
- get_acres_from_geojson
- get_aoi_id_by_nodeid
- get_completedcustomrequests
- get_countyByGeoid
- get_customrequest_status_bynode
- get_customrequest_status_byuser
- get_customRequestQue_by_aoi_id
- get_customRequestQue_by_node_id
- get_customRequestsQuads
- get_customRequestURLByNodeId
- get_pendingCustomRequests
- get_processCompleteCustomRequests
- get_scenesAlternate
- get_scenesMostRecent
- get_statusByAoiId
- initiate_custom_request
- insert_alert_aoi
- insert_aoi_alert_subscription
- insert_custom_request_scenes
- insert_user_aoi_by_county
- insert_user_aoi_by_geojson
- is_validSceneIntersects
- keys_and_values
- remove_aoi_alert_subscription
- update_custom_request_status
- update_user_aoi_by_county
- update_user_aoi_by_geojson
- write_aoi_events
- All views
- vw_aoi_alerts
- vw_archive_product_dates
- vw_custom_requests_for_viewer
- vw_custom_request_tile_index_cloud
- vw_custom_request_tile_index_gap
- vw_custom_request_tile_index_ndmi
- vw_custom_request_tile_index_ndvi
- vw_custom_request_tile_index_swir
- vw_customrequets_all_status
- vw_customrequets_hung
- vw_failed_dn
- vw_failed_l1metadata
- vw_failed_lcv_quads
- vw_failed_products
- vw_download_scenes
- vw_last_days_products
- vw_last_days_scenes
- vw_missed_lcv
- vw_quad_latest_update
- vw_quad_lc_history
- vw_quilt
- vw_reclass_products
- vw_scenes_less_five
- vw_tile_index_cloud
- vw_tile_index_customrequest
- vw_tile_index_gap
- vw_tile_index_ndmi
- vw_tile_index_ndvi
- vw_tile_index_swir
- vw_user_notification
- vw_viewer_quad_history
- vw_viewer_quads
- vw_wms_params_for_geopdf