-
Notifications
You must be signed in to change notification settings - Fork 11
Stand list query
perrygeo edited this page Jan 24, 2013
·
2 revisions
Run Make_Qry_MP_BASE Run Make_Qry_MP_BASE_TREESUMMARY > Tbl_MP_BASE_TREESUMMARY (which becomes IDB_SUMMARY) use idb_import process
Run Make_Qry_MP_TREELIVE_SUMMARY Run Make_Qry_MP_FINAL_TREELIVE_SUMMARY > Tbl_MP_FINAL_TREELIVE_SUMMARY (which becomes TREELIVE_SUMMARY) a) pivoted method: run create_pivot.py and stuff crosstab in a db b) unpivoted: load flat table into postgres using load.sh and run query_stand_list.py
CALC_DBH_CLASS:
IIF(DBH_IN < 2, 0,
IIF( [DBH_IN] >= 50, 50,
(Int(([DBH_IN]-2)/4)*4) + 2
))
-
document unpivoted method
-
get the stand list filter from TREELIVE_SUMMARY + base query from IDBSUMMARY joined in query_stand_list.py
-
integrate query_stand_list.py with NN
-
build stand list input interface to test
- filtering ... show all candidates and stand lists for each
- select geography
- show details on top match
-
error handling
-
etc...