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

OK, it looks like there is actually an issue tracking this: https://issuetracker.google.com/issues/37302950

On Tuesday, January 9, 2018 at 1:33:37 PM UTC-5, Michael Marcacci wrote:

Well, now that I shared my workaround I found a nice production bug that it introduces. It turns out that the conversion reduces the numerical precision by one bit... so -85.39986445542691 becomes -85.3998644554269 (missing the last digit there).

This has broken the idempotent guarantee of our API, since the comparison is done application-side. Thus, a second identical request can look different and be rejected.

I'm going to create another request, this thread is clearly not getting noticed. I'll post any updates here.

On Monday, January 8, 2018 at 2:09:44 PM UTC-5, Michael Marcacci wrote:

Hi Mauro,

Absolutely! The backend that runs these queries is written in javascript, and we use the wkx library to do these conversions. Our code is littered with these conversions right now, but here's a simple model (using a custom modeling system) that should illustrate what we have to do:

https://gist.github.com/mike-marcacci/a12e150949acf25006d1040e3dfe5bcb

Note the commented-out section that reference this thread. This uses GeoJSON and works everywhere except Google Cloud. Having the models as an abstraction layer means that we've been able to isolate the inconvenience to some extent, but they really muck up analytics queries.

I know this product is still in beta, but the lack of response to this issue is becoming a bit frustrating; a simple "we're still working on it" would go a long way.

Cheers,

Mike

On Monday, January 8, 2018 at 1:55:45 PM UTC-5, Mauro Pompilio wrote:

Hi Michael,

Would be possible for you to post a gist with the shimming of the GeoJSON functions? is that workaround still working for you?

Thanks,

Mauro.

On Thursday, 20 July 2017 14:08:41 UTC+1, Michael Marcacci wrote:

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/86309a0f-ad07-4b40-9e04-514253b4b290%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.