POST
|
Joins seem a bit clunky in model builder so I was going to do an iterative select by location for each species. I don't need species counts, this is just a presence /absence. So reading down Column ThrSpec_1 may read Devil, null, null, Devil, Devil etc. ThrSpec_2 may be null, Quoll, Quoll, null etc... Part of the reason I wanted to do this iteratively was to create the columns on the fly as needed - select unique species value 1, create column, select parcels, fill values. Repeat for unique value 2. etc. I just don't know how to use an iterator to carry out a task on a different layer.
... View more
05-26-2021
03:56 AM
|
0
|
0
|
951
|
POST
|
Thanks Dan, this is a small part of a much larger model I'm building in Model builder. I'm kind of new to iterators so I'm not sure how to set this up. All of the species are in a single field in a point file and I would prefer to create Text fields named ThrSpec_1, ThrSpec_2 etc in a Polygon file of land parcels and populate the fields of selected records with the relevant species name. Does that make sense? Thanks, Steve
... View more
05-25-2021
04:27 PM
|
0
|
0
|
1085
|
POST
|
I have a table with a list of threatened species. Using model builder I want to add fields to a different layer - one field for every unique species value. The list will vary and the number of species will vary too so I can't create a predefined list of new fields. Is this possible?
... View more
05-25-2021
03:24 PM
|
0
|
4
|
1101
|
POST
|
Alternatively, convert your raster to ASCII and edit the values in notepad. Steve
... View more
07-03-2013
10:00 PM
|
0
|
0
|
1131
|
POST
|
Hi So what you have is a combobox with say...trees,shrubs,grasses and when select 'trees, the second combobox only loads up with tree species?? Mark Precisely. And before you ask the code is below. In this case item chosen from a dbf list linked to "cmbActn" will populate the combobox "cmbWrkMthd" sub SelectList 'sub to select specific entires from a dbf file for inclusion in dropdown menu on form, based on previous choice dim pLayer, pAction, pWorkMethod, filepath, GetPath set pLayer = Application.map.selectionLayer.Forms("EDITFORM") pAction = pLayer.Pages("PAGE3").Controls("cmbActn").value set pWorkMethod=pLayer.Pages("PAGE3").Controls("cmbWrkMthd") if pWorkMethod.ListCount > 0 then pWorkMethod.Clear end if GetPath = Left(application.map.selectionlayer.FilePath, InStrRev(application.map.selectionlayer.FilePath, "\")) if pAction <> "" then filePath = GetPath & "WorkMethod.dbf" pWorkMethod.AddItemsFromTable filePath, "Method", "Method", "[ACTION] = """& pAction & """" end if end sub 'SelectList and the dbf for the second combobox (in this case WorkMethod.dbf) must look like this: ACTION METHODTXT Weed Control Spray - Chemical Weed Control Spray - Rust Weed Control Hand Removal Weed Control Other (Please Type) Fencing Standard Fence Fencing Other (Please Type) Revegetation Reveg with Indigenous Vegetation Revegetation Other Reveg (Plse Type) hope that helps cheers Steve H
... View more
11-07-2010
05:29 PM
|
0
|
0
|
467
|
POST
|
Dashiell; you have to change the quickdraw setting to no display - i.e. the checkbox should be empty. Kind of unintuitive since the visibility box is unchecked but there you go. cheers Steve
... View more
08-19-2010
09:18 PM
|
0
|
0
|
306
|
POST
|
Thanks Eric that second script was just what I was looking for.:cool: Cheers Steve
... View more
08-16-2010
07:23 PM
|
0
|
0
|
312
|
POST
|
I have a custom form of several pages where users are continually entering data on the first page only and then exiting. Anyone know of a way of disabling the OK button until users reach the end of the form? thanks Steve
... View more
08-12-2010
06:35 PM
|
0
|
2
|
2603
|