Re: [OSM-dev] XAPI - Source code

2011-01-03 Thread arminus
Same error. However, I got it working now with --write-pgsql-dump and a subsequent pgsnapshot_load_0.6.sql. Your new xapi code now also returns a valid result. Great :-) cheers, Armin -- View this message in context: http://gis.638310.n2.nabble.com/API-XAPI-caching-proxy-server-tp5825779p58868

Re: [OSM-dev] XAPI - Source code

2011-01-03 Thread Ian Dees
On Mon, Jan 3, 2011 at 3:10 PM, arminus wrote: > > > This sounds as if your database isn't even a PostGIS database? > > No it wasn't :-/ I didn't realize that apparently (?) the osmosis > import I did after postgis enabling the db somehow wiped out the > postgis code in it ... At any rate, I don'

Re: [OSM-dev] XAPI - Source code

2011-01-03 Thread arminus
> This sounds as if your database isn't even a PostGIS database? No it wasn't :-/ I didn't realize that apparently (?) the osmosis import I did after postgis enabling the db somehow wiped out the postgis code in it ... At any rate, I don't get the errors on an empty db anymore, but I also fail to

Re: [OSM-dev] XAPI - Source code

2011-01-03 Thread Frederik Ramm
Hi, arminus wrote: Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [CREATE TEMPORARY TABLE bbox_nodes ON COMMIT DROP AS SELECT * FROM nodes WHERE (geom && ?)]; nested exception is org.postgresql.util.PSQLException: Unknown ty

Re: [OSM-dev] XAPI - Source code

2011-01-03 Thread Ian Dees
On Mon, Jan 3, 2011 at 10:21 AM, arminus wrote: > > @Ian: > > > The grammar that I published parses the examples on the xapi wiki page > > just > > fine. The hard part now is converting those in to SQL statements while > > maintaining speed. > > In which stage is this code presently ? I managed t

Re: [OSM-dev] XAPI - Source code

2011-01-03 Thread arminus
@Ian: > The grammar that I published parses the examples on the xapi wiki page > just > fine. The hard part now is converting those in to SQL statements while > maintaining speed. In which stage is this code presently ? I managed to build it, but when I try to actually run a query, I get Except

Re: [OSM-dev] XAPI - Source code

2010-12-20 Thread Ian Dees
On Dec 20, 2010 1:47 AM, "Stefan Keller" wrote: > > Philipp, Ian > > @Philipp: > Ian seems to begin a complete rewrite of XAPI. There seems to be only > on implementation out there and at for some time least three well > known installations. See also Frederiks answer recently. > > @Ian: > Since yo

Re: [OSM-dev] XAPI - Source code

2010-12-19 Thread Stefan Keller
Philipp, Ian @Philipp: Ian seems to begin a complete rewrite of XAPI. There seems to be only on implementation out there and at for some time least three well known installations. See also Frederiks answer recently. @Ian: Since you start programming: Did you verify/discuss with others the syntax

Re: [OSM-dev] XAPI - Source code

2010-12-19 Thread Philipp Borgers
> 1. I think all XAPI server mentioned in > http://wiki.openstreetmap.org/wiki/XAPI#Servers use the same code, > don't they? > Can someone provide source code for all the xapi implementations out there? http://xapi.openstreetmap.org/scripts is broken for several days now. I will make a list in t