Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6680 | 6680 | 112268 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 6704 | 6704 | 112269 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10998 | 10998 | 112267 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 113029 | 113029 | 117600 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 565 39TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5983700.0 | 2111975.0 | 37.7781364952795 | -122.49997311443501 | (37.7781364952795, -122.499973114435) | |||
| 90516 | 90516 | 20972 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 95236 | 95236 | 20974 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 97048 | 97048 | 20975 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 81585 | 81585 | 52592 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 327CALIFORNIA 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48686 | 5988048.64326864 | 2113784.56845539 | 37.7833593060301 | -122.48506257055 | (37.7833593060301, -122.48506257055) | ||||
| 127656 | 127656 | 94524 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3322 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774668 | 5988381.0 | 2111924.0 | 37.7782700631784 | -122.48377629744301 | (37.7782700631784, -122.483776297443) | |||
| 106122 | 106122 | 117200 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1321 23RD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5988915.0 | 2106334.0 | 37.7629525336189 | -122.481519510385 | (37.7629525336189, -122.481519510385) | |||
| 114563 | 114563 | 9079 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 5625 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989525.4329 | 2112589.82108 | 37.7801647748824 | -122.479866062567 | (37.7801647748824, -122.479866062567) | |||
| 96529 | 96529 | 9076 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 5618 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989554.31102 | 2112758.21214 | 37.7806288074212 | -122.479778486374 | (37.7806288074212, -122.479778486374) | |||
| 101186 | 101186 | 9077 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 5618 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989554.31102 | 2112758.21214 | 37.7806288074212 | -122.479778486374 | (37.7806288074212, -122.479778486374) | |||
| 95810 | 95810 | 9071 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 5600 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1990 12:00:00 AM | 12 | 3X3 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | ||
| 116898 | 116898 | 9070 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 5600 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1990 12:00:00 AM | 12 | 3X3 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | ||
| 65794 | 65794 | 115992 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778644 | 5989723.9 | 2112354.3 | 37.7795296278249 | -122.47916224845301 | (37.7795296278249, -122.479162248453) | ||
| 78296 | 78296 | 93145 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1152 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991985.0 | 2113459.0 | 37.7826938870859 | -122.47142072749399 | (37.7826938870859, -122.471420727494) | |||||
| 100058 | 100058 | 93144 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1152 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2016 12:00:00 AM | 3 | 5991985.0 | 2113459.0 | 37.7826938870859 | -122.47142072749399 | (37.7826938870859, -122.471420727494) | |||
| 112840 | 112840 | 93146 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1152 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991985.0 | 2113459.0 | 37.7826938870859 | -122.47142072749399 | (37.7826938870859, -122.471420727494) | |||||
| 119954 | 119954 | 26666 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1015 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5992306.14573 | 2114757.6166 | 37.78627810348571 | -122.47040431482401 | (37.7862781034857, -122.470404314824) | |||
| 93550 | 93550 | 105290 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 330 11TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | 5992515.1 | 2113228.4 | 37.7820913739714 | -122.469570031425 | (37.7820913739714, -122.469570031425) | ||||
| 9804 | 9804 | 59226 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 530 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779363 | 5992552.44717 | 2111818.61025 | 37.7782226338783 | -122.469338181035 | (37.7782226338783, -122.469338181035) | ||
| 1369 | 1369 | 121635 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 506 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | 5992560.0 | 2111978.0 | 37.778660711296794 | -122.46932365779699 | (37.7786607112968, -122.469323657797) | ||
| 120949 | 120949 | 12630 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 841 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5992831.38337 | 2114795.44702 | 37.7864123300728 | -122.46858989794501 | (37.7864123300728, -122.468589897945) | |||
| 91008 | 91008 | 120156 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 758 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10 | 5992930.0 | 2110298.0 | 37.77406925887279 | -122.467921468059 | (37.7740692588728, -122.467921468059) | ||||
| 113361 | 113361 | 54410 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1248 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 10182 | 5993332.64911234 | 2106987.54521442 | 37.765002872173 | -122.46628801063 | (37.765002872173, -122.46628801063) | |||
| 127180 | 127180 | 111369 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 724 IRVING ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993485.0 | 2106687.0 | 37.7641864431876 | -122.465739233402 | (37.7641864431876, -122.465739233402) | ||||
| 76139 | 76139 | 94058 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1401X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5993648.0 | 2105942.0 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | |||
| 121808 | 121808 | 94059 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1401X 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5993648.0 | 2105942.0 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | |||
| 112107 | 112107 | 54742 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1374 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 3x3 | Permit Number 10588 | 5993980.75543943 | 2106156.09216002 | 37.7627572927027 | -122.463986029849 | (37.7627572927027, -122.463986029849) | ||
| 101735 | 101735 | 1685 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 452X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5994164.03145 | 2111506.7878 | 37.7774594509207 | -122.46374052558399 | (37.7774594509207, -122.463740525584) | |||
| 119250 | 119250 | 103480 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1247 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x5 | Permit Number 31998 | 5994182.5 | 2107061.8 | 37.765255754741 | -122.463353999562 | (37.765255754741, -122.463353999562) | ||
| 104013 | 104013 | 54736 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1247 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1993 12:00:00 AM | 12 | 5x5 | Permit Number 31998 | 5994208.55249488 | 2107032.01090972 | 37.7651754625969 | -122.463261729084 | (37.7651754625969, -122.463261729084) | |
| 92438 | 92438 | 33008 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1311 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 6x4 | Permit Number 37302 | 5994224.05093468 | 2106581.50911401 | 37.7639393951455 | -122.463175433011 | (37.7639393951455, -122.463175433011) | ||
| 105308 | 105308 | 25271 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
| 110854 | 110854 | 25270 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
| 112191 | 112191 | 25272 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
| 120838 | 120838 | 25273 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
| 98245 | 98245 | 1679 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 350X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5994545.07613 | 2111468.1594 | 37.7773753373943 | -122.462419573309 | (37.7773753373943, -122.462419573309) | |||
| 125376 | 125376 | 97561 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1251X 04th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5994791.4 | 2106981.0 | 37.765068960260294 | -122.461242116604 | (37.7650689602603, -122.461242116604) | ||||
| 143031 | 143031 | 108561 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 141 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995170.0 | 2114629.2 | 37.786090674815604 | -122.460486880145 | (37.7860906748156, -122.460486880145) | ||||
| 94791 | 94791 | 119280 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995293.0 | 2090512.0 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | ||||
| 114487 | 114487 | 119279 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995293.0 | 2090512.0 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | ||||
| 115348 | 115348 | 106967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1225 02ND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.45908784262899 | (37.7657409782079, -122.459087842629) | ||||||
| 82045 | 82045 | 86740 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | |||||
| 77740 | 77740 | 1442 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | |||
| 86675 | 86675 | 121337 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5995656.55399656 | 2107084.69972772 | 37.765403444810204 | -122.45825728758899 | (37.7654034448102, -122.458257287589) | ||||
| 118402 | 118402 | 54199 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | 4x4 | Permit Number 9937 | 5995656.55399656 | 2107084.69972772 | 37.765403444810204 | -122.45825728758899 | (37.7654034448102, -122.458257287589) | ||
| 116674 | 116674 | 113279 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2 Hugo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 5995790.34429445 | 2107089.36315796 | 37.76542393643229 | -122.457794878244 | (37.7654239364323, -122.457794878244) | ||||
| 92293 | 92293 | 106915 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772728 | 5995876.045419999 | 2115884.62189 | 37.7895783172049 | -122.458135060161 | (37.7895783172049, -122.458135060161) | ||||
| 103988 | 103988 | 106916 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3832 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2015 12:00:00 AM | 3 | 5995876.045419999 | 2115884.62189 | 37.7895783172049 | -122.458135060161 | (37.7895783172049, -122.458135060161) | |||
| 110441 | 110441 | 28300 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5995887.0 | 2088090.0 | 37.713261901345 | -122.45608683538099 | (37.713261901345, -122.456086835381) | |||
| 90900 | 90900 | 96407 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | |||||
| 92260 | 92260 | 96411 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2012 12:00:00 AM | Permit Number 768662 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | |||
| 94440 | 94440 | 96410 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767718 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | ||||
| 103095 | 103095 | 96408 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | |||||
| 142605 | 142605 | 96409 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | |||||
| 145603 | 145603 | 97278 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 60 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768156 | 5995934.7 | 2114107.9 | 37.7847032866401 | -122.45780350364599 | (37.7847032866401, -122.457803503646) | |||
| 101501 | 101501 | 117650 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 79 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5996337.0 | 2111626.0 | 37.7779117506286 | -122.456232175702 | (37.7779117506286, -122.456232175702) | |||
| 96381 | 96381 | 117649 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 82 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5996392.0 | 2111672.0 | 37.778041211542 | -122.456045238979 | (37.778041211542, -122.456045238979) | |||
| 99092 | 99092 | 117647 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 86 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5996396.0 | 2111643.0 | 37.777961814765504 | -122.456029304513 | (37.7779618147655, -122.456029304513) | |||
| 108128 | 108128 | 117648 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 86 ROSSI AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5996396.0 | 2111643.0 | 37.777961814765504 | -122.456029304513 | (37.7779618147655, -122.456029304513) | |||
| 49591 | 49591 | 110708 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 77420 | 77420 | 110696 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 99925 | 99925 | 110704 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 110742 | 110742 | 111378 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 125637 | 125637 | 110712 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 127253 | 127253 | 110710 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 140865 | 140865 | 110702 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 141223 | 141223 | 110706 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 83845 | 83845 | 8762 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 87220 | 87220 | 8763 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 97020 | 97020 | 8767 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 117236 | 117236 | 8764 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 120064 | 120064 | 8766 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 143635 | 143635 | 8765 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 144710 | 144710 | 8768 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 106931 | 106931 | 110698 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996770.5 | 2111189.3 | 37.7767375616272 | -122.454700997037 | (37.7767375616272, -122.454700997037) | ||||
| 127933 | 127933 | 92818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 95 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3x3 | Permit Number 53027 | 5996883.0 | 2096019.0 | 37.7350901820695 | -122.453216393363 | (37.7350901820695, -122.453216393363) | ||
| 82477 | 82477 | 20090 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2075X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.45345917871401 | (37.7709958615587, -122.453459178714) | |||
| 86827 | 86827 | 20091 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2075X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.45345917871401 | (37.7709958615587, -122.453459178714) | |||
| 78954 | 78954 | 113001 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 83223 | 83223 | 113004 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 84432 | 84432 | 113005 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 99696 | 99696 | 113009 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 103839 | 103839 | 113010 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 105624 | 105624 | 113002 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 120558 | 120558 | 113000 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 139973 | 139973 | 113003 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 140079 | 140079 | 113008 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 141838 | 141838 | 113006 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 143541 | 143541 | 113007 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 99340 | 99340 | 113158 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1104 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997339.0 | 2106686.0 | 37.764405251212004 | -122.45240935159799 | (37.764405251212, -122.452409351598) | ||||
| 88288 | 88288 | 102825 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2001X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997438.0 | 2109144.0 | 37.77115996155629 | -122.45224431217899 | (37.7711599615563, -122.452244312179) | ||||
| 111842 | 111842 | 102824 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2001X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997438.0 | 2109144.0 | 37.77115996155629 | -122.45224431217899 | (37.7711599615563, -122.452244312179) | ||||
| 125020 | 125020 | 102826 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2001X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997438.0 | 2109144.0 | 37.77115996155629 | -122.45224431217899 | (37.7711599615563, -122.452244312179) | ||||
| 145245 | 145245 | 94600 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1709 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997540.0 | 2108126.0 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | |||||
| 125237 | 125237 | 52226 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 423 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2005 12:00:00 AM | Permit Number 48405 | 5997634.34727934 | 2115023.86499621 | 37.787315780851294 | -122.451989424725 | (37.7873157808513, -122.451989424725) | |||
| 128062 | 128062 | 17122 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1931 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997743.8504099995 | 2109170.01524 | 37.7712489089965 | -122.45118824582701 | (37.7712489089965, -122.451188245827) | |||
| 141432 | 141432 | 112971 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 601x COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5997795.0 | 2108483.0 | 37.7693654697431 | -122.450961770246 | (37.7693654697431, -122.450961770246) |
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");