trees
856 rows where qSpecies_id = 5 sorted by PlotSize 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90694 | 189838 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 525 Phelps St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015431.26911 | 2098152.36329 | 37.7419936082285 | -122.389236732886 | (37.7419936082285, -122.389236732886) | 10 | 3 | 8 | 58 | 1 | |||
173944 | 189837 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015387.45837 | 2098059.88528 | 37.7417372537812 | -122.389381761177 | (37.7417372537812, -122.389381761177) | 10 | 3 | 8 | 58 | 1 | |||
189953 | 189835 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015422.83464 | 2098030.46357 | 37.7416584290923 | -122.389257386733 | (37.7416584290923, -122.389257386733) | 10 | 3 | 8 | 58 | 1 | |||
30477 | 222899 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005393.47694 | 2104277.70893 | 37.7582508111316 | -122.424379813902 | (37.7582508111316, -122.424379813902) | 2 | 4 | 5 | 28859 | 19 | |||
38272 | 125985 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6008371.27829 | 2121652.4837 | 37.8061254702907 | -122.415311214049 | (37.8061254702907, -122.415311214049) | 5 | 1 | 10 | 308 | 23 | |||
59975 | 125986 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008368.52895 | 2121668.47116 | 37.8061692132974 | -122.415321861121 | (37.8061692132974, -122.415321861121) | 5 | 1 | 10 | 308 | 23 | |||
67416 | 125984 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 6ft | 6008373.73288 | 2121637.11508 | 37.8060834098955 | -122.41530163086 | (37.8060834098955, -122.41530163086) | 5 | 1 | 10 | 308 | 23 | |||
76986 | 205989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.463057021885 | (37.744370734026, -122.463057021885) | 1 | 8 | 4 | 29491 | 40 | |||
79309 | 125987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6008367.52131 | 2121686.8739 | 37.8062196859398 | -122.415326651828 | (37.8062196859398, -122.415326651828) | 5 | 1 | 10 | 308 | 23 | |||
101361 | 222898 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2771 22nd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 6009527.7031 | 2103333.93064 | 37.7558919964247 | -122.410015170384 | (37.7558919964247, -122.410015170384) | 2 | 4 | 7 | 28859 | 19 | |||
107672 | 125981 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008384.91577 | 2121552.17509 | 37.8058508146246 | -122.415256913874 | (37.8058508146246, -122.415256913874) | 5 | 1 | 10 | 308 | 23 | |||
111120 | 225061 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 5997502.5049 | 2105021.09629 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | 15 | 5 | 11 | 29492 | 12 | |||
124920 | 125982 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008379.56749 | 2121591.49972 | 37.8059584895516 | -122.415278208017 | (37.8059584895516, -122.415278208017) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
12741 | 188474 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6007923.25888 | 2109012.80714 | 37.7713948192467 | -122.415966013116 | (37.7713948192467, -122.415966013116) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
26958 | 188469 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6008084.26268 | 2108917.74209 | 37.771142843604 | -122.415402360325 | (37.771142843604, -122.415402360325) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
49432 | 222887 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 123 Webster St | 1 | : | Tree | Private 2 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.428767500918 | (37.77173547164, -122.428767500918) | 7 | 9 | 11 | 29492 | 10 | |||
52787 | 222885 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Valencia St | 3 | : | Tree | Private 2 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
61480 | 246510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
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 | |||
76472 | 225100 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006056.75092 | 2109200.3154 | 37.7718045566698 | -122.422435689168 | (37.7718045566698, -122.422435689168) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
86068 | 188467 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6008105.35323 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
89800 | 188471 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6008055.90153 | 2108933.51614 | 37.7711845613454 | -122.415501579828 | (37.7711845613454, -122.415501579828) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
107019 | 225101 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006050.3801 | 2109334.27291 | 37.7721720124675 | -122.422467246366 | (37.7721720124675, -122.422467246366) | 8 | 2 | 9 | 28853 | 19 | |||
108171 | 188473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6007942.65601 | 2109006.33264 | 37.7713781323189 | -122.415898458759 | (37.7713781323189, -122.415898458759) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
125848 | 125983 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6008377.32314 | 2121617.1276 | 37.8060287311026 | -122.415287790321 | (37.8060287311026, -122.415287790321) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
141672 | 188475 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6007904.0486 | 2109028.39399 | 37.7714365370061 | -122.416033566603 | (37.7714365370061, -122.416033566603) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
165805 | 188470 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | 8 | 2 | 9 | 28853 | 19 | |||
166336 | 188472 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6007955.34249 | 2108999.99523 | 37.7713614445082 | -122.415854126661 | (37.7713614445082, -122.415854126661) | 8 | 2 | 9 | 28853 | 19 | |||
182345 | 222884 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Valencia St | 1 | : | Tree | Private 2 | 18 | Width 5ft | 6006058.17228 | 2109199.11331 | 37.7718013362 | -122.422430687153 | (37.7718013362, -122.422430687153) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
183287 | 188468 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6008096.35172 | 2108912.02487 | 37.7711278249234 | -122.415360138963 | (37.7711278249234, -122.415360138963) | 8 | 2 | 9 | 28853 | 19 | |||
193471 | 225085 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6004142.31119 | 2101495.14459 | 37.7505398125629 | -122.428508555547 | (37.7505398125629, -122.428508555547) | 2 | 4 | 5 | 28862 | 22 | |||
640 | 222906 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004761.72453 | 2109824.22026 | 37.7734445081828 | -122.42695971791 | (37.7734445081828, -122.42695971791) | 7 | 9 | 11 | 28852 | 10 | |||
4441 | 246422 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.7460181445246 | -122.429473817668 | (37.7460181445246, -122.429473817668) | 2 | 7 | 5 | 63 | 22 | |||
8125 | 189865 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6015985.7864 | 2097784.98338 | 37.7410155838051 | -122.387293751216 | (37.7410155838051, -122.387293751216) | 10 | 3 | 8 | 58 | 1 | |||
9018 | 126003 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6007892.37102 | 2121599.81603 | 37.8059539308952 | -122.416964822665 | (37.8059539308952, -122.416964822665) | 5 | 1 | 10 | 308 | 23 | |||
10434 | 189892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 6 | : | Tree | Private 2 | 13 | Width 4ft | 6016806.72009 | 2098324.89991 | 37.7425435148768 | -122.384492832481 | (37.7425435148768, -122.384492832481) | 10 | 3 | 8 | 58 | 1 | |||
15607 | 189834 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 4 | : | Tree | Private 2 | 14 | Width 4ft | 6015429.09406 | 2098017.0802 | 37.7416220281222 | -122.389234809264 | (37.7416220281222, -122.389234809264) | 10 | 3 | 8 | 58 | 1 | |||
16205 | 222929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 10 | Width 4ft | Permit Number 17592 | 5999199.8898 | 2106672.6396 | 37.7644750037296 | -122.445972112616 | (37.7644750037296, -122.445972112616) | 15 | 5 | 11 | 29492 | 9 | |
16559 | 222925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998825.08997 | 2106348.09575 | 37.7635624787486 | -122.447245077795 | (37.7635624787486, -122.447245077795) | 15 | 5 | 11 | 29492 | 9 | |||
18852 | 222928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998758.16977 | 2106859.07637 | 37.7649616790718 | -122.447513315894 | (37.7649616790718, -122.447513315894) | 15 | 5 | 11 | 29492 | 9 | |||
26621 | 222916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004301.92294 | 2109033.13825 | 37.7712463798496 | -122.428493839936 | (37.7712463798496, -122.428493839936) | 7 | 9 | 11 | 28852 | 10 | |||
31579 | 225050 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 24 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | 2 | 7 | 5 | 63 | 22 | |||
32299 | 222920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998076.5165 | 2106905.97838 | 37.765051481758 | -122.449874352843 | (37.765051481758, -122.449874352843) | 15 | 5 | 11 | 29492 | 9 | |||
35932 | 222922 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998725.13711 | 2107078.63003 | 37.7655626303238 | -122.44764337315 | (37.7655626303238, -122.44764337315) | 15 | 5 | 11 | 29492 | 9 | |||
37876 | 125979 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.8057422979318 | -122.41523987894 | (37.8057422979318, -122.41523987894) | 5 | 1 | 10 | 308 | 23 | |||
41601 | 222917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 88 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6004303.69708 | 2109018.65394 | 37.7712067098536 | -122.428486670528 | (37.7712067098536, -122.428486670528) | 7 | 9 | 11 | 28852 | 10 | |||
47090 | 222910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004846.32395 | 2109834.20253 | 37.7734767003282 | -122.426667787188 | (37.7734767003282, -122.426667787188) | 7 | 9 | 11 | 28852 | 10 | |||
48751 | 189873 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Newhall St | 13 | : | Tree | Private 2 | 13 | Width 4ft | 6015949.19552 | 2097817.31467 | 37.7411023324162 | -122.387422525146 | (37.7411023324162, -122.387422525146) | 10 | 3 | 8 | 58 | 1 | |||
52442 | 188480 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 209 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012920.54855 | 2106035.89651 | 37.7635005775036 | -122.398471110175 | (37.7635005775036, -122.398471110175) | 14 | 3 | 8 | 28856 | 29 | |||
55436 | 126001 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007899.07258 | 2121560.79928 | 37.8058471777553 | -122.41693886466 | (37.8058471777553, -122.41693886466) | 5 | 1 | 10 | 308 | 23 | |||
56518 | 237914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 4ft | 5997227 | 2107052 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | 15 | 5 | 11 | 29492 | 12 | |||
57257 | 189907 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6016312.90853 | 2098309.60993 | 37.7424742122044 | -122.386199237601 | (37.7424742122044, -122.386199237601) | 10 | 3 | 8 | 58 | 1 | |||
60894 | 246420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.429398275524 | (37.7460188154337, -122.429398275524) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
63609 | 222900 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3733 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005413.47026 | 2104278.82733 | 37.7582550109751 | -122.424310747749 | (37.7582550109751, -122.424310747749) | 2 | 4 | 5 | 28859 | 19 | |||
64795 | 225045 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 881 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009145.12233 | 2103987.25914 | 37.7576644387915 | -122.411384417877 | (37.7576644387915, -122.411384417877) | 2 | 4 | 7 | 28859 | 19 | |||
65426 | 189896 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 3 | : | Tree | Private 2 | 14 | Width 4ft | 6016683.25153 | 2098348.88465 | 37.7426025436648 | -122.384921425089 | (37.7426025436648, -122.384921425089) | 10 | 3 | 8 | 58 | 1 | |||
66277 | 222890 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009529.18788 | 2103922.95806 | 37.757509416346 | -122.4100516172 | (37.757509416346, -122.4100516172) | 2 | 4 | 7 | 28859 | 19 | |||
67065 | 222911 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004864.94155 | 2109835.08183 | 37.7734801672159 | -122.426603448797 | (37.7734801672159, -122.426603448797) | 7 | 9 | 11 | 28852 | 10 | |||
67696 | 189866 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 3 | : | Tree | Private 2 | 11 | Width 4ft | 6016000.66321 | 2097804.14137 | 37.7410690116125 | -122.3872436482 | (37.7410690116125, -122.3872436482) | 10 | 3 | 8 | 58 | 1 | |||
67782 | 125998 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
69905 | 222921 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5998078.46928 | 2106885.24351 | 37.7649946607859 | -122.449866104246 | (37.7649946607859, -122.449866104246) | 15 | 5 | 11 | 29492 | 9 | |||
71557 | 125966 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2198 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6002473.45784 | 2118854.30827 | 37.7981091788388 | -122.435521270088 | (37.7981091788388, -122.435521270088) | 13 | 9 | 1 | 57 | 17 | |||
72128 | 225047 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 971 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009431.36633 | 2103539.27108 | 37.7564504151646 | -122.410362833886 | (37.7564504151646, -122.410362833886) | 2 | 4 | 7 | 28859 | 19 | |||
75395 | 125996 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007913.10752 | 2121457.27998 | 37.8055637294392 | -122.41688295558 | (37.8055637294392, -122.41688295558) | 5 | 1 | 10 | 308 | 23 | |||
75632 | 188488 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 8 | : | Tree | Private 2 | 8 | Width 4ft | 6016697.4652 | 2098710.93051 | 37.7435974339762 | -122.384897495043 | (37.7435974339762, -122.384897495043) | 10 | 3 | 8 | 58 | 1 | |||
77058 | 222893 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 301 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | Width 4ft | 6004914.2278 | 2106488.73534 | 37.7642946914815 | -122.426194676362 | (37.7642946914815, -122.426194676362) | 8 | 4 | 5 | 28859 | 19 | |||
83845 | 189890 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 4 | : | Tree | Private 2 | 10 | Width 4ft | 6016847.57568 | 2098318.03852 | 37.742526934071 | -122.384351086743 | (37.742526934071, -122.384351086743) | 10 | 3 | 8 | 58 | 1 | |||
87824 | 125999 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007905.9664 | 2121521.7786 | 37.8057404246312 | -122.416912241104 | (37.8057404246312, -122.416912241104) | 5 | 1 | 10 | 308 | 23 | |||
95691 | 225059 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 245 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5997024.32382 | 2107012.23049 | 37.7652829636624 | -122.453521279988 | (37.7652829636624, -122.453521279988) | 15 | 5 | 11 | 29492 | 12 | |||
96630 | 222908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004803.10417 | 2109829.19919 | 37.773460518813 | -122.426816934368 | (37.773460518813, -122.426816934368) | 7 | 9 | 11 | 28852 | 10 | |||
98799 | 126000 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007902.73328 | 2121542.33791 | 37.8057966934257 | -122.416924887385 | (37.8057966934257, -122.416924887385) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
104673 | 222889 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 81 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004268.74767 | 2108942.84192 | 37.7709965706599 | -122.428602156987 | (37.7709965706599, -122.428602156987) | 7 | 9 | 11 | 29492 | 10 | |||
108597 | 189872 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Newhall St | 12 | : | Tree | Private 2 | 17 | Width 4ft | 6015960.56064 | 2097835.58742 | 37.7411531351002 | -122.387384502698 | (37.7411531351002, -122.387384502698) | 10 | 3 | 8 | 58 | 1 | |||
110010 | 222924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998822.08068 | 2106365.67219 | 37.763610567293 | -122.447256751019 | (37.763610567293, -122.447256751019) | 15 | 5 | 11 | 29492 | 9 |
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) );