POST
|
Hi All, I have a data driven map setup and it is very close to how we need it, but as my scale is set to best fit it is not percfect. 99% of my pages work great, and they look like this: Then on the other hand, I have a couple of sites which are a little 'busier', which makes my building points unreadable as they are in a cluster, see example: So what I am wanting to do, is calculate a field automatically which would be called "data_driven_scale", then I will be able to select the field in the "Set Up Data Driven Pages" dialog: So as I have 150+ pages I do not want to manually enter the scale I would like to use, but I would like arcmap to automatically tell me what it is using, then I can go through and manually edit the scale set for the handful of pages which need tweaking. Does anyone know if this is possible? Thanks
... View more
01-22-2015
01:48 PM
|
0
|
0
|
3189
|
POST
|
No you are 100% correct, I have only just now re-looked at this problem I listed a couple of months ago and it has clicked (i'm slow thats for sure! haha). I can simply list all versions, then reconcile said versions then delete. I will give this angle a go. Thanks for your help all. PS. Can someone confirm that if a user forgets to reconcile/post before I delete the version, all the add/deletes will be lost during a compress? Or are they lost as soon as the user is deleted? And secondly, if a user does forget, and I were to use reconcile version tool, do these two options achieve the exact same thing? There is no difference between me forcing the reconcile and the user remembering to? Thanks for the help.
... View more
01-22-2015
01:24 PM
|
0
|
0
|
511
|
POST
|
Hi All, I have a data driven map at approx 150 pages, and each page shows a land parcel, and on each land parcel we can have several buildings. So land parcels is a polygon with a SITE_ID Buildings is point feature class with a BUILDING_ID and a SITE_ID which is a key between the two. I have done a data driven booklet based on each site, and it shows the buildings within and their building ID. I want to add to each page an index showing each of the buildings shown, and the building name (so people can identify at a glance each building). My first question, is this possible? My second question, is there a tutorial somewhere? Added image, yellow site is data driven site, and yellow dot with numbers are buildings with same site ID as data driven site Message was edited by: Ben Van Kesteren
... View more
01-21-2015
06:55 PM
|
0
|
5
|
4820
|
POST
|
I have just tried adding the newly created Mosaic Dataset to a MXD to publish as map service, but it says I do not have Imagery Licence in order to do this... so it looks like I need to find another way to server this image to all other users.... Back to drawing board.... I have looked at what my predecessor (recently retired) had done in the past, it seems he has somehow created a raster on a server and added it that way. It must be a different licence using a mosaic than using a raster. Strange.... Thanks
... View more
01-21-2015
03:27 PM
|
0
|
0
|
2708
|
POST
|
So I have just created a mosaic dataset. I then right clicked and add raster. (see screenshot for window), then clicked ok, and it seems the raster is visible by my by single clicking the mosaic in ArcCatalog and looking at the preview window. I assume because it took < 1min to do that this is just a reference to the ECW on my network drive? It did not move a copy of it? The aerial photo I want to make available currently resides on a network share that only people in my dept can view, will this cause a problem? The alternative solution I can think of is that I move the aerial onto the C drive of my server, and make a copy of this folder (for example C:\Aerial2014) and set it up on my PC to reference the C drive, then when it is added to the mosaic will it look on the server C:\Aerial2014 instead of my PC?? Im a little new to working with rasters. Cheers
... View more
01-21-2015
02:07 PM
|
0
|
2
|
2708
|
POST
|
Hi, I have recently taken ownership of our Enterprize GeoDB, and today we received four ECW aerial photographs which tile to make up our City. We have existing Raster Datasets that the previous Admin has setup when he had been given imagery in the past, now I am trying to replicate his old work but incorporate the new imagery. This is the supplied data I have in my hand (albury, holbrook, tallangatta and walbundrie ECWs): This is how my predecessor had the imagery sitting on our SDE: I currently have an empty database to place the imagery into: Can someone please tell me the steps that need to be taken to import these images into the DB? Thanks very much for your time. -Ben
... View more
01-14-2015
05:01 PM
|
0
|
5
|
9133
|
POST
|
Hi all, I am playing around in ArcGIS Pro Pre-release and I am unable to work out how to add a table from excel to a map??? In ArcDesktop it was very straight forward, but it is not so straightforward in Pro... Anyone done this simple task before? Thanks
... View more
12-09-2014
02:20 PM
|
0
|
7
|
6964
|
POST
|
Excuse my n00bidity, but where would a default *.mxd be found?? Thanks
... View more
11-30-2014
03:02 PM
|
0
|
0
|
484
|
POST
|
Hi, Did you end up finding a solution to this problem? Have you got it working now? Thanks -Ben
... View more
11-26-2014
08:02 PM
|
0
|
0
|
2642
|
POST
|
Hi All, I have just compiled a list of scripts and models that I have bundled for the GISADMIN (Me) and placed them in the Toolbox which is created automatically in our SDE, into a new Toolset I just created within. What I want to do is quite simple, I just want to rename the toolset to something more userfriendly, but when I right click the Rename is not available. See screenshot below. Does anyone know if a rename is possible? Thanks
... View more
11-26-2014
03:28 PM
|
0
|
0
|
1778
|
POST
|
ah excellent, good point. Yes all the users are informed to reconcile or post each week prior to my weekly maintenance. This is generally successful, but as people are sometimes away at last minute we try to hold off the maintenance until everyone is at work. One thing I would like to consider, is reconcile/post on everyone's behalf. It is very unusual for someone not to want to reconcile/post each week, so to elimate this user error possibility I would like to automate it, so this is something else I am looking at setting up during this process. I have just had a quick look at the Reconcile Versions tool, and it is exactly what I am looking for, thanks for that Jake Skinner, greatly appreciated.
... View more
11-25-2014
01:44 PM
|
0
|
0
|
511
|
POST
|
I am currently running the below code to delete all versions before doing a weekly compress. But as you can see it is very primative and the hard coding of the names is becoming annoying as I am having to edit it each time a GIS User starts or leaves our buisness. Is there a simple tool that will find/list all versions? That way I can then go ahead and delete them once a list has been created. # Name: DeleteAllVersion.py
# Description: Deletes all versions from our SDE
# By Ben Van Kesteren 22/07/2014
# Import system modules
import arcpy
# Set local variables
inWorkspace = r"Database Connections/GISADMIN@SDE_Spatial@Smithy.sde"
Nathan = "Nathan"
Ben = "Ben_Edit"
David = "David_Armstrong"
James = "James"
Patrick = "Patrick"
Rory = "Rory"
Josh = "Josh"
MrsBeer = "Mrs_Beer_Edit"
#Russell = "Muddy_Edit"
Patrea = "Patrea"
Kerrie = "Kerrie"
SteveM = "Steve_Edit"
Helen = "Helen"
MattJ = "Matt_Johnson"
# Execute DeleteVersion
arcpy.DeleteVersion_management(inWorkspace, Nathan)
arcpy.DeleteVersion_management(inWorkspace, Ben)
arcpy.DeleteVersion_management(inWorkspace, David)
arcpy.DeleteVersion_management(inWorkspace, James)
arcpy.DeleteVersion_management(inWorkspace, Patrick)
arcpy.DeleteVersion_management(inWorkspace, Rory)
arcpy.DeleteVersion_management(inWorkspace, Josh)
arcpy.DeleteVersion_management(inWorkspace, MrsBeer)
#arcpy.DeleteVersion_management(inWorkspace, Russell)
arcpy.DeleteVersion_management(inWorkspace, Patrea)
arcpy.DeleteVersion_management(inWorkspace, Kerrie)
arcpy.DeleteVersion_management(inWorkspace, SteveM)
arcpy.DeleteVersion_management(inWorkspace, Helen)
arcpy.DeleteVersion_management(inWorkspace, MattJ)
... View more
11-24-2014
09:30 PM
|
0
|
4
|
3417
|
POST
|
Hi Owen, thanks very much for that, has worked well for this little script. So are you saying that print statements are not recognised by this ESRI window at all? I need to use AddMessage and AddWarning instead from now on? Thanks again.
... View more
11-24-2014
07:52 PM
|
0
|
1
|
880
|
POST
|
Just to give you a better idea of my problem, the below script returns a list of Users currently connected to my SDE... this script is only useful if i run it from the CMD window, if I run it from Catalog as a script it displays the window shown in my first post.. and as you can see it does not return a list of connected users. Cheers #-------------------------------------------------------------------------------
# Name: Find current users connected to SDE
# Purpose: This script is specifically written to be able to return a
# list of all current users connected to the SDE_Spatial database.
#
# Author: Ben Van Kesteren & Nathan Duncan
#
# Created: 14/11/2014
# Copyright: (c) Ben Van Kesteren 2014
#
#-------------------------------------------------------------------------------
import arcpy
import csv
def main():
PCNameKey = pc_name_key()
UserList = user_list()
outputFinal = output(PCNameKey, UserList)
for name in outputFinal:
print name
print name
print "\n" + str(outputFinal)+ "\n"
## Creates a dictionary from the listed CSV file
def pc_name_key():
reader = csv.reader(open('H:\\GIS Admin\\PCNumbers.csv'))
key_dict = {}
for row in reader:
key = row[0]
if key in key_dict:
pass
key_dict[key] = row[1]
return key_dict
def user_list():
# Set the admistrative workspace connection
arcpy.env.workspace = "H:\\ESRI SDE Connections\\GISADMIN@SDE_Spatial@Smithy.sde"
user_list = arcpy.env.workspace
# Create a list of users
'''
NOTE: When the arcpy.env.workspace environment is set, a workspace
does not need to be provided to the function.
'''
users = arcpy.ListUsers(user_list)
# Create a list of SDE connected usernames.
id_users = [user.ClientName for user in users]
current_users = []
for user in id_users:
if user != str(u'gisserver'):
user = user.upper() # set PC Numbers to uppercase
user = str(user)
if user in current_users:
pass
else:
current_users.append(user)
else: pass
# Count all users currently connected
total_users = len(current_users)
# Print the total number of users currently connected
if total_users > 0:
print "\nTotal number of connected users " + str(total_users) + "\n"
else:
print "\nNo Users Connected\n"
return current_users
def output(PC_Key, name_list):
output_list = []
for id in name_list:
if id in PC_Key:
output_list.append(PC_Key[id])
else: pass
return output_list
## Boilerplate
if __name__ == '__main__':
main()
... View more
11-24-2014
06:10 PM
|
0
|
4
|
880
|
POST
|
Hi All, I have a python script that I have just written and I am able to run it quite simply by opening the CMD window, and typing >>>python myScript.py and it runs great, it shows me all my print commands as it runs through. Now I have it working I want to add it to my Toolbox so I can simply run the script once a week to do what I have set it to do. I have quite simply right clicked the toolbox, and selected ADD | Script... I then get it to point at my myScript.py file, and thats it. So then I go back to the script in my catalog, and double click it and it runs. But unfortunately I am unable to see any of the Print statements as its the esri window, it only lets me know when its complete. Basically see the first screenshot of the text the script prints out, this is what I like... See this second screen shot, this is the ESRI version, I am hoping to get all my print statements to show in this window... is it at all possible?? Thanks heaps for your time.
... View more
11-24-2014
06:08 PM
|
0
|
5
|
2306
|
Title | Kudos | Posted |
---|---|---|
1 | 09-23-2018 07:38 PM | |
1 | 04-08-2019 10:05 PM | |
1 | 02-03-2019 03:06 PM | |
1 | 12-20-2019 07:16 PM | |
1 | 11-19-2019 04:28 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|