trees
8,758 rows where qSpecies_id = 16 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53430 | 83316 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1516 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50185 | 5980939.77097966 | 2104729.07463785 | 37.7580789214423 | -122.508983405944 | (37.7580789214423, -122.508983405944) | 1 | 8 | 3 | 56 | 35 | ||
83994 | 83930 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1516 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50185 | 5980939.77097966 | 2104729.07463785 | 37.7580789214423 | -122.508983405944 | (37.7580789214423, -122.508983405944) | 1 | 8 | 3 | 56 | 35 | ||
90231 | 11609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4390 JUDAH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4x4 | 5980943 | 2105553 | 37.760341374292 | -122.509033418341 | (37.760341374292, -122.509033418341) | 1 | 8 | 3 | 56 | 35 | |||
46529 | 38359 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
62563 | 38357 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
88505 | 38358 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
127152 | 38356 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
127386 | 38355 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
185693 | 103704 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4700 Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 4x4 | 5980950.21824 | 2110299.88198 | 37.7733753570212 | -122.509360996158 | (37.7733753570212, -122.509360996158) | 11 | 6 | 2 | 55 | 26 | |||
28150 | 89203 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1298 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | 1 | 8 | 3 | 56 | 35 | ||
126209 | 89204 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1298 La Playa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | 1 | 8 | 3 | 56 | 35 | ||
183167 | 89202 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1298 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | 1 | 8 | 3 | 56 | 35 | ||
85116 | 183645 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1488 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5980952.0163 | 2104980.2451 | 37.7587692853894 | -122.508959706802 | (37.7587692853894, -122.508959706802) | 1 | 8 | 3 | 56 | 35 | |||
22675 | 59691 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 185 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | 38 | 4x3 | Permit Number 19118 | 5980952.62035506 | 2112920.61231564 | 37.7805712485973 | -122.509547375915 | (37.7805712485973, -122.509547375915) | 11 | 6 | 2 | 55 | 26 | |
97229 | 183263 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4398 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5980952.9997 | 2105563.3093 | 37.7603702701668 | -122.508999600178 | (37.7603702701668, -122.508999600178) | 1 | 8 | 3 | 56 | 35 | |||
93310 | 183660 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5980953.2204 | 2104940.5095 | 37.7586602538114 | -122.508952592119 | (37.7586602538114, -122.508952592119) | 1 | 8 | 3 | 56 | 35 | |||
137515 | 183661 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5980953.2204 | 2104954.9588 | 37.7586999274449 | -122.508953664999 | (37.7586999274449, -122.508953664999) | 1 | 8 | 3 | 56 | 35 | |||
192874 | 83520 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1488 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50200 | 5980958.16481146 | 2104928.49787253 | 37.7586275647998 | -122.508934600528 | (37.7586275647998, -122.508934600528) | 1 | 8 | 3 | 56 | 35 | ||
95133 | 83966 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50201 | 5980959.07775236 | 2104901.96094882 | 37.7585547558345 | -122.508929472843 | (37.7585547558345, -122.508929472843) | 1 | 8 | 3 | 56 | 35 | ||
121200 | 83967 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50201 | 5980959.07775236 | 2104901.96094882 | 37.7585547558345 | -122.508929472843 | (37.7585547558345, -122.508929472843) | 1 | 8 | 3 | 56 | 35 | ||
136150 | 184265 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1516 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5980961.5822 | 2104713.1219 | 37.7580364055652 | -122.50890679028 | (37.7580364055652, -122.50890679028) | 1 | 8 | 3 | 56 | 35 | |||
142070 | 184264 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1516 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5980961.5822 | 2104704.8718 | 37.7580137531541 | -122.508906177719 | (37.7580137531541, -122.508906177719) | 1 | 8 | 3 | 56 | 35 | |||
174787 | 184300 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5980963.5684 | 2104623.8985 | 37.757791540748 | -122.508893296573 | (37.757791540748, -122.508893296573) | 1 | 8 | 3 | 56 | 35 | |||
157280 | 184299 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5980964.7906 | 2104608.0094 | 37.7577479858759 | -122.508887890039 | (37.7577479858759, -122.508887890039) | 1 | 8 | 3 | 56 | 35 | |||
32847 | 184297 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1540 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5980967.2351 | 2104560.9533 | 37.7576189273961 | -122.508875942299 | (37.7576189273961, -122.508875942299) | 1 | 8 | 3 | 56 | 35 | |||
71644 | 184298 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1540 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5980967.2351 | 2104582.3424 | 37.7576776557414 | -122.508877530386 | (37.7576776557414, -122.508877530386) | 1 | 8 | 3 | 56 | 35 | |||
163688 | 184324 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1546 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5980967.8462 | 2104496.7858 | 37.7574427778303 | -122.508869064647 | (37.7574427778303, -122.508869064647) | 1 | 8 | 3 | 56 | 35 | |||
61530 | 11608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4396 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 5980977.2024 | 2105564.7226 | 37.7603755774385 | -122.508916000736 | (37.7603755774385, -122.508916000736) | 1 | 8 | 3 | 56 | 35 | |||
38251 | 250986 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 185 Seal Rock Dr | 1 | : | Tree | Private 2 | 16 | Width 3ft | 5980980.82201 | 2112923.78682 | 37.7805816277787 | -122.50945005058 | (37.7805816277787, -122.50945005058) | 11 | 6 | 2 | 55 | 26 | |||
174398 | 103701 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4700 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 5980981.42101 | 2110300.97358 | 37.7733801939619 | -122.50925314442 | (37.7733801939619, -122.50925314442) | 11 | 6 | 2 | 55 | 26 | |||
7802 | 184178 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1604 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5980981.8741 | 2104106.8749 | 37.756373020872 | -122.508791602838 | (37.756373020872, -122.508791602838) | 1 | 8 | 3 | 56 | 35 | |||
179545 | 184180 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1610 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5980983.7076 | 2104061.3443 | 37.7562481149238 | -122.508781881753 | (37.7562481149238, -122.508781881753) | 1 | 8 | 3 | 56 | 35 | |||
170723 | 109509 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7200X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5980988.44063 | 2109621.98513 | 37.7715163048766 | -122.509178431554 | (37.7715163048766, -122.509178431554) | 11 | 6 | 2 | 55 | 26 | |||
46876 | 38371 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4245 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2011 12:00:00 AM | 1 | Permit Number 46593 | 5981002.9588 | 2104145.6829 | 37.756480819381 | -122.50872156702 | (37.756480819381, -122.50872156702) | 1 | 8 | 3 | 56 | 35 | |
176673 | 103699 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4700 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 5981012.38843 | 2110301.40953 | 37.7733832167065 | -122.509146058065 | (37.7733832167065, -122.509146058065) | 11 | 6 | 2 | 55 | 26 | |||
13791 | 47886 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4737 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | 6 | Permit Number 45632 | 5981014.1249 | 2106186.9276 | 37.7620861496896 | -122.508834503155 | (37.7620861496896, -122.508834503155) | 1 | 8 | 3 | 56 | 35 | |
133212 | 119226 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 715 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5981020.44403 | 2110823.32053 | 37.7748167056171 | -122.509156957318 | (37.7748167056171, -122.509156957318) | 11 | 6 | 2 | 55 | 26 | |||
119976 | 119228 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 701 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5981020.55796 | 2110899.83837 | 37.7750268077692 | -122.509162246597 | (37.7750268077692, -122.509162246597) | 11 | 6 | 2 | 55 | 26 | |||
102024 | 119227 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 5981021.77199 | 2110849.56022 | 37.7748888303639 | -122.509154312662 | (37.7748888303639, -122.509154312662) | 11 | 6 | 2 | 55 | 26 | |||
118292 | 118477 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 562 48th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5981021.8691 | 2111857.25612 | 37.7776556713315 | -122.509228826135 | (37.7776556713315, -122.509228826135) | 11 | 6 | 2 | 55 | 26 | |||
35840 | 119225 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 727 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5981023.84612 | 2110741.39714 | 37.7745919686982 | -122.509139104186 | (37.7745919686982, -122.509139104186) | 11 | 6 | 2 | 55 | 26 | |||
105530 | 119223 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 735 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5981025.6499 | 2110691.86737 | 37.7744560808806 | -122.509129185905 | (37.7744560808806, -122.509129185905) | 11 | 6 | 2 | 55 | 26 | |||
33888 | 119224 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 731 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5981025.77438 | 2110715.4681 | 37.7745208888731 | -122.509130508226 | (37.7745208888731, -122.509130508226) | 11 | 6 | 2 | 55 | 26 | |||
24872 | 119222 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 739 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5981027.41572 | 2110667.2741 | 37.7743886591074 | -122.509121251082 | (37.7743886591074, -122.509121251082) | 11 | 6 | 2 | 55 | 26 | |||
183031 | 119218 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 763 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5981033.21237 | 2110509.91967 | 37.7739569518981 | -122.509089512697 | (37.7739569518981, -122.509089512697) | 11 | 6 | 2 | 55 | 26 | |||
176211 | 119217 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 767 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5981034.11572 | 2110480.77646 | 37.7738769864738 | -122.509084223405 | (37.7738769864738, -122.509084223405) | 11 | 6 | 2 | 55 | 26 | |||
98906 | 118392 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 626 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5981039.09397 | 2111430.83509 | 37.7764858608449 | -122.50913756719 | (37.7764858608449, -122.50913756719) | 11 | 6 | 2 | 55 | 26 | |||
129087 | 118393 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 632 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5981041.70445 | 2111399.5882 | 37.776400220019 | -122.509126216077 | (37.776400220019, -122.509126216077) | 11 | 6 | 2 | 55 | 26 | |||
48471 | 38363 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1730 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2004 12:00:00 AM | Permit Number 44741 | 5981045.1604602 | 2103280.47601246 | 37.7541076952376 | -122.508511394581 | (37.7541076952376, -122.508511394581) | 1 | 8 | 3 | 56 | 35 | ||
159098 | 184592 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1738 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5981049.2322 | 2103224.6995 | 37.75395478877 | -122.508493173486 | (37.75395478877, -122.508493173486) | 1 | 8 | 3 | 56 | 35 | |||
180905 | 95287 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4245@Lower Great Highway Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2011 12:00:00 AM | 3x5 | 5981056 | 2104104.5 | 37.7563708691811 | -122.508535077894 | (37.7563708691811, -122.508535077894) | 1 | 8 | 3 | 56 | 35 | |||
16152 | 63923 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1762 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1987 12:00:00 AM | 10 | 4x6 | Permit Number 24645 | 5981062.59870673 | 2103072.00706036 | 37.7535363264903 | -122.50843561579 | (37.7535363264903, -122.50843561579) | 1 | 8 | 3 | 56 | 35 | |
111023 | 118963 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 710 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5981065.4684 | 2110852.35495 | 37.7748990799338 | -122.509003367842 | (37.7748990799338, -122.509003367842) | 11 | 6 | 2 | 55 | 26 | |||
147560 | 118962 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 718 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 5981067.98071 | 2110794.62587 | 37.7747407209907 | -122.508990389908 | (37.7747407209907, -122.508990389908) | 11 | 6 | 2 | 55 | 26 | |||
146776 | 118961 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 722 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5981069.81327 | 2110770.76906 | 37.7746753252483 | -122.508982279013 | (37.7746753252483, -122.508982279013) | 11 | 6 | 2 | 55 | 26 | |||
77698 | 118958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 738 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5981071.11518 | 2110678.5071 | 37.7744220778212 | -122.508970923414 | (37.7744220778212, -122.508970923414) | 11 | 6 | 2 | 55 | 26 | |||
2732 | 118955 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 750 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5981074.93145 | 2110594.12979 | 37.7741906275321 | -122.508951455998 | (37.7741906275321, -122.508951455998) | 11 | 6 | 2 | 55 | 26 | |||
81025 | 118950 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 790 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5981082.61085 | 2110351.11848 | 37.7735238426358 | -122.508906844787 | (37.7735238426358, -122.508906844787) | 11 | 6 | 2 | 55 | 26 | |||
120044 | 118951 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 784 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5981083.64589 | 2110377.48258 | 37.7735962917196 | -122.50890522241 | (37.7735962917196, -122.50890522241) | 11 | 6 | 2 | 55 | 26 | |||
108683 | 118949 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 794 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5981085.25189 | 2110332.14767 | 37.7734719100523 | -122.508896300354 | (37.7734719100523, -122.508896300354) | 11 | 6 | 2 | 55 | 26 | |||
148117 | 118689 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4645 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5981086.68024 | 2110929.25527 | 37.7751114760009 | -122.50893570407 | (37.7751114760009, -122.50893570407) | 11 | 6 | 2 | 55 | 26 | |||
2547 | 38368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4245 Lawton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 3 | Permit Number 40431 | 5981092.1865 | 2104150.2665 | 37.7564986636188 | -122.508413331792 | (37.7564986636188, -122.508413331792) | 1 | 8 | 3 | 56 | 35 | |
102900 | 255186 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4650 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981093 | 2111000 | 37.7753060927233 | -122.50891909698 | (37.7753060927233, -122.50891909698) | 11 | 6 | 2 | 55 | 26 | ||||
169344 | 118940 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 866 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5981103.6967 | 2109825.96964 | 37.7720831810124 | -122.508794909293 | (37.7720831810124, -122.508794909293) | 11 | 6 | 2 | 55 | 26 | |||
31641 | 118939 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 870 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5981104.04669 | 2109787.66612 | 37.7719780314039 | -122.508790854299 | (37.7719780314039, -122.508790854299) | 11 | 6 | 2 | 55 | 26 | |||
40602 | 118938 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 874 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5981104.7978 | 2109768.03491 | 37.7719241741289 | -122.508786798415 | (37.7719241741289, -122.508786798415) | 11 | 6 | 2 | 55 | 26 | |||
89863 | 118932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 890 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5981108.05536 | 2109679.46379 | 37.7716811758005 | -122.508768953384 | (37.7716811758005, -122.508768953384) | 11 | 6 | 2 | 55 | 26 | |||
47980 | 118931 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 894 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5981109.2149 | 2109657.02164 | 37.7716196245787 | -122.508763276041 | (37.7716196245787, -122.508763276041) | 11 | 6 | 2 | 55 | 26 | |||
64588 | 85357 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | 1 | 8 | 3 | 56 | 35 | |||
112081 | 85358 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 48th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | 1 | 8 | 3 | 56 | 35 | |||
150410 | 85355 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | 1 | 8 | 3 | 56 | 35 | |||||
152136 | 85356 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | 1 | 8 | 3 | 56 | 35 | |||
13838 | 118898 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7140 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5981141.02043 | 2109625.4747 | 37.7715348806274 | -122.508650918354 | (37.7715348806274, -122.508650918354) | 11 | 6 | 2 | 55 | 26 | |||
38140 | 37104 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1215 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | 3x3 | Permit Number 39702 | 5981158.6347 | 2106766.3804 | 37.7636856772509 | -122.508377723134 | (37.7636856772509, -122.508377723134) | 1 | 8 | 3 | 56 | 35 |
72901 | 118897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7140 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5981159.51058 | 2109626.64732 | 37.7715391901125 | -122.508587048124 | (37.7715391901125, -122.508587048124) | 11 | 6 | 2 | 55 | 26 | |||
108531 | 114553 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1235 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 4x4 | 5981162.8746 | 2106644.13 | 37.7633502628215 | -122.508353983735 | (37.7633502628215, -122.508353983735) | 1 | 8 | 3 | 56 | 35 | |||
127304 | 183290 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1271 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5981171.0011 | 2106414.1155 | 37.7627191882725 | -122.508308802837 | (37.7627191882725, -122.508308802837) | 1 | 8 | 3 | 56 | 35 | |||
64074 | 65145 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1991 12:00:00 AM | Permit Number 30097 | 5981171.08035557 | 2112695.84581661 | 37.7799669861685 | -122.50877493976 | (37.7799669861685, -122.50877493976) | 11 | 6 | 2 | 55 | 26 | ||
56925 | 184525 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1984 Lower Great Hwy | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5981181.3942 | 2101605.0811 | 37.7495155632023 | -122.507915944996 | (37.7495155632023, -122.507915944996) | 1 | 8 | 3 | 29491 | 35 | |||
71555 | 184523 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1984 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5981183.4247 | 2101564.8089 | 37.7494051067275 | -122.507905935252 | (37.7494051067275, -122.507905935252) | 1 | 8 | 3 | 29491 | 35 | |||
115305 | 69000 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1984 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | Permit Number 32995 | 5981187.48777379 | 2101571.41580392 | 37.7494234868175 | -122.507892375543 | (37.7494234868175, -122.507892375543) | 1 | 8 | 3 | 29491 | 35 | ||
183303 | 118690 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4631 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5981189.58568 | 2110933.39146 | 37.775128898447 | -122.50858004487 | (37.775128898447, -122.50858004487) | 11 | 6 | 2 | 55 | 26 | |||
191277 | 68288 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1994 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1993 12:00:00 AM | Permit Number 32097 | 5981192.89165036 | 2101506.41861494 | 37.7492453412397 | -122.507868866206 | (37.7492453412397, -122.507868866206) | 1 | 8 | 3 | 29491 | 35 | ||
142821 | 118896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7140 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5981194.21089 | 2109627.69648 | 37.7715441159498 | -122.508467097882 | (37.7715441159498, -122.508467097882) | 11 | 6 | 2 | 55 | 26 | |||
85106 | 65140 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | Permit Number 27115 | 5981196.67226771 | 2112697.46270488 | 37.7799729341387 | -122.508686527544 | (37.7799729341387, -122.508686527544) | 11 | 6 | 2 | 55 | 26 | ||
656 | 37103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
15025 | 37102 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
97278 | 37866 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4635 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 7 | Permit Number 40226 | 5981211.71775 | 2110254.19083 | 37.7732653175969 | -122.508453056303 | (37.7732653175969, -122.508453056303) | 11 | 6 | 2 | 55 | 26 | |
36770 | 251007 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 Point Lobos Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5981218.41729 | 2112709.81742 | 37.7800081381925 | -122.508612220583 | (37.7800081381925, -122.508612220583) | 11 | 6 | 2 | 55 | 26 | |||
85185 | 118691 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4623 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5981218.52405 | 2110933.62781 | 37.7751312529524 | -122.508479959956 | (37.7751312529524, -122.508479959956) | 11 | 6 | 2 | 55 | 26 | |||
70496 | 90286 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4630 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981219.28195 | 2110988.86276 | 37.7752829565285 | -122.508481439474 | (37.7752829565285, -122.508481439474) | 11 | 6 | 2 | 55 | 26 | ||
130205 | 183331 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4661 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5981220.7386 | 2106875.0181 | 37.7639876247918 | -122.508170992758 | (37.7639876247918, -122.508170992758) | 1 | 8 | 3 | 56 | 35 | |||
43576 | 118895 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7130 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5981227.10109 | 2109628.33584 | 37.7715478098001 | -122.50835337836 | (37.7715478098001, -122.50835337836) | 11 | 6 | 2 | 55 | 26 | |||
137714 | 67688 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1551 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2007 12:00:00 AM | Permit Number 49593 | 5981231.37137157 | 2104515.76346185 | 37.7575104157548 | -122.507959114088 | (37.7575104157548, -122.507959114088) | 1 | 8 | 3 | 56 | 35 | |||
181413 | 33941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1557 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1997 12:00:00 AM | 3 | Permit Number 37900 | 5981238.5987 | 2104476.2789 | 37.7574024282635 | -122.507931189279 | (37.7574024282635, -122.507931189279) | 1 | 8 | 3 | 56 | 35 | ||
47156 | 67687 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1561 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | 11 | Permit Number 31292 | 5981238.7246 | 2104439.6462 | 37.7573018527477 | -122.507928035281 | (37.7573018527477, -122.507928035281) | 1 | 8 | 3 | 56 | 35 | ||
69566 | 67689 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1563 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | 10 | Permit Number 31295 | 5981239.3358 | 2104429.5627 | 37.7572742023476 | -122.507925173233 | (37.7572742023476, -122.507925173233) | 1 | 8 | 3 | 56 | 35 | ||
22867 | 183332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4651 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5981239.5568 | 2106875.8545 | 37.76399103019 | -122.508105969425 | (37.76399103019, -122.508105969425) | 1 | 8 | 3 | 56 | 35 | |||
95914 | 69023 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2090 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 33027 | 5981247.43450995 | 2100853.11671093 | 37.7474547713207 | -122.507631788887 | (37.7474547713207, -122.507631788887) | 1 | 8 | 3 | 29491 | 35 | ||
104001 | 24757 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 472 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5981247.69836 | 2112733.69414 | 37.7800754223594 | -122.508512699012 | (37.7800754223594, -122.508512699012) | 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) );