Latest Contributions by PetronilaMandeno

Hello Josh, thank you for your ideas! I do have Spatial Analyst and I thought of using Zonal Statistics, but I don't know how to efficiently create a bunch of zones along the line. Any thoughts on that? Regarding the distance for the spatial join, there isn't an option to do that. I *wish* there was an option, but the only options I get when I do the spatial join is intersect or nearest points. (I don't want the intersect because the hazard layer has the road represented in it and it's just 0 - I want the hazard rating around the line). Thanks again for your idea. I will research more to see if I can come up with a way to use the zonal stats. ... View more

Hello Dan - thanks for thinking through this. You are right. I don't need an average. The most frequent hazard rating would be closer to what I need. Thanks! ... View more

Follow up: here's what I ended up doing: Buffered my roads by 200 feet With that buffered layer, extracted by mask from the hazard raster Convert those to points (deleting any that were less than 1 or null) Then I split my roads into 200 foot sections (its just a manageable distance to use) Lastly, I did a spatial join, joining the point data to the lines and used the nearest option (instead of intersect) and computed the average only. This will work for now, but I don't know what 'nearest' means. Does it just use the ones it encounters first all along the line or does it use a set distance? Would be cool to be able to set a distance. If anyone else has a more elegant way of doing this, please let me know!  ... View more

I have almost the same question! My idea was to create points along the line, extract the values from the raster to the point, and then spatial join the points to segmented portions (regular intervals) of the line. But I need an average of the raster value around each point (since the roads are already represented in the raster and a value under the point themselves would just return 0). ... View more

Yes! Sorry I didn't come back to let folks know. What I ended up doing was re-doing the join and *not* creating a view out of it. I created a new feature service layer. That worked fine. However, the attachments didn't come along. That's another hurdle I have to figure out. 😕 ... View more

I'm having this problem too. The bug page says that it has been fixed. But I just performed a join and the attachments didn't come through. Has anyone figured out an elegant work-around? ... View more

Hello James, Sorry I didn't respond until now. I've successfully been able to join the two databases and create an entirely new feature service, but some stuff gets left behind. Here's what I'm doing : In an online map, I add both databases (one is the request for the evaluation, the other is the matching evaluation) I click on Analysis, then Summarize Data, then Join Features. The Target Layer is the evaluation because it has the geopoint and the picture. The layer to join to the target layer is the request - has the owner's name. I then click on the 'Choose the field to match' option and pick the street address in both. This is a one to one option, so that's all good. I get it a name and uncheck 'Use current map extent' and I leave the 'Create results as hosted feature layer view' unchecked. Then I click on RUN ANALYSIS. After a little bit, my new feature layer is added to the map (yay!). I can then create a new survey using this feature layer from within Survey123 Connect (desktop) - another yay! Unfortunately, not everything comes across to the new feature service. Most importantly: the pictures from the evaluation and all the domain/list stuff for all the attributes (over 70 attributes!). Is there anyway for all that to be copied over to the new feature service (without me adding it one record or one attribute at a time)? Thanks, Esther ... View more

Thank you, Zach! I'll try that. I did share the contents of the Survey's folder with my group, hoping that it would show up for this automagically, but that didn't work. However, I didn't try deleting that stakeholder file. I might try that. But, while trying to figure it out, I realized I created the join as a 'feature layer view' - which means no editing. But I don't want to edit. I like the fact that folks can't edit it. I just want them to be able to use the Data and Analysis tabs in Survey123. I'll figure it out, one way or another. Either I'll try deleting the stakeholder file in the folder or just creating a new join that isn't a 'view'. Thanks again! ... View more

Thank you! I'll read through all the steps and make the attempt tomorrow. Fingers crossed! ... View more

Add on question, what if the surveys are already published and currently in use? Might I still be able to somehow merge the two? They wouldn't have to use the merged database as a survey, but rather just generate reports from it. Any advice for that scenario? ... View more