trees
327 rows where qLegalStatus_id = 1 and qSpecies_id = 35 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 267 | 178174 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988358.3694 | 2089791.63303 | 37.717499145949 | -122.482232652541 | (37.717499145949, -122.482232652541) | 1 | 8 | 4 | 64 | 14 | ||||
| 436 | 120628 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 1049 | 120626 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 2117 | 111271 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 42 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 20168 | 211040 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6001161.45161 | 2095717.92279 | 37.7345077855016 | -122.438402718629 | (37.7345077855016, -122.438402718629) | 9 | 7 | 5 | 63 | 7 | ||||
| 22684 | 120262 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 24th Ave | 6 | Side Yard : Yard | Tree | Private 2 | 26 | 5988353.58713 | 2115180.43805 | 37.7872097252822 | -122.484109995805 | (37.7872097252822, -122.484109995805) | 11 | 6 | 1 | 55 | 33 | ||||
| 36557 | 211039 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6001157.31367 | 2095726.26325 | 37.7345304511011 | -122.438417622186 | (37.7345304511011, -122.438417622186) | 9 | 7 | 5 | 63 | 7 | ||||
| 37212 | 111553 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 31 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 39027 | 211036 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001192.69302 | 2095737.41742 | 37.7345630902121 | -122.438296103083 | (37.7345630902121, -122.438296103083) | 2 | 7 | 5 | 63 | 7 | ||||
| 39660 | 111514 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 40576 | 120625 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6004349 | 2113949 | 37.7847467885767 | -122.428681484586 | (37.7847467885767, -122.428681484586) | 13 | 9 | 11 | 29490 | 41 | |||||
| 41737 | 115997 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20X Park St | 2 | Median : Yard | Tree | DPW 1 | 08/30/2016 09:25:00 AM | 3 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | 2 | 7 | 5 | 28859 | 2 | |||
| 45135 | 111279 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 17 | Front Yard : Yard | Tree | DPW 1 | 24 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 54367 | 253555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 27 Ceres St | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 6013919.66127 | 2093997.42296 | 37.7305010827376 | -122.394172607985 | (37.7305010827376, -122.394172607985) | 10 | 3 | 8 | 58 | 1 | ||||
| 58106 | 132162 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 11 | Front Yard : Yard | Tree | Private 2 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.407713714409 | (37.8053168133783, -122.407713714409) | 3 | 1 | 10 | 308 | 23 | ||||
| 63516 | 178176 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989163.89955 | 2089384.56057 | 37.7164282485354 | -122.479418571325 | (37.7164282485354, -122.479418571325) | 1 | 8 | 4 | 64 | 14 | ||||
| 66177 | 109347 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 59x BURNSIDE AVE | 1 | Median : Yard | Tree | DPW 1 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | 2 | 7 | 5 | 63 | 7 | ||||
| 66990 | 98838 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1101X Portola Dr | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 5994967.95791 | 2097979.30417 | 37.740362747151 | -122.459979297607 | (37.740362747151, -122.459979297607) | 9 | 8 | 4 | 59 | 40 | |||
| 68490 | 243115 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 18 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001841.69539 | 2098643.31719 | 37.7425789076843 | -122.436260181872 | (37.7425789076843, -122.436260181872) | 2 | 7 | 5 | 63 | 7 | |||
| 69254 | 111516 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 11 | Front Yard : Yard | Tree | DPW 1 | 14 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 69447 | 111507 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 2 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 69893 | 211037 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6001183.29295 | 2095747.84811 | 37.7345911958118 | -122.438329349227 | (37.7345911958118, -122.438329349227) | 2 | 7 | 5 | 63 | 7 | ||||
| 71549 | 234477 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Grand View Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 5999979.48342 | 2101750.0189 | 37.7510031819599 | -122.442922193204 | (37.7510031819599, -122.442922193204) | 2 | 4 | 5 | 28862 | 22 | ||||
| 74434 | 120629 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
| 83309 | 247525 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1101 Waller St | 6 | Side Yard : Yard | Tree | Private 2 | 2 | 6000029.93527 | 2108491.27934 | 37.7695158962756 | -122.443231851395 | (37.7695158962756, -122.443231851395) | 15 | 5 | 11 | 29492 | 9 | ||||
| 83823 | 211035 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6001198.5187 | 2095714.51341 | 37.7345005324595 | -122.438274321504 | (37.7345005324595, -122.438274321504) | 2 | 7 | 5 | 63 | 7 | ||||
| 87630 | 243112 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 15 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001806.81928 | 2098684.11193 | 37.7426889388393 | -122.436383692077 | (37.7426889388393, -122.436383692077) | 2 | 7 | 5 | 63 | 7 | |||
| 93553 | 178171 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988123.04078 | 2089845.83927 | 37.7176342915553 | -122.483050036443 | (37.7176342915553, -122.483050036443) | 1 | 8 | 4 | 64 | 14 | ||||
| 94007 | 132160 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1141 Chestnut St | 5 | Front Yard : Yard | Tree | Private 2 | 20 | 6006382.37262 | 2120397.93248 | 37.8025688116636 | -122.422104980572 | (37.8025688116636, -122.422104980572) | 5 | 9 | 1 | 28858 | 32 | ||||
| 95623 | 178173 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988347.73388 | 2089792.82325 | 37.717501795356 | -122.482269501364 | (37.717501795356, -122.482269501364) | 1 | 8 | 4 | 64 | 14 | ||||
| 97385 | 112912 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 480X BEACON ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 30 | 6002571 | 2098077 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | 2 | 7 | 5 | 63 | 7 | ||||
| 101189 | 111558 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 36 | Front Yard : Yard | Tree | DPW 1 | 15 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 107565 | 252925 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Sanchez St | 2 | Front Yard : Yard | Tree | DPW 1 | 6003672 | 2104202 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | 2 | 4 | 5 | 28862 | 3 | |||||
| 113773 | 111508 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 3 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 113834 | 243114 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 17 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001830.21459 | 2098656.61242 | 37.7426147609522 | -122.436300830338 | (37.7426147609522, -122.436300830338) | 2 | 7 | 5 | 63 | 7 | |||
| 115061 | 243111 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 13 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001795.3662 | 2098698.75734 | 37.7427285009166 | -122.436424341429 | (37.7427285009166, -122.436424341429) | 2 | 7 | 5 | 63 | 7 | |||
| 120441 | 234471 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350 Noe St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6003196.85258 | 2100348.13678 | 37.7473368492221 | -122.431696139568 | (37.7473368492221, -122.431696139568) | 2 | 4 | 5 | 63 | 22 | ||||
| 122378 | 101036 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1010X Portola Dr | 10 | Front Yard : Yard | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||
| 127523 | 243106 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 9 | Median : Yard | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 6001667.33897 | 2098826.57882 | 37.7430721930381 | -122.436876170699 | (37.7430721930381, -122.436876170699) | 2 | 7 | 5 | 63 | 7 | |||
| 135146 | 243113 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 16 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001816.52967 | 2098672.65474 | 37.7426580318326 | -122.436349296602 | (37.7426580318326, -122.436349296602) | 2 | 7 | 5 | 63 | 7 | |||
| 137465 | 234473 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | 6007295.70063 | 2098744.01488 | 37.7431637754778 | -122.417408915989 | (37.7431637754778, -122.417408915989) | 2 | 7 | 7 | 28859 | 2 | ||||
| 137776 | 178172 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988133.68649 | 2089845.13121 | 37.7176329668754 | -122.483013187625 | (37.7176329668754, -122.483013187625) | 1 | 8 | 4 | 64 | 14 | ||||
| 138421 | 243116 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 19 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001856.44522 | 2098624.22352 | 37.7425273189785 | -122.436207815256 | (37.7425273189785, -122.436207815256) | 2 | 7 | 5 | 63 | 7 | |||
| 141285 | 120542 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | DPW for City Agency | 6002644.10897 | 2115479.97736 | 37.7888538273233 | -122.434689351726 | (37.7888538273233, -122.434689351726) | 13 | 9 | 1 | 29490 | 27 | ||||
| 144446 | 178170 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5989035.58475 | 2090454.34239 | 37.7193581480518 | -122.479940326497 | (37.7193581480518, -122.479940326497) | 1 | 8 | 4 | 64 | 14 | ||||
| 146907 | 243109 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 10 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001750.32805 | 2098751.0187 | 37.7428694390712 | -122.436583810118 | (37.7428694390712, -122.436583810118) | 2 | 7 | 5 | 63 | 7 | |||
| 147440 | 111557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 35 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 150152 | 120624 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 150320 | 111555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 33 | Front Yard : Yard | Tree | DPW 1 | 24 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 155300 | 178177 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 167 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004561.94872 | 2092421.12411 | 37.7256483463685 | -122.426411406667 | (37.7256483463685, -122.426411406667) | 9 | 7 | 6 | 28861 | 5 | ||||
| 156411 | 120627 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 161876 | 211038 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 6001171.81546 | 2095754.02956 | 37.7346075158123 | -122.438369473392 | (37.7346075158123, -122.438369473392) | 2 | 7 | 5 | 63 | 7 | ||||
| 162963 | 243101 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 1 | Median : Yard | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 6001501.83115 | 2098971.73396 | 37.7434613467555 | -122.437458843264 | (37.7434613467555, -122.437458843264) | 2 | 7 | 5 | 63 | 7 | |||
| 165137 | 101040 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1010X Portola Dr | 14 | Front Yard : Yard | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||
| 165450 | 243102 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 6 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001583.44665 | 2098902.15724 | 37.7432749451763 | -122.437171657349 | (37.7432749451763, -122.437171657349) | 2 | 7 | 5 | 63 | 7 | |||
| 170489 | 178175 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5989026.35056 | 2089515.50206 | 37.7167797908382 | -122.47990357931 | (37.7167797908382, -122.47990357931) | 1 | 8 | 4 | 64 | 14 | ||||
| 171251 | 111554 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 32 | Front Yard : Yard | Tree | DPW 1 | 26 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 175848 | 111265 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 3 | Front Yard : Yard | Tree | DPW 1 | 20 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 178910 | 61559 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1096 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 08/25/1984 12:00:00 AM | 16 | Permit Number 21519 | 6012461.11053783 | 2102868.78681941 | 37.7547787864142 | -122.399837764002 | (37.7547787864142, -122.399837764002) | 10 | 3 | 8 | 28856 | 29 | ||
| 182602 | 132161 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 10 | Front Yard : Yard | Tree | Private 2 | 15 | 6010552.8238 | 2121311.79296 | 37.8053123842132 | -122.407737540175 | (37.8053123842132, -122.407737540175) | 3 | 1 | 10 | 308 | 23 | ||||
| 183037 | 8530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100X Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 15 | 6001630.1932 | 2113615.3325 | 37.7836763773468 | -122.438063730933 | (37.7836763773468, -122.438063730933) | 15 | 5 | 11 | 29490 | 41 | |||
| 183595 | 101034 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1010X Portola Dr | 8 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
| 189067 | 243103 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 8 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001619.86426 | 2098870.33574 | 37.7431896408852 | -122.437043457211 | (37.7431896408852, -122.437043457211) | 2 | 7 | 5 | 63 | 7 | |||
| 83122 | 2045 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Bosworth St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
| 160462 | 2028 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600X Bosworth St | 5 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |||
| 96483 | 4970 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 6 | Median : Cutout | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 12 | 6000842.33366 | 2099520.2529 | 37.7449299333661 | -122.439778532074 | (37.7449299333661, -122.439778532074) | 2 | 7 | 5 | 63 | 7 | ||
| 194257 | 4968 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12/03/2018 12:00:00 AM | 3 | 12 | 6000815.91312 | 2099549.13893 | 37.7450077436274 | -122.439871959934 | (37.7450077436274, -122.439871959934) | 2 | 7 | 5 | 63 | 7 | ||
| 194284 | 4966 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/03/2018 12:00:00 AM | 3 | 12 | 6000791.48606 | 2099581.9209 | 37.7450963646197 | -122.439958774198 | (37.7450963646197, -122.439958774198) | 2 | 7 | 5 | 63 | 7 | ||
| 124888 | 2268 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 750X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 6 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
| 164072 | 2266 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 12 | Median : Cutout | Tree | DPW 1 | 04/04/2014 12:00:00 AM | 22 | 14M | Permit Number 772491 | 5991180.7931196 | 2088069.9959997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | 1 | 8 | 4 | 64 | 14 | |
| 161693 | 3773 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1098 Carolina St | 6 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
| 5625 | 19976 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY45 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
| 7691 | 19980 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY45 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
| 9342 | 23614 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 910X Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 30X30PL | 6011300.2113585 | 2104101.3880723 | 37.7580984495586 | -122.403939228694 | (37.7580984495586, -122.403939228694) | 10 | 3 | 8 | 28856 | 29 | |||
| 63272 | 4532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6005027.0371 | 2113673.2533 | 37.784028006638 | -122.42631605912 | (37.784028006638, -122.42631605912) | 7 | 9 | 11 | 28858 | 41 | |
| 66433 | 8563 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
| 71757 | 8562 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
| 107231 | 8560 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
| 113256 | 8561 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
| 127704 | 4530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004963.1338 | 2113665.364 | 37.7840027322121 | -122.426536579485 | (37.7840027322121, -122.426536579485) | 7 | 9 | 11 | 28858 | 41 | |
| 129439 | 4367 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 973 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001101.12966 | 2096102.69208 | 37.7355608412513 | -122.438638832041 | (37.7355608412513, -122.438638832041) | 2 | 7 | 5 | 63 | 7 | |||
| 137065 | 4531 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004996.2689 | 2113667.7308 | 37.7840111039908 | -122.426422112629 | (37.7840111039908, -122.426422112629) | 7 | 9 | 11 | 28858 | 41 | |
| 83492 | 116067 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 4150X CLEMENT ST | 5 | Front Yard : Yard | Tree | DPW 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |
| 86234 | 173745 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
| 106659 | 111575 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1x SUNSET BLVD OFF RAMP | 7 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | 5984955 | 2095624 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | 1 | 8 | 4 | 64 | 35 | |||
| 186953 | 173744 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
| 192931 | 173637 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008672 | 2111900 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | 8 | 2 | 9 | 28853 | 34 | ||||
| 193081 | 173746 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
| 15936 | 19986 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY46 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
| 187095 | 21459 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | |||
| 153963 | 24789 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7700 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.7794353864392 | -122.502049785013 | (37.7794353864392, -122.502049785013) | 11 | 6 | 2 | 55 | 26 | |||
| 82660 | 27295 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 2 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.7792423135673 | -122.503361806845 | (37.7792423135673, -122.503361806845) | 11 | 6 | 2 | 55 | 26 | ||
| 136516 | 27297 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 4 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.86392 | 2112396.64212 | 37.7792343387449 | -122.503529847504 | (37.7792343387449, -122.503529847504) | 11 | 6 | 2 | 55 | 26 | ||
| 150758 | 27296 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 3 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982703.46074 | 2112397.79309 | 37.7792388274313 | -122.50345176232 | (37.7792388274313, -122.50345176232) | 11 | 6 | 2 | 55 | 26 | ||
| 151464 | 27298 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 5 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982658.07107 | 2112395.9042 | 37.7792309725957 | -122.503608641413 | (37.7792309725957, -122.503608641413) | 11 | 6 | 2 | 55 | 26 | ||
| 161640 | 27299 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 6 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982630.17797 | 2112395.09735 | 37.7792271172593 | -122.503705073784 | (37.7792271172593, -122.503705073784) | 11 | 6 | 2 | 55 | 26 | ||
| 175352 | 27294 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 1 | Median : Cutout | Tree | Fire Dept 16 | 02/12/2001 12:00:00 AM | 6 | 5X5 | 5982752.16339 | 2112399.44122 | 37.7792462157513 | -122.503283404585 | (37.7792462157513, -122.503283404585) | 11 | 6 | 2 | 55 | 26 | ||
| 6586 | 258122 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 4 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:11:00 PM | 3 | 5x5 | ||||||||||||
| 6935 | 258120 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 2 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:06:00 PM | 3 | 5x5 | ||||||||||||
| 13326 | 258119 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 1 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:14:00 PM | 3 | 5x5 |
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) );