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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9009 | 9009 | 11172 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2717 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006856.95142 | 2121692.8865 | 37.80615118099271 | -122.42055467348301 | (37.8061511809927, -122.420554673483) | |||
| 9062 | 9062 | 17891 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2243 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x9 | 6003186.0915 | 2115153.6856 | 37.7879886670873 | -122.43279085011999 | (37.7879886670873, -122.43279085012) | |||
| 9077 | 9077 | 18066 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999965.0708 | 2114761.4253 | 37.786728414639505 | -122.443906774886 | (37.7867284146395, -122.443906774886) | |||
| 9087 | 9087 | 11163 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2646 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6006947.21164 | 2121442.50233 | 37.8054687763153 | -122.420224530547 | (37.8054687763153, -122.420224530547) | |||
| 9132 | 9132 | 11160 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2632 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006954.37609 | 2121379.1362 | 37.80529519278 | -122.420195236936 | (37.80529519278, -122.420195236936) | |||
| 9180 | 9180 | 9916 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1990X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005305.17759 | 2116200.067 | 37.790981725181 | -122.42553368453301 | (37.790981725181, -122.425533684533) | |||
| 9210 | 9210 | 11156 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2618 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006962.612869999 | 2121312.5054900004 | 37.80511270594771 | -122.420162000697 | (37.8051127059477, -122.420162000697) | |||
| 9242 | 9242 | 17892 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2249 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003165.9152 | 2115151.8922 | 37.7879825985405 | -122.43286052828002 | (37.7879825985405, -122.43286052828) | |||
| 9243 | 9243 | 17977 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2558 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001719.5728 | 2115004.5111 | 37.7874957889991 | -122.43785404394698 | (37.7874957889991, -122.437854043947) | |||
| 9303 | 9303 | 11157 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2621 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006915.48876 | 2121316.55267 | 37.8051211631688 | -122.420325367033 | (37.8051211631688, -122.420325367033) | |||
| 9309 | 9309 | 17899 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2279 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003065.4822 | 2115140.6832 | 37.787946124669 | -122.433207206924 | (37.787946124669, -122.433207206924) | |||
| 9323 | 9323 | 18065 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999986.084 | 2114760.7686 | 37.786727810113504 | -122.443834027246 | (37.7867278101135, -122.443834027246) | |||
| 9363 | 9363 | 18821 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1855 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6005936.5128 | 2116239.67488 | 37.79112613022821 | -122.423352103743 | (37.7911261302282, -122.423352103743) | |||
| 9421 | 9421 | 18820 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1855 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005909.66344 | 2116240.6882700003 | 37.7911273973734 | -122.42344507383899 | (37.7911273973734, -122.423445073839) | |||
| 9447 | 9447 | 17825 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1924 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2000 12:00:00 AM | 3 | 3X3 | 6004489.9176 | 2115389.1759 | 37.7887091248695 | -122.42829663448299 | (37.7887091248695, -122.428296634483) | ||
| 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) | |||
| 9961 | 9961 | 54316 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1324 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1972 12:00:00 AM | 5x5 | Permit Number 10077 | 5994279.15543647 | 2106492.16366383 | 37.7636972500787 | -122.46297836176001 | (37.7636972500787, -122.46297836176) | ||
| 10358 | 10358 | 37108 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981801.156 | 2106110.4328 | 37.761922478322504 | -122.506106840747 | (37.7619224783225, -122.506106840747) |
| 10463 | 10463 | 37110 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981797.2694 | 2106191.6975 | 37.762145379104204 | -122.506126308526 | (37.7621453791042, -122.506126308526) |
| 10545 | 10545 | 55314 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1108 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 9 | 3x12 | Permit Number 11243 | 6011262.01011 | 2089590.5676900002 | 37.7182526888019 | -122.40305069543301 | (37.7182526888019, -122.403050695433) | |
| 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) | |||
| 10913 | 10913 | 54811 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 179 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774552 | 6009584.74153 | 2095040.5771599999 | 37.7331234617736 | -122.409232703537 | (37.7331234617736, -122.409232703537) | |
| 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) | |||
| 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) |
| 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 | |||||||||
| 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) | ||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 11822 | 11822 | 117429 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 418 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 777101 | 6000919.46363 | 2092339.69207 | 37.72521817457061 | -122.43899732339099 | (37.7252181745706, -122.438997323391) | ||
| 12051 | 12051 | 26281 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1884 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2011 12:00:00 AM | 12 | 3x4 | 6000209.254369999 | 2093016.37684 | 37.7270357601912 | -122.441500974804 | (37.7270357601912, -122.441500974804) | ||
| 12214 | 12214 | 15831 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5179 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1995 12:00:00 AM | 6 | 3X3 | 6000153.213380001 | 2088921.93918 | 37.715790175057 | -122.441401035832 | (37.715790175057, -122.441401035832) | ||
| 12371 | 12371 | 37111 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.3894 | 2106160.9583 | 37.762061102870796 | -122.50611669707199 | (37.7620611028708, -122.506116697072) |
| 12388 | 12388 | 108548 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 231 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773712 | 6001628.81735 | 2093873.1155299998 | 37.7294689416254 | -122.436654875418 | (37.7294689416254, -122.436654875418) |
| 12410 | 12410 | 65623 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 185 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 18 | 3x3 | Permit Number 28530 | 6004571.295580001 | 2094064.8852900001 | 37.730162278453 | -122.426496085951 | (37.730162278453, -122.426496085951) |
| 12722 | 12722 | 117443 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 134 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778577 | 6004618.40487 | 2092601.87765 | 37.72614784693 | -122.42622910508601 | (37.72614784693, -122.426229105086) | ||
| 12946 | 12946 | 37109 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.7427 | 2106129.159 | 37.761973811904795 | -122.506113117253 | (37.7619738119048, -122.506113117253) |
| 13138 | 13138 | 117433 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 157 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776957 | 6000554.87359 | 2091671.7956400001 | 37.72336353237829 | -122.440209797466 | (37.7233635323783, -122.440209797466) | ||
| 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) | ||||
| 13325 | 13325 | 187677 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13326 | 13326 | 187676 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13332 | 13332 | 187674 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13335 | 13335 | 187678 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13336 | 13336 | 187675 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13337 | 13337 | 187679 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13487 | 13487 | 108687 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.1046599997 | 37.756177459246295 | -122.400883423742 | (37.7561774592463, -122.400883423742) | |
| 13498 | 13498 | 60261 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.41226881345301 | (37.7575442102667, -122.412268813453) | |
| 13538 | 13538 | 42043 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 13578 | 13578 | 187698 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008980.17665 | 2103937.78959 | 37.757519353838795 | -122.41195137385 | (37.7575193538388, -122.41195137385) | ||||
| 13680 | 13680 | 39555 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 15 | Permit Number 40979 | 6013094.503190001 | 2106943.24687 | 37.766001649682 | -122.397933106026 | (37.766001649682, -122.397933106026) | ||
| 13811 | 13811 | 3566 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018911.95106 | 2097439.80241 | 37.740229404572396 | -122.377152086609 | (37.7402294045724, -122.377152086609) | ||
| 13814 | 13814 | 10604 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 18 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6017010.864569999 | 2095475.59177 | 37.73473117440221 | -122.383588632512 | (37.7347311744022, -122.383588632512) | ||
| 13816 | 13816 | 3563 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018859.49817 | 2097478.39151 | 37.7403324731777 | -122.37733612657401 | (37.7403324731777, -122.377336126574) | ||
| 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 | |||||||||
| 14102 | 14102 | 3562 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018842.999 | 2097491.0611 | 37.7403663524293 | -122.37739405370701 | (37.7403663524293, -122.377394053707) | ||
| 14104 | 14104 | 39557 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013095.63903 | 2106895.18187 | 37.7658697371335 | -122.39792580534599 | (37.7658697371335, -122.397925805346) | ||
| 14191 | 14191 | 12216 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1523 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1992 12:00:00 AM | 15 | 3X3 | 6015935.5625 | 2095820.8342 | 37.735619647499 | -122.387330428498 | (37.735619647499, -122.387330428498) | ||
| 14314 | 14314 | 3560 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018809.63786 | 2097515.71259 | 37.7404322025979 | -122.377511114855 | (37.7404322025979, -122.377511114855) | ||
| 14614 | 14614 | 22513 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6424 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013017.34088 | 2090082.06317 | 37.7197001044495 | -122.39701766186 | (37.7197001044495, -122.39701766186) | |||
| 14684 | 14684 | 39553 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.35036 | 2107006.086 | 37.7661739606766 | -122.39795187847601 | (37.7661739606766, -122.397951878476) | ||
| 14754 | 14754 | 3564 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018876.34975 | 2097465.88877 | 37.740299071447794 | -122.377276992562 | (37.7402990714478, -122.377276992562) | ||
| 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) | |||
| 15040 | 15040 | 22433 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6000 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1992 12:00:00 AM | 3 | 3X3 | 6013569.5341 | 2091525.6902 | 37.723694738350396 | -122.395209983132 | (37.7236947383504, -122.395209983132) | ||
| 15055 | 15055 | 113527 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6013095.17315 | 2106916.8102 | 37.7659290977746 | -122.39792893408001 | (37.7659290977746, -122.39792893408) | ||||
| 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) | ||
| 15266 | 15266 | 39554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.01553 | 2106989.57845 | 37.7661286159676 | -122.397951878486 | (37.7661286159676, -122.397951878486) | ||
| 15269 | 15269 | 39556 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013089.54039 | 2107025.61956 | 37.7662275503778 | -122.397956050431 | (37.7662275503778, -122.397956050431) | ||
| 15519 | 15519 | 38776 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 660 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/2017 12:00:00 AM | 3 | Permit Number 779488 | 6014510.81012 | 2111730.04342 | 37.7792239033058 | -122.39336936232999 | (37.7792239033058, -122.39336936233) | |
| 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) | |
| 15904 | 15904 | 42044 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16074 | 16074 | 22377 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5538 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014067.3893 | 2092832.2588 | 37.7273099879691 | -122.393580370471 | (37.7273099879691, -122.393580370471) | |||
| 16143 | 16143 | 3559 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018791.21625 | 2097528.24687 | 37.7404656043104 | -122.377575679878 | (37.7404656043104, -122.377575679878) | ||
| 16144 | 16144 | 3565 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018894.06666 | 2097453.02118 | 37.740264715549 | -122.37721484129601 | (37.740264715549, -122.377214841296) | ||
| 16190 | 16190 | 22512 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6424 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013020.80961 | 2090093.5041 | 37.719731712041 | -122.397006473368 | (37.719731712041, -122.397006473368) | |||
| 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 | |||||||||
| 16322 | 16322 | 42042 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16362 | 16362 | 22376 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5538 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014077.5103 | 2092853.4647 | 37.7273687774645 | -122.39354686543601 | (37.7273687774645, -122.393546865436) | |||
| 16500 | 16500 | 42041 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16594 | 16594 | 22437 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6025 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013597.3212 | 2091386.3105 | 37.7233135750036 | -122.39510416905 | (37.7233135750036, -122.39510416905) | |||
| 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) | |||
| 16775 | 16775 | 110930 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6013101.5791 | 2106846.11839 | 37.7657353505351 | -122.397901817734 | (37.7657353505351, -122.397901817734) | ||||
| 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 | ||||||||
| 17053 | 17053 | 10375 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1296 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2007 12:00:00 AM | 12 | 3X3 | 6000028.8313 | 2108866.5222 | 37.7705461558325 | -122.443262625265 | (37.7705461558325, -122.443262625265) | ||
| 17159 | 17159 | 18616 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992096.2291 | 2088496.6198 | 37.7141600639726 | -122.46921850171199 | (37.7141600639726, -122.469218501712) | |||
| 17161 | 17161 | 26495 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2007 12:00:00 AM | 6 | 3x3 | 6008885.38363 | 2102897.90727 | 37.754658753403504 | -122.412205713815 | (37.7546587534035, -122.412205713815) | ||
| 17218 | 17218 | 26701 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1055 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2002 12:00:00 AM | 3 | 3X3 | 6004445.56166 | 2102766.22763 | 37.754047066024704 | -122.427550437605 | (37.7540470660247, -122.427550437605) | ||
| 17238 | 17238 | 27425 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1296 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1999 12:00:00 AM | 12 | 3X3 | 6000045.435 | 2108867.471 | 37.7705497077728 | -122.44320526125601 | (37.7705497077728, -122.443205261256) | ||
| 17331 | 17331 | 26496 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008886.0848199995 | 2102878.04826 | 37.7546042643838 | -122.412201885424 | (37.7546042643838, -122.412201885424) | ||
| 17502 | 17502 | 18578 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 114 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993641.4878 | 2088544.8235 | 37.7143815912468 | -122.463881030417 | (37.7143815912468, -122.463881030417) | |||
| 17690 | 17690 | 18609 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 601 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5992399.8764 | 2088496.7733 | 37.714178026974395 | -122.468168999945 | (37.7141780269744, -122.468168999945) | |||
| 17855 | 17855 | 18594 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 400 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992917.5472 | 2088553.0754 | 37.7143625030062 | -122.466383834117 | (37.7143625030062, -122.466383834117) | |||
| 17955 | 17955 | 10276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004948.0554599995 | 2109498.71961 | 37.7725612966014 | -122.42629199289699 | (37.7725612966014, -122.426291992897) | |||
| 17981 | 17981 | 17200 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200X Olive St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006498.358440001 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | |||
| 18147 | 18147 | 56051 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.768410964941104 | -122.43229368198 | (37.7684109649411, -122.43229368198) | ||
| 18149 | 18149 | 60477 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1343 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | Permit Number 20072 | 6002221.27409585 | 2113110.91985101 | 37.7823249851452 | -122.435982713361 | (37.7823249851452, -122.435982713361) | ||
| 18440 | 18440 | 24552 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 400 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2002 12:00:00 AM | 18 | 3X3 | 6007194.9047 | 2097268.97601 | 37.739107975142495 | -122.41765291735202 | (37.7391079751425, -122.417652917352) | ||
| 18458 | 18458 | 17241 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 17X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993905.3882 | 2088478.8088 | 37.714215535169004 | -122.46296410647699 | (37.714215535169, -122.462964106477) |
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");