GeoServer

Quoting Giacomo Fiorentini <g.fiorentini@...>:

> Is there support for punctual x,y JDBC datasource on geoserver ?
> If yes, can you suggest me docs, howto, or classes or jars to start
> seeing how it works.
> If not, can you give me some tips and suggestion for developing this
> type of
> simple datastore.

I can give you something in between...  Rob Atkinson developed the
'geometryless' datastore in geotools.  See
http://svn.geotools.org/geotools/trunk/gt/plugin/geometryless/  It will
pretty much do what you want, no need to really develop it.  The thing
that is missing is docs, howtos and jars.  What would be a great
service to the community is if you could do those things.  Make a
documentation page as a child page here:
http://docs.codehaus.org/display/GEOSDOC/DataStores (postgis and
shapefile are good examples).  And package up a jar file as an
extension like:
http://sourceforge.net/project/showfiles.php?group_id=25086&package_id=129885&release_id=385179
You can probably just download GeoTools 2.1.1 and use that jar directly.

If we get good feedback then we can start including the datastore in the
main distributions.

best regards,

Chris

>
> Any suggestion are welcome.
>
>
>                            Giacomo.
>
> Configuration info:
>     FeatureName
>     JDBC driver/Connection info
>     SQL query
>     xFieldName
>     yFieldName
>     CoordinateSystemReference
>     other metas
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through
> log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD
> SPLUNK!
>
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


***
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/

Giacomo Fiorentini wrote:
> Is there support for punctual x,y JDBC datasource on geoserver ?
> If yes, can you suggest me docs, howto, or classes or jars to start 
> seeing how it works.
> If not, can you give me some tips and suggestion for developing this 
> type of
> simple datastore.
>
Yes - there are some limitations, but docs are at:
https://www.seegrid.csiro.au/twiki/bin/view/Infosrvices/GeometrylessJDBCDataStore

(need moving to main doco site)

NB There are some changes to this on the geotools complex-features branch.

> Any suggestion are welcome.
>
>                                                                         
>                           Giacomo.
>
> Configuration info:
>    FeatureName
>    JDBC driver/Connection info
>    SQL query
>    xFieldName
>    yFieldName
>    CoordinateSystemReference
>    other metas
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log 
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Any chance you have some version of GeoTools on your classpath?  Have
you ever worked with GeoTools on this computer before?  This error
indicates that it's just not finding classes, that everyone else does
find, which is quite odd.  The only explanation I can think of is your
java is thinking that another version of GeoTools (and 2.2 changed the
referencing stuff) is being used.  If you have GeoTools on the path try
to remove it, or perhaps even delete it entirely, and see if that
helps.

best regards,

Chris


Quoting Corey Puffalt <cplists@...>:

> Justin,
>
> I re-ran under jdk1.4 with identical results.  As for modifications
> to the
> startup script, I added two lines to the top of startup.sh:
>
> JAVA_HOME=/usr/java/jdk1.4
> GEOSERVER_HOME=/stuff/geoserver-1.3.0
>
> Corey
>
>
> On 1/27/06, Justin Deoliveira <jdeolive@...> wrote:
> >
> > Hmm,
> >
> > Although Java 1.5 isn't officially supported it "should" work. Can
> you
> > humor me and try using a Java 1.4 jdk?
> >
> > Also  can you be a bit more specific to how you modified the
> startup.sh
> > script. Can you possible attach the script because when I try it it
> > works out of the box.
> >
> > -Justin
> >
>


***
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/

No, or at least if I did I've since deleted it.  Keep in mind I downloaded
the self-contained binary with it's own embedded Jetty.  I'm not deploying
to an existing J2EE container so I don't think there's anyway it could be
picking up the wrong libraries?

Corey

On 1/30/06, Chris Holmes <cholmes@...> wrote:
>
> Any chance you have some version of GeoTools on your classpath?  Have
> you ever worked with GeoTools on this computer before?  This error
> indicates that it's just not finding classes, that everyone else does
> find, which is quite odd.  The only explanation I can think of is your
> java is thinking that another version of GeoTools (and 2.2 changed the
> referencing stuff) is being used.  If you have GeoTools on the path try
> to remove it, or perhaps even delete it entirely, and see if that
> helps.
>
> best regards,
>
> Chris
>

Quoting Corey Puffalt <cplists@...>:

> No, or at least if I did I've since deleted it.  Keep in mind I
> downloaded
> the self-contained binary with it's own embedded Jetty.  I'm not
> deploying
> to an existing J2EE container so I don't think there's anyway it
> could be
> picking up the wrong libraries?
Well, if it's on your java classpath then it can pick up the libraries
from there.  If that's not it I'm completely stumped, since no one else
has really reported this problem.  I forget how to see what's on your
classpath on linux...  Maybe Justin has ideas.   Perhaps you could try
downloading GeoTools 2.1.1 and replace gt2-main.jar in
server/geoserver/WEB-INF/lib with the 2.1.1 main geotools jar.  Also
try doing 'jar xf gt2-main.jar' in that same location, and see if it
has the DefaultCoordinateSystemAxis.class in
org/geotools/referencing/cs.

best regards,

Chris

>
> Corey
>
> On 1/30/06, Chris Holmes <cholmes@...> wrote:
> >
> > Any chance you have some version of GeoTools on your classpath?
> Have
> > you ever worked with GeoTools on this computer before?  This error
> > indicates that it's just not finding classes, that everyone else
> does
> > find, which is quite odd.  The only explanation I can think of is
> your
> > java is thinking that another version of GeoTools (and 2.2 changed
> the
> > referencing stuff) is being used.  If you have GeoTools on the path
> try
> > to remove it, or perhaps even delete it entirely, and see if that
> > helps.
> >
> > best regards,
> >
> > Chris
> >
>


***
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/

> >
> > I remember there was a document in the goeserver site about how to
> set
> > up views to work in geoserver, but I could not find it... it is
> hard
> > sometimes to find those pages in the geoserver site. I always have
> the
> > impressions there are hidden somewhere...
http://docs.codehaus.org/display/GEOSDOC/PostGIS+DataStore is the page.

And I guess we have some work to do to make things more accessible.=20
Have you found:
http://docs.codehaus.org/display/GEOSDOC/Documentation+Tree ?  It lists
all the pages.  And have you tried the search box?  It backends to
google, and is really quite good at finding what you're looking for...

Chris

