 CockroachDB Geospatial Survey 2

1.Do you use any kind of public benchmark for geospatial performance? Do you recommend we benchmark with any public data set + queries?

2.Could you share with us a few example queries with a link to test data? In particular, we would like to understand what your performance expectations are for these queries.

4.Our implementation may involve indexing Planar Geometry objects within user-specified bounds (e.g. a bounding box from (-100,-100) to (100,100)) and not index accelerating queries outside this bound. Would this be a problem for you?

Yes

No

If this were to occur, would this constrain you? What would your geometry bounds be?

5.Do you use any operators (e.g., the & and ~ operator) which only work on bounding boxes of geospatial types? If so, why?

I do not use these operators

I use these operators

What operators do you use and why?

6.For nearest neighbor support, which of the following options matter most to you?

<-> (distance between box centers)

<#> (distance between box edges)

I don’t need nearest neighbor support

7.Most of the previous survey’s respondents used PostGIS over Postgres’ native geospatial implementation. Do you use Postgres' Geometric Functions and Operators?

I do not use Postgres Geometric Functions and Operators

I use Postgres Geometric Functions and Operators

If you use Postgres’s native implementation, could you share more about why you use it and what Postgres Geometric Functions and Operators you use?

8.Do you use a driver or ORM with your Geospatial applications?

I don’t use a driver/ORM

I use a driver/ORM

What driver/ORM do you use?

CockroachDB Geospatial Survey 2

CockroachDB Geospatial Support