Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172373 | 172373 | 191279 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014488.651430001 | 2110553.2747 | 37.7759915303161 | -122.393363646226 | (37.7759915303161, -122.393363646226) | |||
| 172150 | 172150 | 94214 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013545.016969999 | 2104957.62874 | 37.7605746593094 | -122.396235681545 | (37.7605746593094, -122.396235681545) | |
| 171961 | 171961 | 129439 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010043.54378 | 2115756.3306400003 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | |||
| 171953 | 171953 | 207069 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 5993748.4844 | 2102370.47272 | 37.752349572298606 | -122.46451448116999 | (37.7523495722986, -122.46451448117) | |||
| 171684 | 171684 | 176974 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 15 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009262.49228 | 2094178.39386 | 37.730738031628704 | -122.410285956242 | (37.7307380316287, -122.410285956242) | |||
| 171630 | 171630 | 227590 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 33 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6005514.0143099995 | 2098729.37498 | 37.743023170990604 | -122.423568480604 | (37.7430231709906, -122.423568480604) | |||
| 171606 | 171606 | 176934 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 52 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012523.28008 | 2087764.2105 | 37.7133082296521 | -122.398562902163 | (37.7133082296521, -122.398562902163) | |||
| 171489 | 171489 | 176938 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 10 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012264.960419999 | 2087928.82829 | 37.7137458424772 | -122.39946729997101 | (37.7137458424772, -122.399467299971) | |||
| 170832 | 170832 | 207092 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991411.795390001 | 2097355.25398 | 37.738444095618 | -122.4722295024 | (37.738444095618, -122.4722295024) | |||
| 170818 | 170818 | 227612 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1299 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010076.057159999 | 2101688.5205599996 | 37.7514047850101 | -122.40800274303601 | (37.7514047850101, -122.408002743036) | |||
| 170793 | 170793 | 227664 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 46 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006352.613580001 | 2109543.15644 | 37.7727626017523 | -122.42143663049801 | (37.7727626017523, -122.421436630498) | |||
| 170771 | 170771 | 227615 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005000.954919999 | 2099622.04361 | 37.7454452619845 | -122.42540601408001 | (37.7454452619845, -122.42540601408) | |||
| 170548 | 170548 | 103458 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 212 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769919 | 5999039.39992 | 2115859.35215 | 37.789690188098504 | -122.447188409728 | (37.7896901880985, -122.447188409728) | |
| 170367 | 170367 | 105028 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015077.92484 | 2108113.3475599997 | 37.7693247525719 | -122.391154592016 | (37.7693247525719, -122.391154592016) | |||
| 170215 | 170215 | 191359 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015119.80828 | 2107355.2560099997 | 37.7672455235927 | -122.39095672679 | (37.7672455235927, -122.39095672679) | |||
| 170159 | 170159 | 191353 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015102.637619999 | 2107654.6219599997 | 37.768066564148505 | -122.39103704433501 | (37.7680665641485, -122.391037044335) | |||
| 169966 | 169966 | 227597 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005381.2036 | 2107800.12984 | 37.767921851550604 | -122.424672832791 | (37.7679218515506, -122.424672832791) | |||
| 169932 | 169932 | 176948 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 43 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012470.82697 | 2087771.0926700002 | 37.7133242043273 | -122.39874468213101 | (37.7133242043273, -122.398744682131) | |||
| 169241 | 169241 | 129430 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004093.9756 | 2116304.66162 | 37.791200405233496 | -122.42973185833401 | (37.7912004052335, -122.429731858334) | |||
| 169237 | 169237 | 191278 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014098.280590001 | 2110942.62046 | 37.777038889768896 | -122.39474132397801 | (37.7770388897689, -122.394741323978) | |||
| 169093 | 169093 | 176928 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 110 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012745.689669999 | 2087817.6299700001 | 37.713467297259996 | -122.397797917233 | (37.71346729726, -122.397797917233) | |||
| 169089 | 169089 | 176954 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 95 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012699.50978 | 2087739.26695 | 37.713249556105104 | -122.397952038554 | (37.7132495561051, -122.397952038554) | |||
| 169077 | 169077 | 176965 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 327 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 6004071.24912 | 2093653.41815 | 37.7290042007626 | -122.428195498837 | (37.7290042007626, -122.428195498837) | |||
| 168923 | 168923 | 191360 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015121.963930001 | 2107325.3788400004 | 37.767163607031705 | -122.390947182278 | (37.7671636070317, -122.390947182278) | |||
| 168888 | 168888 | 176927 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200 Morse St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 10ft | 6000575.21017 | 2087869.90013 | 37.7129255429455 | -122.43986703794201 | (37.7129255429455, -122.439867037942) | |||
| 168777 | 168777 | 207093 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2469 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992014.45058 | 2098646.31177 | 37.742023871309 | -122.47023982251801 | (37.742023871309, -122.470239822518) | |||
| 168739 | 168739 | 207051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992092.816880001 | 2106815.43538 | 37.764458690039 | -122.47056370526899 | (37.764458690039, -122.470563705269) | |||
| 168646 | 168646 | 191273 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014193.41583 | 2110841.8415900003 | 37.7767674626879 | -122.394405160994 | (37.7767674626879, -122.394405160994) | |||
| 168581 | 168581 | 227609 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6006260.1728300005 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | ||||
| 168441 | 168441 | 139749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 CLEARY CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004687.007999999 | 2113628.2842 | 37.783885306529605 | -122.427489231919 | (37.7838853065296, -122.427489231919) | |||
| 168398 | 168398 | 129401 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5 Dicha Aly | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5998309.94171 | 2113772.92465 | 37.7839197016653 | -122.449561847418 | (37.7839197016653, -122.449561847418) | |||
| 167387 | 167387 | 129428 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2250 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6003926.506990001 | 2116660.0257099997 | 37.7921666602192 | -122.430336659605 | (37.7921666602192, -122.430336659605) | |||
| 167362 | 167362 | 207055 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1950 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992276.06738 | 2102166.8288 | 37.751705429283206 | -122.469591467999 | (37.7517054292832, -122.469591467999) | |||
| 167315 | 167315 | 227633 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3240 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008124.7966 | 2100966.18492 | 37.749311972684396 | -122.414699339617 | (37.7493119726844, -122.414699339617) | |||
| 167301 | 167301 | 35008 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50542 | 5999619.6658 | 2114602.5127 | 37.7862723736076 | -122.445090361129 | (37.7862723736076, -122.445090361129) | |
| 167148 | 167148 | 191294 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014564.69623 | 2110362.23682 | 37.775471207769606 | -122.393087215303 | (37.7754712077696, -122.393087215303) | |||
| 166791 | 166791 | 191265 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2100 Thomas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6012134.75084 | 2095927.2478099999 | 37.735700607590296 | -122.400478845738 | (37.7357006075903, -122.400478845738) | ||||
| 166757 | 166757 | 227604 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004502.9106 | 2096117.99556 | 37.7357957927473 | -122.426878664735 | (37.7357957927473, -122.426878664735) | ||||
| 166627 | 166627 | 191298 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6015180.160630001 | 2107302.1939 | 37.7671031752919 | -122.39074426644899 | (37.7671031752919, -122.390744266449) | |||
| 166600 | 166600 | 191288 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014381.59657 | 2110521.77598 | 37.7758990935001 | -122.39373177471 | (37.7758990935001, -122.39373177471) | |||
| 165842 | 165842 | 227605 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.61589 | 2096121.06345 | 37.735804312902204 | -122.426872987299 | (37.7358043129022, -122.426872987299) | ||||
| 165795 | 165795 | 129398 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3729 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997021.62902 | 2114999.75252 | 37.787214459718705 | -122.454107547129 | (37.7872144597187, -122.454107547129) | |||
| 165313 | 165313 | 207060 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2454 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5992058.22745 | 2098746.77263 | 37.7423022420675 | -122.470095770898 | (37.7423022420675, -122.470095770898) | |||
| 165161 | 165161 | 227641 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 582 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001827.41036 | 2102469.65818 | 37.753084321989 | -122.436583393722 | (37.753084321989, -122.436583393722) | |||
| 164682 | 164682 | 37224 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1340 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39788 | 5985571.0917 | 2106094.9849 | 37.7621012650414 | -122.49306716261101 | (37.7621012650414, -122.493067162611) | |
| 164481 | 164481 | 31363 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2295 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 2 | Permit Number 34969 | 5991013.007780001 | 2099881.4668 | 37.7453573397732 | -122.47379254479799 | (37.7453573397732, -122.473792544798) | ||
| 164417 | 164417 | 191304 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015169.51274 | 2107473.76779 | 37.767573688899496 | -122.390793087953 | (37.7675736888995, -122.390793087953) | |||
| 164375 | 164375 | 207088 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991634.58199 | 2098444.51298 | 37.7414478141662 | -122.47153857305 | (37.7414478141662, -122.47153857305) | |||
| 164372 | 164372 | 111668 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3PL | 6004109.02078 | 2116034.23701 | 37.790458739741 | -122.429660507029 | (37.790458739741, -122.429660507029) | |||
| 164170 | 164170 | 62984 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 7 | Permit Number 33034 | 5984571.8482 | 2106766.3839 | 37.7638862475145 | -122.496572656852 | (37.7638862475145, -122.496572656852) | |
| 164130 | 164130 | 191350 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015098.296519999 | 2107739.7702099998 | 37.7683001216821 | -122.39105801201099 | (37.7683001216821, -122.391058012011) | |||
| 163894 | 163894 | 129427 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003257.40294 | 2117505.83832 | 37.794451121666604 | -122.43271221522 | (37.7944511216666, -122.43271221522) | |||
| 163312 | 163312 | 227643 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002989.53011 | 2103560.80368 | 37.7561463193257 | -122.432642495251 | (37.7561463193257, -122.432642495251) | |||
| 163250 | 163250 | 191292 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014526.81372 | 2110393.83261 | 37.7755558582611 | -122.393220472347 | (37.7755558582611, -122.393220472347) | |||
| 163137 | 163137 | 227627 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1455 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6003318.42561 | 2099759.38462 | 37.7457271634958 | -122.43123373066003 | (37.7457271634958, -122.43123373066) | |||
| 163085 | 163085 | 183580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988349.2799 | 2097484.0905 | 37.7386201346216 | -122.482827506776 | (37.7386201346216, -122.482827506776) | |||
| 163079 | 163079 | 247479 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002709.4266 | 2109671.5189 | 37.7729089683714 | -122.434047985824 | (37.7729089683714, -122.434047985824) | |||
| 162971 | 162971 | 227657 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 117 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001570.048769999 | 2106180.8326 | 37.7632596788053 | -122.437739171852 | (37.7632596788053, -122.437739171852) | |||
| 162970 | 162970 | 246778 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 392 Franconia St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6009934.469769999 | 2098852.71045 | 37.7436103455484 | -122.408292376913 | (37.7436103455484, -122.408292376913) | ||||
| 162927 | 162927 | 246317 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.771133605468705 | -122.419700914309 | (37.7711336054687, -122.419700914309) | |||
| 162829 | 162829 | 51087 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2031REVISED Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2004 12:00:00 AM | 8 | Permit Number 47544 | 6006859.53299 | 2118230.7659 | 37.7966452201661 | -122.42029985774799 | (37.7966452201661, -122.420299857748) | ||
| 162702 | 162702 | 129396 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3570 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997759.42615 | 2115150.05593 | 37.7876694312425 | -122.451565786028 | (37.7876694312425, -122.451565786028) | |||
| 162520 | 162520 | 227662 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 32 Harry St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6003182.99622 | 2097643.55659 | 37.7399099141156 | -122.43155100069099 | (37.7399099141156, -122.431551000691) | |||
| 162509 | 162509 | 120374 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 433 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5988073.52579 | 2113031.79545 | 37.7812938539051 | -122.484921243675 | (37.7812938539051, -122.484921243675) | |||
| 162454 | 162454 | 227640 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1098 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006270.9018 | 2103197.69782 | 37.7553348592182 | -122.421268598461 | (37.7553348592182, -122.421268598461) | |||
| 162331 | 162331 | 129397 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3729 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997011.377730001 | 2114998.8497200003 | 37.7872113930486 | -122.45414294896099 | (37.7872113930486, -122.454142948961) | |||
| 162297 | 162297 | 191270 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014244.47605 | 2110787.29844 | 37.7766205377503 | -122.39422470752899 | (37.7766205377503, -122.394224707529) | |||
| 162169 | 162169 | 101345 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.803736447762795 | -122.413855954453 | (37.8037364477628, -122.413855954453) | ||
| 162168 | 162168 | 176971 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Tulane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007468.11752 | 2093808.15267 | 37.7296206815304 | -122.416463191631 | (37.7296206815304, -122.416463191631) | |||
| 161451 | 161451 | 227601 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1100 San Jose Ave | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004769.19859 | 2096667.0685 | 37.7373184762576 | -122.425997076417 | (37.7373184762576, -122.425997076417) | ||||
| 161305 | 161305 | 114220 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012353.592019999 | 2087846.1951099997 | 37.713523887993105 | -122.39915515788799 | (37.7135238879931, -122.399155157888) | |||
| 161241 | 161241 | 227594 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005345.94103 | 2107798.56704 | 37.7679155688764 | -122.42479469094101 | (37.7679155688764, -122.424794690941) | |||
| 161158 | 161158 | 129394 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3700 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5997109.1846199995 | 2115060.1871599997 | 37.7873854172521 | -122.45380899111099 | (37.7873854172521, -122.453808991111) | |||
| 160010 | 160010 | 176926 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200 Morse St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6000586.22066 | 2087873.8924099999 | 37.712937131606395 | -122.439829268227 | (37.7129371316064, -122.439829268227) | |||
| 159965 | 159965 | 176962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 121 Saint Charles Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 5992069.06615 | 2087619.0428799998 | 37.71174887986621 | -122.46924855110301 | (37.7117488798662, -122.469248551103) | |||
| 159621 | 159621 | 186908 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985188.8014 | 2096694.9245 | 37.736268900285 | -122.493696639188 | (37.736268900285, -122.493696639188) | |||
| 159374 | 159374 | 129432 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004124.61142 | 2116315.60844 | 37.7912321971464 | -122.429626640374 | (37.7912321971464, -122.429626640374) | |||
| 159237 | 159237 | 139750 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 CLEARY CT | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004722.5099 | 2113632.2289 | 37.78389814561189 | -122.427366689538 | (37.7838981456119, -122.427366689538) | |||
| 159060 | 159060 | 200098 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015053.9581 | 2092365.0208 | 37.726081815437205 | -122.39013714867201 | (37.7260818154372, -122.390137148672) | |||
| 158779 | 158779 | 227635 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3234 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008177.73099 | 2100971.3435400003 | 37.7493291110692 | -122.41451665582198 | (37.7493291110692, -122.414516655822) | |||
| 158100 | 158100 | 227666 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 46 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006306.62249 | 2109592.20963 | 37.772894696857705 | -122.421599203664 | (37.7728946968577, -122.421599203664) | |||
| 157758 | 157758 | 34595 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 224 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38290 | 5999049.11331 | 2115811.8927599997 | 37.7895604321171 | -122.447151385541 | (37.7895604321171, -122.447151385541) | |
| 157755 | 157755 | 129412 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2111 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003281.29754 | 2115999.00202 | 37.790315090121005 | -122.432521856625 | (37.790315090121, -122.432521856625) | |||
| 157583 | 157583 | 227652 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3875 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003788.823369999 | 2104769.57077 | 37.759510603063795 | -122.42996449048799 | (37.7595106030638, -122.429964490488) | |||
| 157316 | 157316 | 176970 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 146 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004341.61716 | 2094290.0126599998 | 37.7307674412459 | -122.42730614487301 | (37.7307674412459, -122.427306144873) | |||
| 157251 | 157251 | 227646 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4082 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002634.29607 | 2102415.94957 | 37.7529826707309 | -122.43378918933 | (37.7529826707309, -122.43378918933) | |||
| 157086 | 157086 | 129399 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3766 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5996788.91292 | 2115340.40834 | 37.788136462672604 | -122.454937313809 | (37.7881364626726, -122.454937313809) | |||
| 157041 | 157041 | 199935 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1310 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017874.9241 | 2092620.1152 | 37.726938315047896 | -122.380402857754 | (37.7269383150479, -122.380402857754) | |||
| 157008 | 157008 | 187077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985155.4633 | 2096938.6014 | 37.736936021545 | -122.493829852855 | (37.736936021545, -122.493829852855) | |||
| 156929 | 156929 | 217749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 445 West Portal Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991783.05973 | 2096405.3403 | 37.7358573522267 | -122.470876685538 | (37.7358573522267, -122.470876685538) | |||
| 156882 | 156882 | 191347 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015093.18746 | 2107823.28717 | 37.768529157422705 | -122.391081522115 | (37.7685291574227, -122.391081522115) | |||
| 156796 | 156796 | 191266 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1721 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 9ft | 6014437.69224 | 2094855.17275 | 37.7328850694924 | -122.39244165855499 | (37.7328850694924, -122.392441658555) | |||
| 156648 | 156648 | 182931 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2639 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982106.6394 | 2097122.6843 | 37.7372626147396 | -122.50438444730699 | (37.7372626147396, -122.504384447307) | |||
| 156592 | 156592 | 82944 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52427 | 6009357.52887 | 2110544.0816099998 | 37.775679873857605 | -122.4111129656 | (37.7756798738576, -122.4111129656) | |
| 156333 | 156333 | 129391 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1851 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004117.78483 | 2119036.12679 | 37.798701658520706 | -122.42984439412399 | (37.7987016585207, -122.429844394124) | |||
| 156068 | 156068 | 129419 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003276.06747 | 2117879.65532 | 37.795478585430104 | -122.43267434925899 | (37.7954785854301, -122.432674349259) | |||
| 156039 | 156039 | 31965 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 35367 | 6008195.50256 | 2118963.54127 | 37.7987324288073 | -122.41572900131099 | (37.7987324288073, -122.415729001311) | |||
| 155958 | 155958 | 227621 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1335 Douglass St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001398.3282 | 2099807.1524799997 | 37.7457493236871 | -122.43787655407499 | (37.7457493236871, -122.437876554075) | |||
| 155887 | 155887 | 207084 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2093 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993169.3721900005 | 2101262.29203 | 37.7492733917544 | -122.46643659227101 | (37.7492733917544, -122.466436592271) | |||
| 155800 | 155800 | 53889 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1009 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1972 12:00:00 AM | 6 | Permit Number 9600 | 6011157.21659 | 2090045.52637 | 37.7194960599821 | -122.403444914172 | (37.7194960599821, -122.403444914172) |
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");