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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 261 | 261 | 141359 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1499X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 552 | 552 | 194122 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 557 | 557 | 194124 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 569 | 569 | 194126 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 572 | 572 | 194125 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 573 | 573 | 194127 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 574 | 574 | 194128 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 575 | 575 | 194123 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 587 | 587 | 233050 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3181 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2011 12:00:00 AM | 3 | Width 3ft | 6007759.16475 | 2102654.84325 | 37.7539280965303 | -122.416083280221 | (37.7539280965303, -122.416083280221) | ||
| 606 | 606 | 233049 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3181 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2011 12:00:00 AM | 3 | Width 3ft | 6007718.49924 | 2102654.70617 | 37.753925433618704 | -122.416223901805 | (37.7539254336187, -122.416223901805) | ||
| 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) | |||
| 1557 | 1557 | 251590 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 340x Vicente St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5991910.0 | 2097743.0 | 37.739537567792894 | -122.47053520105601 | (37.7395375677929, -122.470535201056) | ||||
| 1560 | 1560 | 210622 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1386 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | Width 2ft | 5993364.80541 | 2106063.8087299997 | 37.762468389619606 | -122.46610965904699 | (37.7624683896196, -122.466109659047) | ||
| 2198 | 2198 | 252932 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 66 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091179.0 | 37.7218154760893 | -122.451975324711 | (37.7218154760893, -122.451975324711) | |||||
| 2199 | 2199 | 252934 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 78 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091229.0 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | |||||
| 2201 | 2201 | 252933 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 72 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091205.0 | 37.7218868659906 | -122.45197719957199 | (37.7218868659906, -122.451977199572) | |||||
| 2596 | 2596 | 253141 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2597 | 2597 | 253140 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2602 | 2602 | 253139 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2604 | 2604 | 253137 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2605 | 2605 | 253138 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2619 | 2619 | 139012 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2569 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000213.2565 | 2114045.1151 | 37.7847757661737 | -122.442996653485 | (37.7847757661737, -122.442996653485) | |||
| 2684 | 2684 | 233816 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 41 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006595.43726 | 2109656.08938 | 37.7730863765667 | -122.420604692871 | (37.7730863765667, -122.420604692871) | |||
| 4698 | 4698 | 253662 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4701 | 4701 | 253665 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4707 | 4707 | 253664 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4708 | 4708 | 253663 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4710 | 4710 | 253661 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4781 | 4781 | 244068 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 414 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998440.5999 | 2109109.2833 | 37.771122022546294 | -122.448773795857 | (37.7711220225463, -122.448773795857) | |||
| 7754 | 7754 | 112345 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 12 Perine Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6002270.40051 | 2115593.91143 | 37.7891454381677 | -122.435990485098 | (37.7891454381677, -122.435990485098) | |||
| 8184 | 8184 | 117421 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 27 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996647.4398 | 2112726.9752 | 37.7809525538521 | -122.45523784550699 | (37.7809525538521, -122.455237845507) | |||
| 8437 | 8437 | 96380 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 553 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005168.9792 | 2111274.1780000003 | 37.7774487586726 | -122.42565418286301 | (37.7774487586726, -122.425654182863) | |||
| 9537 | 9537 | 137839 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6005239.1389 | 2115489.1761 | 37.7890260654428 | -122.425711556168 | (37.7890260654428, -122.425711556168) | ||||
| 9785 | 9785 | 116718 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 4 | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | ||
| 9786 | 9786 | 173690 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2015 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 9794 | 9794 | 173689 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 9801 | 9801 | 173692 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 9809 | 9809 | 173691 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 11103 | 11103 | 117183 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 163 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6004102.13214 | 2092696.8683900002 | 37.7263794754103 | -122.42802059686899 | (37.7263794754103, -122.428020596869) | |||
| 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) | ||||
| 14876 | 14876 | 96731 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1504 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015860.59929 | 2096653.48415 | 37.7379017837359 | -122.38764768211 | (37.7379017837359, -122.38764768211) | |||
| 15185 | 15185 | 71390 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1530 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1988 12:00:00 AM | 1 | 3x3 | 6015584.85469 | 2096508.0059099998 | 37.7374870523836 | -122.38859092252599 | (37.7374870523836, -122.388590922526) | ||
| 15538 | 15538 | 114498 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 506 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777227 | 6013489.27726 | 2111373.9955599997 | 37.778189468908 | -122.39687832179199 | (37.778189468908, -122.396878321792) | |
| 16706 | 16706 | 102011 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 469 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6014033.25215 | 2112677.25893 | 37.7817981973592 | -122.395087809375 | (37.7817981973592, -122.395087809375) | |||
| 22302 | 22302 | 232948 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 347 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2017 12:00:00 AM | 3 | Width 3ft | 6004812.4927199995 | 2101688.42216 | 37.7511084107379 | -122.426204773027 | (37.7511084107379, -122.426204773027) | ||
| 22850 | 22850 | 232995 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 117 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999304.36377 | 2107674.97359 | 37.7672331264423 | -122.44568285378901 | (37.7672331264423, -122.445682853789) | |||
| 22907 | 22907 | 233756 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.04868 | 2107994.1327400003 | 37.768245263926396 | -122.43746090722 | (37.7682452639264, -122.43746090722) | |||
| 22988 | 22988 | 70383 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | ||
| 23586 | 23586 | 210746 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5 Hugo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5995733.91674 | 2107044.02445 | 37.7652962061742 | -122.45798676557301 | (37.7652962061742, -122.457986765573) | |||
| 23632 | 23632 | 131925 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 751 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009171.50405 | 2115581.46122 | 37.789500881707895 | -122.412112560256 | (37.7895008817079, -122.412112560256) | |||
| 23652 | 23652 | 210826 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994426.39557 | 2101510.85772 | 37.7500283438364 | -122.462107837801 | (37.7500283438364, -122.462107837801) | |||
| 23668 | 23668 | 246223 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 78 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999336.3954 | 2107868.6288 | 37.767766683653896 | -122.44558598872601 | (37.7677666836539, -122.445585988726) | |||
| 23677 | 23677 | 233712 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4400 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001386.36506 | 2104686.2053799997 | 37.7591453514935 | -122.438267391334 | (37.7591453514935, -122.438267391334) | |||
| 23702 | 23702 | 132037 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 647 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012462.86272 | 2118420.8665299998 | 37.7974813378361 | -122.400924323116 | (37.7974813378361, -122.400924323116) | |||
| 23778 | 23778 | 137982 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2281 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002983.8805 | 2115127.6807 | 37.7879057937101 | -122.433488604212 | (37.7879057937101, -122.433488604212) | |||
| 23841 | 23841 | 233141 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 528 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001164.95753 | 2103181.4854099997 | 37.7550011603929 | -122.438925288565 | (37.7550011603929, -122.438925288565) | |||
| 23958 | 23958 | 233168 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 806 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5999143.21873 | 2107567.8605400003 | 37.7669298192955 | -122.446232523009 | (37.7669298192955, -122.446232523009) | |||
| 23994 | 23994 | 142494 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 495 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6010611.2205 | 2119595.5653 | 37.800603314635 | -122.40741438161999 | (37.800603314635, -122.40741438162) | |||
| 24011 | 24011 | 247408 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 990 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001866.3003 | 2109465.7283 | 37.7722960331347 | -122.436949719287 | (37.7722960331347, -122.436949719287) | |||
| 24042 | 24042 | 139986 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 625 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005793.4562 | 2111911.0062 | 37.779232600697206 | -122.42353919478201 | (37.7792326006972, -122.423539194782) | |||
| 24257 | 24257 | 246725 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 159 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6008962.35356 | 2099130.96939 | 37.744319899838295 | -122.411673386218 | (37.7443198998383, -122.411673386218) | |||
| 24272 | 24272 | 233804 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 220 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001999.2647400005 | 2096183.36607 | 37.7358334050816 | -122.43553941123501 | (37.7358334050816, -122.435539411235) | |||
| 24348 | 24348 | 233007 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 51 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6007335.8858199995 | 2099205.3862900003 | 37.744432859197104 | -122.417302653917 | (37.7444328591971, -122.417302653917) | |||
| 24362 | 24362 | 73557 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 15 | 5982628.313080001 | 2110748.29603 | 37.774705372511704 | -122.50358954053301 | (37.7747053725117, -122.503589540533) | ||
| 24398 | 24398 | 178021 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 501 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6009115.97426 | 2093800.21325 | 37.729691414114704 | -122.41076579579901 | (37.7296914141147, -122.410765795799) | |||
| 24498 | 24498 | 210813 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 486 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994698.943 | 2100017.50065 | 37.745943650072704 | -122.46105713288401 | (37.7459436500727, -122.461057132884) | |||
| 24611 | 24611 | 178026 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 104 Burrows St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011109.90647 | 2093496.75882 | 37.728969789123795 | -122.40385117479299 | (37.7289697891238, -122.403851174793) | |||
| 24651 | 24651 | 233122 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1709 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002632.870680001 | 2100541.09171 | 37.7478346734395 | -122.433660134801 | (37.7478346734395, -122.433660134801) | |||
| 24652 | 24652 | 233126 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1411 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6003310.36641 | 2099907.98672 | 37.746134733540394 | -122.431272203649 | (37.7461347335404, -122.431272203649) | |||
| 24783 | 24783 | 194129 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 627 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010999.839380001 | 2105288.3790700003 | 37.7613408754141 | -122.405061627211 | (37.7613408754141, -122.405061627211) | |||
| 24794 | 24794 | 232951 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 410 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003772.35083 | 2100138.80282 | 37.7467946713417 | -122.429691180205 | (37.7467946713417, -122.429691180205) | |||
| 24808 | 24808 | 210655 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 302 Westgate Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 5993736.1298400005 | 2094686.96853 | 37.731251887161605 | -122.463999505972 | (37.7312518871616, -122.463999505972) | |||
| 24859 | 24859 | 233808 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 279 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003794.40206 | 2097833.5267 | 37.7404661636783 | -122.42945055851101 | (37.7404661636783, -122.429450558511) | |||
| 24979 | 24979 | 177920 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Juan Bautista Cir | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989764.376630001 | 2089755.55448 | 37.7174817656499 | -122.477370148614 | (37.7174817656499, -122.477370148614) | ||||
| 25046 | 25046 | 131983 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2445 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006960.65003 | 2120965.01562 | 37.8041584766956 | -122.420144116771 | (37.8041584766956, -122.420144116771) | |||
| 25290 | 25290 | 233726 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 84 Seward St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6000741.8111 | 2104532.41656 | 37.7586864040831 | -122.44048553140699 | (37.7586864040831, -122.440485531407) | |||
| 25292 | 25292 | 177947 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | ||||
| 25299 | 25299 | 177894 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 350 Rutland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010334.18865 | 2088569.51073 | 37.715397218989104 | -122.406185898468 | (37.7153972189891, -122.406185898468) | |||
| 25372 | 25372 | 210752 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1324 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994275.3966 | 2106492.95791 | 37.7636992143574 | -122.462991419941 | (37.7636992143574, -122.462991419941) | |||
| 25443 | 25443 | 210773 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 530 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992612.70871 | 2103920.27322 | 37.7565393833141 | -122.46855489411199 | (37.7565393833141, -122.468554894112) | |||
| 25449 | 25449 | 232967 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1350 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5998278.03823 | 2105754.12772 | 37.7619003184538 | -122.449094356436 | (37.7619003184538, -122.449094356436) | |||
| 25467 | 25467 | 232850 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 835 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008576.94223 | 2103670.76544 | 37.7567635348198 | -122.41332704252198 | (37.7567635348198, -122.413327042522) | |||
| 25527 | 25527 | 184919 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1990 41st Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5983531.226 | 2102116.9441 | 37.7510591687413 | -122.499828114856 | (37.7510591687413, -122.499828114856) | |||
| 25540 | 25540 | 183635 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1466 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5983120.0142 | 2105165.2765 | 37.759404895189206 | -122.501475581309 | (37.7594048951892, -122.501475581309) | |||
| 25601 | 25601 | 233731 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 220 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999972.34566 | 2104826.41144 | 37.759449797175996 | -122.44316780075 | (37.759449797176, -122.44316780075) | |||
| 25627 | 25627 | 132022 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 928 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007892.79628 | 2120308.15692 | 37.8024073851468 | -122.416871780604 | (37.8024073851468, -122.416871780604) | |||
| 25713 | 25713 | 210777 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1369 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 5994856.84062 | 2106234.38155 | 37.7630227056673 | -122.46096165726401 | (37.7630227056673, -122.460961657264) | |||
| 25729 | 25729 | 233231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010116.17645 | 2099679.88413 | 37.7458917573937 | -122.407722389299 | (37.7458917573937, -122.407722389299) | |||
| 25730 | 25730 | 233142 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000859.74729 | 2102942.63257 | 37.754327958491395 | -122.43996366469901 | (37.7543279584914, -122.439963664699) | |||
| 25753 | 25753 | 233662 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 705 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001773.52582 | 2102030.32272 | 37.7518749496793 | -122.436738290261 | (37.7518749496793, -122.436738290261) | |||
| 25782 | 25782 | 119454 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5985729.2789 | 2110639.79727 | 37.774589291809605 | -122.492854831906 | (37.7745892918096, -122.492854831906) | |||
| 25825 | 25825 | 233757 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.84947 | 2107982.08951 | 37.7682122417201 | -122.437457274854 | (37.7682122417201, -122.437457274854) | |||
| 25849 | 25849 | 210744 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5995697.70658 | 2107044.30758 | 37.765294903062504 | -122.45811202766701 | (37.7652949030625, -122.458112027667) | |||
| 25936 | 25936 | 210838 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 459 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5995438.73644 | 2095838.0782299999 | 37.7345105311276 | -122.458196607982 | (37.7345105311276, -122.458196607982) | |||
| 25961 | 25961 | 131900 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3201 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5999404.71857 | 2115660.50969 | 37.78916508563879 | -122.44591014126301 | (37.7891650856388, -122.445910141263) | |||
| 26009 | 26009 | 233688 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3922 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6003611.35002 | 2102468.43806 | 37.753182186212705 | -122.430414095727 | (37.7531821862127, -122.430414095727) | |||
| 26049 | 26049 | 233051 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3165 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007206.48709 | 2103796.8023599996 | 37.757032564312205 | -122.41807552586 | (37.7570325643122, -122.41807552586) | |||
| 26122 | 26122 | 70370 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.50148010954901 | (37.7594698688276, -122.501480109549) | ||
| 26176 | 26176 | 210849 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 32 Valletta Ct | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999399.23324 | 2096649.47402 | 37.73696521176579 | -122.444562201393 | (37.7369652117658, -122.444562201393) | |||
| 26226 | 26226 | 233777 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 25 Temple St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999970.72676 | 2105847.0932 | 37.7622522447563 | -122.44324670907 | (37.7622522447563, -122.44324670907) |
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");