> >
> > Hope this helps.
> >
> > Javier.
> >
> > On 1/30/06, maria garcia garcia <laika54@...> wrote:
> > >
> > > Hello,I'll try explain my doubt. I have installed
> > PostgreSQL 8.1, and i have
> > > some tables with datos. I want to do querys, For example,
> > that Geoserver me
> > > dibuje 'parcelas which area is less than 80 metres, en vez
> > de todas. And i
> > > do this query with a sentencia SQL in PostgreSQL, i create
> > a view how:
> > >
> > > CREATE OR REPLACE VIEW vistaparcelas4 AS
> > >  SELECT parcelas.gid, parcelas.mapa, parcelas.delegacio,
> > parcelas.municipio,
> > > parcelas.masa, parcelas.hoja, parcelas.tipo, parcelas.parcela,
> > > parcelas.coorx, parcelas.coory, parcelas.via, parcelas.numero,
> > > parcelas.numerodup, parcelas.numsymbol, parcelas.area,
> > parcelas.fechaalta,
> > > parcelas.fechabaja, parcelas.the_geom
> > >    FROM parcelas
> > >   WHERE area(parcelas.the_geom) < 80;
> > >
> > > but when i create this view how a Feature Type in
> > Geoserver, el campo
> > > 'the_geom' doesn't appear and appears the next error:
> > >
> > >
> > > El FeatureType 'vistaparcelas4' tiene extensi&oactute;n
> > NULL. HINT: el
> > > conjunto de datos est=E1 vac=EDo o no contiene un atributo
> > geom=E9trico por
> > > defecto.
> > >
> > > Finally, I obtained that el campo 'the_geom' appeared but
> > when i do a
> > > request GetMap, Geoserver doesn't draw anything, why? what
> > can i do wrong???
> > >
> > > Could you help me, please?? do you know how to do 'querys'
> > in Geoserver??? I
> > > need help urgently.
> > >
> > > Thank you very much.
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by: Splunk Inc. Do you grep
> > through log files
> > > for problems? Stop! Download the new AJAX search engine
> > that makes searching
> > > your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> > >
>
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D=
121642
> > _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@...
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through
> log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD
> SPLUNK!
>
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D=
121642
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>
>
> 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 =E8 consentito esclusivamente al destinatario del messaggio,
> per le
> finalit=E0 indicate nel messaggio stesso. Qualora riceveste 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; costituisce comportamento contrario
> ai
> principi dettati dal D. Lgs. 196/2003 il trattenere il messaggio
> stesso,
> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo,
> od
> utilizzarlo per finalit=E0 diverse.
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through
> log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD
> SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=12164=
2
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


***
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/

Hi Chris,

I tried the search box with =A8PostgreSQL views" and did not find
anything. But with PostGIS it was ok. I suppose I did not have much
patience to search good.

The Documentation tree is great, I booked mark it!

I think the documentation in Geoserver is quite goodis just that
sometimes I have problems finding things, but I normally manage. And I
think one of the strengths of Geoserver is the good documentation.

Javier.

On 1/30/06, Chris Holmes <cholmes@...> wrote:
>
>
> > >
> > > I remember there was a document in the goeserver site about how to
> > set
> > > up views to work in geoserver, but I could not find it... it is
> > hard
> > > sometimes to find those pages in the geoserver site. I always have
> > the
> > > impressions there are hidden somewhere...
> http://docs.codehaus.org/display/GEOSDOC/PostGIS+DataStore is the page.
>
> And I guess we have some work to do to make things more accessible.
> Have you found:
> http://docs.codehaus.org/display/GEOSDOC/Documentation+Tree ?  It lists
> all the pages.  And have you tried the search box?  It backends to
> google, and is really quite good at finding what you're looking for...
>
> Chris
>
> > >
> > > Hope this helps.
> > >
> > > Javier.
> > >
> > > On 1/30/06, maria garcia garcia <laika54@...> wrote:
> > > >
> > > > Hello,I'll try explain my doubt. I have installed
> > > PostgreSQL 8.1, and i have
> > > > some tables with datos. I want to do querys, For example,
> > > that Geoserver me
> > > > dibuje 'parcelas which area is less than 80 metres, en vez
> > > de todas. And i
> > > > do this query with a sentencia SQL in PostgreSQL, i create
> > > a view how:
> > > >
> > > > CREATE OR REPLACE VIEW vistaparcelas4 AS
> > > >  SELECT parcelas.gid, parcelas.mapa, parcelas.delegacio,
> > > parcelas.municipio,
> > > > parcelas.masa, parcelas.hoja, parcelas.tipo, parcelas.parcela,
> > > > parcelas.coorx, parcelas.coory, parcelas.via, parcelas.numero,
> > > > parcelas.numerodup, parcelas.numsymbol, parcelas.area,
> > > parcelas.fechaalta,
> > > > parcelas.fechabaja, parcelas.the_geom
> > > >    FROM parcelas
> > > >   WHERE area(parcelas.the_geom) < 80;
> > > >
> > > > but when i create this view how a Feature Type in
> > > Geoserver, el campo
> > > > 'the_geom' doesn't appear and appears the next error:
> > > >
> > > >
> > > > El FeatureType 'vistaparcelas4' tiene extensi&oactute;n
> > > NULL. HINT: el
> > > > conjunto de datos est=E1 vac=EDo o no contiene un atributo
> > > geom=E9trico por
> > > > defecto.
> > > >
> > > > Finally, I obtained that el campo 'the_geom' appeared but
> > > when i do a
> > > > request GetMap, Geoserver doesn't draw anything, why? what
> > > can i do wrong???
> > > >
> > > > Could you help me, please?? do you know how to do 'querys'
> > > in Geoserver??? I
> > > > need help urgently.
> > > >
> > > > Thank you very much.
> > > > -------------------------------------------------------
> > > > This SF.net email is sponsored by: Splunk Inc. Do you grep
> > > through log files
> > > > for problems? Stop! Download the new AJAX search engine
> > > that makes searching
> > > > your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> > > >
> >
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=
=3D121642
> > > _______________________________________________
> > > Geoserver-users mailing list
> > > Geoserver-users@...
> > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc. Do you grep through
> > log files
> > for problems?  Stop!  Download the new AJAX search engine that makes
> > searching your log files as easy as surfing the  web.  DOWNLOAD
> > SPLUNK!
> >
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=
=3D121642
> > _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@...
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
> >
> >
> >
> > 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 =E8 consentito esclusivamente al destinatario del messaggio,
> > per le
> > finalit=E0 indicate nel messaggio stesso. Qualora riceveste 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; costituisce comportamento contrario
> > ai
> > principi dettati dal D. Lgs. 196/2003 il trattenere il messaggio
> > stesso,
> > divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo,
> > od
> > utilizzarlo per finalit=E0 diverse.
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc. Do you grep through
> > log files
> > for problems?  Stop!  Download the new AJAX search engine that makes
> > searching your log files as easy as surfing the  web.  DOWNLOAD
> > SPLUNK!
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=12164=
2
> > _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@...
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
>
>
> ***
> Chris Holmes
> The Open Planning Project
> thoughts at: http://cholmes.wordpress.com
>
> ----------------------------------------------------------
> This mail sent through IMP: https://webmail.limegroup.com/
>

Quoting Javier de la Torre <jatorre@...>:

> Hi Chris,
>
> I tried the search box with =A8PostgreSQL views" and did not find
> anything. But with PostGIS it was ok. I suppose I did not have much
> patience to search good.
Looks like that just failed because the word 'views' is not used, only
'view'.  I changed one word on the docs so now 'views' should appear in
searches too.

>
> The Documentation tree is great, I booked mark it!
Yeah, I need to modify the sidebar to make it more front and center.=20
But I lost permissions to do so in the upgrade.

