trees
439 rows where qSpecies_id = 148 sorted by Fire Prevention Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14247 | 256666 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1406 California St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782597 | |||||||||||
| 19838 | 207 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2919 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/1994 12:00:00 AM | 20 | 2X3 | 5990501.92231 | 2095794.16798 | 37.7341050531518 | -122.47526143143 | (37.7341050531518, -122.47526143143) | 1 | 8 | 4 | 64 | 35 | ||
| 117503 | 293 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3355 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/1994 12:00:00 AM | 20 | 2 | 5990512.87275 | 2093746.75836 | 37.7284840191392 | -122.475074162513 | (37.7284840191392, -122.475074162513) | 1 | 8 | 4 | 64 | 14 | ||
| 152845 | 270 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3201X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1999 12:00:00 AM | 6 | 2X2 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 14266 | 104341 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 953 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2013 12:00:00 AM | 3x3 | Permit Number 770725 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | ||
| 2703 | 2795 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 6530X California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 75 | 5 | 5987349.71414 | 2113973.97564 | 37.783838627391 | -122.487494476151 | (37.783838627391, -122.487494476151) | 11 | 6 | 1 | 55 | 33 | |||
| 16561 | 3199 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3700X California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 11:41:00 AM | 3 | 3X3 | 5996731.2206933 | 2114663.0950297 | 37.7862734316129 | -122.455087955232 | (37.7862734316129, -122.455087955232) | 11 | 6 | 1 | 54 | 31 | ||
| 16919 | 27303 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4339 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5994091.63002 | 2114139.77761 | 37.7846847585801 | -122.464182179248 | (37.7846847585801, -122.464182179248) | 11 | 6 | 2 | 54 | 11 | |||
| 18997 | 146023 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 211 Cornwall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5994760.92974 | 2114191.03867 | 37.7848640608675 | -122.46187036015 | (37.7848640608675, -122.46187036015) | 11 | 6 | 2 | 54 | 11 | |||
| 21126 | 27305 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4405 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5993893.05463 | 2114093.73932 | 37.7845469027899 | -122.464865833974 | (37.7845469027899, -122.464865833974) | 11 | 6 | 2 | 54 | 11 | |||
| 50243 | 26639 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 6530X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 80 | 5 | 5987349.71414 | 2113973.97564 | 37.783838627391 | -122.487494476151 | (37.783838627391, -122.487494476151) | 11 | 6 | 1 | 55 | 33 | ||
| 59981 | 27302 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4327 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5994140.41077 | 2114141.59782 | 37.7846925678068 | -122.464013547575 | (37.7846925678068, -122.464013547575) | 11 | 6 | 2 | 54 | 11 | |||
| 82500 | 112842 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 604 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2015 12:00:00 AM | Permit Number 773221 | 5992274.9 | 2111288.5 | 37.7767510524606 | -122.470259695975 | (37.7767510524606, -122.470259695975) | 11 | 6 | 2 | 54 | 11 | |||
| 123351 | 3220 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3838 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2012 12:00:00 AM | 2 | 3x3 | 5995990.5445804 | 2114559.6929387 | 37.7859469971234 | -122.457643002187 | (37.7859469971234, -122.457643002187) | 11 | 6 | 1 | 54 | 31 | ||
| 134491 | 27307 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4431 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5993817.95209 | 2114090.93355 | 37.7845348684789 | -122.465125457344 | (37.7845348684789, -122.465125457344) | 11 | 6 | 2 | 54 | 11 | |||
| 150783 | 3258 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4134 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2000 12:00:00 AM | 8 | 3X3 | 5994723.99031 | 2114406.57793 | 37.7854537467716 | -122.46201379337 | (37.7854537467716, -122.46201379337) | 11 | 6 | 1 | 54 | 11 | ||
| 156969 | 27499 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3478X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997784.225 | 2114880.84142 | 37.786931659649 | -122.451460562094 | (37.786931659649, -122.451460562094) | 11 | 6 | 1 | 54 | 31 | |||
| 159637 | 123676 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4620 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782655 | 5993209.68387 | 2114188.73207 | 37.7847683024995 | -122.467236954218 | (37.7847683024995, -122.467236954218) | 11 | 6 | 2 | 54 | 11 | |
| 168625 | 27306 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4419 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5993893.05463 | 2114093.73932 | 37.7845469027899 | -122.464865833974 | (37.7845469027899, -122.464865833974) | 11 | 6 | 2 | 54 | 11 | |||
| 178366 | 3212 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3800X California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/1994 12:00:00 AM | 25 | 3X3 | 5996156.57307 | 2114605.43515 | 37.7860821290085 | -122.457071902611 | (37.7860821290085, -122.457071902611) | 11 | 6 | 1 | 54 | 31 | ||
| 179179 | 27304 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4355 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 3X3 | 5994036.54811 | 2114137.7225 | 37.7846759409315 | -122.464372593569 | (37.7846759409315, -122.464372593569) | 11 | 6 | 2 | 54 | 11 | |||
| 191922 | 3201 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3700X California St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2005 12:00:00 AM | 3 | 3X3 | 5996548.27505 | 2114783.92692 | 37.786594706495 | -122.455729633586 | (37.786594706495, -122.455729633586) | 11 | 6 | 1 | 54 | 31 | ||
| 40360 | 13581 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | |||
| 42062 | 13492 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 215 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013729.1406446 | 2116782.463481 | 37.7930532214207 | -122.396427736192 | (37.7930532214207, -122.396427736192) | 12 | 2 | 9 | 28855 | 6 | ||
| 74683 | 13505 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 245 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013642.6483486 | 2116679.2066582 | 37.7927648888925 | -122.396719764541 | (37.7927648888925, -122.396719764541) | 12 | 2 | 9 | 28855 | 6 | ||
| 82698 | 13471 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
| 88844 | 13503 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 245 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013642.6483486 | 2116679.2066582 | 37.7927648888925 | -122.396719764541 | (37.7927648888925, -122.396719764541) | 12 | 2 | 9 | 28855 | 6 | ||
| 91931 | 13591 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2004 12:00:00 AM | 8 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | ||
| 112989 | 13466 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
| 120614 | 13586 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2004 12:00:00 AM | 20 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | ||
| 120690 | 13657 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 619 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6012007.3883744 | 2115123.3531128 | 37.7884017343709 | -122.402268428095 | (37.7884017343709, -122.402268428095) | 12 | 2 | 9 | 28855 | 6 | |||
| 127010 | 13469 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
| 166367 | 13463 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
| 176159 | 13468 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
| 190865 | 13588 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | |||
| 191456 | 13493 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 215 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013729.1406446 | 2116782.463481 | 37.7930532214207 | -122.396427736192 | (37.7930532214207, -122.396427736192) | 12 | 2 | 9 | 28855 | 6 | ||
| 7301 | 172637 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1675 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2013 12:00:00 AM | 3 | Width 3ft | 6006387.36369 | 2115949.63382 | 37.790355184582 | -122.421771561426 | (37.790355184582, -122.421771561426) | 13 | 9 | 10 | 28858 | 21 | ||
| 26556 | 26652 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2324 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | 13 | 9 | 1 | 29490 | 27 | |||
| 37333 | 8452 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1850X Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6002863.14639 | 2113881.31105 | 37.7844767282199 | -122.433817202745 | (37.7844767282199, -122.433817202745) | 13 | 9 | 11 | 29490 | 13 | ||
| 43845 | 3131 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3200 California St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 5998952.52581 | 2114994.22768 | 37.7873098198001 | -122.447426688631 | (37.7873098198001, -122.447426688631) | 13 | 6 | 1 | 54 | 31 | ||
| 49683 | 116229 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1699 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | 13 | 9 | 11 | 29490 | 13 | |||||
| 51452 | 2624 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781445 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | 13 | 9 | 11 | 28858 | 27 | |
| 51845 | 116302 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 56014 | 8417 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1625X Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1997 12:00:00 AM | 6 | 3X3 | 6003997.4163 | 2113895.15466 | 37.7845790386871 | -122.429894005852 | (37.7845790386871, -122.429894005852) | 13 | 9 | 11 | 29490 | 41 | ||
| 59971 | 116303 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 60464 | 116304 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 67495 | 3009 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2402 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2012 12:00:00 AM | 3 | 3x3 | 6002808.01196 | 2115517.13179 | 37.7889651474795 | -122.434124927834 | (37.7889651474795, -122.434124927834) | 13 | 9 | 1 | 29490 | 27 | ||
| 77788 | 8375 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1301X Geary Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005507.71189 | 2114109.8093 | 37.7852538400076 | -122.424684163392 | (37.7852538400076, -122.424684163392) | 13 | 9 | 11 | 28858 | 41 | |||
| 78850 | 23383 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1451X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/1999 12:00:00 AM | 10 | 3X3 | 6006248.25114 | 2115440.18145 | 37.7889485091226 | -122.42221667202 | (37.7889485091226, -122.42221667202) | 13 | 9 | 1 | 28858 | 41 | ||
| 79663 | 28725 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1970 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2013 12:00:00 AM | 3 | 3x3 | 6003187.8589 | 2114511.853 | 37.7862264577302 | -122.432738867912 | (37.7862264577302, -122.432738867912) | 13 | 9 | 11 | 29490 | 27 | ||
| 96187 | 116306 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 105315 | 16721 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1040 O'Farrell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1999 12:00:00 AM | 3 | 4X4 | 6006312.05395 | 2113904.57697 | 37.784735716896 | -122.421886798179 | (37.784735716896, -122.421886798179) | 13 | 9 | 11 | 28858 | 41 | ||
| 105368 | 116227 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1699 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | 13 | 9 | 11 | 29490 | 13 | |||||
| 109025 | 105854 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3440 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2014 12:00:00 AM | 3x3 | Permit Number 771130 | 5998402.1 | 2115236.7 | 37.7879441154945 | -122.449348514051 | (37.7879441154945, -122.449348514051) | 13 | 6 | 1 | 54 | 31 | ||
| 111380 | 26653 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2324 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | 13 | 9 | 1 | 29490 | 27 | |||
| 119087 | 101070 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3018 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768630 | 5999883.5 | 2115123.7 | 37.7877184733225 | -122.444215032048 | (37.7877184733225, -122.444215032048) | 13 | 6 | 1 | 29490 | 27 | |
| 120954 | 23883 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1500X Webster St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 6X6 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.431115216253 | (37.7845850728987, -122.431115216253) | 13 | 9 | 11 | 29490 | 41 | |||
| 126461 | 83989 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1765 California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2013 12:00:00 AM | 3x4 | 6005922.82997861 | 2115889.71332947 | 37.7901644509246 | -122.423374556695 | (37.7901644509246, -122.423374556695) | 13 | 9 | 1 | 28858 | 41 | |||
| 130284 | 116305 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 131372 | 101526 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2300X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6003597.8 | 2116101.6 | 37.7906147410217 | -122.431434108251 | (37.7906147410217, -122.431434108251) | 13 | 9 | 1 | 29490 | 27 | |||
| 134560 | 101923 | Section 143 10 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1401X California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007402.7 | 2116063.9 | 37.7907261358602 | -122.418266664095 | (37.7907261358602, -122.418266664095) | 13 | 1 | 10 | 28858 | 21 | ||
| 136072 | 8432 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1655X Geary Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/22/2015 12:00:00 AM | 3 | 3X3 | 6003848.7878415 | 2113876.6611275 | 37.7845198420807 | -122.430406890022 | (37.7845198420807, -122.430406890022) | 13 | 9 | 11 | 29490 | 41 | ||
| 138293 | 116228 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1699 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | 13 | 9 | 11 | 29490 | 13 | |||||
| 153132 | 3074 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2889 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2005 12:00:00 AM | 3 | 3X3 | 6000557.1809667 | 2115144.6462063 | 37.7878143969754 | -122.441885735464 | (37.7878143969754, -122.441885735464) | 13 | 6 | 1 | 29490 | 27 | ||
| 153141 | 2901 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1675 California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2013 12:00:00 AM | 3 | 3x3 | 6006386.50176 | 2115877.66161 | 37.7901575181695 | -122.421769429319 | (37.7901575181695, -122.421769429319) | 13 | 9 | 10 | 28858 | 21 | ||
| 165559 | 18884 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2324 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1991 12:00:00 AM | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | 13 | 9 | 1 | 29490 | 27 | ||
| 172138 | 2992 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2271 California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1997 12:00:00 AM | 3 | 3X3 | 6003533.29552 | 2115470.79333 | 37.7888790501987 | -122.431612235281 | (37.7888790501987, -122.431612235281) | 13 | 9 | 1 | 29490 | 27 | ||
| 184180 | 26654 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2324 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | 13 | 9 | 1 | 29490 | 27 | |||
| 191319 | 30169 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3110 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2007 12:00:00 AM | 3 | 3x3 | 5999423.70663 | 2115059.74822 | 37.7875166362976 | -122.445801222119 | (37.7875166362976, -122.445801222119) | 13 | 6 | 1 | 29490 | 31 | ||
| 1735 | 28503 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 270 06th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/2013 12:00:00 AM | 3 | 3x3 | 6010824.2979387 | 2111653.7211901 | 37.7788088323978 | -122.406117215604 | (37.7788088323978, -122.406117215604) | 14 | 2 | 9 | 28853 | 34 | ||
| 21275 | 13852 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 989 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | |||
| 26656 | 13928 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1091 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2000 12:00:00 AM | 20 | 4X4 | 6009083.7080174 | 2112335.6900033 | 37.7805838469879 | -122.412186834853 | (37.7805838469879, -122.412186834853) | 14 | 2 | 9 | 28853 | 34 | ||
| 28382 | 28514 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 316 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6011028.87929 | 2111401.64562 | 37.778128132254 | -122.40539172749 | (37.778128132254, -122.40539172749) | 14 | 2 | 9 | 28853 | 34 | |||
| 35185 | 103088 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 256 SHIPLEY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011387 | 2111652 | 37.7788355638527 | -122.404170475964 | (37.7788355638527, -122.404170475964) | 14 | 2 | 9 | 28856 | 34 | ||||
| 37390 | 41431 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 352-360 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2005 12:00:00 AM | Permit Number 42039 | 6011197 | 2111276 | 37.7777925370097 | -122.404801285962 | (37.7777925370097, -122.404801285962) | 14 | 2 | 9 | 28853 | 34 | |||
| 43063 | 13918 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1077 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2015 08:31:00 AM | 3 | 4X4 | 6009171.9340081 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | 14 | 2 | 9 | 28853 | 34 | ||
| 46114 | 13919 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1077 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6009171.9340081 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | 14 | 2 | 9 | 28853 | 34 | |||
| 49387 | 91787 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 974 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011579.201291 | 2111277.19318 | 37.7778171686355 | -122.403479195946 | (37.7778171686355, -122.403479195946) | 14 | 2 | 9 | 28856 | 34 | |||
| 64235 | 13870 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1000 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 8 | 4x4 | 6009621.3575962 | 2112944.5572428 | 37.7822858053101 | -122.410369845025 | (37.7822858053101, -122.410369845025) | 14 | 2 | 9 | 28852 | 36 | ||
| 68947 | 13857 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 991 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 6 | 4X4 | 6009733.8299349 | 2112955.195175 | 37.7823213188284 | -122.409981490315 | (37.7823213188284, -122.409981490315) | 14 | 2 | 9 | 28853 | 34 | ||
| 72225 | 91784 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1098 HARRISON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 40 | 3x3 | 6010813 | 2110645 | 37.7760384868277 | -122.40608521627 | (37.7760384868277, -122.40608521627) | 14 | 2 | 9 | 28853 | 34 | ||
| 80899 | 13830 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 965 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 3 | 4X4 | 6009908.9307448 | 2113122.0497873 | 37.7827892741888 | -122.409387495448 | (37.7827892741888, -122.409387495448) | 14 | 2 | 9 | 28853 | 34 | ||
| 106090 | 13837 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 972 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 3 | 4x4 | 6009828.8708825 | 2113156.6502082 | 37.7828797927495 | -122.409666913005 | (37.7828797927495, -122.409666913005) | 14 | 2 | 9 | 28852 | 36 | ||
| 108184 | 28513 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 316 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6011028.87929 | 2111401.64562 | 37.778128132254 | -122.40539172749 | (37.778128132254, -122.40539172749) | 14 | 2 | 9 | 28853 | 34 | |||
| 119588 | 28369 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 352-360 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 3 | 3X3 | 6011197 | 2111276 | 37.7777925370097 | -122.404801285962 | (37.7777925370097, -122.404801285962) | 14 | 2 | 9 | 28853 | 34 | ||
| 125402 | 13924 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1083 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2004 12:00:00 AM | 16 | 4X4 | 6009134.0341107 | 2112383.6460599 | 37.7807183466268 | -122.41201612229 | (37.7807183466268, -122.41201612229) | 14 | 2 | 9 | 28853 | 34 | ||
| 144167 | 13793 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 929 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2016 06:56:00 AM | 3 | 4X4 | 6010115.5056 | 2113327.9166 | 37.7833661076198 | -122.408687358048 | (37.7833661076198, -122.408687358048) | 14 | 2 | 9 | 28853 | 34 | ||
| 147819 | 13927 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1091 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/2015 07:43:00 AM | 3 | 4x4 | 6009083.7080174 | 2112335.6900033 | 37.7805838469879 | -122.412186834853 | (37.7805838469879, -122.412186834853) | 14 | 2 | 9 | 28853 | 34 | ||
| 151384 | 13923 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1081 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/1997 12:00:00 AM | 20 | 4X4 | 6009147.0816163 | 2112396.0791116 | 37.7807532168626 | -122.411971863376 | (37.7807532168626, -122.411971863376) | 14 | 2 | 9 | 28853 | 34 | ||
| 155322 | 13906 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1063 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2016 11:38:00 AM | 3 | 4x4 | 6009266.7492 | 2112493.5891 | 37.7810276692866 | -122.411564765047 | (37.7810276692866, -122.411564765047) | 14 | 2 | 9 | 28853 | 34 | ||
| 160935 | 91785 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1020 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011200.069593 | 2110914.857315 | 37.7768010945018 | -122.404765235736 | (37.7768010945018, -122.404765235736) | 14 | 2 | 9 | 28853 | 34 | |||
| 166567 | 13851 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 989 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2004 12:00:00 AM | 6 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | ||
| 171182 | 13925 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1083 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/15/2006 12:00:00 AM | 6 | 4X4 | 6009134.0341107 | 2112383.6460599 | 37.7807183466268 | -122.41201612229 | (37.7807183466268, -122.41201612229) | 14 | 2 | 9 | 28853 | 34 | ||
| 181552 | 91786 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 966 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2010 12:00:00 AM | 3 | 3x3 | 6011627.673411 | 2111323.517939 | 37.7779470730221 | -122.403314772772 | (37.7779470730221, -122.403314772772) | 14 | 2 | 9 | 28856 | 34 | |||
| 23054 | 104167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
| 27210 | 111374 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
| 29927 | 5259 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1221 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X3 | 6001282.65173 | 2112621.17829 | 37.7809269126295 | -122.439194811296 | (37.7809269126295, -122.439194811296) | 15 | 5 | 11 | 29490 | 41 | |||
| 31354 | 5288 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 01/01/2010 12:00:00 AM | 3 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||
| 37348 | 116701 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||||
| 39100 | 92566 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 |
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) );