Re: [Geoserver-users] WFS layer with "location"

[geseus]

Hi, thanks for reply .. so once again without formatting .. 

Hi, 

Im using Geoserver and PostGis .. 

On database i have table "Coordinate" ("Id", "X", "Y", "AddressId",
"RootId", ...)
I also have  materialized view, wich is updated periodically:

create materialized view "geoCoordinate"
select "RootId", "AddressId", "Location" as "Location-3067",
st_transform("Location", 4326) as "Location-4326"
from (
select "Id", "RootId", "AddressId", st_setsrid(st_point("X", "Y"),
3067)::geometry(Point,3067) as "Location"
from "Coordinate") t
with data;

If I create a layer "geoCoordinate-1" via "Configure new SQL view..." and
use this select:

select "AddressId" as "addressId", "RootId" as "rootId", "Location-4326" as
"point"
from "geoCoordinate"

Then, when i check DescribeFeatureType:
http://localhost:8080/geoserver/wfs?service=WFS&request=DescribeFeatureType&version=1.1.0&typeName=lge:geoCoordinate-1

the result is: 

http://test-namespace.fi/lge";>
  http://www.opengis.net/gml";
schemaLocation="http://localhost:8080/geoserver/schemas/gml/3.1.1/base/gml.xsd"/>
  


  



  
  

  
  



BUT, if I create a layer "geoCoordinate-2" via "Configure new SQL view..."
and use this select:

select "AddressId" as "addressId", "RootId" as "rootId", "Location-4326" as
"location"
from "geoCoordinate"
NOTE: i just changed word "point" to the word "location"

Then the result of DescribeFeatureType:
http://localhost:8080/geoserver/wfs?service=WFS&request=DescribeFeatureType&version=1.1.0&typeName=lge:geoCoordinate-2
is:

http://test-namespace.fi/lge";>
  http://www.opengis.net/gml";
schemaLocation="http://localhost:8080/geoserver/schemas/gml/3.1.1/base/gml.xsd"/>
  

  

  
  

  

  
  


Element "location" is missing schema. But when I use GetFeature request, the
"locations" are correctly shown in the result.

Why does it happen? Is the "location" some keyword? Is it possible to use
word "location" somehow as a column name of the select (and the element of
the layer)?

Thanks a lot,
Tomas
 



--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html


___
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

[Geoserver-users] WFS layer with "location"

[geseus]

Hi, 

Im using Geoserver and PostGis .. 

On database i have table 
I also have  materialized view, wich is updated periodically: 


If I create a layer /"geoCoordinate-1"/ via /"Configure new SQL view..."/
and use this select:


Then, when i check /DescribeFeatureType:
http://localhost:8080/geoserver/wfs?service=WFS&request=DescribeFeatureType&version=1.1.0&typeName=lge:geoCoordinate-1/

the result is: 


BUT, if I create a layer /"geoCoordinate-2"/ via /"Configure new SQL
view..."/ and use this select:

NOTE: i just changed word /"point"/ to the word /"location"/ in the select.

Then the result of DescribeFeatureType:
/http://localhost:8080/geoserver/wfs?service=WFS&request=DescribeFeatureType&version=1.1.0&typeName=lge:geoCoordinate-2/
is:


Element /"location"/ is missing in the schema. But when I use /GetFeature/
request, the /locations/ are correctly in the result.
Why does it happen? Is the /"location"/ some keyword? Is it possible to use
word /"location"/ somehow as a column name of the select (and the element of
the layer)?

Thanks a lot,
Tomas



--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html


___
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

[Geoserver-users] Parametrize DB connection (PostGIS)

[geseus]

Hi, is it possible to parametrize values for PostGIS datastore in
datastore.xml file (like for eg. app-schemas)?

I'm using PostGIS as a database, and would like to have datastore.xml like:


  test_datastore
  dbStore
  ${test.datasource.description}
  PostGIS
  true
  
test_workspace
  
  
${test.database.host}
${test.database.port}
${test.database.name}
${test.database.schema}
${test.database.user}
${test.database.password}
false
false
false
false
false
false
false
false
false
  
  <__default>false



.. but I do not know where/how I should place *.properties file; or how to
set up configuration.

Thanks a lot,
T.




--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html


___
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

[Geoserver-users] Mapping PostGis geometry to app schema

[geseus]

Hi, 
is it possible to use geometry type from PostGis in app schema?

I have view in postgre db: 


Then i have schema:



App schema mapping is defined as:



But when a call WFS service, there is empty  Geom element in the result:


So, how can i map postGis geometry type to element in app schema?

Thanks a lot, 
Tomas





--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

--
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

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] WFS nesting

[geseus]

files.zip   

Hi, 

I'm trying to do wfs with nested elements, but without success. 
I have 3 postgres tables: person, email, web.
I'm able to join them, so output is like:


  
.. person elements

  email 1 elements


  email 2 elements

..

  web 1 elements


  web 2 elements


...

But I would like to have web and email info nested like this:

  
.. person elements

>>> HOW TO ADD THIS ELEMENT?


>>> AND THIS ELEMENT?
  

  email 1 elements


  email 2 elements

  
  

  web 1 elements

  
  
I do not know, how to create schema files and feature_link for that.

And another question, i have three xml files, which contain the same
datastores with exactly the same connection to database.
Is it possible to define connection/datastore otside and include it somehow
(so i have connection defined only once).
And is it posible to crypt the password like this?
crypt1:SNtjcptw+CrnShpSnfw6hPBxUpGhWbIs 
(this doesnt work for me)

All files im using are (hopefully) attached as a zip.
Thanks a lot for any advice.
Tomas



--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

--
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

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users