I'm currently using: - Geoserver 2.7.2 - PostgreSQL 9.4.4 - PostGIS 2.1.9
When I submit the following wfs GetFeature request:
http://localhost:8080/geoserver/wfs...om&outputFormat=gml2&cql_filter=(street_name='FLINT RD')
I receive the following result:
unknown44.12436,-72.54717-72.54743,-Infinity -Infinity,44.12444 44.12463,-72.54852 -72.54871,-Infinity -Infinity,44.12468 44.12499,-72.54978 -72.55025,-Infinity-Infinity,44.1251 44.12517,-72.55048 -72.5519,-Infinity -Infinity,44.12547 44.12553,-72.55207 -72.55227,-Infinity -Infinity,44.1255844.12565,-72.5526 -72.55374,-Infinity -Infinity,44.12593 44.12598,-72.55402(Notice all the -Infinity occurrences)
The Geoserver log shows the following:
2015-10-15 19:05:57,870 DEBUG [geotools.jdbc] - SELECT "gid",encode(ST_AsEWKB("the_geom"),'base64') as "the_geom" FROM "gis"."roads" WHERE ("street_name" = 'FLINT RD') LIMIT 1000000 2015-10-15 19:05:57,904 TRACE [gml.producer] - ENTRY MULTILINESTRING((44.124362943798175 -72.54717254645593, -72.54743194580789-179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.12443923857896, 44.12463378863299 -72.54852294837116, -72.54870605469117 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.124675750770415, 44.12499237083453 -72.54978179876312, -72.55025482204758 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.1251029964365, 44.125171661170974 -72.55048370402218, -72.55190276942085 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.125473021362026, 44.12553405699744 -72.55207061773541, -72.5522689808511 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.12558364838957, 44.12565231215203 -72.5526046755422, -72.55374145556436 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.12593078582823, 44.12598037696227 -72.55402374258838))2015-10-15 19:05:57,904 TRACE [gml.producer] - RETURN MultiLineString
There is nothing of note in the Postgresql log.
When I query the database directly the geometries looks fine:
select st_asgeojson(the_geom) from gis.roads where street_name = 'FLINT RD';st_asgeojson{"type":"MultiLineString","coordinates":[[[-72.5471725464559,44.1243629437982],[-72.5474319458079,44.124439238579],[-72.5485229483712,44.124633788633],[-72.5487060546912,44.1246757507704],[-72.5497817987631,44.1249923708345],[-72.5502548220476,44.1251029964365],[-72.5504837040222,44.125171661171],[-72.5519027694208,44.125473021362],[-72.5520706177354,44.1255340569974],[-72.5522689808511,44.1255836483896],[-72.5526046755422,44.125652312152],[-72.5537414555644,44.1259307858282],[-72.5540237425884,44.1259803769623],[-72.5541915893192,44.1260261526254],[-72.5545272832683,44.1261024472592],[-72.5555801392129,44.1263809192413],[-72.5561523429156,44.1265525805059],[-72.5563964838536,44.1266136172514],[-72.556709289904,44.1266746509119]]]}(1 row)Does anyone have any idea what may be causing -Infinity to be returned in the wfs result set?
أكثر...
When I submit the following wfs GetFeature request:
http://localhost:8080/geoserver/wfs...om&outputFormat=gml2&cql_filter=(street_name='FLINT RD')
I receive the following result:
unknown44.12436,-72.54717-72.54743,-Infinity -Infinity,44.12444 44.12463,-72.54852 -72.54871,-Infinity -Infinity,44.12468 44.12499,-72.54978 -72.55025,-Infinity-Infinity,44.1251 44.12517,-72.55048 -72.5519,-Infinity -Infinity,44.12547 44.12553,-72.55207 -72.55227,-Infinity -Infinity,44.1255844.12565,-72.5526 -72.55374,-Infinity -Infinity,44.12593 44.12598,-72.55402(Notice all the -Infinity occurrences)
The Geoserver log shows the following:
2015-10-15 19:05:57,870 DEBUG [geotools.jdbc] - SELECT "gid",encode(ST_AsEWKB("the_geom"),'base64') as "the_geom" FROM "gis"."roads" WHERE ("street_name" = 'FLINT RD') LIMIT 1000000 2015-10-15 19:05:57,904 TRACE [gml.producer] - ENTRY MULTILINESTRING((44.124362943798175 -72.54717254645593, -72.54743194580789-179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.12443923857896, 44.12463378863299 -72.54852294837116, -72.54870605469117 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.124675750770415, 44.12499237083453 -72.54978179876312, -72.55025482204758 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.1251029964365, 44.125171661170974 -72.55048370402218, -72.55190276942085 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.125473021362026, 44.12553405699744 -72.55207061773541, -72.5522689808511 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.12558364838957, 44.12565231215203 -72.5526046755422, -72.55374145556436 -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, -179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 44.12593078582823, 44.12598037696227 -72.55402374258838))2015-10-15 19:05:57,904 TRACE [gml.producer] - RETURN MultiLineString
There is nothing of note in the Postgresql log.
When I query the database directly the geometries looks fine:
select st_asgeojson(the_geom) from gis.roads where street_name = 'FLINT RD';st_asgeojson{"type":"MultiLineString","coordinates":[[[-72.5471725464559,44.1243629437982],[-72.5474319458079,44.124439238579],[-72.5485229483712,44.124633788633],[-72.5487060546912,44.1246757507704],[-72.5497817987631,44.1249923708345],[-72.5502548220476,44.1251029964365],[-72.5504837040222,44.125171661171],[-72.5519027694208,44.125473021362],[-72.5520706177354,44.1255340569974],[-72.5522689808511,44.1255836483896],[-72.5526046755422,44.125652312152],[-72.5537414555644,44.1259307858282],[-72.5540237425884,44.1259803769623],[-72.5541915893192,44.1260261526254],[-72.5545272832683,44.1261024472592],[-72.5555801392129,44.1263809192413],[-72.5561523429156,44.1265525805059],[-72.5563964838536,44.1266136172514],[-72.556709289904,44.1266746509119]]]}(1 row)Does anyone have any idea what may be causing -Infinity to be returned in the wfs result set?
أكثر...