> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Migrate from GeoJSON

CockroachDB supports efficiently storing and querying [spatial data](https://docs.cockroachlabs.com/docs/stable/query-spatial-data.md).

This page has instructions for migrating data from the [GeoJSON](https://wikipedia.org/wiki/GeoJSON) format into CockroachDB using [`ogr2ogr`](https://gdal.org/programs/ogr2ogr.html) and [`IMPORT INTO`](https://docs.cockroachlabs.com/docs/stable/import-into).

In the following example, you will import a data set with [the locations of underground storage tanks in the state of Vermont (USA)](https://anrweb.vt.gov/DEC/ERT/UST.aspx?ustfacilityid=96).

## Before you begin

To follow along with the example below, you will need the following prerequisites:

* CockroachDB [installed](https://docs.cockroachlabs.com/docs/stable/install-cockroachdb.md) and [running](https://docs.cockroachlabs.com/docs/stable/start-a-local-cluster.md)
* [`ogr2ogr`](https://gdal.org/programs/ogr2ogr.html)

> [!NOTE]
>
> An `ogr2ogr` version of 3.1.0 or higher is required to generate data that can be imported into CockroachDB.

* [Python 3](https://www.python.org)
* The storage tank GeoJSON data:

  ```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
  curl -o tanks.geojson https://geodata.vermont.gov/datasets/986155613c5743239e7b1980b45bbf36_162.geojson
  ```

## Step 1. Convert the GeoJSON data to CSV

Convert the GeoJSON data to CSV using the following `ogr2ogr` command:

```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
ogr2ogr -f CSV tanks.csv -lco GEOMETRY=AS_WKT tanks.geojson
```

You will import the CSV data into a CockroachDB table.

## Step 2. Host the file where the cluster can access it

Each node in the CockroachDB cluster needs to have access to the files being imported.  There are several ways for the cluster to access the data; for a complete list of the types of storage [`IMPORT INTO`](https://docs.cockroachlabs.com/docs/stable/import-into) can pull from, see [Import file location](https://docs.cockroachlabs.com/docs/stable/import-into.md#import-file-location).

For local testing, you can [start a local file server](https://docs.cockroachlabs.com/docs/stable/use-a-local-file-server.md).  The following command will start a local file server listening on port 3000:

```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
python3 -m http.server 3000
```

## Step 3. Prepare the CockroachDB database

Create a database to hold the storage tank data:

```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
cockroach sql --insecure
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
CREATE DATABASE IF NOT EXISTS tanks;
USE tanks;
```

## Step 4. Create a CockroachDB table

To import the CSV data, you need to create a table with the necessary columns and data types.

Convert the GeoJSON data to SQL using the following `ogr2ogr` command:

```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
ogr2ogr -f PGDUMP tanks.sql -lco LAUNDER=NO -lco DROP_TABLE=OFF tanks.geojson
```

Create a CockroachDB table that corresponds to the DDL statements in `tanks.sql`:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
CREATE TABLE underground_storage_tank (
  wkb_geometry GEOMETRY(POINT) NULL,
  "TankID" INT8 NULL,
  "FacilityID" INT8 NULL,
  "Name" VARCHAR NULL,
  "TankStatus" VARCHAR NULL,
  "TankCapacity" INT8 NULL,
  "YearInstalled" VARCHAR NULL,
  "LastInspDate" TIMESTAMPTZ NULL,
  "Address" VARCHAR NULL,
  "Town" VARCHAR NULL,
  "State" VARCHAR NULL,
  "Zip" VARCHAR NULL,
  "DecLat" FLOAT8 NULL,
  "DecLong" FLOAT8 NULL,
  "DocLink" VARCHAR NULL,
  "ActorName" VARCHAR NULL,
  "PermitExpires" TIMESTAMPTZ NULL
);
```

## Step 5. Import the CSV

Since the file is being served from a local server and is formatted as CSV, you can import the data using the following [`IMPORT INTO`](https://docs.cockroachlabs.com/docs/stable/import-into) statement:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
IMPORT INTO underground_storage_tank CSV DATA ('http://localhost:3000/tanks.csv') WITH skip = '1';
```

```
        job_id       |  status   | fraction_completed | rows | index_entries | bytes
---------------------+-----------+--------------------+------+---------------+---------
  980386389822701569 | succeeded |                  1 | 3256 |             0 | 904102
```

## See also

* [`IMPORT INTO`](https://docs.cockroachlabs.com/docs/stable/import-into)
* [Migrate from OpenStreetMap](https://docs.cockroachlabs.com/docs/stable/migrate-from-openstreetmap.md)
* [Migrate from Shapefiles](https://docs.cockroachlabs.com/docs/stable/migrate-from-shapefiles.md)
* [Migrate from GeoPackage](https://docs.cockroachlabs.com/docs/stable/migrate-from-geopackage.md)
* [Spatial indexes](https://docs.cockroachlabs.com/docs/stable/spatial-indexes.md)
* [Migration Overview](https://docs.cockroachlabs.com/docs/molt/migration-overview.md)
* [Migrate from MySQL](https://docs.cockroachlabs.com/docs/molt/migrate-to-cockroachdb?filters=mysql)
* [Migrate from PostgreSQL](https://docs.cockroachlabs.com/docs/molt/migrate-to-cockroachdb)
* [Back Up and Restore Data](https://docs.cockroachlabs.com/docs/stable/take-full-and-incremental-backups.md)
* [Use the Built-in SQL Client](https://docs.cockroachlabs.com/docs/stable/cockroach-sql.md)
* [`cockroach` Commands Overview](https://docs.cockroachlabs.com/docs/stable/cockroach-commands)

[postgres]: migrate-from-postgres.html

[mysql]: migrate-from-mysql.html