SQL Server plugin/extension

[asneuvon]

Hello all,

We unfortunately still have some of our spatial data in SQL Server and probably will for a long time to come, so I just wanted to check: the SQL Server data type “geography” is not supported by GeoServer’s SQL Server extension and we should instead use “geometry”?

Not complaining or asking for changes, simply checking I’m up to speed on this

Thanks,
Sam

[aaime-geosolutions]

Hi Samuli,
that seems to be the case… in the whole codebase for the SQL Server
plugin I only see one mention of
“geography”.

SQL Server is one of those commercial database plugins that gets any change
done only when there is
sponsoring on the table, hard to imagine an open source developer taking a
Sunday off to work on it.
That said, both funding and code contributions are more than welcomed.
While waiting for someone to step up and implement comprehensive geography
support,
using “geometry” seems the way to go, indeed.

Cheers,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit GeoSolutions Enterprise Support Services for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

GeoSolutions

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

On Tue, Sep 17, 2024 at 10:16 AM Samuli Neuvonen via OSGeo Discourse <
noreply@discourse.osgeo.org> wrote:

asneuvon https://discourse.osgeo.org/u/asneuvon
September 17

Hello all,

We unfortunately still have some of our spatial data in SQL Server and
probably will for a long time to come, so I just wanted to check: the SQL
Server data type “geography” is not supported by GeoServer’s SQL Server
extension and we should instead use “geometry”?

Not complaining or asking for changes, simply checking I’m up to speed on
this [image: ]

Thanks,
Sam

Visit Topic
https://discourse.osgeo.org/t/sql-server-plugin-extension/50931/1 or
reply to this email to respond.

To unsubscribe from these emails, click here
https://discourse.osgeo.org/email/unsubscribe/34b0ce17a7d481c554f663647db24b231b2c1df2b64318f09e9d55d61ef8b42d
.