O'Reilly Where 2.0 Conference

In these tough economic times we realize passing on savings to you, our audience, is something worth consideration and importance.

We are extending our early registration pricing until March 1, 2010, which saves you $300 off standard registration. We would also like to include a 25% discount code in addition to the early registration savings. Use discount code, whr10ln and register today.
https://en.oreilly.com/where2010/public/register

Attend sessions like: Haiti: Crisis Mapping the Earthquake by John Crowley (STAR-TIDES), Spatial Analysis and the Geoweb by Jack Dangermond (ESRI), Base Map 2.0, and Shedding Light on Climate Change

Where 2.0, happening March 30-April 1, 2010 at the San Jose Marriott in San Jose, California, encompasses the latest innovations in Mobile, Mapping and Local Opps and Models. To see the full schedule:
http://en.oreilly.com/where2010/public/schedule/full

Mapzen POI Collector - Free iPhone OpenStreetMap editor

Mapzen POI Collector - a free, easy to use editor for OpenStreetMap is now available from the App Store. Check it out here:

http://bit.ly/xDRza

Mapzen POI Collector has been designed to be as easy to use as possible and to lower the barriers to entry for new contributors to OSM.

I hope you like it. And apologies for spamming you if you don't have an iPhone!

Example statement 10

Insert a compound line string:

INSERT INTO roads values ('obj_2', mdsys.sdo_geometry(2002, null, null,

mdsys.sdo_elem_info_array(1,4,2,1,2,1,9,2,2),

mdsys.sdo_ordinate_array(15,10, 25,10, 30,5, 38,5, 38,10, 35,15, 25,20)));

Example statement 09

Select any objects within 1.35 distance units from the query window:

select a.feature_id

from target a

where sdo_within_distance(a.shape, :theWindow, 'distance=1.35') = 'TRUE';

Example statement 08

Performs a consistency check to validate a geometry:

select c.name, sdo_geom.validate_geometry(c.shape, m.diminfo)

from cola_markets c, user_sdo_geom_metadata m

where m.table_name = 'COLA_MARKETS' AND m.column_name = 'SHAPE'

and c.name = 'cola_c';

Example statement 07

Compute the difference between two geometries:

select sdo_geom.sdo_distance(c_b.shape, m.diminfo, c_d.shape, m.diminfo)

from cola_markets c_b, cola_markets c_d, user_sdo_geom_metadata m

where m.table_name = 'COLA_MARKETS' AND m.column_name = 'SHAPE'

AND c_b.name = 'cola_b' AND c_d.name = 'cola_d';

Example statement 06

Return the minimum bounding rectangle of all geometries in a column:

select sdo_tune.extent_of('cola_markets','shape')

from dual;