Latest Contributions by PasqualeLanera

Thanks. We suppose that the first value of the field MyTasteValue in the Iterator is Grid-25  1) The first query selects all records (usually the max value in a cell is one) in the  HabitatPnts_SJ_GridPolys feature class with an Area of 50 (max value) and where MyTasteValue=Grid-25. So the records selected are usually 1, rarely 2. In the model follow the second Selection by attribute. 2) When you say for the second Selection by attribute: "That selection set includes the one (or more) points you are interested in returning, plus all other points with an Area of 50." You mean that in the the Grid-25 (a cell of the grid) there are also the points with an Area of 50 of Grid-25 or of other Grid-cells (Grid-26, Grid27, ...) ?    3) You say: The second select by attribute excludes all points not in Grid-25; leaving you with just the points you want (I.E. those points (one or more) that represent the highest habitat by area in that grid cell).   I am not well convinced about this statemen, so I decided to delete the second Select Layer by Attribute and run the model. With this change the output was the same of the original model, only 3 records, only the point with the max value of "Area" of each polygon! What do you think about it ?  4) You have not answered a my question. Wich are the difference between the two tool "Select Layer by Attribute" and "Select by Attribute" ? Could I use in the model also "Select by Attribute" ? Sincerely      ... View more

Hello Kim. Can you expalin two things: 1) Select Layer by attribute and  Select by attribute are the same ? If no why you use the first ? 2) In the query: Value = (SELECT MAX(Value) FROM MaxTestPoints_SpatialJoin2 WHERE MyTestValue = '%Value%') why there is '%Value%' and not only Value ?  ... View more

If I want generate the value for the field MyTestValue I would like to use the Field Calculator from Table: How can write a script that make a union of a text "TestPoly" and the value of ObjectID or progressive numeber ? TestPoly4 TestPoly5 ............... TestPoly495054   ... View more

Hello. Your model RUNNNNNNN with your data!!!!! Now I have my Feature Class with over 500,000 records. How can generate values of the field MyTestValue in my Polygon Feature (over 500,000 of records) ? Can I add the text "TestPoly" or another text to OBJECTID number or to a progressive number using the Field Calculator for my numerous records to obatin an unique ID ? Could you send me the scripts for the Field Calculator to generate this unique ID ? Another simple solution could be: copy the OBJECTID into field MyTestValue. Is a good idea ?   Thanks, Thanks Thanks my friend   ... View more

Hello. I askek you to send me  the model because it is not possible read the SQL script in the figure 7. Thanks a lot ... View more

Hello Kim. Excuse me with wich ESRI platform the solution of my problem will be more easy ? My polygonal and point feature have over 500,000 records. Do your solution run also if a polygon is empty or if has only one point within ?   ... View more

Thanks Kim, I an not a expert with Models so it is a little difficult. I have some requests. 1) Why you add the field MyTasteValue in PolygonTest ?  2) MyTasteValue  is to identify each polygon, so if there is 4 polygon I will have also TestPoly3 and TestPoly4 ? 3) Why don't use the field ObjectID instead of MyTasteValue  4) Could you add the figure of the Apppend Tool ? 5) Why there is "(2)" or "(3)" after the name of an object in the green box Could you send me yours GDB or shapefile of the example and the model saved like a tool ? My email is planera63@gmail.com   Thanks, thanks, thanks    ... View more

This is a one time process or I will have to repeat some time. But it is very strange that with the Spatial Join I don't solve the problem.  ... View more

In a File Geodatabase. ... View more

Thanks Kim The polygon feature class (FC) "Grid" with over 100,000 cells (each cell is 1 km square) is the target Feature and the point FC "PointHabitats" is the Join Features. Each cell can intersect one or more points.  I don't undestand how select in a new layer within a cell the only point with AREA = max and the corrispondence value of HABITAT. I have to use the command SELECT in ArcGIS ? Or I have to use an external database ? I prove with the tool SELECT but I don't know the exact SQL statement to write. With: "Target.ID = Target.ID AND AREA is max" does not run. The points within the same cell have the same Target.ID    ... View more

Where do you work and what is your role? I currently work for ISPRA, a  government Institute for environmet in Italy.   My role is to know a little bit about a lot of things in GIS and remote sensing in the marine ecosystems.    What GIS success have you had this year and what product did you use Lately I have been working with ArcGIS platform.   What is your expertise (GIS related or not), and how can that help the community? ArcGIS. Currently working on providing the best utility for marine habitat mapping from remote sensing and drone. ... View more