trees

183 rows where qSpecies_id = 119 sorted by TreeID descending

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
79000 99679 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 165 Grattan St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
135986 88782 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 166 Havelock St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2008 12:00:00 AM 9 3x3 Permit Number 51699 5999327.15741 2092949.02389 37.7268005308142 -122.444545520761 (37.7268005308142, -122.444545520761) 9 7 6 28861 25
54242 804 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 680X 39th Ave 2 Median : Cutout Tree DPW 1     3 6-HOA   5983823.94935 2111143.69789 37.7758612538886 -122.499482885033 (37.7758612538886, -122.499482885033) 11 6 2 55 26
90526 7445 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 2548 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008209.4393 2103591.66563 37.7565257046152 -122.414592409312 (37.7565257046152, -122.414592409312) 2 4 7 28859 19
872 73939 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1450 Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5988330.9539 2099688.5183 37.7446718481509 -122.483052396761 (37.7446718481509, -122.483052396761) 1 8 3 29491 35
17085 73562 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1620 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6015449.23036 2096256.56638 37.7367891335144 -122.389042293172 (37.7367891335144, -122.389042293172) 10 3 8 58 1
14087 72881 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 130 Alpha St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6010899.06821 2088108.56402 37.7141631333099 -122.404200991296 (37.7141631333099, -122.404200991296) 9 7 8 309 39
2236 71359 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1620 La Salle Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015449.34332 2096256.73769 37.7367896101585 -122.389041914574 (37.7367896101585, -122.389041914574) 10 3 8 58 1
63491 65002 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1628 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1989 12:00:00 AM 7   Permit Number 26041 6007789.57951 2087924.39296 37.7134831981768 -122.414935588817 (37.7134831981768, -122.414935588817) 9 7 8 309 39
17176 62603 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 792 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/1986 12:00:00 AM 6   Permit Number 22911 5984491.42084 2110500.08946 37.7741332293959 -122.497126446837 (37.7741332293959, -122.497126446837) 11 6 2 55 26
171515 61499 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 154 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/1984 12:00:00 AM 7   Permit Number 21452 5989629.6033 2114330.31946 37.7849497475064 -122.47963307901 (37.7849497475064, -122.47963307901) 11 6 2 55 26
69086 61497 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 137 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/1984 12:00:00 AM 9   Permit Number 21447 5989576.46395 2114470.47527 37.7853314889271 -122.479827181582 (37.7853314889271, -122.479827181582) 11 6 2 55 26
169656 57922 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 539 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1977 12:00:00 AM 5   Permit Number 16880 5999313.15008 2086900.51859 37.7101919177852 -122.444159502961 (37.7101919177852, -122.444159502961) 9 7 6 28861 5
127964 5550 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 951 Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM 18 6   6005117.32575 2102805.17707 37.7541919854752 -122.425230085106 (37.7541919854752, -122.425230085106) 2 4 5 28859 19
160265 54637 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1747 Quint St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1972 12:00:00 AM 1   Permit Number 10460 6012648.74415 2095666.17396 37.7350124040996 -122.398683444593 (37.7350124040996, -122.398683444593) 10 3 8 58 1
145580 48553 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 378 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM 3   Permit Number 45869 5990302.44703 2112853.20794 37.7809330733125 -122.477197298017 (37.7809330733125, -122.477197298017) 11 6 2 55 26
43478 32329 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1884 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/1996 12:00:00 AM 5   Permit Number 36893 5993786.54543 2102682.50055 37.7532085147622 -122.464405513896 (37.7532085147622, -122.464405513896) 1 8 4 56 12
8190 261370 Planning Code 138.1 required 2 Eriobotrya japonica :: Edible Loquat 119 102 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007140 2095356 37.7338522748733 -122.417707198486 (37.7338522748733, -122.417707198486) 2 7 7 28859 2
40158 253917 Significant Tree 6 Eriobotrya japonica :: Edible Loquat 119 1819 Mason St 1 Front Yard : Yard Tree Private 2           6009087 2119549 37.8003900283184 -122.412685532944 (37.8003900283184, -122.412685532944) 3 1 10 308 32
24987 249981 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 224 Filbert St 2 Front Yard : Yard Tree Private 2     9 Width 0ft   6011659.45074 2120118.51197 37.8020978133144 -122.403823874987 (37.8020978133144, -122.403823874987) 3 1 10 308 23
41791 249910 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 308 Greenwich St 2 Front Yard : Yard Tree Private 2     10 Width 0ft   6011272.31007 2120413.30181 37.8028855987512 -122.405184344187 (37.8028855987512, -122.405184344187) 3 1 10 308 23
172147 249903 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 300 Greenwich St 4 Front Yard : Yard Tree Private 2     17 Width 0ft   6011307.54061 2120412.72536 37.8028859854681 -122.405062387114 (37.8028859854681, -122.405062387114) 3 1 10 308 23
56792 249890 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 230 Greenwich St 26 Back Yard : Yard Tree Private 2     11 Width 0ft   6011458.55673 2120431.85719 37.8029469576839 -122.404541138271 (37.8029469576839, -122.404541138271) 3 1 10 28860 6
70334 249883 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 230 Greenwich St 19 Back Yard : Yard Tree Private 2     14 Width 0ft   6011507.08304 2120427.11079 37.8029366370675 -122.404372876909 (37.8029366370675, -122.404372876909) 3 1 10 308 23
118137 249880 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 230 Greenwich St 16 Back Yard : Yard Tree Private 2     11 Width 0ft   6011523.78476 2120446.01272 37.8029894704488 -122.404316411196 (37.8029894704488, -122.404316411196) 3 1 10 28860 6
74386 249863 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 233 Greenwich St 4 Front Yard : Yard Tree Private 2     6 Width 0ft   6011630.03083 2120434.01589 37.8029624665125 -122.403947897788 (37.8029624665125, -122.403947897788) 3 1 10 308 23
86235 249846 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 289 Greenwich St 3 Side Yard : Yard Tree Private 2     14 Width 0ft   6011427.16735 2120382.55668 37.8028098362532 -122.404646289706 (37.8028098362532, -122.404646289706) 3 1 10 308 23
153744 249620 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 2400 Golden Gate Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 7ft   5997953.57215 2111367.44178 37.7772944806811 -122.450621264952 (37.7772944806811, -122.450621264952) 15 6 2 54 16
124641 248210 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 69 Fair Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6007064.668 2099422.3589 37.7450133544796 -122.418255851634 (37.7450133544796, -122.418255851634) 2 7 7 28859 2
126650 247967 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 16 Joy St 3 Front Yard : Yard Tree Private 2     4     6010333.49571 2098927.49611 37.7438380268983 -122.40691790615 (37.7438380268983, -122.40691790615) 2 7 7 28859 2
9946 247879 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 388 Mayflower St 8 Side Yard : Yard Tree Private 2     3     6009924.14803 2098382.32436 37.7423181897436 -122.408294896795 (37.7423181897436, -122.408294896795) 10 7 7 28859 2
120318 247873 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 388 Mayflower St 1 Side Yard : Yard Tree Private 2     9     6009888.01932 2098399.59712 37.7423635938187 -122.408421037503 (37.7423635938187, -122.408421037503) 10 7 7 28859 2
158281 246774 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1850 Alabama St 3 Sidewalk: Curb side : Yard Tree Private 2     15     6009457.96402 2098740.81971 37.7432764236648 -122.409932126974 (37.7432764236648, -122.409932126974) 2 7 7 28859 2
38491 246771 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1850 Alabama St 1 Sidewalk: Curb side : Yard Tree Private 2     18     6009333.37029 2098874.50038 37.743636497837 -122.410372378408 (37.743636497837, -122.410372378408) 2 7 7 28859 2
54915 246770 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 99 Waltham St 3 Side Yard : Yard Tree Private 2     9     6009309.01668 2098932.20278 37.7437935707282 -122.410460661231 (37.7437935707282, -122.410460661231) 2 7 7 28859 2
187997 246764 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 70 Waltham St 8 Front Yard : Yard Tree Private 2     8     6009279.96949 2098891.64841 37.7436805888792 -122.410558236772 (37.7436805888792, -122.410558236772) 2 7 7 28859 2
110805 246755 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1838 Alabama St 2 Front Yard : Yard Tree Private 2     16     6009311.20113 2098998.06122 37.7439745260177 -122.410457757318 (37.7439745260177, -122.410457757318) 2 7 7 28859 2
47047 246754 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1838 Alabama St 1 Front Yard : Yard Tree Private 2     16     6009313.62627 2099009.88757 37.7440071345341 -122.410450206611 (37.7440071345341, -122.410450206611) 2 7 7 28859 2
180779 22498 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 6404 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM 3 3X3   6013069.4059 2090221.21293 37.7200850799347 -122.396847440878 (37.7200850799347, -122.396847440878) 10 3 8 58 1
149641 224132 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 310 Liberty St 26 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   6004003.01868 2103934.91108 37.7572309538551 -122.429164182884 (37.7572309538551, -122.429164182884) 2 4 5 28862 3
163446 224131 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1340 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009255.1331 2101276.97976 37.7502287892492 -122.410812544378 (37.7502287892492, -122.410812544378) 2 4 7 28859 19
100884 224130 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 840 Castro St 2 Sidewalk: Property side : Yard Tree Private 2     18     6002416.06064 2103301.09689 37.7554006877977 -122.434607174889 (37.7554006877977, -122.434607174889) 2 4 5 28862 22
190243 224129 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 26 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999702.07185 2101445.78437 37.7501520078164 -122.443859651015 (37.7501520078164, -122.443859651015) 2 5 5 63 38
76419 224128 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 18 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5999679.40978 2101490.53022 37.7502735763867 -122.443941232111 (37.7502735763867, -122.443941232111) 2 5 5 63 38
80510 224127 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 950 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999802.03186 2102082.04496 37.7519047262434 -122.443559684852 (37.7519047262434, -122.443559684852) 2 5 5 63 38
83388 224126 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 3213 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006857.14128 2103777.70396 37.7569604557817 -122.419282344129 (37.7569604557817, -122.419282344129) 2 4 7 28859 19
162017 224125 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1745 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6008033.82801 2108179.59599 37.7691132329216 -122.415524547646 (37.7691132329216, -122.415524547646) 8 4 7 28853 19
89041 224124 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1244 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008668.58024 2101297.73586 37.7502528748804 -122.412842355611 (37.7502528748804, -122.412842355611) 2 4 7 28859 19
19239 224123 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 601X Powhattan Ave 3 Sidewalk: Curb side : Yard Tree Private 2     7     6008526.38321 2098121.40646 37.7415233967761 -122.413109512687 (37.7415233967761, -122.413109512687) 10 7 7 28859 2
9830 224122 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 499X Ogden Ave 6 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6008272.03754 2096094.48518 37.7359436331948 -122.413845611379 (37.7359436331948, -122.413845611379) 2 7 7 28859 2
11577 224121 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 499X Ogden Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6008290.10508 2096093.22608 37.7359411906366 -122.413783055452 (37.7359411906366, -122.413783055452) 2 7 7 28859 2
37765 224120 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1350 Noe St 6 Sidewalk: Property side : Yard Tree Private 2     8     6003219.3903 2100351.64414 37.7473477571063 -122.431618456154 (37.7473477571063, -122.431618456154) 2 4 5 63 22
88203 224119 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 410 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6003252.6682 2099235.68131 37.7442854692919 -122.431423731321 (37.7442854692919, -122.431423731321) 2 7 5 63 22
87091 224118 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1525 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009611.07907 2100364.72243 37.7477438841853 -122.409517278718 (37.7477438841853, -122.409517278718) 2 7 7 28859 2
70351 224117 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 2818 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009831.98095 2102814.76339 37.7544835286044 -122.408926245167 (37.7544835286044, -122.408926245167) 2 4 7 28859 19
56150 224116 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 400 Prospect Ave 15 Sidewalk: Property side : Yard Tree Private 2     7     6006205.79839 2097605.42741 37.7399760871276 -122.421096686769 (37.7399760871276, -122.421096686769) 2 7 7 28859 2
71753 224115 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 71 Front Yard : Yard Tree Private 2     8     6004680.7613 2096547.43611 37.7369849941684 -122.426294330213 (37.7369849941684, -122.426294330213) 2 7 5 63 7
37110 224114 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 70 Front Yard : Yard Tree Private 2     6     6004687.50549 2096549.18122 37.736990167061 -122.42627113673 (37.736990167061, -122.42627113673) 2 7 5 63 7
84688 224113 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 69 Front Yard : Yard Tree Private 2     4     6004690.02185 2096554.43933 37.7370047468799 -122.426262810788 (37.7370047468799, -122.426262810788) 2 7 5 63 7
71542 224112 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 51 Sidewalk: Property side : Yard Tree Private 2     5     6004737.84332 2096628.18536 37.7372099397936 -122.426102718871 (37.7372099397936, -122.426102718871) 2 7 5 63 7
89861 224111 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 50 Sidewalk: Property side : Yard Tree Private 2     4     6004733.53405 2096634.51546 37.7372270772601 -122.426118068508 (37.7372270772601, -122.426118068508) 2 7 5 63 7
184069 218344 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 385 Castenada Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 0ft   5993369.33927 2100022.3312 37.745880311731 -122.465655034675 (37.745880311731, -122.465655034675) 1 8 4 29491 40
12159 207734 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 301 Joost Ave 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 10ft   6000042.84201 2094939.48464 37.7323066857905 -122.442214249597 (37.7323066857905, -122.442214249597) 9 7 4 63 40
167227 207733 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 500 Joost Ave 3 Sidewalk: Property side : Yard Tree Private 2     4     5998757.70005 2094996.74516 37.7323905826432 -122.446661380942 (37.7323905826432, -122.446661380942) 9 7 4 59 40
109998 207732 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 400 Congo St 2 Sidewalk: Property side : Yard Tree Private 2     19 Width 10ft   6000124.6238 2095012.30469 37.7325112932663 -122.441936736802 (37.7325112932663, -122.441936736802) 9 7 5 63 40
59884 207731 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 32 Malta Dr 19 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5999573.25493 2096045.34694 37.7353163497697 -122.443917140176 (37.7353163497697, -122.443917140176) 9 7 4 63 40
38804 207730 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 740 Foerster St 1 Sidewalk: Property side : Yard Tree Private 2     16 Width 3ft   5998158.00142 2095945.96511 37.7349626400957 -122.44880301654 (37.7349626400957, -122.44880301654) 9 7 4 59 40
129645 207729 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 10 Mendosa Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5993528.03028 2101159.37914 37.749011508282 -122.465188881878 (37.749011508282, -122.465188881878) 1 8 4 29491 40
153448 207728 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 3802 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.474661051582 (37.7196901687566, -122.474661051582) 9 8 4 64 40
180879 207727 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 378 Victoria St 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   5993265.77465 2089711.08498 37.717562206406 -122.465264296326 (37.717562206406, -122.465264296326) 9 8 6 64 24
95024 207726 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 416 Ralston St 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   5992237.92359 2090619.01384 37.719995829436 -122.468883110676 (37.719995829436, -122.468883110676) 9 8 6 64 24
9092 207725 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 380 Ralston St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 6ft   5992234.50872 2090438.58266 37.7195002121526 -122.468881791362 (37.7195002121526, -122.468881791362) 9 8 6 64 24
158858 207724 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 132 Ralston St 1 : Tree Private 2     3 Width 3ft   5992208.61623 2088772.74591 37.7149247331539 -122.46885013342 (37.7149247331539, -122.46885013342) 9 8 6 64 24
165212 207723 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 301 Byxbee St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 10ft   5991929.88427 2090544.15077 37.7197724720092 -122.469942439216 (37.7197724720092, -122.469942439216) 9 8 6 64 24
115439 207722 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 300 Louisburg St 1 : Tree Private 2     8 Width 3ft   5997412.90563 2090249.05124 37.7192776245304 -122.450968397868 (37.7192776245304, -122.450968397868) 9 8 6 28861 24
116467 207721 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 228 Montana St 1 Sidewalk: Curb side : Pot Tree Private 2     5     5994631.9391 2089350.3088 37.7166502911674 -122.460515994629 (37.7166502911674, -122.460515994629) 9 8 6 28861 24
122502 207720 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 750 Grafton Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5994515.75563 2090598.91337 37.7200719768186 -122.461008027219 (37.7200719768186, -122.461008027219) 9 8 6 28861 24
116477 207719 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 126 Brighton Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 1ft   5996251.42646 2090752.11635 37.7205923605284 -122.455019501973 (37.7205923605284, -122.455019501973) 9 8 6 28861 24
58209 207718 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 315 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994723.84306 2090686.34608 37.7203240181088 -122.46029507617 (37.7203240181088, -122.46029507617) 9 8 6 28861 24
107253 207717 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1180 Plymouth Ave 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   5995974.63238 2091762.70234 37.7233513070047 -122.456049310222 (37.7233513070047, -122.456049310222) 9 8 4 28861 24
34061 207716 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 115 Judson Ave 4 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   5999335.92351 2093459.52729 37.7282027546376 -122.444551891566 (37.7282027546376, -122.444551891566) 9 7 4 28861 40
112712 207715 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 117 Judson Ave 2 Sidewalk: Property side : Yard Tree Private 2     2     5999294.96193 2093458.56634 37.7281977787 -122.444693427785 (37.7281977787, -122.444693427785) 9 7 4 28861 40
97479 207714 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 298 Staples Ave 11 Sidewalk: Property side : Yard Tree Private 2     12     5998133.74364 2093826.5868 37.7291419427263 -122.448734282271 (37.7291419427263, -122.448734282271) 9 7 4 28861 40
138085 207713 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 171 Flood Ave 3 Sidewalk: Property side : Yard Tree Private 2     11     5999625.57301 2094046.65577 37.7298313962868 -122.443592725033 (37.7298313962868, -122.443592725033) 9 7 4 63 40
83068 207712 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 579 Hearst Ave 1 Sidewalk: Property side : Yard Tree Private 2     7     5997579.44084 2094367.86788 37.7305964594534 -122.450689553205 (37.7305964594534, -122.450689553205) 9 7 4 28861 40
167876 207711 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 200x Terrace Dr 31 Median : Yard Tree DPW 1     12     5993844.07189 2096487.62875 37.7362022754996 -122.463756979508 (37.7362022754996, -122.463756979508) 1 8 4 59 40
107290 207710 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 641 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992286.81518 2103851.81856 37.7563325940936 -122.46967695664 (37.7563325940936, -122.46967695664) 1 8 4 56 12
90998 207709 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 916 Ortega St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 1ft   5991129.27817 2102510.74063 37.7525833753326 -122.47358226082 (37.7525833753326, -122.47358226082) 1 8 4 56 12
155867 207708 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 916 Ortega St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 1ft   5991151.90196 2102512.9309 37.7525906994144 -122.473504184373 (37.7525906994144, -122.473504184373) 1 8 4 56 12
132651 207707 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1254 18th Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5990519.64263 2106849.66281 37.7644615768749 -122.476007325895 (37.7644615768749, -122.476007325895) 11 8 3 56 12
143684 202013 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 7 Wheat St 2 : Tree Private 2     3 Width 3ft   6012149.42791 2091374.55614 37.7232006759464 -122.400108468936 (37.7232006759464, -122.400108468936) 10 3 8 58 1
118144 201358 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 245 Kalmanovitz St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 2ft   6013008.61874 2092664.02794 37.7267891723748 -122.39722877051 (37.7267891723748, -122.39722877051) 10 3 8 58 1
80989 200198 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 3125 Jennings St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   6013701.6232 2090281.2208 37.7202850194185 -122.394666263771 (37.7202850194185, -122.394666263771) 10 3 8 58 1
9550 20003 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 100 STAIRWAY46 23 Sidewalk: Curb side : Cutout Tree DPW 1     3 2                      
17991 19926 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 100 STAIRWAY37 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
9086 19838 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 100 STAIRWAY25 22 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
8381 19836 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 100 STAIRWAY25 20 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
561 19835 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 100 STAIRWAY25 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
17879 19817 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 100 STAIRWAY25 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
11967 19792 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 100 STAIRWAY19 14 Sidewalk: Curb side : Cutout Tree DPW 1     6 20ST                      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);