trees

Custom SQL query returning 29 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
93586 102654 7 65 203X Farallones St 3 Sidewalk: Curb side : Cutout Tree 2     10 3x3   5995004 2088355 37.7139388056528 -122.459157943572 (37.7139388056528, -122.459157943572) 9 8 6 28861 24
160387 203556 1 65 209 Farallones St 3 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   5994991.30881 2088378.07982 37.7140014477822 -122.45920347906 (37.7140014477822, -122.45920347906) 9 8 6 28861 24
119492 203554 1 65 209 Farallones St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   5994942.92929 2088379.09284 37.7140014477918 -122.459370769157 (37.7140014477918, -122.459370769157) 9 8 6 28861 24
168312 175182 1 65 647 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6002406.62971 2090005.70634 37.718894076269 -122.433689610108 (37.718894076269, -122.433689610108) 9 7 6 28861 5
8943 73896 1 65 800 Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree 2 FUF   10     6004393.10182 2091444.69797 37.7229577492801 -122.426925586868 (37.7229577492801, -122.426925586868) 9 7 6 28861 5
21664 175212 1 65 87x Valmar Ter 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6005258.73549 2092540.80848 37.7260163372638 -122.424011175489 (37.7260163372638, -122.424011175489) 9 7 7 309 5
183128 175208 1 65 9 Athens St 3 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6005371.81589 2093231.88981 37.727920278496 -122.423669377345 (37.727920278496, -122.423669377345) 9 7 6 28861 5
172356 175209 1 65 9 Athens St 5 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6005385.77988 2093250.96165 37.7279734338052 -122.423622458831 (37.7279734338052, -122.423622458831) 9 7 6 28861 5
172281 203590 1 65 120 Judson Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   5999238.54402 2093513.75556 37.7283460957772 -122.444892431558 (37.7283460957772, -122.444892431558) 9 7 4 28861 40
21660 65231 1 65 812 Silliman St 1 Sidewalk: Curb side : Cutout Tree 2   07/24/1989 12:00:00 AM 10   Permit Number 28018 6008328.075 2093605.15348 37.7291116131036 -122.41347586773 (37.7291116131036, -122.41347586773) 9 3 7 309 28
95747 221850 1 65 19 Saint Marys Ave 6 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6004464.56621 2095558.73638 37.7342580248697 -122.426971417216 (37.7342580248697, -122.426971417216) 2 7 5 28861 25
166822 221848 1 65 19 Saint Marys Ave 4 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6004429.19741 2095585.11426 37.7343284525969 -122.427095576708 (37.7343284525969, -122.427095576708) 2 7 5 28861 25
38326 221845 1 65 19 Saint Marys Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6004371.42755 2095618.1193 37.7344158100226 -122.427297656166 (37.7344158100226, -122.427297656166) 2 7 5 28861 25
10220 221824 1 65 199X Ogden Ave 10 Sidewalk: Curb side : Pot Tree 2     10 Width 4ft   6007730.82531 2096150.27006 37.7360663969372 -122.415720751814 (37.7360663969372, -122.415720751814) 2 7 7 28859 2
35034 221861 1 65 246 Chenery St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6004637.65749 2096950.59035 37.7380895280136 -122.426472056954 (37.7380895280136, -122.426472056954) 2 7 5 63 7
77808 104992 1 65 2423 47TH AVE 1 Sidewalk: Curb side : Yard Tree 2   01/14/2016 12:00:00 AM 10 2x6 Permit Number 775156 5981729.7 2098576.9 37.7412333126477 -122.505795454359 (37.7412333126477, -122.505795454359) 1 8 3 29491 35
85330 221801 1 65 378 Valley St 3 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6003412.45231 2099242.88691 37.7443143087709 -122.430871746349 (37.7443143087709, -122.430871746349) 2 7 5 63 22
187229 83487 1 65 2051 44th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/23/2008 12:00:00 AM 10 3x3 Permit Number 50156 5982589.2289 2101159.5488 37.7483751044578 -122.503014711943 (37.7483751044578, -122.503014711943) 1 8 3 29491 35
71659 221855 1 65 310 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6000611.21677 2101947.64163 37.7515818030572 -122.440751776575 (37.7515818030572, -122.440751776575) 2 4 5 28862 22
16727 227695 1 65 4250 21st St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 5ft   6001245.67427 2103366.3123 37.7555132424609 -122.438659390527 (37.7555132424609, -122.438659390527) 2 4 5 28862 3
42770 221831 1 65 569 Capp St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6007292.05586 2104018.90213 37.7576472149557 -122.417795338504 (37.7576472149557, -122.417795338504) 2 4 7 28859 19
183302 37071 1 65 1426 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 10   Permit Number 39847 5982798.7178 2105383.4209 37.7599849826858 -122.502602909857 (37.7599849826858, -122.502602909857) 1 8 3 56 35
158774 83067 1 65 624 De Haro St 1 Sidewalk: Curb side : Cutout Tree 2   07/02/2009 12:00:00 AM 10 3x6 Permit Number 52379 6012068.69574 2105475.40084 37.7619140888872 -122.401378022999 (37.7619140888872, -122.401378022999) 10 3 8 28856 29
186443 83009 1 65 622 De Haro St 1 Sidewalk: Curb side : Cutout Tree 2   07/02/2009 12:00:00 AM 10 3x3 Permit Number 52378 6012068.99141 2105489.95153 37.7619540583423 -122.401378022995 (37.7619540583423, -122.401378022995) 10 3 8 28856 29
181359 107593 1 65 1801 Anza St 2 Sidewalk: Curb side : Cutout Tree 2     10 4x6   5993030.37815 2112040.04561 37.7788582423825 -122.467700965505 (37.7788582423825, -122.467700965505) 11 6 2 54 11
185738 139916 1 65 1000 LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   6004814.4523 2112350.3862 37.7803837224117 -122.426957277261 (37.7803837224117, -122.426957277261) 7 9 11 28852 41
117746 109922 1 65 20 Dashiell Hammett St 4 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6010385.90065 2115990.02467 37.7906907621072 -122.407939683476 (37.7906907621072, -122.407939683476) 5 1 10 28857 21
182873 125555 1 65 22 Dashiell Hammett St 4 Sidewalk: Curb side : Cutout Tree 2     10 Width 1ft   6010375.3917 2116064.19944 37.7908938398292 -122.40798127711 (37.7908938398292, -122.40798127711) 5 1 10 28857 21
46734 125549 1 65 1445 Greenwich St 7 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   6006015.52243 2119649.2025 37.8004922923456 -122.423321211112 (37.8004922923456, -122.423321211112) 13 9 1 28858 32