Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 564 | 564 | 222895 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.0940099997 | 37.765017648370105 | -122.42151112584801 | (37.7650176483701, -122.421511125848) | ||
| 568 | 568 | 222894 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 27054 | 6006296.82054 | 2106727.45524 | 37.765028210007 | -122.42142962480301 | (37.765028210007, -122.421429624803) | |
| 3024 | 3024 | 225099 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.770612035853404 | -122.43068573955401 | (37.7706120358534, -122.430685739554) | |
| 5182 | 5182 | 225094 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | |
| 24342 | 24342 | 225069 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 892 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009108.56559 | 2103972.85995 | 37.75762285142989 | -122.41150982923 | (37.7576228514299, -122.41150982923) | |||
| 25271 | 25271 | 125991 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008338.82398 | 2121554.9566599997 | 37.805855861614795 | -122.41541661910699 | (37.8058558616148, -122.415416619107) | |||
| 25477 | 25477 | 225086 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.756311078698296 | -122.429732966312 | (37.7563110786983, -122.429732966312) | |||
| 26487 | 26487 | 189910 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.742244189916704 | -122.386410241063 | (37.7422441899167, -122.386410241063) | |||
| 26761 | 26761 | 175842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 234 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004274.97667 | 2092050.6197400002 | 37.724614796925 | -122.427377064513 | (37.724614796925, -122.427377064513) | |||
| 27662 | 27662 | 225079 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009325.524119999 | 2103958.77383 | 37.7575963412133 | -122.410758500511 | (37.7575963412133, -122.410758500511) | |||
| 28082 | 28082 | 225072 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 902 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009377.02442 | 2103868.3997 | 37.757351081704606 | -122.41057400910299 | (37.7573510817046, -122.410574009103) | |||
| 30923 | 30923 | 188479 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2208 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010817.79084 | 2106032.71885 | 37.763374486260204 | -122.40574369103201 | (37.7633744862602, -122.405743691032) | |||
| 31280 | 31280 | 189919 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6013770.13743 | 2116011.13859 | 37.7909376251249 | -122.396231800058 | (37.7909376251249, -122.396231800058) | |||
| 31832 | 31832 | 222918 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997702.832359999 | 2107152.93734 | 37.7657081802151 | -122.451184638974 | (37.7657081802151, -122.451184638974) | |||
| 32281 | 32281 | 225053 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.736911510559295 | -122.438267032523 | (37.7369115105593, -122.438267032523) | |||
| 32338 | 32338 | 248196 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006902.26536 | 2099037.70953 | 37.7439480508589 | -122.41879013796101 | (37.7439480508589, -122.418790137961) | |||
| 33051 | 33051 | 123914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 389 09th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993078.53663 | 2112857.8084299997 | 37.7811063777719 | -122.467593853963 | (37.7811063777719, -122.467593853963) | |||
| 33356 | 33356 | 248279 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | |||
| 34084 | 34084 | 206003 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1593 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991725.497880001 | 2104502.2556 | 37.7580860643266 | -122.471665566325 | (37.7580860643266, -122.471665566325) | |||
| 35349 | 35349 | 189956 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 572 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.773349868946205 | -122.403749639528 | (37.7733498689462, -122.403749639528) | |||
| 35568 | 35568 | 225084 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3784 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003185.26448 | 2103031.00379 | 37.7547027131682 | -122.43192775097401 | (37.7547027131682, -122.431927750974) | |||
| 35683 | 35683 | 225082 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 543 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002779.31526 | 2103257.0391599997 | 37.7553003306644 | -122.433347783174 | (37.7553003306644, -122.433347783174) | |||
| 37728 | 37728 | 225083 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3782 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003229.02977 | 2103031.88331 | 37.7547076090931 | -122.431776461616 | (37.7547076090931, -122.431776461616) | |||
| 38614 | 38614 | 225070 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009108.93583 | 2103990.9837700003 | 37.757672636103 | -122.411509829221 | (37.757672636103, -122.411509829221) | |||
| 40106 | 40106 | 248228 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006955.04848 | 2099184.3603 | 37.744353692775995 | -122.41861802300501 | (37.744353692776, -122.418618023005) | |||
| 41360 | 41360 | 225095 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004583.37564 | 2109107.4182 | 37.7714662577942 | -122.427525575841 | (37.7714662577942, -122.427525575841) | |||
| 42068 | 42068 | 205999 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001682.52176 | 2095686.8275900001 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | |||
| 43136 | 43136 | 188487 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6016679.39003 | 2098723.9070200003 | 37.74363206505979 | -122.384960899022 | (37.7436320650598, -122.384960899022) | |||
| 43464 | 43464 | 206016 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.45650193453899 | (37.7299087874515, -122.456501934539) | |||
| 43510 | 43510 | 225058 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 283 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996870.764690001 | 2106986.93981 | 37.76520471814 | -122.454050575073 | (37.76520471814, -122.454050575073) | |||
| 43855 | 43855 | 206018 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | |||
| 44285 | 44285 | 206008 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990990.06403 | 2097739.22497 | 37.7394739659536 | -122.47371563298701 | (37.7394739659536, -122.473715632987) | |||
| 45186 | 45186 | 205991 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993388.91946 | 2093682.37508 | 37.72847350453279 | -122.465126926677 | (37.7284735045328, -122.465126926677) | |||
| 45296 | 45296 | 248254 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006798.65634 | 2098892.16282 | 37.7435425780247 | -122.419138073069 | (37.7435425780247, -122.419138073069) | |||
| 45389 | 45389 | 248262 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | |||
| 45525 | 45525 | 206011 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990881.65673 | 2097736.82059 | 37.739461084972206 | -122.47409027886299 | (37.7394610849722, -122.474090278863) | |||
| 45627 | 45627 | 225076 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3328 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007533.56344 | 2101516.4180900003 | 37.7507895524966 | -122.41678281788602 | (37.7507895524966, -122.416782817886) | |||
| 46452 | 46452 | 248275 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006752.53211 | 2098758.7700799997 | 37.743173713897 | -122.41928809889299 | (37.743173713897, -122.419288098893) | |||
| 50402 | 50402 | 248264 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006711.60121 | 2098736.3727599997 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | |||
| 51934 | 51934 | 225074 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3354 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007335.7626 | 2101504.20622 | 37.750744893976204 | -122.417465967185 | (37.7507448939762, -122.417465967185) | |||
| 53404 | 53404 | 189942 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 160 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014651.73587 | 2116280.65037 | 37.7917266570015 | -122.39320034911199 | (37.7917266570015, -122.393200349112) | |||
| 53695 | 53695 | 188483 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016580.588769999 | 2098830.3730200003 | 37.7439189335051 | -122.38530995020399 | (37.7439189335051, -122.385309950204) | |||
| 53992 | 53992 | 222919 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 121 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997880.24105 | 2107132.61559 | 37.765662537824895 | -122.45056955843701 | (37.7656625378249, -122.450569558437) | |||
| 54211 | 54211 | 188484 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6016633.990259999 | 2098788.07165 | 37.743805736753394 | -122.38512235163 | (37.7438057367534, -122.38512235163) | |||
| 54347 | 54347 | 206013 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992845.13508 | 2095810.8192900002 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | |||
| 55143 | 55143 | 248200 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006940.782319999 | 2099105.37762 | 37.744136020872205 | -122.418661752548 | (37.7441360208722, -122.418661752548) | |||
| 55275 | 55275 | 189902 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | |||
| 55327 | 55327 | 189949 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014767.16396 | 2116087.91405 | 37.791203859513004 | -122.392787475772 | (37.791203859513, -122.392787475772) | |||
| 57395 | 57395 | 125990 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008335.581590001 | 2121584.4344900004 | 37.8059366180507 | -122.415429928145 | (37.8059366180507, -122.415429928145) | |||
| 58420 | 58420 | 125975 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007035.474780001 | 2121873.14157 | 37.806656174619704 | -122.41994966175601 | (37.8066561746197, -122.419949661756) | |||
| 58491 | 58491 | 189959 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010397.618480001 | 2108539.03358 | 37.7702327485634 | -122.40737363758998 | (37.7702327485634, -122.40737363759) | |||
| 58573 | 58573 | 189943 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014663.902869999 | 2116268.03372 | 37.7916926905231 | -122.39315736781299 | (37.7916926905231, -122.393157367813) | |||
| 59003 | 59003 | 225090 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002851.63466 | 2107200.7798599997 | 37.7661329947706 | -122.433379482476 | (37.7661329947706, -122.433379482476) | |||
| 59009 | 59009 | 206021 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | |||
| 60186 | 60186 | 248270 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | |||
| 64383 | 64383 | 248208 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 37 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007034.71089 | 2099281.8609599997 | 37.744625892375396 | -122.41834947827101 | (37.7446258923754, -122.418349478271) | |||
| 64492 | 64492 | 222913 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004271.62218 | 2109232.3150299997 | 37.771791556066 | -122.428612851729 | (37.771791556066, -122.428612851729) | |||
| 65155 | 65155 | 248201 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.41863372066601 | (37.7441794671077, -122.418633720666) | |||
| 65181 | 65181 | 248195 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006895.3062 | 2099022.5140400003 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | |||
| 65489 | 65489 | 225056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901044995 | -122.43874836315399 | (37.737188901045, -122.438748363154) | |||
| 65825 | 65825 | 205992 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993371.398019999 | 2093686.3141400001 | 37.728483309840996 | -122.46518778469299 | (37.728483309841, -122.465187784693) | |||
| 66533 | 66533 | 206019 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994816.51833 | 2099704.78199 | 37.745091768175605 | -122.460627918846 | (37.7450917681756, -122.460627918846) | |||
| 66722 | 66722 | 248258 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006769.1868199995 | 2098841.93634 | 37.7434030077589 | -122.41923640944201 | (37.7434030077589, -122.419236409442) | |||
| 67946 | 67946 | 125995 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008349.66203 | 2121453.17315 | 37.8055769989413 | -122.41537190211201 | (37.8055769989413, -122.415371902112) | |||
| 68659 | 68659 | 248263 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.743141812234505 | -122.41940912783899 | (37.7431418122345, -122.419409127839) | |||
| 69332 | 69332 | 225073 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 904 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009377.25257 | 2103854.7897900003 | 37.757313724754795 | -122.410572259011 | (37.7573137247548, -122.410572259011) | |||
| 70040 | 70040 | 248206 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 39 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007021.99675 | 2099262.74695 | 37.744572693881395 | -122.41839208633999 | (37.7445726938814, -122.41839208634) | |||
| 71217 | 71217 | 125968 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2810 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001336.417830001 | 2115647.62359 | 37.7892398148051 | -122.43922579254101 | (37.7892398148051, -122.439225792541) | |||
| 71841 | 71841 | 225048 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2823 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009293.07164 | 2103911.54746 | 37.757464848636204 | -122.410867399417 | (37.7574648486362, -122.410867399417) | |||
| 71848 | 71848 | 125969 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2672 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002023.76351 | 2115741.9503 | 37.7895379005066 | -122.43685441882 | (37.7895379005066, -122.43685441882) | |||
| 72501 | 72501 | 225044 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007468.43971 | 2099454.94472 | 37.7451255476034 | -122.4168619861 | (37.7451255476034, -122.4168619861) | |||
| 73260 | 73260 | 205990 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993405.09676 | 2093676.5167599998 | 37.7284583518695 | -122.46507057606001 | (37.7284583518695, -122.46507057606) | |||
| 74103 | 74103 | 225093 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 635 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002682.06353 | 2108837.51126 | 37.770617436283004 | -122.43408300774901 | (37.770617436283, -122.434083007749) | |||
| 74525 | 74525 | 225089 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004316.16009 | 2104019.9015 | 37.757482039184204 | -122.428087274435 | (37.7574820391842, -122.428087274435) | |||
| 74726 | 74726 | 206007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991032.21326 | 2097741.2680200003 | 37.739482016692904 | -122.473570049822 | (37.7394820166929, -122.473570049822) | |||
| 75782 | 75782 | 189964 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 287 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010268.27805 | 2111003.99646 | 37.7769937249279 | -122.407994884783 | (37.7769937249279, -122.407994884783) | |||
| 75887 | 75887 | 225065 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006960.17815 | 2097772.4528099997 | 37.740477199257704 | -122.418500188445 | (37.7404771992577, -122.418500188445) | |||
| 76853 | 76853 | 225071 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009374.803830001 | 2103883.5621599997 | 37.7573925899019 | -122.410582759505 | (37.7573925899019, -122.410582759505) | |||
| 96732 | 96732 | 189953 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014700.62775 | 2116023.46282 | 37.7910231956157 | -122.39301317951201 | (37.7910231956157, -122.393013179512) | |||
| 100325 | 100325 | 189958 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010386.6969099995 | 2108550.07878 | 37.7702624648584 | -122.407412194212 | (37.7702624648584, -122.407412194212) | |||
| 104259 | 104259 | 248261 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | |||
| 122019 | 122019 | 205987 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | |||
| 126890 | 126890 | 206004 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | |||
| 130030 | 130030 | 222903 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 164 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009951.59256 | 2100103.1565099997 | 37.747044755713205 | -122.408321349458 | (37.7470447557132, -122.408321349458) | |||
| 130879 | 130879 | 225068 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009114.1902 | 2103856.87983 | 37.757304711760604 | -122.41148218316299 | (37.7573047117606, -122.411482183163) | |||
| 131148 | 131148 | 225096 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004357.77926 | 2109121.0465599997 | 37.7714909154158 | -122.428306896964 | (37.7714909154158, -122.428306896964) | |||
| 132092 | 132092 | 206014 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | |||
| 132834 | 132834 | 189962 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010439.90597 | 2108494.60457 | 37.7701131234445 | -122.407224232334 | (37.7701131234445, -122.407224232334) | |||
| 134756 | 134756 | 225092 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002638.752309999 | 2108633.09345 | 37.770053697148796 | -122.434218205527 | (37.7700536971488, -122.434218205527) | |||
| 135193 | 135193 | 189961 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010424.6180300005 | 2108510.1784200002 | 37.770155030049295 | -122.407278211428 | (37.7701550300493, -122.407278211428) | |||
| 135232 | 135232 | 248274 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006747.61558 | 2098750.1570099997 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | |||
| 136895 | 136895 | 225067 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009115.2795 | 2103823.2478099996 | 37.7572124269416 | -122.41147603989401 | (37.7572124269416, -122.411476039894) | |||
| 137305 | 137305 | 125993 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008342.4716300005 | 2121500.19485 | 37.8057057045282 | -122.415400116539 | (37.8057057045282, -122.415400116539) | |||
| 137669 | 137669 | 248203 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 47 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006976.18023 | 2099171.17204 | 37.7443186704674 | -122.418544018687 | (37.7443186704674, -122.418544018687) | |||
| 149673 | 149673 | 248229 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006943.33301 | 2099166.5172900003 | 37.7443040402894 | -122.41865726764401 | (37.7443040402894, -122.418657267644) | |||
| 149968 | 149968 | 248204 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 47 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006982.897919999 | 2099182.4975099997 | 37.744350145854796 | -122.418521593214 | (37.7443501458548, -122.418521593214) | |||
| 150091 | 150091 | 206006 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | |||
| 150639 | 150639 | 248209 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 37 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007043.43628 | 2099296.21325 | 37.7446657917085 | -122.418320324941 | (37.7446657917085, -122.418320324941) | |||
| 152050 | 152050 | 225080 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2823 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009082.12028 | 2103902.9950900003 | 37.7574295349581 | -122.411596352099 | (37.7574295349581, -122.411596352099) | |||
| 152658 | 152658 | 248198 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006917.65895 | 2099068.8782900004 | 37.744034500003295 | -122.418739120308 | (37.7440345000033, -122.418739120308) |
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");