Street_Tree_List

Data source: data.sfgov.org

255 rows where qSiteInfo = 4 and qSpecies = 37 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize, PermitNotes

qSiteInfo ✖

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188852 188852 241247 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1330 Stevenson St 2 : 4 Tree 1 Private 1     5 Width 2ft   6006254.50183 2108932.02318 37.77107904388 -122.421732594687 (37.77107904388, -122.421732594687)
188370 188370 198036 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 333 11th St 4 : 4 Tree 1 Private 1     3 Width 3ft   6008686.77489 2109006.56148 37.7714205668302 -122.413324523514 (37.7714205668302, -122.413324523514)
188365 188365 246426 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 448 Duncan St 1 : 4 Tree 1 Private 1     6 Width 3ft   6003617.56416 2099843.55926 37.745975235172295 -122.43020535771299 (37.7459752351723, -122.430205357713)
187957 187957 180224 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3599 Alemany Blvd 1 : 4 Tree 1 Private 1     8 Width 3ft   5993480.96313 2087505.0727 37.7115174312511 -122.46436041830799 (37.7115174312511, -122.464360418308)
187780 187780 198137 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 118 Bridgeview Dr 1 : 4 Tree 1 Private 1     11 Width 2ft   6013432.85539 2095621.93817 37.734934597439704 -122.395969375192 (37.7349345974397, -122.395969375192)
187625 187625 218526 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 424 Garfield St 1 : 4 Tree 1 Private 1     3 Width 3ft   5992849.69775 2090512.21172 37.7197379029691 -122.46676067557199 (37.7197379029691, -122.466760675572)
187523 187523 241639 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 200 Guerrero St 1 : 4 Tree 1 Private 1     4 Width 2ft   6005424.1713 2107755.7253799997 37.7678023541299 -122.424521053307 (37.7678023541299, -122.424521053307)
187297 187297 198039 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 157 12th St 3 : 4 Tree 1 Private 1     5 Width 3ft   6007591.24481 2109206.34028 37.771907543438395 -122.417128184534 (37.7719075434384, -122.417128184534)
185904 185904 247801 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 462 30th St 1 : 4 Tree 1 Private 1     8 Width 3ft   6003630.84189 2098375.23957 37.741944320889104 -122.430054719445 (37.7419443208891, -122.430054719445)
184794 184794 247800 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 450 30th St 1 : 4 Tree 1 Private 1     6 Width 3ft   6003679.98284 2098378.58347 37.741956285468504 -122.42988504438298 (37.7419562854685, -122.429885044383)
183701 183701 218518 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 313 Vernon St 1 : 4 Tree 1 Private 1     5 Width 3ft   5992449.51413 2089938.14589 37.7181385540341 -122.46810221944901 (37.7181385540341, -122.468102219449)
183096 183096 241556 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3750 Market St 1 : 4 Tree 1 Private 1     3 Width 3ft   6000189.8094 2102874.5763 37.754102932814 -122.44227558786801 (37.754102932814, -122.442275587868)
182131 182131 241650 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 50 Scott St 4 : 4 Tree 1 Private 1     6 Width 3ft   6002438.428230001 2108471.60709 37.7695989234814 -122.434899572366 (37.7695989234814, -122.434899572366)
180823 180823 218511 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 318 Lakeview Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   5996829.51445 2089654.6411099997 37.7176120972009 -122.45294206803001 (37.7176120972009, -122.45294206803)
180804 180804 218565 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 77 Rossmoor Dr 2 : 4 Tree 1 Private 1     8 Width 3ft   5990819.815219999 2094485.38355 37.730529882627394 -122.474066927066 (37.7305298826274, -122.474066927066)
180763 180763 218556 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 50 Rossmoor Dr 1 : 4 Tree 1 Private 1     6 Width 3ft   5991013.46606 2094544.7667599998 37.7307041496708 -122.47340178398198 (37.7307041496708, -122.473401783982)
179744 179744 218533 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 175 Eucalyptus Dr 3 : 4 Tree 1 Private 1     3 Width 2ft   5991030.95126 2094659.5879400002 37.7310204322329 -122.473349706944 (37.7310204322329, -122.473349706944)
179300 179300 218530 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 179 Eucalyptus Dr 2 : 4 Tree 1 Private 1     3 Width 2ft   5990903.39265 2094666.8232099998 37.7310329112435 -122.47379122189301 (37.7310329112435, -122.473791221893)
178730 178730 218557 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 56 Rossmoor Dr 1 : 4 Tree 1 Private 1     1 Width 3ft   5990972.9543 2094544.43485 37.730700892315795 -122.473541813811 (37.7307008923158, -122.473541813811)
177854 177854 218553 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 80 Elmhurst Dr 1 : 4 Tree 1 Private 1     7 Width 3ft   5991104.11114 2094544.62455 37.73070900780179 -122.473088402633 (37.7307090078018, -122.473088402633)
177063 177063 198144 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1790 Newcomb Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   6014242.32519 2096462.18043 37.7372867320059 -122.393229508759 (37.7372867320059, -122.393229508759)
176487 176487 198012 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 950 Clara St 1 : 4 Tree 1 Private 1     5 Width 3ft   6011569.50985 2111521.45528 37.778487314485105 -122.403529911791 (37.7784873144851, -122.403529911791)
176235 176235 180233 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3353 19th Ave 6 : 4 Tree 1 Private 1     2 Width 3ft   5990560.21445 2094269.5326900003 37.7299221693679 -122.474948645772 (37.7299221693679, -122.474948645772)
176118 176118 249541 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1031 Franklin St 1 : 4 Tree 1 Private 1     3 Width 3ft   6006016.726419999 2113765.1480900003 37.7843362199808 -122.42289862237699 (37.7843362199808, -122.422898622377)
175985 175985 241241 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 98 McCoppin St 3 : 4 Tree 1 Private 1     1 Width 3ft   6006130.56818 2109161.24748 37.771701449400396 -122.42217757385299 (37.7717014494004, -122.422177573853)
175296 175296 218544 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 20 Elmhurst Dr 1 : 4 Tree 1 Private 1     5 Width 3ft   5991241.315909999 2094410.9683 37.730349964259894 -122.472604328142 (37.7303499642599, -122.472604328142)
174591 174591 246466 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 240 Duncan St 1 : 4 Tree 1 Private 1     8 Width 3ft   6004915.09696 2099911.47997 37.746235136546396 -122.425723494564 (37.7462351365464, -122.425723494564)
174149 174149 198017 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 950 Clara St 6 : 4 Tree 1 Private 1     3 Width 2ft   6011612.66203 2111564.03025 37.7786066257438 -122.403383627176 (37.7786066257438, -122.403383627176)
173996 173996 218534 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 171 Eucalyptus Dr 1 : 4 Tree 1 Private 1     3 Width 2ft   5991093.98994 2094659.29915 37.731023289396 -122.47313175264 (37.731023289396, -122.47313175264)
173422 173422 218543 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 10 Elmhurst Dr 1 : 4 Tree 1 Private 1     7 Width 3ft   5991239.17772 2094375.63397 37.7302528212926 -122.472609144905 (37.7302528212926, -122.472609144905)
173194 173194 241231 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 243 Duboce Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   6005149.29633 2108406.9235799997 37.7695748612069 -122.42551816404499 (37.7695748612069, -122.425518164045)
173071 173071 198031 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 354 09th St 1 : 4 Tree 1 Private 1     6 Width 3ft   6009423.88038 2109239.7396299997 37.772102176494606 -122.4107912997 (37.7721021764946, -122.4107912997)
173064 173064 241252 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 186 Duboce Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   6005533.121730001 2108500.77585 37.7698542365083 -122.42419720024401 (37.7698542365083, -122.424197200244)
172602 172602 198127 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2 Lucy St 4 : 4 Tree 1 Private 1     9 Width 3ft   6014137.802759999 2093994.81434 37.7305060425038 -122.393418272834 (37.7305060425038, -122.393418272834)
172235 172235 201654 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 744 Innes Ave 2 : 4 Tree 1 Private 1     3 Width 3ft   6020169.84192 2093795.1774099998 37.73029117649 -122.372550568669 (37.73029117649, -122.372550568669)
172073 172073 85219 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 603 22nd Ave 2 : 4 Tree 1 Private 1   07/19/2007 12:00:00 AM 3   Permit Number 49541 5989076.796080001 2111176.31145 37.77625759727871 -122.481314542866 (37.7762575972787, -122.481314542866)
171531 171531 218519 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 313 Vernon St 2 : 4 Tree 1 Private 1     6 Width 3ft   5992450.27493 2089919.88933 37.71808846989129 -122.468098262426 (37.7180884698913, -122.468098262426)
170627 170627 202327 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 121 Orsi Cir 1 : 4 Tree 1 Private 1     4 Width 2ft   6012845.23034 2093098.4043400001 37.727972783613204 -122.397824059657 (37.7279727836132, -122.397824059657)
170353 170353 198124 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 75 Williams Ave 4 : 4 Tree 1 Private 1     6 Width 3ft   6013810.98382 2093612.6128200002 37.729438431221205 -122.394521389373 (37.7294384312212, -122.394521389373)
170153 170153 241237 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1353 Stevenson St 2 : 4 Tree 1 Private 1     7 Width 3ft   6006282.81333 2108802.54616 37.7707251273838 -122.421625466565 (37.7707251273838, -122.421625466565)
169917 169917 198135 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 111 Bridgeview Dr 1 : 4 Tree 1 Private 1     8 Width 2ft   6013464.34426 2095584.8175599999 37.7348344237609 -122.395857906032 (37.7348344237609, -122.395857906032)
169708 169708 198040 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 157 12th St 4 : 4 Tree 1 Private 1     4 Width 3ft   6007573.55961 2109215.4264 37.7719314968599 -122.417190003036 (37.7719314968599, -122.417190003036)
168227 168227 198112 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 500 Arkansas St 4 : 4 Tree 1 Private 1     5 Width 3ft   6012943.11931 2104639.2308799997 37.759666898924706 -122.39829504539499 (37.7596668989247, -122.398295045395)
167577 167577 218535 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 171 Eucalyptus Dr 3 : 4 Tree 1 Private 1     4 Width 2ft   5991111.04224 2094658.5927099998 37.7310223369939 -122.473072749029 (37.7310223369939, -122.473072749029)
167138 167138 218552 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 70 Elmhurst Dr 1 : 4 Tree 1 Private 1     7 Width 3ft   5991136.37193 2094544.36551 37.730710164331995 -122.47297685429501 (37.730710164332, -122.472976854295)
166913 166913 218539 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 167 Eucalyptus Dr 2 : 4 Tree 1 Private 1     4 Width 2ft   5991186.570780001 2094655.95963 37.7310194798608 -122.472811444694 (37.7310194798608, -122.472811444694)
166606 166606 250811 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 55 Sea View Ter 2 : 4 Tree 1 Private 1     5 Width 3ft   5986145.66751 2114125.50365 37.784184385653894 -122.491671129117 (37.7841843856539, -122.491671129117)
166576 166576 198038 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 157 12th St 2 : 4 Tree 1 Private 1     6 Width 3ft   6007603.04686 2109200.86421 37.7718931713742 -122.4170869722 (37.7718931713742, -122.4170869722)
166503 166503 218525 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 213 Bright St 2 : 4 Tree 1 Private 1     3 Width 3ft   5993735.1620000005 2088577.5608299999 37.7144768779817 -122.46355963226699 (37.7144768779817, -122.463559632267)
166476 166476 218508 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 82 Margaret Ave 2 : 4 Tree 1 Private 1     10 Width 3ft   5996984.38941 2089699.59442 37.717744402756 -122.452409980531 (37.717744402756, -122.452409980531)
165562 165562 218571 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 98 Rossmoor Dr 2 : 4 Tree 1 Private 1     4 Width 3ft   5990740.2773400005 2094470.45315 37.7304842798098 -122.474340809303 (37.7304842798098, -122.474340809303)
165531 165531 246601 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1 Waller St 3 : 4 Tree 1 Private 1     2 Width 4ft   6005553.210969999 2109241.87873 37.77189026116871 -122.424180426085 (37.7718902611687, -122.424180426085)
165492 165492 198142 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1655 Jerrold Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   6015037.63541 2097187.27801 37.7393218528083 -122.390530383376 (37.7393218528083, -122.390530383376)
165328 165328 198116 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 500 Toland St 3 : 4 Tree 1 Private 1     4 Width 3ft   6012565.75039 2098841.96583 37.7437278356634 -122.39919323967301 (37.7437278356634, -122.399193239673)
164413 164413 198030 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 70 Converse St 2 : 4 Tree 1 Private 1     5 Width 3ft   6010334.07948 2109275.93485 37.7722525530475 -122.407645384826 (37.7722525530475, -122.407645384826)
164004 164004 198128 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2115 Quesada Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   6012499.36052 2096642.9645 37.7376861424924 -122.399268467073 (37.7376861424924, -122.399268467073)
163789 163789 198111 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 500 Arkansas St 3 : 4 Tree 1 Private 1     5 Width 3ft   6012942.0959 2104655.9995 37.75971288486671 -122.39829976142299 (37.7597128848667, -122.398299761423)
163392 163392 246448 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 437 Duncan St 1 : 4 Tree 1 Private 1     3 Width 3ft   6003657.431919999 2099795.32001 37.745845039413794 -122.43006405980199 (37.7458450394138, -122.430064059802)
163374 163374 218532 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 175 Eucalyptus Dr 2 : 4 Tree 1 Private 1     2 Width 2ft   5991015.99501 2094660.59708 37.7310223370113 -122.473401486299 (37.7310223370113, -122.473401486299)
162187 162187 180219 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 254 Wilson St 1 : 4 Tree 1 Private 1     6 Width 3ft   5994266.2336800005 2086739.00195 37.7094592149324 -122.46159083107901 (37.7094592149324, -122.461590831079)
162135 162135 198029 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 70 Converse St 1 : 4 Tree 1 Private 1     5 Width 3ft   6010343.2009 2109265.68356 37.7722249159661 -122.407613109969 (37.7722249159661, -122.407613109969)
161421 161421 241645 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 472 Oak St 1 : 4 Tree 1 Private 1     1 Width 3ft   6004722.92891 2110216.2056400003 37.774518610776795 -122.42712184320101 (37.7745186107768, -122.427121843201)
160233 160233 201483 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 801 Arelious Walker Dr 2 : 4 Tree 1 Private 1     5 Width 3ft   6019824.354280001 2094127.5426599998 37.731184797722705 -122.37376798991899 (37.7311847977227, -122.373767989919)
159569 159569 218517 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 312 Vernon St 4 : 4 Tree 1 Private 1     8 Width 3ft   5992480.50725 2089942.0542400002 37.718151075281206 -122.46799537461 (37.7181510752812, -122.46799537461)
158383 158383 218555 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 20 Rossmoor Dr 2 : 4 Tree 1 Private 1     6 Width 3ft   5991088.47089 2094414.70645 37.7303513798138 -122.473133001812 (37.7303513798138, -122.473133001812)
158066 158066 241245 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1320 Stevenson St 4 : 4 Tree 1 Private 1     3 Width 2ft   6006256.03019 2109015.93605 37.771309534746706 -122.42173326920201 (37.7713095347467, -122.421733269202)
158060 158060 218563 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 74 Rossmoor Dr 1 : 4 Tree 1 Private 1     4 Width 3ft   5990853.662690001 2094536.86772 37.7306732058057 -122.473953667332 (37.7306732058057, -122.473953667332)
157397 157397 198042 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 966 Natoma St 2 : 4 Tree 1 Private 1     1 Width 3ft   6007955.48118 2109829.7754599997 37.773639832845795 -122.415912416224 (37.7736398328458, -122.415912416224)
157148 157148 180234 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3353 19th Ave 8 : 4 Tree 1 Private 1     1 Width 3ft   5990557.66801 2094210.25193 37.7297592517825 -122.474953123507 (37.7297592517825, -122.474953123507)
156968 156968 246602 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1 Waller St 4 : 4 Tree 1 Private 1     2 Width 4ft   6005566.51625 2109243.72851 37.77189609146429 -122.424134533696 (37.7718960914643, -122.424134533696)
156625 156625 198133 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 147 Bridgeview Dr 1 : 4 Tree 1 Private 1     11 Width 2ft   6013277.827409999 2095722.37145 37.7352017401562 -122.396512402938 (37.7352017401562, -122.396512402938)
155897 155897 218529 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 183 Eucalyptus Dr 3 : 4 Tree 1 Private 1     5 Width 3ft   5990845.1079400005 2094666.97645 37.731029956048104 -122.473992731197 (37.7310299560481, -122.473992731197)
155828 155828 247780 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 258 30th St 2 : 4 Tree 1 Private 1     7 Width 3ft   6004900.45377 2098450.54885 37.7422229263622 -122.42567016656601 (37.7422229263622, -122.425670166566)
155268 155268 218507 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 19 Caine Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5997670.25765 2089705.91413 37.71780102586771 -122.450039707591 (37.7178010258677, -122.450039707591)
155124 155124 198114 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 500 Toland St 1 : 4 Tree 1 Private 1     3 Width 3ft   6012579.44838 2098858.57483 37.743774203826604 -122.39914704060301 (37.7437742038266, -122.399147040603)
154157 154157 247786 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 0 30th St 2 : 4 Tree 1 Private 1     3 Width 3ft   6004434.4666 2098422.1705099996 37.7421186634473 -122.42727938556101 (37.7421186634473, -122.427279385561)
154017 154017 241646 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 508 Oak St 2 : 4 Tree 1 Private 1     2 Width 3ft   6004431.60341 2110177.48427 37.7743958128512 -122.42812683470501 (37.7743958128512, -122.428126834705)
153943 153943 201484 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 801 Arelious Walker Dr 3 : 4 Tree 1 Private 1     4 Width 3ft   6019815.12004 2094115.72508 37.731151841174004 -122.37379909656 (37.731151841174, -122.37379909656)
153121 153121 198037 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 157 12th St 1 : 4 Tree 1 Private 1     6 Width 3ft   6007615.86414 2109193.6225799997 37.771874008595795 -122.41704212299999 (37.7718740085958, -122.417042123)
152950 152950 247795 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 408 30th St 1 : 4 Tree 1 Private 1     6 Width 3ft   6003836.77293 2098388.1114 37.7419913248315 -122.429343594042 (37.7419913248315, -122.429343594042)
152150 152150 198024 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 370 07th St 1 : 4 Tree 1 Private 1     1 Width 3ft   6010586.99761 2110579.16527 37.7758450766249 -122.406862381093 (37.7758450766249, -122.406862381093)
152093 152093 246469 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 274 Duncan St 1 : 4 Tree 1 Private 1     6 Width 4ft   6004738.49373 2099902.53955 37.74620060706471 -122.426333530769 (37.7462006070647, -122.426333530769)
151908 151908 218574 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 95 Rossmoor Dr 3 : 4 Tree 1 Private 1     7 Width 3ft   5990724.629290001 2094434.6004700002 37.730384930811 -122.474392290997 (37.730384930811, -122.474392290997)
151678 151678 218516 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 312 Vernon St 3 : 4 Tree 1 Private 1     8 Width 3ft   5992481.316000001 2089926.0766200002 37.7181072513199 -122.46799141759199 (37.7181072513199, -122.467991417592)
151588 151588 198108 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1606 20th St 1 : 4 Tree 1 Private 1     6 Width 3ft   6013167.4589599995 2104762.27633 37.7600172487192 -122.397527790602 (37.7600172487192, -122.397527790602)
150636 150636 180228 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2901 Ocean Ave 4 : 4 Tree 1 Private 1     5 Width 3ft   5989943.872719999 2095241.7603 37.7325559212225 -122.477150408276 (37.7325559212225, -122.477150408276)
150450 150450 202315 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 179 Orsi Cir 1 : 4 Tree 1 Private 1     4 Width 2ft   6013045.37799 2092949.4671200002 37.7275749765936 -122.397121699923 (37.7275749765936, -122.397121699923)
150338 150338 241238 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 100 McCoppin St 2 : 4 Tree 1 Private 1     3 Width 3ft   6005908.08699 2109147.66491 37.771651603561104 -122.422946185717 (37.7716516035611, -122.422946185717)
150018 150018 250810 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 55 Sea View Ter 1 : 4 Tree 1 Private 1     5 Width 3ft   5986123.508640001 2114127.60677 37.784188865162 -122.491747944716 (37.784188865162, -122.491747944716)
149821 149821 201485 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 801 Arelious Walker Dr 4 : 4 Tree 1 Private 1     4 Width 3ft   6019804.87091 2094104.0965 37.7311193477698 -122.373833724951 (37.7311193477698, -122.373833724951)
149193 149193 246604 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1 Waller St 6 : 4 Tree 1 Private 1     1 Width 4ft   6005614.489030001 2109249.34773 37.7719142289884 -122.423968991887 (37.7719142289884, -122.423968991887)
148015 148015 241642 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3 Laussat St 1 : 4 Tree 1 Private 1     7 Width 3ft   6004646.58441 2109298.02282 37.7719931867726 -122.427320513349 (37.7719931867726, -122.427320513349)
144256 144256 198005 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 238 Shipley St 1 : 4 Tree 1 Private 1     1 Width 3ft   6011481.128719999 2111736.55218 37.779072983571794 -122.403850797089 (37.7790729835718, -122.403850797089)
137783 137783 247787 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 0 30th St 3 : 4 Tree 1 Private 1     6 Width 3ft   6004405.04711 2098420.28659 37.74211182679821 -122.42738097477199 (37.7421118267982, -122.427380974772)
137501 137501 218509 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 19 Josiah Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   5996929.671130001 2090006.0095900001 37.7185826122667 -122.45262121781201 (37.7185826122667, -122.452621217812)
137193 137193 241244 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1320 Stevenson St 3 : 4 Tree 1 Private 1     4 Width 2ft   6006253.43644 2109037.09804 37.771367494246 -122.421743744473 (37.771367494246, -122.421743744473)
136856 136856 247799 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 468 30th St 1 : 4 Tree 1 Private 1     8 Width 3ft   6003576.37635 2098371.38296 37.7419306466931 -122.430242768589 (37.7419306466931, -122.430242768589)
136622 136622 241249 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1358 Stevenson St 1 : 4 Tree 1 Private 1     3 Width 2ft   6006262.04942 2108777.1847599996 37.7706543201802 -122.42169548777001 (37.7706543201802, -122.42169548777)
136590 136590 241649 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 50 Scott St 3 : 4 Tree 1 Private 1     7 Width 3ft   6002442.34767 2108446.81048 37.769531060630605 -122.43488424161 (37.7695310606306, -122.43488424161)
136453 136453 198109 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 500 Arkansas St 1 : 4 Tree 1 Private 1     5 Width 3ft   6012941.63238 2104677.96184 37.759773162811 -122.398302905469 (37.759773162811, -122.398302905469)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 1538.837ms · Data source: data.sfgov.org