Timeline for Adding coordinates to table (forcing 1:1 association without unique identifiers on either side)
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 22, 2017 at 23:54 | comment | added | Faydey | The database I have is postgis enabled. Like i said, i have around 80 million rows that identify the census tract (by ID), but they don't have the tract geometry. I must stress I'm not an SQL professional, I just know how to put together a query. Centroid is not really useful in this case, as i'll be plotting the dots on a map. (trust me, it makes sense in my context.) | |
| Dec 22, 2017 at 22:36 | history | answered | Evan Carroll | CC BY-SA 3.0 |