Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Solr: Handling different CRS types in the table "record" in the database #23

Open
eliyabuyukkaya opened this issue Dec 16, 2024 · 3 comments
Open

Solr: Handling different CRS types in the table "record" in the database #23

eliyabuyukkaya opened this issue Dec 16, 2024 · 3 comments
Assignees
@pvgenuchten

Comments

@eliyabuyukkaya
Copy link

Below is the list of existing CRS types in the record table.
How to determine source EPSG in order to transform the geometry to EPSG:4326?

crs count
urn:ogc:def:crs:EPSG::4326 1025
urn:ogc:def:crs:EPSG:4326 553
WGS 1984 129
EPSG:3035 116
EPSG:32637 - WGS 74
WGS84/UTM32 46
urn:ogc:def:crs:EPSG::4647 44
+proj=igh +datum=WGS84 +no_defs +towgs84=0,0,0 41
urn:ogc:def:crs:EPSG:25832 41
+proj=laea +lat_0=5 +lon_0=20 +x_0=0 +y_0=0 +datum=WGS84 +units=m +no_defs 35
RDN2008-TM33NE 33
RDN2008/UTM zone 32N 31
EPSG:32736 - WGS 84 / UTM zone 36S 29
WGS84/UTM 32N 28
EPSG:4326 - WGS84 27
4326 - Geographic Coordinate System: GCS_WGS_1984 24
EPSG:32636 - WGS 23
EPSG:25833 22
ETRS89/UTM-ZONE32N 20
EPSG:4326 - WGS 1984 18
ETRS89 / UTM zone 32N 17
ED50-UTM32N 16
urn:ogc:def:crs:EPSG: 15
EPSG:32636 - WGS 84 / UTM zone 36N 14
EPSG:3034 13
EPSG:4326 13
http://www.opengis.net/def/crs/EPSG/0/3035 13
EPSG:4026 12
http://www.opengis.net/def/crs/EPSG/0/25833 12
http://www.opengis.net/def/crs/EPSG/0/4258 12
Monte-Mario-Italy1 10
EPSG:31370 9
EPSG:32628 - WGS 84 / UTM zone 28N 9
EPSG:32644 - WGS 84 / UTM zone 44N 9
EPSG:4326 - WGS 84 9
EPSG:32736 - WGS 8
http://www.opengis.net/def/crs/EPSG/0/25832 8
Monte Mario / TM Emilia-Romagna 8
EPSG:32630 - WGS 7
ETRS89/UTM-zone33N 7
EPSG:25832 6
EPSG 25832: ETRS89 / UTM Zone 32N 6
EPSG:31466 6
EPSG:3765 6
EPSG:25830 (ETRS89 UTM Huso 30 N) 5
EPSG:4258 (ETRS89 coordenadas geográficas) 5
ETRS89 / ETRS-TM32 5
European Terrestrial Reference System 1989 - Geodetic Reference System 1980 (ETRS89-GRS80) 5
WGS 1984 - Geographic 5
EPSG:4258 4
GCS_WGS_1984 4
http://www.opengis.net/def/crs/EPSG/0/2169 4
http://www.opengis.net/def/crs/EPSG/0/3006 4
urn:ogc:def:crs:EPSG::25832 4
urn:ogc:def:crs:EPSG::3763 4
WGS84 4
EPSG:21781 3
EPSG 31467: DHDN / Gauss-Krüger Zone 3 3
EPSG:32637 - WGS 84 / UTM zone 37N 3
EPSG:3857 3
Geographic Coordinate System: GCS_WGS_1984 3
urn:ogc:def:crs:EPSG::3061 3
urn:ogc:def:crs:EPSG:7.1:4258 3
CH1903+ (LV95) 2
EPSG:2056 2
EPSG 25833: ETRS89 / UTM Zone 33N 2
EPSG:31468 2
EPSG:32630 - WGS 84 / UTM zone 30N 2
EPSG 5650: ETRS89 / UTM Zone 33N (zE-N) 2
EPSG Projection 4326 - WGS 84 2
ETRS89 (EPSG:4258) 2
ETRS89 / GK25FIN (EPSG:3879) 2
Lambert Azimuthal Projection 2
RDN2008-TM32EN 2
urn:ogc:def:crs:EPSG::25833 2
urn:ogc:def:crs:EPSG::3057 2
4326 - Geographic projection - WGS 1984 1
EPSG:3067 1
EPSG:31467 1
EPSG 31468: DHDN / Gauss-Krüger Zone 4 1
EPSG:32625 1
EPSG:3879 1
EPSG:5514 1
ETRS89/ETRS-TM32 1
ETRS89 (geographic 2D) 1
ETRS89 / UTM zone 32N (EPSG:25832) 1
GCS_WGS84 1
Geographic Projection 1
http://www.opengis.net/def/crs/EPSG/0/21782 1
http://www.opengis.net/def/crs/EPSG/0/31287 1
http://www.opengis.net/def/crs/EPSG/0/31466 1
http://www.opengis.net/def/crs/EPSG/0/31700 1
http://www.opengis.net/def/crs/EPSG/0/3844 1
http://www.opengis.net/def/crs/EPSG/0/3912 1
Projection: Hammer Haitoff 1
RD_New (28992) 1
Rijks Driehoeksstelsel 1
ROMA40/OVEST 1
ROMA40/ROMA 1
urn:ogc:def:crs:EEA:1.0:777101 1
urn:ogc:def:crs:EPSG::28992 1
urn:ogc:def:crs:EPSG::31466 1
urn:ogc:def:crs:EPSG:31467 1
urn:ogc:def:crs:EPSG::31467 1
urn:ogc:def:crs:EPSG::32625 1
urn:ogc:def:crs:EPSG::32736 1
urn:ogc:def:crs:EPSG:7.1:32631 1
urn:ogc:def:crs:EPSG:7.1:32636 1
urn:ogc:def:crs:EPSG::84 1
WGS84 ZoneUTM35N 1
@pvgenuchten
Copy link

