GIS Coldfusion Google Maps Spatial MySQL

[Guest]

Anybody dealing with GIS Coldfusion Google Maps Spatial MySQL?

[Newsgroup_User]

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.

[Guest]

Have you had any experience with Oracle Spatial? How does it compare to postGIS/postgres?

[Newsgroup_User]

jcrip wrote:
> Have you had any experience with Oracle Spatial? How does it compare to postGIS/postgres?

it's not free ;-)

[Newsgroup_User]

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?

[Guest · Accepted solution]

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.

[Newsgroup_User]

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.