Latest Contributions by ChristopherThomas

As of now with ArcGIS Pro 1.4, there is not currently a way to manage or create workgroup geodatabases, but as Manvi mentioned we can create connections to them and use the data in Pro. I use workgroup and Sql Server express in several of the classes that I teach. Currently the workaround is to continue use ArcMap and Database Servers to create and manage workgroup geodatabases, but maybe that will be added in a future release. I didn't see anything on the ideas website yet.  ... View more

I've used database views to display data on the fly if your data is loaded into an enterprise geodatabase. You might also check out the Attribute Assistant add-in as another option. Attribute Assistant | ArcGIS Solutions ... View more

Good to know! I'm running 2014 and 2012 on my machines here so I had not run into that. ... View more

James, There shouldn't be anything special you need to do differently at 10.4. Are you able to access other data in that enterprise GDB? Is it just the certain views that are not accessible? The first thing I usually check when one machine cannot see data that another machine can is to check the privileges. Are you  using OS or Database Authentication to access the data? If you are using OS authentication are you able to logon to your colleague's machine and access the view with 10.3.1 with your login? If you are using database authentication, are you connecting as that same user from the different machines? Chris ... View more

Aza, What kind of data are you using this tool on? Is this a feature class in a file geodatabase? Excel Table? The results window shows "CCTVs\CCTV Phase 5C\CCTV Phase 5C". I usually try to avoid spaces in the names when scripting or gp tools are involved. I don't think that would be the problem, but you might try creating a copy with a different name without spaces and give it a try. Chris ... View more

Aza, what Joshua Bixby said below... you only need to put the variable name "Status" into the expression. Post what the error message is if you still do not get that to work. ... View more

Here is a screenshot of what worked for me using the Calculate geoprocessing Tool in 10.3.1... In this case SymbolID is a text field and Status is a text field length of 50 that I added to my Zoning feature class. If you have not already, try restarting ArcGIS to make sure nothing is locked or old variables get cleared from memory. ... View more

Also, I noticed your original EndIf needs a space in it: End If I tested it here with a file geodatabase and a sql server feature class and it worked for me. What version of ArcGIS are you using? ... View more

VB script requires double quotes. Try: Dim Status IF [SymbolID] = "0" THEN Status = "In Construction" Else Status =  "Planned" End If ... View more

Another approach that has the benefit of working with the existing feature classes without creating additional feature classes like spatial join: Use the Generate Near Table tool. This produces an output table with the feature IDs of both feature classes. If the building resides within that parcel it will include the distance of 0. In this case you are not interested in the distance but the IN_FID(building OID) and NEAR_FID(parcel OID). Next you can join the NearTable output to the building feature class using IN_FID then join the parcels to the buildings using NEAR_FID. Next calculate the building.PIN over from parcel.PIN through the joined tables. Keep in mind if the feature classes are large, you might want to add indexes to the fields involved in the join to do the calculation with better performance. ... View more