autocad
ESRI acquires Procedural – Master Planning & Urban Design just got easier?
Yesterday at ESRI’s annual user conference in San Diego, Jack Dangermond announced the acquisition of Procedural, the maker of an “up and coming” piece of software called CityEngine that I’ve talked about quite a lot on this blog…
My reaction to this news is enthusiastic I already use ArcGIS in our Urban Design and Master Planning projects extensively. I’ve been also looking at using CityEngine to speed up the process of master planning as well as other related urban projects. Better integration with ArcGIS will be great for us. I’m also looking forward to a more mature product at the next release with support for GeoTiffs at the top of my most wanted list.
From the moment I downloaded the trial of CityEngine (thanks to blog post in DigitalUrban) I saw that this program had huge potential on many levels for my industry. The key to its usefulness, for me, is it’s ability (or potential ability) to deal with the macro to micro scale of planning. For example I can get it to grow a region wide street network from obstacle maps and an existing network, but within that and dependent on your rule files I can zoom into building level and have a particular piece of street furniture outside a building. The possibilities are endless, honestly, and the complexity of your model is only as complex as your rule files. I can quite quickly make a convincing looking city for master planning purposes provided I put the time into the rule files that govern your model.
At it’s simplest level you can specify lot sizes very easily (provided your area is bounded by a road network). This means that for some traditional ways of working (I’m talking AutoCAD plotting), has been dramatically reduced. For a small company like the one I work for, where everyone has multiple jobs (I’m the CAD technician as well on master planning projects!) this is essential for us to remain competitive.
The future of certain urban based modelling, especially in master planning I see as two fold:
- Most of the drawing of urban areas will now be governed by text based rule files and drawn automatically using CityEngine methods. Much of the time consuming processes involved in designing a new city will be reduced to a tiny amount of the project time.
- Design becomes more prominent in the process as time freed doing the manual work of plotting cities is replaced by CityEngine. I think what we will see is design codes and planning standards used as templates to create rule files that can be changed very quickly. When it comes to, for example, detailed studies for a master plan we as master planners will have much more time to actually design. By that I mean instead of putting time into plotting in AutoCAD lots, plots and districts we will actually be able to design key buildings and other pieces of the urban fabric.
Attending the ESRI UK Conference
Okay why a post about some weird acronym type company? Well in the world of GIS (Geographic Information Systems/Science), ESRI (Environmental Systems Research Institute) a software/consultancy company is a big player.
Yes they are a big corporate entity but in some ways they feel more like a movement, so when their yearly conference comes round I get excited. Not content with just advertising their products to their customers it feels as if you’re at an event for the GIS industry as a whole. Whatever issue you might have with ESRI’s software ArcGIS etc… you can’t fault the staff’s enthusiasm and professionalism (well that’s my experience anyway) especially at events like this.
Why the blog post this year? Well because I submitted a paper about using some software in our workflow called CityEngine and was asked to do a presentation on both days. You can find out more about ESRI here and ESRI UK here, I would also recommend some Wikipedia research on GIS.
You may have come to this post because I mentioned you somewhere, if you want to add something more (links, information etc…) or correct something contact me or add a comment to the relevant post.
- ESRI UK Conference – Day 1
- ESRI UK Conference - Day 2
- ESRI UK Conference - My Presentations
- ESRI UK Conference - People I met
- ESRI UK Conference - Thoughts for the Future, suggestions for ESRI UK
- Back in London – not really related to the conference more musings of visiting our nation’s capital.
Quick Tip: Images into AutoCAD LT (2006)
| Word+AutoCAD = productivity? |
Do you have a copy of AutoCAD LT (2006 or other) and need to insert an image/photo into your layout or data view? Do you not want to purchase a full version of AutoCAD? Well you’re in luck as there is an easy way to do it!.
- AutoCAD LT (I have 2006 but this may work with other versions)
- Microsoft Word (I have version 2007 but other versions or alternative office programs may well work)
- A photo or image (jpg or otherwise) that you want to insert.
- Some knowledge of Microsoft Windows…
- Open Word and preferably create a new blank document.
- Insert or copy+paste (crtl+c then crtl+v) an image into the Word document.
- Select the newly pasted image in word and …
- Either
- right click –> Copy or
- Ctrl+C or
- Home Tab Click ‘Copy’
- Open or switch to AutoCAD LT and the data/layout view you want the image in and….
- Either
- right-click –> Paste or
- Crtl+V or
- Edit Menu –> Paste
ArcGIS : Using Query Builder to display certain features (multiple)
![]() |
| The Power of SQL & Query Builder |
I know this post covers something probably very obvious to many technical users of ArcGIS. However some of us ArcGIS users are not necessarily aware of Query Builder and it’s uses. So this advice is for people like us/them.
You may have noticed the “Definition Query” tab in your “Layer Properties” dialog box (right click on your layer and select ‘properties’). As ESRI says in the ArcGIS helpfile:
Query expressions are used in ArcGIS to select a subset of features and table records.
Clear as mud to those not familiar with standard SQL expressions! Anyway why would you use? Or more importantly why would I use it?
Here was my problem, for a particular project I have imported into a Geodatabase an AutoCAD file that has many layers and a lot of features. So I am displaying each former AutoCAD layer with different symbology but using the same feature class in the geodatabase each time (clear enough?).
![]() |
| How did I select you? You’re not there! |
Using the Symbology tab in the Layer properties I can display only those features that I am interested in. Now I can make some nice paper maps and the like! The trouble is when I want to now edit that layer I keep on selecting for some reason the features that I haven’t assigned symbology to. Very annoying and very frustrating.
So what the Query Builder allows me to do is select only the features that are in this case by layer name field (it’s from AutoCAD) to be used. Now when I go to edit this layer only those features I have given symbology to are selectable. Okay I apologise if this doesn’t make sense to you but then perhaps you haven’t had the same issue I have.
Anyway say you have three features types (formerly layers in AutoCAD) that you want display these are:
- Primary Road
- Secondary Road
- Track
“Layer” IN(‘Primary Road’ , ‘Secondary Road’, ‘Local’ )
I’m not here to explain how it works as to be honest I’m not sure and its probable that you can do this another way. However this works for me, if you have any suggestions as to a better code, I’m all ears so please add a comment after this post and I’ll amend the advice!
I looked for help on the ArcGIS forums beforing writing this post and used the following discussion thread:
Mulitple NOT expressions in query builder?
Suggested Reads (I guess): Getting to Know ArcGIS Desktop: The Basics of ArcView, ArcEditor, and ArcInfo Updated for ArcGIS 9 (Getting to Know series) and SQL For Dummies
Game changers? Any suggestions?
![]() |
| Does this do anything for you? Source: Wikipedia |
Warning a more than slightly geeky post is about to happen! This list is not in any particular order… (warning most of the list below is linking to wiki)
- Commodre 64
- PC 1512
- Microsoft Windows 3.1
- Microsoft Word for Windows
- AutoCAD
- InkJet printers
- iPod
- SketchUP
- Freedom of Information/OpenData
- GIS
- PlanningPortal and Planning Delivery Grant
- Kindle
Photomodeler and creating a 3D model of a Historic building
I’m not just a planner or a GIS man! As part of my work at Garsdale Design Limited, I help in the assessment and survey of historic buildings (in conjunction with our Heritage Specialist). One such building I am working on at the moment requires a nice measured and detailed drawing, as part of a planning application.
We’re using a piece of software called Photomodeler to build up an accurate 3D (and 2D if you really want) model of this lovely old farmhouse in the Yorkshire Dales National Park. The process invloves calibration of your chosen camera (preferably a good quality one), then the taking of a large amount of photos from at least two opposing angles of all parts of your building.
Once imported into Photomodeler you need to mark the same point one each photo, and if you’ve done it correctly you will get yourself a pretty accurate model. We also do a good amount of measuring to ensure that the model does indeed remain accurate…
We’ve used this method before and I have to say the software is excellent and relatively easy to use. Creating a 3D model is also great fun and once finished is incredibly satisfying. Photomodeler allows you to do accurate drawings without spending as much time on site (which can be a cost saving!).
We then export our model to a DXF format (3D or 2D), but you can export to kml and a variety of other formats (see screen capture to the left). Photomodeler also allows for the photos to be projected onto your surfaces.
Anyway I really recommend that if you are interested you give it a go, Photomodeler isn’t just for buildings as their marketing will state!
You can also view your new model in stereo view if you have those nifty 3D red/blue glasses…ooooo
Photomodeler Website is here
We bought our software and subsequent training from Photarc
HP DesignJet 500 and Windows 7: Yes it does work even without the HPGL2 card!
Updated (04/12/2012): To include information about how to get the 450c to work with Windows 8 after a conversation with @AlbanyDriver on twitter. I also think this technqiue will probably work for Windows 8 as well.
Updated (22/June/2012):
Updated (08/May/2010): this post was partially rewritten to clarify which file you should download.
Unbelievably this is the most popular post on my blog, I honestly get 1000+ hits a month just on this page. If you like it and have more to add please send me a message or add a comment below. Thank you for reading!
![]() |
| Source: hp.com |
Okay this is a quick one, if you have a HP DesignJet 500 without that HPGL2 card and want to upgrade to Windows 7 (or 8) or have done so and can’t seem to get it to work, try the following.
We use our HP DesignJet for all things GIS and AutoCAD so it’s important we have this working!
You may have noticed that HP only has Windows 7 drivers for the DJ500 with the HPGL2 card in the driver package called either:
- HP Designjet 500, 510, and 800 HP-GL/2 and HP RTL 32-bit Driver or
- HP Designjet 500, 510, and 800 HP-GL/2 and HP RTL 64-bit Driver
So don’t download those drivers, make sure you download the drivers from Vista equivalent (in my case Vista 32bit). This file is called either:
- HP DesignJet 500 PCL3GUI 32-bit Driver or
- DesignJet 500 PCL3GUI 64-bit Driver
Click here to go direct to the HP DJ 500 driver download site.
Add your printer in the usual way in Windows 7, (if you are adding it over the network you may want to look at my previous post).
After the install it will ask if you want to Print a Test Page, it was here that I was getting an error message (about the HP driver not being able to connect to the printer) and just assumed it wasn’t working. If you get an error message and no test page try this:
- Select the printer in the printer browser, and view the printer properties.
- On the page with the print test page button there is another button next to it called printing preferences, click on this and it should bring up a dialog box stating that the printer is now connected.
- Now try to print that test page.
Okay so I don’t know why I couldn’t print the test page straight off but accessing the designjets plotter preferences did help.
Again if this post is not clear, or you require any help, just let me know.
Have you got an HP 450C and want it to work with Windows 8 (32bit)? @AlbanyDriver got in contact and asked me if I could help, after some searching on forums about making it work on Windows 7, I suggested he used the Windows XP 32bit drivers which seemed to work!
Updated Link Added for my previous post adding printers over a network: http://geoplanit.blogspot.com/2010/01/very-slow-printer-dialog-boxes-in.html
AutoCAD Annotation to ArcGIS
A very long numbered list related to ArcGIS
The trouble with displaying or importing annotation from CAD to ArcGIS is that my carefully placed text in autocad moves when I place it in ArcGIS.
After a bit of searching I have found some solutions like this one here: http://forums.esri.com/Thread.asp?c=93&f=1728&t=131939 (ESRI Support pages)
I thought I’d elaborate and do a step by step process, mainly so I don’t forget!
- First open ArcCatalog
- Open the ArcToolBox
- Find under “Conversion Tools” the “Import from CAD” tool
- Double Click on this “Import from CAD tool”
- Select your AutoCad file (the whole file not just parts)
- Then choose where you want the new Geodatabase file you are creating will go.
- Click Ok
- Now open up ArcMap
- Add the point layer under the “CAD Staging” Feature Dataset
- Notice that the points you have added are in the location you want your text to be in, (there are also points from other parts of your CAD drawing here as well, we’ll clean this up in a bit)
- Right Click on your newly added point layer and select Joins and Relates Join.
- The field we will be linking is the EntID field.
- Now select the File Geodatabase Table called “Entity”, this is located with your newly exported CAD file in the Geodatabase.
- You will also be using the “EntID” field, Keep all records and click OK.
- Now for clarity I tend to switch off from view those fields I don’t need, right click on your point layer and select Properties. Select the Fields tab and then go through the list switching off all the fields, except for : Point.OBJECTID, Entity.Layer and Entity.RefName. Click Apply and then OK.
- Now right click on your point layer again and Open the Attribute Table, voila! You should have your text matched to your point data (if you notice funny code around your text, relating to font and size, don’t worry I will deal with this, so keep reading). It’s up to you how you clear up the data now, however I shall continue this so you get an idea of what can be done.
- I want a nice clean layer so, right click your point layer and select export data. Now I would select only the items I want to label (remember the point layer is a consolidated file of ALL your point data from AutoCAD not just text!)
- Choose a location to save this new file and select okay, and click ‘yes’ to add this new data.
- When looking at my text stored in the RefName field I can see that it has brought through some extra information like this: “{\fVerdana|b1|i0|c0|p34;QUARTER 1}”.
- Start an edit session.
- Open the point file’s attribute table.
- We want to get rid of first the front part of this code, so select one of the fields and select the first part of the code like this “{\fVerdana|b1|i0|c0|p34;” once selected either right click and copy, or press “Control+C” on the keyboard.
- Select the RefName Column so the whole column is selected
- Now click on options and then Find and Replace.
- In find place the copied text “{\fVerdana|b1|i0|c0|p34;” (or whatever text you have)
- And leave the Replace with blank.
- Now click “Replace All”
- You should now be left with something like this in your fields: “QUARTER 1}”.
- Now select and copy (or just type) the last bit of this data and repeat the process (“}”).
- So now stop editing (making sure you have saved it).
- Now right click on your point layer and select properties, now click on the labels tab.
- Check the label features in this layer box.
- Now click on the Placement Properties button, here I tend to choose “Place Label on top of the Point”, click OK.
- I would also effectively switch off the point symbol by making it 1pt transparent with no outline.
Phew, I hope that made some sense if I can clarify something please let me know!






