<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Footlight MT Light";
panose-1:2 4 6 2 6 3 10 2 3 4;}
@font-face
{font-family:"Lucida Bright";
panose-1:2 4 6 2 5 5 5 2 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Lucida Bright","serif";
color:blue;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Query layers are pretty cool
things. I recently completed a web application that uses them as all of the data
is in SQL Spatial Types.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>From an existing ODBC connection
you can view the tables in the DB and select the table you want, it does not provide
any capacity to edit them, it is read only.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Right now query layers can only
be created in ArcMap, at 10.1 the python library will be updated to allow for programmatic
connections, or so I was told at the Dev Summit by a Product Mgr.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>You can use some very minor SQL
syntax in creating the query to access the data, but beware that within the
query layer dialog box you are actually looking at a view of the table. Query
layers do not access the table directly. They did this to create one (1)
interface that can connect to the 4 or 5 different spatial databases they
support. Only very limited sql is allowable in a view and even some that is
legal will generate an error. The docs say that “any” legal sql
stmt can be used. They even go to the extent to say you can copy and paste from
something like SQL Server Mgmt Studio; this is inaccurate and it will not work
all the time because you are pasting into the design of a table view.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>The benefit of the query layers
in dynamic applications is that they effectively create a disconnect between the
table and the GIS part. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>An example:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>SQL spatial table with current
hurricane forecast data is exposed to a REST service via a mxd/msd<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>You can make a change to the
data in SQL without hitting any locks or other hiccups and the change will propagate
up through the service to the web app either on reload of the app or if you
have a function to do an ajax call to refresh the data in the current session
of the application.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Once you create the web service
you don’t have to stop, restart, refresh…it just comes through.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I’ve been living and
breathing these things for the past 3 months so if anyone has any questions
about spatial data in SQL (I know a teensy bit about Oracle as well) and/or
query layers feel free to drop me a line.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><b><span style='font-family:"Times New Roman","serif";
color:#1F497D'>Keith Sandell, MBA<o:p></o:p></span></b></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
font-variant:small-caps;color:gray'>GIS Manager, Corporate Analytics<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
font-variant:small-caps;color:gray'>Citizens Property Insurance Corporation<o:p></o:p></span></p>
<p class=MsoNormal style='line-height:5.0pt;mso-line-height-rule:exactly'><span
style='font-size:10.0pt;font-family:"Times New Roman","serif";color:gray'>-------------------------------------------------------<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:gray'>ofc. 850.521.8341 | cell 850.727.2897</span><span
style='color:#1F497D'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> shrug-l-bounces@lists.dep.state.fl.us
[mailto:shrug-l-bounces@lists.dep.state.fl.us] <b>On Behalf Of </b>Tripp Corbin<br>
<b>Sent:</b> Wednesday, July 13, 2011 3:57 PM<br>
<b>To:</b> shrug-L@lists.dep.state.fl.us<br>
<b>Subject:</b> Re: shrug-l: ArcGIS 10.1 - What's coming - spatial DB connections<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>I did find out some more
information about spatial DB connection and their support in ArcGIS from Dawn
Caravallo of Esri. At ArcGIS 10, you can make a spatial DB connection out
of the box. It is called a Query Layer. Here is the article for more
information about this capability:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><a
href="http://blogs.esri.com/Dev/blogs/geodatabase/archive/2010/04/14/Query-Layers-_4000_-ArcGIS-10.aspx">http://blogs.esri.com/Dev/blogs/geodatabase/archive/2010/04/14/Query-Layers-_4000_-ArcGIS-10.aspx</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>If I hear more I will pass it
along. Thanks for the heads up Dawn!!<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><b><i><span style='font-size:12.0pt;color:black'>Tripp
Corbin, MCP, CFM, GISP</span></i></b><b><span style='font-size:12.0pt;
color:black'> </span></b><span style='font-size:12.0pt;color:black'>| Vice
President, GIS/IT</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><br>
</span><b><span style='font-size:12.0pt;font-family:"Footlight MT Light","serif";
color:#244061'><a href="http://www.keckwood.com/"><span style='font-size:18.0pt;
color:#244061;text-decoration:none'>K</span><span style='font-size:13.5pt;
color:#244061;text-decoration:none'>ECK</span><span style='font-size:18.0pt;
color:#244061;text-decoration:none'> & W</span><span style='font-size:13.5pt;
color:#244061;text-decoration:none'>OOD,</span><span style='font-size:18.0pt;
color:#244061;text-decoration:none'> I</span><span style='font-size:13.5pt;
color:#244061;text-decoration:none'>NC</span><span style='font-size:18.0pt;
color:#244061;text-decoration:none'>.</span></a></span></b><span
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>2750 Premiere Parkway, Suite 900,
Duluth, GA 30097<br>
Direct (678) 417-4013 | Main (678) 417-4000 | Fax (678) 417-4055<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'><a
href="mailto:tcorbin@keckwood.com">tcorbin@keckwood.com</a> | <a
href="www.keckwood.com">www.keckwood.com</a> <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>Esri Certified Trainer | Esri
Certified Desktop Associate</span><span style='font-size:12.0pt;font-family:
"Times New Roman","serif";color:black'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Lucida Bright","serif";
color:blue'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
shrug-l-bounces@lists.dep.state.fl.us
[mailto:shrug-l-bounces@lists.dep.state.fl.us] <b>On Behalf Of </b>Tripp Corbin<br>
<b>Sent:</b> Wednesday, July 13, 2011 2:11 PM<br>
<b>To:</b> Robert_Clift@doh.state.fl.us; shrug-L@lists.dep.state.fl.us<br>
<b>Subject:</b> RE: shrug-l: ArcGIS 10.1 - What's coming<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Rob,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I don’t remember them
mentioning anything specifically about being able make direct spatial DB
connections right out of the box. I do know they have simplified the connection
process and consolidated the Database connections, spatial or database, to a
single location. There is also several new Geoprocessing tools add to
ArcToolbox for database admin and functions. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>There is also a new Database
Administration tool which allows you to manage versions, connections and locks.
This will hopefully allow us to move away from the command line administration
and make it a little more intuitive. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><b><i><span style='font-size:12.0pt;color:black'>Tripp
Corbin, MCP, CFM, GISP</span></i></b><b><span style='font-size:12.0pt;
color:black'> </span></b><span style='font-size:12.0pt;color:black'>| Vice
President, GIS/IT</span><br>
<b><a href="http://www.keckwood.com/"><span style='font-size:18.0pt;color:#244061;
text-decoration:none'>K</span><span style='font-size:13.5pt;color:#244061;
text-decoration:none'>ECK</span><span style='font-size:18.0pt;color:#244061;
text-decoration:none'> & W</span><span style='font-size:13.5pt;color:#244061;
text-decoration:none'>OOD,</span><span style='font-size:18.0pt;color:#244061;
text-decoration:none'> I</span><span style='font-size:13.5pt;color:#244061;
text-decoration:none'>NC</span><span style='font-size:18.0pt;color:#244061;
text-decoration:none'>.</span></a></b><o:p></o:p></p>
<p class=MsoNormal><span style='color:black'>2750 Premiere Parkway, Suite 900,
Duluth, GA 30097<br>
Direct (678) 417-4013 | Main (678) 417-4000 | Fax (678) 417-4055<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'><a
href="mailto:tcorbin@keckwood.com">tcorbin@keckwood.com</a> | <a
href="www.keckwood.com">www.keckwood.com</a> <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>Esri Certified Trainer | Esri
Certified Desktop Associate</span><o:p></o:p></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b>From:</b> Robert_Clift@doh.state.fl.us
[mailto:Robert_Clift@doh.state.fl.us] <br>
<b>Sent:</b> Wednesday, July 13, 2011 1:43 PM<br>
<b>To:</b> Tripp Corbin; shrug-L@lists.dep.state.fl.us<br>
<b>Subject:</b> RE: shrug-l: ArcGIS 10.1 - What's coming<o:p></o:p></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks for the recap. <o:p></o:p></p>
<p class=MsoNormal>Following up on your mention of database management tools, I
heard some buzz that 10.1 will support spatial DB connections right out of
the box and **might** even give us some editing capabilities. Was there any
mention of writing to tables from Desktop?<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>-Rob<o:p></o:p></p>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p>Robert E. Clift <br>
Florida Department of Health <br>
Division of Health Access & Tobacco <br>
4025 Esplanade Way, Room 330B <br>
Tallahassee, FL 32311 <br>
Phone: 850.245.4444 ext 2471 <br>
Fax: 850.414.6470 <o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=3 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b>From:</b>
shrug-l-bounces@lists.dep.state.fl.us
[mailto:shrug-l-bounces@lists.dep.state.fl.us] <b>On Behalf Of </b>Tripp Corbin<br>
<b>Sent:</b> Wednesday, July 13, 2011 9:54 AM<br>
<b>To:</b> shrug-L@lists.dep.state.fl.us<br>
<b>Subject:</b> shrug-l: ArcGIS 10.1 - What's coming<o:p></o:p></p>
<p class=MsoNormal>Yesterday in the Esri Plenary Session Jack Dangermond,
President and Founder of Esri, gave us some a sneak peak of some of the goodies
we can expect with the ArcGIS 10.1 release scheduled for the first quarter of
last year. For those like me not able to attend the UC or not able to view the
record sessions, I thought I might share some of what I thought were
highlights.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>ArcGIS Desktop will be even more integrated with ArcGIS
Server and ArcGIS Online. Publishing Maps will be as easy as right clicking and
choosing to share. This will make it much easier to share data with others. Not
only will you be able to share maps in 10.1 but you will also be able to share
geoprocessing models as well using this same method creating model packages. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>ArcGIS Desktop will have some other improvements. 10.1 will
include Dynamic Legends. This means they will automatically resize based on the
scale and size of the map. You will be able to track who edited which features
using Feature Edit Tracking. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>LiDAR data will now be supported. ArcGIS will support the
use of LAS files. You will be able to use these as raster, tin or point cloud
data. This will hopefully make LiDAR even more useful in GIS. This support was
built on the new Dynamic Mosaicing functionality that will be introduced with
ArcGIS 10.1. This new functionality according to Jack will allow users to
easily and quickly access large amounts of raster data. Support has also been
added for additional LandSat Imagery. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>ArcGIS Server will be 64 Bit and have increased support for
Linux. This will mean more power and faster performance. ArcGIS Server
will also have several improvements in the web application side. It will now
support web printing. Support for OGC tile and processing standards have also
been included. It also looks like on the fly symbology will be part of the
package for web apps. Integration with Microsoft SharePoint has also been
increased. SharePoint users will be able to create GIS maps directly inside of
SharePoint via the improved integration. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Well those were some of the highlights. There is more
including improved 3D analysis, editing and visualization, new light weight
runtime app similar to the old MapObjects, new enterprise database management
tools, and support for IBM’s new Netezza.<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><b><i><span style='font-size:12.0pt;color:black'>Tripp
Corbin, MCP, CFM, GISP</span></i></b><b><span style='font-size:12.0pt;
color:black'> </span></b><span style='font-size:12.0pt;color:black'>| Vice
President, GIS/IT</span><br>
<a href="http://www.keckwood.com/"><b>KECK & WOOD, INC.</b></a><o:p></o:p></p>
<p class=MsoNormal><span style='color:black'>2750 Premiere Parkway, Suite 900,
Duluth, GA 30097<br>
Direct (678) 417-4013 | Main (678) 417-4000 | Fax (678) 417-4055<o:p></o:p></span></p>
<p class=MsoNormal><a href="mailto:tcorbin@keckwood.com">tcorbin@keckwood.com</a><span
style='color:black'> | </span><a href="www.keckwood.com">www.keckwood.com</a><span
style='color:black'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>Esri Certified Trainer | Esri
Certified Desktop Associate</span><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>