Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188870 | 188870 | 189960 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010412.08756 | 2108524.3089900003 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) | |||
| 188742 | 188742 | 246420 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.42939827552401 | (37.7460188154337, -122.429398275524) | |||
| 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) | |||
| 188434 | 188434 | 125994 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008347.52133 | 2121476.34798 | 37.805640510859206 | -122.41538095198901 | (37.8056405108592, -122.415380951989) | |||
| 188391 | 188391 | 225051 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000881.81518 | 2102275.99981 | 37.752498802180796 | -122.439839555559 | (37.7524988021808, -122.439839555559) | |||
| 188116 | 188116 | 222897 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2771 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009509.00989 | 2103333.0296099996 | 37.7558884746751 | -122.41007975427 | (37.7558884746751, -122.41007975427) | |||
| 187567 | 187567 | 218314 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 437 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5993129.70143 | 2099920.62697 | 37.7455872325622 | -122.466476271275 | (37.7455872325622, -122.466476271275) | |||
| 187471 | 187471 | 189892 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6016806.72009 | 2098324.8999099997 | 37.74254351487679 | -122.384492832481 | (37.7425435148768, -122.384492832481) | |||
| 186595 | 186595 | 206002 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1593 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991725.37276 | 2104496.31776 | 37.758069753342205 | -122.47166556633199 | (37.7580697533422, -122.471665566332) | |||
| 185981 | 185981 | 189906 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6016329.85018 | 2098328.36686 | 37.742526652587706 | -122.386141965188 | (37.7425266525877, -122.386141965188) | |||
| 185909 | 185909 | 57320 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2728 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 15 | Permit Number 16145 | 5999531.6355 | 2114001.5838 | 37.7846173544843 | -122.445351698652 | (37.7846173544843, -122.445351698652) | ||
| 185704 | 185704 | 188476 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 499 San Bruno Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6010896.57818 | 2106030.2080599996 | 37.763371997828706 | -122.405471012994 | (37.7633719978287, -122.405471012994) | |||
| 185355 | 185355 | 225064 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 253 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998981.0777900005 | 2106664.05961 | 37.7644389481338 | -122.446728303069 | (37.7644389481338, -122.446728303069) | |||
| 185308 | 185308 | 248230 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 74 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006935.57349 | 2099151.82262 | 37.7442632551522 | -122.418683056597 | (37.7442632551522, -122.418683056597) | |||
| 184467 | 184467 | 140578 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003397.0361 | 2111670.2009 | 37.778435854356104 | -122.431812198827 | (37.7784358543561, -122.431812198827) | |||
| 184302 | 184302 | 189844 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017173.06513 | 2098183.08322 | 37.742174366561606 | -122.383216237654 | (37.7421743665616, -122.383216237654) | |||
| 184225 | 184225 | 222889 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 81 Webster St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6004268.7476699995 | 2108942.84192 | 37.7709965706599 | -122.428602156987 | (37.7709965706599, -122.428602156987) | |||
| 184149 | 184149 | 225054 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 342 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6001139.36381 | 2096693.2959599998 | 37.7371846769336 | -122.438548945674 | (37.7371846769336, -122.438548945674) | |||
| 184090 | 184090 | 93110 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.548880001 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | |
| 184060 | 184060 | 248231 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 80 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006921.48329 | 2099128.86154 | 37.74419941586729 | -122.41873014957599 | (37.7441994158673, -122.418730149576) | |||
| 183547 | 183547 | 248276 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.41927801298401 | (37.7431956465585, -122.419278012984) | |||
| 182826 | 182826 | 225078 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2844 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6009189.802619999 | 2103948.11037 | 37.7575594510339 | -122.41122712912599 | (37.7575594510339, -122.411227129126) | |||
| 182504 | 182504 | 189867 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016089.46635 | 2097928.7080599996 | 37.7414159637784 | -122.38694528191999 | (37.7414159637784, -122.38694528192) | |||
| 182276 | 182276 | 106027 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 11 | 3x3 | Permit Number 770222 | 6014665.819209999 | 2115987.9153400003 | 37.7909236568574 | -122.393131128317 | (37.7909236568574, -122.393131128317) | |
| 182201 | 182201 | 125976 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | |||
| 182071 | 182071 | 222886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Webster St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | |||
| 181328 | 181328 | 189963 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1000 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6010349.36768 | 2108372.96344 | 37.7697740574441 | -122.40752882731 | (37.7697740574441, -122.40752882731) | |||
| 181222 | 181222 | 248199 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698121999 | (37.7440974516285, -122.41868698122) | |||
| 181190 | 181190 | 189878 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016474.87335 | 2098336.17477 | 37.742556117060104 | -122.38564105721399 | (37.7425561170601, -122.385641057214) | |||
| 180722 | 180722 | 125998 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | |||
| 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) | |||
| 180608 | 180608 | 225049 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 6002919.63953 | 2100068.3028700002 | 37.7465527734974 | -122.432634735922 | (37.7465527734974, -122.432634735922) | |||
| 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) | |||
| 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) | |||
| 179956 | 179956 | 189952 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6014715.63981 | 2116037.4080000003 | 37.7910623197318 | -122.392962214036 | (37.7910623197318, -122.392962214036) | |||
| 179431 | 179431 | 189853 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.742069463331106 | -122.382594511142 | (37.7420694633311, -122.382594511142) | |||
| 179366 | 179366 | 188486 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6016667.7961 | 2098739.5766 | 37.7436744492327 | -122.385002079878 | (37.7436744492327, -122.385002079878) | |||
| 179238 | 179238 | 248257 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.41920489088899 | (37.7434438819296, -122.419204890889) | |||
| 179078 | 179078 | 222900 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3733 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005413.47026 | 2104278.82733 | 37.758255010975105 | -122.424310747749 | (37.7582550109751, -122.424310747749) | |||
| 178915 | 178915 | 189920 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013751.034659999 | 2115995.6768400003 | 37.790894107822794 | -122.396296811166 | (37.7908941078228, -122.396296811166) | |||
| 178681 | 178681 | 222912 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004886.98291 | 2109837.9956900002 | 37.773489414027296 | -122.42652741201 | (37.7734894140273, -122.42652741201) | |||
| 178420 | 178420 | 225055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | |||
| 178399 | 178399 | 222892 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2751 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6009588.6552 | 2103924.1994 | 37.757516157658294 | -122.40984604206899 | (37.7575161576583, -122.409846042069) | |||
| 178393 | 178393 | 225075 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3334 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007507.05129 | 2101513.0888099996 | 37.750778919809 | -122.416874263658 | (37.750778919809, -122.416874263658) | |||
| 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) | |||
| 177491 | 177491 | 222921 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 957 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5998078.46928 | 2106885.24351 | 37.7649946607859 | -122.44986610424601 | (37.7649946607859, -122.449866104246) | |||
| 177476 | 177476 | 32581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1314 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37055 | 5985876.1437 | 2106257.7648 | 37.762566049362704 | -122.492024105228 | (37.7625660493627, -122.492024105228) | |
| 177272 | 177272 | 115849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003588.62501 | 2120788.7376599996 | 37.803483892518294 | -122.43180065966801 | (37.8034838925183, -122.431800659668) | |||
| 177140 | 177140 | 225077 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2862 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6009020.65891 | 2103938.13075 | 37.7575225617285 | -122.411811393486 | (37.7575225617285, -122.411811393486) | |||
| 176954 | 176954 | 106030 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6014615.46906 | 2115943.46238 | 37.790798802166 | -122.393302227016 | (37.790798802166, -122.393302227016) | |||
| 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) | |||
| 176670 | 176670 | 175843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 154 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004555.98826 | 2092507.33419 | 37.7258847232758 | -122.42643814711501 | (37.7258847232758, -122.426438147115) | |||
| 176629 | 176629 | 248202 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 51 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006954.7875 | 2099136.48348 | 37.7442222190818 | -122.418615530989 | (37.7442222190818, -122.418615530989) | |||
| 176560 | 176560 | 205994 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 334 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994253.11993 | 2101023.44894 | 37.7486800649323 | -122.462671676761 | (37.7486800649323, -122.462671676761) | |||
| 176531 | 176531 | 248253 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006804.331590001 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | |||
| 175928 | 175928 | 125977 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008401.628880001 | 2121444.29683 | 37.8055555474172 | -122.415191434251 | (37.8055555474172, -122.415191434251) | |||
| 175776 | 175776 | 85255 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 49553 | 6013503.0525 | 2116024.16318 | 37.7909585226636 | -122.39715682295 | (37.7909585226636, -122.39715682295) | |||
| 175525 | 175525 | 139056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2693 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999748.2433 | 2113980.0087 | 37.7845704772917 | -122.44460075979201 | (37.7845704772917, -122.444600759792) | |||
| 175453 | 175453 | 189874 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 14 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6015935.20003 | 2097800.22723 | 37.741054638653004 | -122.387469725156 | (37.741054638653, -122.387469725156) | |||
| 175276 | 175276 | 139007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999691.7088 | 2114071.461 | 37.78481835543629 | -122.444802925313 | (37.7848183554363, -122.444802925313) | |||
| 174977 | 174977 | 225091 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | |||
| 174972 | 174972 | 125992 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008341.11218 | 2121531.47257 | 37.8057915088426 | -122.41540703681801 | (37.8057915088426, -122.415407036818) | |||
| 174929 | 174929 | 125978 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008392.85025 | 2121496.40648 | 37.8056981340166 | -122.415225505068 | (37.8056981340166, -122.415225505068) | |||
| 174828 | 174828 | 125988 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008319.39655 | 2121673.00017 | 37.806178887323 | -122.41549221341101 | (37.806178887323, -122.415492213411) | |||
| 174686 | 174686 | 199696 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | |||
| 174584 | 174584 | 222924 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998822.080680001 | 2106365.6721900003 | 37.763610567293 | -122.447256751019 | (37.763610567293, -122.447256751019) | |||
| 174545 | 174545 | 205998 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998781.20203 | 2096512.5772400002 | 37.736554040821204 | -122.446689155601 | (37.7365540408212, -122.446689155601) | |||
| 174435 | 174435 | 222926 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998842.04298 | 2106555.36385 | 37.7641325536076 | -122.447201360861 | (37.7641325536076, -122.447201360861) | |||
| 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) | |||
| 174264 | 174264 | 115842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6003573.215530001 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | |||
| 173975 | 173975 | 189914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013894.185819999 | 2094452.33408 | 37.7317487598799 | -122.394292519091 | (37.7317487598799, -122.394292519091) | |||
| 173621 | 173621 | 189899 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6016506.94741 | 2098386.01279 | 37.7426947367801 | -122.385533625971 | (37.7426947367801, -122.385533625971) | |||
| 173588 | 173588 | 189854 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6017283.71117 | 2098187.47887 | 37.742192549946104 | -122.38283396012599 | (37.7421925499461, -122.382833960126) | |||
| 173011 | 173011 | 189946 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 162 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 6014709.0415900005 | 2116225.6637 | 37.7915788597386 | -122.39299822110901 | (37.7915788597386, -122.392998221109) | |||
| 172679 | 172679 | 248207 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 39 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007026.812390001 | 2099268.29908 | 37.7445882098712 | -122.41837582837601 | (37.7445882098712, -122.418375828376) | |||
| 172191 | 172191 | 206010 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990906.39798 | 2097737.17838 | 37.7394635005399 | -122.47400476141199 | (37.7394635005399, -122.474004761412) | |||
| 171108 | 171108 | 206012 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990870.16608 | 2097736.47672 | 37.739459475161794 | -122.474129983014 | (37.7394594751618, -122.474129983014) | |||
| 171008 | 171008 | 119740 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6013460.477580001 | 2116066.8176700003 | 37.791073271674705 | -122.397307123936 | (37.7910732716747, -122.397307123936) | ||||
| 170749 | 170749 | 189944 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 162 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014676.15778 | 2116259.76194 | 37.791670658917106 | -122.393114386531 | (37.7916706589171, -122.393114386531) | |||
| 170703 | 170703 | 189886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 201 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016892.13311 | 2098254.09694 | 37.7423538271607 | -122.384192566831 | (37.7423538271607, -122.384192566831) | |||
| 170676 | 170676 | 189907 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6016312.908530001 | 2098309.60993 | 37.7424742122044 | -122.38619923760099 | (37.7424742122044, -122.386199237601) | |||
| 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) | |||
| 170271 | 170271 | 225047 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 971 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009431.366330001 | 2103539.27108 | 37.7564504151646 | -122.410362833886 | (37.7564504151646, -122.410362833886) | |||
| 169791 | 169791 | 125979 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.80574229793179 | -122.41523987893999 | (37.8057422979318, -122.41523987894) | |||
| 169707 | 169707 | 57317 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2706 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16141 | 5999606.4685 | 2114016.4513 | 37.7846624482509 | -122.44509387174801 | (37.7846624482509, -122.445093871748) | ||
| 169467 | 169467 | 189954 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 145 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014570.20304 | 2115942.2831 | 37.7907930492013 | -122.393458763924 | (37.7907930492013, -122.393458763924) | |||
| 169210 | 169210 | 52724 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 160@ HOWARD Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 7 | Permit Number 48777 | 6014638.31432 | 2116297.63809 | 37.791772555711 | -122.393247977227 | (37.791772555711, -122.393247977227) | ||
| 168692 | 168692 | 205988 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1469 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993333.43827 | 2105504.18267 | 37.7609299931406 | -122.46617747513099 | (37.7609299931406, -122.466177475131) | |||
| 168386 | 168386 | 189904 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 3ft | 6016400.23461 | 2098374.6941 | 37.742657753052505 | -122.38590182282499 | (37.7426577530525, -122.385901822825) | |||
| 168105 | 168105 | 189908 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 3ft | 6016294.30511 | 2098287.7036099997 | 37.7424130322313 | -122.38626203636998 | (37.7424130322313, -122.38626203637) | |||
| 168072 | 168072 | 115848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003586.42591 | 2120801.53952 | 37.8035189184231 | -122.43180918435499 | (37.8035189184231, -122.431809184355) | |||
| 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) | |||
| 167349 | 167349 | 189877 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016448.8562900005 | 2098333.07564 | 37.7425461678608 | -122.38573080145099 | (37.7425461678608, -122.385730801451) | |||
| 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) | |||
| 167323 | 167323 | 225063 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 247 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998979.478759999 | 2106681.18548 | 37.7644858801306 | -122.44673506598998 | (37.7644858801306, -122.44673506599) | |||
| 167049 | 167049 | 248271 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | |||
| 166502 | 166502 | 61685 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 34 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 11 | Permit Number 21682 | 6013864.09066 | 2093969.56082 | 37.730421490047604 | -122.39436277503201 | (37.7304214900476, -122.394362775032) | |
| 166259 | 166259 | 189957 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 572 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011483.58307 | 2109635.35024 | 37.773303704933895 | -122.40369442207701 | (37.7733037049339, -122.403694422077) | |||
| 166172 | 166172 | 189893 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016784.24817 | 2098329.2173099997 | 37.7425541268854 | -122.384570835175 | (37.7425541268854, -122.384570835175) | |||
| 166137 | 166137 | 189911 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013879.72064 | 2094387.8060700002 | 37.73157077506371 | -122.394338012196 | (37.7315707750637, -122.394338012196) |
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");