Updated: You Can’t Edit Spatial RDBMS with ArcGIS for Desktop without SDS

August 18, 2011 Leave a Comment

So the answer is… No.

[via Bill Dollins](http://blog.geomusings.com/2011/08/17/so-which-is-it/#more-1950)

From the Esri Support Forums: [Edit spatial data with "ArcGIS for Desktop 10.1" in non-SDE RDBMS systems?](http://forums.arcgis.com/threads/35676-Edit-spatial-data-with-quot-ArcGIS-for-Desktop-10.1-quot-in-non-SDE-RDBMS-systems)

>ArcGIS Server 10.1 will include a new technology component called Spatial Data Server (SDS). It is a separate installation from ArcGIS Server and will be included with all editions of ArcGIS Server. SDS is a low-memory footprint application that enables you to publish feature services of your vector data stored in a database or geodatabase. SDS will allow you to edit spatial data in a standard database and does not require ArcSDE technology. Editing for SDS is done via the REST API only which ArcMap does not support at this time [editors note: see below].

Oh snap, not only can you not edit spatial data in other RDBMS without Esri’s Spatial Data Server, you can’t even do it via ArcGIS for Desktop. [editors note: see below] To be fair though, Esri’s business model is built on being the middle man to everything.

>`I don’t know how this whole business started
Of me thinkin’ that I could edit PostGIS
But if you think that we’d be better parted
It’s gonna hurt me but I’ll break away from you`

The latest:

Craig Williams clarifies a [key point](http://forums.arcgis.com/threads/35676-Edit-spatial-data-with-quot-ArcGIS-for-Desktop-10.1-quot-in-non-SDE-RDBMS-systems?p=127134&viewfull=1#post127134):

>Derek’s comments about ArcGIS for Desktop 10.1 not being able to edit SDS are incorrect. ArcGIS for Desktop 10.1 can edit SDS and all other types of ArcGIS feature services. These edits are performed via the REST API for SDS and hosted feature services.

So what does that mean? [Says Craig](https://twitter.com/williamscraigm/status/104240198744940545)

> you connect to SDS, drag the service into the map and it draws via REST calls. To edit you check out / check in

So the final word on this is that you still need middleware to get this done, but you don’t need ArcSDE anymore. Esri views editing spatial databases differently that many of us do, I don’t fault their thinking too much on this, but 99.9% of the time in the real world no one cares about deltas. So to fix my thoughts from above:

Oh snap, you can’t edit spatial data in other RDBMSs without Esri’s Spatial Data Server.

Filed under GIS Tagged with , , ,

ESRI Releases ArcGIS 9.3.1 Service Pack 2

July 9, 2010 1 Comment

A quick push out the door before the UC.

ArcGIS (Desktop, Engine, Server) 9.3.1 Service Pack 2

ArcSDE 9.3.1 Service Pack 2

ArcIMS 9.3.1 Service Pack 2

ArcGIS Image Server 9.3.1 Service Pack 2

You can also see a list of the issues addressed with this Service Pack.

Filed under GIS Tagged with , , , , , ,

Open Source Friday!

April 23, 2010 3 Comments

Basically I have no idea where the week went. As you can probably tell I’ve been very busy and thus there isn’t much time for blogging about how much I love the shapefile format. In the meantime there is some good open source news you probably need to be aware of.

  • OpenLayer 2.9 Released – Follow that link for the full details, but the take-away from the ESRI DevSummit was if you are doing cool stuff with the ESRI REST API, you are probably doing it in OpenLayers. Why code with something else?
  • zigGIS 3.0 – The defacto tool to access PostGIS from ArcGIS is now open source again. Well it is more complicated than that, but Abe Gillespie has the details on his blog. Basically the project is going to be moving forward with some very cool stuff planned. I’m excited as it makes zero sense to buy ArcSDE to access PostGIS.
  • The R Project – now this isn’t a specific news item, just a reminder that there is a kick ass statistical open source project screaming for you to use it. At the URISA conferences I was at the last two weeks, it appears many don’t know about all the cool stuff you can do with it. My favorite book on learning R (and other open source analytical tools) is Baseball Hacks. ESRI has been showcasing using R with their python tools so you should really want to get into it, just a freaking sweet project. Now if you want to see some geospatial use of R, check out Dylan Beaudette’s blog where he’s been showcasing some cool uses of R.

Anyway, have a great weekend folks. I’ll see some of you next week at GITA 2010. Play me out Joe Morello.

Filed under GIS Tagged with , , , , , ,

Git Yer ArcGIS 9.3.1 Service Pack 1

December 14, 2009 3 Comments

Yep, the service pack to the .1 release is here:

ArcGIS (Desktop, Engine, Server) 9.3.1 Service Pack 1
ArcSDE 9.3.1 Service Pack 1
ArcIMS 9.3.1 Service Pack 1
ArcGIS Image Server 9.3.1 Service Pack 1

UPDATE: Yikes, I left off ArcGIS Military Analyst 9.3.1 Service Pack 1

You can learn more on the “Issues addressed with Service Pack 1” page. I can’t think of any other way to celebrate than dear old Rocky Top…

ArcGIS, you’ll always be home to me…

Filed under GIS Tagged with , , , , , , , , ,

Depreciation plans for ArcGIS 9.3.1 with a little what’s coming in 9.4

September 14, 2009 27 Comments

ESRI has an updated FAQ which outlines depreciation plans for the 9.3.1 release and what is coming at 9.4.  Some key highlights:

ArcGIS Desktop 9.3.1

  • ArcGIS 9.3.1 contains the last release of the Crystal Report Wizard in ArcGIS Desktop; we will no longer provide this technology in ArcGIS 9.4.  Much more here (http://www.spatiallyadjusted.com/2009/07/15/esri-arcgis-9-4-reports-updates/).
  • ArcGIS 9.3.1 was the last release supporting Microsoft Visual Basic 6 (VB6).  All I can say is move on guys…
  • ArcGIS 9.3.1 was the last release supporting the Microsoft Windows 2000 operating system for all ArcGIS products. Please anyone tell me they are still running Win2k.  I’d love to know.
  • ArcGIS 9.3.1 was the last release supporting Microsoft Visual Studio 2005.
  • ArcGIS 9.3.1 was the last release to support Internet Explorer 6 (IE6); we will no longer support this browser with the release after ArcGIS 9.3.1.  w00t!
  • ArcGIS 9.3.1 was the last release supporting Sun Solaris 9 for ArcReader and ArcGIS Engine.  We are all running Solaris 10, right?

ArcGIS Workstation 9.3.1

  • ArcGIS 9.3 was the last release of ArcInfo Workstation on AIX; we will no longer support this platform at ArcGIS 9.4. We are dropping this platform as we no longer see demand for it.  *side note: I don’t miss AIX at all!

ArcIMS 9.3.1

  • ArcGIS 9.3.1 was the last release of the ArcMap Server Extension to ArcIMS; we will no longer provide it in ArcGIS 9.4 release.  So if you want to roll MXDs, you have to use ArcGIS Server 9.4.
  • ArcGIS 9.3.1 was the last release of ArcIMS on HP-UX; we no longer support it in ArcGIS 9.4. HP-UX is not a popular platform for ArcIMS and will be retired due to limited demand.  So you HP-UX users have no one to blame but yourselves for letting the rest of us abandon the platform.  But don’t feel too bad because ESRI will continue to support ArcSDE technology on HP-UX on the Itanium processor.

ArcGIS Server 9.3.1

  • ArcGIS 9.3.1 was the last release of ArcSDE for Oracle 9i. We no longer support it in ArcGIS 9.4 due to this platform no longer being actively supported by Oracle.  Sounds like fighting words to me…
  • Solaris 9 is dropped, but you can still roll ArcSDE on it.
  • See IE 6 note above.

The Tragic Prelude beyond ArcGIS 9.4

ArcGIS Desktop 9.4

  • ArcGIS 9.4 will be the last release of Microsoft Visual Basic for Applications (VBA); we will no longer support VBA beyond the ArcGIS 9.4 release. Microsoft no longer promotes or updates VBA.   So unless you want to be like your VB6 friends, time to move on.
  • ArcGIS 9.4 will be the last release of Solaris support for ArcReader and ArcGIS Engine; we will no longer support the Solaris platform for this functionality beyond ArcGIS 9.4 due to limited demand for this platform.  So if you migrated from Solaris 9 to run 9.4, know that it was all a wasted effort because 9.4 drops Solaris support for ArcReader and ArcGIS Engine.

ArcGIS Workstation 9.4

  • At ArcGIS 9.4, ArcInfo Workstation will be decoupled from ArcGIS Desktop 9.4, so users will be able to upgrade to newer versions of ArcGIS Desktop without impacting ArcInfo Workstation.  See any writing on that wall?
  • At ArcGIS 9.4 ArcInfo Workstation will be supported on Windows 7 (this will be the last expected Windows platform upgrade). I see the end don’t you?
  • ArcGIS 9.4 will be the last release of ArcInfo Workstation on Solaris; we will no longer support this platform after ArcGIS 9.4.  So the abandonment of Solaris by ESRI users is just about complete.
  • The next major release after ArcGIS 9.4 will be the last planned release for ArcInfo Workstation on Windows, which will be the last supported platforms. Users will continue to be able to use their existing versions, but we will not release newer versions.  Ah there it is, the end of ArcInfo Workstation is here.

ArcIMS 9.4

  • ArcGIS 9.4 will be the last release of ArcIMS on Solaris; we will no longer support it after ArcGIS 9.4.
  • The next major release after ArcGIS 9.4 will be the last planned release for ArcIMS on Windows and Linux, which are the last supported platforms.  So there you go, more writing on the wall.  ArcIMS is near the end.  Time to move on folks.

ArcGIS Server 9.4

  • ArcGIS 9.4 will be the last ArcGIS Server release with support for Solaris (with the exception of the ArcSDE technology component); we will not support this platform after ArcGIS 9.4 due to limited demand for the Solaris server platform. We will continue to support the ArcSDE component of ArcGIS Server on the Solaris platform beyond the ArcGIS 9.4 release. So essentially after 9.4, only ArcSDE will be supported on Solaris.

Filed under GIS Tagged with , , , , , , , , , , ,

ArcGIS 9.3.1 Roundup

May 4, 2009 12 Comments

Well got my copy late last week and others are reporting that they’ve received it as well.  9.3.1 isn’t revolutionary, more evolutionary in nature so there isn’t that, “I MUST HAVE IT” feeling with it.  And you know what?  That is exactly what we need at this point, a nice solid release.

Some blog posts about 9.3.1:

I’m sure we’ll see more information in the next week.  Remember you can get the “What’s new in 9.3.1″ from ESRI’s servers.  We haven’t installed it yet, but hopefully there will be a chance later this week.

ArcGIS 9.3.1 is on its way. YEAH!

ArcGIS 9.3.1.... YEAH!

Filed under GIS Tagged with , , , , , , , , , ,

RESTful GeoServer 1.7.3

March 11, 2009 2 Comments

On the heels of the 1.7.2 release, GeoServer 1.7.3 is now out.   Improvements to ArcSDE Raster support, RESTful interface, Excel support and of course GeoWebCache.  You know you want to get some of this…

Horray GIS!

Horray GIS!

Filed under GIS Tagged with , , , , , , , ,

ArcGIS 9.2 SP6 Released

July 18, 2008 3 Comments

ESRI has released ArcGIS 9.2 SP6. All those who are unlucky enough to be working though the weekend can get ahead of the rest of us who will spend out Monday morning downloading and installing SP6 on our our workstations.

Me?  I’ll be on the couch all weekend watching the British Open.

Some where their ESRI T-Shirt while climbing mountains, I wear it while watching golf.

Some wear their ESRI T-Shirt while climbing mountains, I wear it while watching golf.

Filed under GIS Tagged with , , , , , , ,

Now you can have direct connections to ArcSDE geodatabases

July 9, 2008 2 Comments

One of the more interesting features ESRI has rolled out lately is the ability to connect to geodatabases that aren’t the same release. Now ArcGIS 9.2 SP5 or SP6 clients can make connections to ArcSDE 9.3 geodatabases and for ArcGIS 9.3 clients can make direct connections to any ArcSDE 9.x geodatabase.

Direct connections to ArcSDE geodatabases

The ESRI Inside the Geodatabase blog has some links to web help and support information worth checking out.


ESRI clients can now consume multiple versions of the geodatabase

Filed under GIS Tagged with , ,

ArcGIS 9.2 Service Pack 6 Announced

July 8, 2008 1 Comment

Those who aren’t jumping on the 9.3 upgrade bandwagon can grab the latest ArcGIS 9.2 SP6 release available later this month. I’m personally very happy to see continued improvements to 9.2 even though 9.3 is released. Many organizations don’t upgrade immediately and making sure 9.2 is still improved allows those who aren’t ready to make the jump work better. A welcome change from abandoning older releases (though I think in the past years ESRI has been more proactive about supporting versions longer).

Filed under GIS Tagged with , , , , , , , ,

← Older posts