This is a quick write up that’s related to the blog series I’m doing on custom symbology in ArcGIS Pro. Well sort of, it just so happens to be the perfect dataset to use to use for UK based mapping projects where you don’t want to use a costly licenced dataset (maybe the forthcoming Open MasterMap may change that?). Now, I know I normally write about 3D and CityEngine related stuff but I do love a good 2D map as well! This post assumes a simple working knowledge of ArcGIS Pro. I’m considering making this a video as well so you can see the entire process.
As you can see there are some instructions on what to do with style sheets if you’re an ArcMap user in that PDF linked above… well I do not use ArcMap much anymore more so I’ve pretty much made a complete transition to ArcGIS Pro so here’s what you do next.
Step 1: New ArcGIS Pro project and then ‘insert’ a new ‘map’.
Step 2: Convert the Geopackage into a File Geodatabase… as far as I am aware you don’t need an Advanced licence or FME or the Data Interoperability Extension (if I’m wrong comment below on this post) you can drag in each layer manually into a Map in ArcGIS Pro and then right-click the ‘export data’ function. Or better yet, you can use the copy features GP tool (using the Batch function). *I’ve created a toolbox with two tools that simplifies this process for me. I will share this as a separate blog post soon…
Step 2: Remove the prefix ‘main_’ from all the feature classes you imported into the new file geodatabase, otherwise you can’t use the lyr file on them….
Step 3: Find your “OS-Open-Zoomstack.lyr” (link to download it here) and drag it in to your Map, notice all those red “!” marks, this means it can’t find the data these symbols are linking too. Click on one of these red “!” to fix them all. It will ask you where the data layer is located ( in this case ‘names’). Find the data in the new file geodatabase you created.
Step 4: Well it should all work and all those “!” should have gone and you have a nicely symbolised OS Open Zoomstack data set courtesy of the nice folks at the Ordnance Survey.
A final note this workflow unbelievably helped me find where Esri hid the ‘repair data’ function went, basically they built it into the “!“… d’oh.
Coming up in a future blog post: How we can use OS Open Zoomstack with our hand drawn custom symbology.
Last Tuesday (16th of May 2017) was the much-anticipated yearly geospatial event from Esri UK. Their Annual Conference has gone from strength to strength and the venue has been at capacity for the last two years now.
I love the EsriUK conference and being based in Cumbria having an event where I can get to see all the people we work with in one location is fantastic (although I quite enjoyed EsriUK’s Perth event too!). It used to be I went for the presentations I now go to have meetings and keep the personal connections I’ve developed through social media going.
The opening plenary was interesting and focused (quite rightly) on the significant achievements Esri have made in developing their platform. I cannot comprehend how complex the process is of developing a cloud presence and slowly (it feels slow to me at least in regards to stability & memory issues) developing the new ArcGISPro application whilst still maintaining the existing and well used product suite of ArcMap, ArcGlobe, and ArcScene. I guess that’s what they use our licence and maintenance fees for!
What I noticed this time was what I have been saying for a while and told people about back in 2009 (when I started using CityEngine): Esri needs to be invested deeply in 3D to compete in the new and merging industries of ‘smart cities’ and ‘BIM’. All their competitors are there and coming for the GIS users too. Fortunately is Esri doing this now.
EsriUK’s live demo this year was walking around with a GeoSlam device getting a laser scan of the venue, to fly around and measure in ArcGISPro. Unfortunately I felt this demo was a little limited in scope this year. We’ve worked with point clouds in ArcGISPro and whilst good there are still some issues so perhaps that’s why it was not as ‘wow!’ for me.
Looking at all their applications, it is truly crazy how many 3D capable products Esri have developed. Yet amongst all these amazing tools, all too often, I am still meeting people who wonder what they’re going to do with these 3D technologies….
The obvious answer is ‘well first you need 3D data’, and that’s what Garsdale Design’s new project, our GD3D brand, is all about. Acquiring 3D is still like acquiring satellite data in the early days, difficult and expensive, however I will write more on this soon because it doesn’t have to be.
Post plenary there was plenty of people to talk too, but I did manage to get to see a few presentations:
Mapping London’s 2050 Infrastructure Growth
Dr Larissa R Suzuki gave a great presentation into the challenges Transport for London were facing managing development and maintenance of their infrastructure. The mapping systems they are implementing to identify what activity is taking place in the same location (think development and road works etc..) at the same time are fantastically useful. Let’s hope this kind of technology use gets adopted nationally not just per authority.
A journey through the airport
The Manchester Airport Group have a place in my heart, as I am a big fan of Manchester Airport to be honest. Small-ish airport in the scheme of things owned by local authorities but punching well above its weight in terms of the region it serves and the places you can fly to. I can get a train direct from Oxenholme straight to Manchester Airport and be in Dubai or major hubs in the USA really quickly. Their talk by Vickie Withnell was very interesting, showing us a 3D animation of the next phase of expansion of Manchester Airport basically 4D or construction management. As one commentator on the Esri AC app put it a “video’ gantt chart”. Obviously being able to manage data through time and integrate your process with the planning and consultation elements of their business has paid dividends. Vickie should have received a stand ovation for saying that their planning application for a new arrivals terminal at Stansted only took 13 weeks (supposed target processing time for major planning applications), top it all off they only had one objection. Any planner (private or public) in the room I am sure was immediately feeling completely in awe.
SWEET, simplicity and GeoDesign
Charles Kennelly CTO of EsriUK was in top form clearly presenting one of his technology passions ‘geodesign’. The application he demo’d was called ‘SWEET’ and his message was very simple really. Sometimes making tools that are simple to use for defined purposes really do make sense. The web application he demo showed off how you could program rules in to editing tools that automatically clipped polygons and stopped you editing outside areas. Basically, taking away that process us GIS professionals always have to do when receiving someone else’s data which is cleaning up and fixing geometries (like slithers). In the demo web application you could plot away and be sure that the data you create was clean and clipped to your areas properly.
The Customer Success Awards were back again (we won one last year hurrah!) and what a great series of entries, I am glad they keeping this going. It is always nice to be recognised for hardwork and clearly the winners and nominees have been working hard!.
Daniel Raven-Ellison a self-confessed ‘Guerilla Geographer’ (don’t cringe) gave a very impassioned presentation focusing on his campaign to make London a National Park City . Always the cynic living in Northern England I feel uncomfortable giving London more designations and status. But he did give a compelling argument but perhaps instead of a National Park City a focus on making all cities green and vibrant as he wants to make London would be better? Whatever your opinion he is a very passionate and good speaker with important things to say about our cities and environment. I think we ignore him at our peril.
The future look at the platform was interesting the Esri inc team were represented with Chris Andrews and EsriUK by Charles Kennelly the platform is scaling well and 3D is a big part of this.
Charles also treated us to an experimental map where the cartography was enhanced or augmented with sounds. So moving the mouse over particular elements of a map gave a different noise. I think this kind of approach will be ever more important when augmented and mixed reality technologies become main stream. Not everything in GIS should be visual was my ‘take away’.
As usual I have skimmed over details at a ramble for this blog post. As a company we had a great day talking about our new GD3D® brand and our data service for the Esri platform. It strikes me that people still are sitting in silos of data though, hesitating to be the first to break out and hindered by restrictive licencing and pricing. I guess that is often the nature of professions.
Personally, I met lots of new and interesting people, so thank you if you talked to me and sorry if I don’t remember your name next we meet, it’s not personal! I’m just not very good at remembering faces.
We gave out lots of badges and stickers which made travelling home lighter and easier too. Coming up next for us, my colleague Nicholas Duggan will be attending the Geobusiness conference in London. I have now booked my flights to San Diego for this year’s Esri UC I’ll be attending some 3D sessions there but am also eager to meet up and chat with anyone interested in 3D building data for the Esri platform and of course Esri CityEngine training and services.
Our presentation on Big Data!
I’ll be doing another post on our presentation at the Esri UK Annual Conference entitled “Big data! Offshore to onshore: Streaming 3D cities and point clouds” shortly…. 🙂
Okay it’s a little odd but I’ve been experimenting with Ordnance Survey Opendata and CityEngine on and off for a while…. using ArcGIS Spatial Analyst Extension tools I created from some OS terrain an artificial flood polygon. I imported the terrain and polygon into CityEngine renamed the flood polygon “flood__water” (the “__water” tells the CityEngine webgl viewer to render it as water). Then I exported it out as a webscene.
Whether this is actually useful I don’t know, certainly for this demo it’s not as I’ve exaggerated the terrain a little for ‘dramatic’ effect.
I think it looks pretty good, I’m in the process of adding buildings, roads and forests, I’ll let you know how it goes… I’m also wanting to do this again using opensource software like QGIS and CityEngine (there is no equivalent of CityEngine as an opensource product).
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.
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.
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
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!
Well a quick announcement really… I’ll be one of the featured speakers at ESRI’s HQ in Redlands, San Diego, early next year (January 24-25 2013).
This is what I’ll be talking about:
Garsdale Design, which specialises in master planning and urban design has been working on four city master planning projects in southern Iraq. These projects required the analysis and planning of these cities for their expansion over the next 40 years. So how did ArcGIS and CityEngine maximise our productivity giving the client better outcomes?
Large-scale city master planning projects inevitably move slowly over many months since the work proceeds stage by stage. At certain points work can often stop while the client consults and chooses options from a series of drafts. Frequently new data or requirements can emerge, the consequences of which have far reaching implications.
What if a city can be fully described at each stage of a project? CityEngine has demonstrated a new and exciting direction for us. With the concepts of ‘GeoDesign’ we are now looking at our project workflows in new ways. What if the project team could change detailed plans with ease taking into account new data instantly, and avoiding the laborious redrawing of layouts? This is the promise of the ‘Instant City’.
If you’re a regular reader of my blog, you’ll know why I’m talking about CityEngine, it’s become a bit of an obsession really….
Drop me a line if you’re intending on going it would be great to meet other geo-professionals!
Based on a toolbox created by thales007 for clipping a workspace, this adds a raster clipper. This is a beta version and it is intended to add more tools and tidy up the functionality of these as well.