Project

General

Profile

Actions

Bug #1977

closed

need to add parent of namedplace in that table.

Added by Michael Lee about 19 years ago. Updated about 19 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
db_design
Target version:
Start date:
02/10/2005
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
1977

Description

and then be able to fill in parents for places. Probably add a new field for
"completely" within the parent, as quads are not completely in their states, nor
are they necessarily in the country

Actions #1

Updated by Michael Lee about 19 years ago

also add some more denormalized fields to plot. Need to backfill states and
countries where possible from other places. Need to decide how to deal with
Lat/Long plots that have no specific place names.

Actions #2

Updated by Michael Lee about 19 years ago

new namedplaceCorrelation added on aldo. Need to test that its addition doesn't
pose problems for compile of java beans, etc. (full redeploy there needed).
Then need to populate this table with SQL from /src/sql/throwaways.

Still need to reduce the duplicated quadrangles that cross state lines into
single quadrangles and adjust how VegBranch looks for these. And add the new
table to VegBranch.

Actions #3

Updated by Michael Lee about 19 years ago

done! Just need to run the sql script when we rebuild vegbank. Reminder is
listed in the wiki page for rebuilding vegbank.org

Actions #4

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 1977

Actions

Also available in: Atom PDF