trees
930 rows where qSpecies_id = 65 sorted by TreeID descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155759 | 90704 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4226 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982526.486333 | 2110346.227119 | 37.773595421125 | -122.503911988256 | (37.773595421125, -122.503911988256) | 11 | 6 | 2 | 55 | 26 | |
| 21243 | 90701 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4150 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982718.22424 | 2110361.27379 | 37.773648007644 | -122.50324986327 | (37.773648007644, -122.50324986327) | 11 | 6 | 2 | 55 | 26 | ||
| 101431 | 90700 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4132 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982733.96073 | 2110362.78645 | 37.7736530859898 | -122.503195541264 | (37.7736530859898, -122.503195541264) | 11 | 6 | 2 | 55 | 26 | ||
| 103245 | 90699 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4130 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982824.979147 | 2110357.060256 | 37.7736427132649 | -122.502880275835 | (37.7736427132649, -122.502880275835) | 11 | 6 | 2 | 55 | 26 | |
| 189807 | 90698 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4120 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982803.7615 | 2110365.66424 | 37.7736650902847 | -122.502954306782 | (37.7736650902847, -122.502954306782) | 11 | 6 | 2 | 55 | 26 | ||
| 67477 | 90697 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982827.55624 | 2110364.98681 | 37.7736646287423 | -122.502871948318 | (37.7736646287423, -122.502871948318) | 11 | 6 | 2 | 55 | 26 | ||
| 82855 | 90696 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4100X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982853.2509 | 2110366.2864 | 37.7736697071224 | -122.502783164224 | (37.7736697071224, -122.502783164224) | 11 | 6 | 2 | 55 | 26 | ||
| 159956 | 90694 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4046 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983004.67089 | 2110371.95797 | 37.7736941772479 | -122.50225980754 | (37.7736941772479, -122.50225980754) | 11 | 6 | 2 | 55 | 26 | ||
| 38083 | 90692 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4040 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 3x3 | 5983028.8678 | 2110374.29859 | 37.7737020255392 | -122.502176281286 | (37.7737020255392, -122.502176281286) | 11 | 6 | 2 | 55 | 26 | ||
| 109433 | 90691 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4030 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983054.01644 | 2110373.76049 | 37.7737020255531 | -122.502089249824 | (37.7737020255531, -122.502089249824) | 11 | 6 | 2 | 55 | 26 | ||
| 99186 | 90690 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4024 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983082.07402 | 2110375.00998 | 37.7737071045954 | -122.501992288349 | (37.7737071045954, -122.501992288349) | 11 | 6 | 2 | 55 | 26 | ||
| 86233 | 90689 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4000X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983112.49812 | 2110376.37698 | 37.7737126452226 | -122.501887149528 | (37.7737126452226, -122.501887149528) | 11 | 6 | 2 | 55 | 26 | ||
| 154640 | 90688 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4000X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983129.59902 | 2110378.53332 | 37.7737195704462 | -122.501828155386 | (37.7737195704462, -122.501828155386) | 11 | 6 | 2 | 55 | 26 | ||
| 63136 | 90687 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4000X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983157.80014 | 2110378.60264 | 37.7737214173 | -122.501730610018 | (37.7737214173, -122.501730610018) | 11 | 6 | 2 | 55 | 26 | ||
| 30965 | 90685 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3940 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983336.42617 | 2110385.20717 | 37.7737500419678 | -122.501113213178 | (37.7737500419678, -122.501113213178) | 11 | 6 | 2 | 55 | 26 | ||
| 27163 | 90684 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3932 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983372.77926 | 2110387.45649 | 37.773758352537 | -122.500987630515 | (37.773758352537, -122.500987630515) | 11 | 6 | 2 | 55 | 26 | ||
| 120745 | 90683 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3920 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983409.07279 | 2110386.93278 | 37.7737590455363 | -122.500862048734 | (37.7737590455363, -122.500862048734) | 11 | 6 | 2 | 55 | 26 | ||
| 10290 | 90682 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3900 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983432.26602 | 2110389.71572 | 37.7737680483939 | -122.500782026808 | (37.7737680483939, -122.500782026808) | 11 | 6 | 2 | 55 | 26 | ||
| 80338 | 90681 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3900 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983466.89 | 2110390.06853 | 37.7737710498312 | -122.500662284982 | (37.7737710498312, -122.500662284982) | 11 | 6 | 2 | 55 | 26 | ||
| 100853 | 90680 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3900 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983481.15915 | 2110390.09963 | 37.7737719729083 | -122.500612928817 | (37.7737719729083, -122.500612928817) | 11 | 6 | 2 | 55 | 26 | ||
| 23303 | 90679 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3844 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983636.5454 | 2110395.68992 | 37.7737964430073 | -122.500075844978 | (37.7737964430073, -122.500075844978) | 11 | 6 | 2 | 55 | 26 | ||
| 111347 | 90678 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3828 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983679.39644 | 2110397.80075 | 37.7738047535536 | -122.499927774786 | (37.7738047535536, -122.499927774786) | 11 | 6 | 2 | 55 | 26 | ||
| 52750 | 90677 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3822 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983703.21809 | 2110398.38448 | 37.7738077542579 | -122.49984541634 | (37.7738077542579, -122.49984541634) | 11 | 6 | 2 | 55 | 26 | ||
| 21671 | 90676 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3816 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983797.540277 | 2110392.357405 | 37.773796740286 | -122.499518700393 | (37.773796740286, -122.499518700393) | 11 | 6 | 2 | 55 | 26 | |
| 193994 | 90675 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3808 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983782.70932 | 2110400.38504 | 37.7738179116671 | -122.499570595637 | (37.7738179116671, -122.499570595637) | 11 | 6 | 2 | 55 | 26 | ||
| 187123 | 90674 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3800X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983809.20189 | 2110401.93923 | 37.7738237334342 | -122.499479069897 | (37.7738237334342, -122.499479069897) | 11 | 6 | 2 | 55 | 26 | ||
| 24090 | 90673 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3750x CABRILLO ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984009 | 2110380 | 37.7737752151611 | -122.498786325695 | (37.7737752151611, -122.498786325695) | 11 | 6 | 2 | 55 | 26 | |
| 98816 | 90672 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3750x CABRILLO ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984009 | 2110380 | 37.7737752151611 | -122.498786325695 | (37.7737752151611, -122.498786325695) | 11 | 6 | 2 | 55 | 26 | |
| 8671 | 90671 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3730 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984065.245536 | 2110402.073206 | 37.7738391205751 | -122.498593397317 | (37.7738391205751, -122.498593397317) | 11 | 6 | 2 | 55 | 26 | |
| 12275 | 90670 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3730 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 6 | 3x3 | 5984065.245536 | 2110402.073206 | 37.7738391205751 | -122.498593397317 | (37.7738391205751, -122.498593397317) | 11 | 6 | 2 | 55 | 26 | |
| 9403 | 90669 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3722 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984088.982472 | 2110402.934687 | 37.7738428780038 | -122.498511352333 | (37.7738428780038, -122.498511352333) | 11 | 6 | 2 | 55 | 26 | |
| 1318 | 90667 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3650 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984240.02152 | 2110418.12044 | 37.7738934300459 | -122.497990013473 | (37.7738934300459, -122.497990013473) | 11 | 6 | 2 | 55 | 26 | ||
| 123571 | 90666 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3650 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984258.53781 | 2110419.78746 | 37.7738990927666 | -122.497926086691 | (37.7738990927666, -122.497926086691) | 11 | 6 | 2 | 55 | 26 | ||
| 81526 | 90661 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3500X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984678.30481 | 2110433.19729 | 37.7739605128473 | -122.496475055086 | (37.7739605128473, -122.496475055086) | 11 | 6 | 2 | 55 | 26 | ||
| 43723 | 90660 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3500X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984694.72726 | 2110433.79882 | 37.7739631265543 | -122.496418292329 | (37.7739631265543, -122.496418292329) | 11 | 6 | 2 | 55 | 26 | ||
| 166111 | 90659 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3500X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984771.763559 | 2110427.714833 | 37.7739509343258 | -122.496151365888 | (37.7739509343258, -122.496151365888) | 11 | 6 | 2 | 55 | 26 | |
| 154316 | 90658 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3500X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984734.74818 | 2110435.32467 | 37.7739696605363 | -122.496279967939 | (37.7739696605363, -122.496279967939) | 11 | 6 | 2 | 55 | 26 | ||
| 110235 | 87815 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 98528 | 87814 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 186665 | 87813 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 156296 | 87374 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | 9 | 7 | 4 | 28861 | 40 | |||
| 19127 | 86386 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1515 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988049.4132 | 2104971.8792 | 37.759162153442 | -122.484413329834 | (37.759162153442, -122.484413329834) | 1 | 8 | 3 | 56 | 35 | ||
| 91062 | 84740 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 143 Alhambra St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | 13 | 9 | 1 | 57 | 17 | |
| 23568 | 84675 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3025 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51854 | 5986186.78165 | 2110431.4764 | 37.7740440447924 | -122.49125692663 | (37.7740440447924, -122.49125692663) | 11 | 6 | 2 | 55 | 26 | |
| 31198 | 84402 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1852 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51006 | 6000688.3478 | 2111734.5053 | 37.778458498926 | -122.441187160325 | (37.778458498926, -122.441187160325) | 15 | 5 | 11 | 29490 | 41 | |
| 73567 | 83915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1218 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50159 | 5982131.5385 | 2106775.0727 | 37.763766832166 | -122.505013452733 | (37.763766832166, -122.505013452733) | 1 | 8 | 3 | 56 | 35 | |
| 51850 | 83832 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1311 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50170 | 5981489.3468 | 2106129.5123 | 37.7619565050576 | -122.507186662869 | (37.7619565050576, -122.507186662869) | 1 | 8 | 3 | 56 | 35 | |
| 166768 | 83830 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 4429 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50197 | 5981144.78735824 | 2104834.04535283 | 37.7583792247877 | -122.50828217567 | (37.7583792247877, -122.50828217567) | 1 | 8 | 3 | 56 | 35 | ||
| 29996 | 83821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1514 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50163 | 5981890.7885 | 2104754.0668 | 37.7582035604252 | -122.505696289301 | (37.7582035604252, -122.505696289301) | 1 | 8 | 3 | 56 | 35 | |
| 114804 | 83800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1206 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50158 | 5982131.5385 | 2106862.8908 | 37.764007955481 | -122.505019961028 | (37.764007955481, -122.505019961028) | 1 | 8 | 3 | 56 | 35 | |
| 178764 | 83799 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1200 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 3x3 | Permit Number 53146 | 5982135.42302083 | 2106787.40938389 | 37.7638009337056 | -122.505000931873 | (37.7638009337056, -122.505000931873) | 1 | 8 | 3 | 56 | 35 | ||
| 110639 | 83535 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1779 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50180 | 5981283.63190284 | 2102973.80068941 | 37.7532797037627 | -122.507663961783 | (37.7532797037627, -122.507663961783) | 1 | 8 | 3 | 56 | 35 | |||
| 187229 | 83487 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2051 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50156 | 5982589.2289 | 2101159.5488 | 37.7483751044578 | -122.503014711943 | (37.7483751044578, -122.503014711943) | 1 | 8 | 3 | 29491 | 35 | |
| 158774 | 83067 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 624 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x6 | Permit Number 52379 | 6012068.69574 | 2105475.40084 | 37.7619140888872 | -122.401378022999 | (37.7619140888872, -122.401378022999) | 10 | 3 | 8 | 28856 | 29 | |
| 186443 | 83009 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 622 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52378 | 6012068.99141 | 2105489.95153 | 37.7619540583423 | -122.401378022995 | (37.7619540583423, -122.401378022995) | 10 | 3 | 8 | 28856 | 29 | |
| 88150 | 82830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1475 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52467 | 6015906.1825 | 2094100.414 | 37.7308940918936 | -122.387312034756 | (37.7308940918936, -122.387312034756) | 10 | 3 | 8 | 58 | 1 | |
| 106840 | 82673 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Jennings Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52499 | 6012920.29338 | 2089198.31583 | 37.7172681083272 | -122.397291182543 | (37.7172681083272, -122.397291182543) | 10 | 3 | 8 | 58 | 1 | |
| 158268 | 81935 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 23 Gaviota Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49833 | 5998498.7012246 | 2097562.09988585 | 37.7394196374476 | -122.447741409302 | (37.7394196374476, -122.447741409302) | 9 | 7 | 4 | 59 | 40 | ||
| 90858 | 81824 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 465 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49841 | 5998560.4175518 | 2097716.54493852 | 37.7398472336872 | -122.447539136623 | (37.7398472336872, -122.447539136623) | 9 | 7 | 4 | 59 | 40 | ||
| 130795 | 81299 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 109 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50541 | 6006708.25661782 | 2103139.88479614 | 37.7552007652727 | -122.419751988993 | (37.7552007652727, -122.419751988993) | 2 | 4 | 7 | 28859 | 19 | |
| 1937 | 78248 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 734 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6002539.24351 | 2089283.26415 | 37.716917933889 | -122.433179625239 | (37.716917933889, -122.433179625239) | 9 | 7 | 6 | 28861 | 5 | |||
| 16687 | 74647 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004365.04367 | 2091463.54141 | 37.7230079026666 | -122.42702391962 | (37.7230079026666, -122.42702391962) | 9 | 7 | 6 | 28861 | 5 | |||
| 14111 | 74492 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004373.61085 | 2091456.86354 | 37.7229900511464 | -122.42699382922 | (37.7229900511464, -122.42699382922) | 9 | 7 | 6 | 28861 | 5 | |||
| 9579 | 74128 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004381.29063 | 2091452.37119 | 37.7229781503978 | -122.426966961977 | (37.7229781503978, -122.426966961977) | 9 | 7 | 6 | 28861 | 5 | |||
| 111705 | 74111 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 500X Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1994 12:00:00 AM | 15 | 3x3 | 6003976.59234436 | 2092494.78352221 | 37.7258174919201 | -122.428440184616 | (37.7258174919201, -122.428440184616) | 9 | 7 | 6 | 28861 | 5 | ||
| 8943 | 73896 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004393.10182 | 2091444.69797 | 37.7229577492801 | -122.426925586868 | (37.7229577492801, -122.426925586868) | 9 | 7 | 6 | 28861 | 5 | |||
| 13677 | 73831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6010808.25129 | 2088026.19044 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | 9 | 7 | 8 | 309 | 39 | |||
| 7703 | 73451 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 376 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989681.20245 | 2112841.9195 | 37.7808660152932 | -122.479345638761 | (37.7808660152932, -122.479345638761) | 11 | 6 | 2 | 55 | 26 | |||
| 9976 | 73440 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1829 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 5989774.97686 | 2113326.97705 | 37.7822032940119 | -122.479056721694 | (37.7822032940119, -122.479056721694) | 11 | 6 | 2 | 55 | 26 | ||
| 6628 | 73438 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 212 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5989642.98356 | 2113924.77294 | 37.7838370079244 | -122.479557105797 | (37.7838370079244, -122.479557105797) | 11 | 6 | 2 | 55 | 26 | |||
| 12867 | 73402 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1434 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5982802.3301 | 2105339.2702 | 37.759863969648 | -122.502587148941 | (37.759863969648, -122.502587148941) | 1 | 8 | 3 | 56 | 35 | |||
| 3392 | 70645 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6002626.20323 | 2094469.32888 | 37.7311626384362 | -122.433249403638 | (37.7311626384362, -122.433249403638) | 9 | 7 | 5 | 28861 | 25 | |||
| 16271 | 70637 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 366 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 5989681.33486 | 2112881.66682 | 37.7809751580333 | -122.479348089371 | (37.7809751580333, -122.479348089371) | 11 | 6 | 2 | 55 | 26 | |||
| 15128 | 70636 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 249 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5989603.89345 | 2113698.71942 | 37.7832140576516 | -122.479675795688 | (37.7832140576516, -122.479675795688) | 11 | 6 | 2 | 55 | 26 | |||
| 1872 | 70589 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 339 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 5989627.95381 | 2113064.98358 | 37.7814753940656 | -122.479546175065 | (37.7814753940656, -122.479546175065) | 11 | 6 | 2 | 55 | 26 | |||
| 13559 | 70587 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1834 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5989770.57381 | 2113384.40122 | 37.7823607090318 | -122.479076155854 | (37.7823607090318, -122.479076155854) | 11 | 6 | 2 | 55 | 26 | |||
| 12461 | 70586 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1829 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 3x3 | 5989790.05617 | 2113327.40851 | 37.7822053543666 | -122.479004586193 | (37.7822053543666, -122.479004586193) | 11 | 6 | 2 | 55 | 26 | ||
| 15441 | 70583 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1801 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5989858.46515 | 2113331.71432 | 37.7822211492768 | -122.478768239422 | (37.7822211492768, -122.478768239422) | 11 | 6 | 2 | 55 | 26 | |||
| 14208 | 70581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 366 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5989681.74367 | 2112910.59233 | 37.7810546031553 | -122.47934879186 | (37.7810546031553, -122.47934879186) | 11 | 6 | 2 | 55 | 26 | |||
| 9419 | 70579 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 212 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 5989642.97264 | 2113940.99798 | 37.7838815566968 | -122.479558331084 | (37.7838815566968, -122.479558331084) | 11 | 6 | 2 | 55 | 26 | |||
| 2206 | 70527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004201.75826 | 2093380.33154 | 37.7282617492704 | -122.427724869209 | (37.7282617492704, -122.427724869209) | 9 | 7 | 6 | 28861 | 5 | |||
| 3223 | 70495 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 41 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004160.99444 | 2093317.30941 | 37.7280863985552 | -122.427861302663 | (37.7280863985552, -122.427861302663) | 9 | 7 | 6 | 28861 | 5 | |||
| 13672 | 70491 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6005035.04728 | 2091735.87999 | 37.7237935486115 | -122.424727215697 | (37.7237935486115, -122.424727215697) | 9 | 7 | 6 | 28861 | 5 | |||
| 7022 | 70397 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 21 | 6006350.25387 | 2093285.00079 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | 9 | 7 | 7 | 309 | 5 | |||
| 15715 | 70376 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1434 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 5982801.126 | 2105356.1278 | 37.7599101850833 | -122.502592561024 | (37.7599101850833, -122.502592561024) | 1 | 8 | 3 | 56 | 35 | |||
| 18137 | 70176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.53201 | 37.7230227297861 | -122.42729139329 | (37.7230227297861, -122.42729139329) | 9 | 7 | 6 | 28861 | 5 | ||
| 122230 | 69299 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1632 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | 25 | Permit Number 33374 | 5999947.983 | 2110939.1774 | 37.7762325313103 | -122.443691201885 | (37.7762325313103, -122.443691201885) | 15 | 5 | 11 | 29492 | 16 | |
| 167156 | 69206 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2864 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33255 | 6008953.68763074 | 2101781.1943032 | 37.7515963427841 | -122.411890591701 | (37.7515963427841, -122.411890591701) | 2 | 4 | 7 | 28859 | 19 | ||
| 21022 | 69205 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2860 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33254 | 6008952.43931379 | 2101803.50283851 | 37.7516575269948 | -122.411896484829 | (37.7516575269948, -122.411896484829) | 2 | 4 | 7 | 28859 | 19 | ||
| 129894 | 69204 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33252 | 6008949.31851966 | 2101859.27420808 | 37.7518104876034 | -122.411911217702 | (37.7518104876034, -122.411911217702) | 2 | 4 | 7 | 28859 | 19 | ||
| 83313 | 68880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2018 12:00:00 AM | 3 | Permit Number 32851 | 6000180.50707 | 2120770.20455 | 37.8032392229736 | -122.443593228653 | (37.8032392229736, -122.443593228653) | 13 | 9 | 1 | 57 | 17 | |
| 51560 | 68866 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 50 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32829 | 5999664.63009036 | 2093804.62136616 | 37.72916905361 | -122.443440322014 | (37.72916905361, -122.443440322014) | 9 | 7 | 4 | 63 | 40 | ||
| 95940 | 68849 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32812 | 5999215.30905725 | 2094104.51871766 | 37.7299668673625 | -122.44501520736 | (37.7299668673625, -122.44501520736) | 9 | 7 | 4 | 28861 | 40 | ||
| 78160 | 68831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32782 | 5999950.39080564 | 2094093.84509942 | 37.729979487143 | -122.442473182831 | (37.729979487143, -122.442473182831) | 9 | 7 | 4 | 63 | 40 | ||
| 176909 | 68818 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32765 | 5999442.86322085 | 2093551.99082798 | 37.7284627395009 | -122.444188839651 | (37.7284627395009, -122.444188839651) | 9 | 7 | 4 | 63 | 40 | ||
| 89731 | 68540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 562 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 28 | Permit Number 32423 | 5982889.49723 | 2111962.75458 | 37.7780552740204 | -122.502775984008 | (37.7780552740204, -122.502775984008) | 11 | 6 | 2 | 55 | 26 | |
| 127311 | 68456 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 107 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 25 | Permit Number 32318 | 5991466.74972 | 2114692.79792 | 37.7860515606903 | -122.473303650104 | (37.7860515606903, -122.473303650104) | 11 | 6 | 2 | 54 | 26 | |
| 65829 | 68256 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.409219186739 | (37.7281816043806, -122.409219186739) | 10 | 3 | 7 | 309 | 28 | |
| 68631 | 68056 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31793 | 5993375.65948901 | 2104224.93951181 | 37.7574199602528 | -122.465938496778 | (37.7574199602528, -122.465938496778) | 1 | 8 | 4 | 56 | 12 | ||
| 143164 | 67951 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 546 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 1 | Permit Number 31666 | 5988462.26619 | 2112267.73562 | 37.7792185950288 | -122.483520377593 | (37.7792185950288, -122.483520377593) | 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) );