Street_Tree_List

Data source: data.sfgov.org

255 rows where qSiteInfo = 4 and qSpecies = 37

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1969 198010 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 213 Clara St 1 : 4 Tree 1 Private 1     1 Width 3ft Permit Number 779305 6011863.46506 2111836.2655700003 37.7793681257663 -122.40253514649099 (37.7793681257663, -122.402535146491)
24128 198134 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 131 Bridgeview Dr 1 : 4 Tree 1 Private 1     8 Width 2ft   6013337.1330699995 2095632.7165299999 37.7349588665628 -122.396301078452 (37.7349588665628, -122.396301078452)
24340 241638 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 200 Guerrero St 2 : 4 Tree 1 Private 1     3 Width 2ft   6005425.11854 2107744.6412400003 37.767771973225 -122.424516988391 (37.767771973225, -122.424516988391)
24404 246777 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 999 Esmeralda Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   6009797.217759999 2098767.51115 37.743368720206206 -122.408760953364 (37.7433687202062, -122.408760953364)
24956 198140 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 152 Bridgeview Dr 1 : 4 Tree 1 Private 1     12 Width 2ft   6013267.76129 2095794.5918400001 37.7353994821874 -122.396552266301 (37.7353994821874, -122.396552266301)
24967 241232 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 127 Duboce Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   6005861.10215 2108452.80959 37.7697410460526 -122.42305931235201 (37.7697410460526, -122.423059312352)
25060 85220 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 603 22nd Ave 3 : 4 Tree 1 Private 1   07/19/2007 12:00:00 AM 3   Permit Number 49541 5989076.71677 2111162.9995 37.776221041753296 -122.48131384215401 (37.7762210417533, -122.481313842154)
25109 241253 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 398 Guerrero St 1 : 4 Tree 1 Private 1     2 Width 3ft   6005480.91961 2106731.68653 37.764993792043 -122.424251927594 (37.764993792043, -122.424251927594)
25735 246806 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 132 Brewster St 1 : 4 Tree 1 Private 1     3 Width 2ft   6010286.59808 2099166.12262 37.744490619049294 -122.407096884714 (37.7444906190493, -122.407096884714)
26511 218506 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 331 Tara St 1 : 4 Tree 1 Private 1     5 Width 3ft   5997624.737980001 2089991.46593 37.7185824800643 -122.450217619562 (37.7185824800643, -122.450217619562)
27314 218570 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 98 Rossmoor Dr 1 : 4 Tree 1 Private 1     4 Width 3ft   5990761.96187 2094481.85885 37.7305168532543 -122.47426667546002 (37.7305168532543, -122.47426667546)
27501 198028 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 106 Langton St 3 : 4 Tree 1 Private 1     3 Width 3ft   6010225.17287 2110701.2793 37.7761601208299 -122.40812264516 (37.7761601208299, -122.40812264516)
27759 218515 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 312 Vernon St 2 : 4 Tree 1 Private 1     7 Width 3ft   5992482.76796 2089904.38544 37.7180477764537 -122.46798482193701 (37.7180477764537, -122.467984821937)
27858 198136 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 27 Bridgeview Dr 1 : 4 Tree 1 Private 1     12 Width 2ft   6014000.75949 2095429.8898900002 37.7344388515748 -122.393992476471 (37.7344388515748, -122.393992476471)
27867 241239 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 100 McCoppin St 1 : 4 Tree 1 Private 1     5 Width 3ft   6005928.367769999 2109150.09439 37.7716594186857 -122.42287620587601 (37.7716594186857, -122.422876205876)
28080 198006 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 238 Shipley St 2 : 4 Tree 1 Private 1     1 Width 3ft   6011475.496280001 2111728.4985 37.7790505553711 -122.403869715215 (37.7790505553711, -122.403869715215)
28632 198138 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 134 Bridgeview Dr 1 : 4 Tree 1 Private 1     15 Width 3ft   6013340.1556400005 2095686.7025099997 37.7351072690864 -122.396294410852 (37.7351072690864, -122.396294410852)
29242 246450 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 425 Duncan St 1 : 4 Tree 1 Private 1     6 Width 3ft   6003711.71796 2099797.01906 37.7458527789913 -122.429876467534 (37.7458527789913, -122.429876467534)
29757 198021 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 217 Clara St 2 : 4 Tree 1 Private 1     1 Width 3ft   6011882.31824 2111817.0211 37.7793163374183 -122.40246857147699 (37.7793163374183, -122.402468571477)
29892 247666 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 136 Divisadero St 1 : 4 Tree 1 Private 1     5 Width 3ft   6001948.31125 2108443.5233 37.7694939725921 -122.436592856397 (37.7694939725921, -122.436592856397)
29994 218514 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 312 Vernon St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992482.71781 2089883.86567 37.71799143124971 -122.467983503544 (37.7179914312497, -122.467983503544)
30269 218547 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 25 Elmhurst Dr 4 : 4 Tree 1 Private 1     6 Width 3ft   5991211.4167599995 2094496.23075 37.7305823428046 -122.472713906928 (37.7305823428046, -122.472713906928)
30660 198122 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 75 Williams Ave 2 : 4 Tree 1 Private 1     9 Width 3ft   6013771.43179 2093619.4653599998 37.7294550480043 -122.394658605233 (37.7294550480043, -122.394658605233)
31534 202322 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 149 Orsi Cir 1 : 4 Tree 1 Private 1     3 Width 2ft   6012943.5875699995 2093025.90325 37.727779187458296 -122.39747895112 (37.7277791874583, -122.39747895112)
31648 198026 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 370 07th St 3 : 4 Tree 1 Private 1     6 Width 3ft   6010608.77532 2110557.1414900003 37.7757858229832 -122.406785493561 (37.7757858229832, -122.406785493561)
31723 247796 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 410 30th St 1 : 4 Tree 1 Private 1     6 Width 3ft   6003801.70372 2098385.09969 37.7419810698755 -122.429464637397 (37.7419810698755, -122.429464637397)
31750 218522 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 516 Victoria St 1 : 4 Tree 1 Private 1     5 Width 3ft   5993271.7065 2090620.2984799999 37.7200590292793 -122.465309800203 (37.7200590292793, -122.465309800203)
31831 218523 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 506 Victoria St 1 : 4 Tree 1 Private 1     5 Width 3ft   5993270.87957 2090565.6413599998 37.7199089063619 -122.465308690447 (37.7199089063619, -122.465308690447)
31853 180223 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3602 Alemany Blvd 8 : 4 Tree 1 Private 1     6 Width 3ft   5993236.04296 2087638.25257 37.7118689906411 -122.46521658728099 (37.7118689906411, -122.465216587281)
33181 218540 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2 Rossmoor Dr 1 : 4 Tree 1 Private 1     7 Width 2ft   5991304.84344 2094334.7083700001 37.7301442506463 -122.472379149601 (37.7301442506463, -122.472379149601)
33587 198007 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 274 Shipley St 2 : 4 Tree 1 Private 1     1 Width 2ft   6011297.08858 2111564.84003 37.7785912185545 -122.404475379844 (37.7785912185545, -122.404475379844)
33686 241242 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1320 Stevenson St 1 : 4 Tree 1 Private 1     3 Width 2ft   6006249.62904 2109085.1733 37.771499282705605 -122.421760329799 (37.7714992827056, -122.421760329799)
33953 247763 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 55 Alpine Ter 1 : 4 Tree 1 Private 1     1 Width 5ft   6001651.1462 2108480.6901700003 37.769579132108205 -122.43762339851101 (37.7695791321082, -122.437623398511)
34019 218545 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 30 Elmhurst Dr 1 : 4 Tree 1 Private 1     6 Width 3ft   5991243.29595 2094455.3235900002 37.730471867362205 -122.47260071555799 (37.7304718673622, -122.472600715558)
35926 198013 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 950 Clara St 2 : 4 Tree 1 Private 1     5 Width 3ft   6011579.13499 2111530.21874 37.778511914541895 -122.403497231313 (37.7785119145419, -122.403497231313)
36358 198143 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1655 Jerrold Ave 2 : 4 Tree 1 Private 1     3 Width 3ft   6015049.24886 2097178.829 37.7392992978216 -122.390489638682 (37.7392992978216, -122.390489638682)
37341 218521 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 569 Victoria St 1 : 4 Tree 1 Private 1     2 Width 3ft   5993243.831619999 2090944.1329400002 37.7209465926795 -122.46542966546801 (37.7209465926795, -122.465429665468)
37453 198113 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 453 Mississippi St 1 : 4 Tree 1 Private 1     9 Width 3ft   6014103.66815 2105000.08777 37.760722311801096 -122.394306519737 (37.7607223118011, -122.394306519737)
37537 247760 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 67 Alpine Ter 1 : 4 Tree 1 Private 1     7 Width 3ft   6001664.39466 2108401.08395 37.769361306418 -122.43757187093901 (37.769361306418, -122.437571870939)
37759 241234 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 55 Duboce Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   6006307.196819999 2108475.9991099997 37.7698298819675 -122.42151792831801 (37.7698298819675, -122.421517928318)
38237 218573 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 95 Rossmoor Dr 2 : 4 Tree 1 Private 1     4 Width 3ft   5990744.9353 2094437.13782 37.73039307417179 -122.474322276075 (37.7303930741718, -122.474322276075)
38718 241233 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 121 Duboce Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   6005881.34596 2108456.5771 37.7697525330713 -122.422989557315 (37.7697525330713, -122.422989557315)
38834 202325 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 135 Orsi Cir 1 : 4 Tree 1 Private 1     4 Width 2ft   6012883.64623 2093069.27547 37.7278949409987 -122.39768921171199 (37.7278949409987, -122.397689211712)
38884 180226 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2901 Ocean Ave 2 : 4 Tree 1 Private 1     5 Width 3ft   5989906.43638 2095240.30742 37.7325497599557 -122.47727972718398 (37.7325497599557, -122.477279727184)
40089 198130 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 81 Topeka Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   6012344.64179 2095362.1885400002 37.7341607757888 -122.399713503797 (37.7341607757888, -122.399713503797)
40137 218559 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 65 Rossmoor Dr 1 : 4 Tree 1 Private 1     4 Width 3ft   5990923.4815 2094514.63427 37.730616202260705 -122.473710674116 (37.7306162022607, -122.473710674116)
40628 247798 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 436 30th St 1 : 4 Tree 1 Private 1     10 Width 3ft   6003746.333330001 2098382.8174900003 37.7419716683528 -122.429655927686 (37.7419716683528, -122.429655927686)
40931 218564 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 77 Rossmoor Dr 1 : 4 Tree 1 Private 1     4 Width 3ft   5990836.12868 2094496.30946 37.7305608273977 -122.47401132646401 (37.7305608273977, -122.474011326464)
40989 241240 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1301 Jessie St 5 : 4 Tree 1 Private 1     7 Width 2ft   6006461.320719999 2109025.58866 37.771347612922604 -122.42102384438101 (37.7713476129226, -122.421023844381)
41290 218537 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 169 Eucalyptus Dr 2 : 4 Tree 1 Private 1     3 Width 2ft   5991155.07657 2094656.4445 37.7310189879395 -122.47292035978901 (37.7310189879395, -122.472920359789)
41395 218560 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 65 Rossmoor Dr 2 : 4 Tree 1 Private 1     7 Width 3ft   5990937.78345 2094514.9257599998 37.730617830926796 -122.47366125186899 (37.7306178309268, -122.473661251869)
41570 247781 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 266 30th St 1 : 4 Tree 1 Private 1     9 Width 3ft   6004850.70069 2098447.83797 37.7422126713879 -122.425842004521 (37.7422126713879, -122.425842004521)
43133 180229 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3353 19th Ave 2 : 4 Tree 1 Private 1     3 Width 3ft   5990564.5240400005 2094381.66097 37.7302302950786 -122.47494192874201 (37.7302302950786, -122.474941928742)
43255 218551 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 60 Elmhurst Dr 1 : 4 Tree 1 Private 1     4 Width 3ft   5991187.9738300005 2094540.77517 37.730703293514 -122.47279819858 (37.730703293514, -122.47279819858)
43525 250638 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2609 Lake St 1 : 4 Tree 1 Private 1     1 Width 3ft   5987350.36914 2114602.8431 37.7855653557873 -122.487538422371 (37.7855653557873, -122.487538422371)
44252 218541 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2 Rossmoor Dr 2 : 4 Tree 1 Private 1     4 Width 2ft   5991287.109209999 2094336.12276 37.730147107779395 -122.47244056159401 (37.7301471077794, -122.472440561594)
44387 202306 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 160 Orsi Cir 1 : 4 Tree 1 Private 1     4 Width 2ft   6012951.54895 2092971.8033599998 37.7276310834963 -122.397447635807 (37.7276310834963, -122.397447635807)
44655 218546 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 25 Elmhurst Dr 5 : 4 Tree 1 Private 1     7 Width 3ft   5991216.07157 2094485.7269 37.730553771324 -122.472697049151 (37.730553771324, -122.472697049151)
45491 198139 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 150 Bridgeview Dr 1 : 4 Tree 1 Private 1     1 Width 3ft   6013283.18276 2095780.0515 37.735360415658704 -122.396497929253 (37.7353604156587, -122.396497929253)
45762 198117 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 500 Toland St 4 : 4 Tree 1 Private 1     3 Width 3ft   6012558.18705 2098832.22604 37.7437006707628 -122.39921870850401 (37.7437006707628, -122.399218708504)
45821 247817 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 564 30th St 1 : 4 Tree 1 Private 1     8 Width 3ft   6002957.26382 2098344.63275 37.7418221102078 -122.432381547978 (37.7418221102078, -122.432381547978)
46171 180230 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3353 19th Ave 3 : 4 Tree 1 Private 1     3 Width 3ft   5990563.35981 2094357.1779099999 37.7301630033059 -122.474944167152 (37.7301630033059, -122.474944167152)
47484 241647 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 50 Scott St 1 : 4 Tree 1 Private 1     6 Width 3ft   6002452.37921 2108374.6636099997 37.769333532638505 -122.434844382773 (37.7693335326385, -122.434844382773)
47751 201529 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 718 Innes Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   6020227.99181 2093752.40727 37.7301769329099 -122.372346575457 (37.7301769329099, -122.372346575457)
47758 198126 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 75 Williams Ave 6 : 4 Tree 1 Private 1     13 Width 3ft   6013842.551630001 2093605.35504 37.729420257733295 -122.394411747628 (37.7294202577333, -122.394411747628)
48210 217808 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 199 Lee Ave 3 : 4 Tree 1 Private 1     3 Width 3ft   5996522.50518 2091865.3991200002 37.7236647198324 -122.454162841049 (37.7236647198324, -122.454162841049)
48372 241235 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 55 Duboce Ave 2 : 4 Tree 1 Private 1     3 Width 3ft   6006333.55405 2108477.41029 37.7698352428425 -122.421426859387 (37.7698352428425, -122.421426859387)
48625 241557 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3750 Market St 2 : 4 Tree 1 Private 1     3 Width 3ft   6000178.6391 2102857.41231 37.7540551680289 -122.442312985266 (37.7540551680289, -122.442312985266)
48753 198110 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 500 Arkansas St 2 : 4 Tree 1 Private 1     5 Width 3ft   6012942.32537 2104667.3106299997 37.7597439555289 -122.398299761419 (37.7597439555289, -122.398299761419)
49427 85218 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 603 22nd Ave 1 : 4 Tree 1 Private 1   07/19/2007 12:00:00 AM 3   Permit Number 49541 5989075.71612 2111192.27037 37.7763013532486 -122.481319447652 (37.7763013532486, -122.481319447652)
49912 246603 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1 Waller St 5 : 4 Tree 1 Private 1     2 Width 4ft   6005584.08918 2109245.7263700003 37.7719025692852 -122.42407388970899 (37.7719025692852, -122.424073889709)
51043 218527 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 183 Eucalyptus Dr 1 : 4 Tree 1 Private 1     5 Width 3ft   5990817.95884 2094667.89607 37.7310309084509 -122.474086656376 (37.7310309084509, -122.474086656376)
52517 198125 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 75 Williams Ave 5 : 4 Tree 1 Private 1     9 Width 3ft   6013825.74476 2093610.0448599998 37.72943220072 -122.394470179266 (37.72943220072, -122.394470179266)
52578 198141 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 162 Bridgeview Dr 1 : 4 Tree 1 Private 1     7 Width 3ft   6013199.84699 2095813.32575 37.7354471417785 -122.396788385978 (37.7354471417785, -122.396788385978)
52791 198120 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1715 Silver Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   6011096.260480001 2095120.5890400002 37.7334277240045 -122.40401257884199 (37.7334277240045, -122.404012578842)
53379 241254 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 200 Guerrero St 4 : 4 Tree 1 Private 1     3 Width 2ft   6005428.00897 2107706.60063 37.767667686033896 -122.42450428455 (37.7676676860339, -122.42450428455)
53730 198131 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 171 Bridgeview Dr 1 : 4 Tree 1 Private 1     10 Width 2ft   6013157.52169 2095742.10645 37.7352492324546 -122.39692972971599 (37.7352492324546, -122.396929729716)
54019 218510 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 330 Lakeview Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   5996781.43157 2089689.53525 37.7177051527504 -122.453110785357 (37.7177051527504, -122.453110785357)
54285 247758 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 89 Alpine Ter 1 : 4 Tree 1 Private 1     6 Width 3ft   6001675.24031 2108330.5572200003 37.769168274117796 -122.43752930513 (37.7691682741178, -122.43752930513)
54848 218569 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 95 Rossmoor Dr 1 : 4 Tree 1 Private 1     6 Width 3ft   5990765.45397 2094449.75445 37.7304289049727 -122.474252261144 (37.7304289049727, -122.474252261144)
55148 247779 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 254 30th St 1 : 4 Tree 1 Private 1     6 Width 3ft   6004930.81683 2098452.72536 37.74223061823729 -122.42556533528999 (37.7422306182373, -122.42556533529)
55310 198023 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 336 07th St 1 : 4 Tree 1 Private 1     4 Width 3ft   6010479.15286 2110685.94265 37.776132227452706 -122.407242974182 (37.7761322274527, -122.407242974182)
55328 241558 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 184 Marview Way 1 : 4 Tree 1 Private 1     2 Width 3ft   5998169.83766 2103394.0693099997 37.7554139986847 -122.449298535803 (37.7554139986847, -122.449298535803)
55453 218520 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 286 Ramsell St 1 : 4 Tree 1 Private 1     5 Width 3ft   5992992.28014 2089088.20524 37.7158361528844 -122.466164394478 (37.7158361528844, -122.466164394478)
56078 180232 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3353 19th Ave 5 : 4 Tree 1 Private 1     3 Width 3ft   5990560.881159999 2094301.1206099999 37.7300089404634 -122.47494864576001 (37.7300089404634, -122.47494864576)
56527 201482 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 801 Arelious Walker Dr 1 : 4 Tree 1 Private 1     4 Width 3ft   6019833.06925 2094138.86397 37.731216363049704 -122.373738644125 (37.7312163630497, -122.373738644125)
57715 241248 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1346 Stevenson St 1 : 4 Tree 1 Private 1     7 Width 2ft   6006262.59994 2108856.22438 37.7708713751436 -122.421699198355 (37.7708713751436, -122.421699198355)
58256 247669 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 154 Divisadero St 1 : 4 Tree 1 Private 1     1 Width 3ft   6001934.24111 2108541.81832 37.7697630668318 -122.436648561282 (37.7697630668318, -122.436648561282)
58259 241644 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 415 Oak St 1 : 4 Tree 1 Private 1     5 Width 5ft   6004982.83626 2110199.4621900003 37.774487331444895 -122.426221580476 (37.7744873314449, -122.426221580476)
58775 202307 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 172 Orsi Cir 1 : 4 Tree 1 Private 1     3 Width 2ft   6012991.60594 2092941.53695 37.7275502083622 -122.397307035804 (37.7275502083622, -122.397307035804)
59731 218550 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 25 Elmhurst Dr 1 : 4 Tree 1 Private 1     5 Width 3ft   5991159.53615 2094513.6265200002 37.7306271038561 -122.472894532173 (37.7306271038561, -122.472894532173)
60837 218562 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 71 Rossmoor Dr 1 : 4 Tree 1 Private 1     5 Width 3ft   5990887.70773 2094513.01623 37.730609687575495 -122.473834230193 (37.7306096875755, -122.473834230193)
61188 198016 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 950 Clara St 5 : 4 Tree 1 Private 1     4 Width 2ft   6011600.73372 2111552.6255799998 37.7785746449277 -122.40342408946199 (37.7785746449277, -122.403424089462)
61357 198106 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 878 Rhode Island St 2 : 4 Tree 1 Private 1     7 Width 3ft   6011838.88261 2104286.50365 37.7586368163639 -122.40208927521999 (37.7586368163639, -122.40208927522)
61703 217809 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 199 Lee Ave 4 : 4 Tree 1 Private 1     3 Width 3ft   5996519.87412 2091846.99673 37.7236140403522 -122.454170607597 (37.7236140403522, -122.454170607597)
62105 241229 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 291 Duboce Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   6004995.489019999 2108399.8809 37.769546832063 -122.426049676848 (37.769546832063, -122.426049676848)
62659 201486 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 934 Innes Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   6019032.21192 2094642.96183 37.7325564518085 -122.376542332772 (37.7325564518085, -122.376542332772)
62688 198132 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 151 Bridgeview Dr 1 : 4 Tree 1 Private 1     10 Width 2ft   6013262.28061 2095747.20787 37.7352690706072 -122.39656789470101 (37.7352690706072, -122.396567894701)
62876 218524 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 213 Bright St 1 : 4 Tree 1 Private 1     3 Width 3ft   5993735.17777 2088595.3117 37.7145256185467 -122.463560865244 (37.7145256185467, -122.463560865244)
63123 198020 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 217 Clara St 1 : 4 Tree 1 Private 1     1 Width 3ft   6011870.90395 2111808.74197 37.7792929676258 -122.402507476166 (37.7792929676258, -122.402507476166)

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 1546.188ms · Data source: data.sfgov.org