Did a mistake, I thought we were in GeoServer ML. However, the JsonPointer function (which is used by GeoServer) provides support for accessing PostGIS JSON column values.
On Sun, Oct 17, 2021 at 8:30 PM Nuno Oliveira < nuno.olive...@geosolutionsgroup.com> wrote: > Hi Alessandro, > just wanted to point out that there is already support in GeoServer for > PostgreSQL JSON columns: > > https://docs.geoserver.org/latest/en/user/data/database/postgis.html#jsonpointer-function-support > > Hope it helps, > Nuno Oliveira > > On Wed, Oct 13, 2021 at 2:05 AM Alessandro Ferrucci < > alessandroferru...@gmail.com> wrote: > >> Hello - >> >> I have a need of taking a shapefile and loading it into a PostGIS >> database table. Some of the attributes from the shapefile translate into >> columns on the postgis database table, while others will be stuffed inside >> a JSON column as a key value pair as: {"AttributeName": AttributeValue.....} >> >> I would need to do 2 things: >> >> 1) Create a FeatureTypeBuilder that is able to specify a >> Map<String,Object> attribute and >> 2) Define a FeatureSource that is able to translate the >> Map<String,Object> attribute to a Postgres JSON data type. >> >> I have a few questions. >> Are the 2 steps I have outlined above correct? >> >> If so - would someone have a suggestion of where to find pointers as to >> how to implement this? >> >> Kind regards, >> Alessandro >> _______________________________________________ >> GeoTools-GT2-Users mailing list >> GeoTools-GT2-Users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users >> > > > -- > > Regards, > > Nuno Oliveira > > == > GeoServer Professional Services from the experts! > > Visit http://bit.ly/gs-services-us for more information. > == > > Nuno Miguel Carvalho Oliveira > @nmcoliveira > Technical Lead / Project Manager > > > GeoSolutions Group > phone: +39 0584 962313 > fax: +39 0584 1660272 > > https://www.geosolutionsgroup.com/ > http://twitter.com/geosolutions_it > ------------------------------------------------------- > > > Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE > 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si > precisa che ogni circostanza inerente alla presente email (il suo > contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è > riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il > messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra > operazione è illecita. Le sarei comunque grato se potesse darmene notizia. > > This email is intended only for the person or entity to which it is > addressed and may contain information that is privileged, confidential or > otherwise protected from disclosure. We remind that - as provided by > European Regulation 2016/679 “GDPR” - copying, dissemination or use of this > e-mail or the information herein by anyone other than the intended > recipient is prohibited. If you have received this email by mistake, please > notify us immediately by telephone or e-mail. > -- Regards, Nuno Oliveira == GeoServer Professional Services from the experts! Visit http://bit.ly/gs-services-us for more information. == Nuno Miguel Carvalho Oliveira @nmcoliveira Technical Lead / Project Manager GeoSolutions Group phone: +39 0584 962313 fax: +39 0584 1660272 https://www.geosolutionsgroup.com/ http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.
_______________________________________________ GeoTools-GT2-Users mailing list GeoTools-GT2-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
