As part of a new urban renewal project we obtained the previous master plan as a PDF (naturally). Reading through it we felt that we needed to understand what was proposed and how the proposals would look in 3D.
It’s a largish urban area and previously we would never even dream of modelling it at such an early stage of the project. Too much work to model in SketchUp and certainly not to just understand part of a report. Things have changed and now we are aware of what CityEngine can do we’re starting to modify how we approach jobs.
You wonder why I’m interested in CityEngine? Well I can see how it is changing our work and what it will change for us in the future. Less than a month into a project and we’ve modelled an entire urban area in less than 1/2 a day, just to understand something better.
Pre-CityEngine we would never have done this.
I was recently asked to be the Guest Speaker at the wards dinner and ceremony at GISWORX’13, I was asked if I could say something motivational/inspirational for 5 minutes…. I hope this was okay:
“Good evening fellow geo colleagues and distinguished guests, I feel very honoured to be asked to present at this wonderful conference. I think we can all agree that GISTEC have done a marvellous job fitting so much in to 3 days, with such interesting presentations and workshops!
I was asked whether I would talk to you now about something motivational or inspirational potentially related to the conference themes.
But all I have come up with is the idea we all need to find time to play. Let me try and explain to you what I believe is the ….
… the power of play
I know you’re probably all fed up of this by now…. You can view my presentation at the GeoDesign summit here, or at the ESRI video site (you can download it for offline viewing too!) or eventually on ESRI’s Youtube site
This is a useful tip that has been pointed out to me by a colleague, so useful in fact I have to make sure I note it down somewhere. Until my idea is incorporated into ArcGIS this is a quick and dirty workaround for translating Arabic labels in ArcGIS.
We have received some GIS data from a client, it’s landuse in a geodatabase with Arabic labels. Trouble is our maps are needed in English! In the past we’ve tested the Microsoft translation tools (for office) against Google’s online translate tool and found that Google does a much better translation.
So how do we translate this large landuse table quickly and easily? Use Excel of course! Please note that this bullet point list assumes you know ArcGIS and Excel quite well, to instruct from a beginners point of view would be a bit to long winded for me.
- First create a field name for the English Translation in ArcGIS
- Open a new Excel document
- Copy (using this method) the table from ArcGIS into Excel.
- Create a PivotTable that lists the row labels (in this case Arabic Landuse)
- Copy and paste this list out (so the text is static, you probably don’t have to)
- Copy the Arabic text into the text box at translate.google.com
- Now Copy that English translation text list back adjacent to your Arabic landuse list into Excel
- Now you have to use some Excel magic, select the English and Arabic text and under the Formulas tab (in Excel 2007) define a name ( in this case I called it English Translate)
- Once you have done this go to the English Landuse field name column and type in code like this “=VLOOKUP(E7,EnglishTranslate,2)”. E7 is the Arabic landuse in your original table in Excel, EnglishTranslate is that Name you defined above and the number 2 is the column number of the EnglishTranslate you need to use if matched.
- Then click and drag copy this down your English translation field to check it works.
- Now copy back this data into ArcGIS or Join/Link it.
Well that’s it if you have any improvements/questions/suggestions please add them in the comments section below!
It’s still a difficult concept for me, I have to admit, when it’s explained to me it seems to stupidly obvious that it hardly needs pointing out or given a name. Yet it’s useful to give what is coming a name, I say what is coming because I believe true ‘geodesign’ has not been done yet.
I regard ‘geodesign’ as the term we will use to explain how we will manage, create and plan things in the future by taking into account as much of the knowledge we have at our disposal from sensors, theories and analytical tools. When I say “as much of the knowledge we have“, I don’t mean how we do it now. For instance when planning a new city I don’t actually design by taking into account the sum of all human knowledge about that area and all the data current, historical and projected that relate to it. Nor do I take into account all the theories new, old and emerging that might be of relevance to urban form or planning or environment. Shocking isn’t it? Well, of course not really, no one can do that and if they say they can I’m pretty sure they’re lying.
We are starting to see the emergence of true Geodesign, all the technological pieces are lining up, ubiquitous sensors, internet, communications infrastructure, social networks, computing power. Now all we need is someone ( a Geodesigner?) to piece it all together into a unified global framework or system. So perhaps the last piece in the puzzle is probably that transactional database of the world that Jack has talked of.
Like driverless cars, the technology has been there for a while it just needs someone to fit it all together into a complete package.
Feeding into the transactional database of the world would need to be a vast number of sensors. Well that’s all happening now, buildings, engines, animals you name it large parts of our world are being monitored at various levels.
The trouble is that they’re all in their own data silos with limited interactivity to the outside world. One concept that came from David Bartlett’s presentation was that:
“people are the smartest sensors we have”
Of course these ideas feed into each other and there’s probably someone out there fitting all the pieces together as we speak…. lets hope the appropriate checks and balances are built in from the ground up!
At the summit Jack Dangermond told us of his idea of creating a transactional database of the world. I think a central repository of all scientific knowledge in relation to the earth. A place where anyone with a computer and access to the internet could access all the sensor logs and all the analytical models that existed. Now there is an amazing if a little scary idea.
I think as long as no one organisation or government has total control over this database then it may have a huge amount of uses for humanity and the planet. The real implementation issues are not technical though, it’s the financial, political and social aspects. Perhaps this EU INSPIRE directive is the start of it all then?
People do like conferences and summits for the conversation, I’ve personally found it almost of more value than the people I’ve come to hear speak. But really this idea of conversations was brought up in a number of presentations at the Summit. Communicating ideas and new theories as well as data is getting increasingly complex. As the internet and it’s various types of networks start interacting (social, mapping, work, games etc). Twitter/facebook et al have shown there is an appetite for conversation on a global level between people who have no connections other than their love of LOLCats (or GIS either is valid in this context!).
What amuses me most about some people who are anti-social media is the familiar lines of young people having “too short n attention span, nowadays” yet almost in the same breath saying they have “no time for social media”. I think that humans have the same attention span they always did. It’s just we have access to so much more information that we have adapted to absorbing snippets of information from multiple sources. Whilst we scan web pages and social media streams we still manage to read books of more than a few pages (then share that over a social network) and we still watch TV shows of more than 10 minutes for 24 episodes (I wonder what show I could be referring to). It’s not just the entertainment media either, educational programs like those made by Brian Cox or Sir David Attenborough have never been more popular. So the idea of short attention spans of the newer generations is false.
What I think needs to be much more connected is this idea of story telling (via maps for example) and conversations. ESRI for example has an amazing array of tools and systems to tell stories an relay information via maps but no way of enabling that conversation on a global level, except via other people’s social networks. Perhaps we need a new kind of social network that operates like and with existing ones but with an emphasis on sharing data, research and analytical process and tools. I think that this has the beginnings of another blog post about the logical future of ESRI.
NB : I’m aware of the irony of writing one large article then splitting it up for readability….