Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About DavidPike
DavidPike
MVP Notable Contributor
since
01-21-2020
a month ago
2725
Posts created
1006
Kudos given
392
Solutions
1286
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by DavidPike
|
POST
|
import arcpy
input_table = r'put the path to your table here'
#lcb is the lower class boundary
width_age_range_1 = 14.5
lcb_age_range_1 = 0.0
width_age_range_2 = 50.0
lcb_age_range_2 = 14.5
width_age_range_3 = 35.5
lcb_age_range_3 = 64.5
median_list = [ ]
with arcpy.da.SearchCursor(input_table, ["TOT", "TOT_0_14", "TOT_15_64", "TOT_65"]) as cursor :
for row in cursor :
#if all numeric fields hopefully
n_over2 = (row[0]/2.0)
if row[1] >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = 0.0
if row[1] != 0.0 :
median = lcb_age_range_1 + ( ((n_over2 - cumu_freq)/row[1]) * width_age_range_1)
median_list.append(median)
continue
continue
if (row[1] + row[2]) >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = row[1]
if row[2] != 0.0 :
median = lcb_age_range_2 + ( ((n_over2 - cumu_freq)/row[2]) * width_age_range_2)
median_list.append(median)
continue
continue
if (row[1] + row[2] + row[3]) >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = row[1] + row[2]
if row[3] != 0.0 :
median = lcb_age_range_3 + ( ((n_over2 - cumu_freq)/row[3]) * width_age_range_3)
median_list.append(median)
continue
continue
else:
median_list.append("error")
for median in median_list :
print(median)
#obviously can add a field and append these values in rather than printing them. look at arcpy.da.UpdateCursors
... View more
01-31-2020
12:04 PM
|
3
|
24
|
5598
|
|
POST
|
It's not actually too hard. N/2 will be the cumulative frequency you're looking for, so a search cursor and a few conditional statements should find your median group. Then just plug that group's range and upper and lower bands into the grouped median formula. I can write it out if you like.
... View more
01-31-2020
11:19 AM
|
2
|
26
|
5598
|
|
POST
|
Perhaps try focal statistics on the original DEM to replicate the smoothing function. Then retry.
... View more
01-31-2020
09:12 AM
|
0
|
0
|
1627
|
|
POST
|
I guess it could be done by calculating the equations of both lines then solving to see if they are perpendicular and where the would cross, create a point at that intersection and points to line.
... View more
01-31-2020
07:43 AM
|
0
|
0
|
1727
|
|
POST
|
I'm assuming you meant this as 20 degrees (i.e 110 degrees)?
... View more
01-31-2020
06:29 AM
|
1
|
0
|
1567
|
|
POST
|
I'm not sure. Would probably merge into one FC, planarise, then export them out again. Would work but likely a better way!
... View more
01-30-2020
03:34 PM
|
0
|
0
|
2222
|
|
POST
|
import arcpy, os
# Set environment settings
arcpy.env.workspace = r"C:\Projects\points\test.gdb"
# Set the local variables
in_folder = whatever your folder is
merged_fc = name of final merged fc to be created in gdb
x_coords = "field7"
y_coords = "field6"
z_coords = ""
#grab all the text files and put them in a list
text_file_list = [ ]
for file in os.listdir(in_folder):
if ".txt" in file:
text_file_list.append(file)
# Make the point feature classes
path_list = [ ]
for text_file in text_file_list:
in_table = os.path.join(in_folder,text_file)
name = text_file.strip(".txt")
out_fc = os.path.join("in_memory",name)
path_list.append(out_fc)
arcpy.management.XYTableToPoint(in_table, out_fc,x_coords, y_coords, z_coords, arcpy.SpatialReference(4326))
arcpy.Merge(path_list,merged_fc)
arcpy.Delete_management("in_memory")
... View more
01-30-2020
02:50 PM
|
1
|
3
|
5217
|
|
POST
|
Ah I've gotcha. I'm unsure if features in a FC have an extent object. You could turn your FC into a feature layer then export each feature as it's own FC then grab the extents that way? Do everything in memory.
... View more
01-30-2020
11:23 AM
|
0
|
0
|
6998
|
|
POST
|
import arcpy
arcpy.env.overwriteOutput = True
cellSize = 50
sa = 2500
fullPlots = 0
halfPlots = 0
blockNum_list = [ ]
with arcpy.da.SearchCursor("L3OpSilv", "BLOCK_") as cursor:
for row in cursor:
blockNum_list.append(row[0])
blockNum_set = set(blockNum_list)
for blockNum in blockNum_set :
whereClause = "BLOCK_ = " + "'" + blockNum + "'"
counter == 0
with arcpy.da.SearchCursor('L3OpSilv', ["BLOCK_","SHAPE@"], whereClause) as cursor:
for row in cursor:
pLowerLeft = str(row[1].extent.lowerLeft)
pUpperRight = str(row[1].extent.upperRight)
fullExtent = row[1].extent
extXMin = row[1].extent.XMin
#arcpy.AddMessage(row[1].extent.YMin)
extYMin = str(row[1].extent.YMin + 10)
#arcpy.AddMessage(extYMin)
yAxisCoord = (str(extXMin) + " " + str(extYMin))
counter += 1
full_fishnet_path = "Fishnet_" + blockNum + "_" + str(counter)
clipped_fishnet_path = "Fishnet_" + blockNum + "_" + str(counter) + "clip"
arcpy.management.CreateFishnet(full_fishnet_path, pLowerLeft, yAxisCoord, cellSize, cellSize, None, None, pUpperRight, 'NO_LABELS', fullExtent, 'Polygon')
fishnetclipped = arcpy.Clip_analysis(clipped_fishnet_path, 'L3OpSilv', 'fishnetclip')
... View more
01-30-2020
10:53 AM
|
1
|
0
|
6998
|
|
POST
|
What do you want to happen or what is not working? I'm sorry I don't understand the question.
... View more
01-30-2020
10:17 AM
|
0
|
0
|
6998
|
|
POST
|
Run the Delete Identical tool on your neighbourhoods.
... View more
01-30-2020
10:10 AM
|
0
|
0
|
1249
|
|
POST
|
Try ushering and managing the update capability for each feature, log out, log back in, update ownership, log out etc. Can be very buggy. That's all I have, good luck!
... View more
01-29-2020
01:49 PM
|
0
|
0
|
2455
|
|
POST
|
Do you plan to use the tool on different tables and field names or is it just to constantly update the one table? If that's the case, just change the path as Dan Patterson has written out for you.
... View more
01-29-2020
01:41 PM
|
0
|
1
|
3153
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-17-2023 12:44 PM | |
| 1 | 06-13-2025 01:08 PM | |
| 1 | 09-25-2025 03:19 PM | |
| 1 | 09-24-2025 02:35 PM | |
| 1 | 09-17-2025 02:42 PM |
Activity Feed
- Got a Kudo for Re: Calculate precise population using 2020 Census Blocks and Spatial Join. a week ago
- Posted Re: ArcGIS Online Feature Service Webhook deactiviting itself on ArcGIS Online Questions. a month ago
- Got a Kudo for ArcGIS Online Feature Service Webhook deactiviting itself. a month ago
- Posted Re: ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings on ArcGIS Pro Questions. 06-17-2026 03:56 PM
- Kudoed Re: ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings for RichardDaniels. 06-17-2026 03:55 PM
- Kudoed Re: ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings for RichardDaniels. 06-17-2026 03:55 PM
- Posted Re: ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings on ArcGIS Pro Questions. 06-14-2026 11:59 AM
- Posted ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings on ArcGIS Pro Questions. 06-11-2026 02:32 PM
- Posted Re: Regedit values to start up ArcGIS Pro as named user on ArcGIS Pro Questions. 06-11-2026 05:24 AM
- Got a Kudo for Survey123 _form hosted feature layer view. 04-16-2026 02:54 PM
- Got a Kudo for Survey123 _form hosted feature layer view. 04-16-2026 02:51 PM
- Got a Kudo for Survey123 _form hosted feature layer view. 02-05-2026 10:43 AM
- Posted Re: ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning on ArcGIS Enterprise Questions. 01-14-2026 12:11 PM
- Kudoed Re: ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning for JoshuaBixby. 01-14-2026 12:10 PM
- Posted ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning on ArcGIS Enterprise Questions. 01-07-2026 01:22 PM
- Got a Kudo for Re: Broken bookmarks in Arc Pro. 12-19-2025 08:08 AM
- Got a Kudo for Re: Define Projection crack-down. 12-11-2025 06:02 AM
- Posted ArcMap 10.8.2 virtualisation - Azure Virtual Desktop (AVD) on ArcMap Questions. 12-03-2025 11:07 AM
- Kudoed Re: S123 web not honoring bind::type entered in connect for Neal_t_k. 11-14-2025 12:57 PM
- Kudoed Re: Way to convert indicator values to whole numbers for KenBuja. 11-14-2025 09:55 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
a month ago
|