|
POST
|
I'm performing a grid analysis using a tessellation, 30 sq ft grid squares over a room in a building. I want to rotate the grid to line up with the geographic angle of the room on the map. I need to automate this process for over 10000 rooms. Since I can only manually rotate polygons (why is there not a tool for this?) I'm converting the grid to raster, rotating that to the room angle, and reconverting the rotated raster back to a polygon. The problem I'm having is that the raster cells become distorted when rotated. I'm trying to count the number of 30 foot squares are completely within the room and this distortion is throwing off the accuracy of the count because it's missing squares that would likely fit into the room along the top (see screenshots). I started this analysis a couple of months ago, and I'm just noticing this issue after upgrading to Pro 2.3. When I originally ran the analysis, this particular room had 15 squares completely within. Now it has twelve due to the cell distortion. This happens whether I run the process in Python 3, or if I do the steps manually in Pro. Tessellation to raster: Raster rotate: Raster to polygon: Three more of these squares were counted before the cell distortion
... View more
02-05-2019
02:01 PM
|
0
|
2
|
601
|
|
POST
|
OK. I'm in the middle of a separate support case, so I'll mention this to the tech. All I can tell you is that this project was created from an imported MXD and saved in Pro 2.2.4. When I opened it in 2.3, everything was missing.
... View more
01-30-2019
10:33 AM
|
0
|
0
|
814
|
|
POST
|
Yes, I only noticed this data connection problem on the aprx with the map series. I've never seen anything like it. The links are correct, except for the added folder in the path, i.e. "M:\PROJECTS\DATA\blah\map_series.aprx" where PROJECTS and DATA are two completely separate directories on the drive. Also, all the layer definition queries were gone, probably as a result of the paths being screwed up.
... View more
01-30-2019
08:46 AM
|
0
|
2
|
814
|
|
POST
|
Today I upgraded to ArcGIS Pro 2.3. I opened an aprx file with a map series. Every data link is broken* and all the map series pages and layer definition queries are gone. WTF!?!? *we have a drive with two separate top-level folders "PROJECTS" and "DATA." The file paths all say "M:\PROJECTS\DATA\..." after the upgrade. Luckily, this project was from an imported MXD, so I can start over without too much hassle. Still, this ain't good!
... View more
01-28-2019
03:24 PM
|
0
|
4
|
1000
|
|
POST
|
That was the first approach I tried, but I just figured out what the problem was. I needed a definition query on the layer itself that filters out rooms that don't meet the criteria. Then I can have table statistic dynamic text that sums just those values.
... View more
01-16-2019
03:24 PM
|
0
|
0
|
3713
|
|
POST
|
No, I'm trying to create a single sum for all features that contain the text prefix 'CR_'. I've been reading that Arcade can't be used on multiple records??? What is the point? I could accomplish this in seconds in Python, but I can only use Arcade expressions for Dynamic text in a Map Series.
... View more
01-16-2019
01:21 PM
|
0
|
3
|
3713
|
|
POST
|
I'm new to Arcade. I'm trying to summarize square footage for rooms of a certain classification (containing the prefix 'CR_') in a Map Series using dynamic text. The expression builder says my Arcade expression is valid, but nothing is being printed to the dynamic text box.
... View more
01-16-2019
11:05 AM
|
0
|
8
|
4744
|
|
POST
|
I have a map series of 225 site floor plans. I want to be able to display total square footage summed by room type with dynamic text. I'm able to accomplish this with a custom SQL query. The problem is, I need the site name specified in the query, and I need that to change for whatever page of the map series that I'm on. As it stands, I can choose either "custom query" or "map series rows" in the insert table statistic query dropdown. Is there any way to pass the page name (site name in this case) into the custom query? Could this kind of functionality be added to a future update of Pro?
... View more
01-10-2019
09:00 AM
|
0
|
2
|
1852
|
|
POST
|
Well, the P/A ratio works really well in many cases. <0.15 ratio using -3 foot distance threshold and >.02 ratio using -6 foot distance threshold results in a reasonable number of selected grid cells. However, in this particular case in the photo below, the opposite is true. These rooms have a very low P/A ratio, but using -3 feet results in too many grid squares being selected (in this case 27). Using -6 feet is more reasonable (20 grid cells selected), but that blows up the model. We want to count grid cells inside the room, but using 'within' or 'completely within' also results in far too few grid cells being selected.
... View more
01-07-2019
04:58 PM
|
0
|
0
|
1666
|
|
POST
|
Ah duh, I just realized I needed to assign arcpy.SelectLayerByAttribute to a variable "selection" and then copy that. That did the trick!
... View more
01-07-2019
02:12 PM
|
1
|
0
|
2739
|
|
POST
|
I'm trying to use arcpy to recreate clicking on a row in an attribute table, and exporting that row to a new class. I'm iterating through a feature class with 12,000+ records and filtering out features that meet a certain criteria (room classification). Using Select Layer By Attribute and Copy Features I'm getting every single row copied over. I think my where clause might be the issue. Here is my snippet: for row in arcpy.da.SearchCursor(fc, '*' ,sql_clause=(None, "WHERE CurrentSpaceClass = 'CR_Reg'")):
OID_field = arcpy.Describe(fc).OIDFieldName
site = row[8]
room_number = row[9]
pa_ratio = row[18]
angle = row[16]
site_no_space = site.replace(' ','_')
room_feature = scratch_gdb + site_no_space.lower() + "_room_" + room_number
where = '{0} = {1}'.format(arcpy.AddFieldDelimiters(fc,OID_field),row[0])
arcpy.SelectLayerByAttribute_management(fc,"NEW_SELECTION",where)
arcpy.CopyFeatures_management(fc,room_feature)
... View more
01-07-2019
01:48 PM
|
0
|
3
|
3023
|
|
POST
|
The definition is the issue. I calculated the P/A ratio of the room in the screenshot, and another room in the same building that is totally square. The wacky room's ratio is 0.21 and the square is 0.13. I'll try using >0.2 as the threshold for irregular shapes and see how it does.
... View more
01-04-2019
11:23 AM
|
0
|
0
|
1666
|
|
POST
|
I'm doing a grid based analysis for functional room capacity, trying to verify out how many 30 square foot blocks will fit comfortably in a room. I'm confirming this visually and against numbers generated in Excel by an architect. It works very well using the Select features by location tool within a distance of -3 feet from the polygon edge in generally rectangular rooms. However, I have to change this threshold to around -6 feet before it starts to make sense in awkwardly shaped rooms. I need to apply the same methodology to thousands of rooms, so I need the threshold to be a variable. Is there a programmatic way to identify irregularly shaped polygons? Should I look at Calculate Metrics from the Topographic Production Tools? I think my organization might have a license for this.
... View more
01-04-2019
09:14 AM
|
0
|
3
|
1816
|
|
POST
|
Right. Hopefully ESRI will work on making that "Pro" tool more than a useless surface level thing. I won't hold my breath. This script was developed by my predecessor as an ArcMap 10.5 toolbox before anybody had installed Pro. I've been trying to port it over with limited success. I'll add try/except statements and see if that helps. Honestly I could care less about running this in a toolbox in Pro, but I need to be able to make it accessible to other people in my organization. I've always found it better to run Python scripts that use arcpy from IDLE or the command line instead of inside ArcMap.
... View more
12-31-2018
10:15 AM
|
0
|
0
|
2223
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 04-08-2019 09:21 AM | |
| 1 | 04-05-2019 04:21 PM | |
| 2 | 04-01-2019 10:11 AM | |
| 1 | 03-22-2019 09:30 AM | |
| 1 | 05-16-2019 08:42 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:24 AM
|