rssidlowski / Hydrants

City of Baltimore Fire Hydrant Inspections
0 stars 0 forks source link

Data: update Hydrant_Status table #28

Open rssidlowski opened 9 years ago

rssidlowski commented 9 years ago

Update Hydrant_Status table and application to allow for the following: a. Change WORN_STEM_OPER_YN to WORN_STEM_YN b. Remove WORK_STEM_NOTOPER_YN c. Remove COMMENTS_DATE d. Change FLOW_STATIC_PSI to STATIC_PSI e. Change FLOW_RESID_PSI to FLOW_PSI f. Add OPER_FLOWS_YN g. Add WORN_STEM_YN h. Add LOW_FLOW_YN i. Add MAX_FLOW_OBSERVED_GPM j. Add LEAD_VALVE_OPER_YN k. Add HYDRANT_SHEARED_YN l. Add PITOT