trees

Custom SQL query returning 23 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1338 261130 1 181 198 Madrid St 2 Sidewalk: Curb side : Cutout Tree 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003761.7429 2092753.33549 37.7265152577639 -122.429201331188 (37.7265152577639, -122.429201331188) 9 7 6 28861 5
5069 161446 1 181 330 Lisbon St 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3   6002674.4423 2091528.28518 37.7230899316367 -122.432872602985 (37.7230899316367, -122.432872602985) 9 7 6 28861 5
7249 160605 1 181 753 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/18/2017 01:48:00 PM 3 Width 0ft   6002503.48745 2089141.95917 37.7165279132188 -122.433293125102 (37.7165279132188, -122.433293125102) 9 7 6 28861 5
11445 171733 1 181 1010 Silliman St 1 Sidewalk: Curb side : Cutout Tree 1     0 3x5   6007780.11257 2093435.62386 37.72861533842 -122.415358227021 (37.72861533842, -122.415358227021) 9 3 7 309 5
13304 171228 1 181 131 Peru Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/27/2019 12:00:00 AM 3 Width 2ft   6004022.36469 2093295.14469 37.7280176957394 -122.428338971261 (37.7280176957394, -122.428338971261) 9 7 6 28861 5
13387 171252 1 181 198 Madrid St 1 Sidewalk: Curb side : Cutout Tree 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003761.7429 2092753.33549 37.7265152577639 -122.429201331188 (37.7265152577639, -122.429201331188) 9 7 6 28861 5
15487 258375 1 181 1010 Silliman St 2 Sidewalk: Curb side : Cutout Tree 1 FUF     3x3   6007854.59312 2093456.62302 37.7286771834491 -122.415102228476 (37.7286771834491, -122.415102228476) 9 3 7 309 5
17122 171142 1 181 23 Madrid St 1 Sidewalk: Curb side : Cutout Tree 2   11/27/2019 12:00:00 AM 3 Width 4ft   6004222.5848 2093413.47095 37.7283539207904 -122.427655231101 (37.7283539207904, -122.427655231101) 9 7 6 28861 5
17692 161115 1 181 580 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/25/2017 03:13:00 PM 3 Width 0ft   6003070.44185 2090129.12968 37.7192706134287 -122.431403880597 (37.7192706134287, -122.431403880597) 9 7 6 28861 5
19514 171471 1 181 225 Congdon St 1 Sidewalk: Curb side : Cutout Tree 2     3 3x5   6004711.85389 2093923.42078 37.7297817932982 -122.426000090949 (37.7297817932982, -122.426000090949) 9 7 6 28861 5
27138 160521 1 181 786 Madrid St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/18/2017 11:59:00 AM 3 Width 0ft   6001662.29271 2089410.30964 37.7172169863455 -122.436219899452 (37.7172169863455, -122.436219899452) 9 7 6 28861 5
28459 88318 7 181 607 France Ave   Sidewalk: Curb side : Cutout Tree 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51309 6002519.4 2089575.2 37.7177183994753 -122.433269062939 (37.7177183994753, -122.433269062939) 9 7 6 28861 5
71930 160603 1 181 771 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/18/2017 12:20:00 PM 3 Width 0ft   6002439.45935 2089043.61541 37.7162542504093 -122.433507413734 (37.7162542504093, -122.433507413734) 9 7 6 28861 5
89626 88352 7 181 700 VIENNA ST 2 Sidewalk: Curb side : Cutout Tree 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51333 6002601.8 2089436.1 37.7173411358396 -122.432974311079 (37.7173411358396, -122.432974311079) 9 7 6 28861 5
121189 88324 7 181 182 Lisbon St   Sidewalk: Curb side : Cutout Tree 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51313 6003195 2092351 37.7253784345628 -122.431131833246 (37.7253784345628, -122.431131833246) 9 7 6 28861 5
183982 180958 1 181 778 Madrid St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/18/2017 12:11:00 PM 3 Width 2ft   6001688.47401 2089452.0208 37.7173330033918 -122.43613238641 (37.7173330033918, -122.43613238641) 9 7 6 28861 5
186878 160606 1 181 745 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   0 Width 0ft   6002538.27018 2089198.00588 37.716683778298 -122.433176901193 (37.716683778298, -122.433176901193) 9 7 6 28861 5
193740 160520 1 181 782 Madrid St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/18/2017 12:02:00 PM 3 Width 0ft   6001673.45326 2089428.52056 37.7172676235708 -122.436182625252 (37.7172676235708, -122.436182625252) 9 7 6 28861 5
194428 253435 1 181 793 Vienna St   Sidewalk: Curb side : Cutout Tree 1 FUF 10/18/2017 11:49:00 AM 3     6002373 2088903 37.7158643806251 -122.433727084844 (37.7158643806251, -122.433727084844) 9 7 6 28861 5
194471 179002 1 181 500 Paris St 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 2ft Permit Number 778923 6001822.18343 2090679.74768 37.7207116627863 -122.43575800674 (37.7207116627863, -122.43575800674) 9 7 6 28861 5
194476 179001 1 181 500 Paris St 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft Permit Number 778923 6001827.05422 2090687.03762 37.7207319560017 -122.435741691253 (37.7207319560017, -122.435741691253) 9 7 6 28861 5
194478 35851 1 181 500 Paris St 1 Sidewalk: Curb side : Cutout Tree 2   12/21/2016 12:00:00 AM 3 3x3 Permit Number 778923 6001833.39372 2090697.41132 37.7207607999542 -122.435720519401 (37.7207607999542, -122.435720519401) 9 7 6 28861 5
194490 171446 1 181 130 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2   04/08/2017 12:00:00 AM 3 Width 2ft   6004630.97691 2092622.98585 37.7262065159928 -122.426187146329 (37.7262065159928, -122.426187146329) 9 7 6 28861 5