Comments (7)
All right, the problem seems to be resolved.
The issue was not coming from SRID but from H2GIS version.
In NM v4.0.2 we are using H2GIS v2.1.120 while the H2GIS web client is based on v2.1.214
So with @nicolas-f we updated (manually) the NM version to v2.1.214 and it works ! We will have to update the release ...
from h2gis.
One of the two PRJ file was not recognized
The error was:
Values of types "GEOMETRY(MULTIPOLYGON, 0)" and "GEOMETRY(MULTIPOLYGON Z, 2154)" are not comparable; SQL statement:
CREATE TABLE pblm_intersection AS SELECT st_intersection(a.THE_GEOM, b.THE_GEOM) AS THE_GEOM
FROM RAIL_BUFF_D4 a, PBLM_Z1 b
WHERE a.THE_GEOM && b.the_geom AND st_intersects(a.THE_GEOM , b.THE_GEOM) [90110-214] 90110/90110 [(Aide)](https://h2database.com/javadoc/org/h2/api/ErrorCode.html#c90110)
org.h2.jdbc.JdbcSQLSyntaxErrorException: Values of types "GEOMETRY(MULTIPOLYGON, 0)" and "GEOMETRY(MULTIPOLYGON Z, 2154)" are not comparable; SQL statement:
CREATE TABLE pblm_intersection AS SELECT st_intersection(a.THE_GEOM, b.THE_GEOM) AS THE_GEOM
FROM RAIL_BUFF_D4 a, PBLM_Z1 b
from h2gis.
I don't know if it is related but
H2GIS 2.2 use CTS 1.7 but NoiseModelling 4.0.2 use CTS 1.6
from h2gis.
Hum, it's on the export, but in my db, both are in 2154
Don't mind with the table name which is different
from h2gis.
The PRJ file RAIL_BUFF_D4 doesn't contain any EPSG code so H2GIS is not able to find a SRID.
from h2gis.
Thanks Erwan. I reupladed the files here : data_pblm.zip
The PRJ are the same. But the problem remains in H2GIS db.
@nicolas-f just told me that the problem is resolved if I use H2GIS clien (https://github.com/orbisgis/h2gis/releases/download/v2.2.0/h2gis-2.2.0-bin.zip) instead of the NM db. So I will try
from h2gis.
ok super ;-)
from h2gis.
Related Issues (20)
- Import shapefile error with .prj HOT 1
- JTS OverlayNG HOT 1
- Add ST_Project HOT 2
- ST_OSMDownloader HOT 1
- Add ESRI proj definitions to SPATIAL_REF_SYS table HOT 1
- Support options on FILE_TABLE HOT 2
- Dependency org.postgresql:postgresql, leading to CVE problem
- ST_Tessellate empty geometry
- Error transformation from SRID 2100 to 4326 HOT 2
- Update H2GIS with H2 2.2.220 HOT 2
- Check createDDL for DECFLOAT
- Update to H2 2.2.222 HOT 4
- st_union with GROUP BY doesn't work HOT 1
- TopoJson driver
- GeoJSON driver read regression HOT 2
- H2GISFunctions assumes that PUBLIC is the active schema HOT 5
- Trouble reading SHP file HOT 5
- Read and Write CPG file for dbf string encoding HOT 3
- Manage SRID on empty geometry HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from h2gis.