geosql.blogspot.com
SQL for Geographers: The Power of the Spatial to Attribute Join-Part 3
http://geosql.blogspot.com/2006/02/power-of-spatial-to-attribute-join.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Monday, February 06, 2006. The Power of the Spatial to Attribute Join-Part 3. Sorry for the long delay between posts! So what does this mean for GIS and SQL? We can visualize some of this dataset in ArcScene (or any other 3D package). 4* whe...
geosql.blogspot.com
SQL for Geographers: Consuming REST services with Oracle
http://geosql.blogspot.com/2006/04/consuming-rest-services-with-oracle.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Tuesday, April 11, 2006. Consuming REST services with Oracle. Services (representation state transfer). They provide a powerful yet simple way of consuming data via the web (Some examples of REST services: Yahoo. USGS EDC Elev NED. Or the Or...
geosql.blogspot.com
SQL for Geographers: February 2006
http://geosql.blogspot.com/2006_02_01_archive.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Monday, February 06, 2006. The Power of the Spatial to Attribute Join-Part 3. Sorry for the long delay between posts! So what does this mean for GIS and SQL? We can visualize some of this dataset in ArcScene (or any other 3D package). 4* whe...
geosql.blogspot.com
SQL for Geographers: Database + GIS = Powerful Visualization
http://geosql.blogspot.com/2006/03/database-gis-powerful-visualization.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Tuesday, March 28, 2006. Database GIS = Powerful Visualization. SQL desc STRAT WELL TOP 22MAR2006. FORMATION NAME NOT NULL VARCHAR2(60). WELL HEADER KID NOT NULL NUMBER(10). WELL TOP NUMBER(8,2). GROUND ELEVATION SOURCE VARCHAR2(12). Create ...
geosql.blogspot.com
SQL for Geographers: March 2006
http://geosql.blogspot.com/2006_03_01_archive.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Tuesday, March 28, 2006. Database GIS = Powerful Visualization. SQL desc STRAT WELL TOP 22MAR2006. FORMATION NAME NOT NULL VARCHAR2(60). WELL HEADER KID NOT NULL NUMBER(10). WELL TOP NUMBER(8,2). GROUND ELEVATION SOURCE VARCHAR2(12). Create ...
geosql.blogspot.com
SQL for Geographers: November 2005
http://geosql.blogspot.com/2005_11_01_archive.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Thursday, November 10, 2005. The Power of the Spatial to Attribute Join-Part 2. EXAMPLE DATASET: HADL SST. TABLE COMMENTS: Sea Surface Temperatures: OI version 2 SST Analysis from NCEP - Reynolds, Smith, and Stokes. One degree resolution...
geosql.blogspot.com
SQL for Geographers: Oracle Spatial + Where 2.0?
http://geosql.blogspot.com/2006/06/oracle-spatial-where-20.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Thursday, June 15, 2006. Oracle Spatial Where 2.0? Don't you think that Oracle Spatial should have been there? Maybe I missed them, but they were not presenting and they were not in the participant list. Posted by Jeremy : 10:39 AM. Is there...
geosql.blogspot.com
SQL for Geographers: August 2005
http://geosql.blogspot.com/2005_08_01_archive.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Tuesday, August 23, 2005. Oracle Analytics to the rescue! The "location" is the legal description ( PLSS. To do this we need to join the legal description table with a spatial feature class ( SDE. LAYERDEF id="acres 640" visible="true".
geosql.blogspot.com
SQL for Geographers: Summary Statistics
http://geosql.blogspot.com/2006/03/summary-statistics.html
This blog is dedicated to the integration between GIS and enterprise level relational databases. The amount of data waiting to be spatially enabled within enterprise databases is extraordinary. I hope to show in this blog working examples of database-GIS interaction. Monday, March 06, 2006. One of my most used web pages is a page that summarizes a numeric column for min, max, standard deviation, count, and produces a 10 class equal binned histogram. Take the following interactive map. All we are really d...