trees
6,344 rows where qSpecies_id = 19 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74323 | 229280 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 995 Potrero Ave | 8 | : | Tree | Private 2 | 9 | Width 4ft | 6010513.67118 | 2104098.92501 | 37.758047711846 | -122.40665926203 | (37.758047711846, -122.40665926203) | 10 | 4 | 8 | 28859 | 19 | |||
74333 | 193073 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 38 | : | Tree | Private 2 | 4 | Width 4ft | 6015332.51881 | 2098714.54599 | 37.7435317708642 | -122.389617437498 | (37.7435317708642, -122.389617437498) | 10 | 3 | 8 | 58 | 1 | |||
74835 | 229279 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 995 Potrero Ave | 6 | : | Tree | Private 2 | 11 | Width 4ft | 6010520.08812 | 2103990.76889 | 37.7577510983469 | -122.406629447707 | (37.7577510983469, -122.406629447707) | 10 | 4 | 8 | 28859 | 19 | |||
74937 | 193056 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1998 Evans Ave | 6 | : | Tree | Private 2 | 4 | Width 4ft | 6013679.69857 | 2100028.02497 | 37.7470465210879 | -122.395424519121 | (37.7470465210879, -122.395424519121) | 10 | 3 | 8 | 58 | 1 | |||
75385 | 193091 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1395 Fairfax Ave | 1 | : | Tree | DPW 1 | 01/27/2015 12:22:00 PM | 6 | Width 3ft | 6016598.40823 | 2097419.67591 | 37.7400464320877 | -122.385150061522 | (37.7400464320877, -122.385150061522) | 10 | 3 | 8 | 58 | 1 | ||
76336 | 192844 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 360 03rd St | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6013205.26526 | 2113091.37149 | 37.7828891766224 | -122.397981335797 | (37.7828891766224, -122.397981335797) | 6 | 2 | 9 | 28856 | 34 | |||
76666 | 192888 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Rizal St | 9 | : | Tree | Private 2 | 10 | Width 3ft | 6012728.77433 | 2112673.72942 | 37.7817158788256 | -122.399600474299 | (37.7817158788256, -122.399600474299) | 6 | 2 | 9 | 28856 | 34 | |||
76843 | 193070 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 32 | : | Tree | Private 2 | 2 | Width 4ft | 6015258.8607 | 2098768.603 | 37.7436761156767 | -122.389875906263 | (37.7436761156767, -122.389875906263) | 10 | 3 | 8 | 58 | 1 | |||
76896 | 193108 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Thornton Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6014279.85245 | 2094099.91382 | 37.7308025157065 | -122.392934532911 | (37.7308025157065, -122.392934532911) | 10 | 3 | 8 | 58 | 1 | |||
77505 | 250489 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 240 El Camino Del Mar | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5987807.77183 | 2115352.13466 | 37.7876493619664 | -122.486010983235 | (37.7876493619664, -122.486010983235) | 11 | 6 | 1 | 55 | 33 | |||
78189 | 192860 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Lapu-lapu St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6013043.20119 | 2112717.4864 | 37.7818535470496 | -122.398515769609 | (37.7818535470496, -122.398515769609) | 6 | 2 | 9 | 28856 | 34 | |||
78583 | 193080 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 45 | : | Tree | Private 2 | 3 | Width 4ft | 6015444.09199 | 2098631.34147 | 37.743309494432 | -122.389225833109 | (37.743309494432, -122.389225833109) | 10 | 3 | 8 | 58 | 1 | |||
79015 | 193055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1998 Evans Ave | 5 | : | Tree | Private 2 | 3 | Width 4ft | 6013702.50905 | 2100012.12293 | 37.7470041261332 | -122.395344528031 | (37.7470041261332, -122.395344528031) | 10 | 3 | 8 | 58 | 1 | |||
79484 | 193036 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 Evans Ave | 4 | : | Tree | Private 2 | 6 | Width 4ft | 6013922.86814 | 2099766.93566 | 37.7463431469336 | -122.394565373411 | (37.7463431469336, -122.394565373411) | 10 | 3 | 8 | 58 | 1 | |||
79924 | 208688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 455 Vernon St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5992460.83183 | 2090875.38614 | 37.7207126412465 | -122.468131239666 | (37.7207126412465, -122.468131239666) | 9 | 8 | 6 | 64 | 24 | |||
81101 | 193030 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1995 Evans Ave | 8 | : | Tree | Private 2 | 5 | Width 4ft | 6013820.7021 | 2099841.58915 | 37.7465424492744 | -122.394923881842 | (37.7465424492744, -122.394923881842) | 10 | 3 | 8 | 58 | 1 | |||
82656 | 193023 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1575 Bay Shore Blvd | 10 | : | Tree | Private 2 | 4 | Width 3ft | 6011811.6604 | 2092165.89243 | 37.7253546844472 | -122.401331656646 | (37.7253546844472, -122.401331656646) | 10 | 3 | 8 | 58 | 1 | |||
83194 | 208697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Garfield St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993327.08056 | 2090460.08559 | 37.7196223166853 | -122.465106762081 | (37.7196223166853, -122.465106762081) | 9 | 8 | 6 | 64 | 24 | |||
83341 | 218214 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Lenox Way | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993560.88973 | 2098882.74324 | 37.7427623379227 | -122.464909938252 | (37.7427623379227, -122.464909938252) | 1 | 8 | 4 | 59 | 40 | |||
84484 | 193034 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 Evans Ave | 2 | : | Tree | Private 2 | 4 | Width 4ft | 6013889.05967 | 2099790.32344 | 37.7464054852269 | -122.394683917534 | (37.7464054852269, -122.394683917534) | 10 | 3 | 8 | 58 | 1 | |||
85148 | 193061 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 10 | : | Tree | Private 2 | 3 | Width 4ft | 6014872.80659 | 2099056.97723 | 37.7444465145094 | -122.391230952554 | (37.7444465145094, -122.391230952554) | 10 | 3 | 8 | 58 | 1 | |||
85396 | 250550 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 El Camino Del Mar | 5 | : | Tree | Private 2 | 9 | Width 4ft | 5988215.47064 | 2115370.08013 | 37.7877223860349 | -122.484601759078 | (37.7877223860349, -122.484601759078) | 11 | 6 | 1 | 55 | 33 | |||
85660 | 193109 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 98 Flora St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6013811.82266 | 2094249.19212 | 37.7311863949379 | -122.394563047742 | (37.7311863949379, -122.394563047742) | 10 | 3 | 8 | 58 | 1 | |||
86171 | 229282 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 995 Potrero Ave | 11 | : | Tree | Private 2 | 13 | Width 4ft | 6010506.9251 | 2104261.45738 | 37.7584936119138 | -122.406694046915 | (37.7584936119138, -122.406694046915) | 10 | 4 | 8 | 28859 | 19 | |||
87189 | 192865 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Tandang Sora St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6012579.34351 | 2112725.19235 | 37.7818488534846 | -122.400121053148 | (37.7818488534846, -122.400121053148) | 6 | 2 | 9 | 28856 | 34 | |||
87889 | 192831 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6013123.79461 | 2113277.62075 | 37.7833960363261 | -122.398276263964 | (37.7833960363261, -122.398276263964) | 6 | 2 | 9 | 28856 | 6 | |||
88300 | 192931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1562 11th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6008981.17541 | 2108615.01514 | 37.7703619964339 | -122.412278495049 | (37.7703619964339, -122.412278495049) | 8 | 2 | 9 | 28853 | 19 | |||
88837 | 192944 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 224 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008142.81739 | 2109480.83399 | 37.77269225227 | -122.415239683772 | (37.77269225227, -122.415239683772) | 8 | 2 | 9 | 28853 | 19 | |||
89019 | 193090 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1401 Fairfax Ave | 3 | : | Tree | Private 2 | 3 | Width 4ft | 6016442.713 | 2097535.30475 | 37.7403553114351 | -122.385696453647 | (37.7403553114351, -122.385696453647) | 10 | 3 | 8 | 58 | 1 | |||
89295 | 193094 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400 Fairfax Ave | 13 | : | Tree | Private 2 | 5 | Width 3ft | 6016292.3394 | 2097733.74624 | 37.7408918694664 | -122.386230221956 | (37.7408918694664, -122.386230221956) | 10 | 3 | 8 | 58 | 1 | |||
89427 | 192935 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 394 12th St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6008589.10788 | 2108571.83744 | 37.7702214324131 | -122.41363160691 | (37.7702214324131, -122.41363160691) | 8 | 2 | 9 | 28853 | 19 | |||
89715 | 193104 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1663 Palou Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014514.83326 | 2095486.54729 | 37.7346229787569 | -122.392219101556 | (37.7346229787569, -122.392219101556) | 10 | 3 | 8 | 58 | 1 | |||
89724 | 192826 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 351 Saint Francis Pl | 1 | : | Tree | Private 2 | 8 | Width 1ft | 6013220.10577 | 2113174.25296 | 37.7831175765455 | -122.397935809387 | (37.7831175765455, -122.397935809387) | 6 | 2 | 9 | 28856 | 6 | |||
90017 | 193067 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 26 | : | Tree | Private 2 | 4 | Width 4ft | 6015172.19383 | 2098833.8565 | 37.7438504816303 | -122.3901801397 | (37.7438504816303, -122.3901801397) | 10 | 3 | 8 | 58 | 1 | |||
90086 | 193075 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 40 | : | Tree | Private 2 | 3 | Width 4ft | 6015364.68497 | 2098691.20601 | 37.7434694676348 | -122.38950458429 | (37.7434694676348, -122.38950458429) | 10 | 3 | 8 | 58 | 1 | |||
90419 | 192822 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 674 Harrison St | 4 | : | Tree | Private 2 | 10 | Width 4ft | 6013416.27051 | 2113057.46597 | 37.7828078293482 | -122.397248962085 | (37.7828078293482, -122.397248962085) | 6 | 2 | 9 | 28856 | 6 | |||
90749 | 193095 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1498 Fairfax Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6016258.30057 | 2097758.8859 | 37.7409590137548 | -122.386349669012 | (37.7409590137548, -122.386349669012) | 10 | 3 | 8 | 58 | 1 | |||
90920 | 192994 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 404 Texas St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6013752.83539 | 2105173.9713 | 37.7611802501882 | -122.395532084347 | (37.7611802501882, -122.395532084347) | 10 | 3 | 8 | 28856 | 29 | |||
91976 | 208700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 144 Eucalyptus Dr | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5990998.47136 | 2094705.01684 | 37.731143287718 | -122.473465306694 | (37.731143287718, -122.473465306694) | 1 | 8 | 4 | 64 | 40 | |||
93166 | 192941 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1531 Howard St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6007936.54468 | 2109469.70313 | 37.7726500947637 | -122.415952417173 | (37.7726500947637, -122.415952417173) | 8 | 2 | 9 | 28853 | 19 | |||
93464 | 192917 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009135.63021 | 2109156.36651 | 37.7718570869615 | -122.411782491979 | (37.7718570869615, -122.411782491979) | 8 | 2 | 9 | 28853 | 34 | |||
93748 | 192889 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Rizal St | 10 | : | Tree | Private 2 | 10 | Width 3ft | 6012712.48304 | 2112660.3861 | 37.7816783330348 | -122.399655897695 | (37.7816783330348, -122.399655897695) | 6 | 2 | 9 | 28856 | 34 | |||
93842 | 249380 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 648 Hyde St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6007883.83982 | 2114699.11368 | 37.7870058377012 | -122.416505224146 | (37.7870058377012, -122.416505224146) | 13 | 1 | 9 | 28858 | 36 | |||
94040 | 193035 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 Evans Ave | 3 | : | Tree | Private 2 | 6 | Width 4ft | 6013910.22684 | 2099775.47741 | 37.7463658979851 | -122.394609683909 | (37.7463658979851, -122.394609683909) | 10 | 3 | 8 | 58 | 1 | |||
94422 | 192858 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 730 Harrison St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6013118.62459 | 2112768.94304 | 37.7819990366666 | -122.398258449293 | (37.7819990366666, -122.398258449293) | 6 | 2 | 9 | 28856 | 34 | |||
95103 | 250551 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 El Camino Del Mar | 6 | : | Tree | Private 2 | 8 | Width 4ft | 5988203.79836 | 2115369.62382 | 37.7877204533909 | -122.484642108948 | (37.7877204533909, -122.484642108948) | 11 | 6 | 1 | 55 | 33 | |||
96459 | 250772 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 251 32nd Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5985866.25825 | 2114225.46269 | 37.7844425108487 | -122.492645136277 | (37.7844425108487, -122.492645136277) | 11 | 6 | 1 | 55 | 33 | |||
96722 | 193024 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1575 Bay Shore Blvd | 11 | : | Tree | Private 2 | 3 | Width 3ft | 6011805.97785 | 2092195.65532 | 37.7254360901775 | -122.401353391455 | (37.7254360901775, -122.401353391455) | 10 | 3 | 8 | 58 | 1 | |||
97057 | 246953 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6003411.81977 | 2107112.28183 | 37.7659217655897 | -122.431435595179 | (37.7659217655897, -122.431435595179) | 15 | 5 | 5 | 28862 | 3 | |||
97137 | 192905 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 7 | : | Tree | Private 2 | 11 | Width 3ft | 6012342.50289 | 2112782.98964 | 37.7819943431069 | -122.400944478726 | (37.7819943431069, -122.400944478726) | 6 | 2 | 9 | 28856 | 34 | |||
97809 | 192938 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1559 Howard St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6007846.80578 | 2109365.46074 | 37.7723588241445 | -122.416255450046 | (37.7723588241445, -122.416255450046) | 8 | 2 | 9 | 28853 | 19 | |||
98131 | 192948 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 202 11th St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6008125.57272 | 2109597.0372 | 37.7730103496868 | -122.415307562798 | (37.7730103496868, -122.415307562798) | 8 | 2 | 9 | 28853 | 34 | |||
98340 | 192885 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Rizal St | 6 | : | Tree | Private 2 | 9 | Width 3ft | 6012793.56318 | 2112736.79616 | 37.7818926567552 | -122.399380762736 | (37.7818926567552, -122.399380762736) | 6 | 2 | 9 | 28856 | 34 | |||
98876 | 246949 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6003300.7395 | 2107104.41585 | 37.7658938713298 | -122.431819236962 | (37.7658938713298, -122.431819236962) | 15 | 5 | 5 | 28862 | 3 | |||
99364 | 192876 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 728 Lapu-lapu St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6012840.49119 | 2112934.68618 | 37.7824386324777 | -122.399232308038 | (37.7824386324777, -122.399232308038) | 6 | 2 | 9 | 28856 | 34 | |||
99959 | 192947 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 202 11th St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6008145.44562 | 2109574.99572 | 37.7729509458718 | -122.415237259199 | (37.7729509458718, -122.415237259199) | 8 | 2 | 9 | 28853 | 34 | |||
100890 | 192949 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 202 11th St | 4 | : | Tree | Private 2 | 6 | Width 3ft | 6007949.61319 | 2109881.19021 | 37.7737806756731 | -122.415936356171 | (37.7737806756731, -122.415936356171) | 8 | 2 | 9 | 28853 | 34 | |||
101224 | 250691 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 850 El Camino Del Mar | 2 | : | Tree | Private 2 | 5 | Width 4ft | 5985780.23123 | 2115050.10184 | 37.7867017004544 | -122.493003521504 | (37.7867017004544, -122.493003521504) | 11 | 6 | 1 | 55 | 33 | |||
102099 | 192910 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 320 04th St | 3 | : | Tree | Private 2 | 16 | Width 3ft | 6012390.67526 | 2112631.98649 | 37.7815824104263 | -122.400767211555 | (37.7815824104263, -122.400767211555) | 6 | 2 | 9 | 28856 | 34 | |||
102990 | 193043 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 4 | : | Tree | Private 2 | 3 | Width 4ft | 6013932.32662 | 2099840.86073 | 37.7465466554048 | -122.394537842462 | (37.7465466554048, -122.394537842462) | 10 | 3 | 8 | 58 | 1 | |||
103169 | 192988 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1143 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6011965.37384 | 2103084.95216 | 37.7553446798412 | -122.401567359947 | (37.7553446798412, -122.401567359947) | 10 | 3 | 8 | 28856 | 29 | |||
104000 | 192863 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Tandang Sora St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6012617.89195 | 2112679.39909 | 37.7817252650447 | -122.39998447581 | (37.7817252650447, -122.39998447581) | 6 | 2 | 9 | 28856 | 34 | |||
105185 | 192986 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 794 Rhode Island St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6011815.20163 | 2104707.36031 | 37.7597910737109 | -122.402200764159 | (37.7597910737109, -122.402200764159) | 10 | 3 | 8 | 28856 | 29 | |||
105427 | 192887 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Rizal St | 8 | : | Tree | Private 2 | 9 | Width 3ft | 6012749.30003 | 2112698.38189 | 37.7817847129295 | -122.399531195917 | (37.7817847129295, -122.399531195917) | 6 | 2 | 9 | 28856 | 34 | |||
105518 | 229278 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 995 Potrero Ave | 5 | : | Tree | Private 2 | 14 | Width 4ft | 6010524.08037 | 2103939.89399 | 37.7576116306009 | -122.406612055713 | (37.7576116306009, -122.406612055713) | 10 | 4 | 8 | 28859 | 19 | |||
106580 | 192847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 360 03rd St | 5 | : | Tree | Private 2 | 15 | Width 4ft | 6013254.70368 | 2113046.49872 | 37.7827687196385 | -122.397807149703 | (37.7827687196385, -122.397807149703) | 6 | 2 | 9 | 28856 | 34 | |||
106789 | 246462 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Duncan St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6005120.85833 | 2099924.01405 | 37.746281177351 | -122.425012888034 | (37.746281177351, -122.425012888034) | 2 | 7 | 5 | 63 | 22 | |||
107076 | 193110 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 98 Flora St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6013809.79454 | 2094238.41857 | 37.7311567002165 | -122.394569305233 | (37.7311567002165, -122.394569305233) | 10 | 3 | 8 | 58 | 1 | |||
107356 | 229271 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 398 Church St | 2 | : | Tree | Private 2 | 6 | Width 4ft | 6004161.95672 | 2106675.00655 | 37.7647635988959 | -122.428809850019 | (37.7647635988959, -122.428809850019) | 8 | 4 | 5 | 28862 | 3 | |||
107658 | 192871 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Bonifacio St | 6 | : | Tree | Private 2 | 12 | Width 3ft | 6012707.65681 | 2112873.57092 | 37.7822634202506 | -122.399687567353 | (37.7822634202506, -122.399687567353) | 6 | 2 | 9 | 28856 | 34 | |||
108175 | 192864 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Tandang Sora St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6012596.11924 | 2112706.04983 | 37.7817972278994 | -122.400061671807 | (37.7817972278994, -122.400061671807) | 6 | 2 | 9 | 28856 | 34 | |||
108382 | 249381 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Hyde St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6007880.04669 | 2114726.60806 | 37.7870811172514 | -122.416520295881 | (37.7870811172514, -122.416520295881) | 13 | 1 | 9 | 28858 | 36 | |||
108728 | 201663 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1581 Howard St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6007798.33366 | 2109303.76012 | 37.7721866831042 | -122.416418748921 | (37.7721866831042, -122.416418748921) | 8 | 2 | 9 | 28853 | 19 | |||
109208 | 192892 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 772 Harrison St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6012873.96461 | 2112526.0648 | 37.7813185178887 | -122.399087813051 | (37.7813185178887, -122.399087813051) | 6 | 2 | 9 | 28856 | 34 | |||
109761 | 193083 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 50 | : | Tree | Private 2 | 4 | Width 4ft | 6015525.37481 | 2098572.11958 | 37.7431513891242 | -122.388940641912 | (37.7431513891242, -122.388940641912) | 10 | 3 | 8 | 58 | 1 | |||
110043 | 192923 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 7 | : | Tree | Private 2 | 4 | Width 3ft | 6009205.16374 | 2109084.23673 | 37.7716629359303 | -122.411536872751 | (37.7716629359303, -122.411536872751) | 8 | 2 | 9 | 28853 | 34 | |||
110359 | 250653 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 El Camino Del Mar | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5986703.58682 | 2115157.00739 | 37.7870491886035 | -122.489816840378 | (37.7870491886035, -122.489816840378) | 11 | 6 | 1 | 55 | 33 | |||
111087 | 229275 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 995 Potrero Ave | 1 | : | Tree | Private 2 | 14 | Width 4ft | 6010539.7531 | 2103704.20659 | 37.7569653624673 | -122.40654124489 | (37.7569653624673, -122.40654124489) | 10 | 4 | 8 | 28859 | 19 | |||
112059 | 192933 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1562 11th St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6009029.56571 | 2108557.67139 | 37.7702072590867 | -122.412107059111 | (37.7702072590867, -122.412107059111) | 8 | 2 | 9 | 28853 | 19 | |||
113688 | 246660 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3331 Harrison St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6009064.11809 | 2099300.57362 | 37.7447913037799 | -122.411333483854 | (37.7447913037799, -122.411333483854) | 2 | 7 | 7 | 28859 | 2 | |||
115119 | 193096 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1498 Fairfax Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016240.24501 | 2097771.68412 | 37.7409931556099 | -122.386412991184 | (37.7409931556099, -122.386412991184) | 10 | 3 | 8 | 58 | 1 | |||
117622 | 246950 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6003325.95588 | 2107107.02483 | 37.7659024643657 | -122.431732205089 | (37.7659024643657, -122.431732205089) | 15 | 5 | 5 | 28862 | 3 | |||
118232 | 208690 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 266 Vernon St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992479.67005 | 2089630.07877 | 37.7172944179741 | -122.467975588622 | (37.7172944179741, -122.467975588622) | 9 | 8 | 6 | 64 | 24 | |||
118724 | 192874 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Bonifacio St | 9 | : | Tree | Private 2 | 10 | Width 3ft | 6012775.32795 | 2112937.71825 | 37.7824433260271 | -122.399457958738 | (37.7824433260271, -122.399457958738) | 6 | 2 | 9 | 28856 | 34 | |||
119603 | 193032 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1995 Evans Ave | 10 | : | Tree | Private 2 | 3 | Width 4ft | 6013856.76211 | 2099814.34392 | 37.7464696446691 | -122.394797281563 | (37.7464696446691, -122.394797281563) | 10 | 3 | 8 | 58 | 1 | |||
120707 | 193063 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 20 | : | Tree | Private 2 | 2 | Width 4ft | 6015045.87298 | 2098929.39678 | 37.7441058081384 | -122.390623606204 | (37.7441058081384, -122.390623606204) | 10 | 3 | 8 | 58 | 1 | |||
122594 | 193085 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 52 | : | Tree | Private 2 | 2 | Width 4ft | 6015556.89734 | 2098546.13888 | 37.7430817986961 | -122.388829831052 | (37.7430817986961, -122.388829831052) | 10 | 3 | 8 | 58 | 1 | |||
123727 | 193053 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1998 Evans Ave | 3 | : | Tree | Private 2 | 4 | Width 4ft | 6013762.09863 | 2099966.21499 | 37.7468813866636 | -122.395135255799 | (37.7468813866636, -122.395135255799) | 10 | 3 | 8 | 58 | 1 | |||
123796 | 192901 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6012392.91079 | 2112729.54868 | 37.78185041829 | -122.400766333822 | (37.78185041829, -122.400766333822) | 6 | 2 | 9 | 28856 | 34 | |||
123909 | 229277 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 995 Potrero Ave | 4 | : | Tree | Private 2 | 18 | Width 4ft | 6010526.84052 | 2103899.06003 | 37.7574996640945 | -122.406599632462 | (37.7574996640945, -122.406599632462) | 10 | 4 | 8 | 28859 | 19 | |||
124017 | 193078 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 43 | : | Tree | Private 2 | 2 | Width 4ft | 6015410.29764 | 2098655.98733 | 37.7433752933383 | -122.389344406925 | (37.7433752933383, -122.389344406925) | 10 | 3 | 8 | 58 | 1 | |||
124849 | 193028 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1995 Evans Ave | 6 | : | Tree | Private 2 | 4 | Width 4ft | 6013731.66325 | 2099907.02812 | 37.7467171794589 | -122.395236353976 | (37.7467171794589, -122.395236353976) | 10 | 3 | 8 | 58 | 1 | |||
125874 | 246955 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 7 | : | Tree | Private 2 | 1 | Width 3ft | 6003442.97283 | 2107114.24236 | 37.7659289143048 | -122.431327983194 | (37.7659289143048, -122.431327983194) | 15 | 5 | 5 | 28862 | 3 | |||
126313 | 192919 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6009154.94193 | 2109134.89964 | 37.7717992272969 | -122.411714174064 | (37.7717992272969, -122.411714174064) | 8 | 2 | 9 | 28853 | 34 | |||
126496 | 192916 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 219 Dore St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6009505.48944 | 2109189.17331 | 37.7719679086316 | -122.410505434889 | (37.7719679086316, -122.410505434889) | 8 | 2 | 9 | 28853 | 34 | |||
127645 | 192992 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 324 Texas St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6013736.28779 | 2105555.70481 | 37.7622274864269 | -122.395616062134 | (37.7622274864269, -122.395616062134) | 10 | 3 | 8 | 28856 | 29 | |||
127799 | 193040 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1890 Evans Ave | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6014266.5091 | 2099591.88048 | 37.745881580665 | -122.393364845912 | (37.745881580665, -122.393364845912) | 10 | 3 | 8 | 58 | 1 | |||
128568 | 250692 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 850 El Camino Del Mar | 3 | : | Tree | Private 2 | 5 | Width 4ft | 5985754.9302 | 2115039.63583 | 37.7866714841451 | -122.493090284498 | (37.7866714841451, -122.493090284498) | 11 | 6 | 1 | 55 | 33 | |||
128714 | 192891 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 760 Harrison St | 4 | : | Tree | Private 2 | 18 | Width 3ft | 6012948.27406 | 2112607.17097 | 37.7815453574786 | -122.398836430965 | (37.7815453574786, -122.398836430965) | 6 | 2 | 9 | 28856 | 34 | |||
129264 | 246951 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6003369.9467 | 2107110.28224 | 37.7659139019225 | -122.431580282629 | (37.7659139019225, -122.431580282629) | 15 | 5 | 5 | 28862 | 3 |
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) );