trees
8,758 rows where qSpecies_id = 16 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130252 | 247667 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 140 Divisadero St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6001942.4727 | 2108474.82716 | 37.7695795934622 | -122.436615292671 | (37.7695795934622, -122.436615292671) | 15 | 5 | 5 | 29492 | 9 | |||
134096 | 193799 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 776 Rhode Island St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6011815.17202 | 2104757.26095 | 37.7599280881417 | -122.402204374956 | (37.7599280881417, -122.402204374956) | 10 | 3 | 8 | 28856 | 29 | |||
134792 | 193824 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Fairfax Ave | 3 | : | Tree | Private 2 | 14 | Width 6ft | 6015655.00087 | 2098203.32161 | 37.7421459299858 | -122.388466689285 | (37.7421459299858, -122.388466689285) | 10 | 3 | 8 | 58 | 1 | |||
134838 | 250994 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 463 44th Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5982196.35208 | 2112719.64417 | 37.7800927104493 | -122.505229891073 | (37.7800927104493, -122.505229891073) | 11 | 6 | 2 | 55 | 26 | |||
139824 | 213262 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 258 Ramsell St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5992991.07499 | 2088923.87767 | 37.7153848793724 | -122.466156625225 | (37.7153848793724, -122.466156625225) | 9 | 8 | 6 | 64 | 24 | |||
140245 | 177710 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5994442.40126 | 2086628.41328 | 37.7091657032093 | -122.460973960888 | (37.7091657032093, -122.460973960888) | 9 | 8 | 6 | 28861 | 25 | |||
142236 | 193848 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 78 Robblee Ave | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6012400.07716 | 2095850.27748 | 37.7355040562528 | -122.399556101736 | (37.7355040562528, -122.399556101736) | 10 | 3 | 8 | 58 | 1 | |||
142882 | 213272 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 3 | : | Tree | Private 2 | 4 | Width 0ft | 5990724.99809 | 2091116.69086 | 37.7212748020662 | -122.474149016276 | (37.7212748020662, -122.474149016276) | 9 | 8 | 4 | 64 | 40 | |||
143410 | 250039 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 Daniel Burnham Ct | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6006219.93247 | 2114745.11482 | 37.7870384309268 | -122.42226524787 | (37.7870384309268, -122.42226524787) | 13 | 9 | 1 | 28858 | 41 | |||
143716 | 193838 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6011570.05157 | 2099605.03725 | 37.7457675250463 | -122.402689799314 | (37.7457675250463, -122.402689799314) | 10 | 3 | 8 | 58 | 1 | |||
144897 | 193833 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6011558.06967 | 2099515.95149 | 37.7455222457662 | -122.4027249673 | (37.7455222457662, -122.4027249673) | 10 | 3 | 8 | 58 | 1 | |||
145875 | 247765 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 35 Alpine Ter | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6001639.70986 | 2108538.32929 | 37.7697367445938 | -122.437667084867 | (37.7697367445938, -122.437667084867) | 15 | 5 | 5 | 29492 | 9 | |||
147316 | 213246 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 117 Majestic Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5997038.83695 | 2089260.60213 | 37.7165421512897 | -122.45219012327 | (37.7165421512897, -122.45219012327) | 9 | 8 | 6 | 28861 | 24 | |||
149676 | 213237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Majestic Ave | 1 | : | Tree | Private 2 | 21 | Width 3ft | 5997483.43481 | 2089893.95191 | 37.7183066418059 | -122.450699017642 | (37.7183066418059, -122.450699017642) | 9 | 8 | 6 | 28861 | 24 | |||
150681 | 193815 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1301 Cesar Chavez St | 8 | : | Tree | Private 2 | 2 | Width 2ft | 6015101.59724 | 2101035.90572 | 37.7498929329134 | -122.390578089719 | (37.7498929329134, -122.390578089719) | 10 | 3 | 8 | 58 | 1 | |||
151145 | 193839 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6011572.75268 | 2099621.60996 | 37.7458131809443 | -122.402681624471 | (37.7458131809443, -122.402681624471) | 10 | 3 | 8 | 58 | 1 | |||
152146 | 213268 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 511 Sargent St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5992622.15954 | 2089173.70026 | 37.7160495404397 | -122.467449905201 | (37.7160495404397, -122.467449905201) | 9 | 8 | 6 | 64 | 24 | |||
152260 | 193836 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6011563.86564 | 2099569.70024 | 37.745670151857 | -122.402708704842 | (37.745670151857, -122.402708704842) | 10 | 3 | 8 | 58 | 1 | |||
153746 | 250050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 9 | : | Tree | Private 2 | 11 | Width 3ft | 6005954.34563 | 2114709.51335 | 37.7869256936999 | -122.423181588678 | (37.7869256936999, -122.423181588678) | 13 | 9 | 1 | 28858 | 41 | |||
156572 | 232632 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 59 Saint Germain Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5998265.10599 | 2104149.08154 | 37.7574925234868 | -122.449023456563 | (37.7574925234868, -122.449023456563) | 15 | 5 | 4 | 28862 | 38 | |||
158746 | 250979 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 66 Seal Rock Dr | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5981557.10695 | 2112990.72061 | 37.7807993716359 | -122.50746140944 | (37.7807993716359, -122.50746140944) | 11 | 6 | 2 | 55 | 15 | |||
158752 | 193831 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 351 Cargo Way | 17 | : | Tree | Private 2 | 8 | Width 3ft | 6017496.31387 | 2098500.41004 | 37.7430635397576 | -122.382120602585 | (37.7430635397576, -122.382120602585) | 10 | 3 | 8 | 58 | 1 | |||
159799 | 193825 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Fairfax Ave | 6 | : | Tree | Private 2 | 15 | Width 6ft | 6015596.67696 | 2098247.43003 | 37.7422638104273 | -122.388671435242 | (37.7422638104273, -122.388671435242) | 10 | 3 | 8 | 58 | 1 | |||
159922 | 213274 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 6 | : | Tree | Private 2 | 10 | Width 0ft | 5990949.99995 | 2091167.07364 | 37.7214261723669 | -122.473374929304 | (37.7214261723669, -122.473374929304) | 9 | 8 | 4 | 64 | 40 | |||
160262 | 193846 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 43 Robblee Ave | 1 | : | Tree | Private 2 | 21 | Width 3ft | 6012543.04402 | 2095896.68975 | 37.7356394626972 | -122.399065064718 | (37.7356394626972, -122.399065064718) | 10 | 3 | 8 | 58 | 1 | |||
160309 | 193835 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6011562.1176 | 2099553.35249 | 37.7456251668608 | -122.402713599879 | (37.7456251668608, -122.402713599879) | 10 | 3 | 8 | 58 | 1 | |||
160398 | 213259 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 238 Ralston St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5992216.54214 | 2089457.76515 | 37.7168060879127 | -122.468872558029 | (37.7168060879127, -122.468872558029) | 9 | 8 | 6 | 64 | 24 | |||
163003 | 213241 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 73 Majestic Ave | 2 | : | Tree | Private 2 | 15 | Width 3ft | 5997231.99514 | 2089535.73549 | 37.7173086668408 | -122.451542310132 | (37.7173086668408, -122.451542310132) | 9 | 8 | 6 | 28861 | 24 | |||
163359 | 193847 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 28 Robblee Ave | 1 | : | Tree | Private 2 | 19 | Width 3ft | 6012579.2172 | 2095957.17903 | 37.7358075693637 | -122.398944243498 | (37.7358075693637, -122.398944243498) | 10 | 3 | 8 | 58 | 1 | |||
163708 | 193843 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2077 Thomas Ave | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6012292.10089 | 2095744.5048 | 37.7352076073321 | -122.399921993617 | (37.7352076073321, -122.399921993617) | 10 | 3 | 8 | 58 | 1 | |||
164142 | 250047 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 6 | : | Tree | Private 2 | 9 | Width 3ft | 6006014.39552 | 2114717.86837 | 37.7869520231531 | -122.422974423547 | (37.7869520231531, -122.422974423547) | 13 | 9 | 1 | 28858 | 41 | |||
164446 | 250525 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 26th Ave | 1 | : | Tree | Private 2 | 12 | Width 4ft | 5987725.71266 | 2115440.30097 | 37.7878866588866 | -122.486301363544 | (37.7878866588866, -122.486301363544) | 11 | 6 | 1 | 55 | 33 | |||
164767 | 193802 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 914 Wisconsin St | 2 | : | Tree | Private 2 | 14 | Width 5ft | 6012741.48748 | 2103182.61758 | 37.7556561240405 | -122.398890161848 | (37.7556561240405, -122.398890161848) | 10 | 3 | 8 | 28856 | 29 | |||
165011 | 250501 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 540 El Camino Del Mar | 4 | : | Tree | Private 2 | 5 | Width 3ft | 5986824.08944 | 2115367.06151 | 37.7876329718436 | -122.489415384816 | (37.7876329718436, -122.489415384816) | 11 | 6 | 1 | 55 | 33 | |||
165303 | 213270 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2611 Ocean Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5990925.11554 | 2094948.6608 | 37.7318080243187 | -122.47373667531 | (37.7318080243187, -122.47373667531) | 1 | 8 | 4 | 64 | 40 | |||
165673 | 193796 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 764 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6011810.70544 | 2104819.98611 | 37.7601000681883 | -122.402224232882 | (37.7601000681883, -122.402224232882) | 10 | 3 | 8 | 28856 | 29 | |||
167260 | 193850 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 Newhall St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6013757.72876 | 2094795.76851 | 37.7326841744313 | -122.394788325229 | (37.7326841744313, -122.394788325229) | 10 | 3 | 8 | 58 | 1 | |||
168916 | 232628 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Starview Way | 3 | : | Tree | Private 2 | 10 | Width 3ft | 5997489.97648 | 2102197.32823 | 37.7520891340271 | -122.451563373145 | (37.7520891340271, -122.451563373145) | 1 | 5 | 4 | 63 | 38 | |||
170006 | 213266 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 128 Shields St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 5993574.68997 | 2089852.4387 | 37.7179681396843 | -122.464206781727 | (37.7179681396843, -122.464206781727) | 9 | 8 | 6 | 64 | 24 | |||
172436 | 250500 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 540 El Camino Del Mar | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5986857.46811 | 2115377.35874 | 37.7876631935443 | -122.489300660099 | (37.7876631935443, -122.489300660099) | 11 | 6 | 1 | 55 | 33 | |||
173307 | 213244 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 133 Majestic Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5996980.9799 | 2089180.19297 | 37.7163180519044 | -122.452384305794 | (37.7163180519044, -122.452384305794) | 9 | 8 | 6 | 28861 | 24 | |||
174154 | 250334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 123 27th Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5987384.94959 | 2115132.32414 | 37.787021175632 | -122.487457693838 | (37.787021175632, -122.487457693838) | 11 | 6 | 1 | 55 | 33 | |||
176677 | 193826 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Phelps St | 1 | : | Tree | Private 2 | 8 | Width 6ft | 6015550.82711 | 2098317.66581 | 37.7424541222593 | -122.388834873553 | (37.7424541222593, -122.388834873553) | 10 | 3 | 8 | 58 | 1 | |||
177586 | 250335 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 123 27th Ave | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5987383.88616 | 2115115.01872 | 37.7869735978985 | -122.487460101328 | (37.7869735978985, -122.487460101328) | 11 | 6 | 1 | 55 | 33 | |||
178054 | 213247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2950 San Jose Ave | 1 | : | Tree | Private 2 | 16 | Width 3ft | 5996077.12469 | 2087544.08394 | 37.7117738540499 | -122.455390272656 | (37.7117738540499, -122.455390272656) | 9 | 8 | 6 | 28861 | 24 | |||
178737 | 213254 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 5991915.47279 | 2088758.9984 | 37.7148700453991 | -122.469862350988 | (37.7148700453991, -122.469862350988) | 9 | 8 | 6 | 64 | 24 | |||
181332 | 193837 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 5 | : | Tree | Private 2 | 1 | Width 3ft | 6011567.15169 | 2099585.96693 | 37.7457150001509 | -122.402698485856 | (37.7457150001509, -122.402698485856) | 10 | 3 | 8 | 58 | 1 | |||
181384 | 213255 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 3 | : | Tree | Private 2 | 15 | Width 3ft | 5991914.94594 | 2088733.972 | 37.7148012985192 | -122.469862350968 | (37.7148012985192, -122.469862350968) | 9 | 8 | 6 | 64 | 24 | |||
181657 | 193845 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1799 Quint St | 1 | : | Tree | Private 2 | 20 | Width 3ft | 6012499.084 | 2095587.88903 | 37.7347891105367 | -122.399195382759 | (37.7347891105367, -122.399195382759) | 10 | 3 | 8 | 58 | 1 | |||
184167 | 193800 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 928 Rhode Island St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6011853.36956 | 2104056.29499 | 37.758005522856 | -122.402022988864 | (37.758005522856, -122.402022988864) | 10 | 3 | 8 | 28856 | 29 | |||
184561 | 193853 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 258 Bridgeview Dr | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6012944.98621 | 2095306.66723 | 37.7340417739162 | -122.397634016692 | (37.7340417739162, -122.397634016692) | 10 | 3 | 8 | 58 | 1 | |||
186006 | 193823 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Fairfax Ave | 2 | : | Tree | Private 2 | 13 | Width 6ft | 6015666.23055 | 2098193.52595 | 37.7421196554058 | -122.388427176666 | (37.7421196554058, -122.388427176666) | 10 | 3 | 8 | 58 | 1 | |||
189032 | 213265 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 729 Shields St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5991983.73841 | 2089837.9291 | 37.7178364726652 | -122.469704899486 | (37.7178364726652, -122.469704899486) | 9 | 8 | 6 | 64 | 24 | |||
190223 | 218301 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8 Ardenwood Way | 1 | : | Tree | Private 2 | 7 | Width 2ft | 5991277.55412 | 2096357.62934 | 37.735697102027 | -122.472620923325 | (37.735697102027, -122.472620923325) | 1 | 8 | 4 | 29491 | 40 | |||
191491 | 232629 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Starview Way | 4 | : | Tree | Private 2 | 14 | Width 3ft | 5997494.11803 | 2102162.88078 | 37.7519947870451 | -122.451546566645 | (37.7519947870451, -122.451546566645) | 1 | 5 | 4 | 63 | 38 | |||
191913 | 177709 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5994451.68551 | 2086639.19983 | 37.7091958547847 | -122.460942654584 | (37.7091958547847, -122.460942654584) | 9 | 8 | 6 | 28861 | 25 | |||
192117 | 193821 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Phelps St | 2 | : | Tree | Private 2 | 15 | Width 3ft | 6015477.1577 | 2098231.99769 | 37.7422148117602 | -122.389083622404 | (37.7422148117602, -122.389083622404) | 10 | 3 | 8 | 58 | 1 | |||
192461 | 246429 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 476 Duncan St | 1 | : | Tree | Private 2 | 15 | Width 4ft | 6003446.58995 | 2099832.72905 | 37.7459358124929 | -122.430795790488 | (37.7459358124929, -122.430795790488) | 2 | 7 | 5 | 63 | 22 | |||
192739 | 250042 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6006158.68902 | 2114736.17368 | 37.7870104260474 | -122.422476501285 | (37.7870104260474, -122.422476501285) | 13 | 9 | 1 | 28858 | 41 | |||
193121 | 232627 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Starview Way | 2 | : | Tree | Private 2 | 13 | Width 3ft | 5997483.45824 | 2102211.01483 | 37.7521263407563 | -122.451586901227 | (37.7521263407563, -122.451586901227) | 1 | 5 | 4 | 63 | 38 | |||
193615 | 213240 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 72 Majestic Ave | 1 | : | Tree | Private 2 | 11/24/1982 12:00:00 AM | 14 | Width 3ft | Permit Number 20046 | 5997197.84697 | 2089560.74227 | 37.7173753740534 | -122.451662146612 | (37.7173753740534, -122.451662146612) | 9 | 8 | 6 | 28861 | 24 | |
194251 | 213250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 28 Monticello St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 5991690.07083 | 2089001.80263 | 37.7155236951408 | -122.470659101751 | (37.7155236951408, -122.470659101751) | 9 | 8 | 6 | 64 | 24 | |||
66427 | 248974 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 716 Goettingen St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010713 | 2091306 | 37.7229322393396 | -122.405069122237 | (37.7229322393396, -122.405069122237) | 10 | 3 | 7 | 309 | 28 | ||||
6828 | 131262 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2711 Union St | 2 | Front Yard : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 785082 | 6000010.78683 | 2118118.88771 | 37.7959497330364 | -122.443989935801 | (37.7959497330364, -122.443989935801) | 13 | 9 | 1 | 57 | 17 | ||
10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
72773 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2224 Baker St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||||
25668 | 177650 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Tocoloma Ave | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 5ft | 6012434.26652 | 2086449.48006 | 37.7096932805964 | -122.398778354552 | (37.7096932805964, -122.398778354552) | 10 | 3 | 8 | 309 | 1 | |||
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 | ||||
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 | ||||
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 | ||||
34550 | 231223 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 220 Coso Ave | 5 | Front Yard : Yard | Tree | Private 2 | 4 | 6007580.66688 | 2099526.66852 | 37.7453287970792 | -122.416479002612 | (37.7453287970792, -122.416479002612) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||||
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 | ||||
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 | ||||
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 | ||||
65621 | 193819 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Tulare St | 8 | Front Yard : Yard | Tree | Private 2 | 2 | 6015080.24684 | 2100323.56466 | 37.7479358093949 | -122.390602150165 | (37.7479358093949, -122.390602150165) | 3 | 8 | 58 | 1 | |||||
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 | ||||
70129 | 232774 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 23 Seward St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6001021.9889 | 2104218.53505 | 37.7578405116552 | -122.439494050427 | (37.7578405116552, -122.439494050427) | 2 | 4 | 5 | 28862 | 38 | |||
77614 | 177648 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Tocoloma Ave | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 5ft | 6012427.63047 | 2086427.74351 | 37.7096332265644 | -122.398799765591 | (37.7096332265644, -122.398799765591) | 10 | 3 | 8 | 309 | 1 | |||
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 | ||||
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 | |||||
112017 | 193817 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Tulare St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | 6015100.80126 | 2100307.8332 | 37.7478937543942 | -122.390529974205 | (37.7478937543942, -122.390529974205) | 3 | 8 | 58 | 1 | |||||
116729 | 193816 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Tulare St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6015118.62426 | 2100316.39595 | 37.7479182546422 | -122.390468940782 | (37.7479182546422, -122.390468940782) | 3 | 8 | 58 | 1 | |||||
124756 | 249935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Filbert St | 4 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011217.60626 | 2120022.59893 | 37.8018097658745 | -122.405346117856 | (37.8018097658745, -122.405346117856) | 3 | 1 | 10 | 308 | 23 | |||
125726 | 113380 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 63 Potomac St | 1 | Front Yard : Yard | Tree | Private 2 | 4x4 | Permit Number 776311 | 6003081 | 2108682.5 | 37.7702144463181 | -122.432692008068 | (37.7702144463181, -122.432692008068) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |||||
132636 | 249934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011220.75334 | 2120024.08669 | 37.8018140268525 | -122.405335332271 | (37.8018140268525, -122.405335332271) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||||
147624 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | 5 | 1 | 1 | 28858 | 32 | |||
147971 | 253973 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 2 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
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 | ||||
151194 | 201933 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 190 Boutwell St | 3 | Front Yard : Yard | Tree | Private 2 | 20 | Width 9ft | 6010622.81918 | 2095611.54962 | 37.7347493344117 | -122.405683976059 | (37.7347493344117, -122.405683976059) | 10 | 3 | 8 | 58 | 1 | |||
153173 | 177647 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Tocoloma Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Width 5ft | 6012423.94947 | 2086414.60679 | 37.7095969506192 | -122.398811566514 | (37.7095969506192, -122.398811566514) | 10 | 3 | 8 | 309 | 1 | |||
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 | |||||
155352 | 193775 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1040 Minnesota St | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 6015239.9483 | 2103736.7361 | 37.7573165153716 | -122.390288335332 | (37.7573165153716, -122.390288335332) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||||
163295 | 253972 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 1 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
170295 | 177649 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Tocoloma Ave | 3 | Front Yard : Yard | Tree | Private 2 | 8 | Width 5ft | 6012431.1901 | 2086436.64385 | 37.7096578634812 | -122.398788087022 | (37.7096578634812, -122.398788087022) | 10 | 3 | 8 | 309 | 1 | |||
174606 | 193818 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Tulare St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6015085.69798 | 2100310.3734 | 37.7478998913736 | -122.390582378571 | (37.7478998913736, -122.390582378571) | 3 | 8 | 58 | 1 |
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) );