January 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3305) Add system functions for GeoJSON

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3305?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3305: ------------------------------ Description: Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). https://github.com/bjornharrtell/jts2geojson I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. * http://postgis.org/docs/ST_AsGeoJSON.html * http://postgis.org/docs/ST_GeomFromGeoJSON.html was: Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). https://github.com/bjornharrtell/jts2geojson > Add system functions for GeoJSON > -------------------------------- > > Key: TEIID-3305 > URL: https://issues.jboss.org/browse/TEIID-3305 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). > https://github.com/bjornharrtell/jts2geojson > I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. > * http://postgis.org/docs/ST_AsGeoJSON.html > * http://postgis.org/docs/ST_GeomFromGeoJSON.html -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3308) Add translator for GeoWave

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3308: --------------------------------- Summary: Add translator for GeoWave Key: TEIID-3308 URL: https://issues.jboss.org/browse/TEIID-3308 Project: Teiid Issue Type: Feature Request Reporter: Tom Arnold Assignee: Steven Hawkins GeoWave adds spatial indexing and analytics to Accumulo. * https://github.com/ngageoint/geowave * https://ngageoint.github.io/geowave/ Perhaps this could be an extension of the Accumulo translator? -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3306) SOLR: Add spatial query support

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3306?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3306: ------------------------------ Issue Type: Enhancement (was: Feature Request) > SOLR: Add spatial query support > ------------------------------- > > Key: TEIID-3306 > URL: https://issues.jboss.org/browse/TEIID-3306 > Project: Teiid > Issue Type: Enhancement > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: solr, spatial > > Add support for running spatial queries with SOLR source. > https://cwiki.apache.org/confluence/display/solr/Spatial+Search > It looks like SOLR supports within-distance and BBOX queries. The spatial functions work with polygons, so we might need to be clever here. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3307) PostgreSQL: Implement Teiid spatial

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3307: --------------------------------- Summary: PostgreSQL: Implement Teiid spatial Key: TEIID-3307 URL: https://issues.jboss.org/browse/TEIID-3307 Project: Teiid Issue Type: Enhancement Reporter: Tom Arnold Assignee: Steven Hawkins Add support for GEOMETRY and the ST_* functions to the PostgreSQL translator. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3306) SOLR: Add spatial query support

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3306?page=com.atlassian.jira.plugin... ] Tom Arnold commented on TEIID-3306: ----------------------------------- I'm thinking we could do something like calculate a MBR (min bounding rectangle) and do a BBOX search with that, and then apply a more accurate filter to the results using the system functions. I think this could be a general enhancement for situations where the source partially supports a capability. The engine could push the filter to the translator and then apply it to the results in the engine anyways. This would make writing translators easier. > SOLR: Add spatial query support > ------------------------------- > > Key: TEIID-3306 > URL: https://issues.jboss.org/browse/TEIID-3306 > Project: Teiid > Issue Type: Feature Request > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: solr, spatial > > Add support for running spatial queries with SOLR source. > https://cwiki.apache.org/confluence/display/solr/Spatial+Search > It looks like SOLR supports within-distance and BBOX queries. The spatial functions work with polygons, so we might need to be clever here. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3306) SOLR: Add spatial query support

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3306?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3306: ------------------------------ Description: Add support for running spatial queries with SOLR source. https://cwiki.apache.org/confluence/display/solr/Spatial+Search It looks like SOLR supports within-distance and BBOX queries. The spatial functions work with polygons, so we might need to be clever here. was: Add support for running spatial queries with SOLR source. https://cwiki.apache.org/confluence/display/solr/Spatial+Search It looks like SOLR supports within-distance and BBOX queries. The spatial functions work with polygons, so we might need to be clever here. I'm thinking we could do something like calculate a MBR (min bounding rectangle) and do a BBOX search with that, and then apply a more accurate filter to the results using the system functions. > SOLR: Add spatial query support > ------------------------------- > > Key: TEIID-3306 > URL: https://issues.jboss.org/browse/TEIID-3306 > Project: Teiid > Issue Type: Feature Request > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: solr, spatial > > Add support for running spatial queries with SOLR source. > https://cwiki.apache.org/confluence/display/solr/Spatial+Search > It looks like SOLR supports within-distance and BBOX queries. The spatial functions work with polygons, so we might need to be clever here. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3306) SOLR: Add spatial query support

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3306: --------------------------------- Summary: SOLR: Add spatial query support Key: TEIID-3306 URL: https://issues.jboss.org/browse/TEIID-3306 Project: Teiid Issue Type: Feature Request Reporter: Tom Arnold Assignee: Steven Hawkins Add support for running spatial queries with SOLR source. https://cwiki.apache.org/confluence/display/solr/Spatial+Search It looks like SOLR supports within-distance and BBOX queries. The spatial functions work with polygons, so we might need to be clever here. I'm thinking we could do something like calculate a MBR (min bounding rectangle) and do a BBOX search with that, and then apply a more accurate filter to the results using the system functions. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3305) Add system functions for GeoJSON

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3305: --------------------------------- Summary: Add system functions for GeoJSON Key: TEIID-3305 URL: https://issues.jboss.org/browse/TEIID-3305 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Tom Arnold Assignee: Steven Hawkins Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). https://github.com/bjornharrtell/jts2geojson -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3304) MongoDB: Implement Teiid spatial

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3304: --------------------------------- Summary: MongoDB: Implement Teiid spatial Key: TEIID-3304 URL: https://issues.jboss.org/browse/TEIID-3304 Project: Teiid Issue Type: Enhancement Reporter: Tom Arnold Assignee: Steven Hawkins MongoDB translator has support for spatial queries using source-specific functions. We should update this to use the GEOMETRY type and the ST_* functions. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3303) Add translator for RethinkDB

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3303: --------------------------------- Summary: Add translator for RethinkDB Key: TEIID-3303 URL: https://issues.jboss.org/browse/TEIID-3303 Project: Teiid Issue Type: Feature Request Reporter: Tom Arnold Assignee: Steven Hawkins {quote} RethinkDB is built to store JSON documents, and scale to multiple machines with very little effort. It has a pleasant query language that supports really useful queries like table joins and group by, and is easy to setup and learn. {quote} See http://rethinkdb.com/. There are two 3rdparty drivers for Java, so we should pick one and build on that: * https://github.com/npiv/rethink-java-driver * https://github.com/dkhenry/rethinkjava -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2015