Revision 11781
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.geoscrub/geoscrub_output/geoscrub.csv.run | ||
|---|---|---|
| 7 | 7 |
|
| 8 | 8 |
export_() # usage: rm=1 .../self.run export_ |
| 9 | 9 |
{
|
| 10 |
echo_func; require_remote
|
|
| 10 |
echo_func |
|
| 11 | 11 |
local_export database=geoscrub table=geoscrub \ |
| 12 | 12 |
cols='decimallatitude,decimallongitude,country,stateprovince,county,countrystd'\ |
| 13 | 13 |
',stateprovincestd,countystd,latlonvalidity,countryvalidity,'\ |
| 14 | 14 |
'stateprovincevalidity,countyvalidity' # str b/c env vars don't support arrays |
| 15 |
to_top_file pg_as_root pg_export # runtime: 30 s ("0m30.352s")
|
|
| 15 |
to_top_file pg_export # runtime: 30 s ("0m30.352s")
|
|
| 16 | 16 |
} |
| 17 | 17 |
|
| 18 | 18 |
make() # usage: rm=1 .../self.run make |
Also available in: Unified diff
inputs/.geoscrub/geoscrub_output/geoscrub.csv.run: don't connect to DB as the root user, because this is not needed now that the geoscrub schema is owned by the bien user. this avoids a sudo password prompt at the end of the geoscrubbing run.