[postgis-users] CityGML in PostGIS - 3D City Database released
felix-kunde at gmx.de
Fri Dec 21 06:48:58 PST 2012
I've never tripped over this kind of error before. It looks pretty clear:
The substitution variable for your second input parameter could not be
interpreted. Take a look in CREATE_DB.sql in a text editor. Line 50:
INSERT INTO DATABASE_SRS(SRID,GML_SRS_NAME) VALUES (:SRS_NO,:'GMLSRSNAME');
SRS_NO and GMLSRSNAME are variables defined by your prompt inputs. By using
colons (:) the variables should be replaced by the values you've entered.
In the error message you can see, that this happened for SRS_NO but not for
GMLSRSNAME. I'm sorry, I can't help you with this one. It always worked on
german and english machines. I don't know if the error is caused by french
settings as the ' is interpreted differently. I asked another PostgreSQL
board but got no answer yet. I let you know if I got any news.
Alternatively you can change the file by hardcoding Line 50 to e.g.
INSERT INTO DATABASE_SRS(SRID,GML_SRS_NAME) VALUES (:SRS_NO,'someText');
In fact the value for GML_SRS_NAME is not a mandatory one. It was not my
idea. I've just ported it that way to the PostGIS version.
> -------- Original-Nachricht --------
> Datum: Wed, 19 Dec 2012 11:52:25 -0800 (PST)
> Von: babou <hiba.maalaoui at gmail.com>
> An: postgis-users at postgis.refractions.net
> Betreff: Re: [postgis-users] CityGML in PostGIS - 3D City Database
> thank you Felix, I used SRID 3068 Berlin just to test access to the
> via the tools Import / export for a CityGML file.
> I'm currently working with PostGIS 2.0, I have only the table
> spatial_ref_sys public in my public schema.
> But now a syntax error is displayed despite I used the same syntax used
> the tutorial (Please enter a valid SRID: 3068 urn: ogc: def: crs, crs:
> 6.12:3068, crs: EPSG: 6.12:5783)
> and this error is repeated with any SRID entered.
> View this message in context:
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users