Hi all,
I am trying to check my data against epsg 25832.
Following the steps:
1. get bounds of epsg:25832 in lon, lat (https://epsg.io/25832) -->
(-16.1 32.88) (39.65 84.17)
2. calculate bbox: select
st_astext(st_envelope(st_geometryfromtext('LINESTRING(-16.1 32.88, 39.65
84.17 )', 4326))) --> POLYGON((-16.1 32.88,-16.1 84.17,39.65 84.17,39.65
32.88,-16.1 32.88))
3. count point outside: select count(*) from table_lines where not
ST_Intersects(st_transform(geom, 4326), st_geometryfromtext('POLYGON((-16.1
32.88,-16.1 84.17,39.65 84.17,39.65 32.88,-16.1 32.88))', 4326)) --> 0
I have executed the check also using epsg:3857:
select count(*) from sinfidb_history.infr_rt_estensione_p where not
ST_Contains(st_transform(st_geometryfromtext('POLYGON((-16.1 32.88,-16.1
84.17,39.65 84.17,39.65 32.88,-16.1 32.88))', 4326), 3857),
st_transform(geom, 3857))
with same result.
So, do you think there is a better way to make this check?
Matteo Cusmai
On Sat, Oct 28, 2017 at 9:26 PM, Andrea Aime <[email protected]>
wrote:
>
>
> Il 28 ott 2017 8:14 PM, "Matteo Cusmai" <[email protected]> ha
> scritto:
>
> So, the most probable cause of this error is the presence of data on the
> boundary of the epsg, isn't it?
>
>
> At the border... Not really, I'd say really outside. But we are going in
> circles here... Can you use another tool to just query the data?
>
> Also, which version of GeoServer are you using?
>
> Cheers
> Andrea
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
