trees
439 rows where qSpecies_id = 148 sorted by Zip Codes
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 | |||||||||||
| 2426 | 100409 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
| 21517 | 27259 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 690 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
| 32018 | 14183 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1844 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2012 12:00:00 AM | 12 | 4X4 | Permit Number 769087 | 6005554.6579568 | 2109080.5883488 | 37.7714474783148 | -122.424163948162 | (37.7714474783148, -122.424163948162) | 7 | 2 | 5 | 28852 | 10 | |
| 32661 | 100407 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
| 32839 | 91205 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
| 33990 | 91343 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
| 35496 | 27675 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
| 39073 | 27258 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 690 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
| 39543 | 70859 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1995 12:00:00 AM | Permit Number 767727 | 6006431.93006457 | 2110802.5343302 | 37.7762250224845 | -122.421251711265 | (37.7762250224845, -122.421251711265) | 7 | 9 | 11 | 28852 | 10 | |||
| 51107 | 91344 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
| 54616 | 13948 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1112X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/1994 12:00:00 AM | 12 | 4x4 | 6008868.4803223 | 2112239.1730786 | 37.7803067555436 | -122.412924586563 | (37.7803067555436, -122.412924586563) | 7 | 2 | 9 | 28852 | 36 | ||
| 58660 | 13940 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1140X Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6008690.2869843 | 2112068.9420038 | 37.7798293375501 | -122.413528998881 | (37.7798293375501, -122.413528998881) | 7 | 2 | 9 | 28852 | 36 | |||
| 58809 | 14170 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1776X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2015 10:09:00 AM | 3 | 4x4 | 6005777.896097 | 2109293.199395 | 37.7720438591777 | -122.423406872271 | (37.7720438591777, -122.423406872271) | 7 | 2 | 11 | 28852 | 10 | ||
| 59418 | 27255 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 620X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.420326195624 | (37.7813170997428, -122.420326195624) | 7 | 9 | 9 | 28852 | 36 | |||
| 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 | ||
| 75983 | 91335 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
| 77944 | 27674 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
| 81270 | 22592 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 785X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/14/2002 12:00:00 AM | 3 | 4X4 | 6006155.3095005 | 2112777.9901286 | 37.7816335448796 | -122.422349009875 | (37.7816335448796, -122.422349009875) | 7 | 9 | 11 | 28852 | 41 | ||
| 84052 | 13946 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1108 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/08/1999 12:00:00 AM | 12 | 4x4 | 6008893.4024674 | 2112262.9816205 | 37.7803735270406 | -122.412840052753 | (37.7803735270406, -122.412840052753) | 7 | 2 | 9 | 28852 | 36 | ||
| 87123 | 91336 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
| 87629 | 27679 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
| 93141 | 23203 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 590 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1999 12:00:00 AM | 8 | 3x3 | 6006785.52098 | 2112480.30357 | 37.7808516993941 | -122.420147639969 | (37.7808516993941, -122.420147639969) | 7 | 9 | 9 | 28852 | 36 | ||
| 93447 | 27256 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 660X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
| 100838 | 14187 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1844 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2012 12:00:00 AM | 18 | 4X4 | Permit Number 769087 | 6005518.4692831 | 2109046.2188948 | 37.7713510647017 | -122.424286681889 | (37.7713510647017, -122.424286681889) | 7 | 2 | 5 | 28852 | 10 | |
| 105085 | 91204 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | ||
| 122483 | 14626 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 410X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/05/2001 12:00:00 AM | 20 | 3X3 | 6007165.24508 | 2112272.29684 | 37.7803019512551 | -122.418819229453 | (37.7803019512551, -122.418819229453) | 7 | 9 | 9 | 28852 | 36 | ||
| 126355 | 27676 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
| 127174 | 27257 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 660X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/2004 12:00:00 AM | 3 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | ||
| 138619 | 100408 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
| 139425 | 27252 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 620X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.420326195624 | (37.7813170997428, -122.420326195624) | 7 | 9 | 9 | 28852 | 36 | |||
| 149234 | 27678 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
| 155330 | 14031 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1244 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 3 | 4x4 | 6008141.7716697 | 2111544.9362715 | 37.7783597285455 | -122.415389454094 | (37.7783597285455, -122.415389454094) | 7 | 2 | 9 | 28852 | 36 | ||
| 159666 | 27254 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 620X Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.420326195624 | (37.7813170997428, -122.420326195624) | 7 | 9 | 9 | 28852 | 36 | |||
| 162970 | 14117 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1572X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 12:52:00 PM | 3 | 4x4 | 6006735.3160639 | 2110201.3257307 | 37.7745913473524 | -122.420159536302 | (37.7745913473524, -122.420159536302) | 7 | 2 | 11 | 28852 | 10 | ||
| 163970 | 27677 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
| 177115 | 27253 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 620X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.420326195624 | (37.7813170997428, -122.420326195624) | 7 | 9 | 9 | 28852 | 36 | |||
| 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 | ||
| 7309 | 14032 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1245 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2012 12:00:00 AM | 3 | 4X4 | 6008153.5614441 | 2111445.1787375 | 37.7780864807987 | -122.415341604846 | (37.7780864807987, -122.415341604846) | 8 | 2 | 9 | 28853 | 34 | ||
| 9094 | 91830 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1849 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008677.188747 | 2107760.243317 | 37.7679979296822 | -122.413269533592 | (37.7679979296822, -122.413269533592) | 8 | 4 | 7 | 28853 | 19 | ||
| 9871 | 91779 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1184 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010158.993686 | 2109919.902048 | 37.7740109351691 | -122.408296453122 | (37.7740109351691, -122.408296453122) | 8 | 2 | 9 | 28853 | 34 | ||
| 20292 | 41297 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 135 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2000 12:00:00 AM | 18 | Permit Number 41974 | 6006066.97178257 | 2108901.70025465 | 37.770985207585 | -122.422379113504 | (37.770985207585, -122.422379113504) | 8 | 2 | 9 | 28853 | 19 | ||
| 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 | |||
| 23271 | 91828 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1941 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.413129591178 | (37.7664314036014, -122.413129591178) | 8 | 4 | 7 | 28853 | 19 | ||
| 23858 | 85447 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 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 | ||
| 28286 | 26876 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2014 12:00:00 AM | 20 | 3X3 | Permit Number 771536 | 6006101 | 2108089 | 37.7687556461675 | -122.422203660432 | (37.7687556461675, -122.422203660432) | 8 | 4 | 7 | 28853 | 19 | |
| 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 | |||
| 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 | ||
| 43112 | 26878 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | Permit Number 771536 | 6006101 | 2108089 | 37.7687556461675 | -122.422203660432 | (37.7687556461675, -122.422203660432) | 8 | 4 | 7 | 28853 | 19 | ||
| 44768 | 85446 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 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 | |||
| 46154 | 14094 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1455 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2004 12:00:00 AM | 3 | 4X4 | 6007204.2526311 | 2110536.5858952 | 37.7755383026332 | -122.418561167244 | (37.7755383026332, -122.418561167244) | 8 | 2 | 9 | 28853 | 34 | ||
| 61145 | 97531 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 66289 | 97530 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 66342 | 14084 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1411 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | 4X4 | Permit Number 775519 | 6007340.8551319 | 2110667.3761307 | 37.7759051108463 | -122.418097899429 | (37.7759051108463, -122.418097899429) | 8 | 2 | 9 | 28853 | 34 | |
| 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 | ||
| 71851 | 97533 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 72192 | 85433 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y1 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 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 | ||
| 72523 | 14128 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1621 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2017 09:15:00 AM | 3 | 4X4 | 6006600.23891 | 2109952.28073 | 37.7738999176888 | -122.420609113022 | (37.7738999176888, -122.420609113022) | 8 | 2 | 9 | 28853 | 19 | ||
| 74286 | 91838 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1617 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008750.352862 | 2108461.38548 | 37.7699272102311 | -122.413066048552 | (37.7699272102311, -122.413066048552) | 8 | 2 | 9 | 28853 | 19 | ||
| 76766 | 85437 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y4 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 79095 | 85444 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y10 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 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 | ||
| 81477 | 86693 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1355 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2007 12:00:00 AM | Permit Number 49693 | 6007704.191622 | 2111021.854521 | 37.7768988673684 | -122.416866141309 | (37.7768988673684, -122.416866141309) | 8 | 2 | 9 | 28853 | 34 | |||
| 81731 | 14123 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1615 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2014 02:16:00 PM | 3 | 4X4 | 6006597.57832 | 2109978.9478798 | 37.7739729893435 | -122.420620209869 | (37.7739729893435, -122.420620209869) | 8 | 2 | 9 | 28853 | 19 | ||
| 87721 | 103745 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1999X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008051.81901 | 2107091.22594 | 37.7661258341797 | -122.415385257212 | (37.7661258341797, -122.415385257212) | 8 | 4 | 7 | 28853 | 19 | ||
| 93711 | 26877 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 771536 | 6006101 | 2108089 | 37.7687556461675 | -122.422203660432 | (37.7687556461675, -122.422203660432) | 8 | 4 | 7 | 28853 | 19 | ||
| 94031 | 85448 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y14 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 96901 | 85439 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y5 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 98088 | 97532 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 100369 | 91768 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008825.910209 | 2108635.634966 | 37.7704098999414 | -122.412817017344 | (37.7704098999414, -122.412817017344) | 8 | 2 | 9 | 28853 | 19 | ||
| 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 | |||
| 109129 | 85445 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y11 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 111192 | 85440 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y6 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 113755 | 85435 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y3 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/07/2006 12:00:00 AM | 3 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 116463 | 85443 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y9 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | |||
| 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 | ||
| 121371 | 91780 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010733.753804 | 2110469.199819 | 37.7755513476177 | -122.406346961489 | (37.7755513476177, -122.406346961489) | 8 | 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 | ||
| 126905 | 243200 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 220 Valencia St | 1 | : | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781817 | 6006037.36793 | 2108352.33176 | 37.7694751030168 | -122.422442472745 | (37.7694751030168, -122.422442472745) | 8 | 4 | 5 | 28853 | 19 | |
| 127139 | 13954 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1117 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/23/2015 07:44:00 AM | 3 | 4X4 | 6008897.3784125 | 2112157.6718266 | 37.7800845945909 | -122.412818850612 | (37.7800845945909, -122.412818850612) | 8 | 2 | 9 | 28853 | 34 | ||
| 127325 | 97529 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 128801 | 106964 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771536 | 6006216.68747 | 2108092.23656 | 37.7687710576512 | -122.421803735394 | (37.7687710576512, -122.421803735394) | 8 | 4 | 7 | 28853 | 19 | ||||
| 134144 | 91769 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1532 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008825.910209 | 2108635.634966 | 37.7704098999414 | -122.412817017344 | (37.7704098999414, -122.412817017344) | 8 | 2 | 9 | 28853 | 19 | ||
| 137191 | 91839 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1351 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009423.082164 | 2109161.631862 | 37.7718876659968 | -122.410788543549 | (37.7718876659968, -122.410788543549) | 8 | 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 | ||
| 146536 | 91829 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1941 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.413129591178 | (37.7664314036014, -122.413129591178) | 8 | 4 | 7 | 28853 | 19 | ||
| 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 | ||
| 151859 | 14083 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1411 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2004 12:00:00 AM | 3 | 4X4 | 6007365.6919502 | 2110691.1561735 | 37.7759718030505 | -122.418013668426 | (37.7759718030505, -122.418013668426) | 8 | 2 | 9 | 28853 | 34 | ||
| 152930 | 91827 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1941 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.413129591178 | (37.7664314036014, -122.413129591178) | 8 | 4 | 7 | 28853 | 19 | ||
| 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 | ||
| 157553 | 91836 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1617 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008750.352862 | 2108461.38548 | 37.7699272102311 | -122.413066048552 | (37.7699272102311, -122.413066048552) | 8 | 2 | 9 | 28853 | 19 | ||
| 158568 | 91781 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010733 | 2110469 | 37.7755507567936 | -122.40634955501 | (37.7755507567936, -122.40634955501) | 8 | 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 | |||
| 165300 | 85441 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y7 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 |
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) );