Hi,
It does matter to make the database query by using srs=3763 if the polygon is
also converted correctly into the same coordinate system. I rather believe that
something goes wrong with the attribute query. Does the base of the query
return some rows for you?
SELECT "ID","LineNumber" "geom" FROM "GEO"."Lines" WHERE "Code" = 'T02A' AND
"Code" IS NOT NULL LIMIT 10;
-Jukka Rahkonen-
Lähettäjä: Filipe Silva [mailto:filipesil...@gmail.com]
Lähetetty: 23. tammikuuta 2018 14:42
Vastaanottaja: Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi>
Kopio: geoserver-users <geoserver-users@lists.sourceforge.net>
Aihe: Re: WMS Request with cql_filter on diferent projection
well.. i must be doing something wrong.
analysing and running the query on the DB, the "problem" is on the bbox polygon
(wich is on the srs on wich the db data is = 3763)
bellow the log on the request that gives no results.
any thoughts?
Regards
2018-01-23 12:32:17,820 INFO [org.geoserver.wms] -
Request: getServiceInfo
2018-01-23 12:32:17,820 DEBUG [org.geotools.data.sqlserver.jtds] - Failed to
find JTDS jar
2018-01-23 12:32:17,820 TRACE [org.geotools.data.sqlserver.jtds] - No JTDS jar
on classpath
2018-01-23 12:32:17,820 DEBUG [org.geotools.util] - CRSConverterFactory can be
applied from Strings to CRS only.
2018-01-23 12:32:17,820 DEBUG [org.geotools.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation
only.
2018-01-23 12:32:17,820 DEBUG [org.geotools.data.sqlserver.jtds] - Failed to
find JTDS jar
2018-01-23 12:32:17,833 TRACE [org.geotools.data.sqlserver.jtds] - No JTDS jar
on classpath
2018-01-23 12:32:17,833 DEBUG [org.geotools.util] - CRSConverterFactory can be
applied from Strings to CRS only.
2018-01-23 12:32:17,833 DEBUG [org.geotools.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation
only.
2018-01-23 12:32:17,833 DEBUG [org.geotools.styling] - number of fts set 1
2018-01-23 12:32:17,833 INFO [org.geoserver.flow] - Control-flow inactive,
there are no configured rules
2018-01-23 12:32:17,851 DEBUG [org.geotools.rendering] - Computed scale
denominator: 4265.459167698695
2018-01-23 12:32:17,864 DEBUG [org.geotools.styling] - number of fts set 1
2018-01-23 12:32:17,864 DEBUG [org.geotools.rendering] - creating rules for
scale denominator - 4,265.459
2018-01-23 12:32:17,864 DEBUG [org.geotools.data.sqlserver.jtds] - Failed to
find JTDS jar
2018-01-23 12:32:17,864 TRACE [org.geotools.data.sqlserver.jtds] - No JTDS jar
on classpath
2018-01-23 12:32:17,864 DEBUG [org.geotools.util] - CRSConverterFactory can be
applied from Strings to CRS only.
2018-01-23 12:32:17,864 DEBUG [org.geotools.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation only.
2018-01-23 12:32:17,864 DEBUG [org.geotools.data.sqlserver.jtds] - Failed to
find JTDS jar
2018-01-23 12:32:17,880 TRACE [org.geotools.data.sqlserver.jtds] - No JTDS jar
on classpath
2018-01-23 12:32:17,880 DEBUG [org.geotools.util] - CRSConverterFactory can be
applied from Strings to CRS only.
2018-01-23 12:32:17,880 DEBUG [org.geotools.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation only.
2018-01-23 12:32:17,880 DEBUG [org.geotools.rendering] - Processing 1 stylers
for http://mygeo.azurewebsites.net/esp:Linhas
2018-01-23 12:32:17,880 DEBUG [org.geotools.rendering] - Expanding rendering
area by 2 pixels to consider stroke width
2018-01-23 12:32:17,895 DEBUG [org.geotools.rendering] - Querying layer
http://mygeo.azurewebsites.net/esp:Linhas with bbox:
ReferencedEnvelope[-841416.9816337774 : -840914.1693070891, 4633954.148776404 :
4634437.851846022]
2018-01-23 12:32:17,895 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2018-01-23 12:32:17,895 DEBUG [org.geotools.filter] - exporting LogicFilter
2018-01-23 12:32:17,895 DEBUG [org.geotools.filter] - exporting PropertyName
2018-01-23 12:32:17,895 DEBUG [org.geotools.filter] - exporting
LiteralExpression
2018-01-23 12:32:17,895 DEBUG [org.geotools.data.sqlserver.jtds] - Failed to
find JTDS jar
2018-01-23 12:32:17,895 TRACE [org.geotools.data.sqlserver.jtds] - No JTDS jar
on classpath
2018-01-23 12:32:17,915 DEBUG [org.geotools.util] - CRSConverterFactory can be
applied from Strings to CRS only.
2018-01-23 12:32:17,915 DEBUG [org.geotools.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation only.
2018-01-23 12:32:17,915 DEBUG [org.geotools.filter] - exporting SQL
ComparisonFilter
2018-01-23 12:32:17,915 DEBUG [org.geotools.filter] - exporting PropertyName
2018-01-23 12:32:17,915 DEBUG [org.geotools.filter] - exporting
LiteralExpression
2018-01-23 12:32:17,915 DEBUG [org.geotools.filter] - exporting PropertyName
2018-01-23 12:32:17,915 DEBUG [org.geotools.jdbc] - SELECT
"ID","LineNumber","geom".STAsBinary() as "geom" FROM "GEO"."Lines" WHERE
("geom".Filter(geometry::STGeomFromText('POLYGON ((50195.36673961869
-142308.2110378479, 50195.36673961869 -141927.67000774978, 50592.3678403833
-141927.67000774978, 50592.3678403833 -142308.2110378479, 50195.36673961869
-142308.2110378479))', 3763)) = 1 AND "Code" = 'T02A' AND "Code" IS NOT NULL )
2018-01-23 12:32:17,926 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2018-01-23 12:32:17,945 DEBUG [org.geotools.renderer.label] - TOTAL LINE LABELS
: 0
2018-01-23 12:32:17,945 DEBUG [org.geotools.renderer.label] - PAINTED LINE
LABELS : 0
2018-01-23 12:32:17,945 DEBUG [org.geotools.renderer.label] - REMAINING LINE
LABELS : 0
2018-01-23 12:32:17,945 DEBUG [org.geotools.rendering] - Style cache hit ratio:
NaN , hits 0, requests 0
2018-01-23 12:32:17,945 INFO [org.geoserver.wms] -
Request: getMap
Angle = 0.0
BaseUrl = http://mygeo.azurewebsites.net:80/geoserver/
Bbox = SRSEnvelope[-841414.5929766435 :
-840916.557964223, 4633956.537433538 : 4634435.463188888]
BgColor = java.awt.Color[r=255,g=255,b=255]
Buffer = 0
CQLFilter = [[ Code = T02A ]]
Crs = PROJCS["WGS 84 / Pseudo-Mercator",
GEOGCS["WGS 84",
DATUM["World Geodetic System 1984",
SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]],
AUTHORITY["EPSG","6326"]],
PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]],
UNIT["degree", 0.017453292519943295],
AXIS["Geodetic longitude", EAST],
AXIS["Geodetic latitude", NORTH],
AUTHORITY["EPSG","4326"]],
PROJECTION["Popular Visualisation Pseudo Mercator", AUTHORITY["EPSG","1024"]],
PARAMETER["semi_minor", 6378137.0],
PARAMETER["latitude_of_origin", 0.0],
PARAMETER["central_meridian", 0.0],
PARAMETER["scale_factor", 1.0],
PARAMETER["false_easting", 0.0],
PARAMETER["false_northing", 0.0],
UNIT["m", 1.0],
AXIS["Easting", EAST],
AXIS["Northing", NORTH],
AUTHORITY["EPSG","3857"]]
Elevation = []
Env = {}
Exceptions = SE_XML
FeatureId = null
FeatureVersion = null
Filter = [[ Code = T02A ]]
Filters = [[ Code = T02A ]]
Format = image/png8
FormatOptions = {=true, ANTIALIAS=NONE}
Get = true
Height = 401
Interpolations = []
Layers = [org.geoserver.wms.MapLayerInfo@4ff26060]
MaxFeatures = null
Palette = null
RawKvp = {FORMAT=image/png8, STYLES=, WIDTH=417,
HEIGHT=401, LAYERS=esp:Linhas, TILED=false, REQUEST=GetMap, SRS=EPSG:3857,
FORMAT_OPTIONS=antialias:NONE;,
BBOX=-841414.5929766435,4633956.537433538,-840916.557964223,4634435.463188888,
SRSNAME=EPSG:3857, VERSION=1.1.1, SERVICE=WMS, TRANSPARENT=true,
CQL_FILTER=Code='T02A'}
RemoteOwsType = null
RemoteOwsURL = null
Request = GetMap
RequestCharset = UTF-8
ScaleMethod = null
Sld = null
SldBody = null
SldVersion = null
SRS = EPSG:3857
StartIndex = null
StyleBody = null
StyleFormat = sld
Styles = [StyleImpl[ name=lines_SLD]]
StyleUrl = null
StyleVersion = null
Tiled = false
TilesOrigin = null
Time = []
Transparent = true
ValidateSchema = false
Version = 1.1.1
ViewParams = null
Width = 417
2018-01-23 12:32:17,958 DEBUG [org.geotools.styling] - number of fts set 1
On Tue, Jan 23, 2018 at 12:11 PM, Rahkonen Jukka (MML)
<jukka.rahko...@maanmittauslaitos.fi<mailto:jukka.rahko...@maanmittauslaitos.fi>>
wrote:
Hi,
Turn on the GEOTOOLS_DEVELOPER logging level, then we might see more details
especially if your data comes from a database.
-Jukka Rahkonen-
Lähettäjä: Filipe Silva
[mailto:filipesil...@gmail.com<mailto:filipesil...@gmail.com>]
Lähetetty: 23. tammikuuta 2018 14:00
Vastaanottaja: Rahkonen Jukka (MML)
<jukka.rahko...@maanmittauslaitos.fi<mailto:jukka.rahko...@maanmittauslaitos.fi>>
Kopio: Andrea Aime
<andrea.a...@geo-solutions.it<mailto:andrea.a...@geo-solutions.it>>;
geoserver-users
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
Aihe: Re: WMS Request with cql_filter on diferent projection
Below the log on geoserver.
the only diferences are the CQL_Filter and the BBOX.
am i missing something?
regards
This one works!
2018-01-23 11:52:27,429 INFO [geoserver.wms] -
Request: getMap
Angle = 0.0
BaseUrl = http://mygeo.azurewebsites.net:80/geoserver/
Bbox =
SRSEnvelope[-845204.7793485002<tel:(779)%20348-5002> :
-836266.4243534025<tel:(424)%20353-4025>, 4631806.892828335 : 4636077.811783769]
BgColor = java.awt.Color[r=255,g=255,b=255]
Buffer = 0
CQLFilter = null
Crs = PROJCS["WGS 84 / Pseudo-Mercator",
GEOGCS["WGS 84",
DATUM["World Geodetic System 1984",
SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]],
AUTHORITY["EPSG","6326"]],
PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]],
UNIT["degree", 0.017453292519943295],
AXIS["Geodetic longitude", EAST],
AXIS["Geodetic latitude", NORTH],
AUTHORITY["EPSG","4326"]],
PROJECTION["Popular Visualisation Pseudo Mercator", AUTHORITY["EPSG","1024"]],
PARAMETER["semi_minor", 6378137.0],
PARAMETER["latitude_of_origin", 0.0],
PARAMETER["central_meridian", 0.0],
PARAMETER["scale_factor", 1.0],
PARAMETER["false_easting", 0.0],
PARAMETER["false_northing", 0.0],
UNIT["m", 1.0],
AXIS["Easting", EAST],
AXIS["Northing", NORTH],
AUTHORITY["EPSG","3857"]]
Elevation = []
Env = {}
Exceptions = SE_XML
FeatureId = null
FeatureVersion = null
Filter = null
Filters = null
Format = image/png8
FormatOptions = {=true, ANTIALIAS=NONE}
Get = true
Height = 894
Interpolations = []
Layers = [org.geoserver.wms.MapLayerInfo@4ff26060]
MaxFeatures = null
Palette = null
RawKvp = {FORMAT=image/png8, STYLES=, WIDTH=1871,
HEIGHT=894, LAYERS=esp:Linhas, TILED=false, REQUEST=GetMap, SRS=EPSG:3857,
FORMAT_OPTIONS=antialias:NONE;,
BBOX=-845204.7793485002<tel:(779)%20348-5002>,4631806.892828335,-836266.4243534025<tel:(424)%20353-4025>,4636077.811783769,
SRSNAME=EPSG:3857, VERSION=1.1.1, SERVICE=WMS, TRANSPARENT=true}
RemoteOwsType = null
RemoteOwsURL = null
Request = GetMap
RequestCharset = UTF-8
ScaleMethod = null
Sld = null
SldBody = null
SldVersion = null
SRS = EPSG:3857
StartIndex = null
StyleBody = null
StyleFormat = sld
Styles = [StyleImpl[ name=lines_SLD]]
StyleUrl = null
StyleVersion = null
Tiled = false
TilesOrigin = null
Time = []
Transparent = true
ValidateSchema = false
Version = 1.1.1
ViewParams = null
Width = 1871
this one does not work!
2018-01-23 11:53:50,404 INFO [geoserver.wms] -
Request: getMap
Angle = 0.0
BaseUrl = http://mygeo.azurewebsites.net:80/geoserver/
Bbox = SRSEnvelope[-841329.4970662479 :
-841001.6538746186, 4634076.268872376 : 4634315.73175005]
BgColor = java.awt.Color[r=255,g=255,b=255]
Buffer = 0
CQLFilter = [[ Code = T02A ]]
Crs = PROJCS["WGS 84 / Pseudo-Mercator",
GEOGCS["WGS 84",
DATUM["World Geodetic System 1984",
SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]],
AUTHORITY["EPSG","6326"]],
PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]],
UNIT["degree", 0.017453292519943295],
AXIS["Geodetic longitude", EAST],
AXIS["Geodetic latitude", NORTH],
AUTHORITY["EPSG","4326"]],
PROJECTION["Popular Visualisation Pseudo Mercator", AUTHORITY["EPSG","1024"]],
PARAMETER["semi_minor", 6378137.0],
PARAMETER["latitude_of_origin", 0.0],
PARAMETER["central_meridian", 0.0],
PARAMETER["scale_factor", 1.0],
PARAMETER["false_easting", 0.0],
PARAMETER["false_northing", 0.0],
UNIT["m", 1.0],
AXIS["Easting", EAST],
AXIS["Northing", NORTH],
AUTHORITY["EPSG","3857"]]
Elevation = []
Env = {}
Exceptions = SE_XML
FeatureId = null
FeatureVersion = null
Filter = [[ Code = T02A ]]
Filters = [[ Code = T02A ]]
Format = image/png8
FormatOptions = {=true, ANTIALIAS=NONE}
Get = true
Height = 401
Interpolations = []
Layers = [org.geoserver.wms.MapLayerInfo@4ff26060]
MaxFeatures = null
Palette = null
RawKvp = {FORMAT=image/png8, STYLES=, WIDTH=549,
HEIGHT=401, LAYERS=esp:Linhas, TILED=false, REQUEST=GetMap, SRS=EPSG:3857,
FORMAT_OPTIONS=antialias:NONE;,
BBOX=-841329.4970662479,4634076.268872376,-841001.6538746186,4634315.73175005,
SRSNAME=EPSG:3857, VERSION=1.1.1, SERVICE=WMS, TRANSPARENT=true,
CQL_FILTER=Code='T02A'}
RemoteOwsType = null
RemoteOwsURL = null
Request = GetMap
RequestCharset = UTF-8
ScaleMethod = null
Sld = null
SldBody = null
SldVersion = null
SRS = EPSG:3857
StartIndex = null
StyleBody = null
StyleFormat = sld
Styles = [StyleImpl[ name=lines_SLD]]
StyleUrl = null
StyleVersion = null
Tiled = false
TilesOrigin = null
Time = []
Transparent = true
ValidateSchema = false
Version = 1.1.1
ViewParams = null
Width = 549
On Mon, Jan 22, 2018 at 8:58 PM, Filipe Silva
<filipesil...@gmail.com<mailto:filipesil...@gmail.com>> wrote:
Hello.
Yes. It does work with the original srs(the one the data is in - i can even
set a cql filter in layer preview on geoserver and it does work)
My base layer ( on openlayers) and data layer (on geoserver) are indeed
diferent projections.
Also the full request, with no cql_filtet, also works.
Only after I set cql_filter (with the same parameters) it does not work.
Regards
On Monday, January 22, 2018, Rahkonen Jukka (MML)
<jukka.rahko...@maanmittauslaitos.fi<mailto:jukka.rahko...@maanmittauslaitos.fi>>
wrote:
Hi,
Does it work with that CQL filter and some other SRS? Based on your title that
mentions different projection it feels it does but you do not show such request.
BTW. srsName is nonsense with WMS but it is just skipped so it does not make
harm either.
-Jukka Rahkonen-
________________________________
Lähettäjä: Filipe Silva<mailto:filipesil...@gmail.com>
Lähetetty: 22.1.2018 21:34
Vastaanottaja: Andrea Aime<mailto:andrea.a...@geo-solutions.it>
Kopio: geoserver-users<mailto:geoserver-users@lists.sourceforge.net>
Aihe: Re: [Geoserver-users] WMS Request with cql_filter on diferent projection
hello.
this is the one without filter, wich it works.
https://mygeo.azurewebsites.net/geoserver/wms?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&FORMAT=image%2Fpng8&TRANSPARENT=true&STYLES=&LAYERS=esp%3ALinhas&srsname=EPSG%3A3857&tiled=false&FORMAT_OPTIONS=antialias%3ANONE%3B&BBOX=-844292.3123233459%2C4632320.4541121265%2C-837178.8913785567%2C4635564.250499978&SRS=EPSG%3A3857&WIDTH=1489&HEIGHT=679
this is the one with cql_filter, wich it doesn't work.
https://mygeo.azurewebsites.net/geoserver/wms?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&FORMAT=image%2Fpng8&TRANSPARENT=true&STYLES=&LAYERS=esp%3ALinhas&srsname=EPSG%3A3857&tiled=false&FORMAT_OPTIONS=antialias%3ANONE%3B&BBOX=-841329.4970662479%2C4634076.268872376%2C-841001.6538746186%2C4634315.73175005&SRS=EPSG%3A3857&CQL_FILTER=Code%3D%27T02A%27&WIDTH=549&HEIGHT=401
Thanks
On Mon, Jan 22, 2018 at 7:20 PM, Andrea Aime
<andrea.a...@geo-solutions.it<mailto:andrea.a...@geo-solutions.it>> wrote:
Hi Felipe,
could you please share the various actual requests?
Cheers
Andrea
On Mon, Jan 22, 2018 at 8:11 PM, Filipe Silva
<filipesil...@gmail.com<mailto:filipesil...@gmail.com>> wrote:
hello.
I have a layer on geoserver with data on EPSG:3763.
Im accessing it with openlayers on a WMS request on wich the base layer is in
EPSG:3857.
ive already included the proj4 3763 on openlayers.
Now, if make a simple wms request with params:
&SRS=EPSG%3A3857&srsname=EPSG%3A3857
and a BBOX with coordinates on 3857
all goes right and i get the data.
when i add a cql_filter on the data with the same params as before, nothing is
shown.
is this the correct behavior?
Regards
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Regards,
Andrea Aime
==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V
for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via di Montramito
3/A<https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
55054
Massarosa<https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
(LU)
phone: +39 0584 962313<tel:+39%200584%20962313>
fax: +39 0584 1660272<tel:+39%200584%20166%200272>
mob: +39 339 8844549<tel:+39%20339%20884%204549>
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo
è consentito esclusivamente al destinatario del messaggio, per le finalità
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro
sistema. Conservare il messaggio stesso, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse,
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the
attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act (Legislative
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in
accord with its purpose, any disclosure, reproduction, copying, distribution,
or either dissemination, either whole or partial, is strictly forbidden except
previous formal approval of the named addressee(s). If you are not the intended
recipient, please contact immediately the sender by telephone, fax or e-mail
and delete the information in this message that has been received in error. The
sender does not give any warranty or accept liability as the content, accuracy
or completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of e-mail
transmission, viruses, etc.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
