shrug-l: ArcGIS 10.1 - What's coming - spatial DB connections

Keith Sandell Keith.Sandell at
Thu Jul 14 08:53:18 EDT 2011

Also, another issue with the query layers. May seem like a lot of
issues, but like others things when they are new...


Anyone who has permission to look at a table will be able to access the
data from SQL as a query layer. In the dialog box to create the query
layer it will show the native DB schema that was used to create the


Users who have permission to view the schema can add the data to their
map, but when they do ArcMap will dynamically change the schema to match
the windows authentication user id, i.e. it will change .dbo. to
.ksandell. .


Under these circumstances local resources can use the query layer, i.e.
the map document, but this user will not be able to publish the mxd/msd
using their credentials. Only the account that has the origin schema can
create and publish the mxd/msd with the query layer, trying otherwise
will generate an error.


ESRI was asked about this and they provided that this is by design.


Also, the query layer is a quick and dirty way to get spatial data out
of spatial databases, just right click and export like you would
normally and it will write it to a shapefile or feature class.


The real trick is getting the data into SQL (or other spatial DBs) in
the first place, but you'll have to click here
<>  to learn more about that at a
later date.


Keith Sandell, MBA

GIS Manager, Corporate Analytics

Citizens Property Insurance Corporation

2101 Maryland Circle, Tallahassee, Florida 32303


ofc. 850.521.8341   |   cell 850.727.2897


"If we are to achieve results never before accomplished we must expect
to employ methods never before attempted." - Francis Bacon


-------------- next part --------------
An HTML attachment was scrubbed...

More information about the SHRUG-L mailing list