trees
2,421 rows where qSpecies_id = 8 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1153 | 223389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
123439 | 123775 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 999 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992633.47404 | 2110664.48077 | 37.7750583885988 | -122.468973869259 | (37.7750583885988, -122.468973869259) | 11 | 6 | 2 | 54 | 11 | |||
145589 | 123776 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 999 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992611.69228 | 2110664.0229 | 37.7750558729015 | -122.469049183134 | (37.7750558729015, -122.469049183134) | 11 | 6 | 2 | 54 | 11 | |||
15380 | 74967 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012084.12824 | 2119041.91729 | 37.7991654604723 | -122.402278540244 | (37.7991654604723, -122.402278540244) | 3 | 1 | 10 | 28860 | 6 | ||
45466 | 74829 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | 3 | 1 | 10 | 28860 | 6 | ||
11823 | 223370 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Lapidge St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006029.2284 | 2104988.85011 | 37.7602393183104 | -122.422231628499 | (37.7602393183104, -122.422231628499) | 2 | 4 | 5 | 28859 | 19 | |||
32114 | 123721 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995382.67333 | 2111440.05096 | 37.7773463562681 | -122.459520034239 | (37.7773463562681, -122.459520034239) | 11 | 6 | 2 | 54 | 11 | |||
12861 | 253706 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
18342 | 253705 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
186859 | 236267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 775137 | 6007694.337 | 2107447.14933 | 37.7670830178903 | -122.41664693662 | (37.7670830178903, -122.41664693662) | 8 | 4 | 7 | 28853 | 19 | |
31050 | 162895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 989 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:58:00 AM | 3 | Width 0ft | 5995899.78819 | 2090467.68802 | 37.7197912084714 | -122.45621444284 | (37.7197912084714, -122.45621444284) | 9 | 8 | 6 | 28861 | 24 | ||
139495 | 162893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 989 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:55:00 AM | 3 | Width 0ft | 5995900.91597 | 2090507.14729 | 37.7198996190417 | -122.456213396033 | (37.7198996190417, -122.456213396033) | 9 | 8 | 6 | 28861 | 24 | ||
125149 | 223518 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 988 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999648.8119 | 2101706.51559 | 37.7508648743372 | -122.444062558736 | (37.7508648743372, -122.444062558736) | 2 | 5 | 5 | 63 | 38 | |||
141956 | 84009 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 980 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50690 | 6011658.3598 | 2090351.5567 | 37.7203643356392 | -122.401734134722 | (37.7203643356392, -122.401734134722) | 10 | 7 | 8 | 309 | 28 | |
114458 | 88149 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 980 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51177 | 5999654.9 | 2101769.7 | 37.7510387106784 | -122.444046045087 | (37.7510387106784, -122.444046045087) | 2 | 5 | 5 | 63 | 38 | ||
157791 | 223517 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 980 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999663.10864 | 2101754.10727 | 37.7509963650963 | -122.44401653863 | (37.7509963650963, -122.44401653863) | 2 | 5 | 5 | 63 | 38 | |||
46394 | 66647 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 972 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/2000 12:00:00 AM | Permit Number 29858 | 6010191.86940681 | 2103559.76448884 | 37.756549288119 | -122.407734178809 | (37.756549288119, -122.407734178809) | 2 | 4 | 7 | 28859 | 19 | ||
111005 | 223411 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 972 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010196.15825 | 2103568.84012 | 37.7565744478629 | -122.407719986296 | (37.7565744478629, -122.407719986296) | 2 | 4 | 7 | 28859 | 19 | |||
141755 | 223470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 972 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5998837.19654 | 2106602.69587 | 37.7642622385282 | -122.447221529965 | (37.7642622385282, -122.447221529965) | 15 | 5 | 11 | 29492 | 9 | |||
24915 | 207606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995896.38015 | 2090348.10443 | 37.7194626645441 | -122.456217581487 | (37.7194626645441, -122.456217581487) | 9 | 8 | 6 | 28861 | 24 | |||
136449 | 65460 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28338 | 5995896.95851716 | 2090334.96533864 | 37.7194266209016 | -122.45621463281 | (37.7194266209016, -122.45621463281) | 9 | 8 | 6 | 28861 | 24 | ||
156569 | 26634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 959X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1998 12:00:00 AM | 3 | 3x3 | 6010948.2451591 | 2094911.3215655 | 37.7328448487082 | -122.404509586514 | (37.7328448487082, -122.404509586514) | 10 | 3 | 8 | 58 | 1 | ||
131108 | 223471 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 956 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5998814.74018 | 2106663.16945 | 37.764427000625 | -122.447303552626 | (37.764427000625, -122.447303552626) | 15 | 5 | 11 | 29492 | 9 | |||
8480 | 72470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012030.25538 | 2119045.53422 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | 3 | 1 | 10 | 308 | 23 | |||
33909 | 71627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 5 | 6012042.50926 | 2118962.60831 | 37.7989453738906 | -122.402416977385 | (37.7989453738906, -122.402416977385) | 3 | 1 | 10 | 308 | 23 | ||
45874 | 126550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012056.66231 | 2118852.08433 | 37.7986426917617 | -122.402360227452 | (37.7986426917617, -122.402360227452) | 3 | 1 | 10 | 308 | 23 | |||
47502 | 126551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012059.41755 | 2118828.15816 | 37.7985771500692 | -122.402349010193 | (37.7985771500692, -122.402349010193) | 3 | 1 | 10 | 308 | 23 | |||
52362 | 124532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992651.91776 | 2111347.60988 | 37.7769351421706 | -122.468959793565 | (37.7769351421706, -122.468959793565) | 11 | 6 | 2 | 54 | 11 | |||
77104 | 124533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992637.18811 | 2111348.18178 | 37.7769358614128 | -122.469010789113 | (37.7769358614128, -122.469010789113) | 11 | 6 | 2 | 54 | 11 | |||
78978 | 124534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992622.68332 | 2111346.91424 | 37.7769315430211 | -122.469060872907 | (37.7769315430211, -122.469060872907) | 11 | 6 | 2 | 54 | 11 | |||
91649 | 124536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992595.02758 | 2111346.18567 | 37.7769279445894 | -122.469156488684 | (37.7769279445894, -122.469156488684) | 11 | 6 | 2 | 54 | 11 | |||
158538 | 124535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992606.88484 | 2111346.72253 | 37.7769301037952 | -122.469115510242 | (37.7769301037952, -122.469115510242) | 11 | 6 | 2 | 54 | 11 | |||
90949 | 90551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992711.740359 | 2110715.879967 | 37.7752040386212 | -122.46870687216 | (37.7752040386212, -122.46870687216) | 11 | 6 | 2 | 54 | 11 | ||
153986 | 123783 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992630.21461 | 2110720.88883 | 37.7752130815921 | -122.468989250215 | (37.7752130815921, -122.468989250215) | 11 | 6 | 2 | 54 | 11 | |||
8533 | 71618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012375.88529 | 2119419.34267 | 37.8002180611838 | -122.401295492211 | (37.8002180611838, -122.401295492211) | 3 | 1 | 10 | 28860 | 6 | |||
53101 | 34891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
181410 | 34892 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
50780 | 176252 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010107.1247 | 2089599.03617 | 37.7182113811213 | -122.407043259958 | (37.7182113811213, -122.407043259958) | 10 | 7 | 8 | 309 | 39 | |||
162560 | 176253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010117.92765 | 2089629.2495 | 37.7182949452416 | -122.407008046982 | (37.7182949452416, -122.407008046982) | 10 | 7 | 8 | 309 | 39 | |||
10976 | 262163 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
30640 | 38839 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 947 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40668 | 5992575.8845778 | 2114792.63949005 | 37.7863898589993 | -122.469473646902 | (37.7863898589993, -122.469473646902) | 11 | 6 | 2 | 54 | 11 | ||
192513 | 85040 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 946 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | Permit Number 49388 | 5995963.8 | 2090215.2 | 37.7191016102225 | -122.455974934213 | (37.7191016102225, -122.455974934213) | 9 | 8 | 6 | 28861 | 24 | |||
32996 | 90901 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 945X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992730.980543 | 2110676.551916 | 37.7750971658671 | -122.468637454404 | (37.7750971658671, -122.468637454404) | 11 | 6 | 2 | 54 | 11 | ||
98554 | 90902 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 945X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992730.980543 | 2110676.551916 | 37.7750971658671 | -122.468637454404 | (37.7750971658671, -122.468637454404) | 11 | 6 | 2 | 54 | 11 | ||
40084 | 223469 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 945 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998759.82917 | 2106683.9118 | 37.7644808160601 | -122.447494967025 | (37.7644808160601, -122.447494967025) | 15 | 5 | 11 | 29492 | 9 | |||
73987 | 14750 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 940 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2000 12:00:00 AM | 3 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | ||
181009 | 216746 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 935 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:04:00 AM | 3 | Width 3ft | 5995893.72973 | 2090148.9347 | 37.7189156393246 | -122.456212350117 | (37.7189156393246, -122.456212350117) | 9 | 8 | 6 | 28861 | 24 | ||
39722 | 223593 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 930 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009378.63549 | 2103724.24958 | 37.756955368323 | -122.41055825836 | (37.756955368323, -122.41055825836) | 2 | 4 | 7 | 28859 | 19 | |||
8512 | 117149 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.15518 | 2097982.19203 | 37.7413315821976 | -122.401334038935 | (37.7413315821976, -122.401334038935) | 10 | 3 | 8 | 58 | 1 | |
8525 | 117146 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | 10 | 3 | 8 | 58 | 1 | |
10674 | 117147 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978 | (37.7414998183769, -122.40118925978) | 10 | 3 | 8 | 58 | 1 | |
18014 | 117148 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011961.8463 | 2098027.63913 | 37.7414581941431 | -122.401224196662 | (37.7414581941431, -122.401224196662) | 10 | 3 | 8 | 58 | 1 | |
132994 | 117150 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 TOLAND ST | 5 | Front Yard : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950 | 2098029 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | 10 | 3 | 8 | 58 | 1 | |
9989 | 176265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004683.74002 | 2091261.8142 | 37.7224720200432 | -122.425907897826 | (37.7224720200432, -122.425907897826) | 9 | 7 | 6 | 28861 | 5 | |||
102958 | 176266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004692.43448 | 2091256.7125 | 37.7224585032472 | -122.425877480072 | (37.7224585032472, -122.425877480072) | 9 | 7 | 6 | 28861 | 5 | |||
155206 | 252856 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 926 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001578 | 2088750 | 37.7153991335272 | -122.43646402536 | (37.7153991335272, -122.43646402536) | 9 | 7 | 6 | 28861 | 5 | ||||
178849 | 252855 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 926 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001578 | 2088750 | 37.7153991335272 | -122.43646402536 | (37.7153991335272, -122.43646402536) | 9 | 7 | 6 | 28861 | 5 | ||||
65265 | 90904 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 925 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992720.2562 | 2110664.48698 | 37.7750634192844 | -122.468673673873 | (37.7750634192844, -122.468673673873) | 11 | 6 | 2 | 54 | 11 | ||
93389 | 90160 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 924 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5992764.347407 | 2111398.427222 | 37.7770811680106 | -122.46857456674 | (37.7770811680106, -122.46857456674) | 11 | 6 | 2 | 54 | 11 | ||
162025 | 67376 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 924 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 3 | Permit Number 30871 | 5992711.29916 | 2111406.94821 | 37.7771014998466 | -122.468758695805 | (37.7771014998466, -122.468758695805) | 11 | 6 | 2 | 54 | 11 | |
166852 | 123774 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 921 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5992733.94745 | 2110666.64167 | 37.7750701263922 | -122.468626470068 | (37.7750701263922, -122.468626470068) | 11 | 6 | 2 | 54 | 11 | |||
117719 | 90550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 920 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992746.21169 | 2110724.86096 | 37.7752306893281 | -122.468588282697 | (37.7752306893281, -122.468588282697) | 11 | 6 | 2 | 54 | 11 | ||
32383 | 88740 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
71932 | 88741 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
65530 | 176226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 915 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002121.3261 | 2088534.63061 | 37.7148386356627 | -122.434570661505 | (37.7148386356627, -122.434570661505) | 9 | 7 | 6 | 28861 | 5 | |||
152935 | 14731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 912X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 6 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | 7 | 9 | 11 | 28852 | 41 | |||
132215 | 251702 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 910 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:10:00 AM | 3 | 3x3 | 5995959 | 2089989 | 37.7184802428284 | -122.455975181765 | (37.7184802428284, -122.455975181765) | 9 | 8 | 6 | 28861 | 24 | ||
27608 | 251772 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
45628 | 251771 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
46531 | 251773 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
177552 | 90549 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 908 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992785.51591 | 2110727.39305 | 37.7752399121234 | -122.468452505936 | (37.7752399121234, -122.468452505936) | 11 | 6 | 2 | 54 | 11 | ||
127843 | 64026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 907 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24783 | 6008326.13361224 | 2095676.92812978 | 37.7348001501968 | -122.413629054856 | (37.7348001501968, -122.413629054856) | 10 | 7 | 7 | 28859 | 2 | ||
4498 | 58438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | 15 | 5 | 11 | 29492 | 9 | ||
150359 | 223472 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5999167.22172 | 2107046.81544 | 37.7655005312494 | -122.446112018354 | (37.7655005312494, -122.446112018354) | 15 | 5 | 11 | 29492 | 9 | |||
56183 | 90906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 4 | 3x3 | 5992776.28818 | 2110667.73592 | 37.7750755767076 | -122.468480085109 | (37.7750755767076, -122.468480085109) | 11 | 6 | 2 | 54 | 11 | ||
130169 | 90905 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992861.436294 | 2110681.286553 | 37.7751177011018 | -122.468186527599 | (37.7751177011018, -122.468186527599) | 11 | 6 | 2 | 54 | 11 | ||
13100 | 176239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.410785993677 | (37.7203696227506, -122.410785993677) | 9 | 3 | 7 | 309 | 28 | |||
72397 | 176240 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009052.31678 | 2090410.35877 | 37.7203800198047 | -122.41074656201 | (37.7203800198047, -122.41074656201) | 9 | 3 | 7 | 309 | 28 | |||
81467 | 176242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009078.67243 | 2090418.23511 | 37.7204031242939 | -122.41065601467 | (37.7204031242939, -122.41065601467) | 9 | 3 | 7 | 309 | 28 | |||
140001 | 176241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009064.84821 | 2090413.67882 | 37.7203898385876 | -122.410703479104 | (37.7203898385876, -122.410703479104) | 9 | 3 | 7 | 309 | 28 | |||
44374 | 191081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015467.86658 | 2102506.20441 | 37.7539503763268 | -122.389414166444 | (37.7539503763268, -122.389414166444) | 10 | 3 | 8 | 28856 | 29 | |||
108786 | 191082 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015413.33991 | 2102503.20842 | 37.7539391266996 | -122.389602524941 | (37.7539391266996, -122.389602524941) | 10 | 3 | 8 | 28856 | 29 | |||
194119 | 191080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015525.99309 | 2102510.04982 | 37.7539641575461 | -122.389213417992 | (37.7539641575461, -122.389213417992) | 10 | 3 | 8 | 28856 | 29 | |||
89276 | 90158 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5992777.08425 | 2111410.577 | 37.7771152637542 | -122.468531390608 | (37.7771152637542, -122.468531390608) | 11 | 6 | 2 | 54 | 11 | ||
128270 | 90159 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5992754.23611 | 2111407.6277 | 37.7771058459469 | -122.468610214172 | (37.7771058459469, -122.468610214172) | 11 | 6 | 2 | 54 | 11 | ||
4522 | 141909 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.7792188274982 | -122.427751880486 | (37.7792188274982, -122.427751880486) | 7 | 9 | 11 | 29490 | 41 | |||
48492 | 141906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004683.4832 | 2111946.7944 | 37.7792681524686 | -122.427381601663 | (37.7792681524686, -122.427381601663) | 7 | 9 | 11 | 29490 | 41 | |||
113456 | 139822 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005086 | 2111993 | 37.7794177784995 | -122.425992418184 | (37.7794177784995, -122.425992418184) | 7 | 9 | 11 | 28852 | 41 | |||
139595 | 90548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992814.63788 | 2110726.933 | 37.7752403310429 | -122.468351733827 | (37.7752403310429, -122.468351733827) | 11 | 6 | 2 | 54 | 11 | ||
91961 | 223549 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5999208.96535 | 2107104.19665 | 37.7656604693858 | -122.445971764578 | (37.7656604693858, -122.445971764578) | 15 | 5 | 5 | 29492 | 9 | |||
28415 | 223396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6006003.81464 | 2104993.73555 | 37.7602512990686 | -122.42231986997 | (37.7602512990686, -122.42231986997) | 2 | 4 | 5 | 28859 | 19 | |||
147933 | 68475 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 898x HAMPSHIRE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | Permit Number 32344 | 6010178 | 2104272 | 37.7585041507506 | -122.407832365849 | (37.7585041507506, -122.407832365849) | 10 | 4 | 7 | 28859 | 19 | |||
25492 | 251734 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 898X Prague St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.21061 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | 9 | 7 | 6 | 28861 | 5 | ||
102701 | 223409 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 898 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010169.99414 | 2104057.76493 | 37.7579154611487 | -122.407844947098 | (37.7579154611487, -122.407844947098) | 2 | 4 | 7 | 28859 | 19 | |||
116915 | 223408 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 898 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010170.12734 | 2104071.29966 | 37.7579526319374 | -122.407845440824 | (37.7579526319374, -122.407845440824) | 2 | 4 | 7 | 28859 | 19 | |||
176821 | 223410 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 898 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32344 | 6010171.02881 | 2104045.21453 | 37.7578810584907 | -122.407840483778 | (37.7578810584907, -122.407840483778) | 2 | 4 | 7 | 28859 | 19 | |
1085 | 223588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009063.07444 | 2096876.26549 | 37.7381346254237 | -122.411165877211 | (37.7381346254237, -122.411165877211) | 10 | 7 | 7 | 28859 | 2 | |||
9295 | 223587 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009072.26343 | 2096875.24392 | 37.7381323357409 | -122.411134034011 | (37.7381323357409, -122.411134034011) | 10 | 7 | 7 | 28859 | 2 |
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) );