AMANDA Folder Detail | ||
---|---|---|
Category | Development | |
Feature Dataset Name | AMANDA_Folder_Publish | |
Item Name | AMANDA_Folder_Publish | |
Database Type | SDE | |
Originator | AMANDA/BDS GIS | |
Bureau | Bureau of Development Services | |
Publication Date | 10/01/2020 | |
Abstract | AMANDA folder details and processing metrics | |
Purpose | AMANDA folder details and processing metrics | |
Supplemental Information | This dataset contains only permits that could be mapped. Some of the older permits we do not have a reliable associated parcel centroid to associate the permit with. | |
Last Dataset Update | ||
Last Source Update | ||
Maintenance/Update Frequency | Daily | |
Extent | City of Portland | |
Data Type | ||
Shape Type | Point | |
Feature Count | ||
Horizontal Position Accuracy | ||
Horizontal Position Accuracy Link | ||
Progress | ||
North Bounding Coordinate | ||
South Bounding Coordinate | ||
East Bounding Coordinate | ||
West Bounding Coordinate | ||
Theme Keyword(s) | Permit,AMANDA,Folder | |
Theme Keyword Thesaurus | Permit,Construction | |
Place Keyword(s) | Portland | |
Place Keyword Thesaurus | ||
Access Constraints | Available for Public Use | |
Use Constraints | ||
Source Dataset Type | Enterprise Geodatabase | |
Output Geodatabase | EGH_Web | |
Distribution | Grid: State plane coordinate system 1983(91). Units: International feet Datum: North American Datum of 1983/1991 (HPGN) Liability: The information in this file was derived from digital databases on the City of Portland GIS. Care was taken in the creation of this file. The City cannot accept any responsibility for errors, omissions, or positional accuracy. There are no warranties, expressed or implied. Format: Shapefile or File Geodatabase Feature Class - Data will be provided via City of Portland FTP Site. Online Resource: http://portlandmaps.com/opendata Online Instructions: City of Portland Public/Open Data is distributed via the PortlandMaps Open Data Site - http://portlandmaps.com/opendata. Data not available on the PortlandMaps Open Data site can be requested by contacting the City of Portland CGIS Group - maps@portlandoregon.gov Transfer Size: varies SPCS Zone Identifier: 5076 | |
Contact(s) | ||
| ||
File(s) | ||
Lineage |
Service | Description | Feature Access | Layer |
---|---|---|---|
BDS_Permit_Dashboard | BDS Permit Dashboard contains AMANDA folder and process data that is updated nightly | Dynamic | Construction Project Status |
| ||||||
---|---|---|---|---|---|---|
Table Description | ||||||
Table Jurisdiction | ||||||
Column Sort | Column Name | Column Alias | Column Type | Column Size | Domain Value(s) | Column Description | 1 | Shape | Shape | Geometry | 8 | | | 2 | folder_rsn | Folder RSN | Integer | 4 | | | 3 | property_rsn | Property RSN | Integer | 4 | | | 4 | eplans_project_id | ePlans Project ID | Integer | 4 | | | 5 | intake_folder_rsn | Intake Folder RSN | Integer | 4 | | | 6 | intake_folder_status | Intake Folder Status | String | 255 | | | 7 | intake_request_submitted | Intake Request Submitted Date | Date | 8 | | | 8 | intake_review_approved | Intake Review Approved Date | Date | 8 | | | 9 | intake_category_of_const | Intake Category of Construction | String | 255 | | | 10 | intake_request_type | Intake Request Type | String | 255 | | | 11 | intake_type_of_work | Intake Type of Work | String | 255 | | | 12 | intake_link_to_permit | Intake Link to Permit | Date | 8 | | | 13 | intake_work_valuation | Intake Work Valuation | Integer | 4 | | | 14 | dev_hub_status | Dev HUB Status | String | 255 | | | 15 | folder_name | Folder Name | String | 255 | | | 16 | folder_type | Folder Type | String | 40 | | | 17 | folder_number | Folder Number | String | 25 | | | 18 | folder_section | Folder Section | String | 3 | | | 19 | folder_revision | Folder Revision | String | 3 | | | 19 | intake_complete_date | Intake Complete Date | Date | 8 | | | 20 | status | Status | String | 40 | | | 21 | description | Description | String | 4000 | | | 22 | work_type | Work Type | String | 100 | | | 23 | sub_type | Sub Type | String | 100 | | | 23 | finaled_date | Finaled Date | Date | 8 | | | 24 | reference_file | Reference File | String | 255 | | | 25 | in_date | In Date | Date | 8 | | | 26 | under_review_date | Under Review Complete Date | Date | 8 | | | 27 | pre_issuance_date | Pre Issuance Date | Date | 8 | | | 27 | pre_issuance_start_date | Pre Issuance Start Date | Date | 8 | | | 28 | pre_issuance_complete_date | Pre Issuance Complete Date | Date | 8 | | | 29 | approved_to_issue_date | Approved to Issued Date | Date | 8 | | | 30 | issued_date | Issued Date | Date | 8 | | | 31 | under_inspection_date | Under Inspection Date | Date | 8 | | | 32 | final_date | Final Date | Date | 8 | | | 33 | expiry_date | Expiry Date | Date | 8 | | | 34 | property_address | Property Address | String | 60 | | | 35 | property_r_number | Property R Number | String | 9 | | | 36 | property_alt_r_number | Property Alternate R Number | String | 15 | | | 37 | property_state_id | Property State ID | String | 40 | | | 38 | property_city | Property City | String | 40 | | | 39 | property_county | Property County | String | 40 | | | 40 | property_neighborhood | Property Neighborhood | String | 255 | | | 41 | property_neighborhood_police | Property Neighborhood (Police) | String | 255 | | | 42 | property_neighborhood_coalition | Property Neighborhood Coalition | String | 255 | | | 43 | property_business_association | Property Business Association | String | 255 | | | 43 | mando_first_rev_overdue_status | Mandatory First Review Overdue | String | 255 | | | 44 | building_submitted_valuation | Building Submitted Valuation | Integer | 4 | | | 44 | mandatory_first_review_complete | Mandatory First Review Complete | String | 40 | | | 45 | process_first_review_avg_days | Process First Review Average Days | Integer | 4 | | | 45 | building_final_valuation | Building Final Valuation | Integer | 4 | | | 46 | building_final_value_class | Building Final Valuation Class | String | 255 | | | 47 | building_new_unit_count | Building New Unit Count | Integer | 4 | | | 48 | intake_complete_year | Intake Complete Year | String | 4 | | | 48 | building_removed_unit_count | Building Removed Unit Count | Integer | 4 | | | 49 | building_net_unit_count | Building Net Unit Count | Integer | 4 | | | 49 | intake_complete_year_month | Intake Complete Year Month | String | 30 | | | 50 | intake_within_one_year | Intake Within One Year | String | 5 | | | 50 | building_story_count | Building Story Count | Integer | 4 | | | 51 | timeline_exception_reason | Timeline Exception Reason | String | 50 | | | 52 | review_type | Review Type | String | 40 | | | 53 | intake_folder_days | Intake Folder Days | Integer | 4 | | | 54 | first_review_complete_date | First Review Complete Date | Date | 8 | | | 55 | first_rev_overdue_status | First Review Overdue | String | 255 | | | 56 | first_review_complete | First Review Complete | String | 40 | | | 57 | first_review_avg_days | First Review Average Days | Integer | 4 | | | 58 | create_year | Create Year | String | 4 | | | 59 | create_year_month | Create Year Month | String | 30 | | | 60 | create_fiscal_year | Create Fiscal Year | String | 20 | | | 61 | relative_date_class | Relative Date Class | String | 50 | | | 62 | under_review_year | Under Review Year | String | 4 | | | 63 | under_review_year_month | Under Review Year Month | String | 30 | | | 64 | under_review_within_one_year | Under Review Within One Year | String | 5 | | | 65 | app_to_und_rev_days | App to Under Review Days | Integer | 4 | | | 66 | und_rev_to_pre_iss_days | Under Review to Pre Issuance Days | Integer | 4 | | | 67 | pre_issuance_days | Pre Issuance Days | Integer | 4 | | | 68 | pre_issue_to_ati_days | Pre Issue to Appr to Issue Days | Integer | 4 | | | 69 | app_to_ati_days | Application to Appr to Issue Days | Integer | 4 | | | 70 | app_to_issue_days | Application to Issue Days | Integer | 4 | | | 71 | approved_to_issue_days | Approved to Issue Days | Integer | 4 | | | 72 | approved_to_issue_days_class | Approved to Issue Days Class | String | 20 | | | 73 | tot_city_busy_to_ati_days | Total Days City Processed Permit | Integer | 4 | | | 74 | tot_cust_busy_to_ati_days | Total Days Customer Processed Permit | Integer | 4 | | | 75 | days_since_intake | Bus. Days Since Intake | Integer | 4 | | | 76 | days_since_setup | Bus. Days Since Setup | Integer | 4 | | | 77 | days_since_und_rev | Bus. Days Since Under Review | Integer | 4 | | | 78 | days_since_first_rev_done | Bus. Days Since First Review | Integer | 4 | | | 79 | days_since_pre_issue_start | Bus. Days Since Pre-Issuance Start | Integer | 4 | | | 80 | days_since_pre_issue_done | Bus. Days Since Pre-Issuance Complete | Integer | 4 | | | 81 | days_since_ati | Bus. Days Since Approved To Issue | Integer | 4 | | | 82 | days_since_issue | Bus. Days Since Issue | Integer | 4 | | | 83 | checksheet_count | Checksheet Count | Integer | 4 | | | 84 | corrections_received_count | Corrections Received Count | Integer | 4 | | | 85 | reviewer_overdue_status | Reviewer Overdue Status | String | 255 | | | 86 | review_window_status | Review Window Status | String | 255 | | | 86 | gis_portland_maps_url | PortlandMaps URL | String | 100 | | | 87 | review_window_publish_text | Review Window Publish Text | String | 255 | | | 88 | under_inspection_days | Under Inspection Days | Integer | 4 | | | 89 | inspection_site_visit_count | Inspection Site Visit Count | Integer | 4 | | | 90 | inspection_window_publish_text | Inspection Window Publish Text | String | 255 | | | 91 | building_occupancy_group_1 | Building Occupancy Group 1 | String | 255 | | | 92 | building_construction_type_1 | Building Construction Type 1 | String | 255 | | | 93 | building_total_sq_ft_1 | Building Total Sq Ft 1 | Integer | 4 | | | 94 | building_occupancy_group_2 | Building Occupancy Group 2 | String | 255 | | | 95 | building_construction_type_2 | Building Construction Type 2 | String | 255 | | | 96 | building_total_sq_ft_2 | Building Total Sq Ft 2 | Integer | 4 | | | 97 | building_occupancy_group_3 | Building Occupancy Group 3 | String | 255 | | | 98 | building_construction_type_3 | Building Construction Type 3 | String | 255 | | | 98 | chksht_assign_address_rev | Assign Address Tot. Checksheet # | Integer | 4 | | | 99 | status_assign_address_rev | Assign Address Status | String | 255 | | | 99 | building_total_sq_ft_3 | Building Total Sq Ft 3 | Integer | 4 | | | 100 | building_occupancy_group_4 | Building Occupancy Group 4 | String | 255 | | | 100 | chksht_com_plumb_rev | Commercial Plumbing Review Tot. Checksheet # | Integer | 4 | | | 101 | status_com_plumb_rev | Commercial Plumbing Review Status | String | 255 | | | 101 | building_construction_type_4 | Building Construction Type 4 | String | 255 | | | 102 | building_total_sq_ft_4 | Building Total Sq Ft 4 | Integer | 4 | | | 102 | chksht_demo_release_rev | Demo Release Review Tot. Checksheet # | Integer | 4 | | | 103 | status_demo_release_rev | Demo Release Review Status | String | 255 | | | 103 | aff_housing_unit_count | Affordable Housing Unit Count | Integer | 4 | | | 104 | aff_housing_exempt_type_1 | Affordable Housing Exempt Type 1 | String | 255 | | | 104 | chksht_energy_code_rev | Energy Code Review Tot. Checksheet # | Integer | 4 | | | 105 | status_energy_code_rev | Energy Code Review Status | String | 255 | | | 105 | aff_housing_exempt_sqft_1 | Affordable Housing Exempt Sq Ft 1 | String | 255 | | | 106 | aff_housing_exempt_type_2 | Affordable Housing Exempt Type 2 | String | 255 | | | 106 | chksht_erosion_ctrl_plan_rev | Erosion Control Plan Review Tot. Checksheet # | Integer | 4 | | | 107 | status_erosion_ctrl_plan_rev | Erosion Control Plan Review Status | String | 255 | | | 107 | aff_housing_exempt_sqft_2 | Affordable Housing Exempt Sq Ft 2 | String | 255 | | | 108 | aff_housing_exempt_type_3 | Affordable Housing Exempt Type 3 | String | 255 | | | 108 | chksht_fire_plan_rev | Fire Plan Review Tot. Checksheet # | Integer | 4 | | | 109 | status_fire_plan_rev | Fire Plan Review Status | String | 255 | | | 109 | aff_housing_exempt_sqft_3 | Affordable Housing Exempt Sq Ft 3 | String | 255 | | | 110 | aff_housing_exempt_type_4 | Affordable Housing Exempt Type 4 | String | 255 | | | 110 | chksht_inclus_house_rev | Inclusionary Housing Review Tot. Checksheet # | Integer | 4 | | | 111 | status_inclus_house_rev | Inclusionary Housing Review Status | String | 255 | | | 111 | aff_housing_exempt_sqft_4 | Affordable Housing Exempt Sq Ft 4 | String | 255 | | | 112 | gis_map_label | GIS Map Label | String | 50 | | | 112 | chksht_life_safety_rev | Life Safety Review Tot. Checksheet # | Integer | 4 | | | 112 | assign_address_rev_chksht | Assign Address Tot. Checksheet # | Integer | 4 | | | 113 | assign_address_rev_status | Assign Address Status | String | 255 | | | 113 | status_life_safety_rev | Life Safety Review Status | String | 255 | | | 113 | gis_symbol_class | GIS Symbol Class | String | 50 | | | 114 | gis_process_date | GIS Process Date | Date | 8 | | | 114 | chksht_plan_and_zone_rev | Planning and Zoning Review Tot. Checksheet # | Integer | 4 | | | 114 | assign_address_rev_days | Assign Address Elapsed Days | Integer | 4 | | | 115 | gis_process_status | GIS Process Status | String | 100 | | | 115 | assign_address_rev_user | Assign Address Reviewer | Integer | 4 | | | 115 | status_plan_and_zone_rev | Planning and Zoning Review Status | String | 255 | | | 116 | chksht_process_manager | Process Manager Tot. Checksheet # | Integer | 4 | | | 116 | portland_maps_url | PortlandMaps URL | String | 100 | | | 116 | com_plumb_rev_chksht | Commercial Plumbing Review Tot. Checksheet # | Integer | 4 | | | 117 | com_plumb_rev_status | Commercial Plumbing Review Status | String | 255 | | | 117 | eplans_url | ePlans URL | String | 255 | | | 117 | status_process_manager | Process Manager Status | String | 255 | | | 118 | chksht_site_dev_rev | Site Development Review Tot. Checksheet # | Integer | 4 | | | 118 | efiles_url | eFiles URL | String | 255 | | | 118 | com_plumb_rev_days | Commercial Plumbing Review Elapsed Days | Integer | 4 | | | 119 | report_date | Report Date | Date | 8 | | | 119 | com_plumb_rev_user | Commercial Plumbing Reviewer | Integer | 4 | | | 119 | status_site_dev_rev | Site Development Review Status | String | 255 | | | 120 | chksht_structural_rev | Structural Review Tot. Checksheet # | Integer | 4 | | | 120 | report_url | Report URL | String | 255 | | | 120 | demo_release_rev_chksht | Demo Release Review Tot. Checksheet # | Integer | 4 | | | 121 | demo_release_rev_status | Demo Release ReviewStatus | String | 255 | | | 121 | life_cycle_image_url | Life Cycle Image | String | 255 | | | 121 | status_structural_rev | Structural Review Status | String | 255 | | | 122 | chksht_bes_env_rev | BES Environmental Review Tot. Checksheet # | Integer | 4 | | | 122 | demo_release_rev_days | Demo Release Review Elapsed Days | Integer | 4 | | | 122 | gantt_chart_url | Gantt Chart URL | String | 255 | | | 123 | demo_release_rev_user | Demo Release Reviewer | Integer | 4 | | | 123 | status_bes_env_rev | BES Environmental Review Status | String | 255 | | | 124 | chksht_bes_src_ctrl_rev | BES Source Control Review Tot. Checksheet # | Integer | 4 | | | 124 | energy_code_rev_chksht | Energy Code Review Tot. Checksheet # | Integer | 4 | | | 125 | energy_code_rev_status | Energy Code Review Status | String | 255 | | | 125 | status_bes_src_ctrl_rev | BES Source Control Review Status | String | 255 | | | 126 | chksht_pbob_str_assign_rev | Trans - Street Systems Review Tot. Checksheet # | Integer | 4 | | | 126 | energy_code_rev_days | Energy Code Review Elapsed Days | Integer | 4 | | | 127 | energy_code_rev_user | Energy Code Reviewer | Integer | 4 | | | 127 | status_pbob_str_assign_rev | Trans - Street Systems Review Status | String | 255 | | | 128 | chksht_pbot_trans_sdc_rev | Transportation SDC Review Tot. Checksheet # | Integer | 4 | | | 128 | erosion_ctrl_plan_rev_chksht | Erosion Control Plan Review Tot. Checksheet # | Integer | 4 | | | 129 | erosion_ctrl_plan_rev_status | Erosion Control Plan Review Status | String | 255 | | | 129 | status_pbot_trans_sdc_rev | Transportation SDC Review Status | String | 255 | | | 130 | chksht_pbot_trans_ss_rev | Street Systems - Assign Reviews Tot. Checksheet # | Integer | 4 | | | 130 | erosion_ctrl_plan_rev_days | Erosion Control Plan Review Elapsed Days | Integer | 4 | | | 131 | erosion_ctrl_plan_rev_user | Erosion Control Plan Reviewer | Integer | 4 | | | 131 | status_pbot_trans_ss_rev | Street Systems - Assign Reviews Status | String | 255 | | | 132 | chksht_parks_sdc_rev | Parks SDC Review Tot. Checksheet # | Integer | 4 | | | 132 | fire_plan_rev_chksht | Fire Plan Review Tot. Checksheet # | Integer | 4 | | | 133 | fire_plan_rev_status | Fire Plan Review Status | String | 255 | | | 133 | status_parks_sdc_rev | Parks SDC Review Status | String | 255 | | | 134 | chksht_parks_urb_forest_rev | Urban Forestry Review Tot. Checksheet # | Integer | 4 | | | 134 | fire_plan_rev_days | Fire Plan Review Elapsed Days | Integer | 4 | | | 135 | fire_plan_rev_user | Fire Plan Reviewer | Integer | 4 | | | 135 | status_parks_urb_forest_rev | Urban Forestry Review Status | String | 255 | | | 136 | chksht_water_available_rev | Water Available Tot. Checksheet # | Integer | 4 | | | 136 | inclus_house_rev_chksht | Inclusionary Housing Review Tot. Checksheet # | Integer | 4 | | | 137 | inclus_house_rev_status | Inclusionary Housing ReviewStatus | String | 255 | | | 137 | status_water_qual_backflow | Water Available Status | String | 255 | | | 138 | chksht_water_qual_backflow | Water Quality Backflow Tot. Checksheet # | Integer | 4 | | | 138 | inclus_house_rev_days | Inclusionary Housing Review Elapsed Days | Integer | 4 | | | 139 | inclus_house_rev_user | Inclusionary Housing Reviewer | Integer | 4 | | | 139 | status_water_available_rev | Status | String | 255 | | | 140 | life_safety_rev_chksht | Life Safety Review Tot. Checksheet # | Integer | 4 | | | 141 | life_safety_rev_status | Life Safety Review Status | String | 255 | | | 142 | life_safety_rev_days | Life Safety Review Elapsed Days | Integer | 4 | | | 143 | life_safety_rev_user | Life Safety Reviewer | Integer | 4 | | | 144 | plan_and_zone_rev_chksht | Planning and Zoning Review Tot. Checksheet # | Integer | 4 | | | 145 | plan_and_zone_rev_status | Planning and Zoning ReviewStatus | String | 255 | | | 146 | plan_and_zone_rev_days | Planning and Zoning Review Elapsed Days | Integer | 4 | | | 147 | plan_and_zone_rev_user | Planning and Zoning Reviewer | Integer | 4 | | | 148 | process_manager_chksht | Process Manager Tot. Checksheet # | Integer | 4 | | | 149 | process_manager_status | Process Manager Status | String | 255 | | | 150 | process_manager_days | Process Manager Elapsed Days | Integer | 4 | | | 151 | process_manager_user | Process Manager Reviewer | Integer | 4 | | | 152 | site_dev_rev_chksht | Site Development Review Tot. Checksheet # | Integer | 4 | | | 153 | site_dev_rev_status | Site Development Review Status | String | 255 | | | 154 | site_dev_rev_days | Site Development Review Elapsed Days | Integer | 4 | | | 155 | site_dev_rev_user | Site Development Reviewer | Integer | 4 | | | 156 | structural_rev_chksht | Structural Review Tot. Checksheet # | Integer | 4 | | | 157 | structural_rev_status | Structural Review Status | String | 255 | | | 158 | structural_rev_days | Structural Review Elapsed Days | Integer | 4 | | | 159 | structural_rev_user | Structural Reviewer | Integer | 4 | | | 160 | bes_env_rev_chksht | BES Environmental Review Tot. Checksheet # | Integer | 4 | | | 161 | bes_env_rev_status | BES Environmental Review Status | String | 255 | | | 162 | bes_env_rev_days | BES Environmental Review Elapsed Days | Integer | 4 | | | 163 | bes_env_rev_user | BES Environmental Reviewer | Integer | 4 | | | 164 | bes_src_ctrl_rev_chksht | BES Source Control Review Tot. Checksheet # | Integer | 4 | | | 165 | bes_src_ctrl_rev_status | BES Source Control Review Status | String | 255 | | | 166 | bes_src_ctrl_rev_days | BES Source Control Review Elapsed Days | Integer | 4 | | | 167 | bes_src_ctrl_rev_user | BES Source Control Review Reviewer | Integer | 4 | | | 168 | pbot_str_assign_rev_chksht | Trans - Street Systems Review Tot. Checksheet # | Integer | 4 | | | 169 | pbot_str_assign_rev_status | Trans - Street Systems Review Status | String | 255 | | | 170 | pbot_str_assign_rev_days | Trans - Street Systems Review Elapsed Days | Integer | 4 | | | 171 | pbot_str_assign_rev_user | Trans - Street Systems Reviewer | Integer | 4 | | | 172 | pbot_trans_sdc_rev_chksht | Transportation SDC Review Tot. Checksheet # | Integer | 4 | | | 173 | pbot_trans_sdc_rev_status | Transportation SDC Review Status | String | 255 | | | 174 | pbot_trans_sdc_rev_days | Transportation SDC Review Elapsed Days | Integer | 4 | | | 175 | pbot_trans_sdc_rev_user | Transportation SDC Reviewer | Integer | 4 | | | 176 | pbot_trans_ss_rev_chksht | Street Systems - Assign Reviews Tot. Checksheet # | Integer | 4 | | | 177 | pbot_trans_ss_rev_status | Street Systems - Assign Reviews Status | String | 255 | | | 178 | pbot_trans_ss_rev_days | Street Systems - Assign Reviews Elapsed Days | Integer | 4 | | | 179 | pbot_trans_ss_user | Street Systems Reviewer | Integer | 4 | | | 180 | parks_sdc_rev_chksht | Parks SDC Review Tot. Checksheet # | Integer | 4 | | | 181 | parks_sdc_rev_status | Parks SDC Review Status | String | 255 | | | 182 | parks_sdc_rev_days | Parks SDC Review Elapsed Days | Integer | 4 | | | 183 | parks_sdc_rev_user | Parks SDC Reviewer | Integer | 4 | | | 184 | parks_urb_forest_rev_chksht | Urban Forestry Review Tot. Checksheet # | Integer | 4 | | | 185 | parks_urb_forest_rev_status | Urban Forestry Review Status | String | 255 | | | 186 | parks_urb_forest_rev_days | Urban Forestry Review Elapsed Days | Integer | 4 | | | 187 | parks_urb_forest_user | Urban Forestry Reviewer | Integer | 4 | | | 188 | water_available_rev_chksht | Water Available Tot. Checksheet # | Integer | 4 | | | 189 | water_available_rev_status | Water Available Status | String | 255 | | | 190 | water_available_rev_days | Water Available Elapsed Days | Integer | 4 | | | 191 | water_available_rev_user | Water Available Reviewer | Integer | 4 | | | 192 | water_qual_backflow_chksht | Water Quality Backflow Tot. Checksheet # | Integer | 4 | | | 193 | water_qual_backflow_status | Water Quality Backflow Status | String | 255 | | | 194 | water_qual_backflow_days | Water Quality Backflow Elapsed Days | Integer | 4 | | | 195 | water_qual_backflow_user | Water Quality Backflow Reviewer | Integer | 4 | | | 206 | gantt_chart_image_url | Gantt Chart Image | String | 255 | | |