trees
439 rows where qSpecies_id = 148 sorted by DBH descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
866 | 28332 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3247 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 9 | 3x3 | 6006498.83651 | 2099346.51324 | 37.74477323292 | -122.420207017141 | (37.74477323292, -122.420207017141) | 2 | 7 | 7 | 28859 | 2 | ||
28859 | 91843 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 9 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
38534 | 91845 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 9 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
114348 | 23005 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 766 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1997 12:00:00 AM | 8 | 3X3 | 6006192.39683 | 2105141.54299 | 37.7606677795421 | -122.421678150262 | (37.7606677795421, -122.421678150262) | 2 | 4 | 5 | 28859 | 19 | ||
115901 | 91849 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 8 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
124837 | 122515 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x6 | 6006189 | 2105199 | 37.7608253514989 | -122.421693979475 | (37.7608253514989, -122.421693979475) | 2 | 4 | 5 | 28859 | 19 | |||
128877 | 122821 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 777 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6006304 | 2105101 | 37.7605627505881 | -122.421289285481 | (37.7605627505881, -122.421289285481) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
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 | |||
29692 | 91848 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 7 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
53109 | 91850 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 7 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
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 | |||
97984 | 122513 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 721 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006289 | 2105371 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | 2 | 4 | 7 | 28859 | 19 | |||
153578 | 117959 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 851X HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012435 | 2111995 | 37.7798358648386 | -122.400569108585 | (37.7798358648386, -122.400569108585) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
9581 | 28011 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014191.95801 | 2117739.78401 | 37.795707543335 | -122.394893427962 | (37.795707543335, -122.394893427962) | 4 | 2 | 10 | 28860 | 6 | ||
11651 | 28006 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014086.70601 | 2117927.50101 | 37.7962171170916 | -122.395270777766 | (37.7962171170916, -122.395270777766) | 3 | 2 | 10 | 28860 | 6 | ||
15454 | 28326 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3284 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006311.45985 | 2099177.31377 | 37.7442980895932 | -122.420842920924 | (37.7442980895932, -122.420842920924) | 2 | 7 | 7 | 28859 | 2 | ||
20337 | 28014 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014226.68001 | 2117656.23301 | 37.7954800625202 | -122.394767428538 | (37.7954800625202, -122.394767428538) | 4 | 2 | 10 | 28860 | 6 | ||
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 | ||
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 | |||
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 | ||
31583 | 91851 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
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 | ||
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 | ||
36837 | 117955 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | |||
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 | ||
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 | ||
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 | ||
65056 | 28016 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014245.12601 | 2117603.06501 | 37.7953351012525 | -122.394699876607 | (37.7953351012525, -122.394699876607) | 4 | 2 | 10 | 28860 | 6 | ||
65902 | 28017 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014258.14701 | 2117577.02301 | 37.7952643199629 | -122.394652996927 | (37.7952643199629, -122.394652996927) | 4 | 2 | 10 | 28860 | 6 | ||
68393 | 117958 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 851X HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012435 | 2111995 | 37.7798358648386 | -122.400569108585 | (37.7798358648386, -122.400569108585) | 6 | 2 | 9 | 28856 | 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 | ||
72171 | 5231 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1053 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | 6 | 3X3 | 6001315.02339 | 2112044.91566 | 37.7793464837663 | -122.439041510199 | (37.7793464837663, -122.439041510199) | 15 | 5 | 11 | 29490 | 41 | ||
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 | ||
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 | ||
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 | ||
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 | ||
89848 | 28013 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014214.74401 | 2117682.27501 | 37.7955509040886 | -122.394810554146 | (37.7955509040886, -122.394810554146) | 4 | 2 | 10 | 28860 | 6 | ||
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 | ||
97976 | 13567 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 484X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 6 | 4x4 | 6012939.9788554 | 2116125.819916 | 37.791206285852 | -122.399112186297 | (37.791206285852, -122.399112186297) | 4 | 2 | 10 | 28860 | 6 | ||
108085 | 28010 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014178.93701 | 2117764.74001 | 37.7957753426227 | -122.394940232051 | (37.7957753426227, -122.394940232051) | 4 | 1 | 10 | 28860 | 6 | ||
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 | ||
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 | |||
113760 | 28019 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014278.76301 | 2117533.62001 | 37.7951462916621 | -122.394578620953 | (37.7951462916621, -122.394578620953) | 4 | 2 | 10 | 28860 | 6 | ||
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 | |||
117657 | 28012 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014204.97801 | 2117711.57201 | 37.7956308037617 | -122.394846399273 | (37.7956308037617, -122.394846399273) | 4 | 2 | 10 | 28860 | 6 | ||
119843 | 28004 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014041.13301 | 2117989.35001 | 37.7963844052449 | -122.39543280592 | (37.7963844052449, -122.39543280592) | 3 | 2 | 10 | 28860 | 6 | ||
121480 | 91847 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
127194 | 91844 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
127442 | 5837 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 850X Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2015 12:00:00 AM | 6 | 3x3 | 6006360.7801 | 2113218.82973 | 37.7828555709323 | -122.421669498691 | (37.7828555709323, -122.421669498691) | 7 | 9 | 11 | 28858 | 41 | ||
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 | |||
131734 | 91846 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
136264 | 28008 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3x3 | 6014135.53401 | 2117846.12001 | 37.7959963794451 | -122.395096118536 | (37.7959963794451, -122.395096118536) | 3 | 2 | 10 | 28860 | 6 | ||
139774 | 28337 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3209 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006571.86084 | 2099543.08303 | 37.7453170836103 | -122.419968459003 | (37.7453170836103, -122.419968459003) | 2 | 7 | 7 | 28859 | 2 | ||
148304 | 28020 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014303.72001 | 2117502.15301 | 37.795061278092 | -122.394490060779 | (37.795061278092, -122.394490060779) | 4 | 2 | 10 | 28860 | 6 | ||
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 | ||
153960 | 28018 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014268.99801 | 2117554.23701 | 37.7952023582244 | -122.394613854051 | (37.7952023582244, -122.394613854051) | 4 | 2 | 10 | 28860 | 6 | ||
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 | |||
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 | ||
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 | ||
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 | ||
168910 | 28005 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014065.00401 | 2117953.54201 | 37.796287412573 | -122.395347696851 | (37.796287412573, -122.395347696851) | 3 | 2 | 10 | 28860 | 6 | ||
170510 | 85434 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y2 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/23/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
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 | ||
175372 | 85442 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y8 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 | ||
177314 | 28007 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014117.08801 | 2117880.84301 | 37.7960906948417 | -122.395162379187 | (37.7960906948417, -122.395162379187) | 3 | 2 | 10 | 28860 | 6 | ||
181478 | 28009 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014164.83101 | 2117791.86701 | 37.7958490426136 | -122.394990942689 | (37.7958490426136, -122.394990942689) | 4 | 1 | 10 | 28860 | 6 | ||
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 | |||
188165 | 28015 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014236.44501 | 2117630.19201 | 37.7954091029766 | -122.39473181516 | (37.7954091029766, -122.39473181516) | 4 | 2 | 10 | 28860 | 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 | ||
53422 | 84564 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
67522 | 5221 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1009X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2005 12:00:00 AM | 5 | 3X3 | 6001407.0548 | 2111843.67263 | 37.7787991574032 | -122.438708711528 | (37.7787991574032, -122.438708711528) | 15 | 5 | 11 | 29490 | 41 | ||
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 | |||
79199 | 84561 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1095X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) | 2 | 4 | 5 | 28862 | 22 |
95087 | 84562 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
98801 | 84560 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1095X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) | 2 | 4 | 5 | 28862 | 22 |
111204 | 102122 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
131308 | 102123 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
135140 | 84557 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1111X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.7515016484692 | -122.429618577466 | (37.7515016484692, -122.429618577466) | 2 | 4 | 5 | 28862 | 22 |
166295 | 102121 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
168283 | 84563 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
180891 | 84558 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1111X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.7515016484692 | -122.429618577466 | (37.7515016484692, -122.429618577466) | 2 | 4 | 5 | 28862 | 22 |
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 | |||
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 | |||
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 | |||
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 |
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) );