|
POST
|
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
06-26-2012
06:36 AM
|
0
|
0
|
628
|
|
POST
|
Tim, It looks like your doing what I want to do with pivot tables. I changed my record number from a double to a short int and I am still having trouble with the pivot table. Here is what my inputs are. Input Fields: PIN (text) Pivot Field: RecordNum (Short Integer) Value Field: Legal (text) I think this looks right, but it is not working. I get a generic 999999 Error. Let me know if I am doing something wrong If I cant get this working maybe I can try calling support or using the python code
... View more
06-08-2012
10:36 AM
|
0
|
0
|
1622
|
|
POST
|
@ m.cain I thought about creating a temporary table, then joining them back together. Unfortunately I will be dealing with up to 50 or more fields. That could be a lot of work, that is unless I find a way to automatically iterate through the results. @ rthopper I do have ArcInfo, and after sending the original message out I found the pivot table function. Despite double checking my inputs the function failed. I thought it might have been a bug in 10.1RC, until I came across a forum for Micorosoft Excel, which limits the values for pivot tables to numbers. In this case I need a string. Do you know if Pivot Tables in ArcGIS are limited to numbers? Also, I found a note stating that it might be possible to use strings with Pivot Tables in Access... I haven't checked it out yet, but I would still prefer to do all my work via model builder. http://help.lockergnome.com/office/Displaying-Text-numbers-Pivot-Table--ftopict942562.html
... View more
06-08-2012
05:17 AM
|
0
|
0
|
1622
|
|
POST
|
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
06-07-2012
11:19 AM
|
0
|
6
|
1837
|
|
POST
|
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
06-04-2012
06:54 AM
|
0
|
0
|
4220
|
|
POST
|
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
05-18-2012
06:34 AM
|
0
|
2
|
1797
|
|
IDEA
|
-->
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
02-29-2012
08:48 AM
|
8
|
3
|
874
|
|
POST
|
Joel, Thank you for the reply. Feature Class to Feature Class seems to work if the schema of the data will always be the same. I found that if a client wants different variables, or variables ordered in a certain way I had to create a whole new feature class to feature class as we cannot reorder fields once they are in the model. Therefore, in cases where the schema changes, it was recommended that I use a template table and append the new data to the template, which I think is a little frustrating.
... View more
08-24-2011
05:43 AM
|
0
|
0
|
467
|