search

kcigeospatial / MDOT-SHA-NPDES-Next-Gen

Code and issues related to the MDOT SHA NPDES Project. Project codes: Config = 31, Management = 32.
0 stars 0 forks source link

Set fields to read-only or hidden at service level #389

Open talllguy opened 5 years ago

talllguy commented 5 years ago

In #132 we set some fields to be non-editable in the web maps. We've also hidden certain fields, e.g. #159. With the republishing of feature services, in Fall 2019, this issue serves to centralize and track the read only fields in each layer.

Key

🔒 Read Only 💎 Has Recommended Field 🚀 Has Substitute (domain or ETL) 👻 Hidden

Structures

Field Hide R.O. Rec. Sbst.
STRUCTURE_ID   🔒    
ST_ML_PT 👻      
NPDES_NO   🔒    
CONTRACT_ID 👻     🚀
META_ID 👻     🚀
CNTY_CODE   🔒    
MD_WSHED   🔒    
MD_MSHOP   🔒    
MD_DISTRICT   🔒    
OWNER_ID 👻     🚀
X 👻      
Y 👻      
EH_FLD_ORIG_GLOBALID 👻      
IN_FLD_ORIG_GLOBALID 👻      
MH_FLD_ORIG_GLOBALID 👻      
PM_FLD_ORIG_GLOBALID 👻      
SR_FLD_ORIG_GLOBALID 👻      
WR_FLD_ORIG_GLOBALID 👻      
FLD_CTRL_SWMFAC_GUID 👻     🚀
FLD_UPSTR_SWMFAC_GUID 👻     🚀

Conveyance

Field Hide R.O. Rec. Sbst.
CONVEYANCE_ID   🔒    
UPSTRM_STR 👻     🚀
DNSTRM_STR 👻     🚀
CONTRACT_ID 👻     🚀
META_ID 👻     🚀
DT_FLD_ORIG_GLOBALID 👻      
PI_FLD_ORIG_GLOBALID 👻      
CNTY_CODE   🔒    
MD_WSHED   🔒    
MD_MSHOP   🔒    
MD_DISTRICT   🔒    
FLD_UPSTRM_STR_GUID 👻     🚀
FLD_DNSTRM_STR_GUID 👻     🚀

SWMFAC

Field Hide R.O. Rec. Sbst.
FACILITY_ID   🔒    
SWM_FAC_NO   🔒    
LEG_SWM_FAC_NO   🔒    
EC_BMP   🔒    
CONTRACT_ID 👻     🚀
DESIGNATION   🔒 💎  
DESIGN_SUB   🔒 💎  
MDE_NO   🔒    
VIC_BMP 👻      
LEG_VIC_BMP 👻      
PLANDATE   🔒 💎  
FEAT_STATUS   🔒 💎  
META_ID 👻     🚀
IN_STREAM   🔒    
OWNER_ID 👻   💎 🚀
FOUR_MI_VICINITY_AIRPORT   🔒    
SWM_FAC_NO_OTHER 👻      
CNTY_CODE   🔒    
MD_WSHED   🔒    
MD_MSHOP   🔒    
MD_DISTRICT   🔒    
PLAN_IMP_AREA   🔒    
PLAN_DRAIN_AREA   🔒    
DATE_CONSTRUCTED   🔒    
AS_BUILT_CERT_DATE   🔒    
FOR_TMDL   🔒    
JPA   🔒    
RETROFIT_OF_EXISTING   🔒    
FLD_ORIG_GLOBALID 👻      
FLD_OWNER_ID   🔒    
STRUCTURAL_ACCEPTANCE   🔒    
STRUCTURAL_ACCEPTANCE_DATE   🔒    
FINAL_ACCEPTANCE   🔒    
FINAL_ACCEPTANCE_DATE   🔒    
AS_BUILT_FLAG   🔒 💎  
FLAG_COMMENTS   🔒 💎  
BASELINE   🔒    
SWALE_2A   🔒    
HHD_DESIGN_EXCEPTIONS   🔒    
HHD_DESIGN_EXCEPTIONS_COMMENTS   🔒    
RESOLVED   🔒 💎  
ENGINEERING_CONCERNS   🔒    
LANDSCAPE_CONTRACT_ID 👻      
RECOVERY_SWALE 👻    

