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 | ||||||||
| 32605 | 32605 | 119134 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 507 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5981280.05518 | 2112253.74511 | 37.7787595315686 | -122.508365127423 | (37.7787595315686, -122.508365127423) | |||
| 65377 | 65377 | 68999 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1937 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 3 | Permit Number 32993 | 5981324.2082 | 2101884.9559 | 37.750292434094796 | -122.507442861533 | (37.7502924340948, -122.507442861533) | |
| 182282 | 182282 | 87129 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 7316 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50078 | 5981335.81938 | 2110728.67919 | 37.774575436536296 | -122.508059002234 | (37.7745754365363, -122.508059002234) | |
| 187501 | 187501 | 92258 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 891 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52707 | 5981374.1327 | 2109674.4758 | 37.7716831604786 | -122.507848221548 | (37.7716831604786, -122.507848221548) | |
| 48927 | 48927 | 92255 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 854 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52705 | 5981409.481930001 | 2109900.456 | 37.7723057186543 | -122.50774272070801 | (37.7723057186543, -122.507742720708) | |
| 152603 | 152603 | 37100 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1538 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 6 | Permit Number 46585 | 5981585.228999999 | 2104585.7036 | 37.757723294748104 | -122.506740540912 | (37.7577232947481, -122.506740540912) | |
| 68316 | 68316 | 92241 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 542 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52687 | 5981642.07316 | 2112062.15681 | 37.778254814708205 | -122.507098571159 | (37.7782548147082, -122.507098571159) | |
| 63763 | 63763 | 118835 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 628 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5981667.457880001 | 2111440.07687 | 37.776548261466 | -122.50696460088498 | (37.776548261466, -122.506964600885) | |||
| 174315 | 174315 | 48887 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3616 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 0 | Permit Number 46093 | 5981682.07511006 | 2099461.07988631 | 37.743658222157 | -122.506025661966 | (37.743658222157, -122.506025661966) | ||
| 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) |
| 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) |
| 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) |
| 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) |
| 161638 | 161638 | 37128 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1501 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 8 | 2x2 | Permit Number 39712 | 5981844.8018 | 2104832.4428 | 37.7584160519707 | -122.505861139063 | (37.7584160519707, -122.505861139063) | |
| 66425 | 66425 | 37126 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1503 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | 2x2 | Permit Number 39712 | 5981845.4129 | 2104790.8867 | 37.758301986720795 | -122.505855944814 | (37.7583019867208, -122.505855944814) |
| 173551 | 173551 | 184274 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1503 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5981845.7185 | 2104811.6648 | 37.7583590554552 | -122.50585642834999 | (37.7583590554552, -122.50585642835) | |||
| 71917 | 71917 | 37088 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1515 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | Permit Number 39688 | 5981846.9407 | 2104770.7198 | 37.7582467040795 | -122.50584916600401 | (37.7582467040795, -122.505849166004) | |
| 149494 | 149494 | 183627 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1442 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981873.5609 | 2105253.9792 | 37.759575163504 | -122.505792929352 | (37.759575163504, -122.505792929352) | |||
| 103067 | 103067 | 115238 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 589 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775584 | 5981901.6 | 2111755.2 | 37.777427283208496 | -122.506178021462 | (37.7774272832085, -122.506178021462) | |||
| 29115 | 29115 | 68565 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 599 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32455 | 5981915.91303 | 2111733.97216 | 37.777369840379 | -122.50612693446101 | (37.777369840379, -122.506126934461) | |
| 150815 | 150815 | 119068 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 589 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5981917.84784 | 2111763.83691 | 37.7774519540971 | -122.506122456369 | (37.7774519540971, -122.506122456369) | |||
| 47607 | 47607 | 101528 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 819 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769457 | 5981975.18641 | 2110162.57659 | 37.773058737344996 | -122.505805367237 | (37.773058737345, -122.505805367237) | |
| 135220 | 135220 | 47823 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 762 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52683 | 5982005.2592 | 2110568.08729 | 37.7741739213091 | -122.50573141072901 | (37.7741739213091, -122.505731410729) | |
| 176647 | 176647 | 184364 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2255 46th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5982017.5295 | 2099742.21 | 37.7444498680839 | -122.50488658971099 | (37.7444498680839, -122.504886589711) | |||
| 41953 | 41953 | 78551 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | ||
| 43090 | 43090 | 183669 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1331 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982114.4178 | 2105996.5592 | 37.7616282496531 | -122.50501497063 | (37.7616282496531, -122.50501497063) | |||
| 9822 | 9822 | 822 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1411 45th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:39:00 PM | 3 | 3X3 | 5982129.0913294 | 2105488.1375738997 | 37.7602331322527 | -122.50492654488 | (37.7602331322527, -122.50492654488) | ||
| 10518 | 10518 | 820 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1407 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:29:00 PM | 3 | 3X3 | 5982131.0395 | 2105513.2639 | 37.760302236597 | -122.504921669151 | (37.760302236597, -122.504921669151) | ||
| 10681 | 10681 | 821 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1409 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:34:00 PM | 3 | 3X3 | 5982132.645 | 2105492.3927 | 37.7602450246853 | -122.504914569939 | (37.7602450246853, -122.504914569939) | ||
| 135687 | 135687 | 38377 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3815 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1998 12:00:00 AM | 2 | Permit Number 40436 | 5982149.2806 | 2102814.4314 | 37.7528930799905 | -122.50465861474702 | (37.7528930799905, -122.504658614747) | |
| 71427 | 71427 | 183626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1442 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5982184.0203 | 2105272.8436 | 37.7596452277361 | -122.504720622161 | (37.7596452277361, -122.504720622161) | |||
| 135519 | 135519 | 70226 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1466 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 10 | 5982190.0408 | 2105127.5478 | 37.759246640966 | -122.504689034952 | (37.759246640966, -122.504689034952) | ||
| 164192 | 164192 | 38339 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1506 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 6 | Permit Number 40406 | 5982199.9382 | 2104810.9773 | 37.758378010542295 | -122.504631350136 | (37.7583780105423, -122.504631350136) | |
| 159630 | 159630 | 119060 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 530 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5982260.535069999 | 2112121.88735 | 37.778455222474705 | -122.504963547902 | (37.7784552224747, -122.504963547902) | |||
| 187162 | 187162 | 68554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 735 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 777390 | 5982265.00656 | 2110745.36563 | 37.7746759600384 | -122.504846052747 | (37.7746759600384, -122.504846052747) | |
| 43551 | 43551 | 106546 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 644 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 772940 | 5982289.0297300005 | 2111361.80008 | 37.7763699221041 | -122.504808639708 | (37.7763699221041, -122.504808639708) | |
| 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) | ||
| 181019 | 181019 | 55603 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 655 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 2 | Permit Number 11578 | 5982556.76294 | 2111288.6784099997 | 37.7761848980348 | -122.50387707418899 | (37.7761848980348, -122.503877074189) | ||
| 70987 | 70987 | 55605 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 659 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 11 | 3x3 | Permit Number 49999 | 5982556.92934 | 2111261.39213 | 37.7761099876625 | -122.50387447717699 | (37.7761099876625, -122.503874477177) | |
| 38628 | 38628 | 55601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 646 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 12 | Permit Number 11575 | 5982597.71515 | 2111371.57674 | 37.776414920590504 | -122.503741552554 | (37.7764149205905, -122.503741552554) | ||
| 178731 | 178731 | 78426 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1954 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2011 12:00:00 AM | 1 | Permit Number 768091 | 5982612.2416 | 2101808.1342 | 37.750157291821296 | -122.502983144485 | (37.7501572918213, -122.502983144485) | ||
| 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) | ||
| 148617 | 148617 | 184702 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3719 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982717.3841 | 2104205.1171 | 37.7567449138844 | -122.502796975056 | (37.7567449138844, -122.502796975056) | |||
| 152634 | 152634 | 47855 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1339 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | Permit Number 45614 | 5982734.7831 | 2106002.3859 | 37.7616807275351 | -122.50286984609801 | (37.7616807275351, -122.502869846098) | |
| 169722 | 169722 | 69169 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1375 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 0 | Permit Number 33206 | 5982739.37933195 | 2105771.37048825 | 37.7610466950075 | -122.502836848167 | (37.7610466950075, -122.502836848167) | |
| 120401 | 120401 | 47857 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1381 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | 4x6 | Permit Number 45615 | 5982740.72204483 | 2105732.34129465 | 37.7609396108407 | -122.502829315151 | (37.7609396108407, -122.502829315151) | ||
| 68389 | 68389 | 69168 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1371 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33205 | 5982742.8691 | 2105803.089 | 37.7611339901248 | -122.50282712680901 | (37.7611339901248, -122.502827126809) | |
| 174557 | 174557 | 183704 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1375 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5982743.9393 | 2105775.5013 | 37.761058305034496 | -122.502821383267 | (37.7610583050345, -122.502821383267) | |||
| 43422 | 43422 | 47856 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1379 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | 4x8 | Permit Number 45615 | 5982744.6528 | 2105747.7948 | 37.7609822727886 | -122.502816864592 | (37.7609822727886, -122.502816864592) |
| 160957 | 160957 | 75711 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 2 | 5982781.2778 | 2105936.6274 | 37.7615029058487 | -122.50270417470301 | (37.7615029058487, -122.502704174703) | ||
| 62127 | 62127 | 75880 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 3 | 5982784.1317 | 2105860.9992 | 37.7612954200169 | -122.502688706201 | (37.7612954200169, -122.502688706201) | ||
| 34398 | 34398 | 47890 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | 3 | Permit Number 45634 | 5982786.5099 | 2105823.423 | 37.7611923862045 | -122.502677699679 | (37.7611923862045, -122.502677699679) | |
| 112544 | 112544 | 47891 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | Permit Number 45634 | 5982788.21559268 | 2105864.2264207 | 37.7613045210427 | -122.502674820858 | (37.7613045210427, -122.502674820858) | ||
| 121048 | 121048 | 47889 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | Permit Number 45634 | 5982788.21559268 | 2105864.2264207 | 37.7613045210427 | -122.502674820858 | (37.7613045210427, -122.502674820858) | ||
| 65847 | 65847 | 92235 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 547 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52678 | 5982836.20696 | 2112060.4446900003 | 37.778320370547206 | -122.502967564996 | (37.7783203705472, -122.502967564996) | |
| 63961 | 63961 | 117933 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 629 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982860.45781 | 2111468.26133 | 37.7766958332851 | -122.502839825474 | (37.7766958332851, -122.502839825474) | |||
| 109201 | 109201 | 122466 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1351 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 113 | 113 | 183695 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1341 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983048.7244 | 2105854.1384 | 37.7612921278024 | -122.50177309900499 | (37.7612921278024, -122.501773099005) | |||
| 54053 | 54053 | 183697 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1341 42nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983052.2798 | 2105821.6343 | 37.7612030896009 | -122.50175839766099 | (37.7612030896009, -122.501758397661) | |||
| 47671 | 47671 | 47851 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1238 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 5 | Permit Number 45610 | 5983067.6301 | 2106694.7653 | 37.7636013609659 | -122.501769909969 | (37.7636013609659, -122.501769909969) | |
| 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) | ||
| 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) | |||
| 35629 | 35629 | 70375 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | ||
| 151281 | 151281 | 117924 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 611 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5983159.66185 | 2111615.2579900003 | 37.7771170231905 | -122.501815685868 | (37.7771170231905, -122.501815685868) | |||
| 35183 | 35183 | 82588 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 675 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52676 | 5983177.86359 | 2111217.50955 | 37.776025990837105 | -122.501723286949 | (37.7760259908371, -122.501723286949) | |
| 143992 | 143992 | 51520 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 743 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47824 | 5983194.78600704 | 2110736.97724938 | 37.7747075825816 | -122.501629190373 | (37.7747075825816, -122.501629190373) | |||
| 162079 | 162079 | 51521 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 743 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/2005 12:00:00 AM | 6 | Permit Number 47824 | 5983198.06767 | 2110736.10989 | 37.774705393812496 | -122.501617774439 | (37.7747053938125, -122.501617774439) | |
| 53554 | 53554 | 185769 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2162 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983287.4484 | 2100417.9653 | 37.7463799348929 | -122.500545498316 | (37.7463799348929, -122.500545498316) | |||
| 61266 | 61266 | 74796 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2338 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 4 | 5983322.3378 | 2099244.9576 | 37.7431612263111 | -122.500338147126 | (37.7431612263111, -122.500338147126) | ||
| 164573 | 164573 | 74938 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2340 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 4 | 5983322.8922 | 2099223.3332 | 37.74310188417871 | -122.50033463176901 | (37.7431018841787, -122.500334631769) | ||
| 174506 | 174506 | 47426 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 573 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/2004 12:00:00 AM | 3 | Permit Number 45337 | 5983462.700569999 | 2111933.41652 | 37.778008390012296 | -122.50079093001001 | (37.7780083900123, -122.50079093001) | |
| 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) | |||
| 26951 | 26951 | 184920 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1990 41st Ave | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5983531.5644 | 2102137.5878 | 37.7511158704708 | -122.499828470359 | (37.7511158704708, -122.499828470359) | |||
| 119695 | 119695 | 117911 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 847 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983533.163509999 | 2110025.18757 | 37.772773082446605 | -122.50040605490801 | (37.7727730824466, -122.500406054908) | |||
| 18674 | 18674 | 29222 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 92082 | 92082 | 29233 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902 41st Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 99349 | 99349 | 29238 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 108054 | 108054 | 29221 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 120208 | 120208 | 29226 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 78662 | 78662 | 39795 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 96577 | 96577 | 39797 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 112707 | 112707 | 39793 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 125642 | 125642 | 39796 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 171115 | 171115 | 43047 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2151 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 4 | Permit Number 42901 | 5983544.7629 | 2100515.7013 | 37.7466633929793 | -122.499662971026 | (37.7466633929793, -122.499662971026) | |
| 73714 | 73714 | 184906 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1990 41st Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983545.4397 | 2101789.6902 | 37.7501614543488 | -122.49975477788901 | (37.7501614543488, -122.499754777889) | |||
| 57209 | 57209 | 117860 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 720 40th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5983545.64594 | 2110939.3733 | 37.775283905142395 | -122.500430481907 | (37.7752839051424, -122.500430481907) | |||
| 32285 | 32285 | 43048 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2159 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 8 | Permit Number 42902 | 5983545.7781 | 2100465.2765 | 37.7465249999307 | -122.499655734442 | (37.7465249999307, -122.499655734442) | |
| 49242 | 49242 | 117861 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 720 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983545.86004 | 2110898.79484 | 37.7751725010026 | -122.50042674040701 | (37.7751725010026, -122.500426740407) |
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");