Stand list query

process

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

decide on size classes

CALC_DBH_CLASS: 
IIF(DBH_IN < 2, 0, 
	IIF( [DBH_IN] >= 50, 50, 
		(Int(([DBH_IN]-2)/4)*4) + 2
	))

TODO

• 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...