Timeline for spatialite geometry vs PostGIS geography
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 30, 2017 at 9:23 | history | tweeted | twitter.com/StackGIS/status/947035414002589696 | ||
| Dec 28, 2017 at 16:05 | vote | accept | user1244932 | ||
| Dec 28, 2017 at 14:05 | history | edited | user1244932 | CC BY-SA 3.0 |
added 4 characters in body
|
| Dec 28, 2017 at 14:01 | answer | added | user30184 | timeline score: 5 | |
| Dec 28, 2017 at 12:42 | history | edited | user1244932 | CC BY-SA 3.0 |
lat lon -> lon lat
|
| Dec 28, 2017 at 9:50 | comment | added | user1244932 |
@LennertDeFeyter and st_dwithin for geography type take distance_meters not in degrees, see postgis.net/docs/ST_DWithin.html
|
|
| Dec 28, 2017 at 9:47 | comment | added | user1244932 |
@LennertDeFeyter Why it is not in poly? 50 < 51 < 53 and longitude -179.5 lay between -179 and 179
|
|
| Dec 28, 2017 at 9:42 | comment | added | Lennert De Feyter | The st_dwithin you specified is true if the point is within 1 degree of the poly. Which is true. But it isn't inside the poly, which you are checking in spatialite. | |
| Dec 28, 2017 at 9:30 | comment | added | user1244932 | @Vince I add sql quires to make my question is more clear. | |
| Dec 28, 2017 at 9:30 | history | edited | user1244932 | CC BY-SA 3.0 |
added 826 characters in body; edited tags
|
| Dec 27, 2017 at 12:26 | comment | added | Vince | Please Edit the question to include what you have tried, and what error(s) you have encountered. "Will this product work for me?" is quite broad and may be dependent on what exactly you are doing. | |
| Dec 27, 2017 at 12:20 | history | edited | Vince | CC BY-SA 3.0 |
English usage; naming
|
| Dec 27, 2017 at 10:56 | review | First posts | |||
| Dec 27, 2017 at 11:00 | |||||
| Dec 27, 2017 at 10:49 | history | asked | user1244932 | CC BY-SA 3.0 |