6 Replies Latest reply on Aug 6, 2007 12:32 AM by Newsgroup_User

    GIS Coldfusion Google Maps Spatial MySQL

    jcrip
      Anybody dealing with GIS Coldfusion Google Maps Spatial MySQL?
        • 1. Re: GIS Coldfusion Google Maps Spatial MySQL
          Level 7
          jcrip wrote:
          > Anybody dealing with GIS Coldfusion Google Maps Spatial MySQL?

          GIS? yes, maily cf/arcIMS/mapServer & flex
          google maps? yes, sometimes w/flex
          spatial mySQL? nope, not if i can help it. if you have a need for spatial data
          handling i would strongly recommend postGIS/postgres instead. much more mature,
          way more functionality, etc.
          • 2. Re: GIS Coldfusion Google Maps Spatial MySQL
            jcrip Level 1
            Have you had any experience with Oracle Spatial? How does it compare to postGIS/postgres?
            • 3. Re: GIS Coldfusion Google Maps Spatial MySQL
              Level 7
              jcrip wrote:
              > Have you had any experience with Oracle Spatial? How does it compare to postGIS/postgres?

              it's not free ;-)
              • 4. Re: GIS Coldfusion Google Maps Spatial MySQL
                Level 7
                jcrip wrote:
                > Have you had any experience with Oracle Spatial? How does it compare to postGIS/postgres?

                i suppose that answer was a bit too flippant ;-) no we've never really used
                oracle's spatial bits just w/arcSDE.

                what are you trying to do?
                • 5. Re: GIS Coldfusion Google Maps Spatial MySQL
                  jcrip Level 1
                  I found your first answer succinct. Working on two projects one for work - Oracle question and playing around with my personal web site mySQL and Google maps.

                  Just trying to get a feel for what is hype and what is real about spatial databases. At work we are installing ArcSDE now.
                  • 6. Re: GIS Coldfusion Google Maps Spatial MySQL
                    Level 7
                    jcrip wrote:
                    > I found your first answer succinct. Working on two projects one for work -
                    > Oracle question and playing around with my personal web site mySQL and Google
                    > maps.

                    i found mysql's spatial bits limited (for instance, if i recall right, it's
                    early point-in-polygon searches were simple bounding box, which is kind of iffy
                    for really complex polygons) compared to postGIS.

                    > Just trying to get a feel for what is hype and what is real about spatial
                    > databases. At work we are installing ArcSDE now.

                    not sure what you mean, "what is hype and what is real about spatial databases"?
                    they all do pretty much what they're supposed to do, some betters than others.
                    some have more "value" than others--when you get into big GIS applications, s/w
                    cost isn't a really big "value" issue, the data & what you're managing usually
                    cost 1000x what the s/w cost. some work more easily w/cf than others but all the
                    ones i have used can work w/it one way or another.