trees
439 rows where qSpecies_id = 148 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2658 | 91806 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2945 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009025.873084 | 2101313.36822 | 37.7503158463726 | -122.411607913685 | (37.7503158463726, -122.411607913685) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
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 | ||
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 | ||
19974 | 28151 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
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 | |||
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 | |||
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 | |||
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 | ||
24063 | 91815 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2601 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008917.295639 | 2103308.711999 | 37.755788521075 | -122.412124384346 | (37.755788521075, -122.412124384346) | 2 | 4 | 7 | 28859 | 19 | ||
26282 | 2872 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1408 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 6007572.07583 | 2116196.88046 | 37.7911008000132 | -122.417690060515 | (37.7911008000132, -122.417690060515) | 5 | 1 | 10 | 28858 | 21 | ||
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 | ||
26852 | 23014 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 790 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006206.16059 | 2105091.96533 | 37.7605324270074 | -122.421627026238 | (37.7605324270074, -122.421627026238) | 2 | 4 | 5 | 28859 | 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 | |||
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 | |||
31330 | 28335 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3221 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006572.11195 | 2099482.47917 | 37.7451506932372 | -122.419963290861 | (37.7451506932372, -122.419963290861) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |
34463 | 28181 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
34558 | 28331 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3281 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006413.77303 | 2099188.67497 | 37.7443350512574 | -122.420489949359 | (37.7443350512574, -122.420489949359) | 2 | 7 | 7 | 28859 | 2 | ||
35228 | 28154 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
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 | |||
36646 | 14315 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/22/2000 12:00:00 AM | 6 | 4X4 | 6003585.7913445 | 2107202.1800302 | 37.7661784627239 | -122.430840279858 | (37.7661784627239, -122.430840279858) | 7 | 4 | 5 | 28862 | 3 | ||
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 | ||
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 | |||
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 | |||
39391 | 28180 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
39483 | 28169 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
39865 | 26270 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 16 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2015 10:26:00 AM | 3 | 3X3 | 6006157.7043564 | 2098703.0541301 | 37.7429872120583 | -122.42134090318 | (37.7429872120583, -122.42134090318) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
42186 | 15613 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3435 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2004 12:00:00 AM | 6 | 3x3 | 6005895.33669 | 2098270.89959 | 37.7417858175205 | -122.422217403662 | (37.7417858175205, -122.422217403662) | 2 | 7 | 7 | 28859 | 2 | ||
42580 | 28156 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
42673 | 28160 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
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 | ||
43287 | 91814 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2621 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008916 | 2103203 | 37.7554981871043 | -122.412121394411 | (37.7554981871043, -122.412121394411) | 2 | 4 | 7 | 28859 | 19 | ||
43351 | 28363 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3469 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6005899.78718 | 2098063.61718 | 37.7412169177624 | -122.422187292293 | (37.7412169177624, -122.422187292293) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
44088 | 28340 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007038.71469 | 2100348.34949 | 37.7475544551381 | -122.418411239379 | (37.7475544551381, -122.418411239379) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
45913 | 28158 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
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 | ||
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 | |||
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 | |
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 | ||
55209 | 28153 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
55995 | 28163 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
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 | ||
57956 | 122512 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 721 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006289 | 2105371 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
60140 | 28161 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
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 | |
61354 | 24389 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3641 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6005406.19827 | 2096949.60563 | 37.7381302401684 | -122.423814755555 | (37.7381302401684, -122.423814755555) | 2 | 7 | 7 | 28859 | 2 | ||
62166 | 28334 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3241 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2005 12:00:00 AM | 9 | 3X3 | 6006567.49057 | 2099355.80784 | 37.7448026219753 | -122.419970283481 | (37.7448026219753, -122.419970283481) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
64239 | 28155 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
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 | |
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 | ||
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 | ||
69655 | 122511 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 715 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x6 | 6006287 | 2105397 | 37.7613745389022 | -122.421369101713 | (37.7613745389022, -122.421369101713) | 2 | 4 | 7 | 28859 | 19 | |||
70694 | 23003 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 740X Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1994 12:00:00 AM | 8 | 3X3 | 6006197 | 2105252 | 37.7609713282095 | -122.421670075458 | (37.7609713282095, -122.421670075458) | 2 | 4 | 5 | 28859 | 19 | ||
71285 | 28167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
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 | ||
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 | ||
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 | ||
75312 | 28323 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3100 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 11 | 4x4 | 6007076.90394 | 2100561.83623 | 37.7481427912413 | -122.418294317161 | (37.7481427912413, -122.418294317161) | 2 | 4 | 7 | 28859 | 2 | ||
76312 | 91803 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2989 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009039.569733 | 2101067.518808 | 37.7496415669707 | -122.411543181878 | (37.7496415669707, -122.411543181878) | 2 | 4 | 7 | 28859 | 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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
81977 | 15597 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3281 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2013 12:00:00 AM | 9 | 3X3 | 6006413.8 | 2099188.7 | 37.7443351215041 | -122.420489857879 | (37.7443351215041, -122.420489857879) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
83783 | 95165 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100 Divisadero St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2014 12:00:00 AM | 3 | 3x3 | 6001410.7267 | 2112361.1413 | 37.7802202041401 | -122.438733098992 | (37.7802202041401, -122.438733098992) | 15 | 5 | 11 | 29490 | 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 | ||
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 | |||
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 | ||
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 | ||
91070 | 91801 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3071 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009060.650721 | 2100687.104692 | 37.7485982168729 | -122.4114434106 | (37.7485982168729, -122.4114434106) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
92897 | 121027 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
93294 | 13520 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 388 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6013190.8445953 | 2116364.9078359 | 37.7918767419323 | -122.3982609742 | (37.7918767419323, -122.3982609742) | 4 | 2 | 10 | 28860 | 6 | |||
93430 | 91821 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2395x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008850.144084 | 2104529.130727 | 37.7591357459563 | -122.412442878611 | (37.7591357459563, -122.412442878611) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | ||
96005 | 28164 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
96202 | 28166 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
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 |
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) );