77 rows where Fire Prevention Districts = 12 and qSpecies_id = 5 sorted by Longitude

View and edit SQL

Fire Prevention 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)
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
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
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
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
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
138761 189947 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6014726.02618 2116202.25149 37.7915155186799 -122.392937815425 (37.7915155186799, -122.392937815425) 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
161983 189946 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 1ft   6014709.04159 2116225.6637 37.7915788597386 -122.392998221109 (37.7915788597386, -122.392998221109) 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
159299 189945 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 1ft   6014694.61322 2116242.67208 37.7916247593304 -122.393049334066 (37.7916247593304, -122.393049334066) 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
192269 189944 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014676.15778 2116259.76194 37.7916706589171 -122.393114386531 (37.7916706589171, -122.393114386531) 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
1800 189943 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014663.90287 2116268.03372 37.7916926905231 -122.393157367813 (37.7916926905231, -122.393157367813) 12 2 9 28855 6
178073 189942 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014651.73587 2116280.65037 37.7917266570015 -122.393200349112 (37.7917266570015, -122.393200349112) 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
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
9688 52724 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160@ HOWARD Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2006 12:00:00 AM 7   Permit Number 48777 6014638.31432 2116297.63809 37.791772555711 -122.393247977227 (37.791772555711, -122.393247977227) 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
161020 189926 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013338.6063 2116192.95214 37.7914128215027 -122.397737648268 (37.7914128215027, -122.397737648268) 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
141155 189927 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013321.30985 2116211.38819 37.7914624793694 -122.3977987878 (37.7914624793694, -122.3977987878) 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
80002 189928 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013312.71119 2116223.04908 37.7914940185848 -122.397829357532 (37.7914940185848, -122.397829357532) 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
34204 189929 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013297.80377 2116238.25932 37.7915349521343 -122.397882004744 (37.7915349521343, -122.397882004744) 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
144602 189930 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013282.15015 2116252.99602 37.7915745438725 -122.397937200642 (37.7915745438725, -122.397937200642) 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
71028 189931 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013267.71842 2116267.46362 37.7916134647515 -122.397988149957 (37.7916134647515, -122.397988149957) 12 2 9 28855 6
156238 189936 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013261.48411 2116177.89779 37.7913671907995 -122.398003434816 (37.7913671907995, -122.398003434816) 12 2 9 28855 6
67119 189932 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013255.69526 2116279.68267 37.7916463457648 -122.398030607826 (37.7916463457648, -122.398030607826) 12 2 9 28855 6
60278 189935 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013248.49941 2116191.11402 37.791402756277 -122.398049289468 (37.791402756277, -122.398049289468) 12 2 9 28855 6
92390 189934 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013232.87553 2116207.31651 37.7914463743094 -122.398104485334 (37.7914463743094, -122.398104485334) 12 2 9 28855 6
1256 97187 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
42963 97180 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
103825 97186 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 8 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
110444 97188 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 10 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
124374 97181 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
127764 97182 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
157690 97185 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
158873 97183 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
111186 189933 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013208.14765 2116234.45684 37.7915195179644 -122.398191948892 (37.7915195179644, -122.398191948892) 12 2 9 28855 6
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

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