search

WSDOT / HATS

Highway Activity Tracking System Issue Tracker
6 stars 0 forks source link

Create Ditch Feature Roadside Feature Number 9 #1332

Closed PeterBurkhard closed 4 years ago

PeterBurkhard commented 5 years ago

Reed please create/enable the Ditch Feature. We have folks who would like to schedule some ditch work, but first we need a feature.

SELECT * FROM [HighwayActivitiesTracking].[dbo].[RoadsideFeatureType] WHERE RoadsideFeatureTypeName = 'Ditch';

ReedHunter-Wsdot commented 5 years ago

To put this in the hands of our crews, we'll have to release a new version of HATS just like we'd have to for supporting wetland mitigation sites. What's the timeline for when we need this?

Do you still want this ASAP?

Douggow commented 5 years ago

This came from a tech but the superintendent says he is being asked to schedule work for the coming biennium and ditching is a big part of what they do in this area. Not an emergency but I would say sooner than later.

tangoai commented 5 years ago

We've talked to Joe and we would like to see this release before 4.5. if we can get these two features out in a few weeks that would be great. Please let us know what else you need from us to make this happen. Thanks Reed!

ReedHunter-Wsdot commented 5 years ago

Can do.

jhudsonWA commented 5 years ago

Hold for a bit before we do anything. I want to get requirements for this new version locked down today then we can plan a release.

jhudsonWA commented 5 years ago

Per Joe: This can now hold off until 4.5 in September.

ReedHunter-Wsdot commented 5 years ago

@jhudsonWA , when you have the time I'll need an updated Hatsdb.sqlite with the Ids enabled for ditches (9), wetland mitigation site boundaries (156), and the three new general feature types (157, 158, 159) so I can better test the new feature types in Qa.

jhudsonWA commented 5 years ago

Just do a sync? They should all be enabled..

From: Reed Hunter notifications@github.com Sent: Friday, June 28, 2019 1:36 PM To: WSDOT/HATS Cc: Hudson, Joshua; Mention Subject: Re: [WSDOT/HATS] Create Ditch Feature Roadside Feature Number 9 (#1332)

@jhudsonWAhttps://github.com/jhudsonWA , when you have the time I'll need an updated Hatsdb.sqlite with the Ids enabled for ditches (9), wetland mitigation site boundaries (156), and the three new general feature types (157, 158, 159) so I can better test the new feature types in Qa.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/WSDOT/HATS/issues/1332?email_source=notifications&email_token=AAFLP3UPOL3HUWY6IUCZBFDP4ZY5FA5CNFSM4HWT5E32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODY3DLCQ#issuecomment-506869130, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAFLP3WYPTSSBI6PXWKIF4TP4ZY5FANCNFSM4HWT5E3Q.

ReedHunter-Wsdot commented 5 years ago

Feature types 156 through 159 are present, but not showing in the Toc. I'll investigate. On device add, edit, and delete is not allowed for these btw. There's also a "Ditch Maintenance" row with a null RoadsideFeatureTypeId.

jhudsonWA commented 5 years ago

On device edit will need to be toggled for some but some are only reference so that’s fine. Still should show on device if in the local table

From: Reed Hunter notifications@github.com Sent: Friday, June 28, 2019 2:19:10 PM To: WSDOT/HATS Cc: Hudson, Joshua; Mention Subject: Re: [WSDOT/HATS] Create Ditch Feature Roadside Feature Number 9 (#1332)

Feature types 156 through 159 are present, but not showing in the Toc. I'll investigate. On device add, edit, and delete is not allowed for these btw. There's also a "Ditch Maintenance" row with a null RoadsideFeatureTypeId.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/WSDOT/HATS/issues/1332?email_source=notifications&email_token=AAFLP3VMUY7P6LREH5BNGIDP4Z545A5CNFSM4HWT5E32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODY3GAKY#issuecomment-506880043, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAFLP3S2MX6MBZ2YGHQGXITP4Z545ANCNFSM4HWT5E3Q.

ReedHunter-Wsdot commented 5 years ago

The problem of the Toc not getting the layer went away by the time I was running through debug. It looks like the Sdk was holding onto the old geodatabase despite my replacing the file and restarting Hats.

ReedHunter-Wsdot commented 5 years ago

I toggled the allow create/edit/delete on my local database for testing, but you'll have to update these settings server-side since I don't have permissions.

ReedHunter-Wsdot commented 5 years ago

Pete, these ditches have nothing to do with stormwater, right?

jhudsonWA commented 5 years ago

To clarify, we used to have a ditch feature (local only) and then we added and disabled the stormwater ditch from SWIM. Which one should this request cover?

Douggow commented 5 years ago

The ditches do covey storm water but this request was made to able to identify and schedule ditching projects for budgeting and maintenance purposes and to be able to identify a potential backlog of ditching. Hope this helps

From: Joshua Hudson notifications@github.com Sent: Wednesday, July 3, 2019 10:20 AM To: WSDOT/HATS HATS@noreply.github.com Cc: Gow, Doug GowD@wsdot.wa.gov; Comment comment@noreply.github.com Subject: Re: [WSDOT/HATS] Create Ditch Feature Roadside Feature Number 9 (#1332)

To clarify, we used to have a ditch feature (local only) and then we added and disabled the stormwater ditch from SWIM. Which one should this request cover?

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/WSDOT/HATS/issues/1332?email_source=notifications&email_token=AEZ4NC772FV4X5D5CZAIW5LP5TNUJA5CNFSM4HWT5E32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZFEBCA#issuecomment-508182664, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AEZ4NC7B6PS5SKI27DILUI3P5TNUJANCNFSM4HWT5E3Q.

jhudsonWA commented 5 years ago

Then the real question should be, and I'll leave this up to @joeschmit's team: Should we reuse an existing Ditch feature or is this something new like "Ditch Projects"

ReedHunter-Wsdot commented 4 years ago

I'll reuse the existing ditch feature for the version 4.4 map service. Ditches are going to be line features regardless, we can always rename the layer and have the new name sync down at any time, and if the existing legacy features are unwanted we can always wholesale delete them and make the layer empty. I think that I can even change the line symbology without breaking sync compatibility - people would just have to redownload the next day's features map to see the symbol change.