Re: R: [Geoserver-users] views of PostgreSQL in Geoserver

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

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 <ch...@op...> 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 <la...@ho...> 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
> > > Geo...@li...
> > > 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
> > Geo...@li...
> > 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
> > Geo...@li...
> > 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/
>