trees
8,758 rows where qSpecies_id = 16 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60856 | 1000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1726 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X5PL | 6001385.76767 | 2092068.06757 | 37.724498876108 | -122.437365919005 | (37.724498876108, -122.437365919005) | 9 | 7 | 6 | 28861 | 25 | |||
171432 | 100168 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 710 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986405.6 | 2114870 | 37.7862437457696 | -122.490826667671 | (37.7862437457696, -122.490826667671) | 11 | 6 | 1 | 55 | 33 | |||||
126592 | 100184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 480 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6006818.05082 | 2091764.69226 | 37.7239732025834 | -122.418565697766 | (37.7239732025834, -122.418565697766) | 9 | 7 | 7 | 309 | 28 | |||
136027 | 100216 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 527-529 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003013 | 2105186 | 37.7606100501577 | -122.432677416542 | (37.7606100501577, -122.432677416542) | 2 | 4 | 5 | 28862 | 3 | |||
163276 | 100217 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 527-529 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003013 | 2105186 | 37.7606100501577 | -122.432677416542 | (37.7606100501577, -122.432677416542) | 2 | 4 | 5 | 28862 | 3 | |||
128371 | 100352 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4329 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | Permit Number 769248 | 5982262.3 | 2106887.2 | 37.7640823940264 | -122.504569504513 | (37.7640823940264, -122.504569504513) | 1 | 8 | 3 | 56 | 35 | ||
56521 | 100534 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2524 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2012 12:00:00 AM | 5 | Permit Number 769201 | 6002650.71581 | 2116155.36871 | 37.7907086541232 | -122.434714808441 | (37.7907086541232, -122.434714808441) | 13 | 9 | 1 | 29490 | 27 | ||
174676 | 100563 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 284 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009946.4 | 2114395 | 37.7862865916342 | -122.409347728871 | (37.7862865916342, -122.409347728871) | 5 | 10 | 10 | 28852 | 36 | |||
68872 | 100564 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009858 | 2114440 | 37.7864051976389 | -122.409656748713 | (37.7864051976389, -122.409656748713) | 5 | 10 | 10 | 28852 | 36 | |||
159847 | 100565 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009858 | 2114440 | 37.7864051976389 | -122.409656748713 | (37.7864051976389, -122.409656748713) | 5 | 10 | 10 | 28852 | 36 | |||
33897 | 100566 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009858 | 2114440 | 37.7864051976389 | -122.409656748713 | (37.7864051976389, -122.409656748713) | 5 | 10 | 10 | 28852 | 36 | |||
34017 | 100567 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009858 | 2114440 | 37.7864051976389 | -122.409656748713 | (37.7864051976389, -122.409656748713) | 5 | 10 | 10 | 28852 | 36 | |||
176215 | 100692 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 685X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 10 | 4x4 | Permit Number 769119 | 6012690.8 | 2113888.8 | 37.7850500640854 | -122.399817195016 | (37.7850500640854, -122.399817195016) | 6 | 2 | 9 | 28853 | 6 | |
119771 | 100702 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 685X Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6012690.8 | 2113888.8 | 37.7850500640854 | -122.399817195016 | (37.7850500640854, -122.399817195016) | 6 | 2 | 9 | 28853 | 6 | |||
119864 | 100703 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 685X Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6012690.8 | 2113888.8 | 37.7850500640854 | -122.399817195016 | (37.7850500640854, -122.399817195016) | 6 | 2 | 9 | 28853 | 6 | |||
98811 | 100704 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 685X Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6012690.8 | 2113888.8 | 37.7850500640854 | -122.399817195016 | (37.7850500640854, -122.399817195016) | 6 | 2 | 9 | 28853 | 6 | |||
153180 | 100709 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 685X Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6012690.8 | 2113888.8 | 37.7850500640854 | -122.399817195016 | (37.7850500640854, -122.399817195016) | 6 | 2 | 9 | 28853 | 6 | |||
99952 | 100712 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777720 | 6012642.07844 | 2113780.85494 | 37.7847509558276 | -122.399978174254 | (37.7847509558276, -122.399978174254) | 6 | 2 | 9 | 28853 | 6 | |
15556 | 100713 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2020 12:00:00 AM | 3 | 4x4 | 6012618.71345 | 2113808.99095 | 37.7848269080754 | -122.400060986537 | (37.7848269080754, -122.400060986537) | 6 | 2 | 9 | 28853 | 6 | ||
146142 | 100714 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6012602.76589 | 2113824.0281 | 37.7848673074186 | -122.400117216662 | (37.7848673074186, -122.400117216662) | 6 | 2 | 9 | 28853 | 6 | |||
87705 | 100716 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6012588.83834 | 2113836.67028 | 37.7849012433369 | -122.400166289961 | (37.7849012433369, -122.400166289961) | 6 | 2 | 9 | 28853 | 6 | |||
82369 | 100717 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6012575.24779 | 2113851.36546 | 37.7849408350855 | -122.400214341625 | (37.7849408350855, -122.400214341625) | 6 | 2 | 9 | 28853 | 6 | |||
120045 | 100718 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6012561.60349 | 2113863.41333 | 37.7849731549205 | -122.400262393299 | (37.7849731549205, -122.400262393299) | 6 | 2 | 9 | 28853 | 6 | |||
126004 | 100815 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1324 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2012 12:00:00 AM | 0 | Permit Number 769327 | 5982180.1 | 2106070.8 | 37.7618359578506 | -122.504793307747 | (37.7618359578506, -122.504793307747) | 1 | 8 | 3 | 56 | 35 | ||
30923 | 1009 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1833 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 6001322.10095 | 2091567.19027 | 37.7231199608958 | -122.437550153242 | (37.7231199608958, -122.437550153242) | 9 | 7 | 6 | 28861 | 25 | |||
81512 | 101091 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1202 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5990254.0041 | 2103161.7012 | 37.7543200129532 | -122.476656631351 | (37.7543200129532, -122.476656631351) | 1 | 8 | 3 | 56 | 35 | |||
180885 | 101092 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990310.3 | 2103151.6 | 37.7542955428806 | -122.476461210066 | (37.7542955428806, -122.476461210066) | 1 | 8 | 3 | 56 | 35 | |||||
139756 | 101093 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990310.3 | 2103151.6 | 37.7542955428806 | -122.476461210066 | (37.7542955428806, -122.476461210066) | 1 | 8 | 3 | 56 | 35 | |||||
98621 | 101094 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1222 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5990152.5013 | 2103157.8184 | 37.7543034638572 | -122.477007366297 | (37.7543034638572, -122.477007366297) | 1 | 8 | 3 | 56 | 35 | |||
189642 | 101098 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1422 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5989556.7476 | 2103146.7648 | 37.7542385341752 | -122.479066801612 | (37.7542385341752, -122.479066801612) | 1 | 8 | 3 | 56 | 35 | |||
112857 | 101100 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5989483.3887 | 2103142.2154 | 37.7542217822618 | -122.479320159356 | (37.7542217822618, -122.479320159356) | 1 | 8 | 3 | 56 | 35 | |||
113561 | 101101 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989527 | 2103139 | 37.7542154865121 | -122.479169107121 | (37.7542154865121, -122.479169107121) | 1 | 8 | 3 | 56 | 35 | ||||
137591 | 101102 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5989444.1502 | 2103141.6467 | 37.7542179416811 | -122.479455812722 | (37.7542179416811, -122.479455812722) | 1 | 8 | 3 | 56 | 35 | |||
131386 | 101103 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1516 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5989287.5149 | 2103137.0833 | 37.7541963124281 | -122.479997156441 | (37.7541963124281, -122.479997156441) | 1 | 8 | 3 | 56 | 35 | |||
178802 | 101105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1642 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988844.2998 | 2103124.2167 | 37.7541352231255 | -122.481528943789 | (37.7541352231255, -122.481528943789) | 1 | 8 | 3 | 56 | 35 | |||
71864 | 101106 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1650 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 14066 | 5988798.3084 | 2103123.6691 | 37.7541310452569 | -122.481687951334 | (37.7541310452569, -122.481687951334) | 1 | 8 | 3 | 56 | 35 | ||
67833 | 101110 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1700 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5988671.0107 | 2103117.3727 | 37.7541063538101 | -122.482127711453 | (37.7541063538101, -122.482127711453) | 1 | 8 | 3 | 56 | 35 | |||
167321 | 101111 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1728 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 5988603.6661 | 2103114.0876 | 37.7540934165996 | -122.482360362023 | (37.7540934165996, -122.482360362023) | 1 | 8 | 3 | 56 | 35 | |||
28604 | 101112 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1611 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988946.0821 | 2103051.1539 | 37.7539405298718 | -122.481171610101 | (37.7539405298718, -122.481171610101) | 1 | 8 | 3 | 56 | 35 | |||
136246 | 101113 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1443 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5989445.324 | 2103065.4711 | 37.7540088519424 | -122.479446180731 | (37.7540088519424, -122.479446180731) | 1 | 8 | 3 | 56 | 35 | |||
145490 | 101114 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1443 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989504.1745 | 2103066.6722 | 37.7540155679702 | -122.479242751781 | (37.7540155679702, -122.479242751781) | 1 | 8 | 3 | 56 | 35 | |||
156545 | 101115 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1425 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5989531.7982 | 2103069.0742 | 37.7540237675288 | -122.479147399181 | (37.7540237675288, -122.479147399181) | 1 | 8 | 3 | 56 | 35 | |||
131294 | 101116 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 17026 | 5989636.2879 | 2103075.0794 | 37.7540463239751 | -122.478786491943 | (37.7540463239751, -122.478786491943) | 1 | 8 | 3 | 56 | 35 | |||
150639 | 101117 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17026 | 5989684 | 2103075 | 37.7540488762587 | -122.478621488038 | (37.7540488762587, -122.478621488038) | 1 | 8 | 3 | 56 | 35 | ||||
21049 | 101118 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1239 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 17026 | 5990136.9434 | 2103098.5473 | 37.7541398185385 | -122.477056838029 | (37.7541398185385, -122.477056838029) | 1 | 8 | 3 | 56 | 35 | |||
160930 | 101119 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17026 | 5989684 | 2103075 | 37.7540488762587 | -122.478621488038 | (37.7540488762587, -122.478621488038) | 1 | 8 | 3 | 56 | 35 | ||||
153758 | 101120 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201x Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17026 | 5990269 | 2103025 | 37.7539455374003 | -122.476594786081 | (37.7539455374003, -122.476594786081) | 1 | 8 | 3 | 56 | 35 | ||||
116755 | 101121 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17026 | 5990311.7 | 2103111.6 | 37.7541857946529 | -122.476453446723 | (37.7541857946529, -122.476453446723) | 1 | 8 | 3 | 56 | 35 | ||||
165030 | 101141 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 5x9 | 6011868.75409 | 2104860.94697 | 37.7602157776524 | -122.402026348736 | (37.7602157776524, -122.402026348736) | 10 | 3 | 8 | 28856 | 29 | |||
193097 | 101175 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994553 | 2106706 | 37.7643001590155 | -122.462046733301 | (37.7643001590155, -122.462046733301) | 11 | 5 | 11 | 56 | 12 | ||||
116798 | 101176 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994553 | 2106706 | 37.7643001590155 | -122.462046733301 | (37.7643001590155, -122.462046733301) | 11 | 5 | 11 | 56 | 12 | ||||
190244 | 101177 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 408 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994501 | 2106722 | 37.7643410968681 | -122.462227745791 | (37.7643410968681, -122.462227745791) | 11 | 5 | 11 | 56 | 12 | ||||
75766 | 101179 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295X 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994535.9 | 2106711.8 | 37.7643150997768 | -122.462106297592 | (37.7643150997768, -122.462106297592) | 11 | 5 | 11 | 56 | 12 | ||||
49236 | 101181 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 357 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994691 | 2106655 | 37.7641680705078 | -122.461565735882 | (37.7641680705078, -122.461565735882) | 15 | 5 | 11 | 56 | 12 | ||||
148878 | 101182 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 357 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994691 | 2106655 | 37.7641680705078 | -122.461565735882 | (37.7641680705078, -122.461565735882) | 15 | 5 | 11 | 56 | 12 | ||||
71833 | 101183 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 357 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994691 | 2106655 | 37.7641680705078 | -122.461565735882 | (37.7641680705078, -122.461565735882) | 15 | 5 | 11 | 56 | 12 | ||||
127346 | 101188 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994863 | 2106716 | 37.764345459457 | -122.460975263176 | (37.764345459457, -122.460975263176) | 15 | 5 | 11 | 56 | 12 | ||||
39994 | 101193 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 390X Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994589.6 | 2106699.6 | 37.7642846934182 | -122.461919681028 | (37.7642846934182, -122.461919681028) | 15 | 5 | 11 | 56 | 12 | ||||
143860 | 101194 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 390X Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994589.6 | 2106699.6 | 37.7642846934182 | -122.461919681028 | (37.7642846934182, -122.461919681028) | 15 | 5 | 11 | 56 | 12 | ||||
180623 | 101195 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 390X Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994589.6 | 2106699.6 | 37.7642846934182 | -122.461919681028 | (37.7642846934182, -122.461919681028) | 15 | 5 | 11 | 56 | 12 | ||||
182950 | 101196 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1290 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994636.2 | 2106777.6 | 37.7645015437864 | -122.461764161989 | (37.7645015437864, -122.461764161989) | 15 | 5 | 11 | 56 | 12 | ||||
110066 | 101197 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1290 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994636.2 | 2106777.6 | 37.7645015437864 | -122.461764161989 | (37.7645015437864, -122.461764161989) | 15 | 5 | 11 | 56 | 12 | ||||
183094 | 101198 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1290 05th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994636.2 | 2106777.6 | 37.7645015437864 | -122.461764161989 | (37.7645015437864, -122.461764161989) | 15 | 5 | 11 | 56 | 12 | ||||
106637 | 101435 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
127351 | 101436 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
34754 | 101438 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
161031 | 101439 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
155139 | 101440 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 5 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
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 | |||
116244 | 101592 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
172431 | 101593 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
108285 | 101594 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
186178 | 101595 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
115783 | 101597 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
65721 | 101600 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
183119 | 10166 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1020 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2013 12:00:00 AM | 70 | 2X3 | Permit Number 769235 | 6005686.7184724 | 2103018.6198444 | 37.7548102005351 | -122.423276153382 | (37.7548102005351, -122.423276153382) | 2 | 4 | 5 | 28859 | 19 | |
34398 | 101661 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
155486 | 101663 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
1667 | 101664 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
23325 | 101665 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
24264 | 101666 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
49204 | 101667 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
170223 | 101668 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
91941 | 101670 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
182819 | 101671 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
159813 | 101674 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
12499 | 101675 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
141854 | 101676 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
154015 | 101680 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992417.5 | 2095390.1 | 37.7331064279943 | -122.46860934798 | (37.7331064279943, -122.46860934798) | 9 | 8 | 4 | 59 | 40 | ||||
93422 | 101681 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X San Leandro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992417.5 | 2095390.1 | 37.7331064279943 | -122.46860934798 | (37.7331064279943, -122.46860934798) | 9 | 8 | 4 | 59 | 40 | ||||
97867 | 101686 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3701 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5997129.96175 | 2115018.98612 | 37.7872734813453 | -122.453734130627 | (37.7872734813453, -122.453734130627) | 11 | 6 | 1 | 54 | 31 | ||||
150579 | 101687 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 415X Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5997168 | 2115063 | 37.7873965123886 | -122.45360570636 | (37.7873965123886, -122.45360570636) | 11 | 6 | 1 | 54 | 31 | ||||
152840 | 101688 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 415X Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5997168 | 2115063 | 37.7873965123886 | -122.45360570636 | (37.7873965123886, -122.45360570636) | 11 | 6 | 1 | 54 | 31 | ||||
100536 | 101689 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 415X Spruce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5997168 | 2115063 | 37.7873965123886 | -122.45360570636 | (37.7873965123886, -122.45360570636) | 11 | 6 | 1 | 54 | 31 | ||||
174842 | 101690 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 415X Spruce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997168 | 2115063 | 37.7873965123886 | -122.45360570636 | (37.7873965123886, -122.45360570636) | 11 | 6 | 1 | 54 | 31 | ||||
188134 | 101734 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 350 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010571.05211 | 2091409.50467 | 37.7232085054565 | -122.405567095662 | (37.7232085054565, -122.405567095662) | 10 | 3 | 7 | 309 | 28 | |||
24665 | 101842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
182393 | 101843 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
54121 | 101901 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Ocean Ave | 2 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
106378 | 101972 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5998294 | 2107899 | 37.7677905087949 | -122.449193680863 | (37.7677905087949, -122.449193680863) | 15 | 5 | 11 | 29492 | 9 |
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) );