|
POST
|
Remigijus: Thanks for the feedback...it does help a lot and it's most appreciated. I have never posted a snippet of code here before...so I will have to explore that further to see how it's done, and then use that next time. I see where I made my mistake now. I didn't pass the results of my select to a variable and then pass that to my calculate field command, nor did I pass the select result variable to my GetCount command. I was probably thinking like I do when I do this manually using the Select tool and just assumed the results would magically happen :-). I made the adjustments and the script now works perfectly. Thanks again.
... View more
11-25-2019
10:49 AM
|
0
|
0
|
3404
|
|
POST
|
I haven't written a Python script in years...so this is my first one in a LONG time. With that in mind the issue could be more than one issue...I'm not sure. I have a Python script almost working...just one more hurdle to complete and I'm ready to move on. I'm running this script in ArcGIS Pro 2.4.2. There is a sample feature class with 100 points, plus I created a list to extract values that will be passed to a "calc" function later. The "list" I created was made using the Summary function in ArcGIS Pro, and I employ a cursor function as per below. It too works really well and does what it's supposed to do. However, this issue has me a little stumped, but I'm sure it's relatively easy to resolve...it could be a few different things, or it could be that Python isn't even capable to doing it they way I'm doing it. The script does everything I want it to do except select the specific records in an attribute table. I also have a CLEAR_SELECTION process that also runs immediately after this SelectLayerByAttribute string, but I don't know if it's doing anything either. If I do this select manually it works without issue, but in a Python script it seems to have an issue. Rather than select the specific group of records based on a unique identifier (MMSI) this SelectLayerByAttribute process selects the entire table for each iteration of the loop. So when I calculate the field (in the next step) it just overwrites everything that was calculated in the previous iteration each time. This process should update all of the blank fields/records found in the attribute table...and it too also works well manually. So can anyone see what the issue might be here? The code appears to be correct, so the does the syntax...what am I not seeing that will make this work properly? Thanks
... View more
11-20-2019
01:39 PM
|
0
|
8
|
3615
|
|
POST
|
Thomas: Thanks for this info...this really helps. I'm not a SQL Server person, but our SQL Server people here are also not GIS trained or experienced. So I guess the rule that will be documented then is to refrain from spatial editing using SQL Server, and if necessary only work with attributes in that environment. We're converting a lot of data and the resulting feature class is routinely missing records (but we know what the reason is and there is no way around this during the conversion process), and it would be so much easier if the SQL Server DBA could just automate a SQL process to fill in the blanks. However, if they cannot do this then it will require a Python script to perform that task in ArcGIS Pro...or perhaps even doing this in FME (if possible). It just seems to work faster in SQL Server though.
... View more
11-13-2019
08:23 AM
|
0
|
0
|
2395
|
|
POST
|
Asrujit: Thanks for the link...this looks like something I need to read, and will do so today.
... View more
11-13-2019
08:17 AM
|
0
|
0
|
2395
|
|
POST
|
Thanks Joshua...I was choosing a larger font, but in my browser it doesn't look too bad at all. However, I'll use a smaller font here. I'm not quite sure I'm asking about SQL access to enterprise geodatabase data, at least after reading that web page on the subject. In that page there are references to avoid certain actions though, so this tells me that I am on the right track though. Perhaps I should rephrase the question. What we have tried successfully here is because our Enterprise Geodatabase is integrated with our SQL Server we are able to see, open and calculate those geodatabase records from within SQL Server itself. So only opening SQL Server we are able to update "some" things (like attributes) in the geodatabase, but these changes are not altering the spatial data, just the attribute data. What concerns me here though is whether our SQL Server DBA can accidentally delete a record in that geodatabase from within SQL Server, which if possible in my mind would mean that the data will be corrupted. But I want to make sure before I try to document this in a governance document regarding spatial data. Have you ever tried to edit and/or delete an enterprise geodatabase record just from within SQL Server? I would be impressed if one could delete an Enterprise geodatabase record in this manner as that would be altering the spatial data itself...and who would need ArcGIS (or ArcGIS Pro) if this type of work can be done in SQL Server?
... View more
11-12-2019
03:48 PM
|
0
|
2
|
2395
|
|
POST
|
Thanks Kory...appreciated. My thinking now then is that there are some spatial analysis tools available in SQL Server spatial (like you pointed out), each of which will result in a new feature class. But if one tries to delete a record from a file geodatabase using only SQL Server then should I assume that the spatial data will probably be corrupted? Would you know if these basic spatial analytical tools are native to SQL Server, or does SQL Server use ArcGIS in the background to perform these tasks? I guess another way to ask this would be, "can one perform these analytical tasks within SQL Server if there is no ArcGIS on that machine?"
... View more
11-12-2019
01:28 PM
|
0
|
4
|
2395
|
|
POST
|
I remember years ago (before spatial databases were readily available) that one could not perform any geoprocessing on spatial data stored in a database that was using ArcSDE. All spatial operations had to be performed only using the GIS (in our case ArcGIS Pro). However, with newer versions of Oracle Spatial and SQL Server Spatial has this since changed? Can one perform geoprocessing functions within SQL Server now, or does one still need to use ArcGIS? What is one restricted to do solely in SQL Server, and what should be the sole domain of ArcGIS? I know we can go into SQL Server and update tabular data that is in a geodatabase, but what happens if one deletes a GDB record in SQL Server? Does the point/line/polygon also delete? Or is one's data now corrupted like it was in the old days? SQL Server Spatial can store spatial data better than it could in the past (actually I don't think it could store spatial data in the past), but where does data storage end and data manipulation begin with spatial data being stored in SQL Server? I'm just trying to set up ground-rules for our spatial data stored in SQL Server to hopefully prevent the wrong people from making regrettable edits in spatial data...to avoid all of the usual headaches that will undoubtedly occur. Thanks
... View more
11-12-2019
09:57 AM
|
1
|
9
|
2705
|
|
POST
|
We would like to move forward with our drone technology but because we were burned trying to post-process drone images collected with a DJI Phantom IV and found that the camera was not compatible with ArcGIS Pro we are being quite cautious now. How does one determine in advance if the camera in a particular drone model is compatible with ArcGIS Pro, and consequently readable in Drone2Map? A drone that caught our attention is the Skydio 2 that comes with a Sony IMX577 1/2.3” 12.3MP CMOS camera. How do I know in advance if this camera will work with ESRI? ESRI won't tell us, probably for a variety of reasons. Thanks
... View more
10-09-2019
02:38 PM
|
0
|
1
|
984
|
|
POST
|
Never mind...I was just able to answer my own question :-). I just copied my existing Map Frame from within the TOC, renamed it, then resized it, and then activated it and zoomed to the area of interest. This might be one of a few different ways of doing this, but this works well :-).
... View more
10-04-2019
10:01 AM
|
1
|
0
|
3463
|
|
POST
|
I'm using ArcGIS Pro 2.4 and am trying to replicate an inset map that I had created using ArcGIS Desktop 10.6.1. I have made several of these using ArcMap, but never (yet) in ArcGIS Pro. I don't seem to be able to find a way of doing this in ArcGIS Pro though...can this be done? How does one add an inset map to one's layout in a ArcGIS Pro mapping project? What is the workflow in ArcGIS Pro? Thanks
... View more
10-04-2019
09:42 AM
|
0
|
1
|
4886
|
|
POST
|
I have created a few web applications for general staff to use through our Portal for ArcGIS. So far it works very well. However, an issue I can see that will cause users to hesitate to use the application is when they want to print a map (i.e. create a JPG or PDF for sharing to external parties). When one creates a JPG or PDF using the Portal print services one either has the option of letting it default to whatever scale the current scale of the map is in (which isn't desirable because no one wants to see 1:71,396.002439 in their legend). However, there is an option to force the scale too, which does work...but in order for a user to get it right quickly they currently have to reset the scale 2-3 times before they get it right, and this creates an issue for staff (i.e. time). What would be ideal is being able to see the current scale in the web app itself, and the user can then centre their map and then round the scale up or down to make it a number that makes sense (i.e. 1:50,000), and then create their PDF. Being able to quickly determine the scale within the web app would be perfect. The question is, "can this be achieved?". So far all I have been able to do is add a scale bar and coordinates to my web apps, which although looks nice, doesn't really solve this issue. The scale does show up nicely in the printed map though :-). Thanks
... View more
09-19-2019
10:12 AM
|
0
|
0
|
510
|
|
POST
|
I have been struggling with this for quite a while, so a quick solution would be awesome. When I build a web-app using Portal for ArcGIS there are quite a few color options from which to choose. However, I find that if I need to use a light color then it becomes very difficult to see the icons. Here is an example when the web-app colors are dark: However, if I choose a light color the icons do not adjust accordingly...they remain light: We have new corporate colors and I'm currently making changes to our web apps to reflect this, but being able to use dark icons in some cases would really help. Suggestions?
... View more
09-17-2019
10:05 AM
|
0
|
0
|
426
|
|
POST
|
SOLVED (for now) Using the SQL MOD function formula within the Select By Attributes geoprocessing tool (Using ArcGIS Pro 2.4): MOD(OBJECTID+2n-x, n) = 0 • n is the every nth record • x is the Objectid to start from This will select every 10th record in a feature class, which reduces the point total by about 90%. There is some loss of data in areas where the points are moving faster in some areas when compared to others (this is AIS data, which record ship locations over a period of time), but for the most part this does work fairly well.
... View more
07-12-2019
04:02 PM
|
0
|
0
|
1836
|
|
POST
|
We are collecting AIS (Automatic Identification System) ship data to create heat maps in Portal for ArcGIS, and for the most part this has been successful. However, we are also quickly running into an issue of too many points. We have considered to reset the AIS feed to only collect points ever 60 seconds (or even greater)...right now it's collecting points more frequently than that. So for about 1 month's worth of collected data we are acquiring between 3.5 and 5.5 million points. I can get away with publishing that to our Portal, but when publishing more than one month's worth of data it becomes very restrictive and challenging. So rather than alter the AIS feed to only collect data every minute (or longer), which cannot really be done because our AIS feed is being used by other services, the thinking is to statistically filter the points we have already collected using ArcGIS Pro, and then publish that to Portal. What would be the best tool for this? If I want to reduce the number of points from say 4-million to less than 250,000, and still maintain enough data integrity to be able to produce meaningful heat maps, is there an optimal way of doing this? I'm guessing that this might be something akin to generalization, but with points. Ideally, we would like to be able to create heat maps on demand using Portal for ArcGIS, and keeping our point total for the year to be under 4 million would be fine. But is generalizing points possible? Thanks
... View more
07-02-2019
03:55 PM
|
0
|
1
|
1983
|
|
POST
|
We find ourselves in dire need of using something like Drone2Map to rapidly get georeferenced drone captured imagery into an orthophoto and distributed to the right people that same day. I have tried using just ArcGIS Pro to demonstrate how difficult it is to import such drone imagery, and then have it georeferenced (which because of bugs I had to do manually) where it can be used immediately in a GIS. It took days to go through 50-100 images to create a mosaic to use in the GIS, and the accuracy was horrendously poor; hence, our use case does strongly support a need for the software. I need to learn (and then explain to managers) though how Drone2Map actually works (i.e. the workflow). If there is any manual adjustment in the GIS needed for this imagery it will not be an easy sell: Are the captured images from a drone's camera georeferenced using Drone2Map? (i.e. will they simply drop right into one's GIS and into their correct location once loaded as a layer?). Does one still need to manually shift the captured images (or tiled images) to "fit" once they are in the GIS? What sort of post-processing (if any) can one expect to perform after the images have been captured (i.e. after using Drone2Map), or does Drone2Map simply take care of all steps in the workflow? If one does the appropriate flight planning, is there a limit to how many images can be stitched together to make one large image (we have elevation restrictions in place here because of two aerodromes)? Does Drone2Map take into consideration the pitch, yaw and elevation of the drone, plus the direction the camera was facing at the time images were captured (is the scale, image rotation and precise location correct when brought into the GIS)? I'm pretty well sold on the technology, but I do still need to properly inform senior managers here just how much this software will improve our drone image capabilities. Thanks
... View more
05-31-2019
01:19 PM
|
0
|
1
|
1854
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 11-26-2018 03:37 PM | |
| 1 | 03-12-2020 12:36 PM | |
| 1 | 11-12-2019 09:57 AM | |
| 1 | 02-12-2020 02:57 PM | |
| 1 | 11-25-2020 11:39 AM |
| Online Status |
Offline
|
| Date Last Visited |
04-30-2023
12:47 PM
|