Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79872 | 79872 | 38359 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
88039 | 88039 | 38357 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
94790 | 94790 | 38358 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
105666 | 105666 | 38355 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
106484 | 106484 | 38356 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
75339 | 75339 | 103704 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4700 Cabrillo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | 5980950.21824 | 2110299.88198 | 37.7733753570212 | -122.50936099615801 | (37.7733753570212, -122.509360996158) | |||
109771 | 109771 | 89204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1298 La Playa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | ||
128048 | 128048 | 89203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1298 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | ||
139497 | 139497 | 89202 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1298 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | ||
28041 | 28041 | 183645 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1488 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980952.0163 | 2104980.2451 | 37.7587692853894 | -122.508959706802 | (37.7587692853894, -122.508959706802) | |||
77972 | 77972 | 59691 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 185 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1981 12:00:00 AM | 38 | 4x3 | Permit Number 19118 | 5980952.62035506 | 2112920.61231564 | 37.7805712485973 | -122.50954737591499 | (37.7805712485973, -122.509547375915) | |
55479 | 55479 | 183263 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4398 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5980952.9997 | 2105563.3093 | 37.760370270166796 | -122.508999600178 | (37.7603702701668, -122.508999600178) | |||
68258 | 68258 | 183660 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1492 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980953.2204 | 2104940.5095 | 37.7586602538114 | -122.508952592119 | (37.7586602538114, -122.508952592119) | |||
161453 | 161453 | 183661 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1492 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980953.2204 | 2104954.9588 | 37.758699927444894 | -122.50895366499901 | (37.7586999274449, -122.508953664999) | |||
145374 | 145374 | 83520 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1488 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50200 | 5980958.16481146 | 2104928.49787253 | 37.758627564799795 | -122.508934600528 | (37.7586275647998, -122.508934600528) | ||
91053 | 91053 | 83966 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1492 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50201 | 5980959.07775236 | 2104901.96094882 | 37.758554755834496 | -122.508929472843 | (37.7585547558345, -122.508929472843) | ||
109721 | 109721 | 83967 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1492 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50201 | 5980959.07775236 | 2104901.96094882 | 37.758554755834496 | -122.508929472843 | (37.7585547558345, -122.508929472843) | ||
68013 | 68013 | 184265 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1516 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980961.5822 | 2104713.1219 | 37.75803640556521 | -122.50890679028 | (37.7580364055652, -122.50890679028) | |||
137790 | 137790 | 184264 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1516 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5980961.5822 | 2104704.8718 | 37.7580137531541 | -122.508906177719 | (37.7580137531541, -122.508906177719) | |||
63920 | 63920 | 184300 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5980963.5684 | 2104623.8985 | 37.757791540748 | -122.508893296573 | (37.757791540748, -122.508893296573) | |||
159726 | 159726 | 184299 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5980964.7906 | 2104608.0094 | 37.757747985875895 | -122.508887890039 | (37.7577479858759, -122.508887890039) | |||
47065 | 47065 | 184297 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1540 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5980967.2351 | 2104560.9533 | 37.7576189273961 | -122.508875942299 | (37.7576189273961, -122.508875942299) | |||
154379 | 154379 | 184298 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1540 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5980967.2351 | 2104582.3424 | 37.757677655741404 | -122.50887753038602 | (37.7576776557414, -122.508877530386) | |||
131810 | 131810 | 184324 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1546 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980967.8462 | 2104496.7858 | 37.7574427778303 | -122.508869064647 | (37.7574427778303, -122.508869064647) | |||
11308 | 11308 | 11608 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4396 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 5980977.2024 | 2105564.7226 | 37.7603755774385 | -122.50891600073601 | (37.7603755774385, -122.508916000736) | |||
45218 | 45218 | 250986 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 185 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 5980980.82201 | 2112923.78682 | 37.7805816277787 | -122.50945005058 | (37.7805816277787, -122.50945005058) | |||
24690 | 24690 | 103701 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4700 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | 5980981.42101 | 2110300.97358 | 37.7733801939619 | -122.50925314442 | (37.7733801939619, -122.50925314442) | |||
171473 | 171473 | 184178 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1604 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5980981.8741 | 2104106.8749 | 37.756373020872005 | -122.508791602838 | (37.756373020872, -122.508791602838) | |||
182136 | 182136 | 184180 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1610 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5980983.7076 | 2104061.3443 | 37.7562481149238 | -122.50878188175301 | (37.7562481149238, -122.508781881753) | |||
159650 | 159650 | 109509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7200X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5980988.44063 | 2109621.98513 | 37.7715163048766 | -122.50917843155399 | (37.7715163048766, -122.509178431554) | |||
184504 | 184504 | 38371 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4245 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2011 12:00:00 AM | 1 | Permit Number 46593 | 5981002.9588 | 2104145.6829 | 37.756480819381 | -122.50872156701999 | (37.756480819381, -122.50872156702) | |
127053 | 127053 | 103699 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4700 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5981012.38843 | 2110301.40953 | 37.7733832167065 | -122.509146058065 | (37.7733832167065, -122.509146058065) | |||
28500 | 28500 | 47886 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4737 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 6 | Permit Number 45632 | 5981014.1249 | 2106186.9276 | 37.7620861496896 | -122.508834503155 | (37.7620861496896, -122.508834503155) | |
37608 | 37608 | 119226 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 715 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5981020.44403 | 2110823.32053 | 37.774816705617106 | -122.509156957318 | (37.7748167056171, -122.509156957318) | |||
31425 | 31425 | 119228 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 701 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5981020.55796 | 2110899.83837 | 37.7750268077692 | -122.509162246597 | (37.7750268077692, -122.509162246597) | |||
157477 | 157477 | 119227 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 711 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 5981021.77199 | 2110849.56022 | 37.7748888303639 | -122.50915431266199 | (37.7748888303639, -122.509154312662) | |||
153493 | 153493 | 118477 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 562 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5981021.8691 | 2111857.25612 | 37.7776556713315 | -122.509228826135 | (37.7776556713315, -122.509228826135) | |||
26095 | 26095 | 119225 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 727 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981023.84612 | 2110741.39714 | 37.7745919686982 | -122.509139104186 | (37.7745919686982, -122.509139104186) | |||
182312 | 182312 | 119223 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 735 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981025.6499 | 2110691.86737 | 37.774456080880604 | -122.509129185905 | (37.7744560808806, -122.509129185905) | |||
38210 | 38210 | 119224 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 731 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981025.77438 | 2110715.4681 | 37.7745208888731 | -122.509130508226 | (37.7745208888731, -122.509130508226) | |||
155403 | 155403 | 119222 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 739 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5981027.41572 | 2110667.2741 | 37.7743886591074 | -122.50912125108201 | (37.7743886591074, -122.509121251082) | |||
154973 | 154973 | 119218 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 763 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981033.21237 | 2110509.91967 | 37.7739569518981 | -122.50908951269699 | (37.7739569518981, -122.509089512697) | |||
37157 | 37157 | 119217 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 767 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5981034.11572 | 2110480.77646 | 37.7738769864738 | -122.509084223405 | (37.7738769864738, -122.509084223405) | |||
130883 | 130883 | 118392 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 626 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5981039.09397 | 2111430.83509 | 37.7764858608449 | -122.50913756719 | (37.7764858608449, -122.50913756719) | |||
163008 | 163008 | 118393 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 632 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5981041.70445 | 2111399.5882 | 37.776400220019 | -122.50912621607701 | (37.776400220019, -122.509126216077) | |||
79922 | 79922 | 38363 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1730 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 44741 | 5981045.1604602 | 2103280.47601246 | 37.7541076952376 | -122.50851139458099 | (37.7541076952376, -122.508511394581) | ||
147018 | 147018 | 184592 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1738 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5981049.2322 | 2103224.6995 | 37.75395478877 | -122.508493173486 | (37.75395478877, -122.508493173486) | |||
141222 | 141222 | 95287 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4245@Lower Great Highway Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2011 12:00:00 AM | 3x5 | 5981056.0 | 2104104.5 | 37.756370869181104 | -122.508535077894 | (37.7563708691811, -122.508535077894) | |||
18453 | 18453 | 63923 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1762 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1987 12:00:00 AM | 10 | 4x6 | Permit Number 24645 | 5981062.59870673 | 2103072.00706036 | 37.7535363264903 | -122.50843561578999 | (37.7535363264903, -122.50843561579) | |
133569 | 133569 | 118963 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 710 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5981065.4684 | 2110852.35495 | 37.774899079933796 | -122.50900336784201 | (37.7748990799338, -122.509003367842) | |||
150876 | 150876 | 118962 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 718 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 5981067.98071 | 2110794.62587 | 37.77474072099071 | -122.508990389908 | (37.7747407209907, -122.508990389908) | |||
132423 | 132423 | 118961 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 5981069.81327 | 2110770.76906 | 37.774675325248296 | -122.50898227901301 | (37.7746753252483, -122.508982279013) | |||
146469 | 146469 | 118958 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 738 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981071.115180001 | 2110678.5071 | 37.7744220778212 | -122.508970923414 | (37.7744220778212, -122.508970923414) | |||
40804 | 40804 | 118955 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 750 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5981074.93145 | 2110594.12979 | 37.7741906275321 | -122.508951455998 | (37.7741906275321, -122.508951455998) | |||
162223 | 162223 | 118950 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 790 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5981082.61085 | 2110351.1184799997 | 37.7735238426358 | -122.508906844787 | (37.7735238426358, -122.508906844787) | |||
132800 | 132800 | 118951 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 784 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5981083.64589 | 2110377.48258 | 37.773596291719606 | -122.50890522241001 | (37.7735962917196, -122.50890522241) | |||
179954 | 179954 | 118949 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 794 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5981085.25189 | 2110332.14767 | 37.773471910052294 | -122.50889630035401 | (37.7734719100523, -122.508896300354) | |||
170884 | 170884 | 118689 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4645 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5981086.680240001 | 2110929.25527 | 37.7751114760009 | -122.50893570407 | (37.7751114760009, -122.50893570407) | |||
63953 | 63953 | 38368 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4245 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1998 12:00:00 AM | 3 | Permit Number 40431 | 5981092.1865 | 2104150.2665 | 37.7564986636188 | -122.508413331792 | (37.7564986636188, -122.508413331792) | |
56791 | 56791 | 54528 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4650 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 21 | Permit Number 10323 | 5981096.26906 | 2110986.58772 | 37.7752694592632 | -122.508906792671 | (37.7752694592632, -122.508906792671) | ||
130187 | 130187 | 118940 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 866 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981103.6967 | 2109825.9696400003 | 37.7720831810124 | -122.508794909293 | (37.7720831810124, -122.508794909293) | |||
32226 | 32226 | 118939 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 870 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5981104.04669 | 2109787.66612 | 37.7719780314039 | -122.508790854299 | (37.7719780314039, -122.508790854299) | |||
183221 | 183221 | 118938 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 874 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5981104.7978 | 2109768.03491 | 37.7719241741289 | -122.50878679841499 | (37.7719241741289, -122.508786798415) | |||
40340 | 40340 | 118932 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 890 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5981108.05536 | 2109679.46379 | 37.7716811758005 | -122.50876895338399 | (37.7716811758005, -122.508768953384) | |||
185636 | 185636 | 118931 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 894 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5981109.2149 | 2109657.02164 | 37.771619624578705 | -122.508763276041 | (37.7716196245787, -122.508763276041) | |||
89288 | 89288 | 85357 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1295 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | |||
103207 | 103207 | 85358 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1295 48th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | |||
114074 | 114074 | 85355 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1295 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | |||||
120809 | 120809 | 85356 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1295 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | |||
72657 | 72657 | 118898 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7140 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5981141.0204300005 | 2109625.4747 | 37.7715348806274 | -122.508650918354 | (37.7715348806274, -122.508650918354) | |||
65276 | 65276 | 37104 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1215 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39702 | 5981158.6347 | 2106766.3804 | 37.7636856772509 | -122.508377723134 | (37.7636856772509, -122.508377723134) | |
132499 | 132499 | 118897 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7140 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5981159.5105800005 | 2109626.64732 | 37.7715391901125 | -122.50858704812401 | (37.7715391901125, -122.508587048124) | |||
12142 | 12142 | 114553 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1235 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 5981162.8746 | 2106644.13 | 37.7633502628215 | -122.508353983735 | (37.7633502628215, -122.508353983735) | |||
65970 | 65970 | 183290 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1271 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5981171.0011 | 2106414.1155 | 37.7627191882725 | -122.508308802837 | (37.7627191882725, -122.508308802837) | |||
90264 | 90264 | 65145 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 512 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1991 12:00:00 AM | Permit Number 30097 | 5981171.08035557 | 2112695.84581661 | 37.779966986168496 | -122.50877493976002 | (37.7799669861685, -122.50877493976) | ||
74547 | 74547 | 184525 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1984 Lower Great Hwy | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981181.3942 | 2101605.0811 | 37.749515563202294 | -122.507915944996 | (37.7495155632023, -122.507915944996) | |||
179116 | 179116 | 184523 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1984 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981183.4247 | 2101564.8089 | 37.7494051067275 | -122.507905935252 | (37.7494051067275, -122.507905935252) | |||
105039 | 105039 | 69000 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1984 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | Permit Number 32995 | 5981187.48777379 | 2101571.41580392 | 37.7494234868175 | -122.50789237554301 | (37.7494234868175, -122.507892375543) | ||
160255 | 160255 | 118690 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4631 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5981189.5856800005 | 2110933.39146 | 37.775128898447 | -122.50858004487 | (37.775128898447, -122.50858004487) | |||
146190 | 146190 | 68288 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1994 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1993 12:00:00 AM | Permit Number 32097 | 5981192.89165036 | 2101506.41861494 | 37.74924534123971 | -122.507868866206 | (37.7492453412397, -122.507868866206) | ||
29743 | 29743 | 118896 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7140 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5981194.21089 | 2109627.69648 | 37.771544115949794 | -122.508467097882 | (37.7715441159498, -122.508467097882) | |||
91538 | 91538 | 65140 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1989 12:00:00 AM | Permit Number 27115 | 5981196.67226771 | 2112697.46270488 | 37.779972934138705 | -122.508686527544 | (37.7799729341387, -122.508686527544) | ||
19133 | 19133 | 37103 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.764023420548796 | -122.508237579769 | (37.7640234205488, -122.508237579769) | ||
19842 | 19842 | 37102 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.764023420548796 | -122.508237579769 | (37.7640234205488, -122.508237579769) | ||
175657 | 175657 | 37866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4635 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 7 | Permit Number 40226 | 5981211.71775 | 2110254.1908299997 | 37.773265317596895 | -122.50845305630301 | (37.7732653175969, -122.508453056303) | |
47958 | 47958 | 251007 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5981218.41729 | 2112709.81742 | 37.7800081381925 | -122.508612220583 | (37.7800081381925, -122.508612220583) | |||
172788 | 172788 | 118691 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4623 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5981218.52405 | 2110933.62781 | 37.7751312529524 | -122.50847995995599 | (37.7751312529524, -122.508479959956) | |||
84973 | 84973 | 90286 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4630 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981219.28195 | 2110988.86276 | 37.7752829565285 | -122.508481439474 | (37.7752829565285, -122.508481439474) | ||
73701 | 73701 | 183331 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4661 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5981220.7386 | 2106875.0181 | 37.763987624791795 | -122.50817099275801 | (37.7639876247918, -122.508170992758) | |||
133556 | 133556 | 118895 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7130 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5981227.10109 | 2109628.3358400003 | 37.7715478098001 | -122.50835337836 | (37.7715478098001, -122.50835337836) | |||
115359 | 115359 | 67688 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1551 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2007 12:00:00 AM | Permit Number 49593 | 5981231.37137157 | 2104515.76346185 | 37.757510415754794 | -122.507959114088 | (37.7575104157548, -122.507959114088) | |||
55175 | 55175 | 33941 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1557 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1997 12:00:00 AM | 3 | Permit Number 37900 | 5981238.5987 | 2104476.2789 | 37.757402428263504 | -122.507931189279 | (37.7574024282635, -122.507931189279) | ||
133141 | 133141 | 67687 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1561 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 11 | Permit Number 31292 | 5981238.7246 | 2104439.6462 | 37.7573018527477 | -122.507928035281 | (37.7573018527477, -122.507928035281) | ||
130114 | 130114 | 67689 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1563 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 10 | Permit Number 31295 | 5981239.3358 | 2104429.5627 | 37.7572742023476 | -122.50792517323299 | (37.7572742023476, -122.507925173233) | ||
167235 | 167235 | 183332 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4651 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981239.5568 | 2106875.8545 | 37.76399103019 | -122.50810596942499 | (37.76399103019, -122.508105969425) | |||
102504 | 102504 | 69023 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2090 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | Permit Number 33027 | 5981247.43450995 | 2100853.11671093 | 37.747454771320704 | -122.50763178888701 | (37.7474547713207, -122.507631788887) | ||
100043 | 100043 | 24757 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 472 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5981247.69836 | 2112733.6941400003 | 37.7800754223594 | -122.50851269901199 | (37.7800754223594, -122.508512699012) | |||
30058 | 30058 | 54064 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1619-1621 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 19 | Permit Number 9787 | 5981254.141 | 2104003.8963 | 37.7561063161195 | -122.50784238373001 | (37.7561063161195, -122.50784238373) | ||
165060 | 165060 | 118488 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8301 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5981255.6094 | 2112295.38099 | 37.778872410675895 | -122.508452785017 | (37.7788724106759, -122.508452785017) | ||||
113767 | 113767 | 50438 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 472 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1989 12:00:00 AM | Permit Number 47089 | 5981256.38673996 | 2112701.23544484 | 37.779986812480395 | -122.50848023228201 | (37.7799868124804, -122.508480232282) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");