>
> I think the documentation in Geoserver is quite goodis just that
> sometimes I have problems finding things, but I normally manage. And
> I
> think one of the strengths of Geoserver is the good documentation.
Thanks!  Yeah, it's a tough problem to organize the docs when we have so
much, to make it so users can actually find things...

Chris

>
> Javier.
>
> On 1/30/06, Chris Holmes <cholmes@...> wrote:
> >
> >
> > > >
> > > > I remember there was a document in the goeserver site about how
> to
> > > set
> > > > up views to work in geoserver, but I could not find it... it is
> > > hard
> > > > sometimes to find those pages in the geoserver site. I always
> have
> > > the
> > > > impressions there are hidden somewhere...
> > http://docs.codehaus.org/display/GEOSDOC/PostGIS+DataStore is the
> page.
> >
> > And I guess we have some work to do to make things more accessible.
> > Have you found:
> > http://docs.codehaus.org/display/GEOSDOC/Documentation+Tree ?  It
> lists
> > all the pages.  And have you tried the search box?  It backends to
> > google, and is really quite good at finding what you're looking
> for...
> >
> > Chris
> >
> > > >
> > > > Hope this helps.
> > > >
> > > > Javier.
> > > >
> > > > On 1/30/06, maria garcia garcia <laika54@...> wrote:
> > > > >
> > > > > Hello,I'll try explain my doubt. I have installed
> > > > PostgreSQL 8.1, and i have
> > > > > some tables with datos. I want to do querys, For example,
> > > > that Geoserver me
> > > > > dibuje 'parcelas which area is less than 80 metres, en vez
> > > > de todas. And i
> > > > > do this query with a sentencia SQL in PostgreSQL, i create
> > > > a view how:
> > > > >
> > > > > CREATE OR REPLACE VIEW vistaparcelas4 AS
> > > > >  SELECT parcelas.gid, parcelas.mapa, parcelas.delegacio,
> > > > parcelas.municipio,
> > > > > parcelas.masa, parcelas.hoja, parcelas.tipo,
> parcelas.parcela,
> > > > > parcelas.coorx, parcelas.coory, parcelas.via,
> parcelas.numero,
> > > > > parcelas.numerodup, parcelas.numsymbol, parcelas.area,
> > > > parcelas.fechaalta,
> > > > > parcelas.fechabaja, parcelas.the_geom
> > > > >    FROM parcelas
> > > > >   WHERE area(parcelas.the_geom) < 80;
> > > > >
> > > > > but when i create this view how a Feature Type in
> > > > Geoserver, el campo
> > > > > 'the_geom' doesn't appear and appears the next error:
> > > > >
> > > > >
> > > > > El FeatureType 'vistaparcelas4' tiene extensi&oactute;n
> > > > NULL. HINT: el
> > > > > conjunto de datos est=E1 vac=EDo o no contiene un atributo
> > > > geom=E9trico por
> > > > > defecto.
> > > > >
> > > > > Finally, I obtained that el campo 'the_geom' appeared but
> > > > when i do a
> > > > > request GetMap, Geoserver doesn't draw anything, why? what
> > > > can i do wrong???
> > > > >
> > > > > Could you help me, please?? do you know how to do 'querys'
> > > > in Geoserver??? I
> > > > > need help urgently.
> > > > >
> > > > > Thank you very much.
> > > > > -------------------------------------------------------
> > > > > This SF.net email is sponsored by: Splunk Inc. Do you grep
> > > > through log files
> > > > > for problems? Stop! Download the new AJAX search engine
> > > > that makes searching
> > > > > your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> > > > >
> > >
> >
>
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D=
121642
> > > > _______________________________________________
> > > > Geoserver-users mailing list
> > > > Geoserver-users@...
> > > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by: Splunk Inc. Do you grep
> through
> > > log files
> > > for problems?  Stop!  Download the new AJAX search engine that
> makes
> > > searching your log files as easy as surfing the  web.  DOWNLOAD
> > > SPLUNK!
> > >
> >
>
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D=
121642
> > > _______________________________________________
> > > Geoserver-users mailing list
> > > Geoserver-users@...
> > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> > >
> > >
> > >
> > >
> > > 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 =E8 consentito esclusivamente al destinatario del
> messaggio,
> > > per le
> > > finalit=E0 indicate nel messaggio stesso. Qualora riceveste 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; costituisce comportamento
> contrario
> > > ai
> > > principi dettati dal D. Lgs. 196/2003 il trattenere il messaggio
> > > stesso,
> > > divulgarlo anche in parte, distribuirlo ad altri soggetti,
> copiarlo,
> > > od
> > > utilizzarlo per finalit=E0 diverse.
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by: Splunk Inc. Do you grep
> through
> > > log files
> > > for problems?  Stop!  Download the new AJAX search engine that
> makes
> > > searching your log files as easy as surfing the  web.  DOWNLOAD
> > > SPLUNK!
> > >
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=12164=
2
> > > _______________________________________________
> > > Geoserver-users mailing list
> > > Geoserver-users@...
> > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> > >
> >
> >
> > ***
> > Chris Holmes
> > The Open Planning Project
> > thoughts at: http://cholmes.wordpress.com
> >
> > ----------------------------------------------------------
> > This mail sent through IMP: https://webmail.limegroup.com/
> >
>


***
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/

Hi Maria,

Have you added the geometry column of your view to the
"geometry_columns" table in PostGIS?

Do something like

"INSERT INTO geometry_columns (f_table_schema, f_table_name,
f_geometry_column, coord_dimension, srid, "type") VALUES ("public",
"vistaparcelas4", "the_geom",2, 4326, "POLYGON").

There must be in this table already a record for the table "parcelas",
just copy this record but instead of f_table_name being "parcelas" use
"vistaparcelas4".

I remember there was a document in the goeserver site about how to set
up views to work in geoserver, but I could not find it... it is hard
sometimes to find those pages in the geoserver site. I always have the
impressions there are hidden somewhere...

Hope this helps.

Javier.

On 1/30/06, maria garcia garcia <laika54@...> wrote:
>
> Hello,I'll try explain my doubt. I have installed PostgreSQL 8.1, and i h=
ave
> some tables with datos. I want to do querys, For example, that Geoserver =
me
> dibuje 'parcelas which area is less than 80 metres, en vez de todas. And =
i
> do this query with a sentencia SQL in PostgreSQL, i create a view how:
>
> CREATE OR REPLACE VIEW vistaparcelas4 AS
>  SELECT parcelas.gid, parcelas.mapa, parcelas.delegacio, parcelas.municip=
io,
> parcelas.masa, parcelas.hoja, parcelas.tipo, parcelas.parcela,
> parcelas.coorx, parcelas.coory, parcelas.via, parcelas.numero,
> parcelas.numerodup, parcelas.numsymbol, parcelas.area, parcelas.fechaalta=
,
> parcelas.fechabaja, parcelas.the_geom
>    FROM parcelas
>   WHERE area(parcelas.the_geom) < 80;
>
> but when i create this view how a Feature Type in Geoserver, el campo
> 'the_geom' doesn't appear and appears the next error:
>
>
> El FeatureType 'vistaparcelas4' tiene extensi&oactute;n NULL. HINT: el
> conjunto de datos est=E1 vac=EDo o no contiene un atributo geom=E9trico p=
or
> defecto.
>
> Finally, I obtained that el campo 'the_geom' appeared but when i do a
> request GetMap, Geoserver doesn't draw anything, why? what can i do wrong=
???
>
> Could you help me, please?? do you know how to do 'querys' in Geoserver??=
? I
> need help urgently.
>
> Thank you very much.
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems? Stop! Download the new AJAX search engine that makes search=
ing
> your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=
=3D121642
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

