Hi Olle, Andrea,

I was looking at the Microsoft JDBC driver docs this weekend and noticed that the MS driver now actually has both a Geometry and a Geography class now that provide both a STGeomFromText(String wkt, int SRID) and a STGeomFromWKB(byte[] wkb) method [1] as well as STAsBinary()/STAsText() methods so going back-and-forth to eg a JTS geometry should be a breeze.

It may be worth considering a new module or dialect that leverages the possibilities that the JDBC driver exposes instead of continuing on the old path of decoding shapes, segments and figures from the binary data which gets increasingly difficult with compound objects.

This may mean dropping support for sqlserver 2014 and definitely the jdts driver, het good thing is that the Microsoft driver is now available in Maven Central[2] and available as Open Source[3] (MIT licensed) so no hassle with separate downloads and installs.

[1] https://docs.microsoft.com/en-us/sql/connect/jdbc/use-spatial-datatypes?view=sql-server-2017

[2] https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017

[3] https://github.com/Microsoft/mssql-jdbc


On 07-06-18 18:14, Olle Markljung wrote:
Hehe yeah I understand :)

I’ll try to make the estimate myself.

/Olle


tors 7 juni 2018 kl. 17:28 skrev Andrea Aime <andrea.a...@geo-solutions.it <mailto:andrea.a...@geo-solutions.it>>:

    Hi Olle,
    I have them, but we don't discuss estimates outside of private
    business inquiries, sorry :-)
    That said, estimates are personal, they change depending on
    experience, topic and the like, so
    they would not be much use anyways.

    If you decide you want someone else to do it for you, you can
    contact commercial support providers
    to get an estimate:
    http://geoserver.org/support/

    Cheers
    Andrea


    On Thu, Jun 7, 2018 at 4:46 PM, Olle Markljung <marklj...@gmail.com
    <mailto:marklj...@gmail.com>> wrote:

        Hi Andrea and Mark

        Thank you for the swift response!

        Andrea, do you have a ballpark number of hours it took to
        implement the support for curves in Oracle or PostGIS?

        Mark, did you have an estimation to complete the work you started?

        If I don’t find the time myself I’ll try to find funding and
        seek commercial help and then it would be great to have a
        ballpark number to start with.

        Regards,
        Olle Markljung

        tors 7 juni 2018 kl. 14:58 skrev Mark Prins <mc.pr...@gmail.com
        <mailto:mc.pr...@gmail.com>>:

            On 07-06-18 13:32, Olle Markljung wrote:
             > Hello all
             >
             > I have users that would be helped if curve support for
            SQL Server became
             > real.
             > I'm not sure if the implementation is needed in GeoServer
            or GeoTools
             > but I reach out here first.
             >
             > Are there others also seeking this support?

            Ik had a look into this some years ago but our funding
            evaporated, so it
            stranded, see https://osgeo-org.atlassian.net/browse/GEOT-5512

            some unfinished work is in:
            
https://github.com/mprins/geotools/commit/e43286e7bae7101af0dad4edbee40f99ca81d4eb

            docs are available at:
            
https://msdn.microsoft.com/en-us/library/ee320858%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396

            Mark

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

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


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

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




--
    Regards, Andrea Aime == GeoServer Professional Services from the
    experts! Visit http://goo.gl/it488V for more information. == Ing.
    Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di
    Montramito 3/A 55054 Massarosa
    
<https://maps.google.com/?q=Via+di+Montramito+3/A%0D%0A55054++Massarosa&entry=gmail&source=g>
    (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339
    8844549 http://www.geo-solutions.it
    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./



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

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

Reply via email to