pvgenuchten commented Dec 16, 2024 •
edited
Loading

Nice work! Suggestion would be to transform using existing crs definition, if failing, forget about geometry

consider that all wgs84, 4326 alikes don’t need a transformation

@eliyabuyukkaya
Copy link
Author

I have created such a table for now:

crs epsg likely
urn:ogc:def:crs:EEA:1.0:777101 3035
+proj=igh +datum=WGS84 +no_defs +towgs84=0,0,0 54029
+proj=laea +lat_0=5 +lon_0=20 +x_0=0 +y_0=0 +datum=WGS84 +units=m +no_defs
Projection: Hammer Haitoff 54044
EPSG:32736 - WGS 84 / UTM zone 36S 32736
EPSG:32736 - WGS 32736
urn:ogc:def:crs:EPSG::32736 32736
EPSG:32644 - WGS 84 / UTM zone 44N 32644
EPSG:32637 - WGS 32637
EPSG:32637 - WGS 84 / UTM zone 37N 32637
EPSG:32636 - WGS 84 / UTM zone 36N 32636
EPSG:32636 - WGS 32636
urn:ogc:def:crs:EPSG:7.1:32636 32636
WGS84 ZoneUTM35N 32635
WGS84/UTM 32N 32632
WGS84/UTM32 32632
urn:ogc:def:crs:EPSG:7.1:32631 32631
EPSG:32630 - WGS 84 / UTM zone 30N 32630
EPSG:32630 - WGS 32630
EPSG:32628 - WGS 84 / UTM zone 28N 32628
EPSG:32625 32625
urn:ogc:def:crs:EPSG::32625 32625
http://www.opengis.net/def/crs/EPSG/0/31700 31700
EPSG:31468 31468
EPSG 31468: DHDN / Gauss-Krüger Zone 4 31468
urn:ogc:def:crs:EPSG::31467 31467
EPSG 31467: DHDN / Gauss-Krüger Zone 3 31467
EPSG:31467 31467
urn:ogc:def:crs:EPSG:31467 31467
http://www.opengis.net/def/crs/EPSG/0/31466 31466
urn:ogc:def:crs:EPSG::31466 31466
EPSG:31466 31466
EPSG:31370 31370
http://www.opengis.net/def/crs/EPSG/0/31287 31287
urn:ogc:def:crs:EPSG::28992 28992
Rijks Driehoeksstelsel 28992
RD_New (28992) 28992
ROMA40/ROMA 26591
Monte-Mario-Italy1 26591
ETRS89/UTM-zone33N 25833
EPSG:25833 25833
EPSG 25833: ETRS89 / UTM Zone 33N 25833
urn:ogc:def:crs:EPSG::25833 25833
http://www.opengis.net/def/crs/EPSG/0/25833 25833
ETRS89/UTM-ZONE32N 25832
EPSG 25832: ETRS89 / UTM Zone 32N 25832
EPSG:25832 25832
ETRS89 / UTM zone 32N 25832
ETRS89 / UTM zone 32N (EPSG:25832) 25832
http://www.opengis.net/def/crs/EPSG/0/25832 25832
urn:ogc:def:crs:EPSG:25832 25832
urn:ogc:def:crs:EPSG::25832 25832
EPSG:25830 (ETRS89 UTM Huso 30 N) 25830
ED50-UTM32N 23032
http://www.opengis.net/def/crs/EPSG/0/21782 21782
EPSG:21781 21781
RDN2008-TM33NE 6708
RDN2008-TM32EN 6706
RDN2008/UTM zone 32N 6706
EPSG 5650: ETRS89 / UTM Zone 33N (zE-N) 5650
EPSG:5514 5514
urn:ogc:def:crs:EPSG::4647 4647
EPSG:4326 4326
4326 - Geographic projection - WGS 1984 4326
urn:ogc:def:crs:EPSG::4326 4326
GCS_WGS84 4326
GCS_WGS_1984 4326
Geographic Coordinate System: GCS_WGS_1984 4326
Geographic Projection 4326
4326 - Geographic Coordinate System: GCS_WGS_1984 4326
EPSG:4326 - WGS84 4326
EPSG:4326 - WGS 84 4326
EPSG:4326 - WGS 1984 4326
WGS 1984 4326
urn:ogc:def:crs:EPSG:4326 4326
EPSG Projection 4326 - WGS 84 4326
urn:ogc:def:crs:EPSG::84 4326
WGS 1984 - Geographic 4326
WGS84 4326
ETRS89 (geographic 2D) 4258
EPSG:4258 4258
EPSG:4258 (ETRS89 coordenadas geográficas) 4258
urn:ogc:def:crs:EPSG:7.1:4258 4258
ETRS89 (EPSG:4258) 4258
European Terrestrial Reference System 1989 - Geodetic Reference System 1980 (ETRS89-GRS80) 4258
http://www.opengis.net/def/crs/EPSG/0/4258 4258
EPSG:4026 4026
http://www.opengis.net/def/crs/EPSG/0/3912 3912
EPSG:3879 3879
ETRS89 / GK25FIN (EPSG:3879) 3879
EPSG:3857 3857
http://www.opengis.net/def/crs/EPSG/0/3844 3844
EPSG:3765 3765
urn:ogc:def:crs:EPSG::3763 3763
EPSG:3067 3067
urn:ogc:def:crs:EPSG::3061 3061
urn:ogc:def:crs:EPSG::3057 3057
ETRS89/ETRS-TM32 3044
ETRS89 / ETRS-TM32 3044
Lambert Azimuthal Projection 3035
http://www.opengis.net/def/crs/EPSG/0/3035 3035
EPSG:3035 3035
EPSG:3034 3034
http://www.opengis.net/def/crs/EPSG/0/3006 3006
Monte Mario / TM Emilia-Romagna 3003
ROMA40/OVEST 3003
http://www.opengis.net/def/crs/EPSG/0/2169 2169
CH1903+ (LV95) 2056
EPSG:2056 2056

@eliyabuyukkaya
Copy link
Author

There are also records with geometry data however without any crs data provided.
I am considering them as EPSG:4326?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pvgenuchten pvgenuchten

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@pvgenuchten @eliyabuyukkaya