Javier,

There has been some work with filters in WMS. Ionic was doing this =20
and I suspect others may be, too. The Ionic system I saw was done for =20=

the European Space Agency.

I'm not sure what they used in terms of parameters. You might try =20
asking the WMS filter question on the wms-dev mailing list.

	Allan

On Jan 29, 2006, at 14:30, Javier de la Torre wrote:

> Hi Chris,
>
>
>> It's not possible to use filters in the WMS.  You can see more about
>> this issue here: http://jira.codehaus.org/browse/GEOS-529  If you
>> really want it then vote for the issue.  It shouldn't be all that =20
>> hard
>> to implement, and you're right, if things are more efficient with
>> Filters, we probably should make them available.
>
> Yes, specially when handling many features, like in my case =20
> millions, WFS gets useless (unless they implement some paging =20
> mechanism). I suppose the only way is to retrieve lot of data and =20
> not making the client cry for too much data, is through maps and WMS.
>
> Say it like this, without filters in WMS there is no way to create =20
> clients that access very big data stores and that allow to do =20
> searches based on properties. But OGC has not considered it no? =20
> Maybe the way they are thinking is trough SLD only, but WMS and WFS =20=

> can look much more comprehensive if they share things like that. I =20
> suppose I am also too much Geoserver influenced where every data =20
> store is directly served as WFS and WMS making both look so similar.
>
>>
>> There is a bug in for doing better processing of Filters in SLD:
>> http://jira.codehaus.org/browse/GEOS-519  You can watch it, it has a
>> very high priority for us, should be one of the first things done
>> against the new branch...  If someone provides an exact patch of the
>> fix it'll be easier for us to roll in.  We used to have code that did
>> it, if you check the source of 1.2.x you can probably find it, and =20=

>> just
>> adapt it to 1.3.x
>
> I see. That will be already nice! At least I would have a way to do =20=

> what I want to do...
> But this will start looking more ugly once you start supporting =20
> complex features I suppose. with more complicate data structures =20
> creating the correct filter, or just selecting the necessary =20
> fields, will be more challenging no?
>
> I am sorry but I can not work well with Java so I don=B4t think I =20
> will be able to fix that... pity... but if I can help with testing =20
> or something I will be happy.
>
> Javier.
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through =20
> log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD =20
> SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=121642=

> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>

--=20
Allan Doyle
+1.781.433.2695
adoyle@...

If someone could ping the wms-dev list that would be great.  I think
this feature is actually trivially easy for us to implement, unless
things have changed around, since we had it in the code before.  The
reason we took it out was to be more spec compliant, but if there's an
accepted way to do it then we'd be happy to support it.

Allan, do you have any idea why they went with filters instead of just
including filters in the SLD?  I would have guessed that the 'official'
answer would be to just use SLD.

best regards,

Chris

Quoting Allan Doyle <adoyle@...>:

> Javier,
>
> There has been some work with filters in WMS. Ionic was doing this
> and I suspect others may be, too. The Ionic system I saw was done for
> the European Space Agency.
>
> I'm not sure what they used in terms of parameters. You might try
> asking the WMS filter question on the wms-dev mailing list.
>
> 	Allan
>
> On Jan 29, 2006, at 14:30, Javier de la Torre wrote:
>
> > Hi Chris,
> >
> >
> >> It's not possible to use filters in the WMS.  You can see more
> about
> >> this issue here: http://jira.codehaus.org/browse/GEOS-529  If you
> >> really want it then vote for the issue.  It shouldn't be all that
> >> hard
> >> to implement, and you're right, if things are more efficient with
> >> Filters, we probably should make them available.
> >
> > Yes, specially when handling many features, like in my case
> > millions, WFS gets useless (unless they implement some paging
> > mechanism). I suppose the only way is to retrieve lot of data and
> > not making the client cry for too much data, is through maps and
> WMS.
> >
> > Say it like this, without filters in WMS there is no way to create
> > clients that access very big data stores and that allow to do
> > searches based on properties. But OGC has not considered it no?
> > Maybe the way they are thinking is trough SLD only, but WMS and WFS
> > can look much more comprehensive if they share things like that. I
> > suppose I am also too much Geoserver influenced where every data
> > store is directly served as WFS and WMS making both look so
> similar.
> >
> >>
> >> There is a bug in for doing better processing of Filters in SLD:
> >> http://jira.codehaus.org/browse/GEOS-519  You can watch it, it has
> a
> >> very high priority for us, should be one of the first things done
> >> against the new branch...  If someone provides an exact patch of
> the
> >> fix it'll be easier for us to roll in.  We used to have code that
> did
> >> it, if you check the source of 1.2.x you can probably find it, and
> >> just
> >> adapt it to 1.3.x
> >
> > I see. That will be already nice! At least I would have a way to do
> > what I want to do...
> > But this will start looking more ugly once you start supporting
> > complex features I suppose. with more complicate data structures
> > creating the correct filter, or just selecting the necessary
> > fields, will be more challenging no?
> >
> > I am sorry but I can not work well with Java so I don=B4t think I
> > will be able to fix that... pity... but if I can help with testing
> > or something I will be happy.
> >
> > Javier.
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc. Do you grep through
> > log files
> > for problems?  Stop!  Download the new AJAX search engine that
> makes
> > searching your log files as easy as surfing the  web.  DOWNLOAD
> > SPLUNK!
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=121=
642
> > _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@...
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
>
> --
> Allan Doyle
> +1.781.433.2695
> adoyle@...
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through
> log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD
> SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=12164=
2
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


***
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/

