The Java XAPI is a partial implementation of the XAPI read-only OSM server in Java. It is implemented as a servlet and uses pieces of Osmosis to perform the database queries.
See the OSM Wiki for more information about XAPI: http://wiki.openstreetmap.org/wiki/Xapi
These setup steps assume you're working on a Ubuntu 12.x installation.
Make sure you have the required packages installed:
sudo apt-get install postgresql-9.1 postgresql-9.1-postgis postgresql-contrib-9.1 openjdk-7-jre
Set up an Osmosis pgsnapshot 0.6 schema in a PostGIS database:
sudo su - postgres(These commands are meant to be run as user
createuser -s xapi
psql -d xapi -c "ALTER ROLE xapi PASSWORD 'xapi';"
psql -d xapi -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
psql -d xapi -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql
psql -d xapi -c "CREATE EXTENSION hstore;"
psql -d xapi -f ~/osmosis/script/pgsnapshot_schema_0.6.sql
psql -d xapi -f ~/osmosis/script/pgsnapshot_schema_0.6_linestring.sql
exit(Brings us back to original user.)
Tune your postgresql settings for a faster import. For a good discussion on tuning your database settings, see this post by Paul Norman.
Import a planet file (or other piece of OSM data)
bin/osmosis --read-bin file=planet-latest.osm.pbf --log-progress --write-pgsql user="xapi" database="xapi" password="xapi"
Add indexes for tags.
psql -d xapi -c "CREATE INDEX idx_nodes_tags ON nodes USING GIN(tags);" | psql -d xapi
psql -d xapi -c "CREATE INDEX idx_ways_tags ON ways USING GIN(tags);" | psql -d xapi
psql -d xapi -c "CREATE INDEX idx_relations_tags ON relations USING GIN(tags);" | psql -d xapi
Grab the latest XAPI war and deploy it with a servlet container like Tomcat or Jetty.
Keep Your Database Up to Date
Create a working directory for the Osmosis replication metadata.
Initialize the working directory for Osmosis's use.
~/osmosis/bin/osmosis --read-replication-interval-init workingDirectory=~/.osmosis
Find the minutely state file corresponding to a time very near but before your planet file's timestamp. I do this by viewing the minutely diff directory and looking for a timestamp near the one on my planet file. Copy the URL for that diff file and download it to Osmosis's newly-created working directory.
wget -O ~/.osmosis/state.txt http://planet.example.com/minutely-replicate/000/000/000.state.txt
Run Osmosis to catch the database up.
~osmosis/bin/osmosis --read-replication-interval workingDirectory=~/.osmosis \ --write-pgsql-change database="xapi" user="xapi" password="xapi"
I used Maven for the dependency and build management. Make sure you have
mvn installed before
doing any of this.
Clone the github xapi-servlet repo
Check out the Osmosis SVN code and Compile the JARs by executing
ant publishfrom the root osmosis directory.
Manually install the Osmosis dependencies into your local Maven repository by executing
mvn install:install-file -DgroupId=org.openstreetmap.osmosis -DartifactId=pgsnapshot -Dversion=0.39 -Dpackaging=jar -Dfile=build/binary/osmosis-pgsnapshot.jarfrom the Osmosis
mvn compile war:warfrom the xapi-servlet directory to generate a deployable servlet war.
- Note that this will fail if you don't have the JSON or PBF Osmosis JARs installed (You're not missing anything: I don't specify how to do that in this readme). To fix that, comment out the two
dependencyblocks in the
json. At the moment the PBF and JSON output is removed to make it easier to add the
planetDatetimestamp to the output.
See the issues list for all issues, but these limit functionality:
Bug 7 - Relation queries ignore any bounding box predicates.
Bug 12 - Relations aren't included in the "all elements" query.
PBF and JSON support was removed in f0f003 to make it easier to add the
This app was built on the shoulders of other people's open source code:
- bretth's Osmosis: for the database schema and querying code
- emacsen's xapi-ui: for the HTML debugging page he created to help build XAPI query URLs
- zere (and MapQuest's) help with everything; especially the parser!