> ## Documentation Index > Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Migrate from OpenStreetMap export const InternalLink = ({version, path = "", children, ...props}) => { let detectedVersion = version || "stable"; if (typeof window !== 'undefined' && !version) { const match = window.location.pathname.match(/\/docs\/([^/]+)/); if (match) { detectedVersion = match[1]; } } const normalizedPath = path.startsWith("/") ? path.slice(1) : path; return {children} ; }; CockroachDB supports efficiently storing and querying spatial data. This page has instructions for migrating data from [OpenStreetMap](https://www.openstreetmap.org/) `.pbf` data files into CockroachDB using [`osm2pgsql`](https://github.com/openstreetmap/osm2pgsql) and `IMPORT`. In the example below we will import the [OSM data for Australia](https://download.geofabrik.de/australia-oceania/australia) that is available from [GeoFabrik GmbH](http://www.geofabrik.de/data/shapefiles). ## Before You Begin To follow along with the example below, you will need the following prerequisites: * CockroachDB installed and running * [`osm2pgsql`](https://github.com/openstreetmap/osm2pgsql) ## Step 1. Download the OpenStreetMap data First, download the OSM data: ```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} curl -o australia-oceania/australia-latest.osm.pbf https://download.geofabrik.de/australia-oceania/australia-latest.osm.pbf ``` ## Step 2. Prepare the database ```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} cockroach sql --insecure ``` Next, create a database to hold the Australia map data: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} CREATE DATABASE IF NOT EXISTS australia; USE australia; ``` ## Step 3. Import the OpenStreetMap data Run the `osm2pgsql` command shown below to convert the OSM data and import it into the `australia` database. The arguments to `osm2pgsql` shown below assume a locally running insecure cluster and may need to be changed depending on your system. You may also need to tweak the cache setting (`-C`) depending on your system's hardware. ```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} osm2pgsql -C 2048 -d australia -U root -H localhost -P 26257 australia-latest.osm.pbf ``` This will take a few (30+) minutes to run on a laptop, and there will be a lot of output. A successful run will look something like the following: ```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} osm2pgsql version 1.3.0 Allocating memory for dense node cache Allocating dense node cache in one big chunk Allocating memory for sparse node cache Sharing dense sparse Node-cache: cache=2048MB, maxblocks=32768*65536, allocation method=3 Using built-in tag processing pipeline Using projection SRS 3857 (Spherical Mercator) WARNING: setting session var "synchronous_commit" is a no-op WARNING: setting session var "synchronous_commit" is a no-op Setting up table: planet_osm_point NOTICE: UNLOGGED TABLE will behave as a regular table in CockroachDB NOTICE: storage parameter "autovacuum_enabled = 'off'" is ignored WARNING: setting session var "synchronous_commit" is a no-op Setting up table: planet_osm_line NOTICE: UNLOGGED TABLE will behave as a regular table in CockroachDB NOTICE: storage parameter "autovacuum_enabled = 'off'" is ignored WARNING: setting session var "synchronous_commit" is a no-op Setting up table: planet_osm_polygon NOTICE: UNLOGGED TABLE will behave as a regular table in CockroachDB NOTICE: storage parameter "autovacuum_enabled = 'off'" is ignored WARNING: setting session var "synchronous_commit" is a no-op Setting up table: planet_osm_roads NOTICE: UNLOGGED TABLE will behave as a regular table in CockroachDB NOTICE: storage parameter "autovacuum_enabled = 'off'" is ignored Reading in file: australia-latest.osm.pbf Using PBF parser. Processing: Node(66994k 411.0k/s) Way(4640k 7.13k/s) Relation(124777 1313.4/s) parse time: 909s Node stats: total(66994811), max(7888181047) in 163s Way stats: total(4640490), max(845495883) in 651s Relation stats: total(124777), max(11596803) in 95s Sorting data and creating indexes for planet_osm_point node cache: stored: 66994811(100.00%), storage efficiency: 50.93% (dense blocks: 800, sparse nodes: 62492547), hit rate: 100.00% Sorting data and creating indexes for planet_osm_line Sorting data and creating indexes for planet_osm_polygon Sorting data and creating indexes for planet_osm_roads Using native order for clustering Using native order for clustering Using native order for clustering Using native order for clustering Copying planet_osm_roads to cluster by geometry finished Creating geometry index on planet_osm_roads Copying planet_osm_point to cluster by geometry finished Creating geometry index on planet_osm_point Creating indexes on planet_osm_roads finished Copying planet_osm_polygon to cluster by geometry finished Creating geometry index on planet_osm_polygon All indexes on planet_osm_roads created in 318s Completed planet_osm_roads Copying planet_osm_line to cluster by geometry finished Creating geometry index on planet_osm_line Creating indexes on planet_osm_point finished All indexes on planet_osm_point created in 1084s Completed planet_osm_point Creating indexes on planet_osm_polygon finished All indexes on planet_osm_polygon created in 1897s Completed planet_osm_polygon Creating indexes on planet_osm_line finished All indexes on planet_osm_line created in 1961s Completed planet_osm_line Osm2pgsql took 2879s overall ``` ## See also * `IMPORT` * Export Spatial Data * Spatial tutorial * Spatial indexes * Migrate from GeoPackages * Migrate from GeoJSON * Migrate from Shapefiles * Migration Overview * Migrate from MySQL * Migrate from PostgreSQL * Back Up and Restore Data * Use the Built-in SQL Client * `cockroach` Commands Overview * Using GeoServer with CockroachDB