SSdkIGxvdmUgdG8gYmUgYWJsZSB0byB1c2UgV01TIGZpbHRlcnMgYXMgd2VsbC4gVGhlIGppcmEg
dGFzayBhbHJlYWR5CmdvdCBteSB2b3RlLgoKQWxleAoKT24gMS8zMC8wNiwgQ2hyaXMgSG9sbWVz
IDxjaG9sbWVzQG9wZW5wbGFucy5vcmc+IHdyb3RlOgo+IElmIHNvbWVvbmUgY291bGQgcGluZyB0
aGUgd21zLWRldiBsaXN0IHRoYXQgd291bGQgYmUgZ3JlYXQuICBJIHRoaW5rCj4gdGhpcyBmZWF0
dXJlIGlzIGFjdHVhbGx5IHRyaXZpYWxseSBlYXN5IGZvciB1cyB0byBpbXBsZW1lbnQsIHVubGVz
cwo+IHRoaW5ncyBoYXZlIGNoYW5nZWQgYXJvdW5kLCBzaW5jZSB3ZSBoYWQgaXQgaW4gdGhlIGNv
ZGUgYmVmb3JlLiAgVGhlCj4gcmVhc29uIHdlIHRvb2sgaXQgb3V0IHdhcyB0byBiZSBtb3JlIHNw
ZWMgY29tcGxpYW50LCBidXQgaWYgdGhlcmUncyBhbgo+IGFjY2VwdGVkIHdheSB0byBkbyBpdCB0
aGVuIHdlJ2QgYmUgaGFwcHkgdG8gc3VwcG9ydCBpdC4KPgo+IEFsbGFuLCBkbyB5b3UgaGF2ZSBh
bnkgaWRlYSB3aHkgdGhleSB3ZW50IHdpdGggZmlsdGVycyBpbnN0ZWFkIG9mIGp1c3QKPiBpbmNs
dWRpbmcgZmlsdGVycyBpbiB0aGUgU0xEPyAgSSB3b3VsZCBoYXZlIGd1ZXNzZWQgdGhhdCB0aGUg
J29mZmljaWFsJwo+IGFuc3dlciB3b3VsZCBiZSB0byBqdXN0IHVzZSBTTEQuCj4KPiBiZXN0IHJl
Z2FyZHMsCj4KPiBDaHJpcwo+Cj4gUXVvdGluZyBBbGxhbiBEb3lsZSA8YWRveWxlQGVvZ2VvLm9y
Zz46Cj4KPiA+IEphdmllciwKPiA+Cj4gPiBUaGVyZSBoYXMgYmVlbiBzb21lIHdvcmsgd2l0aCBm
aWx0ZXJzIGluIFdNUy4gSW9uaWMgd2FzIGRvaW5nIHRoaXMKPiA+IGFuZCBJIHN1c3BlY3Qgb3Ro
ZXJzIG1heSBiZSwgdG9vLiBUaGUgSW9uaWMgc3lzdGVtIEkgc2F3IHdhcyBkb25lIGZvcgo+ID4g
dGhlIEV1cm9wZWFuIFNwYWNlIEFnZW5jeS4KPiA+Cj4gPiBJJ20gbm90IHN1cmUgd2hhdCB0aGV5
IHVzZWQgaW4gdGVybXMgb2YgcGFyYW1ldGVycy4gWW91IG1pZ2h0IHRyeQo+ID4gYXNraW5nIHRo
ZSBXTVMgZmlsdGVyIHF1ZXN0aW9uIG9uIHRoZSB3bXMtZGV2IG1haWxpbmcgbGlzdC4KPiA+Cj4g
PiAgICAgICBBbGxhbgo+ID4KPiA+IE9uIEphbiAyOSwgMjAwNiwgYXQgMTQ6MzAsIEphdmllciBk
ZSBsYSBUb3JyZSB3cm90ZToKPiA+Cj4gPiA+IEhpIENocmlzLAo+ID4gPgo+ID4gPgo+ID4gPj4g
SXQncyBub3QgcG9zc2libGUgdG8gdXNlIGZpbHRlcnMgaW4gdGhlIFdNUy4gIFlvdSBjYW4gc2Vl
IG1vcmUKPiA+IGFib3V0Cj4gPiA+PiB0aGlzIGlzc3VlIGhlcmU6IGh0dHA6Ly9qaXJhLmNvZGVo
YXVzLm9yZy9icm93c2UvR0VPUy01MjkgIElmIHlvdQo+ID4gPj4gcmVhbGx5IHdhbnQgaXQgdGhl
biB2b3RlIGZvciB0aGUgaXNzdWUuICBJdCBzaG91bGRuJ3QgYmUgYWxsIHRoYXQKPiA+ID4+IGhh
cmQKPiA+ID4+IHRvIGltcGxlbWVudCwgYW5kIHlvdSdyZSByaWdodCwgaWYgdGhpbmdzIGFyZSBt
b3JlIGVmZmljaWVudCB3aXRoCj4gPiA+PiBGaWx0ZXJzLCB3ZSBwcm9iYWJseSBzaG91bGQgbWFr
ZSB0aGVtIGF2YWlsYWJsZS4KPiA+ID4KPiA+ID4gWWVzLCBzcGVjaWFsbHkgd2hlbiBoYW5kbGlu
ZyBtYW55IGZlYXR1cmVzLCBsaWtlIGluIG15IGNhc2UKPiA+ID4gbWlsbGlvbnMsIFdGUyBnZXRz
IHVzZWxlc3MgKHVubGVzcyB0aGV5IGltcGxlbWVudCBzb21lIHBhZ2luZwo+ID4gPiBtZWNoYW5p
c20pLiBJIHN1cHBvc2UgdGhlIG9ubHkgd2F5IGlzIHRvIHJldHJpZXZlIGxvdCBvZiBkYXRhIGFu
ZAo+ID4gPiBub3QgbWFraW5nIHRoZSBjbGllbnQgY3J5IGZvciB0b28gbXVjaCBkYXRhLCBpcyB0
aHJvdWdoIG1hcHMgYW5kCj4gPiBXTVMuCj4gPiA+Cj4gPiA+IFNheSBpdCBsaWtlIHRoaXMsIHdp
dGhvdXQgZmlsdGVycyBpbiBXTVMgdGhlcmUgaXMgbm8gd2F5IHRvIGNyZWF0ZQo+ID4gPiBjbGll
bnRzIHRoYXQgYWNjZXNzIHZlcnkgYmlnIGRhdGEgc3RvcmVzIGFuZCB0aGF0IGFsbG93IHRvIGRv
Cj4gPiA+IHNlYXJjaGVzIGJhc2VkIG9uIHByb3BlcnRpZXMuIEJ1dCBPR0MgaGFzIG5vdCBjb25z
aWRlcmVkIGl0IG5vPwo+ID4gPiBNYXliZSB0aGUgd2F5IHRoZXkgYXJlIHRoaW5raW5nIGlzIHRy
b3VnaCBTTEQgb25seSwgYnV0IFdNUyBhbmQgV0ZTCj4gPiA+IGNhbiBsb29rIG11Y2ggbW9yZSBj
b21wcmVoZW5zaXZlIGlmIHRoZXkgc2hhcmUgdGhpbmdzIGxpa2UgdGhhdC4gSQo+ID4gPiBzdXBw
b3NlIEkgYW0gYWxzbyB0b28gbXVjaCBHZW9zZXJ2ZXIgaW5mbHVlbmNlZCB3aGVyZSBldmVyeSBk
YXRhCj4gPiA+IHN0b3JlIGlzIGRpcmVjdGx5IHNlcnZlZCBhcyBXRlMgYW5kIFdNUyBtYWtpbmcg
Ym90aCBsb29rIHNvCj4gPiBzaW1pbGFyLgo+ID4gPgo+ID4gPj4KPiA+ID4+IFRoZXJlIGlzIGEg
YnVnIGluIGZvciBkb2luZyBiZXR0ZXIgcHJvY2Vzc2luZyBvZiBGaWx0ZXJzIGluIFNMRDoKPiA+
ID4+IGh0dHA6Ly9qaXJhLmNvZGVoYXVzLm9yZy9icm93c2UvR0VPUy01MTkgIFlvdSBjYW4gd2F0
Y2ggaXQsIGl0IGhhcwo+ID4gYQo+ID4gPj4gdmVyeSBoaWdoIHByaW9yaXR5IGZvciB1cywgc2hv
dWxkIGJlIG9uZSBvZiB0aGUgZmlyc3QgdGhpbmdzIGRvbmUKPiA+ID4+IGFnYWluc3QgdGhlIG5l
dyBicmFuY2guLi4gIElmIHNvbWVvbmUgcHJvdmlkZXMgYW4gZXhhY3QgcGF0Y2ggb2YKPiA+IHRo
ZQo+ID4gPj4gZml4IGl0J2xsIGJlIGVhc2llciBmb3IgdXMgdG8gcm9sbCBpbi4gIFdlIHVzZWQg
dG8gaGF2ZSBjb2RlIHRoYXQKPiA+IGRpZAo+ID4gPj4gaXQsIGlmIHlvdSBjaGVjayB0aGUgc291
cmNlIG9mIDEuMi54IHlvdSBjYW4gcHJvYmFibHkgZmluZCBpdCwgYW5kCj4gPiA+PiBqdXN0Cj4g
PiA+PiBhZGFwdCBpdCB0byAxLjMueAo+ID4gPgo+ID4gPiBJIHNlZS4gVGhhdCB3aWxsIGJlIGFs
cmVhZHkgbmljZSEgQXQgbGVhc3QgSSB3b3VsZCBoYXZlIGEgd2F5IHRvIGRvCj4gPiA+IHdoYXQg
SSB3YW50IHRvIGRvLi4uCj4gPiA+IEJ1dCB0aGlzIHdpbGwgc3RhcnQgbG9va2luZyBtb3JlIHVn
bHkgb25jZSB5b3Ugc3RhcnQgc3VwcG9ydGluZwo+ID4gPiBjb21wbGV4IGZlYXR1cmVzIEkgc3Vw
cG9zZS4gd2l0aCBtb3JlIGNvbXBsaWNhdGUgZGF0YSBzdHJ1Y3R1cmVzCj4gPiA+IGNyZWF0aW5n
IHRoZSBjb3JyZWN0IGZpbHRlciwgb3IganVzdCBzZWxlY3RpbmcgdGhlIG5lY2Vzc2FyeQo+ID4g
PiBmaWVsZHMsIHdpbGwgYmUgbW9yZSBjaGFsbGVuZ2luZyBubz8KPiA+ID4KPiA+ID4gSSBhbSBz
b3JyeSBidXQgSSBjYW4gbm90IHdvcmsgd2VsbCB3aXRoIEphdmEgc28gSSBkb27CtHQgdGhpbmsg
SQo+ID4gPiB3aWxsIGJlIGFibGUgdG8gZml4IHRoYXQuLi4gcGl0eS4uLiBidXQgaWYgSSBjYW4g
aGVscCB3aXRoIHRlc3RpbmcKPiA+ID4gb3Igc29tZXRoaW5nIEkgd2lsbCBiZSBoYXBweS4KPiA+
ID4KPiA+ID4gSmF2aWVyLgo+ID4gPgo+ID4gPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCj4gPiA+IFRoaXMgU0YubmV0IGVtYWlsIGlzIHNw
b25zb3JlZCBieTogU3BsdW5rIEluYy4gRG8geW91IGdyZXAgdGhyb3VnaAo+ID4gPiBsb2cgZmls
ZXMKPiA+ID4gZm9yIHByb2JsZW1zPyAgU3RvcCEgIERvd25sb2FkIHRoZSBuZXcgQUpBWCBzZWFy
Y2ggZW5naW5lIHRoYXQKPiA+IG1ha2VzCj4gPiA+IHNlYXJjaGluZyB5b3VyIGxvZyBmaWxlcyBh
cyBlYXN5IGFzIHN1cmZpbmcgdGhlICB3ZWIuICBET1dOTE9BRAo+ID4gPiBTUExVTkshCj4gPiA+
IGh0dHA6Ly9zZWwuYXMtdXMuZmFsa2FnLm5ldC9zZWw/Y21kPWxuayZraWQQMzQzMiZiaWQjMDQ4
NiZkYXQSMTY0Mgo+ID4gPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fXwo+ID4gPiBHZW9zZXJ2ZXItdXNlcnMgbWFpbGluZyBsaXN0Cj4gPiA+IEdlb3NlcnZl
ci11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQKPiA+ID4gaHR0cHM6Ly9saXN0cy5zb3VyY2Vm
b3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vZ2Vvc2VydmVyLXVzZXJzCj4gPiA+Cj4gPgo+ID4gLS0K
PiA+IEFsbGFuIERveWxlCj4gPiArMS43ODEuNDMzLjI2OTUKPiA+IGFkb3lsZUBlb2dlby5vcmcK
PiA+Cj4gPgo+ID4KPiA+Cj4gPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tCj4gPiBUaGlzIFNGLm5ldCBlbWFpbCBpcyBzcG9uc29yZWQgYnk6
IFNwbHVuayBJbmMuIERvIHlvdSBncmVwIHRocm91Z2gKPiA+IGxvZyBmaWxlcwo+ID4gZm9yIHBy
b2JsZW1zPyAgU3RvcCEgIERvd25sb2FkIHRoZSBuZXcgQUpBWCBzZWFyY2ggZW5naW5lIHRoYXQg
bWFrZXMKPiA+IHNlYXJjaGluZyB5b3VyIGxvZyBmaWxlcyBhcyBlYXN5IGFzIHN1cmZpbmcgdGhl
ICB3ZWIuICBET1dOTE9BRAo+ID4gU1BMVU5LIQo+ID4gaHR0cDovL3NlbC5hcy11cy5mYWxrYWcu
bmV0L3NlbD9jbWQ9bG5rJmtpZBAzNDMyJmJpZCMwNDg2JmRhdBIxNjQyCj4gPiBfX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwo+ID4gR2Vvc2VydmVyLXVzZXJz
IG1haWxpbmcgbGlzdAo+ID4gR2Vvc2VydmVyLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldAo+
ID4gaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vZ2Vvc2VydmVy
LXVzZXJzCj4gPgo+Cj4KPiAqKioKPiBDaHJpcyBIb2xtZXMKPiBUaGUgT3BlbiBQbGFubmluZyBQ
cm9qZWN0Cj4gdGhvdWdodHMgYXQ6IGh0dHA6Ly9jaG9sbWVzLndvcmRwcmVzcy5jb20KPgo+IC0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0K
PiBUaGlzIG1haWwgc2VudCB0aHJvdWdoIElNUDogaHR0cHM6Ly93ZWJtYWlsLmxpbWVncm91cC5j
b20vCj4KPgo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0KPiBUaGlzIFNGLm5ldCBlbWFpbCBpcyBzcG9uc29yZWQgYnk6IFNwbHVuayBJbmMu
IERvIHlvdSBncmVwIHRocm91Z2ggbG9nIGZpbGVzCj4gZm9yIHByb2JsZW1zPyAgU3RvcCEgIERv
d25sb2FkIHRoZSBuZXcgQUpBWCBzZWFyY2ggZW5naW5lIHRoYXQgbWFrZXMKPiBzZWFyY2hpbmcg
eW91ciBsb2cgZmlsZXMgYXMgZWFzeSBhcyBzdXJmaW5nIHRoZSAgd2ViLiAgRE9XTkxPQUQgU1BM
VU5LIQo+IGh0dHA6Ly9zZWwuYXMtdXMuZmFsa2FnLm5ldC9zZWw/Y21kbG5rJmtpZBAzNDMyJmJp
ZCMwNDg2JmRhdBIxNjQyCj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX18KPiBHZW9zZXJ2ZXItdXNlcnMgbWFpbGluZyBsaXN0Cj4gR2Vvc2VydmVyLXVzZXJz
QGxpc3RzLnNvdXJjZWZvcmdlLm5ldAo+IGh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xp
c3RzL2xpc3RpbmZvL2dlb3NlcnZlci11c2Vycwo+Cg==

