[Geoserver-users] Import geojson from Postgis to GeoServer

Hello, I am having some troubles with the rest API of importing geojson from Postgres PostGIS database to Geoserver to create layer and register to WFS services.
Are there any ways we can do it?
Thank you

Hi,

Confusing questions. Please elaborate more on what you want to do…

Samann Long <longsamann16@anonymised.com> escreveu no dia terça, 28/01/2020 à(s) 06:12:

···

www.vfonsecaz.pt

The obvious way to do this is to skip the geojson and just add the PostGIS tables as new layers, you can export them from GeoServer as GeoJSON using WFS if you want.

Ian

···

Ian Turton

This makes me wonder if it’s more efficient to export geojason from wfs or directly from PG. Currently I’m going to the database for this in my web applications.
Vera

On Wed., Jan. 29, 2020, 3:58 a.m. Ian Turton, <ijturton@anonymised.com> wrote:

The obvious way to do this is to skip the geojson and just add the PostGIS tables as new layers, you can export them from GeoServer as GeoJSON using WFS if you want.

Ian

On Wed, 29 Jan 2020 at 09:48, Vitor Fonseca <vfonsecaz@anonymised.com> wrote:

Hi,

Confusing questions. Please elaborate more on what you want to do…

Samann Long <longsamann16@anonymised.com> escreveu no dia terça, 28/01/2020 à(s) 06:12:

Hello, I am having some troubles with the rest API of importing geojson from Postgres PostGIS database to Geoserver to create layer and register to WFS services.
Are there any ways we can do it?
Thank you


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

www.vfonsecaz.pt


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Ian Turton


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Yes, you can do that. But then you are responsible for working out the bounding box or any filters that the user would like while if you go via GeoServer you don’t have to write and debug all that code. Also if you stick with an international standard you can switch clients with no effort rather than starting from scratch each time. Remember GeoServer does a lot more for you than just return the data.

Ian

···

Ian Turton

Sorry…even if we are retreating the data as geojason with the end goal of pushing it back to PG with user edits.

Especially then, that is what WFS-T was designed for. Or are you going to write a state of the art authentication and authorisation system that can interact with active directory or just allow any passing hacker delete your data?

Ian

···

Ian Turton

Haha…yes the authentication has been…not fun. We are integrating it with active directory.
Thanks, will investigate. Any doc’s you recommend would be appreciated.
V

On Wed., Jan. 29, 2020, 9:24 a.m. Ian Turton, <ijturton@anonymised.com> wrote:

On Wed, 29 Jan 2020 at 16:12, Vera Green <vera.green.ca@anonymised.com> wrote:

Sorry…even if we are retreating the data as geojason with the end goal of pushing it back to PG with user edits.

Especially then, that is what WFS-T was designed for. Or are you going to write a state of the art authentication and authorisation system that can interact with active directory or just allow any passing hacker delete your data?

Ian

V

On Wed., Jan. 29, 2020, 9:10 a.m. Vera Green, <vera.green.ca@anonymised.com4…> wrote:

Thanks. Even if our end goal is editing the data you would recommend going through WFS?
V

On Wed., Jan. 29, 2020, 9:01 a.m. Ian Turton, <ijturton@anonymised.com> wrote:

Yes, you can do that. But then you are responsible for working out the bounding box or any filters that the user would like while if you go via GeoServer you don’t have to write and debug all that code. Also if you stick with an international standard you can switch clients with no effort rather than starting from scratch each time. Remember GeoServer does a lot more for you than just return the data.

Ian

On Wed, 29 Jan 2020 at 15:55, Vera Green <vera.green.ca@anonymised.com> wrote:

This makes me wonder if it’s more efficient to export geojason from wfs or directly from PG. Currently I’m going to the database for this in my web applications.
Vera

On Wed., Jan. 29, 2020, 3:58 a.m. Ian Turton, <ijturton@anonymised.com> wrote:

