dlebauer
commented
4 years ago we don't need to visualize the shapefiles directly, we want to visualize the data after it has been inserted into the database. For example, to look at the map of experiments we want to test that this is valid ....
select experiments.name, sitename, st_asgeojson(geometry) as polygon from sites
join experiments_sites on sites.id = experiments_sites.site_id
join experiments on experiments.id = experiments_sites.experiment_id
where ????<find the stuff that hasn't been committed e.g. sites.created_at = just now>;similar w/ joins to treatments and cultivars
im-prakher
Created a
shape-visual.jsandgmap.jscomponent that usesreact-leafletto visualize the GeoJSON data.