On Jan 30, 2006, at 12:48, Chris Holmes wrote:

> If someone could ping the wms-dev list that would be great.  I think
> this feature is actually trivially easy for us to implement, unless
> things have changed around, since we had it in the code before.  The
> reason we took it out was to be more spec compliant, but if there's an
> accepted way to do it then we'd be happy to support it.
>
> Allan, do you have any idea why they went with filters instead of just
> including filters in the SLD?  I would have guessed that the =20
> 'official'
> answer would be to just use SLD.

Thinking about this, it may have been because they started doing this =20=

before SLD came into being.

Also, while the official answer could be to just use SLD, it seems to =20=

me that sometimes being able to filter in a WMS without having to go =20
to SLDs could be useful.

There may me more WMS filter proponents out there. Definitely worth =20
pinging wms-dev

	Allan

>
> best regards,
>
> Chris
>
> Quoting Allan Doyle <adoyle@...>:
>
>> Javier,
>>
>> There has been some work with filters in WMS. Ionic was doing this
>> and I suspect others may be, too. The Ionic system I saw was done for
>> the European Space Agency.
>>
>> I'm not sure what they used in terms of parameters. You might try
>> asking the WMS filter question on the wms-dev mailing list.
>>
>> 	Allan
>>
>> On Jan 29, 2006, at 14:30, Javier de la Torre wrote:
>>
>>> Hi Chris,
>>>
>>>
>>>> It's not possible to use filters in the WMS.  You can see more
>> about
>>>> this issue here: http://jira.codehaus.org/browse/GEOS-529  If you
>>>> really want it then vote for the issue.  It shouldn't be all that
>>>> hard
>>>> to implement, and you're right, if things are more efficient with
>>>> Filters, we probably should make them available.
>>>
>>> Yes, specially when handling many features, like in my case
>>> millions, WFS gets useless (unless they implement some paging
>>> mechanism). I suppose the only way is to retrieve lot of data and
>>> not making the client cry for too much data, is through maps and
>> WMS.
>>>
>>> Say it like this, without filters in WMS there is no way to create
>>> clients that access very big data stores and that allow to do
>>> searches based on properties. But OGC has not considered it no?
>>> Maybe the way they are thinking is trough SLD only, but WMS and WFS
>>> can look much more comprehensive if they share things like that. I
>>> suppose I am also too much Geoserver influenced where every data
>>> store is directly served as WFS and WMS making both look so
>> similar.
>>>
>>>>
>>>> There is a bug in for doing better processing of Filters in SLD:
>>>> http://jira.codehaus.org/browse/GEOS-519  You can watch it, it has
>> a
>>>> very high priority for us, should be one of the first things done
>>>> against the new branch...  If someone provides an exact patch of
>> the
>>>> fix it'll be easier for us to roll in.  We used to have code that
>> did
>>>> it, if you check the source of 1.2.x you can probably find it, and
>>>> just
>>>> adapt it to 1.3.x
>>>
>>> I see. That will be already nice! At least I would have a way to do
>>> what I want to do...
>>> But this will start looking more ugly once you start supporting
>>> complex features I suppose. with more complicate data structures
>>> creating the correct filter, or just selecting the necessary
>>> fields, will be more challenging no?
>>>
>>> I am sorry but I can not work well with Java so I don=B4t think I
>>> will be able to fix that... pity... but if I can help with testing
>>> or something I will be happy.
>>>
>>> Javier.
>>>
>>> -------------------------------------------------------
>>> This SF.net email is sponsored by: Splunk Inc. Do you grep through
>>> log files
>>> for problems?  Stop!  Download the new AJAX search engine that
>> makes
>>> searching your log files as easy as surfing the  web.  DOWNLOAD
>>> SPLUNK!
>>> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=1216=
42
>>> _______________________________________________
>>> Geoserver-users mailing list
>>> Geoserver-users@...
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>
>> --
>> Allan Doyle
>> +1.781.433.2695
>> adoyle@...
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: Splunk Inc. Do you grep through
>> log files
>> for problems?  Stop!  Download the new AJAX search engine that makes
>> searching your log files as easy as surfing the  web.  DOWNLOAD
>> SPLUNK!
>> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=12164=
2
>> _______________________________________________
>> Geoserver-users mailing list
>> Geoserver-users@...
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
>
> ***
> Chris Holmes
> The Open Planning Project
> thoughts at: http://cholmes.wordpress.com
>
> ----------------------------------------------------------
> This mail sent through IMP: https://webmail.limegroup.com/
>

