trees
3,709 rows where qSpecies_id = 9 sorted by XCoord
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
| 6966 | 35281 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 10720 | 39483 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 13401 | 35284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 14355 | 35285 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
| 16339 | 39482 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 17767 | 35283 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 17923 | 19768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
| 18560 | 19875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
| 187015 | 119134 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 507 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5981280.05518 | 2112253.74511 | 37.7787595315686 | -122.508365127423 | (37.7787595315686, -122.508365127423) | 11 | 6 | 2 | 55 | 26 | |||
| 136151 | 68999 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1937 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 3 | Permit Number 32993 | 5981324.2082 | 2101884.9559 | 37.7502924340948 | -122.507442861533 | (37.7502924340948, -122.507442861533) | 1 | 8 | 3 | 29491 | 35 | |
| 28038 | 87129 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 731 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50078 | 5981335.81938 | 2110728.67919 | 37.7745754365363 | -122.508059002234 | (37.7745754365363, -122.508059002234) | 11 | 6 | 2 | 55 | 26 | |
| 85047 | 92258 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 891 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52707 | 5981374.1327 | 2109674.4758 | 37.7716831604786 | -122.507848221548 | (37.7716831604786, -122.507848221548) | 11 | 6 | 2 | 55 | 26 | |
| 163282 | 92255 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 854 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52705 | 5981409.48193 | 2109900.456 | 37.7723057186543 | -122.507742720708 | (37.7723057186543, -122.507742720708) | 11 | 6 | 2 | 55 | 26 | |
| 191042 | 37100 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1538 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 6 | Permit Number 46585 | 5981585.229 | 2104585.7036 | 37.7577232947481 | -122.506740540912 | (37.7577232947481, -122.506740540912) | 1 | 8 | 3 | 56 | 35 | |
| 35232 | 92241 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 542 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52687 | 5981642.07316 | 2112062.15681 | 37.7782548147082 | -122.507098571159 | (37.7782548147082, -122.507098571159) | 11 | 6 | 2 | 55 | 26 | |
| 59478 | 118835 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 628 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5981667.45788 | 2111440.07687 | 37.776548261466 | -122.506964600885 | (37.776548261466, -122.506964600885) | 11 | 6 | 2 | 55 | 26 | |||
| 49162 | 48887 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3616 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | 0 | Permit Number 46093 | 5981682.07511006 | 2099461.07988631 | 37.743658222157 | -122.506025661966 | (37.743658222157, -122.506025661966) | 1 | 8 | 3 | 29491 | 35 | ||
| 19520 | 37110 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981797.2694 | 2106191.6975 | 37.7621453791042 | -122.506126308526 | (37.7621453791042, -122.506126308526) | 1 | 8 | 3 | 56 | 35 |
| 122329 | 37111 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.3894 | 2106160.9583 | 37.7620611028708 | -122.506116697072 | (37.7620611028708, -122.506116697072) | 1 | 8 | 3 | 56 | 35 |
| 17500 | 37109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.7427 | 2106129.159 | 37.7619738119048 | -122.506113117253 | (37.7619738119048, -122.506113117253) | 1 | 8 | 3 | 56 | 35 |
| 22242 | 37108 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981801.156 | 2106110.4328 | 37.7619224783225 | -122.506106840747 | (37.7619224783225, -122.506106840747) | 1 | 8 | 3 | 56 | 35 |
| 53619 | 37128 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1501 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 8 | 2x2 | Permit Number 39712 | 5981844.8018 | 2104832.4428 | 37.7584160519707 | -122.505861139063 | (37.7584160519707, -122.505861139063) | 1 | 8 | 3 | 56 | 35 | |
| 70835 | 37126 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1503 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | 2x2 | Permit Number 39712 | 5981845.4129 | 2104790.8867 | 37.7583019867208 | -122.505855944814 | (37.7583019867208, -122.505855944814) | 1 | 8 | 3 | 56 | 35 |
| 35090 | 184274 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1503 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981845.7185 | 2104811.6648 | 37.7583590554552 | -122.50585642835 | (37.7583590554552, -122.50585642835) | 1 | 8 | 3 | 56 | 35 | |||
| 83607 | 37088 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1515 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | Permit Number 39688 | 5981846.9407 | 2104770.7198 | 37.7582467040795 | -122.505849166004 | (37.7582467040795, -122.505849166004) | 1 | 8 | 3 | 56 | 35 | |
| 7300 | 183627 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1442 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981873.5609 | 2105253.9792 | 37.759575163504 | -122.505792929352 | (37.759575163504, -122.505792929352) | 1 | 8 | 3 | 56 | 35 | |||
| 114046 | 115238 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 589 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775584 | 5981901.6 | 2111755.2 | 37.7774272832085 | -122.506178021462 | (37.7774272832085, -122.506178021462) | 11 | 6 | 2 | 55 | 26 | |||
| 109335 | 68565 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 599 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 7 | Permit Number 32455 | 5981915.91303 | 2111733.97216 | 37.777369840379 | -122.506126934461 | (37.777369840379, -122.506126934461) | 11 | 6 | 2 | 55 | 26 | |
| 86499 | 119068 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 589 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5981917.84784 | 2111763.83691 | 37.7774519540971 | -122.506122456369 | (37.7774519540971, -122.506122456369) | 11 | 6 | 2 | 55 | 26 | |||
| 128065 | 101528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 819 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769457 | 5981975.18641 | 2110162.57659 | 37.773058737345 | -122.505805367237 | (37.773058737345, -122.505805367237) | 11 | 6 | 2 | 55 | 26 | |
| 134452 | 47823 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 762 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52683 | 5982005.2592 | 2110568.08729 | 37.7741739213091 | -122.505731410729 | (37.7741739213091, -122.505731410729) | 11 | 6 | 2 | 55 | 26 | |
| 165530 | 184364 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 46th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982017.5295 | 2099742.21 | 37.7444498680839 | -122.504886589711 | (37.7444498680839, -122.504886589711) | 1 | 8 | 3 | 29491 | 35 | |||
| 10318 | 78551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | 1 | 8 | 3 | 29491 | 35 | |||
| 146110 | 183669 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1331 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982114.4178 | 2105996.5592 | 37.7616282496531 | -122.50501497063 | (37.7616282496531, -122.50501497063) | 1 | 8 | 3 | 56 | 35 | |||
| 163443 | 822 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1411 45th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:39:00 PM | 3 | 3X3 | 5982129.0913294 | 2105488.1375739 | 37.7602331322527 | -122.50492654488 | (37.7602331322527, -122.50492654488) | 1 | 8 | 3 | 56 | 35 | ||
| 35511 | 820 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1407 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:29:00 PM | 3 | 3X3 | 5982131.0395 | 2105513.2639 | 37.760302236597 | -122.504921669151 | (37.760302236597, -122.504921669151) | 1 | 8 | 3 | 56 | 35 | ||
| 17854 | 821 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1409 45th Ave | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 04/02/2015 05:34:00 PM | 3 | 3X3 | 5982132.645 | 2105492.3927 | 37.7602450246853 | -122.504914569939 | (37.7602450246853, -122.504914569939) | 1 | 8 | 3 | 56 | 35 | ||
| 2818 | 38377 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3815 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 2 | Permit Number 40436 | 5982149.2806 | 2102814.4314 | 37.7528930799905 | -122.504658614747 | (37.7528930799905, -122.504658614747) | 1 | 8 | 3 | 56 | 35 | |
| 174821 | 183626 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1442 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:39:00 PM | 8 | Width 0ft | 5982184.0203 | 2105272.8436 | 37.7596452277361 | -122.504720622161 | (37.7596452277361, -122.504720622161) | 1 | 8 | 3 | 56 | 35 | ||
| 16334 | 70226 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1466 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5982190.0408 | 2105127.5478 | 37.759246640966 | -122.504689034952 | (37.759246640966, -122.504689034952) | 1 | 8 | 3 | 56 | 35 | |||
| 30265 | 38339 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1506 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 6 | Permit Number 40406 | 5982199.9382 | 2104810.9773 | 37.7583780105423 | -122.504631350136 | (37.7583780105423, -122.504631350136) | 1 | 8 | 3 | 56 | 35 | |
| 124915 | 119060 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 530 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5982260.53507 | 2112121.88735 | 37.7784552224747 | -122.504963547902 | (37.7784552224747, -122.504963547902) | 11 | 6 | 2 | 55 | 26 | |||
| 105652 | 68554 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 735 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2016 12:00:00 AM | 1 | Permit Number 777390 | 5982265.00656 | 2110745.36563 | 37.7746759600384 | -122.504846052747 | (37.7746759600384, -122.504846052747) | 11 | 6 | 2 | 55 | 26 | |
| 27770 | 106546 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 644 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 772940 | 5982289.02973 | 2111361.80008 | 37.7763699221041 | -122.504808639708 | (37.7763699221041, -122.504808639708) | 11 | 6 | 2 | 55 | 26 | |
| 14327 | 70383 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | 1 | 8 | 3 | 56 | 35 | |||
| 3619 | 55603 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 655 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1973 12:00:00 AM | 2 | Permit Number 11578 | 5982556.76294 | 2111288.67841 | 37.7761848980348 | -122.503877074189 | (37.7761848980348, -122.503877074189) | 11 | 6 | 2 | 55 | 26 | ||
| 155608 | 55605 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 659 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 11 | 3x3 | Permit Number 49999 | 5982556.92934 | 2111261.39213 | 37.7761099876625 | -122.503874477177 | (37.7761099876625, -122.503874477177) | 11 | 6 | 2 | 55 | 26 | |
| 129668 | 55601 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 646 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1973 12:00:00 AM | 12 | Permit Number 11575 | 5982597.71515 | 2111371.57674 | 37.7764149205905 | -122.503741552554 | (37.7764149205905, -122.503741552554) | 11 | 6 | 2 | 55 | 26 | ||
| 81537 | 78426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1954 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2011 12:00:00 AM | 1 | Permit Number 768091 | 5982612.2416 | 2101808.1342 | 37.7501572918213 | -122.502983144485 | (37.7501572918213, -122.502983144485) | 1 | 8 | 3 | 29491 | 35 | ||
| 4025 | 73557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 5982628.31308 | 2110748.29603 | 37.7747053725117 | -122.503589540533 | (37.7747053725117, -122.503589540533) | 11 | 6 | 2 | 55 | 26 | |||
| 50696 | 184702 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3719 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5982717.3841 | 2104205.1171 | 37.7567449138844 | -122.502796975056 | (37.7567449138844, -122.502796975056) | 1 | 8 | 3 | 56 | 35 | |||
| 1262 | 47855 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1339 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 3 | Permit Number 45614 | 5982734.7831 | 2106002.3859 | 37.7616807275351 | -122.502869846098 | (37.7616807275351, -122.502869846098) | 1 | 8 | 3 | 56 | 35 | |
| 188181 | 69169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1375 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 0 | Permit Number 33206 | 5982739.37933195 | 2105771.37048825 | 37.7610466950075 | -122.502836848167 | (37.7610466950075, -122.502836848167) | 1 | 8 | 3 | 56 | 35 | |
| 152756 | 47857 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1381 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | 4x6 | Permit Number 45615 | 5982740.72204483 | 2105732.34129465 | 37.7609396108407 | -122.502829315151 | (37.7609396108407, -122.502829315151) | 1 | 8 | 3 | 56 | 35 | ||
| 158263 | 69168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1371 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 6 | Permit Number 33205 | 5982742.8691 | 2105803.089 | 37.7611339901248 | -122.502827126809 | (37.7611339901248, -122.502827126809) | 1 | 8 | 3 | 56 | 35 | |
| 164766 | 183704 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1375 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5982743.9393 | 2105775.5013 | 37.7610583050345 | -122.502821383267 | (37.7610583050345, -122.502821383267) | 1 | 8 | 3 | 56 | 35 | |||
| 128233 | 47856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1379 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 3 | 4x8 | Permit Number 45615 | 5982744.6528 | 2105747.7948 | 37.7609822727886 | -122.502816864592 | (37.7609822727886, -122.502816864592) | 1 | 8 | 3 | 56 | 35 |
| 4833 | 75711 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982781.2778 | 2105936.6274 | 37.7615029058487 | -122.502704174703 | (37.7615029058487, -122.502704174703) | 1 | 8 | 3 | 56 | 35 | |||
| 15933 | 75880 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982784.1317 | 2105860.9992 | 37.7612954200169 | -122.502688706201 | (37.7612954200169, -122.502688706201) | 1 | 8 | 3 | 56 | 35 | |||
| 112345 | 47890 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | 3 | Permit Number 45634 | 5982786.5099 | 2105823.423 | 37.7611923862045 | -122.502677699679 | (37.7611923862045, -122.502677699679) | 1 | 8 | 3 | 56 | 35 | |
| 145559 | 47891 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | Permit Number 45634 | 5982788.21559268 | 2105864.2264207 | 37.7613045210427 | -122.502674820858 | (37.7613045210427, -122.502674820858) | 1 | 8 | 3 | 56 | 35 | ||
| 153551 | 47889 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | Permit Number 45634 | 5982788.21559268 | 2105864.2264207 | 37.7613045210427 | -122.502674820858 | (37.7613045210427, -122.502674820858) | 1 | 8 | 3 | 56 | 35 | ||
| 157365 | 92235 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 547 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52678 | 5982836.20696 | 2112060.44469 | 37.7783203705472 | -122.502967564996 | (37.7783203705472, -122.502967564996) | 11 | 6 | 2 | 55 | 26 | |
| 20504 | 117933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 629 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982860.45781 | 2111468.26133 | 37.7766958332851 | -122.502839825474 | (37.7766958332851, -122.502839825474) | 11 | 6 | 2 | 55 | 26 | |||
| 114713 | 122466 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1351 42nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | 1 | 8 | 3 | 56 | 35 | ||||
| 169777 | 183695 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1341 42nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983048.7244 | 2105854.1384 | 37.7612921278024 | -122.501773099005 | (37.7612921278024, -122.501773099005) | 1 | 8 | 3 | 56 | 35 | |||
| 62025 | 183697 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1341 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983052.2798 | 2105821.6343 | 37.7612030896009 | -122.501758397661 | (37.7612030896009, -122.501758397661) | 1 | 8 | 3 | 56 | 35 | |||
| 106342 | 47851 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1238 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 5 | Permit Number 45610 | 5983067.6301 | 2106694.7653 | 37.7636013609659 | -122.501769909969 | (37.7636013609659, -122.501769909969) | 1 | 8 | 3 | 56 | 35 | |
| 6676 | 70370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.501480109549 | (37.7594698688276, -122.501480109549) | 1 | 8 | 3 | 56 | 35 | |||
| 94032 | 183635 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1466 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983120.0142 | 2105165.2765 | 37.7594048951892 | -122.501475581309 | (37.7594048951892, -122.501475581309) | 1 | 8 | 3 | 56 | 35 | |||
| 2981 | 70375 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | 1 | 8 | 3 | 56 | 35 | |||
| 134150 | 117924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 611 41st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 6ft | 5983159.66185 | 2111615.25799 | 37.7771170231905 | -122.501815685868 | (37.7771170231905, -122.501815685868) | 11 | 6 | 2 | 55 | 26 | |||
| 15351 | 261516 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 671 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 11:26:00 AM | 3x3 | 5983177.86359 | 2111217.50955 | 37.7760259908371 | -122.501723286949 | (37.7760259908371, -122.501723286949) | 11 | 6 | 2 | 55 | 26 | |||
| 175205 | 51520 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 743 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | Permit Number 47824 | 5983194.78600704 | 2110736.97724938 | 37.7747075825816 | -122.501629190373 | (37.7747075825816, -122.501629190373) | 11 | 6 | 2 | 55 | 26 | |||
| 194187 | 51521 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 743 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/2005 12:00:00 AM | 6 | Permit Number 47824 | 5983198.06767 | 2110736.10989 | 37.7747053938125 | -122.501617774439 | (37.7747053938125, -122.501617774439) | 11 | 6 | 2 | 55 | 26 | |
| 164846 | 185769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2162 42nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983287.4484 | 2100417.9653 | 37.7463799348929 | -122.500545498316 | (37.7463799348929, -122.500545498316) | 1 | 8 | 3 | 29491 | 35 | |||
| 11049 | 74796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2338 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.3378 | 2099244.9576 | 37.7431612263111 | -122.500338147126 | (37.7431612263111, -122.500338147126) | 1 | 8 | 3 | 29491 | 35 | |||
| 19237 | 74938 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2340 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.8922 | 2099223.3332 | 37.7431018841787 | -122.500334631769 | (37.7431018841787, -122.500334631769) | 1 | 8 | 3 | 29491 | 35 | |||
| 7716 | 47426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 573 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45337 | 5983462.70057 | 2111933.41652 | 37.7780083900123 | -122.50079093001 | (37.7780083900123, -122.50079093001) | 11 | 6 | 2 | 55 | 26 | |
| 57481 | 184919 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 38 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983531.226 | 2102116.9441 | 37.7510591687413 | -122.499828114856 | (37.7510591687413, -122.499828114856) | 1 | 8 | 3 | 29491 | 35 | |||
| 106705 | 184920 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 39 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983531.5644 | 2102137.5878 | 37.7511158704708 | -122.499828470359 | (37.7511158704708, -122.499828470359) | 1 | 8 | 3 | 29491 | 35 | |||
| 172991 | 117911 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 847 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5983533.16351 | 2110025.18757 | 37.7727730824466 | -122.500406054908 | (37.7727730824466, -122.500406054908) | 11 | 6 | 2 | 55 | 26 | |||
| 2291 | 29222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 85077 | 29233 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902 41st Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 99285 | 29238 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 123348 | 29221 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 154666 | 29226 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 32285 | 39796 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 54706 | 39795 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 88135 | 39797 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 136422 | 39793 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 154865 | 43047 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2151 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 4 | Permit Number 42901 | 5983544.7629 | 2100515.7013 | 37.7466633929793 | -122.499662971026 | (37.7466633929793, -122.499662971026) | 1 | 8 | 3 | 29491 | 35 | |
| 164181 | 184906 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983545.4397 | 2101789.6902 | 37.7501614543488 | -122.499754777889 | (37.7501614543488, -122.499754777889) | 1 | 8 | 3 | 29491 | 35 | |||
| 49338 | 117860 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 720 40th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5983545.64594 | 2110939.3733 | 37.7752839051424 | -122.500430481907 | (37.7752839051424, -122.500430481907) | 11 | 6 | 2 | 55 | 26 | |||
| 24067 | 43048 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2159 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 8 | Permit Number 42902 | 5983545.7781 | 2100465.2765 | 37.7465249999307 | -122.499655734442 | (37.7465249999307, -122.499655734442) | 1 | 8 | 3 | 29491 | 35 | |
| 155022 | 117861 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 720 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5983545.86004 | 2110898.79484 | 37.7751725010026 | -122.500426740407 | (37.7751725010026, -122.500426740407) | 11 | 6 | 2 | 55 | 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );