Re: [google-cloud-sql-discuss] PostgreSQL, Postgis, ST_GeomFromGeoJSON and JSON-C

I'd like to bump my request for an issue link, if it's possible. I am currently shimming the GeoJSON functions with some pretty dirty conversions through other formats, and would really like to clean this up as soon as this bug is fixed.

Thanks,

Mike

On Tuesday, July 4, 2017 at 9:39:54 PM UTC-6, Michael Marcacci wrote:

Do you have a link to this feature request by chance, or is it not public? I'd like to follow along, as working with GeoJSON is one of our top use cases for PostgreSQL+PostGIS.

Thanks,

Mike

On Friday, May 19, 2017 at 11:40:37 AM UTC-6, Ankush Agarwal wrote:

We have a feature request for this and this will help us prioritize.

On Fri, May 19, 2017 at 10:29 AM, Samuel ROZE <samue...@gmail.com> wrote:

I've being trying to use Google Cloud SQL PostgreSQL with Postgis. After experiencing the "missing uuid-ossp extension issue", I've been trying to use the "ST_GeomFromGeoJSON" function:

```

INSERT INTO "locations" ("id","datetime","travelIdentifier","point","accuracy","altitude","altitudeAccuracy","heading","speed","segment") VALUES (DEFAULT,'2017-05-19 17:17:33.022 +00:00','93d4bc6e-ea3e-46db-95e4-4f5ee450070a',ST_GeomFromGeoJSON('{"type":"Point","coordinates":[-122.31259857,37.49677685]}'),5,0,-1,297.42,32.73,7) RETURNING *;

ERROR:  You need JSON-C for ST_GeomFromGeoJSON

```

Based on Postgis' documentation, JSON-C is a required dependency and I understood from various Search queries that it is why I would have this issue. Any idea how, if possible, can we get Postgres with JSON-C ?

Thank you very much,

Samuel.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/33ea88b1-e478-4ceb-a4d5-6b6251fa21db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ankush Agarwal

Software Engineer, Cloud SQL

 

There are 10 types of people in this world - those who understand binary and those who don't

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/13d9ba6d-c1e7-4005-90e1-873849123f89%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.