--=20
Allan Doyle
+1.781.433.2695
adoyle@...

Thanks Brent!

I see how powerful SLD is :)

The only problem I see is that if Geoserver is right now not passing  
filters in SLD to SQL statements to retrieve features.
That means that I can not set up a column in my database for zoom  
level, or scale, and then filter the features based on this property.  
I will have to create a table for every scale with different features  
no?
And then I have to generate a SLD document that just point to the  
correct layer based on the Max Min Scale Denominators no? How can I  
set up a rule in SLD that has a Max Min thing and a pointer to  
another layer? Is there something like UseLayer element or something  
like this?

Am I getting to complicate? Is there anybody that has created a  
featuretype with more than a million features in a database? How can  
you handle the representation of this data?

Thanks again,

Javier.

On 28/01/2006, at 1:31, Brent Owens wrote:

> This can easily be done with SLDs.
> They allow for many layers, and all you have to do is specify some  
> rules with zoom levels to render different layers.
>
> Often you will see several layers representing the same dataset:  
> very small and simple "zoomed out" layers, mid range layers, and  
> the precise "zoomed in" layers.
>
> Here is a tutorial that covers SLDs and goes into how to use rules:
> http://docs.codehaus.org/display/GEOSDOC/SLD+Intro+Tutorial
> This tutorial talks about more advanced rules, such as zoom levels:
> http://docs.codehaus.org/display/GEOSDOC/ComplexLabelingExample
>
> Here is the rule you are looking for:
>
> <Rule>
> 	<MaxScaleDenominator>52000000</MaxScaleDenominator>
> 	<MinScaleDenominator>800000</MinScaleDenominator>
> 	...
> 	// render the appropriate layer
> 	...
> </Rule>
> // next rules for next layer
>
>
> Brent Owens
> (The Open Planning Project)
>
>
>
> Corey Puffalt wrote:
>
>> I've been looking for a solution to this problem as well but I  
>> can't find anything in the documentation that suggests this is  
>> possible...  Can any experts share their experiences with running  
>> geoserver in production with large datasets?
>>
>> Corey
>>
>> On 1/27/06, *Javier de la Torre* <jatorre@...  
>> <mailto:jatorre@...>> wrote:
>>
>>     Hi all,
>>
>>     Here goes another question :)
>>
>>     I have a very big database with more than 50 million features  
>> stored,
>>     only points. I am playing visualizing this through WMS but as  
>> you can
>>     imagine it gets impossible when retrieving a picture of the whole
>>     world because the 50 million points must be taken from PostGIS  
>> and
>>     processed in order to create the map.
>>
>>     Then I started considering some kind of clustering. Something  
>> like
>>     grouping the points that are near in clusters and present them  
>> as a
>>     single point. I am still considering the clustering  
>> technology, well
>>     I am surfing internet looking for possibilities. Then when I  
>> get to
>>     the point that I have different features to present at different
>>     zooms levels, how can I force geoserver to produce different maps
>>     depending on this zoom level? I can imagine that can be done  
>> using
>>     SLD rules or something like this no? Do you know any place  
>> where I
>>     can find more info about this?
>>
>>     I suppose is the same as some WMS services providing satellite  
>> images
>>     that they provide you different pictures depending on the zoom  
>> level.
>>
>>     Any help on that?
>>
>>     Thanks.
>>
>>     Javier.
>>
>>
>>     -------------------------------------------------------
>>     This SF.net email is sponsored by: Splunk Inc. Do you grep  
>> through
>>     log files
>>     for problems?  Stop!  Download the new AJAX search engine that  
>> makes
>>     searching your log files as easy as surfing the  web.  DOWNLOAD
>>     SPLUNK!
>>     http://sel.as-us.falkag.net/sel? 
>> cmd=lnk&kid=103432&bid=230486&dat=121642
>>     <http://sel.as-us.falkag.net/sel? 
>> cmd=lnk&kid=103432&bid=230486&dat=121642>
>>     _______________________________________________
>>     Geoserver-users mailing list
>>     Geoserver-users@...
>>     <mailto:Geoserver-users@...>
>>     https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>>

