Roy

2,200 reputation

723

bio	website	fws.gov/southeast/gis
	location	Atlanta, GA
	age	24
visits	member for	1 year, 3 months
	seen	17 hours ago
stats	profile views	86

I'm a GIS Specialist with the US Fish and Wildlife Service in Atlanta, GA.

	2,200 reputation	bio	website	fws.gov/southeast/gis	visits	member for	1 year, 3 months
723 badges		location	Atlanta, GA		seen	17 hours ago

summary answers questions tags badges favorites bounties reputation activity

226 Comments

suggestions reviews revisions comments badges posts accepts all

Aug 15	comment	How can I handle tables with 256+ variables? With any amount of DB Normalization I suspect that these huge tables should be separated into several (or many) smaller tables relating back to their Census unit (block maybe?) UID.
Aug 15	comment	Creating a raster map using Excel file and calculating averages It would be helpful to give an example of one row of your data. The workflow I'm envisioning is: Excel Workbook => ASCII Text => ESRI Raster
Aug 15	comment	Export each layer in map to a separate image Have you tried debugging by printing `LyrList` to see what the specific problem is? Is this for your own purposes or for someone else? I ask because you could do this without creating a script tool; see if it works by creating your own list as opposed to `GetParameterAsText`.
Aug 14	comment	Duplicate ObjectID in ArcSDE Table Would it be helpful to add a Global Unique Identifier (GUID)?
Aug 14	comment	Export each layer in map to a separate image Did you get an error? What about the script isn't working?
Aug 13	comment	Why do you use ArcGIS? Undergraduate GIS education teaches you what buttons to push as opposed to spatial analysis. Many times ESRI supports campuses with free student licensing so that you learn to push their buttons as opposed to someone else's. To that effect, I work for the Fed who also has an ELA with ESRI. They seem to have me surrounded.
Aug 8	comment	arcpy.UpdateCursor for multiple fields Ahhh I see your point!
Aug 8	comment	insert cursor “Row contains a bad value” The last line of the code is `newRows.insertRow(neue)`, but `neue` is setup to create a new row... Could that be the issue?
Aug 8	comment	arcpy.UpdateCursor for multiple fields I'm still a bit unclear about what you're trying to accomplish. In your script you're inserting the same string `'FIELD_ERROR_VALUE'` into every field. Your SQL statement is static as well, although you commented it may also be less than or greater than, etc.
Aug 8	comment	arcpy.UpdateCursor for multiple fields row.FIELD = "someString" is functionally the same
Aug 7	comment	Free / Open source GIS Education sources Spring 2012 MIT: Spatial Database Management & Advanced GIS
Aug 6	comment	How do I hyperlink a to bookmark on pmf or mxd? In that use case, you'd just have to save your mxd several different times. The extent at which you save the map will be your 'bookmark'.
Aug 3	comment	How do I hyperlink a to bookmark on pmf or mxd? +1 Nifty idea, but if you're adding a bookmark to the attribute table, wouldn't it be just as easy to select that record and zoom to extent as a work-around?
Aug 1	comment	Setting a query loop let us continue this discussion in chat
Aug 1	comment	Setting a query loop Then you might as well continue to use an UpdateCursor now -- use a `try:`, `except:` and `finally:` block to make sure you delete your cursor at the end of your script as illustrated in my sample code.
Aug 1	comment	Setting a query loop If that's the case we need the error messages -- I use this technique regularly, and can confirm that it works.
Aug 1	comment	Setting a query loop Agreed - I use model builder for documenting my analysis (it's much easier for most people to understand than looking at code). That being said I don't like to export models to scripts. It's sort of like using Dreamweaver to make a website WYSIWYG style -- I'm not a fan of the code it churns out. Might just be a personal style preference tho.
Jul 23	comment	Heat map which will be auto-updated from Google Docs I think you're looking for Google Fusion Tables - There's an API
Jul 20	comment	merging TIGER Line shp files for better labeling in ArcGIS If it's all about labeling, you can remove duplicate labels in the Placement Properties dialog of the Labels menu.
Jul 20	comment	merging TIGER Line shp files for better labeling in ArcGIS You could use the Dissolve Tool based on the FULLNAME field. I'm not certain if the calculate geometry would give you the combined length of segments or not -- worth a shot depending on what you're using the files for.