| id | 
                    NY1830042 | 
                  
                  
                    
                    
                      | boundary_type | 
                      
                        
    
      Unknown Service Area - Using EPA ECHO facility location with buffered radius to represent PWS
     | 
                      
                    
                    
                  
                    
                    
                      | centroid_lat | 
                      
                        
    
      43.0649583
     | 
                      
                    
                    
                  
                    
                    
                      | centroid_lon | 
                      
                        
    
      -78.2710184
     | 
                      
                    
                    
                  
                    
                    
                      | centroid_quality | 
                      
                        
    
      TIGER: CALCULATED FROM GEOMETRY
     | 
                      
                    
                    
                  
                    
                    
                      | city_served | 
                      
                        
    
      OAKFIELD
     | 
                      
                    
                    
                  
                    
                    
                      | contact_email | 
                      
                        
    
      jess@gosimplelab.com
     | 
                      
                    
                    
                  
                    
                    
                      | contribution_date | 
                      
                        
    
      2022-07-05
     | 
                      
                    
                    
                  
                    
                    
                      | county_served | 
                      
                        
    
      GENESEE
     | 
                      
                    
                    
                  
                    
                    
                      | data_source | 
                      
                        
    
      SimpleLab
     | 
                      
                    
                    
                  
                    
                    
                      | fid | 
                      
                        
    
      23693
     | 
                      
                    
                    
                  
                    
                    
                      | is_wholesaler_ind | 
                      
                        
    
      False
     | 
                      
                    
                    
                  
                    
                    
                      | owner_type_code | 
                      
                        
    
      L
     | 
                      
                    
                    
                  
                    
                    
                      | place_uri | 
                      
                        
    
      https://geoconnex.us/ref/places/
     | 
                      
                    
                    
                  
                    
                    
                      | population_served_count | 
                      
                        
    
      864
     | 
                      
                    
                    
                  
                    
                    
                      | pred_05 | 
                      
                        
    
      1350.05772274711
     | 
                      
                    
                    
                  
                    
                    
                      | pred_50 | 
                      
                        
    
      1417.08375906608
     | 
                      
                    
                    
                  
                    
                    
                      | pred_95 | 
                      
                        
    
      1487.43742313677
     | 
                      
                    
                    
                  
                    
                    
                      | primacy_agency_code | 
                      
                        
    
      NY
     | 
                      
                    
                    
                  
                    
                    
                      | primacy_type | 
                      
                        
    
      State
     | 
                      
                    
                    
                  
                    
                    
                      | primary_source_code | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | primary_water_source | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | pws_name | 
                      
                        
    
      OAKFIELD TOWN
     | 
                      
                    
                    
                  
                    
                  
                    
                    
                      | sdwis_link | 
                      
                        
    
      https://enviro.epa.gov/enviro/sdw_report_v3.first_table?pws_id=NY1830042&state=NY&source=0&population=0
     | 
                      
                    
                    
                  
                    
                    
                      | service_area_type | 
                      
                        
    
      nan
     | 
                      
                    
                    
                  
                    
                    
                      | service_connections_count | 
                      
                        
    
      415
     | 
                      
                    
                    
                  
                    
                    
                      | source_date | 
                      
                        
    
      2022-07-05
     | 
                      
                    
                    
                  
                    
                    
                      | source_url | 
                      
                        
    
      https://www.hydroshare.org/resource/b11b8982eebd4843833932f085f71d92/data/contents/temm.geojson
     | 
                      
                    
                    
                  
                    
                    
                      | state_code | 
                      
                        
    
      NY
     | 
                      
                    
                    
                  
                    
                    
                      | state_uri | 
                      
                        
    
      https://geoconnex.us/ref/states/36
     | 
                      
                    
                    
                  
                    
                    
                      | tier | 
                      
                        
    
      3
     | 
                      
                    
                    
                  
                    
                    
                      | uri | 
                      
                        
    
      https://geoconnex.us/ref/pws/NY1830042
     | 
                      
                    
                    
                  
                    
                    
                      | wholesaler | 
                      
                        
    
      Is not a wholesaler
     |