trees
563 rows where qSpecies_id = 52 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▲ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29971 | 117550 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 4 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
| 31787 | 176327 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 31 | Median : Cutout | Tree | DPW 1 | 46 | Width 0ft | 6009212.31958 | 2089948.46975 | 37.7191207387124 | -122.410160889327 | (37.7191207387124, -122.410160889327) | 9 | 3 | 8 | 309 | 18 | |||
| 33601 | 67497 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 143 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1999 12:00:00 AM | Permit Number 31025 | 5999134.28418924 | 2093760.51474913 | 37.7290176881307 | -122.445270595435 | (37.7290176881307, -122.445270595435) | 9 | 7 | 4 | 28861 | 40 | ||
| 38642 | 176330 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 35 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6009184.10476 | 2089961.98667 | 37.7191562718235 | -122.410259371368 | (37.7191562718235, -122.410259371368) | 9 | 3 | 8 | 309 | 18 | |||
| 45941 | 176323 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 23 | Median : Cutout | Tree | DPW 1 | 31 | Width 0ft | 6009342.20287 | 2090002.90208 | 37.719277477945 | -122.409715770784 | (37.719277477945, -122.409715770784) | 9 | 3 | 8 | 309 | 18 | |||
| 59778 | 112374 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1247 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | Permit Number 775819 | 6000424.11007 | 2096055.79143 | 37.7353935258967 | -122.440976176652 | (37.7353935258967, -122.440976176652) | 9 | 7 | 4 | 63 | 40 | |||
| 62779 | 107853 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 150 APTOS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | 9 | 8 | 4 | 59 | 40 | ||||
| 68183 | 117549 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 3 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
| 70229 | 68834 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 213 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32785 | 5999328.0521661 | 2094050.43857188 | 37.7298248100363 | -122.444621556754 | (37.7298248100363, -122.444621556754) | 9 | 7 | 4 | 28861 | 40 | ||
| 77468 | 176321 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 10 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6009491.13352 | 2090035.22052 | 37.7193745624679 | -122.409203250746 | (37.7193745624679, -122.409203250746) | 9 | 3 | 8 | 309 | 18 | |||
| 79194 | 176326 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 26 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6009300.41458 | 2090007.16421 | 37.7192868390067 | -122.409860518467 | (37.7192868390067, -122.409860518467) | 9 | 3 | 8 | 309 | 18 | |||
| 79337 | 66246 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 50 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29346 | 5995210.96497601 | 2091915.27509183 | 37.7237263724293 | -122.458700188143 | (37.7237263724293, -122.458700188143) | 9 | 8 | 4 | 28861 | 24 | ||
| 84267 | 176318 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 600x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6009900.75619 | 2090162.07565 | 37.71974582058 | -122.40779627129 | (37.71974582058, -122.40779627129) | 9 | 7 | 8 | 309 | 18 | |||
| 86806 | 176322 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6009482.93202 | 2090051.63911 | 37.7194191850237 | -122.409232758387 | (37.7194191850237, -122.409232758387) | 9 | 3 | 8 | 309 | 18 | |||
| 90938 | 26775 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 800X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 93151 | 53072 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 530@ CAPITOL Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2006 12:00:00 AM | Permit Number 49042 | 5995240.54795335 | 2090593.06935713 | 37.7200976112635 | -122.458502260031 | (37.7200976112635, -122.458502260031) | 9 | 8 | 6 | 28861 | 24 | ||
| 94023 | 65615 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 907 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | Permit Number 28522 | 6001416.70920324 | 2088928.18069936 | 37.7158792115697 | -122.437034265981 | (37.7158792115697, -122.437034265981) | 9 | 7 | 6 | 28861 | 5 | ||
| 95630 | 176324 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 24 | Median : Cutout | Tree | DPW 1 | 43 | Width 0ft | 6009336.81226 | 2089985.35608 | 37.7192289981902 | -122.409733166348 | (37.7192289981902, -122.409733166348) | 9 | 3 | 8 | 309 | 18 | |||
| 97499 | 176325 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 25 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6009306.38792 | 2090008.28787 | 37.7192902591068 | -122.409839950067 | (37.7192902591068, -122.409839950067) | 9 | 3 | 8 | 309 | 18 | |||
| 105108 | 29918 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 810 Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
| 113132 | 108685 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 301X CHESTER AVE | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 5991720 | 2087146 | 37.7104298409998 | -122.470420579231 | (37.7104298409998, -122.470420579231) | 9 | 8 | 4 | 64 | 24 | ||||
| 113696 | 65552 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 285 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28451 | 5995547.56425531 | 2097511.07200024 | 37.7391104150803 | -122.457941385434 | (37.7391104150803, -122.457941385434) | 9 | 7 | 4 | 59 | 40 | ||
| 115747 | 65553 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 283 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28452 | 5995572.37835094 | 2097534.90092934 | 37.7391772690895 | -122.457857313996 | (37.7391772690895, -122.457857313996) | 9 | 7 | 4 | 59 | 40 | ||
| 116280 | 1854 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2500 Bay Shore Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6010837.5147418 | 2086759.4488697 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | 9 | 7 | 8 | 309 | 39 | |||
| 123761 | 69542 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 775 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 8 | Permit Number 38643 | 6001970.16460074 | 2089302.5400568 | 37.71693856245 | -122.435148029449 | (37.71693856245, -122.435148029449) | 9 | 7 | 6 | 28861 | 5 | |
| 125954 | 105666 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 317X DORADO TER | 3 | unknown : Yard | Tree | Private 2 | 22 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | 9 | 8 | 4 | 28861 | 40 | ||||
| 127142 | 65482 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 519 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28366 | 5994743.29707293 | 2091977.51972285 | 37.7238703903851 | -122.460321333166 | (37.7238703903851, -122.460321333166) | 9 | 8 | 4 | 28861 | 24 | ||
| 136060 | 176328 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 32 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6009200.77281 | 2089956.05158 | 37.7191409096134 | -122.410201337249 | (37.7191409096134, -122.410201337249) | 9 | 3 | 8 | 309 | 18 | |||
| 144569 | 117548 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 2 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
| 145650 | 176329 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 33 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6009197.90265 | 2089964.97601 | 37.719165253359 | -122.410211888084 | (37.719165253359, -122.410211888084) | 9 | 3 | 8 | 309 | 18 | |||
| 149348 | 65614 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 901 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 3x3 | Permit Number 28521 | 6001429.80797007 | 2088950.28994853 | 37.7159406631737 | -122.436990572562 | (37.7159406631737, -122.436990572562) | 9 | 7 | 6 | 28861 | 5 | |
| 149539 | 176333 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 12x Canyon Dr | 12 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6002752.1139 | 2086168.71447 | 37.7083781345093 | -122.432221533399 | (37.7083781345093, -122.432221533399) | 9 | 7 | 6 | 28861 | 5 | |||
| 153608 | 117546 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 1 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
| 159523 | 218793 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 616 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 5998053.08406 | 2095010.86684 | 37.7323890825862 | -122.449098408785 | (37.7323890825862, -122.449098408785) | 9 | 7 | 4 | 59 | 40 | |||
| 161363 | 254812 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 2595 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997881 | 2089586 | 37.7174838262402 | -122.449302633722 | (37.7174838262402, -122.449302633722) | 9 | 8 | 6 | 28861 | 24 | ||||
| 162446 | 176315 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 600x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 36 | Width 0ft | 6010056.94301 | 2090202.23729 | 37.7198648386596 | -122.407259215964 | (37.7198648386596, -122.407259215964) | 9 | 7 | 8 | 309 | 18 | |||
| 170148 | 176331 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 36 | Median : Cutout | Tree | DPW 1 | 27 | Width 0ft | 6009160.31915 | 2089943.19891 | 37.7191033512163 | -122.410340263619 | (37.7191033512163, -122.410340263619) | 9 | 3 | 8 | 309 | 18 | |||
| 173225 | 1855 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2500 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 6010837.5147418 | 2086759.4488697 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | 9 | 7 | 8 | 309 | 39 | |||
| 174333 | 53071 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 530@ CAPITOL Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2006 12:00:00 AM | Permit Number 49042 | 5995240.54795335 | 2090593.06935713 | 37.7200976112635 | -122.458502260031 | (37.7200976112635, -122.458502260031) | 9 | 8 | 6 | 28861 | 24 | ||
| 174359 | 107852 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 150 APTOS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | 9 | 8 | 4 | 59 | 40 | ||||
| 176103 | 26776 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 800X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 181652 | 176319 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6009753.29629 | 2090123.38013 | 37.7196313144016 | -122.408303262296 | (37.7196313144016, -122.408303262296) | 9 | 3 | 8 | 309 | 18 | |||
| 183178 | 11637 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 499X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
| 184072 | 176332 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 40 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009122.37089 | 2089940.9339 | 37.7190950046208 | -122.410471276831 | (37.7190950046208, -122.410471276831) | 9 | 3 | 8 | 309 | 18 | |||
| 184155 | 176320 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6009693.65645 | 2090109.67926 | 37.7195903547889 | -122.408508450717 | (37.7195903547889, -122.408508450717) | 9 | 3 | 8 | 309 | 18 | |||
| 185978 | 65605 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 138 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | Permit Number 28509 | 6004309.62922812 | 2093740.61229591 | 37.7292571013758 | -122.427377609436 | (37.7292571013758, -122.427377609436) | 9 | 7 | 6 | 28861 | 5 | ||
| 190393 | 105665 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 317X DORADO TER | 2 | unknown : Yard | Tree | Private 2 | 24 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | 9 | 8 | 4 | 28861 | 40 | ||||
| 190488 | 65550 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 292 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28449 | 5995404.07668865 | 2097513.82279858 | 37.7391097231572 | -122.458437696075 | (37.7391097231572, -122.458437696075) | 9 | 7 | 4 | 59 | 40 | ||
| 192628 | 121081 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 5 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
| 5213 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 145 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 49347 | 6005480 | 2108218 | 37.7690748022624 | -122.42436083172 | (37.7690748022624, -122.42436083172) | 8 | 4 | 5 | 28853 | 19 | ||||
| 7446 | 243531 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2095 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6008748.77289 | 2106455.16153 | 37.764418495754 | -122.412929646495 | (37.764418495754, -122.412929646495) | 8 | 4 | 7 | 28859 | 19 | |||
| 53177 | 191717 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 554 Rhode Island St | 1 | : | Tree | Private 2 | 13 | Width 6ft | 6011757.49983 | 2105782.3491 | 37.762739532526 | -122.402475918038 | (37.762739532526, -122.402475918038) | 8 | 3 | 8 | 28856 | 29 | |||
| 66384 | 66803 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 42 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30083 | 6006463.70585844 | 2108242.90937755 | 37.76919869647 | -122.420960014682 | (37.76919869647, -122.420960014682) | 8 | 4 | 7 | 28853 | 19 | ||
| 83066 | 68706 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3727 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32714 | 6004057.02264849 | 2105954.86981245 | 37.7627803365256 | -122.429121438821 | (37.7627803365256, -122.429121438821) | 8 | 4 | 5 | 28862 | 3 | ||
| 85125 | 101217 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 444 De Haro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011994.2 | 2106304.5 | 37.7641864535036 | -122.401693953948 | (37.7641864535036, -122.401693953948) | 8 | 3 | 8 | 28856 | 29 | ||||
| 160280 | 191716 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 561 Rhode Island St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6011818.5901 | 2105765.65198 | 37.7626970962079 | -122.402263453208 | (37.7626970962079, -122.402263453208) | 8 | 3 | 8 | 28856 | 29 | |||
| 116 | 113159 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005146 | 2111243 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | 7 | 9 | 11 | 28852 | 10 | ||||
| 3489 | 244479 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 124 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005906.1302 | 2110197.2252 | 37.7745333330343 | -122.423027565946 | (37.7745333330343, -122.423027565946) | 7 | 9 | 11 | 28852 | 10 | |||
| 3823 | 121262 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 505 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005321 | 2111256 | 37.7774074352434 | -122.42512699851 | (37.7774074352434, -122.42512699851) | 7 | 9 | 11 | 28852 | 10 | |||
| 31523 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 302 Ivy St | 18 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
| 35379 | 254803 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 525 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005345 | 2110923 | 37.7764944541895 | -122.425020275756 | (37.7764944541895, -122.425020275756) | 7 | 9 | 11 | 28852 | 10 | ||||
| 38428 | 58101 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 535 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29160 | 6004548.41463352 | 2110369.10321649 | 37.774928559979 | -122.427736418344 | (37.774928559979, -122.427736418344) | 7 | 9 | 11 | 28852 | 10 | ||
| 42746 | 87674 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 10 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
| 63332 | 95379 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
| 70602 | 142225 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 641 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004777.6628 | 2110866.818 | 37.7763081284007 | -122.426978855787 | (37.7763081284007, -122.426978855787) | 7 | 9 | 11 | 28852 | 10 | |||
| 72544 | 95380 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
| 105041 | 66384 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 289 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29510 | 6003897.0288205 | 2108659.24127875 | 37.7701968288604 | -122.429867711068 | (37.7701968288604, -122.429867711068) | 7 | 9 | 5 | 29492 | 10 | ||
| 120835 | 95378 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
| 123227 | 95381 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
| 124647 | 6173 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1075 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
| 137140 | 112418 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 268X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | ||||
| 140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 146575 | 122380 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 557 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005149 | 2111246 | 37.777370259808 | -122.425721291473 | (37.777370259808, -122.425721291473) | 7 | 9 | 11 | 28852 | 10 | |||
| 150229 | 87675 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 11 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
| 154893 | 62017 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 53 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1986 12:00:00 AM | Permit Number 22088 | 6004287.33949957 | 2108757.29100043 | 37.7704881450556 | -122.428524619186 | (37.7704881450556, -122.428524619186) | 7 | 9 | 11 | 29492 | 10 | ||
| 165498 | 75663 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1990 12:00:00 AM | 25 | 6003991.19971734 | 2108404.68072341 | 37.7695031998873 | -122.429523817606 | (37.7695031998873, -122.429523817606) | 7 | 9 | 5 | 29492 | 10 | |||
| 184342 | 139748 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.7838090228042 | -122.427648355277 | (37.7838090228042, -122.427648355277) | 7 | 9 | 11 | 28858 | 41 | |||
| 92481 | 32999 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
| 158313 | 30787 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 488 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1995 12:00:00 AM | 3x3 | Permit Number 51964 | 6013865.01842582 | 2112595.14259648 | 37.7815633679001 | -122.395664068446 | (37.7815633679001, -122.395664068446) | 6 | 2 | 9 | 28856 | 6 | ||
| 180688 | 32992 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
| 184426 | 32990 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
| 186774 | 32991 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
| 32951 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 4 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
| 77919 | 32699 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 665 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37104 | 6008544.39382175 | 2114510.13304212 | 37.7865240684083 | -122.414206472781 | (37.7865240684083, -122.414206472781) | 5 | 1 | 9 | 28852 | 36 | ||
| 115879 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 5 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
| 131448 | 112486 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 6 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||
| 157517 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
| 167115 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
| 192906 | 61359 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | 5 | 1 | 10 | 28857 | 21 | ||
| 64346 | 109844 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 535 CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 5x5 | 6012019 | 2117742 | 37.7955925645 | -122.402412455116 | (37.7955925645, -122.402412455116) | 3 | 1 | 10 | 28860 | 4 | |||
| 400 | 104991 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 669X NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6003139 | 2104447 | 37.7585880783392 | -122.432188863302 | (37.7585880783392, -122.432188863302) | 2 | 4 | 5 | 28862 | 3 | |||
| 445 | 110235 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 2346x CASTRO ST | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6002664.5 | 2098664.4 | 37.7426835115852 | -122.433416673574 | (37.7426835115852, -122.433416673574) | 2 | 7 | 5 | 63 | 7 | ||||
| 2604 | 224449 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1201 San Jose Ave | 62 | Front Yard : Yard | Tree | Private 2 | 22 | 6004503.55801 | 2096138.79869 | 37.7358529500558 | -122.426877907491 | (37.7358529500558, -122.426877907491) | 2 | 7 | 5 | 28861 | 2 | ||||
| 3070 | 52712 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 53@ FAIR AVE Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/31/2006 12:00:00 AM | Permit Number 48768 | 6006913.27477728 | 2099421.81000315 | 37.7450033243522 | -122.418779304454 | (37.7450033243522, -122.418779304454) | 2 | 7 | 7 | 28859 | 2 | ||
| 3174 | 224198 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 30 | Front Yard : Yard | Tree | Private 2 | 9 | 6005259.16763 | 2097058.51402 | 37.7384209767501 | -122.424330858406 | (37.7384209767501, -122.424330858406) | 2 | 7 | 5 | 28859 | 2 | ||||
| 3480 | 40261 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3543 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2005 12:00:00 AM | Permit Number 47928 | 6005992.45992589 | 2101968.12777251 | 37.7519430420387 | -122.422144186794 | (37.7519430420387, -122.422144186794) | 2 | 4 | 5 | 28859 | 19 | ||
| 8705 | 224209 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 20 | 6005356.45271 | 2097454.81484 | 37.7395146225008 | -122.424022667913 | (37.7395146225008, -122.424022667913) | 2 | 7 | 5 | 28859 | 2 | ||||
| 16913 | 34491 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1723 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38214 | 6009344.79247114 | 2099429.66611089 | 37.7451615013423 | -122.410372074504 | (37.7451615013423, -122.410372074504) | 2 | 7 | 7 | 28859 | 2 | ||
| 19966 | 4328 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 816 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2000 12:00:00 AM | 3 | 3X3 | 6001892.96711 | 2095861.16752 | 37.7349426843331 | -122.435883876812 | (37.7349426843331, -122.435883876812) | 2 | 7 | 5 | 63 | 7 | ||
| 21497 | 106463 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 3 | Median : Cutout | Tree | DPW 1 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );