Add new site programmatically

[dlebauer]

There is a script in the BETYdb repository (buildSQLGeom.py) that will take a csv of latitude, longitude, elevation and insert it into BETYdb. This works when manually entering rectangles.

I had previously written some code and wrapped it into a function so that I could do this from within R, using R data frames and some of the existing map data sets. The specific use case was to define the boundaries of states and counties.

I wasn't sure if this was redundant, but I wanted to post this issue with [code as a gist](https://gist.github.com/dlebauer/8854c1fb4ae5e2406ad1e7f422fad23c_

Is there currently a need for such a function? Otherwise, we can revisit this when it comes up.

• Related to #482 which inserts sites from web interface
• PecanProject/bety#367 that was closed by creation of script buildSQLGeom.py

[mdietze]

Sounds very relevant.

So I don't see how the py script works within bety. If I go to sites/new I don't see anywhere to upload a csv file of points

As far as I know #482 is still in progress, but I haven't gotten an update from @ch1eroe1 in a long time.

Since this is related to inserting things in the database, it would go in the db module.

[github-actions[bot]]

This issue is stale because it has been open 365 days with no activity.