Hi Brent,


> You can have several different layers of the same data, and perform =20=

> on the client side which to query. It shouldn't be very difficult =20
> to do that based on the zoom value you have on the client side.
>

But, how can I define different layers on the same data? You mean =20
creating different Data types based on the same database table and =20
apply different rules in the SLD document by default? So, for =20
example, in my table I will have a column called zoom_level to =20
indicate that this record should only be shown in this zoom level, =20
then I create a featuretype called my_layer_at_zoom12 and create an =20
SLD document for it that filter based on the zoom_level property.
Am I right with this?
If so I still have the problem that because filters in SLD documents =20
are post-processed then to generate an image geoserver will retrieve =20
all features from the database.

Other possibility could be to use views in PostgreSQL using this =20
zoom_level and configuring feature types based on them, no?

> We have definitely created data sets with several million entries =20
> and tested it with GeoServer. Everything is great when using WFS, =20
> but WMS you have to handle more of it on the client side and =20
> request generalized layers when zoomed out.
>

I see, but if you go the WFS way when presenting large datasets you =20
have to create pretty robust clients that can handle a lot of =20
features and draw them. And also you have the annoying problem that =20
you don=B4t know if you are getting all features for your query or is =20=

just the limit that the user set in geoserver. And if you want to =20
retrieve 10.000 features and the user limit them to 1.000 there is no =20=

way you will be able to get the other 9.000 no?

That=B4s why I thought that WMS was a better way to handle large =20
datasets, all drawing is done in the server and only when the user =20
click somewhere uses WFS to retrieve info about specific features.

Javier.=

Comments inline:

Javier de la Torre wrote:

> Hi Brent,
>
>
>> You can have several different layers of the same data, and perform  
>> on the client side which to query. It shouldn't be very difficult  to 
>> do that based on the zoom value you have on the client side.
>>
>
> But, how can I define different layers on the same data? You mean  
> creating different Data types based on the same database table and  
> apply different rules in the SLD document by default? So, for  
> example, in my table I will have a column called zoom_level to  
> indicate that this record should only be shown in this zoom level,  
> then I create a featuretype called my_layer_at_zoom12 and create an  
> SLD document for it that filter based on the zoom_level property.
> Am I right with this?
> If so I still have the problem that because filters in SLD documents  
> are post-processed then to generate an image geoserver will retrieve  
> all features from the database.
>
> Other possibility could be to use views in PostgreSQL using this  
> zoom_level and configuring feature types based on them, no?
>
What I mean is, you can create several copies of your data, say 3 or 4, 
and generalize them into smaller, simpler, datasets. So your most zoomed 
in dataset is the origional, complex dataset (in its own table), and the 
most zoomed out dataset is the simplest one with the least amount of data.

When your client script makes a getMap request, it can look at how 
zoomed in you are, and request the different datasets (FeatureType): the 
simplest one for zoomed out, and the original dataset for when it is 
zoomed in. So in the end you will have several FeatureTypes of the data, 
some simpler than the others.
The scale element in SLD is really only useful for filtering before 
rendering, so things look nice; it is not useful for filtering data in 
the query.

To create the different datasets from the one dataset, you will need a 
tool such as FME. There are other tools out there that are free, but I 
cna't remember the names off the top of my head.

Filtering your data on your 'zoom level' column is a good idea, but 
unfortunately it will be done after all the data has been selected in 
the query. Using views is a solution for this problem.

>> We have definitely created data sets with several million entries  
>> and tested it with GeoServer. Everything is great when using WFS,  
>> but WMS you have to handle more of it on the client side and  request 
>> generalized layers when zoomed out.
>>
>
> I see, but if you go the WFS way when presenting large datasets you  
> have to create pretty robust clients that can handle a lot of  
> features and draw them. And also you have the annoying problem that  
> you don´t know if you are getting all features for your query or is  
> just the limit that the user set in geoserver. And if you want to  
> retrieve 10.000 features and the user limit them to 1.000 there is no  
> way you will be able to get the other 9.000 no?
>
> That´s why I thought that WMS was a better way to handle large  
> datasets, all drawing is done in the server and only when the user  
> click somewhere uses WFS to retrieve info about specific features.

It is better to do the rendering on the server side with WMS, so the 
data passed to the client is minimal. And so you don't have to write 
your own renderer.
If you are worred about your users modifying the number of features 
returned, just don't let them specify the number. You can always set the 
max_features_returned value to be larger than your dataset and will get 
every row returned, if that is what was selected in the query.

>
> Javier.


Brent Owens
(The Open Planning Project)