Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3486 | 3486 | 39483 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 6162 | 6162 | 35284 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 6472 | 6472 | 39482 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 8735 | 8735 | 35281 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 9279 | 9279 | 19768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 11312 | 11312 | 35280 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 12551 | 12551 | 19769 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 12682 | 12682 | 19875 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 13846 | 13846 | 35283 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 14026 | 14026 | 17630 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10M | ||||||||
| 16213 | 16213 | 35285 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 16886 | 16886 | 39481 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 152396 | 152396 | 177857 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010447.87727 | 2086216.0665099998 | 37.7089414959281 | -122.40562727470501 | (37.7089414959281, -122.405627274705) | |||
| 70441 | 70441 | 177856 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010405.93473 | 2086233.7709700002 | 37.7089877633386 | -122.405773481086 | (37.7089877633386, -122.405773481086) | |||
| 183428 | 183428 | 177855 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010393.78556 | 2086237.29466 | 37.7089967592527 | -122.40581571863301 | (37.7089967592527, -122.405815718633) | |||
| 148750 | 148750 | 177906 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008626.38347 | 2086318.08135 | 37.709119583283204 | -122.411929844982 | (37.7091195832832, -122.411929844982) | |||
| 41427 | 41427 | 177907 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008650.42437 | 2086374.37251 | 37.7092754960461 | -122.411850730737 | (37.7092754960461, -122.411850730737) | |||
| 38147 | 38147 | 177908 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008656.15761 | 2086392.69055 | 37.7093261152759 | -122.411832209211 | (37.7093261152759, -122.411832209211) | |||
| 159797 | 159797 | 177909 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008661.36431 | 2086409.07843 | 37.7093714051391 | -122.411815371178 | (37.7093714051391, -122.411815371178) | |||
| 155933 | 155933 | 177910 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008668.51888 | 2086425.42684 | 37.7094166958987 | -122.41179179815201 | (37.7094166958987, -122.411791798152) | |||
| 132730 | 132730 | 71684 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 163 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994555.12862 | 2086427.38157 | 37.7086202032335 | -122.46056980286501 | (37.7086202032335, -122.460569802865) | ||
| 182322 | 182322 | 177911 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008674.6498300005 | 2086439.3705 | 37.7094553262778 | -122.411771593104 | (37.7094553262778, -122.411771593104) | |||
| 39071 | 39071 | 114959 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 517 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 1 | Permit Number 776031 | 6002108.88292 | 2086505.1138400002 | 37.7092653220046 | -122.43446864782801 | (37.7092653220046, -122.434468647828) | ||
| 10746 | 10746 | 15961 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5873 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2015 12:00:00 AM | 3 | 3X3 | 5997080.5771 | 2086512.6894900003 | 37.7089994077614 | -122.451847724407 | (37.7089994077614, -122.451847724407) | ||
| 63848 | 63848 | 177912 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994504.97936 | 2086701.6160799998 | 37.709370301666496 | -122.460762984428 | (37.7093703016665, -122.460762984428) | |||
| 151015 | 151015 | 63750 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 257 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/1987 12:00:00 AM | 4 | 3x3 | Permit Number 53166 | 5994190.03084 | 2086756.5319400001 | 37.709502961550704 | -122.46185546915501 | (37.7095029615507, -122.461855469155) | |
| 10744 | 10744 | 15929 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997783.780180001 | 2086793.9366099997 | 37.7098118993789 | -122.44943761417 | (37.7098118993789, -122.44943761417) | ||
| 69604 | 69604 | 178039 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 215 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002599.14033 | 2086803.44628 | 37.71011229540329 | -122.432795540083 | (37.7101122954033, -122.432795540083) | |||
| 11196 | 11196 | 15930 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5763 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997809.15318 | 2086804.3845099998 | 37.709842038350104 | -122.449350673092 | (37.7098420383501, -122.449350673092) | ||
| 148212 | 148212 | 178040 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 215 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002585.09291 | 2086817.5954900002 | 37.7101503493261 | -122.432845100837 | (37.7101503493261, -122.432845100837) | |||
| 11149 | 11149 | 61515 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 84 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 21471 | 5994704.395 | 2086819.71376 | 37.7097060419596 | -122.46008232624901 | (37.7097060419596, -122.460082326249) |
| 33054 | 33054 | 178041 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 215 Naylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002576.293869999 | 2086830.5865599997 | 37.710185520909704 | -122.432876439519 | (37.7101855209097, -122.432876439519) | |||
| 95542 | 95542 | 44455 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Winding Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.43287934894899 | (37.710288143695, -122.432879348949) | ||
| 49450 | 49450 | 44449 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 81 Winding Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002622.57283 | 2086916.9861 | 37.7104253799983 | -122.432722658146 | (37.7104253799983, -122.432722658146) | ||
| 165199 | 165199 | 44450 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 81 Winding Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2003 12:00:00 AM | 4 | Permit Number 43778 | 6002632.26196 | 2086926.6553900002 | 37.7104524792676 | -122.43268986074699 | (37.7104524792676, -122.432689860747) | ||
| 43150 | 43150 | 178032 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 125 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002475.307030001 | 2086957.14807 | 37.710527302863895 | -122.433234507292 | (37.7105273028639, -122.433234507292) | |||
| 12362 | 12362 | 15901 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | 20 | 5998236.34112 | 2087033.73083 | 37.710496198018 | -122.447890739788 | (37.710496198018, -122.447890739788) | ||
| 13018 | 13018 | 15903 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | TR20 | 5998269.83738 | 2087060.55751 | 37.7105717725495 | -122.44777690001101 | (37.7105717725495, -122.447776900011) | ||
| 108581 | 108581 | 31670 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 305 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35178 | 6012134.6965622 | 2087196.99456235 | 37.7117291112295 | -122.399866184073 | (37.7117291112295, -122.399866184073) | ||||
| 89873 | 89873 | 15889 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5630 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1992 12:00:00 AM | 3 | 3x3 | 5998415.18601 | 2087264.5308400001 | 37.711140143475106 | -122.447289216406 | (37.7111401434751, -122.447289216406) | ||
| 11618 | 11618 | 15887 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5619 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5998592.6313 | 2087274.30395 | 37.71117711610329 | -122.44667662714501 | (37.7111771161033, -122.446676627145) | ||
| 177572 | 177572 | 177875 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5630 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998500.806059999 | 2087290.46658 | 37.711216249215106 | -122.446995158907 | (37.7112162492151, -122.446995158907) | |||
| 160364 | 160364 | 78800 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Curtis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 4 | 6000803.49845 | 2087336.8275799998 | 37.7114748366708 | -122.439039819944 | (37.7114748366708, -122.439039819944) | ||
| 38995 | 38995 | 177874 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1222 Naples St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6001049.49395 | 2087346.60283 | 37.711515671269495 | -122.43819029695801 | (37.7115156712695, -122.438190296958) | |||
| 105065 | 105065 | 80930 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 4 | 6000799.22346 | 2087352.62937 | 37.7115179816306 | -122.439055727159 | (37.7115179816306, -122.439055727159) | ||
| 161510 | 161510 | 44441 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 31 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 10 | Permit Number 43773 | 6002845.03197 | 2087419.58283 | 37.711818015263 | -122.43198965849399 | (37.711818015263, -122.431989658494) | |
| 38615 | 38615 | 177876 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4117 San Bruno Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 37 | Width 10ft | 6011467.53014 | 2087476.31968 | 37.7124588649577 | -122.40219173226299 | (37.7124588649577, -122.402191732263) | |||
| 37757 | 37757 | 31048 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34804 | 6002823.26013 | 2087491.091 | 37.7120131267777 | -122.432070011132 | (37.7120131267777, -122.432070011132) | |
| 174511 | 174511 | 177879 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 13 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6002815.59518 | 2087508.97249 | 37.7120617908816 | -122.432097779506 | (37.7120617908816, -122.432097779506) | |||
| 169004 | 169004 | 210729 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2950 San Jose Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5996042.96304 | 2087509.5172700002 | 37.711676981779 | -122.455505847225 | (37.711676981779, -122.455505847225) | |||
| 33687 | 33687 | 177899 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 50 Cora St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009624.90275 | 2087518.7442 | 37.712472329600104 | -122.40856343616801 | (37.7124723296001, -122.408563436168) | |||
| 131631 | 131631 | 177898 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 50 Cora St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009629.15466 | 2087530.63547 | 37.7125052187279 | -122.40854957849702 | (37.7125052187279, -122.408549578497) | |||
| 54288 | 54288 | 54784 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 201 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50703 | 6012788.79472 | 2087552.61474 | 37.7127420182918 | -122.39763035375401 | (37.7127420182918, -122.397630353754) | |
| 149401 | 149401 | 177897 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 50 Cora St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009646.02707 | 2087571.54793 | 37.7126185009114 | -122.40849414611 | (37.7126185009114, -122.40849414611) | |||
| 66748 | 66748 | 177896 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 50 Cora St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009653.1272 | 2087592.03175 | 37.712675142925704 | -122.40847104971701 | (37.7126751429257, -122.408471049717) | |||
| 187094 | 187094 | 177895 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 50 Cora St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009660.88165 | 2087611.8363599998 | 37.7127299566062 | -122.40844564386002 | (37.7127299566062, -122.40844564386) | |||
| 69485 | 69485 | 178036 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1262 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001366.699019999 | 2087629.73168 | 37.7123111162496 | -122.437114213161 | (37.7123111162496, -122.437114213161) | |||
| 53834 | 53834 | 178037 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1262 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001347.43363 | 2087637.9116200001 | 37.7123324814346 | -122.43718138530701 | (37.7123324814346, -122.437181385307) | |||
| 29515 | 29515 | 177900 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 51 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009124.10018 | 2087641.97252 | 37.712782628998 | -122.410303065847 | (37.712782628998, -122.410303065847) | |||
| 164587 | 164587 | 178038 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1262 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001333.95173 | 2087644.77472 | 37.7123505596017 | -122.437228473815 | (37.7123505596017, -122.437228473815) | |||
| 165948 | 165948 | 177878 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 271 Leland Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009620.35706 | 2087649.33053 | 37.7128306384044 | -122.40858835368401 | (37.7128306384044, -122.408588353684) | |||
| 185746 | 185746 | 177885 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 145 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010318.896819999 | 2087650.5759299998 | 37.7128731556567 | -122.406174049896 | (37.7128731556567, -122.406174049896) | |||
| 129936 | 129936 | 177901 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 51 Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009128.04855 | 2087650.6090400002 | 37.7128065644385 | -122.41029002836399 | (37.7128065644385, -122.410290028364) | |||
| 45353 | 45353 | 177877 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 271 Leland Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009599.34513 | 2087657.02792 | 37.7128505970487 | -122.40866152071399 | (37.7128505970487, -122.408661520714) | |||
| 51578 | 51578 | 177884 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 157 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010304.96026 | 2087658.7240799998 | 37.7128947492701 | -122.406222793148 | (37.7128947492701, -122.406222793148) | |||
| 56786 | 56786 | 177902 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 51 Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009132.1984 | 2087661.6081700001 | 37.712836998413295 | -122.410276461197 | (37.7128369984133, -122.410276461197) | |||
| 170424 | 170424 | 177903 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 51 Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009134.31726 | 2087671.14606 | 37.712863306274 | -122.41026981070401 | (37.712863306274, -122.410269810704) | |||
| 51098 | 51098 | 177904 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 51 Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009137.70556 | 2087680.0190299999 | 37.7128878595589 | -122.410258725671 | (37.7128878595589, -122.410258725671) | |||
| 61080 | 61080 | 177905 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 51 Schwerin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009142.42849 | 2087691.4201200001 | 37.71291942935311 | -122.410243206079 | (37.7129194293531, -122.410243206079) | |||
| 88114 | 88114 | 31049 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34804 | 6002647.46614225 | 2087728.93921016 | 37.712656237769 | -122.43269458445499 | (37.712656237769, -122.432694584455) | ||
| 38873 | 38873 | 210723 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 221 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994792.877090001 | 2087738.8858400001 | 37.7122349616579 | -122.459843056229 | (37.7122349616579, -122.459843056229) | |||
| 169107 | 169107 | 210722 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 289 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994123.30764 | 2087748.05271 | 37.7122216022051 | -122.46215793366699 | (37.7122216022051, -122.462157933667) | |||
| 180045 | 180045 | 210721 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 291 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994097.27835 | 2087749.40952 | 37.7122238289438 | -122.462247996255 | (37.7122238289438, -122.462247996255) | |||
| 58490 | 58490 | 210720 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 293 Sadowa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994069.59594 | 2087749.5845700002 | 37.7122227155888 | -122.462343686818 | (37.7122227155888, -122.462343686818) | |||
| 185016 | 185016 | 210719 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 293 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994040.58934 | 2087749.69636 | 37.712221352204295 | -122.46244394955099 | (37.7122213522043, -122.462443949551) | |||
| 140744 | 140744 | 52763 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 214@ CAPITOL Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | Permit Number 48805 | 5994863.65888503 | 2087784.21075389 | 37.712363483607604 | -122.459601695791 | (37.7123634836076, -122.459601695791) | |||
| 56704 | 56704 | 210724 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 290 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5994126.31953 | 2087786.89432 | 37.712328425493 | -122.46215033886499 | (37.712328425493, -122.462150338865) | |||
| 148081 | 148081 | 178035 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6002505.07902 | 2087811.4607 | 37.7128747474362 | -122.433192611453 | (37.7128747474362, -122.433192611453) | ||||
| 188176 | 188176 | 178034 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6002495.00651 | 2087816.3446 | 37.7128875861582 | -122.433227774048 | (37.7128875861582, -122.433227774048) | ||||
| 136110 | 136110 | 178033 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6002471.97564 | 2087830.38013 | 37.712924818104 | -122.433308378475 | (37.712924818104, -122.433308378475) | ||||
| 30072 | 30072 | 177889 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 151 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010419.89966 | 2087893.48861 | 37.7135457936846 | -122.405842049878 | (37.7135457936846, -122.405842049878) | |||
| 58990 | 58990 | 177888 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 153 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010396.8058 | 2087905.2937 | 37.713576916505 | -122.405922701993 | (37.713576916505, -122.405922701993) | |||
| 175931 | 175931 | 177886 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 150 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010436.543880001 | 2087928.28734 | 37.7136422747528 | -122.405786970918 | (37.7136422747528, -122.405786970918) | |||
| 132067 | 132067 | 112519 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 152x Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6010410.07132 | 2087941.8611 | 37.7136780650609 | -122.4058794257 | (37.7136780650609, -122.4058794257) | |||
| 186091 | 186091 | 177887 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 154 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010389.20709 | 2087951.35398 | 37.7137029636965 | -122.405952208735 | (37.7137029636965, -122.405952208735) | |||
| 10809 | 10809 | 15867 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5425 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5 | 5999480.671080001 | 2088101.53675 | 37.713499198913105 | -122.443666741949 | (37.7134991989131, -122.443666741949) | |||
| 65088 | 65088 | 64630 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 68 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1988 12:00:00 AM | 1 | Permit Number 25540 | 6000598.45356 | 2088164.29184 | 37.7137351998869 | -122.43980779510599 | (37.7137351998869, -122.439807795106) | ||
| 923 | 923 | 210740 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992981.0390099995 | 2088189.5314 | 37.7133679617255 | -122.46613798048901 | (37.7133679617255, -122.466137980489) | |||
| 13255 | 13255 | 187618 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993007.0 | 2088191.0 | 37.71337349192 | -122.466048357651 | (37.71337349192, -122.466048357651) | ||||
| 52483 | 52483 | 50498 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 924 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 6 | Permit Number 47135 | 6002542.62317 | 2088276.7856400001 | 37.714154557357396 | -122.433096072852 | (37.7141545573574, -122.433096072852) | |
| 76381 | 76381 | 177864 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 989 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001714.742380001 | 2088380.4067900002 | 37.7143920818056 | -122.43596495333999 | (37.7143920818056, -122.43596495334) | |||
| 159832 | 159832 | 210712 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 227 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994692.03797 | 2088381.3818400002 | 37.713993304434794 | -122.460238104111 | (37.7139933044348, -122.460238104111) | |||
| 156805 | 156805 | 177865 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 989 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001720.67634 | 2088389.3755700001 | 37.7144170451902 | -122.43594508462 | (37.7144170451902, -122.43594508462) | |||
| 151492 | 151492 | 177866 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 989 Naples St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001726.64511 | 2088400.0268 | 37.714446630183794 | -122.43592521588002 | (37.7144466301838, -122.43592521588) | |||
| 162821 | 162821 | 210714 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 224 Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994962.32691 | 2088416.70249 | 37.714105830292894 | -122.459306446031 | (37.7141058302929, -122.459306446031) | |||
| 135625 | 135625 | 210713 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 224 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994996.38337 | 2088416.88945 | 37.7141083016242 | -122.459188748187 | (37.7141083016242, -122.459188748187) | |||
| 123829 | 123829 | 210715 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 224 Farallones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994922.2648 | 2088417.5413900001 | 37.7141058303022 | -122.459444975802 | (37.7141058303022, -122.459444975802) | |||
| 75659 | 75659 | 210716 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 224 Farallones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994841.51939 | 2088418.33199 | 37.7141033580681 | -122.459724118176 | (37.7141033580681, -122.459724118176) | |||
| 154264 | 154264 | 210718 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 226 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994722.186319999 | 2088418.43072 | 37.714096766037706 | -122.46013658323099 | (37.7140967660377, -122.460136583231) | |||
| 173729 | 173729 | 210717 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 224 Farallones St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994757.1654199995 | 2088419.4987599999 | 37.7141017105016 | -122.460015760244 | (37.7141017105016, -122.460015760244) |
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");