Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67080 | 67080 | 189835 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6015422.83464 | 2098030.46357 | 37.7416584290923 | -122.389257386733 | (37.7416584290923, -122.389257386733) | |||
| 161929 | 161929 | 189837 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015387.45837 | 2098059.88528 | 37.7417372537812 | -122.389381761177 | (37.7417372537812, -122.389381761177) | |||
| 176882 | 176882 | 189838 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 525 Phelps St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6015431.26911 | 2098152.3632900002 | 37.741993608228505 | -122.389236732886 | (37.7419936082285, -122.389236732886) | |||
| 35330 | 35330 | 125967 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3440 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 5998347.68841 | 2115559.3339299997 | 37.7888268704136 | -122.449560024485 | (37.7888268704136, -122.449560024485) | |||
| 40966 | 40966 | 125985 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6008371.27829 | 2121652.4837 | 37.8061254702907 | -122.415311214049 | (37.8061254702907, -122.415311214049) | |||
| 44097 | 44097 | 125986 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008368.52895 | 2121668.4711599997 | 37.8061692132974 | -122.415321861121 | (37.8061692132974, -122.415321861121) | |||
| 52501 | 52501 | 125984 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 6ft | 6008373.73288 | 2121637.11508 | 37.8060834098955 | -122.41530163086 | (37.8060834098955, -122.41530163086) | |||
| 56220 | 56220 | 125987 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6008367.52131 | 2121686.8739 | 37.8062196859398 | -122.415326651828 | (37.8062196859398, -122.415326651828) | |||
| 65182 | 65182 | 222899 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6005393.47694 | 2104277.7089299997 | 37.7582508111316 | -122.424379813902 | (37.7582508111316, -122.424379813902) | |||
| 69557 | 69557 | 205989 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.46305702188499 | (37.744370734026, -122.463057021885) | |||
| 74533 | 74533 | 222898 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2771 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 6009527.7031 | 2103333.9306400004 | 37.7558919964247 | -122.410015170384 | (37.7558919964247, -122.410015170384) | |||
| 129912 | 129912 | 225061 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 5997502.5049 | 2105021.0962900002 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | |||
| 136904 | 136904 | 125982 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008379.56749 | 2121591.49972 | 37.8059584895516 | -122.415278208017 | (37.8059584895516, -122.415278208017) | |||
| 188551 | 188551 | 125981 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008384.91577 | 2121552.17509 | 37.8058508146246 | -122.415256913874 | (37.8058508146246, -122.415256913874) | |||
| 4762 | 4762 | 188472 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6007955.34249 | 2108999.99523 | 37.7713614445082 | -122.41585412666099 | (37.7713614445082, -122.415854126661) | |||
| 4765 | 4765 | 188470 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | |||
| 4768 | 4768 | 188475 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6007904.0486 | 2109028.3939900002 | 37.7714365370061 | -122.41603356660299 | (37.7714365370061, -122.416033566603) | |||
| 4779 | 4779 | 188471 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6008055.90153 | 2108933.51614 | 37.7711845613454 | -122.41550157982799 | (37.7711845613454, -122.415501579828) | |||
| 4791 | 4791 | 188467 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008105.3532300005 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | |||
| 4806 | 4806 | 188473 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6007942.65601 | 2109006.33264 | 37.771378132318894 | -122.415898458759 | (37.7713781323189, -122.415898458759) | |||
| 4810 | 4810 | 188468 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6008096.35172 | 2108912.02487 | 37.7711278249234 | -122.415360138963 | (37.7711278249234, -122.415360138963) | |||
| 4814 | 4814 | 188469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6008084.262680001 | 2108917.7420900003 | 37.771142843604004 | -122.41540236032499 | (37.771142843604, -122.415402360325) | |||
| 4816 | 4816 | 188474 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007923.258880001 | 2109012.80714 | 37.7713948192467 | -122.41596601311599 | (37.7713948192467, -122.415966013116) | |||
| 23796 | 23796 | 189939 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013302.110780001 | 2116136.01551 | 37.7912544544909 | -122.397859927289 | (37.7912544544909, -122.397859927289) | |||
| 23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
| 24544 | 24544 | 189940 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013316.29733 | 2116121.5529099996 | 37.791215533629 | -122.39780982696001 | (37.791215533629, -122.39780982696) | |||
| 25032 | 25032 | 189928 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013312.71119 | 2116223.04908 | 37.79149401858479 | -122.397829357532 | (37.7914940185848, -122.397829357532) | |||
| 30049 | 30049 | 222884 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006058.1722800005 | 2109199.11331 | 37.7718013362 | -122.422430687153 | (37.7718013362, -122.422430687153) | |||
| 32837 | 32837 | 189922 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013429.98555 | 2116100.18474 | 37.791163192164 | -122.39741496705099 | (37.791163192164, -122.397414967051) | |||
| 36711 | 36711 | 189929 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013297.80377 | 2116238.25932 | 37.79153495213429 | -122.39788200474399 | (37.7915349521343, -122.397882004744) | |||
| 37108 | 37108 | 225085 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6004142.31119 | 2101495.14459 | 37.7505398125629 | -122.42850855554701 | (37.7505398125629, -122.428508555547) | |||
| 41181 | 41181 | 189938 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013289.37156 | 2116149.2267400003 | 37.7912900199673 | -122.39790493209101 | (37.7912900199673, -122.397904932091) | |||
| 42255 | 42255 | 189935 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013248.49941 | 2116191.11402 | 37.791402756277 | -122.398049289468 | (37.791402756277, -122.398049289468) | |||
| 42568 | 42568 | 189927 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013321.30985 | 2116211.3881900003 | 37.7914624793694 | -122.39779878780001 | (37.7914624793694, -122.3977987878) | |||
| 47121 | 47121 | 189917 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6013829.87851 | 2116068.4816 | 37.791098399616104 | -122.39602911715299 | (37.7910983996161, -122.396029117153) | |||
| 52899 | 52899 | 189933 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013208.14765 | 2116234.45684 | 37.791519517964396 | -122.398191948892 | (37.7915195179644, -122.398191948892) | |||
| 64996 | 64996 | 189923 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013419.15414 | 2116110.6688599996 | 37.7911913760301 | -122.397453179235 | (37.7911913760301, -122.397453179235) | |||
| 73397 | 73397 | 246510 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | |||
| 74030 | 74030 | 189936 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013261.48411 | 2116177.8977900003 | 37.7913671907995 | -122.398003434816 | (37.7913671907995, -122.398003434816) | |||
| 132027 | 132027 | 189931 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013267.71842 | 2116267.46362 | 37.7916134647515 | -122.397988149957 | (37.7916134647515, -122.397988149957) | |||
| 134675 | 134675 | 189932 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013255.6952599995 | 2116279.68267 | 37.791646345764796 | -122.398030607826 | (37.7916463457648, -122.398030607826) | |||
| 136532 | 136532 | 125983 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008377.32314 | 2121617.1276 | 37.8060287311026 | -122.415287790321 | (37.8060287311026, -122.415287790321) | |||
| 147048 | 147048 | 189921 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013437.412219999 | 2116091.23603 | 37.791139034597705 | -122.397388642991 | (37.7911390345977, -122.397388642991) | |||
| 148488 | 148488 | 189918 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6013810.73123 | 2116050.81938 | 37.7910488379738 | -122.396094128247 | (37.7910488379738, -122.396094128247) | |||
| 155986 | 155986 | 189924 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013405.38871 | 2116121.70148 | 37.7912209025705 | -122.39750158162799 | (37.7912209025705, -122.397501581628) | |||
| 163848 | 163848 | 189937 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013275.69539 | 2116164.65668 | 37.7913316253015 | -122.397953334494 | (37.7913316253015, -122.397953334494) | |||
| 167348 | 167348 | 225101 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 75 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6006050.3801 | 2109334.27291 | 37.7721720124675 | -122.42246724636601 | (37.7721720124675, -122.422467246366) | |||
| 167856 | 167856 | 189934 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013232.87553 | 2116207.31651 | 37.791446374309395 | -122.398104485334 | (37.7914463743094, -122.398104485334) | |||
| 170578 | 170578 | 189925 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013397.06496 | 2116134.8231200003 | 37.7912564680486 | -122.397531302439 | (37.7912564680486, -122.397531302439) | |||
| 174407 | 174407 | 222887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.42876750091801 | (37.77173547164, -122.428767500918) | |||
| 178093 | 178093 | 189926 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013338.6063 | 2116192.95214 | 37.7914128215027 | -122.39773764826799 | (37.7914128215027, -122.397737648268) | |||
| 180285 | 180285 | 189941 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013331.4553 | 2116106.58194 | 37.7911752709767 | -122.39775632990299 | (37.7911752709767, -122.397756329903) | |||
| 180519 | 180519 | 225100 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 75 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6006056.75092 | 2109200.3154 | 37.7718045566698 | -122.422435689168 | (37.7718045566698, -122.422435689168) | |||
| 180715 | 180715 | 189930 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013282.15015 | 2116252.99602 | 37.7915745438725 | -122.39793720064199 | (37.7915745438725, -122.397937200642) | |||
| 1249 | 1249 | 237914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 5997227.0 | 2107052.0 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | |||
| 1440 | 1440 | 222893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 301 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6004914.2278 | 2106488.73534 | 37.7642946914815 | -122.426194676362 | (37.7642946914815, -122.426194676362) | |||
| 3231 | 3231 | 188482 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 3 | : 4 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | ||
| 3892 | 3892 | 222929 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 23379 | 23379 | 222925 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998825.08997 | 2106348.09575 | 37.763562478748604 | -122.44724507779499 | (37.7635624787486, -122.447245077795) | |||
| 23831 | 23831 | 126000 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6007902.73328 | 2121542.33791 | 37.805796693425705 | -122.41692488738501 | (37.8057966934257, -122.416924887385) | |||
| 23898 | 23898 | 246421 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6003840.654080001 | 2099855.1968900003 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | |||
| 24219 | 24219 | 189857 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | |||
| 25692 | 25692 | 222915 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6004287.81752 | 2109130.32918 | 37.7715124442731 | -122.42854956011999 | (37.7715124442731, -122.42854956012) | |||
| 26990 | 26990 | 222896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6006441.81181 | 2107164.43854 | 37.76623623692421 | -122.420959163358 | (37.7662362369242, -122.420959163358) | |||
| 27876 | 27876 | 222922 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998725.13711 | 2107078.63003 | 37.7655626303238 | -122.44764337315 | (37.7655626303238, -122.44764337315) | |||
| 28090 | 28090 | 189890 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6016847.575680001 | 2098318.03852 | 37.742526934071 | -122.384351086743 | (37.742526934071, -122.384351086743) | |||
| 28181 | 28181 | 126002 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007897.34981 | 2121579.9870599997 | 37.805899765629704 | -122.41694618692699 | (37.8058997656297, -122.416946186927) | |||
| 28582 | 28582 | 222901 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2500 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010350.927680001 | 2105070.60578 | 37.760706622229705 | -122.407290598708 | (37.7607066222297, -122.407290598708) | |||
| 32351 | 32351 | 189916 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1771 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6013954.80906 | 2095907.8137599998 | 37.7357485783226 | -122.394184791988 | (37.7357485783226, -122.394184791988) | |||
| 32636 | 32636 | 222888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 109 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004218.0 | 2109157.0 | 37.771581724556604 | -122.428792964354 | (37.7715817245566, -122.428792964354) | |||
| 33190 | 33190 | 189849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6017283.17469 | 2098125.85242 | 37.742023306530704 | -122.38283152746 | (37.7420233065307, -122.38283152746) | |||
| 33581 | 33581 | 222905 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6004739.789609999 | 2109820.49268 | 37.7734330328342 | -122.427035328438 | (37.7734330328342, -122.427035328438) | |||
| 34241 | 34241 | 125971 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6008148.4886 | 2112831.1491900003 | 37.7818917385495 | -122.415457300812 | (37.7818917385495, -122.415457300812) | |||
| 34932 | 34932 | 222909 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004826.79581 | 2109830.90843 | 37.7734665514719 | -122.426735103265 | (37.7734665514719, -122.426735103265) | |||
| 35702 | 35702 | 189866 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6016000.66321 | 2097804.14137 | 37.7410690116125 | -122.3872436482 | (37.7410690116125, -122.3872436482) | |||
| 35726 | 35726 | 222928 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 912 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998758.16977 | 2106859.07637 | 37.764961679071796 | -122.447513315894 | (37.7649616790718, -122.447513315894) | |||
| 35881 | 35881 | 225050 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | |||
| 37675 | 37675 | 225057 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | |||
| 38071 | 38071 | 125966 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2198 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6002473.45784 | 2118854.30827 | 37.7981091788388 | -122.435521270088 | (37.7981091788388, -122.435521270088) | |||
| 39568 | 39568 | 125980 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008387.31056 | 2121533.89692 | 37.8058007619722 | -122.415247331605 | (37.8058007619722, -122.415247331605) | |||
| 42880 | 42880 | 222907 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004783.41695 | 2109826.60113 | 37.773452272033296 | -122.426884850272 | (37.7734522720333, -122.426884850272) | |||
| 44243 | 44243 | 189896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6016683.25153 | 2098348.88465 | 37.7426025436648 | -122.38492142508899 | (37.7426025436648, -122.384921425089) | |||
| 48972 | 48972 | 222916 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004301.92294 | 2109033.13825 | 37.7712463798496 | -122.42849383993601 | (37.7712463798496, -122.428493839936) | |||
| 50893 | 50893 | 189872 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6015960.56064 | 2097835.58742 | 37.741153135100205 | -122.387384502698 | (37.7411531351002, -122.387384502698) | |||
| 55625 | 55625 | 225059 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 245 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5997024.32382 | 2107012.23049 | 37.7652829636624 | -122.453521279988 | (37.7652829636624, -122.453521279988) | |||
| 56798 | 56798 | 189836 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 9 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015406.79125 | 2098034.46628 | 37.741668530275604 | -122.389313139314 | (37.7416685302756, -122.389313139314) | |||
| 56807 | 56807 | 222910 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6004846.32395 | 2109834.20253 | 37.7734767003282 | -122.426667787188 | (37.7734767003282, -122.426667787188) | |||
| 59090 | 59090 | 189955 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 145 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014561.092019999 | 2115949.59191 | 37.790812611275 | -122.39349079958299 | (37.790812611275, -122.393490799583) | |||
| 60139 | 60139 | 246422 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.746018144524605 | -122.429473817668 | (37.7460181445246, -122.429473817668) | |||
| 60413 | 60413 | 125996 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007913.10752 | 2121457.27998 | 37.8055637294392 | -122.41688295558001 | (37.8055637294392, -122.41688295558) | |||
| 61924 | 61924 | 126001 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007899.07258 | 2121560.79928 | 37.8058471777553 | -122.41693886466001 | (37.8058471777553, -122.41693886466) | |||
| 63863 | 63863 | 189858 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6017192.206809999 | 2098235.0383900004 | 37.7423180827181 | -122.38315366643499 | (37.7423180827181, -122.383153666435) | |||
| 67137 | 67137 | 125997 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6007910.60432 | 2121475.9089200003 | 37.8056147389887 | -122.416892938958 | (37.8056147389887, -122.416892938958) | |||
| 67983 | 67983 | 225046 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 901 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009412.500080001 | 2103884.6672799997 | 37.757397737644204 | -122.41045246843001 | (37.7573977376442, -122.41045246843) | |||
| 68238 | 68238 | 222920 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 957 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998076.5165 | 2106905.9783799998 | 37.765051481758 | -122.449874352843 | (37.765051481758, -122.449874352843) | |||
| 70834 | 70834 | 125999 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007905.9664 | 2121521.7786 | 37.8057404246312 | -122.41691224110399 | (37.8057404246312, -122.416912241104) | |||
| 71127 | 71127 | 222923 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 88 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998162.74598 | 2106870.63901 | 37.764959382183704 | -122.449573561064 | (37.7649593821837, -122.449573561064) | |||
| 71480 | 71480 | 125970 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2301 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6003734.22562 | 2115934.13704 | 37.7901626613254 | -122.430950126753 | (37.7901626613254, -122.430950126753) | |||
| 71925 | 71925 | 126003 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6007892.3710199995 | 2121599.81603 | 37.80595393089521 | -122.41696482266501 | (37.8059539308952, -122.416964822665) | |||
| 72741 | 72741 | 175840 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 658 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002330.91523 | 2089965.9471 | 37.7187806097236 | -122.433948484453 | (37.7187806097236, -122.433948484453) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");