trees
8,758 rows where qSpecies_id = 16 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10436 | 105254 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130 GONZALEZ DR | Front Yard : Yard | Tree | Private 2 | 2 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | |||||
14439 | 104509 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 DICHIERA CT | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5998620 | 2088043 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | 9 | 7 | 6 | 28861 | 25 | |||||
18284 | 258470 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2414 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781119 | 5981787.508 | 2098641.53969 | 37.741414197633 | -122.505600368739 | (37.741414197633, -122.505600368739) | 1 | 8 | 3 | 29491 | 35 | |
20631 | 104678 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3531-3535 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003359 | 2106442.3 | 37.7640791638998 | -122.431570451949 | (37.7640791638998, -122.431570451949) | 15 | 4 | 5 | 28862 | 3 | ||||
26253 | 92760 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
27453 | 111935 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 66 SEACLIFF AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5987847 | 2115823 | 37.788944509176 | -122.485909838035 | (37.788944509176, -122.485909838035) | 11 | 6 | 1 | 55 | 33 | |||||
28982 | 104551 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 428 PANORAMA DR | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5997536 | 2102327 | 37.7524478160364 | -122.451413569464 | (37.7524478160364, -122.451413569464) | 1 | 5 | 4 | 63 | 38 | ||||
29317 | 92765 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
31593 | 89364 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2690 Ocean Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51942 | 5990665.5 | 2095192.3 | 37.7324619562673 | -122.474651985861 | (37.7324619562673, -122.474651985861) | 1 | 8 | 4 | 64 | 40 | ||||
33508 | 92764 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
35294 | 251689 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 355 Silver Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003702 | 2093526 | 37.7286334396351 | -122.429462937782 | (37.7286334396351, -122.429462937782) | 9 | 7 | 6 | 28861 | 5 | |||||
38404 | 258531 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4341 Kirkham St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782234 | 5981427.35617 | 2104849.55351 | 37.7584384536263 | -122.507306095471 | (37.7584384536263, -122.507306095471) | 1 | 8 | 3 | 56 | 35 | |
38873 | 92763 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
39038 | 97647 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1844 Noriega St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988207.7 | 2103154.5 | 37.7541813368782 | -122.483732655057 | (37.7541813368782, -122.483732655057) | 1 | 8 | 3 | 56 | 35 | |||||
44860 | 88643 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51616 | 6011739.6 | 2099623 | 37.7458263117587 | -122.402104784517 | (37.7458263117587, -122.402104784517) | 10 | 3 | 8 | 58 | 1 | |||
50287 | 107758 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 126 HIGHLAND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005605.1 | 2096623 | 37.7372446808015 | -122.423103843591 | (37.7372446808015, -122.423103843591) | 2 | 7 | 7 | 28859 | 2 | |||||
51017 | 92762 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
53182 | 258420 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2282 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783272 | 5982375.8384 | 2099583.33174 | 37.7440347055109 | -122.50363588861 | (37.7440347055109, -122.50363588861) | 1 | 8 | 3 | 29491 | 35 | |
56730 | 86871 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2160 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49804 | 6002705 | 2118187 | 37.796290071465 | -122.434672325351 | (37.796290071465, -122.434672325351) | 13 | 9 | 1 | 57 | 17 | ||||
66938 | 92761 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
87570 | 92759 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
96218 | 87752 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3738 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50409 | 5995374.6 | 2112966.7 | 37.7815376640386 | -122.459658564837 | (37.7815376640386, -122.459658564837) | 11 | 6 | 2 | 54 | 11 | |||
100310 | 110968 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2411 WASHINGTON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x6 | 6003071 | 2116473 | 37.7916046396744 | -122.433283354559 | (37.7916046396744, -122.433283354559) | 13 | 9 | 1 | 29490 | 27 | ||||
103626 | 86747 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 211 Magellan Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49712 | 5995006.7 | 2100576.6 | 37.7474965017759 | -122.46003345468 | (37.7474965017759, -122.46003345468) | 1 | 8 | 4 | 29491 | 40 | |||||
108660 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.445678167683 | (37.7642451591147, -122.445678167683) | 15 | 5 | 5 | 29492 | 9 | ||||||
121401 | 86769 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 574 26th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49742 | 5987849.11568 | 2112068.76078 | 37.7786365594606 | -122.485626884707 | (37.7786365594606, -122.485626884707) | 11 | 6 | 2 | 55 | 26 | ||
126111 | 88110 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1779 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51114 | 5981270 | 2102975.3 | 37.7532830173469 | -122.507711214113 | (37.7532830173469, -122.507711214113) | 1 | 8 | 3 | 56 | 35 | |||
128693 | 257889 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1862 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782771 | 5984139.96462 | 2102494.29431 | 37.7521309716262 | -122.497750926959 | (37.7521309716262, -122.497750926959) | 1 | 8 | 3 | 56 | 35 | |
134204 | 92767 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
144165 | 89003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 658 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51755 | 5983531.7658 | 2111325.68873 | 37.7763438006114 | -122.50050706598 | (37.7763438006114, -122.50050706598) | 11 | 6 | 2 | 55 | 26 | ||
148437 | 87843 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2630 Balboa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50750 | 5987373.4413 | 2111210.00653 | 37.7762509357291 | -122.487209313782 | (37.7762509357291, -122.487209313782) | 11 | 6 | 2 | 55 | 26 | ||
149511 | 92766 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
152065 | 258414 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2278 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783271 | 5982374.92539 | 2099609.35071 | 37.7441060927246 | -122.503640971997 | (37.7441060927246, -122.503640971997) | 1 | 8 | 3 | 29491 | 35 | |
157563 | 86776 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 756 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49748 | 5993859.3 | 2110364.9 | 37.7743065681305 | -122.464711743298 | (37.7743065681305, -122.464711743298) | 11 | 6 | 2 | 54 | 11 | ||||
163486 | 258504 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1474 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783288 | 5981259.3327 | 2105040.90267 | 37.7589539453375 | -122.507901385569 | (37.7589539453375, -122.507901385569) | 1 | 8 | 3 | 56 | 35 | |
165146 | 88276 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2374 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767123 | 5981803.3 | 2098936.1 | 37.7422239080831 | -122.505567596003 | (37.7422239080831, -122.505567596003) | 1 | 8 | 3 | 29491 | 35 | ||
166839 | 88103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1246 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51107 | 5982161.5 | 2106610.6 | 37.763316999992 | -122.504897638357 | (37.763316999992, -122.504897638357) | 1 | 8 | 3 | 56 | 35 | |||
173216 | 89043 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2590X WASHINGTON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51782 | 6002311 | 2116492 | 37.7916136648632 | -122.435914302745 | (37.7916136648632, -122.435914302745) | 13 | 9 | 1 | 29490 | 27 | |||
173426 | 87821 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1359 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50714 | 5982101.5 | 2105852.2 | 37.7612311205066 | -122.505048948824 | (37.7612311205066, -122.505048948824) | 1 | 8 | 3 | 56 | 35 | |||
173569 | 258211 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2131 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2019 12:00:00 AM | 3 | 3x 3 | Permit Number 781078 | 5982921.39073 | 2100620.36173 | 37.746914163779 | -122.501826234988 | (37.746914163779, -122.501826234988) | 1 | 8 | 3 | 29491 | 35 | |
180663 | 106366 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 SEAL ROCK DR | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981833.1 | 2112945.4 | 37.7806911884837 | -122.506503269885 | (37.7806911884837, -122.506503269885) | 11 | 6 | 2 | 55 | 26 | ||||||
181824 | 88644 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51616 | 6011739.6 | 2099623 | 37.7458263117587 | -122.402104784517 | (37.7458263117587, -122.402104784517) | 10 | 3 | 8 | 58 | 1 | |||
185934 | 88086 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1215 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51086 | 5984240 | 2106877.9 | 37.7641729917025 | -122.497728636654 | (37.7641729917025, -122.497728636654) | 1 | 8 | 3 | 56 | 35 | |||
194502 | 265146 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3512 23rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006075 | 2102620 | 37.753737588166 | -122.421905052211 | (37.753737588166, -122.421905052211) | 2 | 4 | 5 | 28859 | 19 | |||||
545 | 90279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4338 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982078.08793 | 2111023.84587 | 37.7754295872152 | -122.505513277346 | (37.7754295872152, -122.505513277346) | 11 | 6 | 2 | 55 | 26 | ||
554 | 63105 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23825 | 6006733.57538349 | 2099199.19959074 | 37.7443819667232 | -122.41938488452 | (37.7443819667232, -122.41938488452) | 2 | 7 | 7 | 28859 | 2 | ||
564 | 67334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1992 12:00:00 AM | 12 | Permit Number 30818 | 6008868.73151 | 2090340.18885 | 37.7201770527016 | -122.411376204361 | (37.7201770527016, -122.411376204361) | 9 | 3 | 7 | 309 | 28 | |
682 | 16784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1961 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 5999039.4234543 | 2112720.6314145 | 37.781072082708 | -122.446962370058 | (37.781072082708, -122.446962370058) | 15 | 5 | 1 | 54 | 16 | |||
715 | 67254 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2107 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 4 | Permit Number 32998 | 5981675.3208 | 2100708.9402 | 37.7470841010946 | -122.506141523298 | (37.7470841010946, -122.506141523298) | 1 | 8 | 3 | 29491 | 35 | |
836 | 115913 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 701X 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5987215.25385 | 2111126.11495 | 37.776011367597 | -122.487750355607 | (37.776011367597, -122.487750355607) | 11 | 6 | 2 | 55 | 26 | |||
865 | 65062 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 481 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1989 12:00:00 AM | Permit Number 27018 | 5982198.4613122 | 2112526.22921648 | 37.7795617740877 | -122.505208255718 | (37.7795617740877, -122.505208255718) | 11 | 6 | 2 | 55 | 26 | ||
915 | 40138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1979 12:00:00 AM | 12 | Permit Number 41341 | 5982776.0706 | 2104863.9918 | 37.7585574465855 | -122.502642786425 | (37.7585574465855, -122.502642786425) | 1 | 8 | 3 | 56 | 35 | |
1001 | 70458 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3222 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982856.1897 | 2099504.4786 | 37.74384642674 | -122.501969135738 | (37.74384642674, -122.501969135738) | 1 | 8 | 3 | 29491 | 35 | |||
1060 | 9003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5211 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5990830.5755 | 2112639.2637 | 37.7803762685111 | -122.475354635721 | (37.7803762685111, -122.475354635721) | 11 | 6 | 2 | 54 | 26 | |||
1147 | 131409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2817 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003467.33625 | 2118170.97636 | 37.796289323341 | -122.432033340382 | (37.796289323341, -122.432033340382) | 13 | 9 | 1 | 57 | 17 | |||
1182 | 922 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1253 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002943.78693 | 2094101.1406 | 37.7301696879821 | -122.432125178253 | (37.7301696879821, -122.432125178253) | 9 | 7 | 6 | 28861 | 25 | |||
1201 | 2190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1055 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000864.0909 | 2112351.4116 | 37.7801623757286 | -122.440623460362 | (37.7801623757286, -122.440623460362) | 15 | 5 | 1 | 29490 | 41 | |||
1217 | 8697 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3015 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997765.247 | 2113011.588 | 37.7817980956526 | -122.451391351666 | (37.7817980956526, -122.451391351666) | 15 | 6 | 2 | 54 | 16 | |||
1237 | 35474 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | Permit Number 38887 | 6007396.82109854 | 2112616.81920427 | 37.7812609627381 | -122.418042529741 | (37.7812609627381, -122.418042529741) | 7 | 9 | 9 | 28852 | 36 | |||
1254 | 61578 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 740 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21541 | 6012694.18956 | 2104059.23085 | 37.7580604768161 | -122.399115263054 | (37.7580604768161, -122.399115263054) | 10 | 3 | 8 | 28856 | 29 | |
1307 | 184338 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5984829.2872 | 2105764.6569 | 37.7611508651334 | -122.495608375429 | (37.7611508651334, -122.495608375429) | 1 | 8 | 3 | 56 | 35 | |||
1317 | 71329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 346 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6003746.38005 | 2089169.34853 | 37.7166735503194 | -122.428999024181 | (37.7166735503194, -122.428999024181) | 9 | 7 | 6 | 28861 | 5 | |||
1368 | 184450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2127 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982917.6673 | 2100633.8105 | 37.7469508716588 | -122.501840104956 | (37.7469508716588, -122.501840104956) | 1 | 8 | 3 | 29491 | 35 | |||
1394 | 60245 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 15 | Permit Number 19797 | 5987888.319 | 2107103.366 | 37.7650052514475 | -122.485126853783 | (37.7650052514475, -122.485126853783) | 1 | 8 | 3 | 56 | 35 | |
1440 | 60253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1258 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19805 | 5988032.4773 | 2106727.2678 | 37.7639809852919 | -122.484600662652 | (37.7639809852919, -122.484600662652) | 1 | 8 | 3 | 56 | 35 | |
1457 | 209974 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 634 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995417.8126 | 2093581.25052 | 37.7283126275124 | -122.458105669454 | (37.7283126275124, -122.458105669454) | 9 | 7 | 4 | 28861 | 40 | |||
1466 | 61584 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 779 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 17 | Permit Number 21548 | 6012760.83948 | 2103909.15662 | 37.7576521198591 | -122.398874224986 | (37.7576521198591, -122.398874224986) | 10 | 3 | 8 | 28856 | 29 | |
1485 | 70364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4039 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5982287.6338 | 2104871.478 | 37.7585492864556 | -122.504332547004 | (37.7585492864556, -122.504332547004) | 1 | 8 | 3 | 56 | 35 | |||
1610 | 60248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1238 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 14 | Permit Number 19800 | 5988026.3501 | 2106852.875 | 37.7643255113996 | -122.48463106882 | (37.7643255113996, -122.48463106882) | 1 | 8 | 3 | 56 | 35 | |
1621 | 71826 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1559 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5988678.2006 | 2104711.6203 | 37.7584841471685 | -122.482219640193 | (37.7584841471685, -122.482219640193) | 1 | 8 | 3 | 56 | 35 | |||
1629 | 73716 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 946 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3x3 | 6012746.53827 | 2103105.12598 | 37.7554436304258 | -122.398867256125 | (37.7554436304258, -122.398867256125) | 10 | 3 | 8 | 28856 | 29 | ||
1717 | 61572 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 14 | Permit Number 21533 | 6012736.84256 | 2103280.10738 | 37.7559235509547 | -122.39891306758 | (37.7559235509547, -122.39891306758) | 10 | 3 | 8 | 28856 | 29 | |
1740 | 5129 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2775 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/1983 12:00:00 AM | 10 | 3X3 | 6002512.34992 | 2095942.64763 | 37.7352015755927 | -122.433748276472 | (37.7352015755927, -122.433748276472) | 2 | 7 | 5 | 63 | 7 | ||
1874 | 78526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5981863.3141 | 2099471.5008 | 37.7436975019585 | -122.505399764525 | (37.7436975019585, -122.505399764525) | 1 | 8 | 3 | 29491 | 35 | |||
1919 | 98261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 676 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 776653 | 5981365.73942 | 2111125.46261 | 37.775666650072 | -122.507984958591 | (37.775666650072, -122.507984958591) | 11 | 6 | 2 | 55 | 26 | ||
1966 | 61296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2360 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 9 | Permit Number 23055 | 6006748.00387 | 2119357.01746 | 37.7997313381808 | -122.420765770421 | (37.7997313381808, -122.420765770421) | 5 | 9 | 1 | 28858 | 32 | |
1974 | 114892 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2226 45TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777232 | 5982390 | 2099932 | 37.7449928846436 | -122.503612737002 | (37.7449928846436, -122.503612737002) | 1 | 8 | 3 | 29491 | 35 | |
2020 | 61588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 803 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 15 | Permit Number 21555 | 6012773.15046 | 2103707.15078 | 37.7570981419736 | -122.398817471471 | (37.7570981419736, -122.398817471471) | 10 | 3 | 8 | 28856 | 29 | |
2021 | 40151 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2000 12:00:00 AM | 1 | Permit Number 43635 | 5982132.3748 | 2106725.7272 | 37.7636313927747 | -122.505006903253 | (37.7636313927747, -122.505006903253) | 1 | 8 | 3 | 56 | 35 | |
2042 | 71413 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1207 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016921.2196 | 2093689.4573 | 37.7298218479605 | -122.38377424868 | (37.7298218479605, -122.38377424868) | 10 | 3 | 8 | 58 | 1 | |||
2124 | 209922 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 870 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990546.69569 | 2099087.99208 | 37.7431516445476 | -122.475347038257 | (37.7431516445476, -122.475347038257) | 1 | 8 | 4 | 29491 | 40 | |||
2147 | 1184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3014 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5996622.2967 | 2087313.8651 | 37.7111729927061 | -122.453489407116 | (37.7111729927061, -122.453489407116) | 9 | 7 | 6 | 28861 | 25 | |||
2162 | 250415 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | Width 4ft | 5987895.18737 | 2115830.32518 | 37.7889674299609 | -122.485743656163 | (37.7889674299609, -122.485743656163) | 11 | 6 | 1 | 55 | 33 | ||
2190 | 117790 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3915 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5983427.0312 | 2111011.12513 | 37.775473951484 | -122.500846098251 | (37.775473951484, -122.500846098251) | 11 | 6 | 2 | 55 | 26 | |||
2198 | 232238 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1742 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003957.58921 | 2098088.34983 | 37.7411750875649 | -122.428904483875 | (37.7411750875649, -122.428904483875) | 2 | 7 | 5 | 63 | 7 | |||
2300 | 1941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 217 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6000825.89094 | 2097729.82062 | 37.7400128936831 | -122.439707051235 | (37.7400128936831, -122.439707051235) | 2 | 7 | 5 | 63 | 7 | |||
2373 | 183738 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2271 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 09/26/2020 12:00:00 AM | 3 | 4x6 | 5985432.7595 | 2099768.105 | 37.7447212985473 | -122.493079504102 | (37.7447212985473, -122.493079504102) | 1 | 8 | 3 | 29491 | 35 | |
2400 | 232794 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 701 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x9 | 6003144.80454 | 2104133.37104 | 37.7577272573137 | -122.432146391441 | (37.7577272573137, -122.432146391441) | 2 | 4 | 5 | 28862 | 3 | |||
2425 | 31630 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2482 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35147 | 5981478.22688702 | 2098193.22560061 | 37.7401650446812 | -122.506636494986 | (37.7401650446812, -122.506636494986) | 1 | 8 | 3 | 29491 | 35 | ||
2443 | 58993 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 590 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1980 12:00:00 AM | 14 | Permit Number 18284 | 5995033.83753 | 2111544.26695 | 37.7776124415586 | -122.460734316672 | (37.7776124415586, -122.460734316672) | 11 | 6 | 2 | 54 | 11 | ||
2515 | 71240 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.438407179792 | (37.781532142896, -122.438407179792) | 15 | 5 | 11 | 29490 | 41 | |||
2518 | 250436 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5987616.8568 | 2115817.96032 | 37.7889172576592 | -122.486705722111 | (37.7889172576592, -122.486705722111) | 11 | 6 | 1 | 55 | 33 | |||
2550 | 1015 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1854X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6001128.27711 | 2091386.71553 | 37.7226133962853 | -122.438207240029 | (37.7226133962853, -122.438207240029) | 9 | 7 | 6 | 28861 | 25 | |||
2556 | 4083 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3215 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008095.47339 | 2100529.11474 | 37.7481102284008 | -122.414769812274 | (37.7481102284008, -122.414769812274) | 2 | 4 | 7 | 28859 | 2 | |||
2562 | 232750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 373 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002968.45088 | 2106099.8261 | 37.7631166695342 | -122.432896777683 | (37.7631166695342, -122.432896777683) | 15 | 4 | 5 | 28862 | 3 | |||
2563 | 18769 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 290 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | Permit Number 787822 | 6000600.23585 | 2106985.9234 | 37.765415066877 | -122.441151190675 | (37.765415066877, -122.441151190675) | 15 | 5 | 5 | 29492 | 3 | ||
2618 | 38070 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2495 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 7 | Permit Number 40259 | 6000679.6833 | 2114111.2164 | 37.7849838454949 | -122.441387719132 | (37.7849838454949, -122.441387719132) | 15 | 6 | 11 | 29490 | 13 | |
2652 | 18747 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000958.79784 | 2107315.99315 | 37.7663417741813 | -122.439934678663 | (37.7663417741813, -122.439934678663) | 15 | 5 | 5 | 29492 | 3 | |||
2680 | 71821 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1270 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5988034.775 | 2106656.0393 | 37.7637855451579 | -122.484587490638 | (37.7637855451579, -122.484587490638) | 1 | 8 | 3 | 56 | 35 | |||
2738 | 140731 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2023 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2004 12:00:00 AM | 12 | Width 0ft | 6001651.0062 | 2113204.4884 | 37.7825494877114 | -122.437962288192 | (37.7825494877114, -122.437962288192) | 15 | 5 | 11 | 29490 | 41 |
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) );