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.
_______________________________________________
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
