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
Wednesday
2720
Posts created
1003
Kudos given
392
Solutions
1281
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
|
I would have thought the mosaic operation would require a spatial reference? That's a big indicator of the problem. Defining the spatial reference will not affect the data, it just let's the system know what it's looking at. Use the define spatial reference tool first and calculate statistics. Check the tiles match up with other boundary data etc.
... View more
02-01-2020
08:09 AM
|
0
|
2
|
3108
|
|
POST
|
I've edited it again to attempt to go into the attribute tasble
... View more
02-01-2020
08:06 AM
|
2
|
3
|
978
|
|
POST
|
Edited. If that doesnt work try it on a subset of features, say 100
... View more
02-01-2020
07:30 AM
|
2
|
5
|
1172
|
|
POST
|
Wow looks awful. I've edited the code to just spit out the values, -999 represents rows where no median could be computed.
... View more
02-01-2020
06:56 AM
|
2
|
7
|
1172
|
|
IDEA
|
Perhaps you could use a raspberry pi or laptop connected to the tv as a cheap alternative until this is hopefully resolved for you?
... View more
02-01-2020
06:45 AM
|
1
|
0
|
2640
|
|
POST
|
Check your attribute table, should have populated it
... View more
02-01-2020
06:23 AM
|
2
|
1
|
1172
|
|
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[0] == 0 :
median_list.append(-9999)
continue
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(-999)
#for median in median_list:
#print(median)
counter = 0
with arcpy.da.UpdateCursor(input_table, ["median"]) as cursor :
for row in cursor :
if counter < len(median_list):
row[0] = median_list[counter]
try :
cursor.updateRow(row)
counter += 1
except :
print("error at count - " + str(counter))
else:
break
print("complete")
... View more
02-01-2020
04:57 AM
|
2
|
13
|
6749
|
|
POST
|
You could pretty easily populate the column by copying and pasting the printed values into your blank column whilst editing the table. Are they correct?
... View more
01-31-2020
04:47 PM
|
2
|
1
|
1231
|
|
POST
|
Wow, I'd test the results against your website, bear in mind it may have calculated lower class boundaries different from what you expected. Basically test quite a few features to see if correct result
... View more
01-31-2020
04:40 PM
|
2
|
1
|
1231
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 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 | |
| 1 | 09-10-2025 02:35 PM |
Activity Feed
- Posted Re: ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning on ArcGIS Enterprise Questions. Wednesday
- Kudoed Re: ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning for JoshuaBixby. Wednesday
- Posted ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning on ArcGIS Enterprise Questions. 2 weeks ago
- 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
- Kudoed Re: Way to convert indicator values to whole numbers for Neal_t_k. 11-14-2025 09:55 AM
- Kudoed Re: How to paste in a long list of data to existing polygon features? for Bud. 11-10-2025 03:51 AM
- Kudoed Re: Identify missing lines between two datasets for VinceAngelo. 10-07-2025 01:02 PM
- Posted Re: Way to get rid of year value in arcade date expression on ArcGIS Online Questions. 10-07-2025 12:55 PM
- Posted Re: 'Extract Multi Values to Points' Alternative in ArcGIS Pro?? on ArcGIS Pro Questions. 10-01-2025 02:43 PM
- Kudoed Re: @pulldata in Survey123 stopped working for Neal_t_k. 10-01-2025 02:36 PM
- Kudoed How to correctly apply a filter when creating a joined view layer with addToDefinition in arcpy? for JuanTomásMartinez17. 10-01-2025 02:34 PM
- Kudoed Re: Dynamic Label of a Calculated Field for Robert_LeClair. 09-30-2025 02:37 PM
- Kudoed 'Extract Multi Values to Points' Alternative in ArcGIS Pro?? for BaileyCranford. 09-30-2025 02:32 PM
- Kudoed Re: Generate polygons that represent historic air photo footprints? for AlfredBaldenweck. 09-30-2025 02:30 PM
- Posted Re: Wrong Sclae while export PDF with scale >1:250000 on ArcGIS Pro Questions. 09-29-2025 05:35 AM
- Kudoed Re: Pro 3.5.3 Painfully Slow for Joshua-Young. 09-26-2025 03:18 PM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Wednesday
|