How can I store Geojson response into Postgres Database using node-express?

Question

NOTE: Geojson response contains coordinates datatype, which needs to be stored in Postgres as geometry datatype.

I don't want to use any 3rd party software like Qgis or ArcGIS, or command line tool such as geojson2psql in Postgis.

What's your table look like? Do you have a geom column? Do you have PostGIS installed? Do you know about the PostGIS method ST_GeomFromGeoJSON? This is actually a better question to ask on gis.stackexchange.com — Dr G.
– Dr G., Commented Mar 5, 2018 at 4:49

rotarydial · Accepted Answer · 2018-03-02 06:15:01Z

1

Use a jsonb column.

It's simple to query a jsonb column for specific attributes, using the -> operator. For example, assuming a column name of "geodata", this query:

SELECT geodata->'geometry'->'coordinates' AS coords FROM geo_example;

...would return [-104.99404, 39.75621] from this GeoJSON example I grabbed from Leaflet:

{
    "type": "Feature",
    "properties": {
        "name": "Coors Field",
        "amenity": "Baseball Stadium",
        "popupContent": "This is where the Rockies play!"
    },
    "geometry": {
        "type": "Point",
        "coordinates": [-104.99404, 39.75621]
    }
};

Here's a SQL Fiddle showing a couple examples.

edited Mar 2, 2018 at 6:15

answered Mar 2, 2018 at 6:02

rotarydial

2,6112 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Simhadri Akaash Over a year ago

Thank you. This may work. But I need to store data in Postgres DB only of type geometry, instead of jsonb. I cannot alter my table now. Need node implementation if possible.

rotarydial Over a year ago

Can you update your question and include your table's definition? At least the column you're looking to insert into.

Hussain Wali Over a year ago

is there any documentation, example anything for inserting data in to a Point type column in postgress with a rest API. I mean something I could test with postman ??

Collectives™ on Stack Overflow

How can I store Geojson response into Postgres Database using node-express?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related