[Geotools-devel] Poor performance with PreparedFilterToSQL when using an Id filter.

2016-09-15 Thread Shaun Forbes
Hey, I've noticed that the SQL generated by the org.geotools.data.jdbc.FilterToSQL and org.geotools.jdbc.PreparedFilterToSQL classes is different when processing an Id filter. The FilterToSQL class wraps the entire where clause in brackets, which the PreparedFilterToSQL does not. I've seen a sig

[Geotools-devel] BigDecimal conversion broken in org.geotools.util.CommonsConverterFactory

2011-11-10 Thread Shaun Forbes
Just perusing the latest gt sources, r38340, and noticed the the BigDecimal converter is registered as follows: register.put(BigDecimalConverter.class, new BigDecimalConverter()); when surely it should be: register.put(BigDecimal.class, new BigDecimalConverter()); Cheers, Shaun

[Geotools-devel] [jira] Created: (GEOT-3155) 'geography' spatial column type not supported in SQL Server 2008

2010-06-22 Thread Shaun Forbes (JIRA)
Type: Bug Components: data sqlserver Affects Versions: 2.7-M0, 2.6.4 Environment: SQL Server 2008 (only tested on R2, not sure if it's important) Reporter: Shaun Forbes It appears that SQL Server 2008 has two types of spatial columns, geometry and geography, but ther

[Geotools-devel] [jira] Created: (GEOT-2522) Unable to calculate query extent using Id filter

2009-05-28 Thread Shaun Forbes (JIRA)
Reporter: Shaun Forbes Assignee: Gabriel Roldán I can't use a FidFilter to calculate an extent in ArcSDE. I believe the problem stems from the fact that ArcSDEQuery.calculateQueryExtent(...) is using FidReader.NULL_READER when calling createQuery rather than obtaining th

[Geotools-devel] [jira] Created: (GEOT-1826) EPSG:102172 is incorrect

2008-05-19 Thread Shaun Forbes (JIRA)
Reporter: Shaun Forbes Assignee: Martin Desruisseaux Priority: Minor The Latitude of Origin is set as -32.5 in esri.properties , but it should be -32.0 http://spatialreference.org/ref/epsg/3107/esriwkt/ Yea, it might also need to be referenced as 3107, since ArcSDE seems

[Geotools-devel] [jira] Reopened: (GEOT-1213) Fid filter can geneate unsupported SQL on Oracle

2007-04-23 Thread Shaun Forbes (JIRA)
[ http://jira.codehaus.org/browse/GEOT-1213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shaun Forbes reopened GEOT-1213: Oops, code falls over when fid filter contains a multiple of 1000 fids > Fid filter can geneate unsuppor

[Geotools-devel] [jira] Created: (GEOT-1213) Id/Fid filter can geneate invalid SQL on Oracle

2007-03-29 Thread Shaun Forbes (JIRA)
Reporter: Shaun Forbes Assigned To: Gabriel Roldán When generating the where clause for an Id filter (or Fid filter on older releases) the default is to generate an IN clause that just lists all of the supplied ids, but Oracle can have problems processing an IN clause that contains more

[Geotools-devel] [jira] Created: (GEOT-1212) Invalid result created when qualifying type name

2007-03-29 Thread Shaun Forbes (JIRA)
Versions: 2.2.2 Reporter: Shaun Forbes Assigned To: Gabriel Roldán When running with ArcSDE on Oracle the database name can be empty which results in ArcSDEDataStore.getSchema(String typeName) generating an invalid type name being generated when trying to generate a fully

[Geotools-devel] [jira] Created: (GEOT-1206) WFSGeoResource canResolve method not checking all classes

2007-03-21 Thread Shaun Forbes (JIRA)
wfs Reporter: Shaun Forbes Assigned To: David Zwiers The WFSGeoResource canResolve method doesn't return true for the GeoResource class, even though the resolve method can resolve to that class. -- This message is automatically generated by JIRA. - If you think it was

[Geotools-devel] [jira] Created: (GEOT-1205) WMSGeoResource canResolve method not checking all classes

2007-03-21 Thread Shaun Forbes (JIRA)
wms Reporter: Shaun Forbes Assigned To: Richard Gould The WMSGeoResource canResolve method doesn't return true for the GeoResourceInfo class, even though the resolve method can resolve to that class. -- This message is automatically generated by JIRA. - If you think i