January 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3269) Oracle pushdown time formatting incorrect

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3269?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-3269: ------------------------------------- What do you mean by "invalid matches"? According to the Teiid doc (*) and the oracle doc (*)(*) are F and u valid options. (*) (Date_Time Functions > Parsing Date Datatypes from Strings): "You can learn more about how this class defines date and time string formats by visiting the Javadocs for SimpleDateFormat." I expect that similar logic applies for formatting of the output. (*)(*)http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html > Oracle pushdown time formatting incorrect > ----------------------------------------- > > Key: TEIID-3269 > URL: https://issues.jboss.org/browse/TEIID-3269 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.7.1, 8.9.1, 8.10 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > Oracle formatting cannot control the number of digits displayed in the same way as Java formatting, needs to AM instead of PM, and needs better handling for ERA. -- 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)

[ https://issues.jboss.org/browse/TEIID-3305?page=com.atlassian.jira.plugin... ] Tom Arnold commented on TEIID-3305: ----------------------------------- Sent PR. The jts2geojson library uses Jackson 2.x which is already a module (for Olingo?), but I needed to bring in the databind & annotation modules as well. Also I batched the GML2 commits (TEIID-3309) into this since I did them at the same time. > 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). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * https://github.com/bjornharrtell/jts2geojson > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > 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-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: ------------------------------ Git Pull Request: https://github.com/teiid/teiid/pull/397 > 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). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * https://github.com/bjornharrtell/jts2geojson > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > 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-3302) Implement ST_Transform

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3302?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3302: ------------------------------ Description: Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. There are a couple of options for implementing this: * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities. There will be a little boilerplate to interface with JTS. * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. was: Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. There are a couple of options for implementing this: * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities, but the project looks dead for about a year. Also there would be a little boilerplate to interface with JTS types. * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. > Implement ST_Transform > ---------------------- > > Key: TEIID-3302 > URL: https://issues.jboss.org/browse/TEIID-3302 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. > There are a couple of options for implementing this: > * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities. There will be a little boilerplate to interface with JTS. > * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. -- 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)

[ 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). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * ~https://github.com/bjornharrtell/jts2geojson~ * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 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). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * -https://github.com/bjornharrtell/jts2geojson- * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 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 > 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). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * ~https://github.com/bjornharrtell/jts2geojson~ > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > 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-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). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * https://github.com/bjornharrtell/jts2geojson * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 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). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * ~https://github.com/bjornharrtell/jts2geojson~ * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 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 > 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). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * https://github.com/bjornharrtell/jts2geojson > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > 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-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). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * -https://github.com/bjornharrtell/jts2geojson- * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 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). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * 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 > 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). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * -https://github.com/bjornharrtell/jts2geojson- > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > 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-3309) Add system functions for GML2

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3309: --------------------------------- Summary: Add system functions for GML2 Key: TEIID-3309 URL: https://issues.jboss.org/browse/TEIID-3309 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Tom Arnold Assignee: Steven Hawkins JTS has a reader/writer for GML2. * http://tsusiatsoftware.net/jts/javadoc/com/vividsolutions/jts/io/gml2/GML... * http://tsusiatsoftware.net/jts/javadoc/com/vividsolutions/jts/io/gml2/GML... We should expose this functionality as system functions (similar to PostGIS). * http://postgis.net/docs/ST_GeomFromGML.html * http://postgis.net/docs/ST_AsGML.html -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3302) Implement ST_Transform

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3302?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3302: ------------------------------ Description: Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. There are a couple of options for implementing this: * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities, but the project looks dead for about a year. Also there would be a little boilerplate to interface with JTS types. * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. was: Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. There are a couple of options for implementing this: * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. > Implement ST_Transform > ---------------------- > > Key: TEIID-3302 > URL: https://issues.jboss.org/browse/TEIID-3302 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. > There are a couple of options for implementing this: > * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities, but the project looks dead for about a year. Also there would be a little boilerplate to interface with JTS types. > * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. -- 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)

[ 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). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * 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 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 > 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). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * 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

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2015