Skip to content

Database Model

davidheyman edited this page Oct 27, 2014 · 2 revisions

Tables

Name Description
baseline Primary line features used to draw basemap
basepoint Primary point features used to draw basemap
basepoly Primary polygon features used to draw basemap
cache Record of every tile created by Mapnik and uploaded to S3
details Additional table of attributes used in data probe
legend Layer hierarchy, styling, and id used to build layer list
names Table to convert table attributes into English and Portuguese
plannedline Line features used to draw plans
plannedpoly Polygon features used to draw plans
spatial_ref_sys PostGIS system table containing projections
uploads Table documenting the date of each upload
visualpoly Table storing information on viewshed points and maps / plans
Clone this wiki locally