[Geoserver-devel] [jira] Created: (GEOS-475) bbox ignored with Batik SVG producer backed by PostgisDataStore

GeoServer GeoServer Developer
1

bbox ignored with Batik SVG producer backed by PostgisDataStore
---------------------------------------------------------------

         Key: GEOS-475
         URL: http://jira.codehaus.org/browse/GEOS-475
     Project: GeoServer
        Type: Bug
  Components: WMS
    Reporter: Justin Deoliveira
Assigned to: Justin Deoliveira
     Fix For: 1.3.0 RC7

I have set WMS svg rendering to use Batik with styling.(you're right it is painfully slow) When I use the following url:

http://localhost/geoserver/wms?bbox=-89,37,-84,42&styles=point&Format=image/svg+xml&request=GetMap&layers=geo:airports_icao&width=500&height=500&srs=EPSG:4269

1582866 [FINE] org.geotools.data.jdbc.JDBC1DataStore - calling sql builder with filter Filter.NONE

1582876 [FINE] org.geotools.data.jdbc.JDBC1DataStore - sql is SELECT "oid", "name", "id", "state_prov", "country", "icao", "host_id", "loc_hdatum", "wgs_datum", "wgs_lat", "latitude", "wgs_long", "longitude", "elev", "type", "mag_var", "wac", "beacon", "arpt", "opr_agy", "sec_name", "sec_icao", "sec_faa", "opr_agy0", "cycle_date", AsText(force_2d("the_geom")) FROM "airports_icao" WHERE TRUE

The bbox intersect clause is left off? Curiously the text labels are clipped to the bbox but not the point symbols. Switching to the simple svg rendering gives the correct sql but won't render until http://jira.codehaus.org/browse/GEOS-457 is resolved.

1837693 [FINE] org.geotools.data.jdbc.JDBC1DataStore - calling sql builder with filter [ POLYGON ((-89 37, -89 42, -84 42, -84 37, -89 37)) intersects the_geom ]

1837693 [FINE] org.geotools.data.jdbc.JDBC1DataStore - sql is SELECT "oid", "name", "id", "state_prov", "country", "icao", "host_id", "loc_hdatum", "wgs_datum", "wgs_lat", "latitude", "wgs_long", "longitude", "elev", "type", "mag_var", "wac", "beacon", "arpt", "opr_agy", "sec_name", "sec_icao", "sec_faa", "opr_agy0", "cycle_date", AsText(force_2d("the_geom")) FROM "airports_icao" WHERE GeometryFromText('POLYGON ((-89 37, -89 42, -84 42, -84 37, -89 37))', 4269) && "the_geom" AND intersects(GeometryFromText('POLYGON ((-89 37, -89 42, -84 42, -84 37, -89 37))', 4269), "the_geom")

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira