Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27862 | 27862 | 194050 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2246 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 6ft | 6012135.46921 | 2099441.05415 | 37.7453488151107 | -122.400723136672 | (37.7453488151107, -122.400723136672) | |||
| 29571 | 29571 | 194075 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 30 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | 6011495.74471 | 2097425.71535 | 37.739779425186704 | -122.402793501934 | (37.7397794251867, -122.402793501934) | ||||
| 34540 | 34540 | 177827 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 10 Brotherhood Way | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 0ft | 5993584.63921 | 2087685.0546799998 | 37.712017594599295 | -122.46401514608 | (37.7120175945993, -122.46401514608) | |||
| 35354 | 35354 | 194072 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2280 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | 6011322.76778 | 2098041.04793 | 37.7414593371741 | -122.40343486513399 | (37.7414593371741, -122.403434865134) | ||||
| 35770 | 35770 | 194078 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 551 Barneveld Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011051.92232 | 2097388.39433 | 37.7396521585296 | -122.404325434065 | (37.7396521585296, -122.404325434065) | |||
| 36721 | 36721 | 210535 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700 Junipero Serra Blvd | 57 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991233.67359 | 2092413.03561 | 37.7248636977911 | -122.472485147273 | (37.7248636977911, -122.472485147273) | |||
| 39873 | 39873 | 210528 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 466 Bright St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 5993789.40568 | 2090279.07412 | 37.719151951468504 | -122.46349555378299 | (37.7191519514685, -122.463495553783) | |||
| 45905 | 45905 | 194094 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 411 Barneveld Ave | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011262.87795 | 2097995.57485 | 37.7413311325376 | -122.40363874593201 | (37.7413311325376, -122.403638745932) | |||
| 49015 | 49015 | 194093 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 411 Barneveld Ave | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011244.42324 | 2097965.17707 | 37.7412466358374 | -122.40370041785299 | (37.7412466358374, -122.403700417853) | |||
| 50586 | 50586 | 194041 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6011789.4196 | 2105194.80325 | 37.761128044544705 | -122.40232420509899 | (37.7611280445447, -122.402324205099) | |||
| 56709 | 56709 | 194068 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 599 Barneveld Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011049.44747 | 2097157.45063 | 37.7390178981683 | -122.404317740371 | (37.7390178981683, -122.404317740371) | |||
| 56871 | 56871 | 194048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1242 19th St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013830.06416 | 2105268.62635 | 37.761444447624 | -122.395271611894 | (37.761444447624, -122.395271611894) | |||
| 57948 | 57948 | 194077 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 551 Barneveld Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6011049.208459999 | 2097370.84853 | 37.7396038298609 | -122.404333582832 | (37.7396038298609, -122.404333582832) | |||
| 58582 | 58582 | 194070 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 41 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | 6011513.73296 | 2097374.29319 | 37.7396392352499 | -122.40272769043501 | (37.7396392352499, -122.402727690435) | ||||
| 63644 | 63644 | 194067 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 599 Barneveld Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011054.01039 | 2097116.70237 | 37.73890626712029 | -122.404299096539 | (37.7389062671203, -122.404299096539) | |||
| 65577 | 65577 | 194073 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2275 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | 6011416.20922 | 2097909.60407 | 37.741103639116 | -122.403102531469 | (37.741103639116, -122.403102531469) | ||||
| 65653 | 65653 | 194076 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 551 Barneveld Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011046.281909999 | 2097328.37169 | 37.7394870339983 | -122.404340712651 | (37.7394870339983, -122.404340712651) | |||
| 66078 | 66078 | 246816 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 186 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6010178.32327 | 2098854.3391299997 | 37.7436284695924 | -122.407449302058 | (37.7436284695924, -122.407449302058) | |||
| 70361 | 70361 | 177828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 10 Brotherhood Way | 6 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5993567.2586900005 | 2087687.58972 | 37.712023553524205 | -122.464075401566 | (37.7120235535242, -122.464075401566) | |||
| 71938 | 71938 | 194042 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6011788.47963 | 2105178.47145 | 37.761083148586394 | -122.402326307728 | (37.7610831485864, -122.402326307728) | |||
| 109421 | 109421 | 194074 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2235 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | 6011541.53422 | 2097819.64053 | 37.7408636163769 | -122.40266287538999 | (37.7408636163769, -122.40266287539) | ||||
| 130786 | 130786 | 194095 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 401 Barneveld Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011321.98821 | 2098077.1907900004 | 37.741558534187206 | -122.403440102771 | (37.7415585341872, -122.403440102771) | |||
| 132855 | 132855 | 194096 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 401 Barneveld Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011333.74765 | 2098094.50677 | 37.7416067369731 | -122.403400660313 | (37.7416067369731, -122.403400660313) | |||
| 133482 | 133482 | 232403 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3977 22nd St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 8ft | 6001960.85303 | 2102925.1671599997 | 37.754342622815706 | -122.43615451782301 | (37.7543426228157, -122.436154517823) | |||
| 148527 | 148527 | 210534 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2523 Ocean Ave | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5991267.17989 | 2094746.77146 | 37.731273492456495 | -122.472539386291 | (37.7312734924565, -122.472539386291) | |||
| 149784 | 149784 | 210526 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 347 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5993225.43115 | 2089502.49868 | 37.7169871520095 | -122.46538860062999 | (37.7169871520095, -122.46538860063) | |||
| 155753 | 155753 | 194045 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013807.05349 | 2105290.79153 | 37.7615040286026 | -122.395352749639 | (37.7615040286026, -122.395352749639) | |||
| 162087 | 162087 | 194065 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011662.94046 | 2097957.49597 | 37.7412489156133 | -122.40225278546002 | (37.7412489156133, -122.40225278546) | |||
| 162240 | 162240 | 194092 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 411 Barneveld Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6011234.12754 | 2097948.45103 | 37.741200134566704 | -122.403734840308 | (37.7412001345667, -122.403734840308) | |||
| 163421 | 163421 | 194046 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 2 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6013804.04007 | 2105323.21797 | 37.761592896918394 | -122.395365443572 | (37.7615928969184, -122.395365443572) | |||
| 168102 | 168102 | 194069 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 599 Barneveld Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011047.778940001 | 2097176.40588 | 37.7390698519997 | -122.40432484322201 | (37.7390698519997, -122.404324843222) | |||
| 170902 | 170902 | 210533 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2645 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5990808.42077 | 2095014.9868299998 | 37.731983379510496 | -122.474144946842 | (37.7319833795105, -122.474144946842) | |||
| 171896 | 171896 | 194066 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011686.01076 | 2097941.04754 | 37.741205039484 | -122.40217185994 | (37.741205039484, -122.40217185994) | |||
| 177007 | 177007 | 194040 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6011787.18264 | 2105219.37542 | 37.7611953893822 | -122.402333669585 | (37.7611953893822, -122.402333669585) | |||
| 177255 | 177255 | 210529 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 233 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5993351.020380001 | 2090459.95557 | 37.7196233401215 | -122.465024001983 | (37.7196233401215, -122.465024001983) | |||
| 178015 | 178015 | 210527 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 491 Bright St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5993759.26647 | 2090422.7728900001 | 37.7195447771444 | -122.463610156198 | (37.7195447771444, -122.463610156198) | |||
| 178554 | 178554 | 177808 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Melra Ct | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 4ft | 6008994.91617 | 2086485.2732900002 | 37.709599327506794 | -122.410667934296 | (37.7095993275068, -122.410667934296) | |||
| 181266 | 181266 | 194071 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2260 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | 6011443.9729 | 2097950.47892 | 37.7412174231363 | -122.403009408459 | (37.7412174231363, -122.403009408459) | ||||
| 183762 | 183762 | 232287 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 Webster St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6004240.14437 | 2109135.1756700003 | 37.7715230535659 | -122.42871480966801 | (37.7715230535659, -122.428714809668) | |||
| 2475 | 2475 | 213240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 72 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 11/24/1982 12:00:00 AM | 14 | Width 3ft | Permit Number 20046 | 5997197.846969999 | 2089560.74227 | 37.7173753740534 | -122.451662146612 | (37.7173753740534, -122.451662146612) | |
| 23570 | 23570 | 250043 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006138.25466 | 2114733.68143 | 37.787002430166396 | -122.422547022523 | (37.7870024301664, -122.422547022523) | |||
| 23879 | 23879 | 193824 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1550 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 6ft | 6015655.00087 | 2098203.32161 | 37.742145929985796 | -122.388466689285 | (37.7421459299858, -122.388466689285) | |||
| 24013 | 24013 | 232628 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Starview Way | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997489.976480001 | 2102197.32823 | 37.7520891340271 | -122.451563373145 | (37.7520891340271, -122.451563373145) | |||
| 24261 | 24261 | 250049 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005972.08253 | 2114712.11265 | 37.7869338316717 | -122.42312040780199 | (37.7869338316717, -122.423120407802) | |||
| 26224 | 26224 | 177707 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5994471.04103 | 2086660.75611 | 37.709256157011794 | -122.46087732063499 | (37.7092561570118, -122.460877320635) | |||
| 27020 | 27020 | 193809 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 283 Texas St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013777.6703699995 | 2105799.42073 | 37.762898978733894 | -122.395490009551 | (37.7628989787339, -122.395490009551) | |||
| 27082 | 27082 | 193812 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 596 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6014080.0948 | 2104357.2434 | 37.75895589042771 | -122.39434303940399 | (37.7589558904277, -122.394343039404) | |||
| 27095 | 27095 | 250526 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 26th Ave | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 5987725.00409 | 2115456.85695 | 37.787932075559794 | -122.48630503096001 | (37.7879320755598, -122.48630503096) | |||
| 29228 | 29228 | 213269 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 58 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992208.01745 | 2088290.25795 | 37.7135999031885 | -122.468817113946 | (37.7135999031885, -122.468817113946) | |||
| 29466 | 29466 | 250525 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 26th Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 5987725.71266 | 2115440.30097 | 37.7878866588866 | -122.486301363544 | (37.7878866588866, -122.486301363544) | |||
| 29586 | 29586 | 250335 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 123 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5987383.88616 | 2115115.01872 | 37.7869735978985 | -122.487460101328 | (37.7869735978985, -122.487460101328) | |||
| 29852 | 29852 | 193773 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1509 11th St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008828.72 | 2108671.3355799997 | 37.7705080832089 | -122.41280982261001 | (37.7705080832089, -122.41280982261) | |||
| 30043 | 30043 | 193801 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 776 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012701.04475 | 2103917.58098 | 37.7576719193319 | -122.39908161224899 | (37.7576719193319, -122.399081612249) | |||
| 32888 | 32888 | 247667 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 140 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6001942.4727 | 2108474.82716 | 37.769579593462204 | -122.436615292671 | (37.7695795934622, -122.436615292671) | |||
| 33415 | 33415 | 213249 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 28 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5991688.58808 | 2088978.22145 | 37.715458861213705 | -122.47066251018299 | (37.7154588612137, -122.470662510183) | |||
| 33515 | 33515 | 213247 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2950 San Jose Ave | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 5996077.12469 | 2087544.08394 | 37.711773854049895 | -122.455390272656 | (37.7117738540499, -122.455390272656) | |||
| 33743 | 33743 | 213275 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 7 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991009.60744 | 2091179.22643 | 37.7214629924139 | -122.473169770586 | (37.7214629924139, -122.473169770586) | |||
| 33798 | 33798 | 213266 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 128 Shields St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5993574.68997 | 2089852.4387 | 37.717968139684295 | -122.46420678172701 | (37.7179681396843, -122.464206781727) | |||
| 34045 | 34045 | 250047 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6006014.39552 | 2114717.8683700003 | 37.7869520231531 | -122.422974423547 | (37.7869520231531, -122.422974423547) | |||
| 37034 | 37034 | 247765 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 35 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6001639.70986 | 2108538.3292900003 | 37.7697367445938 | -122.437667084867 | (37.7697367445938, -122.437667084867) | |||
| 37769 | 37769 | 213250 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 28 Monticello St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 5991690.070830001 | 2089001.8026299998 | 37.715523695140796 | -122.470659101751 | (37.7155236951408, -122.470659101751) | |||
| 38185 | 38185 | 250050 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 9 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005954.34563 | 2114709.51335 | 37.7869256936999 | -122.42318158867799 | (37.7869256936999, -122.423181588678) | |||
| 38418 | 38418 | 193845 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1799 Quint St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6012499.084 | 2095587.88903 | 37.7347891105367 | -122.399195382759 | (37.7347891105367, -122.399195382759) | |||
| 38612 | 38612 | 232630 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 430 Panorama Dr | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5997438.14757 | 2102228.89823 | 37.752172849216706 | -122.451744881537 | (37.7521728492167, -122.451744881537) | |||
| 39117 | 39117 | 213259 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 238 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5992216.5421400005 | 2089457.76515 | 37.7168060879127 | -122.468872558029 | (37.7168060879127, -122.468872558029) | |||
| 39745 | 39745 | 213248 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2950 San Jose Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5996050.31606 | 2087518.48106 | 37.7117020161965 | -122.455481080804 | (37.7117020161965, -122.455481080804) | |||
| 40044 | 40044 | 213258 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 Byxbee St | 6 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5991914.34073 | 2088658.3813 | 37.7145937097982 | -122.469858942549 | (37.7145937097982, -122.469858942549) | |||
| 41132 | 41132 | 250987 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Alta Mar Way | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5981462.395930001 | 2112758.2483099997 | 37.7801554921306 | -122.507771798739 | (37.7801554921306, -122.507771798739) | |||
| 43106 | 43106 | 213238 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 19 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5997429.8126300005 | 2089820.35199 | 37.7181014839665 | -122.45087906193899 | (37.7181014839665, -122.450879061939) | |||
| 43224 | 43224 | 193828 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 7ft | 6015597.83244 | 2098381.88934 | 37.742633072066496 | -122.388676823979 | (37.7426330720665, -122.388676823979) | |||
| 43874 | 43874 | 213243 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 136 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5996957.88538 | 2089198.3009 | 37.7163664489387 | -122.45246543725 | (37.7163664489387, -122.45246543725) | |||
| 44894 | 44894 | 193798 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 770 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6011814.33557 | 2104793.1433599996 | 37.7600265665852 | -122.402209790662 | (37.7600265665852, -122.402209790662) | |||
| 45106 | 45106 | 193815 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1301 Cesar Chavez St | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6015101.59724 | 2101035.90572 | 37.7498929329134 | -122.39057808971901 | (37.7498929329134, -122.390578089719) | |||
| 45218 | 45218 | 250986 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 185 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 5980980.82201 | 2112923.78682 | 37.7805816277787 | -122.50945005058 | (37.7805816277787, -122.50945005058) | |||
| 45924 | 45924 | 213274 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 6 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5990949.99995 | 2091167.07364 | 37.721426172366904 | -122.47337492930401 | (37.7214261723669, -122.473374929304) | |||
| 47599 | 47599 | 193772 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1509 11th St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008849.49911 | 2108690.5122 | 37.770561904027 | -122.412739303188 | (37.770561904027, -122.412739303188) | |||
| 47916 | 47916 | 250455 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200 Seacliff Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5987146.00356 | 2115751.2233 | 37.7887065564079 | -122.48832988241101 | (37.7887065564079, -122.488329882411) | |||
| 47958 | 47958 | 251007 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5981218.41729 | 2112709.81742 | 37.7800081381925 | -122.508612220583 | (37.7800081381925, -122.508612220583) | |||
| 48640 | 48640 | 213254 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 Byxbee St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5991915.47279 | 2088758.9984 | 37.7148700453991 | -122.46986235098801 | (37.7148700453991, -122.469862350988) | |||
| 48760 | 48760 | 213261 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 255 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992959.15066 | 2088902.16567 | 37.7153234215169 | -122.46626539193899 | (37.7153234215169, -122.466265391939) | |||
| 49339 | 49339 | 250483 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 475 Seacliff Ave | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5986409.292859999 | 2115158.05614 | 37.787034880407205 | -122.490835095073 | (37.7870348804072, -122.490835095073) | |||
| 49831 | 49831 | 213233 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Geneva Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5997185.51842 | 2091545.7549299998 | 37.722825048916604 | -122.451847881795 | (37.7228250489166, -122.451847881795) | |||
| 55273 | 55273 | 250478 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 475 Seacliff Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5986370.30078 | 2115143.81022 | 37.78699348730329 | -122.49096894838199 | (37.7869934873033, -122.490968948382) | |||
| 55640 | 55640 | 218301 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8 Ardenwood Way | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5991277.5541199995 | 2096357.6293400002 | 37.735697102027004 | -122.47262092332501 | (37.735697102027, -122.472620923325) | |||
| 56174 | 56174 | 213272 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5990724.99809 | 2091116.6908599997 | 37.721274802066205 | -122.474149016276 | (37.7212748020662, -122.474149016276) | |||
| 56305 | 56305 | 193807 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Madera St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012906.51171 | 2103239.7601099997 | 37.7558222189243 | -122.39832346128 | (37.7558222189243, -122.39832346128) | |||
| 57980 | 57980 | 232626 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Starview Way | 1 | : 4 | Tree 1 | Private 1 | 29 | Width 3ft | 5997477.384980001 | 2102222.75645 | 37.7521582325312 | -122.45160875024901 | (37.7521582325312, -122.451608750249) | |||
| 59180 | 59180 | 213271 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 68 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5990888.94102 | 2094543.24113 | 37.730692748968 | -122.47383217074601 | (37.730692748968, -122.473832170746) | |||
| 60931 | 60931 | 213241 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 73 Majestic Ave | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5997231.99514 | 2089535.73549 | 37.71730866684079 | -122.45154231013201 | (37.7173086668408, -122.451542310132) | |||
| 62944 | 62944 | 250482 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 475 Seacliff Ave | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5986400.2603 | 2115155.17733 | 37.7870264483565 | -122.49086613336901 | (37.7870264483565, -122.490866133369) | |||
| 63140 | 63140 | 193805 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Madera St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6012865.419840001 | 2103240.5937900003 | 37.7558222189454 | -122.39846562969801 | (37.7558222189454, -122.398465629698) | |||
| 63217 | 63217 | 193823 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1550 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 6ft | 6015666.23055 | 2098193.52595 | 37.7421196554058 | -122.388427176666 | (37.7421196554058, -122.388427176666) | |||
| 64681 | 64681 | 177708 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994462.16701 | 2086650.7454 | 37.7092281593337 | -122.460907265375 | (37.7092281593337, -122.460907265375) | |||
| 65183 | 65183 | 250481 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 475 Seacliff Ave | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5986391.51376 | 2115152.57183 | 37.787018783437205 | -122.490896202225 | (37.7870187834372, -122.490896202225) | |||
| 65263 | 65263 | 213267 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 501 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992669.53864 | 2089173.0846900002 | 37.7160505854524 | -122.467286097274 | (37.7160505854524, -122.467286097274) | |||
| 66860 | 66860 | 246934 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 327 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 6ft | 5998433.91472 | 2107557.60959 | 37.7668611389688 | -122.448685143299 | (37.7668611389688, -122.448685143299) | |||
| 67279 | 67279 | 193841 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 9 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011580.56119 | 2099671.3344 | 37.745950149498206 | -122.40265811977801 | (37.7459501494982, -122.402658119778) | |||
| 67529 | 67529 | 193827 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Phelps St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 6ft | 6015556.710659999 | 2098326.08175 | 37.7424775567988 | -122.38881511721901 | (37.7424775567988, -122.388815117219) | |||
| 67696 | 67696 | 250048 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005996.49093 | 2114715.62099 | 37.7869448420797 | -122.423036209646 | (37.7869448420797, -122.423036209646) | |||
| 67879 | 67879 | 177706 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994482.436290001 | 2086673.39058 | 37.709291503981795 | -122.46083885215499 | (37.7092915039818, -122.460838852155) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");