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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2491 | 193810 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 285 Texas St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6013775.34661 | 2105819.12575 | 37.7629529551453 | -122.395499427275 | (37.7629529551453, -122.395499427275) | 14 | 3 | 8 | 28856 | 29 | |||
3999 | 213261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992959.15066 | 2088902.16567 | 37.7153234215169 | -122.466265391939 | (37.7153234215169, -122.466265391939) | 9 | 8 | 6 | 64 | 24 | |||
5620 | 250454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Seacliff Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5987161.73503 | 2115752.97281 | 37.7887122778945 | -122.488275583153 | (37.7887122778945, -122.488275583153) | 11 | 6 | 1 | 55 | 33 | |||
5672 | 250483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 6 | : | Tree | Private 2 | 7 | Width 2ft | 5986409.29286 | 2115158.05614 | 37.7870348804072 | -122.490835095073 | (37.7870348804072, -122.490835095073) | 11 | 6 | 1 | 55 | 33 | |||
5704 | 247050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 523 Valley St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6002490.03893 | 2099140.16558 | 37.7439799534136 | -122.434053911082 | (37.7439799534136, -122.434053911082) | 2 | 7 | 5 | 63 | 22 | |||
6975 | 213248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2950 San Jose Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5996050.31606 | 2087518.48106 | 37.7117020161965 | -122.455481080804 | (37.7117020161965, -122.455481080804) | 9 | 8 | 6 | 28861 | 24 | |||
7914 | 193840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 8 | : | Tree | Private 2 | 6 | Width 3ft | 6011575.20658 | 2099640.54229 | 37.7458653020467 | -122.402674470349 | (37.7458653020467, -122.402674470349) | 10 | 3 | 8 | 58 | 1 | |||
8797 | 213239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Majestic Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997415.57746 | 2089795.63137 | 37.7180327919586 | -122.450926484985 | (37.7180327919586, -122.450926484985) | 9 | 8 | 6 | 28861 | 24 | |||
10186 | 250045 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6006086.73506 | 2114727.88869 | 37.7869836181338 | -122.422724857187 | (37.7869836181338, -122.422724857187) | 13 | 9 | 1 | 28858 | 41 | |||
11650 | 213242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 116 Majestic Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5997026.98347 | 2089301.08259 | 37.7166526221889 | -122.452234013791 | (37.7166526221889, -122.452234013791) | 9 | 8 | 6 | 28861 | 24 | |||
18128 | 213232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Geneva Ave | 1 | : | Tree | Private 2 | 15 | Width 0ft | 5997159.34871 | 2091557.33009 | 37.7228553326789 | -122.451939179162 | (37.7228553326789, -122.451939179162) | 9 | 8 | 4 | 28861 | 24 | |||
21154 | 250480 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 3 | : | Tree | Private 2 | 7 | Width 2ft | 5986385.0033 | 2115149.63936 | 37.7870103513788 | -122.490918510779 | (37.7870103513788, -122.490918510779) | 11 | 6 | 1 | 55 | 33 | |||
21382 | 213233 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Geneva Ave | 2 | : | Tree | Private 2 | 13 | Width 0ft | 5997185.51842 | 2091545.75493 | 37.7228250489166 | -122.451847881795 | (37.7228250489166, -122.451847881795) | 9 | 8 | 4 | 28861 | 24 | |||
22764 | 250526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 26th Ave | 2 | : | Tree | Private 2 | 14 | Width 4ft | 5987725.00409 | 2115456.85695 | 37.7879320755598 | -122.48630503096 | (37.7879320755598, -122.48630503096) | 11 | 6 | 1 | 55 | 33 | |||
24055 | 177708 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 5994462.16701 | 2086650.7454 | 37.7092281593337 | -122.460907265375 | (37.7092281593337, -122.460907265375) | 9 | 8 | 6 | 28861 | 25 | |||
24092 | 193808 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 285 Texas St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6013779.37544 | 2105782.77884 | 37.7628533785923 | -122.395482946298 | (37.7628533785923, -122.395482946298) | 14 | 3 | 8 | 28856 | 29 | |||
24592 | 250049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 8 | : | Tree | Private 2 | 10 | Width 3ft | 6005972.08253 | 2114712.11265 | 37.7869338316717 | -122.423120407802 | (37.7869338316717, -122.423120407802) | 13 | 9 | 1 | 28858 | 41 | |||
26727 | 213267 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Sargent St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992669.53864 | 2089173.08469 | 37.7160505854524 | -122.467286097274 | (37.7160505854524, -122.467286097274) | 9 | 8 | 6 | 64 | 24 | |||
26856 | 193820 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Phelps St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6015466.67819 | 2098214.62302 | 37.7421665235731 | -122.389118644737 | (37.7421665235731, -122.389118644737) | 10 | 3 | 8 | 58 | 1 | |||
30978 | 193844 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2065 Thomas Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6012352.39283 | 2095671.77619 | 37.7350112709454 | -122.399708436121 | (37.7350112709454, -122.399708436121) | 10 | 3 | 8 | 58 | 1 | |||
33216 | 250048 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 7 | : | Tree | Private 2 | 9 | Width 3ft | 6005996.49093 | 2114715.62099 | 37.7869448420797 | -122.423036209646 | (37.7869448420797, -122.423036209646) | 13 | 9 | 1 | 28858 | 41 | |||
36770 | 251007 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 Point Lobos Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5981218.41729 | 2112709.81742 | 37.7800081381925 | -122.508612220583 | (37.7800081381925, -122.508612220583) | 11 | 6 | 2 | 55 | 26 | |||
36866 | 213275 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 7 | : | Tree | Private 2 | 7 | Width 0ft | 5991009.60744 | 2091179.22643 | 37.7214629924139 | -122.473169770586 | (37.7214629924139, -122.473169770586) | 9 | 8 | 4 | 64 | 40 | |||
38064 | 250040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 Daniel Burnham Ct | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6006198.948 | 2114743.14871 | 37.7870318487916 | -122.422337709814 | (37.7870318487916, -122.422337709814) | 13 | 9 | 1 | 28858 | 41 | |||
38251 | 250986 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 185 Seal Rock Dr | 1 | : | Tree | Private 2 | 16 | Width 3ft | 5980980.82201 | 2112923.78682 | 37.7805816277787 | -122.50945005058 | (37.7805816277787, -122.50945005058) | 11 | 6 | 2 | 55 | 26 | |||
38473 | 213276 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 8 | : | Tree | Private 2 | 6 | Width 0ft | 5991051.68263 | 2091187.7754 | 37.721488901863 | -122.473024952766 | (37.721488901863, -122.473024952766) | 9 | 8 | 4 | 64 | 40 | |||
39610 | 250046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6006034.57515 | 2114720.06869 | 37.7869592033491 | -122.422904762956 | (37.7869592033491, -122.422904762956) | 13 | 9 | 1 | 28858 | 41 | |||
41432 | 177712 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3597 Alemany Blvd | 2 | : | Tree | Private 2 | 18 | Width 3ft | 5993573.43523 | 2087465.73541 | 37.7114147502636 | -122.464037959205 | (37.7114147502636, -122.464037959205) | 9 | 8 | 4 | 64 | 24 | |||
42293 | 193797 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 770 Rhode Island St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011812.50717 | 2104805.91519 | 37.7600615331364 | -122.40221701222 | (37.7600615331364, -122.40221701222) | 10 | 3 | 8 | 28856 | 29 | |||
42530 | 246934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 327 Frederick St | 1 | : | Tree | Private 2 | 22 | Width 6ft | 5998433.91472 | 2107557.60959 | 37.7668611389688 | -122.448685143299 | (37.7668611389688, -122.448685143299) | 15 | 5 | 11 | 29492 | 9 | |||
44651 | 250479 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 2 | : | Tree | Private 2 | 7 | Width 2ft | 5986378.77885 | 2115146.97988 | 37.787002685577 | -122.490939849906 | (37.787002685577, -122.490939849906) | 11 | 6 | 1 | 55 | 33 | |||
46573 | 213243 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 136 Majestic Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5996957.88538 | 2089198.3009 | 37.7163664489387 | -122.45246543725 | (37.7163664489387, -122.45246543725) | 9 | 8 | 6 | 28861 | 24 | |||
47378 | 193804 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Madera St | 2 | : | Tree | Private 2 | 8 | Width 4ft | 6012840.88863 | 2103240.40337 | 37.755820329465 | -122.398550453757 | (37.755820329465, -122.398550453757) | 10 | 3 | 8 | 28856 | 29 | |||
47412 | 232630 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Panorama Dr | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5997438.14757 | 2102228.89823 | 37.7521728492167 | -122.451744881537 | (37.7521728492167, -122.451744881537) | 1 | 5 | 4 | 63 | 38 | |||
48132 | 250482 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 5 | : | Tree | Private 2 | 7 | Width 2ft | 5986400.2603 | 2115155.17733 | 37.7870264483565 | -122.490866133369 | (37.7870264483565, -122.490866133369) | 11 | 6 | 1 | 55 | 33 | |||
49009 | 213271 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 68 Rossmoor Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5990888.94102 | 2094543.24113 | 37.730692748968 | -122.473832170746 | (37.730692748968, -122.473832170746) | 9 | 8 | 4 | 64 | 40 | |||
49854 | 213260 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 247 Ramsell St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 5992958.0895 | 2088851.66693 | 37.715184702892 | -122.466265391946 | (37.715184702892, -122.466265391946) | 9 | 8 | 6 | 64 | 24 | |||
51155 | 213257 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 5 | : | Tree | Private 2 | 14 | Width 3ft | 5991914.21978 | 2088676.05712 | 37.7146422363243 | -122.469860646752 | (37.7146422363243, -122.469860646752) | 9 | 8 | 6 | 64 | 24 | |||
51605 | 250987 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Alta Mar Way | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5981462.39593 | 2112758.24831 | 37.7801554921306 | -122.507771798739 | (37.7801554921306, -122.507771798739) | 11 | 6 | 2 | 55 | 26 | |||
53886 | 193801 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 776 Wisconsin St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012701.04475 | 2103917.58098 | 37.7576719193319 | -122.399081612249 | (37.7576719193319, -122.399081612249) | 10 | 3 | 8 | 28856 | 29 | |||
54920 | 193822 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Fairfax Ave | 1 | : | Tree | Private 2 | 15 | Width 6ft | 6015679.27727 | 2098183.69362 | 37.7420933808115 | -122.388381378708 | (37.7420933808115, -122.388381378708) | 10 | 3 | 8 | 58 | 1 | |||
57734 | 193812 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 596 Mississippi St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 6014080.0948 | 2104357.2434 | 37.7589558904277 | -122.394343039404 | (37.7589558904277, -122.394343039404) | 10 | 3 | 8 | 28856 | 29 | |||
58568 | 193811 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Mississippi St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014111.79527 | 2104838.51392 | 37.7602791169064 | -122.394267098858 | (37.7602791169064, -122.394267098858) | 10 | 3 | 8 | 28856 | 29 | |||
60703 | 213249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 28 Monticello St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5991688.58808 | 2088978.22145 | 37.7154588612137 | -122.470662510183 | (37.7154588612137, -122.470662510183) | 9 | 8 | 6 | 64 | 24 | |||
61060 | 249932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Filbert St | 1 | : | Tree | Private 2 | 18 | Width 0ft | 6011228.49404 | 2120021.60131 | 37.8018076353832 | -122.405308370584 | (37.8018076353832, -122.405308370584) | 3 | 1 | 10 | 308 | 23 | |||
61517 | 246925 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 379 Frederick St | 1 | : | Tree | Private 2 | 20 | Width 5ft | 5998143.47338 | 2107513.56427 | 37.7667235894447 | -122.449686553707 | (37.7667235894447, -122.449686553707) | 15 | 5 | 11 | 29492 | 9 | |||
62460 | 246898 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 550 Frederick St | 5 | : | Tree | Private 2 | 3 | Width 3ft | 5996834.53091 | 2107389.94714 | 37.7663091953466 | -122.454205009359 | (37.7663091953466, -122.454205009359) | 15 | 5 | 11 | 29492 | 8 | |||
64339 | 177707 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 5994471.04103 | 2086660.75611 | 37.7092561570118 | -122.460877320635 | (37.7092561570118, -122.460877320635) | 9 | 8 | 6 | 28861 | 25 | |||
65002 | 232631 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Dellbrook Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997192.67269 | 2102776.36452 | 37.7536619934296 | -122.452633274131 | (37.7536619934296, -122.452633274131) | 1 | 5 | 4 | 63 | 38 | |||
65264 | 232626 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Starview Way | 1 | : | Tree | Private 2 | 29 | Width 3ft | 5997477.38498 | 2102222.75645 | 37.7521582325312 | -122.451608750249 | (37.7521582325312, -122.451608750249) | 1 | 5 | 4 | 63 | 38 | |||
65362 | 250041 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 Daniel Burnham Ct | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6006178.42994 | 2114740.45377 | 37.7870232917354 | -122.422408506263 | (37.7870232917354, -122.422408506263) | 13 | 9 | 1 | 28858 | 41 | |||
67627 | 250478 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 1 | : | Tree | Private 2 | 7 | Width 2ft | 5986370.30078 | 2115143.81022 | 37.7869934873033 | -122.490968948382 | (37.7869934873033, -122.490968948382) | 11 | 6 | 1 | 55 | 33 | |||
68461 | 193772 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1509 11th St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6008849.49911 | 2108690.5122 | 37.770561904027 | -122.412739303188 | (37.770561904027, -122.412739303188) | 8 | 2 | 9 | 28853 | 19 | |||
70003 | 177706 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 6 | : | Tree | Private 2 | 6 | Width 3ft | 5994482.43629 | 2086673.39058 | 37.7092915039818 | -122.460838852155 | (37.7092915039818, -122.460838852155) | 9 | 8 | 6 | 28861 | 25 | |||
70095 | 213245 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 129 Majestic Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5996996.8362 | 2089202.46926 | 37.7163801258292 | -122.45233110552 | (37.7163801258292, -122.45233110552) | 9 | 8 | 6 | 28861 | 24 | |||
72570 | 213258 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 6 | : | Tree | Private 2 | 14 | Width 3ft | 5991914.34073 | 2088658.3813 | 37.7145937097982 | -122.469858942549 | (37.7145937097982, -122.469858942549) | 9 | 8 | 6 | 64 | 24 | |||
72748 | 213238 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 Majestic Ave | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5997429.81263 | 2089820.35199 | 37.7181014839665 | -122.450879061939 | (37.7181014839665, -122.450879061939) | 9 | 8 | 6 | 28861 | 24 | |||
73200 | 213263 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Victoria St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993232.40294 | 2090201.31031 | 37.7189063223512 | -122.465415237623 | (37.7189063223512, -122.465415237623) | 9 | 8 | 6 | 64 | 24 | |||
77460 | 213236 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 342 Ridge Ln | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997503.88041 | 2089935.40142 | 37.7184216228495 | -122.450631332891 | (37.7184216228495, -122.450631332891) | 9 | 8 | 6 | 28861 | 24 | |||
78505 | 249572 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1001 Franklin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6006034.21434 | 2113636.62941 | 37.7839843260522 | -122.42282898339 | (37.7839843260522, -122.42282898339) | 7 | 9 | 11 | 28858 | 41 | |||
81148 | 193806 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Madera St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6012889.21828 | 2103238.73501 | 37.755818440888 | -122.39838319603 | (37.755818440888, -122.39838319603) | 10 | 3 | 8 | 28856 | 29 | |||
82952 | 213277 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 9 | : | Tree | Private 2 | 9 | Width 0ft | 5991091.24453 | 2091195.38436 | 37.7215120845989 | -122.472888754009 | (37.7215120845989, -122.472888754009) | 9 | 8 | 4 | 64 | 40 | |||
83947 | 250980 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 121 Seal Rock Dr | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5981282.80421 | 2112935.73296 | 37.7806322299407 | -122.508406256053 | (37.7806322299407, -122.508406256053) | 11 | 6 | 2 | 55 | 26 | |||
86384 | 193798 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 770 Rhode Island St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6011814.33557 | 2104793.14336 | 37.7600265665852 | -122.402209790662 | (37.7600265665852, -122.402209790662) | 10 | 3 | 8 | 28856 | 29 | |||
86440 | 246900 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 550 Frederick St | 7 | : | Tree | Private 2 | 5 | Width 3ft | 5996798.5349 | 2107384.00087 | 37.7662908041998 | -122.454329082515 | (37.7662908041998, -122.454329082515) | 15 | 5 | 11 | 29492 | 8 | |||
86442 | 213234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Geneva Ave | 3 | : | Tree | Private 2 | 10 | Width 0ft | 5997198.16874 | 2091539.55227 | 37.7228087424092 | -122.451803705299 | (37.7228087424092, -122.451803705299) | 9 | 8 | 4 | 28861 | 24 | |||
87314 | 177705 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 84 De Long St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 5994659.32331 | 2086819.21058 | 37.7097020678628 | -122.460238064532 | (37.7097020678628, -122.460238064532) | 9 | 8 | 6 | 28861 | 25 | |||
87641 | 250043 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6006138.25466 | 2114733.68143 | 37.7870024301664 | -122.422547022523 | (37.7870024301664, -122.422547022523) | 13 | 9 | 1 | 28858 | 41 | |||
88267 | 250498 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 540 El Camino Del Mar | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5986910.92102 | 2115396.03511 | 37.7877175935458 | -122.489117099479 | (37.7877175935458, -122.489117099479) | 11 | 6 | 1 | 55 | 33 | |||
89062 | 250481 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 4 | : | Tree | Private 2 | 7 | Width 2ft | 5986391.51376 | 2115152.57183 | 37.7870187834372 | -122.490896202225 | (37.7870187834372, -122.490896202225) | 11 | 6 | 1 | 55 | 33 | |||
90590 | 213253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 5991916.13394 | 2088790.40392 | 37.7149563155577 | -122.469862350985 | (37.7149563155577, -122.469862350985) | 9 | 8 | 6 | 64 | 24 | |||
91201 | 250538 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 81 25th Ave | 1 | : | Tree | Private 2 | 14 | Width 5ft | 5987993.03076 | 2115480.02727 | 37.7880113130196 | -122.485379419922 | (37.7880113130196, -122.485379419922) | 11 | 6 | 1 | 55 | 33 | |||
96052 | 250977 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 Seal Rock Dr | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5981824.31886 | 2112976.61207 | 37.7807763705706 | -122.506535962981 | (37.7807763705706, -122.506535962981) | 11 | 6 | 2 | 55 | 26 | |||
96163 | 193773 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1509 11th St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6008828.72 | 2108671.33558 | 37.7705080832089 | -122.41280982261 | (37.7705080832089, -122.41280982261) | 8 | 2 | 9 | 28853 | 19 | |||
96269 | 193827 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Phelps St | 2 | : | Tree | Private 2 | 13 | Width 6ft | 6015556.71066 | 2098326.08175 | 37.7424775567988 | -122.388815117219 | (37.7424775567988, -122.388815117219) | 10 | 3 | 8 | 58 | 1 | |||
96724 | 213256 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 4 | : | Tree | Private 2 | 14 | Width 3ft | 5991914.37776 | 2088706.98259 | 37.7147271593 | -122.469862350964 | (37.7147271593, -122.469862350964) | 9 | 8 | 6 | 64 | 24 | |||
98642 | 246505 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 251 Duncan St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6004871.64082 | 2099863.97687 | 37.7461022482136 | -122.425870379909 | (37.7461022482136, -122.425870379909) | 2 | 7 | 5 | 63 | 22 | |||
98747 | 177711 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 5994431.51774 | 2086616.48409 | 37.7091323221755 | -122.461010711685 | (37.7091323221755, -122.461010711685) | 9 | 8 | 6 | 28861 | 25 | |||
98813 | 250527 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 78 26th Ave | 1 | : | Tree | Private 2 | 13 | Width 4ft | 5987724.29526 | 2115473.41293 | 37.7879774922173 | -122.48630869928 | (37.7879774922173, -122.48630869928) | 11 | 6 | 1 | 55 | 33 | |||
100346 | 193803 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Madera St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6012815.26602 | 2103237.48322 | 37.7558108838739 | -122.398638860701 | (37.7558108838739, -122.398638860701) | 10 | 3 | 8 | 28856 | 29 | |||
102843 | 193809 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 285 Texas St | 4 | : | Tree | Private 2 | 11 | Width 3ft | 6013777.67037 | 2105799.42073 | 37.7628989787339 | -122.395490009551 | (37.7628989787339, -122.395490009551) | 14 | 3 | 8 | 28856 | 29 | |||
104646 | 213273 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 4 | : | Tree | Private 2 | 6 | Width 0ft | 5990760.05228 | 2091123.40104 | 37.7212952571632 | -122.474028334441 | (37.7212952571632, -122.474028334441) | 9 | 8 | 4 | 64 | 40 | |||
105433 | 193841 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6011580.56119 | 2099671.3344 | 37.7459501494982 | -122.402658119778 | (37.7459501494982, -122.402658119778) | 10 | 3 | 8 | 58 | 1 | |||
107158 | 193852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1797 Bancroft Ave | 4 | : | Tree | Private 2 | 15 | Width 4ft | 6013448.47176 | 2092785.0369 | 37.7271459163427 | -122.395716674691 | (37.7271459163427, -122.395716674691) | 10 | 3 | 8 | 58 | 1 | |||
107951 | 193834 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6011560.32282 | 2099537.83926 | 37.7455824706665 | -122.402718715209 | (37.7455824706665, -122.402718715209) | 10 | 3 | 8 | 58 | 1 | |||
113162 | 246980 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 28 Clipper St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6004933.23249 | 2101079.14603 | 37.7494423033333 | -122.425743880402 | (37.7494423033333, -122.425743880402) | 2 | 4 | 5 | 28862 | 22 | |||
113858 | 250981 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 127 Seal Rock Dr | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5981262.02701 | 2112934.50357 | 37.7806276298976 | -122.508478041756 | (37.7806276298976, -122.508478041756) | 11 | 6 | 2 | 55 | 26 | |||
115350 | 250455 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Seacliff Ave | 2 | : | Tree | Private 2 | 8 | Width 4ft | 5987146.00356 | 2115751.2233 | 37.7887065564079 | -122.488329882411 | (37.7887065564079, -122.488329882411) | 11 | 6 | 1 | 55 | 33 | |||
117326 | 213235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 350 Tara St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5997565.93753 | 2089947.73504 | 37.7184590400263 | -122.450417716921 | (37.7184590400263, -122.450417716921) | 9 | 8 | 6 | 28861 | 24 | |||
117589 | 193807 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Madera St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6012906.51171 | 2103239.76011 | 37.7558222189243 | -122.39832346128 | (37.7558222189243, -122.39832346128) | 10 | 3 | 8 | 28856 | 29 | |||
119637 | 246503 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 259 Duncan St | 1 | : | Tree | Private 2 | 12 | Width 6ft | 6004822.9307 | 2099858.69154 | 37.7460849830515 | -122.426038437146 | (37.7460849830515, -122.426038437146) | 2 | 7 | 5 | 63 | 22 | |||
122309 | 193830 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Phelps St | 4 | : | Tree | Private 2 | 15 | Width 5ft | 6014155.4235 | 2096513.43048 | 37.7374226258562 | -122.393533556032 | (37.7374226258562, -122.393533556032) | 10 | 3 | 8 | 58 | 1 | |||
122671 | 246894 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 550 Frederick St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5996899.3293 | 2107397.33808 | 37.7663332045479 | -122.45398141901 | (37.7663332045479, -122.45398141901) | 15 | 5 | 11 | 29492 | 8 | |||
124040 | 250037 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Daniel Burnham Ct | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6006314.34591 | 2114758.99752 | 37.7870818744731 | -122.42193958447 | (37.7870818744731, -122.42193958447) | 13 | 9 | 1 | 28858 | 41 | |||
125198 | 193842 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2081 Thomas Ave | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6012276.18227 | 2095771.73834 | 37.7352814974372 | -122.399978942282 | (37.7352814974372, -122.399978942282) | 10 | 3 | 8 | 58 | 1 | |||
125952 | 193828 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Phelps St | 4 | : | Tree | Private 2 | 13 | Width 7ft | 6015597.83244 | 2098381.88934 | 37.7426330720665 | -122.388676823979 | (37.7426330720665, -122.388676823979) | 10 | 3 | 8 | 58 | 1 | |||
126590 | 193805 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Madera St | 3 | : | Tree | Private 2 | 11 | Width 4ft | 6012865.41984 | 2103240.59379 | 37.7558222189454 | -122.398465629698 | (37.7558222189454, -122.398465629698) | 10 | 3 | 8 | 28856 | 29 | |||
128335 | 193849 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Bay View St | 2 | : | Tree | Private 2 | 15 | Width 3ft | 6014256.78127 | 2094770.69828 | 37.7326430718137 | -122.393061210509 | (37.7326430718137, -122.393061210509) | 10 | 3 | 8 | 58 | 1 | |||
128739 | 213269 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 58 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992208.01745 | 2088290.25795 | 37.7135999031885 | -122.468817113946 | (37.7135999031885, -122.468817113946) | 9 | 8 | 6 | 64 | 24 | |||
129585 | 213251 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 28 Monticello St | 3 | : | Tree | Private 2 | 18 | Width 3ft | 5991689.17922 | 2089023.33892 | 37.7155827769944 | -122.470663751242 | (37.7155827769944, -122.470663751242) | 9 | 8 | 6 | 64 | 24 |
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) );