meta user
network profile
| bio | website | uk.linkedin.com/in/… |
|---|---|---|
| location | London, United Kingdom | |
| age | 27 | |
| visits | member for | 10 months |
| seen | Oct 5 '12 at 14:21 | |
| stats | profile views | 9 |
|
Sep 27 |
awarded | Tumbleweed |
|
Sep 20 |
asked | QuantumGIS or Matlab package for distribution- or density-based clustering |
|
Jul 26 |
comment |
PostGIS: ST_Transform function conversion problem @CHenderson I'm getting a lot more than 10m+ error. I think that it must be some bug related to the ST_Transform function. My suggestion is to keep the question open for a while to see if anybody else has encountered the same problem, and if not let's close it down. Do you know where I can report the bug? |
|
Jul 25 |
comment |
PostGIS: ST_Transform function conversion problem What I did in the end was to convert the other layer into EPSG:27700 (it's a shape file that I import in PostGIS using the shp2pgsql tool), and to import the GML without transforming the geometry to a different spatial reference system. It then worked as expected, but I would really like to understand what went wrong in the first case. |
|
Jul 25 |
comment |
PostGIS: ST_Transform function conversion problem @CHenderson I double-checked it and the srid is definitely correct. |
|
Jul 25 |
comment |
PostGIS: ST_Transform function conversion problem @Micha Sounds strange, I keep on getting it wrong. Thanks for trying it out! |
|
Jul 23 |
revised |
Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS added 15 characters in body |
|
Jul 23 |
asked | PostGIS: ST_Transform function conversion problem |
|
Jul 22 |
awarded | Student |
|
Jul 22 |
revised |
Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS added 383 characters in body |
|
Jul 22 |
comment |
Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS Cool, thanks, I have PostGIS 1.5.3 installed at the moment. |
|
Jul 22 |
comment |
Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS I'm getting an error: SELECT ST_GeomFromGML('<gml:Point srsName="osgb:BNG"><gml:coordinates>527347.0,181346.0</gml:coordinates></gml:Point>', 27700);
ERROR: function st_geomfromgml(unknown, integer) does not exist
LINE 1: SELECT ST_GeomFromGML('<gml:Point srsName><gml:coordinates>5...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts. Any ideas? |
|
Jul 22 |
comment |
Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS Many thanks for the help! |
|
Jul 22 |
awarded | Scholar |
|
Jul 22 |
accepted | Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS |
|
Jul 22 |
comment |
Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS Thanks for the quick answer! What if I simply replaced "osgb:BNG" with "EPSG:27700" http://spatialreference.org/ref/epsg/27700/ in the GML file? Would that work too? |
|
Jul 22 |
awarded | Editor |
|
Jul 22 |
revised |
Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS added 2 characters in body |
|
Jul 22 |
comment |
Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS The code block isn't displayed correctly: # SELECT ST_GeomFromGML('<gml:Point srsName="osgb:BNG"><gml:coordinates>527347.0,181346.0</gml:coordinates></gml:Point>'); ERROR: unknown spatial reference system |
|
Jul 22 |
asked | Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS |
