trees

856 rows where qSpecies_id = 5 sorted by YCoord descending

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
128485 97184 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013138 2116168 37.791333135618 -122.398429995238 (37.791333135618, -122.398429995238) 12 2 9 28855 6
23322 189937 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013275.69539 2116164.65668 37.7913316253015 -122.397953334494 (37.7913316253015, -122.397953334494) 12 2 9 28855 6
114608 189938 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013289.37156 2116149.22674 37.7912900199673 -122.397904932091 (37.7912900199673, -122.397904932091) 12 2 9 28855 6
52265 95955 Permitted Site 7 Ceratonia siliqua :: Carob 5 190X Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2011 12:00:00 AM   3x3 Permit Number 767637 6014675 2116143.7 37.791351915434 -122.393110267966 (37.791351915434, -122.393110267966) 12 2 9 28855 6
6962 189948 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 1ft   6014781.22378 2116142.62721 37.7913548700732 -122.392742658052 (37.7913548700732, -122.392742658052) 12 2 9 28855 6
123765 189939 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013302.11078 2116136.01551 37.7912544544909 -122.397859927289 (37.7912544544909, -122.397859927289) 12 2 9 28855 6
98740 189925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 11 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013397.06496 2116134.82312 37.7912564680486 -122.397531302439 (37.7912564680486, -122.397531302439) 12 2 9 28855 6
38483 189924 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 10 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6013405.38871 2116121.70148 37.7912209025705 -122.397501581628 (37.7912209025705, -122.397501581628) 12 2 9 28855 6
146281 189940 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013316.29733 2116121.55291 37.791215533629 -122.39780982696 (37.791215533629, -122.39780982696) 12 2 9 28855 6
24818 97179 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013408 2116114 37.7911999015077 -122.397492006217 (37.7911999015077, -122.397492006217) 12 2 9 28855 6
162198 189923 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6013419.15414 2116110.66886 37.7911913760301 -122.397453179235 (37.7911913760301, -122.397453179235) 12 2 9 28855 6
72220 189941 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 10 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013331.4553 2116106.58194 37.7911752709767 -122.397756329903 (37.7911752709767, -122.397756329903) 12 2 9 28855 6
5594 106035 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014366.74772 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061) 12 2 9 28855 6
105981 106036 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2015 12:00:00 AM   3x3 Permit Number 770222 6014366.74772 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061) 12 2 9 28855 6
147008 106033 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014366.74772 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061) 12 2 9 28855 6
194245 106032 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014366.74772 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061) 12 2 9 28855 6
123100 56925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 12   Permit Number 14168 6014784.53223 2116103.90747 37.7912487383869 -122.392728500917 (37.7912487383869, -122.392728500917) 12 2 9 28855 6
137700 189922 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6013429.98555 2116100.18474 37.791163192164 -122.397414967051 (37.791163192164, -122.397414967051) 12 2 9 28855 6
47459 189921 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013437.41222 2116091.23603 37.7911390345977 -122.397388642991 (37.7911390345977, -122.397388642991) 12 2 9 28855 6
177137 189949 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6014767.16396 2116087.91405 37.791203859513 -122.392787475772 (37.791203859513, -122.392787475772) 12 2 9 28855 6
17034 96473 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3 Permit Number 767637 6014754.27658 2116074.97331 37.7911676114441 -122.392831160352 (37.7911676114441, -122.392831160352) 12 2 9 28855 6
37802 119741 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
44569 119744 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
89068 119742 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
101550 119745 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
163468 119743 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
173505 119746 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
35126 15121 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 2X2   6013826.37134 2116069.93693 37.7911022004845 -122.396041353962 (37.7911022004845, -122.396041353962) 12 2 9 28855 6
182570 189917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 338 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6013829.87851 2116068.4816 37.7910983996161 -122.396029117153 (37.7910983996161, -122.396029117153) 12 2 9 28855 6
187401 119740 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     7     6013460.47758 2116066.81767 37.7910732716747 -122.397307123936 (37.7910732716747, -122.397307123936) 12 2 9 28855 6
112676 189950 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6014741.1957 2116062.87497 37.7911336656463 -122.392875573361 (37.7911336656463, -122.392875573361) 12 2 9 28855 6
95233 15122 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 2X2   6013811.40838 2116056.32171 37.7910639837629 -122.396092171091 (37.7910639837629, -122.396092171091) 12 2 9 28855 6
186270 119739 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     8     6013469.82728 2116055.87494 37.7910437460335 -122.397274006392 (37.7910437460335, -122.397274006392) 12 2 9 28855 6
113987 189951 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6014728.34644 2116051.81938 37.7911025958469 -122.392919257911 (37.7911025958469, -122.392919257911) 12 2 9 28855 6
88195 189918 DPW Maintained 1 Ceratonia siliqua :: Carob 5 338 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6013810.73123 2116050.81938 37.7910488379738 -122.396094128247 (37.7910488379738, -122.396094128247) 12 2 9 28855 6
16430 119738 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2     7     6013480.63892 2116044.41356 37.7910128776808 -122.397235794198 (37.7910128776808, -122.397235794198) 12 2 9 28855 6
107370 189952 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 1ft   6014715.63981 2116037.408 37.7910623197318 -122.392962214036 (37.7910623197318, -122.392962214036) 12 2 9 28855 6
62483 119737 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2     7     6013490.74423 2116034.43287 37.7909860356216 -122.397200129801 (37.7909860356216, -122.397200129801) 12 2 9 28855 6
105990 18859 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/1992 12:00:00 AM 12 3X3   6004082.46062 2116030.31556 37.7904464684691 -122.429752123658 (37.7904464684691, -122.429752123658) 13 9 1 29490 27
20273 18860 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004055.90045 2116026.39415 37.7904341972353 -122.429843740294 (37.7904341972353, -122.429843740294) 13 9 1 29490 27
107461 85255 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     6   Permit Number 49553 6013503.0525 2116024.16318 37.7909585226636 -122.39715682295 (37.7909585226636, -122.39715682295) 12 2 9 28855 6
104489 189953 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 7 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6014700.62775 2116023.46282 37.7910231956157 -122.393013179512 (37.7910231956157, -122.393013179512) 12 2 9 28855 6
79345 18853 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2222 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3X3   6004009.33777 2116018.08762 37.7904087527096 -122.430004251319 (37.7904087527096, -122.430004251319) 13 9 1 29490 27
72975 15123 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     14 2X2   6013765.88916 2116013.74101 37.7909445343765 -122.396246681474 (37.7909445343765, -122.396246681474) 12 2 9 28855 6
144683 189919 DPW Maintained 1 Ceratonia siliqua :: Carob 5 338 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6013770.13743 2116011.13859 37.7909376251249 -122.396231800058 (37.7909376251249, -122.396231800058) 12 2 9 28855 6
122504 18864 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2230 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003886.2489 2116004.41909 37.7903642506674 -122.430429154879 (37.7903642506674, -122.430429154879) 13 9 1 29490 27
88181 85254 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     9   Permit Number 49553 6013520.55509 2116003.76772 37.7909034958536 -122.397094833572 (37.7909034958536, -122.397094833572) 12 2 9 28855 6
93762 15124 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     14 2X2   6013752.67684 2116000.07901 37.7909062865319 -122.396291437927 (37.7909062865319, -122.396291437927) 12 2 9 28855 6
56233 18865 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2230 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003863.26827 2115999.97726 37.7903507527417 -122.430508349195 (37.7903507527417, -122.430508349195) 13 9 1 29490 27
109981 189920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 338 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6013751.03466 2115995.67684 37.7908941078228 -122.396296811166 (37.7908941078228, -122.396296811166) 12 2 9 28855 6
54786 106031 Permitted Site 7 Ceratonia siliqua :: Carob 5 180 Howard St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014640.7 2115990 37.7909279854042 -122.39321818634 (37.7909279854042, -122.39321818634) 12 2 9 28855 6
131100 106027 DPW Maintained 1 Ceratonia siliqua :: Carob 5 180 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2015 12:00:00 AM 11 3x3 Permit Number 770222 6014665.81921 2115987.91534 37.7909236568574 -122.393131128317 (37.7909236568574, -122.393131128317) 12 2 9 28855 6
56161 18866 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2241 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6004050.55009 2115976.04283 37.7902956422834 -122.429858659173 (37.7902956422834, -122.429858659173) 13 9 1 29490 27
80077 106029 DPW Maintained 1 Ceratonia siliqua :: Carob 5 180 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2015 12:00:00 AM 14 3x3 Permit Number 770222 6014636.89755 2115962.51686 37.7908523118267 -122.393229418798 (37.7908523118267, -122.393229418798) 12 2 9 28855 6
63341 189955 DPW Maintained 1 Ceratonia siliqua :: Carob 5 145 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6014561.09202 2115949.59191 37.790812611275 -122.393490799583 (37.790812611275, -122.393490799583) 12 2 9 28855 6
53007 106030 DPW Maintained 1 Ceratonia siliqua :: Carob 5 180 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6014615.46906 2115943.46238 37.790798802166 -122.393302227016 (37.790798802166, -122.393302227016) 12 2 9 28855 6
69631 189954 DPW Maintained 1 Ceratonia siliqua :: Carob 5 145 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6014570.20304 2115942.2831 37.7907930492013 -122.393458763924 (37.7907930492013, -122.393458763924) 12 2 9 28855 6
99121 125970 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2301 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6003734.22562 2115934.13704 37.7901626613254 -122.430950126753 (37.7901626613254, -122.430950126753) 13 9 1 29490 27
121999 18922 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2620 SACRAMENTO ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002038.8 2115762.8 37.7895960030005 -122.436803887406 (37.7895960030005, -122.436803887406) 13 6 1 29490 27
25903 125969 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2672 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002023.76351 2115741.9503 37.7895379005066 -122.43685441882 (37.7895379005066, -122.43685441882) 13 6 1 29490 27
22361 125968 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2810 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001336.41783 2115647.62359 37.7892398148051 -122.439225792541 (37.7892398148051, -122.439225792541) 13 6 1 29490 27
175418 125967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3440 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   5998347.68841 2115559.33393 37.7888268704136 -122.449560024485 (37.7888268704136, -122.449560024485) 13 6 1 54 31
21471 139360 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2807 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000073 2114379 37.7856845299005 -122.443505885647 (37.7856845299005, -122.443505885647) 15 6 1 29490 31
19461 138737 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2945 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5999415.669 2114277.6236 37.7853686673978 -122.445772761062 (37.7853686673978, -122.445772761062) 15 6 1 29490 31
67860 57316 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1515 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 13   Permit Number 16140 5999629.2653 2114178.0114 37.7851073514303 -122.445026621162 (37.7851073514303, -122.445026621162) 15 6 1 29490 31
156383 30908 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1511 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM 7   Permit Number 34730 5999634.2212 2114153.2322 37.7850395970423 -122.445007693392 (37.7850395970423, -122.445007693392) 15 6 1 29490 31
53638 138239 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999639.177 2114119.037 37.784945988756 -122.444988088871 (37.784945988756, -122.444988088871) 15 6 1 29490 31
156051 139008 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5999687.2486 2114098.7181 37.7848929418184 -122.444820316061 (37.7848929418184, -122.444820316061) 15 6 1 29490 31
97344 138240 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999643.6372 2114098.2225 37.7848890921049 -122.444971161243 (37.7848890921049, -122.444971161243) 15 6 1 29490 31
61904 110184 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
82931 110183 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
82972 110185 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
75012 138241 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999646.1152 2114082.8594 37.7848470504501 -122.444961483404 (37.7848470504501, -122.444961483404) 15 6 1 29490 31
179176 139007 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5999691.7088 2114071.461 37.7848183554363 -122.444802925313 (37.7848183554363, -122.444802925313) 15 6 1 29490 31
68552 138242 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999647.1063 2114070.9654 37.7848144491807 -122.444957199215 (37.7848144491807, -122.444957199215) 15 6 1 29490 31
116533 138243 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   5999648.5931 2114056.0979 37.7847737117432 -122.444950986247 (37.7847737117432, -122.444950986247) 15 6 1 29490 31
113408 139006 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5999695.1779 2114053.1244 37.7847682058679 -122.444789604899 (37.7847682058679, -122.444789604899) 15 6 1 29490 31
63547 57317 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2706 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 13   Permit Number 16141 5999606.4685 2114016.4513 37.7846624482509 -122.445093871748 (37.7846624482509, -122.445093871748) 15 6 1 29490 31
62929 57320 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2728 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 15   Permit Number 16145 5999531.6355 2114001.5838 37.7846173544843 -122.445351698652 (37.7846173544843, -122.445351698652) 15 6 1 29490 31
111478 139056 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2693 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999748.2433 2113980.0087 37.7845704772917 -122.444600759792 (37.7845704772917, -122.444600759792) 15 6 11 29490 31
56818 139055 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2693 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999732.7035 2113978.0164 37.7845641202108 -122.444654378813 (37.7845641202108, -122.444654378813) 15 6 11 29490 31
74084 124322 DPW Maintained 1 Ceratonia siliqua :: Carob 5 115 Jordan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5996192.87314 2113669.73604 37.7835150337529 -122.456878613619 (37.7835150337529, -122.456878613619) 11 6 1 54 31
194344 124321 DPW Maintained 1 Ceratonia siliqua :: Carob 5 115 Jordan Ave 2 Sidewalk: Curb side : Yard Tree Private 2   12/16/2020 12:00:00 AM 3 Width 3ft   5996193.40211 2113658.22839 37.7834834671867 -122.456875951009 (37.7834834671867, -122.456875951009) 11 6 1 54 31
50058 103976 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2440 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6000022.661 2113372.9775 37.7829193814773 -122.44360774817 (37.7829193814773, -122.44360774817) 15 5 1 29490 31
191380 123914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 389 09th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993078.53663 2112857.80843 37.7811063777719 -122.467593853963 (37.7811063777719, -122.467593853963) 11 6 2 54 11
187721 125971 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6008148.4886 2112831.14919 37.7818917385495 -122.415457300812 (37.7818917385495, -122.415457300812) 7 10 9 28852 36
166428 65950 Permitted Site 7 Ceratonia siliqua :: Carob 5 120 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM     Permit Number 28971 6008148.07854497 2112823.994523 37.7818720705068 -122.415458212735 (37.7818720705068, -122.415458212735) 7 10 9 28852 36
167516 51302 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 12   Permit Number 47670 6008052.8861 2112760.32075 37.7816918867218 -122.415783025366 (37.7816918867218, -122.415783025366) 7 10 9 28852 36
153705 51299 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 10   Permit Number 47670 6008033.00976 2112757.64367 37.7816834187084 -122.415851598691 (37.7816834187084, -122.415851598691) 7 10 9 28852 36
75940 51298 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 7   Permit Number 47670 6008009.38054 2112753.19289 37.7816698695126 -122.415933029587 (37.7816698695126, -122.415933029587) 7 10 9 28852 36
120772 51301 Permitted Site 7 Ceratonia siliqua :: Carob 5 101 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/20/2004 12:00:00 AM     Permit Number 47670 6008105.70875607 2112751.56982087 37.7816708281319 -122.415599663608 (37.7816708281319, -122.415599663608) 7 10 9 28852 36
9470 46514 Permitted Site 7 Ceratonia siliqua :: Carob 5 525or larger Golden Gate Ave In A 24 Box 3 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44680 6007056.20383649 2112568.41573989 37.7811088818185 -122.419217465788 (37.7811088818185, -122.419217465788) 7 9 9 28852 36
169246 14640 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600X McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6006169.26455 2112150.7692 37.779912136471 -122.422256155719 (37.779912136471, -122.422256155719) 7 9 11 28852 41
77005 140023 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 MCALLISTER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005484.9085 2112001.3325 37.7794631941198 -122.424613016933 (37.7794631941198, -122.424613016933) 7 9 11 28852 41
15625 27616 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005483.48508 2112000.60744 37.7794611228941 -122.424617889559 (37.7794611228941, -122.424617889559) 7 9 11 28852 41
24753 140022 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 MCALLISTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6005467.685 2112000.1843 37.7794590687234 -122.424672518677 (37.7794590687234, -122.424672518677) 7 9 11 28852 41
55304 14686 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 4X4   6005447.7824 2111997.5051 37.7794505882327 -122.424741179621 (37.7794505882327, -122.424741179621) 7 9 11 28852 41
25251 14688 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1     26 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
36977 14687 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
139016 140578 DPW Maintained 1 Ceratonia siliqua :: Carob 5 949 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003397.0361 2111670.2009 37.7784358543561 -122.431812198827 (37.7784358543561, -122.431812198827) 15 9 11 29492 41

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