Latest Contributions by KieranClark

Hm, unfortunately I had this checked already. I wonder if it's because all the Transpacific lines have a break in the middle at the date line. I had to draw them this way initially because every time I tried to draw lines that crossed the date line there was an issue where the line would wrap all the way around the world instead of just crossing the line. I will probably have to redraw some of these lines if I can avoid that wrap-around behavior but for now I can just output those handful of Transpacific maps manually. ... View more

Justin - this was absolutely the right answer! I just had to add a join to my cable landings table that associates landings with their cable systems (which was in a table I created already for other purposes) and using the Page Queries everything is filtering and displaying properly. The final hurdle I have to overcome is that a handful of cable systems that cross the Pacific are unfortunately not framed properly. See below:   Obviously, I would prefer the map series to frame it so that the cable isn't split like this. If there is not an easy way to do that, it's not really a big deal as I would have still cut down my manual workload by....about 90%. ... View more

Justin, thanks so much - this looks like it will get me on the right track!  ... View more

Oh wow, the Best Fit Extent gets me about 90% of the way there. As of right now, I can either have ALL the lines showing up or manually have to go through each map in the series and enable the display filter to show the single element that I need. Is there a way to automate this as well? Additionally, I'd like to have another layer present in the map filtered through an expression for each map in the series. We have 800+ landings (cities, basically) marked for all the cable systems but each individual map should only show that single cable system's landings. I have set up filter expressions for all the systems so all I have to do is load the filter, apply it then have all my landings present. ... View more

Hi Justin, Thank you for the detailed reply - however I think you might need to break it down a bit further for me. I'm not a true GIS professional so I'm not sure how to do some of the things you mentioned. I can add fields and set up calculated fields, though I'm not sure what the expression would be to do what you suggest. ... View more

So I've figured out how to get a video embedded as per: How To: Embed a video in pop-ups in ArcGIS Online for a hosted feature service  I've got a process to add the necessary iframe code and video source to my layers and it works on the map and even autoplays. However...the audio now plays twice, as if a second instance of the video is playing in the background about half a second later. I would appreciate some guidance - I hope it's a simple setting or URL parameter that I have overlooked. This is the map in question: https://subtelforum.com/cablemap/  And this is what the iframe bit looks like: <iframe src="https://www.youtube.com/embed/PAwUKXMFCVg?rel=0&fs=1&autoplay=1&playsinline=0" width="316" height="178" frameborder="0"></iframe>‍‍ Edit: Ok, change the iframe code to the following (basically just added mute=1) makes the video autoplay correctly, and without double audio. <iframe src="https://www.youtube.com/embed/PAwUKXMFCVg?rel=0&fs=1&autoplay=1&mute=1&playsinline=0" width="316" height="178" frameborder="0"></iframe>‍ The only downside is this makes the user have to manually unmute the audio, but I'm not terribly concerned about that. ... View more

Wow...it looks like that is all it was. Ok, thank you for the answer and I will certainly keep your comment about removing spaces in mind moving forward. ... View more

Dan, thank you for your help. You've given me a lot to work with and some avenues to explore to keep sharpening my skills. For now, as a quick and dirty workaround, I'm writing the initial JSON to CSV conversion to a temporary file then taking that temporary file and renaming the column headings. This allows the feature updates to happen and gets our project back in working order.  ... View more

Alright...clearly I need some further assistance. Where would I even start looking (documentation/examples) to try to resolve this issue? I understand the  keys = [k.replace(".", "_") for k in keys] line is intended to replace the period in the keys (column headers) after they've been defined or stored but how do I determine where in the process to do that step? ... View more

That is unfortunately what I suspected. However, I am not exactly an expert in Python yet and have had to rely on code examples to cobble together what's necessary to get my tools to work. The following code takes the JSON output from our AIS service and converts it into a CSV file: import json from pandas.io.json import json_normalize def loading_file(): #file path file_path = r'C:\Users\kierc\projects\api\latestshiplocation.json' #Loading json file json_data = open(file_path) data = json.load(json_data) return data #Storing Available Keys def data_keys(data): keys = {} for i in data: for k in i_keys(): keys[k] = 1 keys = keys.keys() #Excluding nested arrays from keys - hard coded -> IMPROVE new_keys = [x for x in keys if x != 'attributes' and x != 'change'] return new_keys #Excluding nested arrays from json dictionary def new_data(data, keys): new_data = [] for i in range(0, len(data)): x = {k:v for (k,v) in data[i].items() if k in keys } new_data.append(x) return new_data def csv_out(data): data.to_csv(r'C:\Users\kierc\projects\api\Ship_Positions.csv', encoding='utf-8') def main(): data_file = loading_file() keys = data_keys(data_file) table = new_data(data_file, keys) csv_out(json_normalize(table)) main() ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ It converts this to a CSV file very nicely, except for the column headers. I'm not sure where I need to change the code so that it uses an underscore instead of a period punctuation. Again, I'm a little unsure as to why these field names aren't working any longer. They were on the previous computer using ArcGIS Pro 2.4 - both through these python scripts and the tools within ArcGIS Pro. ... View more