The obvious way to do this is to skip the geojson and just add the PostGIS tables as new layers, you can export them from GeoServer as GeoJSON using WFS if you want.

Ian

On Wed, 29 Jan 2020 at 09:48, Vitor Fonseca <vfonsecaz@anonymised.com> wrote:

Hi,

Confusing questions. Please elaborate more on what you want to do…

Samann Long <longsamann16@anonymised.com> escreveu no dia terça, 28/01/2020 à(s) 06:12:

Hello, I am having some troubles with the rest API of importing geojson from Postgres PostGIS database to Geoserver to create layer and register to WFS services.
Are there any ways we can do it?
Thank you


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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@anonymised.comourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

www.vfonsecaz.pt


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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@anonymised.comourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Ian Turton


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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@anonymised.comourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Ian Turton

Ian Turton

There is a full tutorial at https://docs.geoserver.org/latest/en/user/security/tutorials/activedirectory/index.html which gives you an example LDAP set up to work with while you get the hang of it.

Ian

···

Ian Turton

Oh…yes thank you. We have that part working :grin:. But we haven’t used WFS-T. So far we are just using WMS in leaflet.
V

On Wed., Jan. 29, 2020, 10:34 a.m. Ian Turton, <ijturton@anonymised.com> wrote:

There is a full tutorial at https://docs.geoserver.org/latest/en/user/security/tutorials/activedirectory/index.html which gives you an example LDAP set up to work with while you get the hang of it.

Ian

On Wed, 29 Jan 2020 at 17:18, Vera Green <vera.green.ca@anonymised.com> wrote:

Haha…yes the authentication has been…not fun. We are integrating it with active directory.
Thanks, will investigate. Any doc’s you recommend would be appreciated.
V

On Wed., Jan. 29, 2020, 9:24 a.m. Ian Turton, <ijturton@anonymised.com> wrote:

On Wed, 29 Jan 2020 at 16:12, Vera Green <vera.green.ca@anonymised.com> wrote:

Sorry…even if we are retreating the data as geojason with the end goal of pushing it back to PG with user edits.

Especially then, that is what WFS-T was designed for. Or are you going to write a state of the art authentication and authorisation system that can interact with active directory or just allow any passing hacker delete your data?

Ian

V

On Wed., Jan. 29, 2020, 9:10 a.m. Vera Green, <vera.green.ca@anonymised.com> wrote:

Thanks. Even if our end goal is editing the data you would recommend going through WFS?
V

On Wed., Jan. 29, 2020, 9:01 a.m. Ian Turton, <ijturton@anonymised.com> wrote:

Yes, you can do that. But then you are responsible for working out the bounding box or any filters that the user would like while if you go via GeoServer you don’t have to write and debug all that code. Also if you stick with an international standard you can switch clients with no effort rather than starting from scratch each time. Remember GeoServer does a lot more for you than just return the data.

Ian

On Wed, 29 Jan 2020 at 15:55, Vera Green <vera.green.ca@anonymised.com> wrote:

This makes me wonder if it’s more efficient to export geojason from wfs or directly from PG. Currently I’m going to the database for this in my web applications.
Vera

On Wed., Jan. 29, 2020, 3:58 a.m. Ian Turton, <ijturton@anonymised.com> wrote:

The obvious way to do this is to skip the geojson and just add the PostGIS tables as new layers, you can export them from GeoServer as GeoJSON using WFS if you want.

Ian

On Wed, 29 Jan 2020 at 09:48, Vitor Fonseca <vfonsecaz@anonymised.com> wrote:

Hi,

Confusing questions. Please elaborate more on what you want to do…

Samann Long <longsamann16@anonymised.com> escreveu no dia terça, 28/01/2020 à(s) 06:12:

Hello, I am having some troubles with the rest API of importing geojson from Postgres PostGIS database to Geoserver to create layer and register to WFS services.
Are there any ways we can do it?
Thank you


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

www.vfonsecaz.pt


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Ian Turton


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Ian Turton

Ian Turton

Ian Turton