search

agrc / electrofishing

The data submission application for recording electrofishing surveys. Built for DWR.
MIT License
0 stars 0 forks source link

Research: Services in AGOL #243

Open nathankota opened 3 years ago

nathankota commented 3 years ago

Caveat: dependencies on existing ArcGIS server GP services

Can services and data be moved to AGOL? Might not be able to handle the database and relationship classes. What other options might be available for getting it out of ArcGIS Server?

stdavis commented 3 years ago

The main concern that I have for this is the geoprocessing tasks. I did just recently get rid of one of the 4. GetSegmentFromStartDistDirt & GetSegmentFromCoords are the two that would be the hardest to replicate on the client...

steveoh commented 3 years ago

could they be done in postgis?

stdavis commented 3 years ago

I don't know. One example: Take two input points and return the closest stream segment to them, or a straight line if there isn't a stream within a certain distance. Take a start point within a certain distance of a stream and trace up or down stream a specified distance.

These sound more than just DB queries to me but I'm not a PostGIS expert.

steveoh commented 3 years ago

The first could use ST_DWithin() to get the closest stream segment, and ST_MakeLine() >when there isn't a match on the distance. Use COALSECE() to get the closest segment first and only create the line when no match.

The second sounds like an easily enough problem for PostGIS and pgrouting