Thursday, September 23, 2010
In this case, the demo takes open parcel and address information from the Boulder City and Boulder County (Colorado, USA), processes it with FME and writes data into a format that can be uploaded into OpenStreetMap for the world to see.
Wednesday, September 22, 2010
Please mark your calendars.
GE Energy will host a Smallworld Latin America Users Conference November 30-December 1 in São Paulo, Brazil.
The venue will be CENESP (Centro Empresarial de São Paulo) on Avenida Maria Coelho Aguiar 215 - Bloco G, 2nd Floor
v Join fellow customers, channels, third party companies related to our industry, and GE staff.
v Listen to industry presentations, case studies, and product announcements.
v Spend time at the Exhibition to learn about the latest software developments and innovations.
v Network and socialize with colleagues from across the Latin America.
v Simultaneous translations to be provided for Spanish and Portuguese.
Please RSVP to Denise Buciotti Coelho by phone +55 11 3067-8223 or email firstname.lastname@example.org.
Tuesday, September 21, 2010
Wednesday, September 15, 2010
http://walking-papers.org provides a way of printing out your maps onto paper. These paper maps have georeferencing marks on them. You take them out into the field, make your redlining changes and then when you come back into the office, you scan them and then upload the scan. The scanned maps are georeferenced onto the background map and made available for a back-office technician to digitize the data and red-lined attributes into the database.
Seems very simple yet effective. I'm not suggesting that Smallworld customers adopt this approach, but when thinking about mobile solutions I think it is good to understand the broad range of options and learn from them.
Saturday, September 11, 2010
Friday, September 10, 2010
1. You can get a SQL prompt directly at the Magik prompt...
SQL> SELECT name, address1 FROM hotel ORDER BY address1
Name Address 1
Acorn Guest House 154 Chesterton Road
Hamilton Lodge 156 Chesterton Road
De Freville House 166 Chesterton Road
Rosswill 17 Chesterton Road
Cam Guest House 17 Elizabeth Way
Kirkwood House 172 Chesterton Road
All Seasons 219 Chesterton Road
Lyngamore 35 Chesterton Road
Suffolk House 69 Milton Road
Southampton House 7 Elizabeth Way
Ashley Hotel 74 Chesterton Road
Arundel House Chesterton Road
Gonville Hotel Gonville Place
Garden House Granta Place
University Arms Regent Street
15 record(s) selected
SQL> SQL> select count(*) from min_road
1 record(s) selected
NOTE: the sql() procedure is defined in module :sql2. You can load that module if your image doesn't have the sql() procedure loaded.
2. You can also use the sql2_parser object directly in your Magik code.
You can find out more by searching the Smallworld documentation for "SQL Support". To be clear, this is not the same as Smallworld's SQL Server image code. This is strictly related to writing SQL in Magik to query Smallworld tables.