Field Screening Sites

Field Hide R.O. Rec. Sbst.
STRUCTURE_ID   🔒   🚀
VIC_SCREEN 👻      
LEG_VIC_SCREEN 👻      
CNTY_CODE   🔒    
ILLICIT_DISCHARGE_POINT_ID 👻      
FLD_ORIG_GLOBALID 👻      

CC @KCI-Ablowers @brentreeves75 @ladejobi @kerrymcmahon @johnshiu

talllguy commented 5 years ago

I've set these up at the service level in KCI_1 and am using it as a template for the 14 other firms (tracking in #390).

The process

For documentation

Testing

  1. Set field properties in KCI_1
  2. Publish KCI_1 map service
  3. Test in KCI_1 map

(test was successful)

Repeat

Repeat test on all firms, tracking in #390

  1. Save as KCI_1 publish MXD over AMT
  2. Change version to AMT
  3. Publish AMT map service
  4. Save As AMT publish MXD over CENT
  5. Repeat ...
talllguy commented 5 years ago

Reopening for FLD_FLDSC_SITE

talllguy commented 5 years ago

Updated field screening site MXD

KCI-Ablowers commented 5 years ago

@talllguy we need to reenable STUDY_PT and IN_STREAM for consultant editing. What is the LOE to update the feature services and maps/apps?

KCI-Ablowers commented 5 years ago

@talllguy We discussed republishing the feature services with the STUDY_PT and IN_STREAM fields enabled. Once republished, I will go back in and reconfigure the map, then the app. Once everything is reconfigured. I will notify the firms to go back and make these updates.

This effort should take place at the end of the day or outside of business hours. Just let me know when you start republishing and I can follow behind and make the changes.

KCI-Ablowers commented 5 years ago

@talllguy Any idea when you will be free to do the republishing?

talllguy commented 5 years ago

@KCI-Ablowers STUDY_PT "Discharge Point" on Structure is not set to read-only. Only, IN_STREAM is. Can you verify the requirements for this change?

talllguy commented 5 years ago

I've enabled the In-Stream editable fix on WBCM's service version. The process took about 10-15 minutes including the time spent waiting for the publisher to complete its task. Good news is that the web app smart editor seemed to already have the editing enabled once I saved the web map. We'll want to test that on another one.

Findings/Process

  1. Load WBCM MXD on DMZ box
  2. Open SWMFAC properties
  3. Set IN_STREAM field Read only to No (double click for faster switching)
  4. Save
  5. Share as service --> Overwrite
  6. Publish
                • W - A - I - T - - - -
  8. Success
  9. Launch web map
  10. Configure SWMFAC attributes
  11. Tick box to make IN_STREAM editable.
  12. Save

That's the process.

KCI-Ablowers commented 5 years ago

@KCI-Ablowers STUDY_PT "Discharge Point" on Structure is not set to read-only. Only, IN_STREAM is. Can you verify the requirements for this change?

@talllguy I think there may have been some misunderstanding between the firms (Century) and me. They were probably looking for "study point" as an alias/field name rather than a "discharge point." Sorry!

KCI-Ablowers commented 5 years ago

bump if

@talllguy

KCI-Ablowers commented 5 years ago

@talllguy Closing this for now. Spoke with Brent and we will populate the In_Stream on any SWMFACs missing the value from the last inspection cycle. Contacted the firms this morning.

talllguy commented 4 years ago

Reopening just to note the update to the original comment about RECOVERY_SWALE. It should be hidden per Heather.