Latest Contributions by ShawnaErnst

Does anyone know how to customize a locator so it will geocode an intersection in the format: W First St/N Main Ave   or   W First St&N Main Ave It works if I enter the intersection this way: W First St / N Main Ave     or     W First St & N Main Ave But if I'm missing the spaces, then I get 0 results.  I have users who consistently enter intersections without the spaces.  I'd rather solve this myself than force them to change their data entry. Thanks, Shawna ... View more

Any help would be most appreciated... I need to execute an MS SQL stored procedure which creates a temporary table with xy records, and then interact with that temporary table via arcpy to create a point feature class.  I've got the stored procedure built, and I know how to make an XY event layer and then save the records to a feature class. Is there any way to execute the stored procedure and then use arcpy to interact with the results?  So far, I cannot find a way to make this work. ... View more

I have the following line of code: arcpy.SelectLayerByAttribute_management(gridLyr, "NEW_SELECTION", "\"Page\" Like \'"+ Neighborhood +"%\'") This line works just fine running directly in Python, or when running as a script tool in toolbox. However, when I publish the toolbox to ArcGIS Server, I get the following error: ERROR 000358: Invalid expression Failed to execute (SelectLayerByAttribute). Any suggestions? I'm not sure what is wrong, since it works great from my script. Thanks, Shawna ... View more

I am using arcpy.mapping to create an atlas that will run via ArcGIS Server - the atlas uses two dataframes.  One of the dataframes holds the data driven pages grid and the other dataframe has a locked extent (so it zooms to wherever the atlas dataframe is zoomed to).  Everything works very well, except very slow performance for one step of my code.  Here's some of the code I'm running- to find the mxd and then start updating some definition queries in my second dataframe (the one that has a locked extent): mxd = arcpy.mapping.MapDocument(r"pathtomxd.mxd") print datetime.datetime.now() for df in arcpy.mapping.ListDataFrames(mxd, "Street View"):      print datetime.datetime.now() When I compare the two datetime stamps- there is a 7 minute gap between the two.  Why is that?  The rest of the code runs in just about a minute (which is fine since it is exporting a whole map book).  But I just can't figure out why this one step takes 7 minutes. Any ideas would be most appreciated!  😄 Shawna ... View more

It would save us a lot of time and extra steps if we could create a topology that included data from multiple feature datasets.  I work in local government.  Each department that uses GIS has their own feature dataset(s) (so they can manage permissions), but we have data that depends on other departmental data (for example, we manage zoning and zoning has boundaries that follow parcel boundaries which are managed by a different department).  So, we have to copy their data into our feature dataset (nightly) in order to have topology rules based on their data.  When we do this process- it creates a maintenance headache- but it also makes it so we cannot save our topology rule exceptions.  Could you allow topology across feature datasets- but still allow users to control permissions to each feature dataset? Thank you, Shawna ... View more