Latest Contributions by MarkVolz

Hello, I am considering using postgis/postgresql to host my published GIS data.  Note I am not using ArcSDE / postgres database, which requires a different license than what I have.  The current way that I know how to update the data from a production file geodatabase to the published postgis database is: 1) export the layer to a shapefile 2) use pgAdmin which has a tool to upload shapefiles into postgis.  I would like to instead use model builder which hopefully will make it easier to upload data into postgis. 1)  Is there a way to use model builder to load data directly to postgis? 2)  Are there any concerns with locks, if so how can I get around them? ... View more

Hello, I have a table that has one or more lines in for each parcel depending on how long the legal description is.  I would like to change it so that there is only one line for each parcel, and several lines for the legal description. Currently the table looks like this Parcel             Record       Legal 02-0002-901       1             NW1/4SE1/4 LESS W 500 FT, SW1/4NE1/4 LESS W 5 02-0002-901       2             00 FT OF S 753 FT & N1/2NE1/4 LESS L.P. BIG S 02-0002-901       3             TONE LAKE-WHETSTONE RIVER PROJECT I would like to change it so that it looks like this Parcel             Record       Legal Line 1                                                                                Legal Line 2                                                       Legal Line 3 02-0002-901       1             NW1/4SE1/4 LESS W 500 FT, SW1/4NE1/4 LESS W 5    00 FT OF S 753 FT & N1/2NE1/4 LESS L.P. BIG S      TONE LAKE-WHETSTONE RIVER PROJECT Any ideas on how to do this via model builder?> ... View more

Hello, I need to create a tax table that has different schema than the source table.  Basically I am trying to figure out the cleanest way to 1) Add many fields to a table, 2) calculate the new fields based on the values of the old fields, 3) delete the old fields. One possible solution that I came across is: 1) Include the add field function in my model 2) Right click on "Add Field" then make variable from parameter and add Field Name, Field Type, and Field Length if necessary 3) For variable add the number of variables that I want to populate 4) The add field function will then allow me to add many fields at once. 5) Repeat steps 2-4 for calculate field. The problem that I have is that in my subsequent "delete field" operation It tries delete each field 50 times (once for each new added field).  The code doesn't fail, but it is inefficient when it attempts to delete a field multiple times when the field only needs to be deleted once. My question is: 1)  Is this the best practice to add and calculate many fields at once in model builder? 2)  How can I get Model Builder to stop viewing the table as a list.  So that delete field and other operations only try to execute once? In the Image below when I create variables to add fields and calculate fields subsequent operations still recognize the table as a list, which is not wanted [ATTACH=CONFIG]14912[/ATTACH] Thanks ... View more

Hi, I have a couple hundred historic air photos for a county.  When I add all the pictures into arcview, the result looks alright, the collars hide parts of neighboring pictures.   If needed I could turn a particular picture on and off so that I can view what is behind it.  However that takes time, and also doesn't work for online mapping applications.  I also would like to eventually export the entire set of air photos into a single image.  Normally I would set true black as transparent for Landsat, or other remote sensing images.  However, each of the photos has a black collar around them which appears black, but is not "true black" and also it is not necessarily the darkest part of the picture.  Therefore I have to figure out something else.  I think it might be possible to create a mosaic and use the historic air photo that has the closest center point to populate the value of the new raster.  For example in the image below the black collar of BJC-4-20 covers part of a field south of town.  The field does show up on image BJC-4-46.  Since that field is closer to the center for BJC-4-46, I would like to use that historical photo as a source for the new raster, and effectively remove the collars from the new air photo. [ATTACH=CONFIG]14420[/ATTACH] Does anyone have any other ideas on how I could remove the collars off a bunch of air photos, and create a single new air photo image? Thank You ... View more

In addition to being able to pull up recent MXD files, It would be nice to bookmark MXD files in a similar to how web browsers allow users to bookmark websites, or go into a website history. Of course the function would need to be called something other than "Bookmarks" since bookmarks are already used for spatial bookmarks within an mxd ... View more

I would appreciate if there was a geoprocessing tool that will permanently rename the fields in a feature class with the field alias. ... View more

Hello, I an using model builder to join a table to a layer, then exporting that layer into a shapefile that permanently contains the data from the joined table.  At this time I am using "feature class to feature class to create my new shapefile."  The model seems to work, however I have a couple questions: 1)  By default most of the functions like to use field_join table as the name.  Feature class to feature class does allow us to rename fields.  However, it is time consuming to remove the table name from each of the field names.  Is there a quicker way? 2) When using feature class to feature class, is there a way to permanently control the field order.  Even if the layer file has been reordered and we use it as an input, feature class to feature class reverts back to the old field order. Thanks ... View more

Hello, Is there a way to permanently reorder fields in a file geodatabase via model builder? Thanks ... View more