Street_Tree_List

Data source: data.sfgov.org

174 rows where qSiteInfo = 9 and qSpecies = 1 sorted by Longitude

View and edit SQL

Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize

qSiteInfo

  • Sidewalk: Property side : Yard · 174
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
161967 186844 Undocumented 2 Myoporum laetum :: Myoporum 1 2034 Lower Great Hwy 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5981219.1453 2101186.094 37.7483673667876 -122.507754314909 (37.7483673667876, -122.507754314909)
58922 185743 Undocumented 2 Myoporum laetum :: Myoporum 1 2120 Lower Great Hwy 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5981266.2638 2100624.5993 37.7468284358609 -122.507549726279 (37.7468284358609, -122.507549726279)
77363 185742 Undocumented 2 Myoporum laetum :: Myoporum 1 2120 Lower Great Hwy 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5981267.7362 2100613.3105 37.7467975267188 -122.507543797463 (37.7467975267188, -122.507543797463)
49556 185768 Undocumented 2 Myoporum laetum :: Myoporum 1 2100 Lower Great Hwy 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5981299.1485 2100269.7385 37.7458560246461 -122.507409691662 (37.7458560246461, -122.507409691662)
179465 118837 Undocumented 2 Myoporum laetum :: Myoporum 1 600 46th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 5ft   5981666.867000001 2111590.99028 37.776962590483606 -122.506977842076 (37.7769625904836, -122.506977842076)
188122 184539 Undocumented 2 Myoporum laetum :: Myoporum 1 1939 47th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 0ft   5981627.7505 2101868.0843 37.7502639852004 -122.50639195948 (37.7502639852004, -122.50639195948)
154803 184534 Undocumented 2 Myoporum laetum :: Myoporum 1 1906 47th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5981676.8437 2102069.7342 37.7508205493518 -122.506237145813 (37.7508205493518, -122.506237145813)
152167 184536 Undocumented 2 Myoporum laetum :: Myoporum 1 1918 47th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5981680.2279 2102012.5409 37.7506637118715 -122.50622120268801 (37.7506637118715, -122.506221202688)
106681 97654 Permitted Site 1 Myoporum laetum :: Myoporum 1 2331 47th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5981707.8 2099208.6 37.7429664967596 -122.505917998204 (37.7429664967596, -122.505917998204)
74793 184498 Undocumented 2 Myoporum laetum :: Myoporum 1 1875 44th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 0ft   5982546.757 2102373.8062 37.751706619904596 -122.503251468292 (37.7517066199046, -122.503251468292)
76120 184497 Undocumented 2 Myoporum laetum :: Myoporum 1 1871 44th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 0ft   5982548.7875 2102393.4347 37.751760633629 -122.503245899839 (37.751760633629, -122.503245899839)
58476 184827 Undocumented 2 Myoporum laetum :: Myoporum 1 1201 Sunset Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984631.5936 2106907.2141 37.764276427718 -122.49637641074301 (37.764276427718, -122.496376410743)
72243 184831 Undocumented 2 Myoporum laetum :: Myoporum 1 1201 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984632.352999999 2106892.4051 37.76423581086029 -122.496372691447 (37.7642358108603, -122.496372691447)
120079 186675 Undocumented 2 Myoporum laetum :: Myoporum 1 1401 Sunset Blvd 32 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984701.897000001 2105453.5805 37.760289275720204 -122.496026006908 (37.7602892757202, -122.496026006908)
131528 186676 Undocumented 2 Myoporum laetum :: Myoporum 1 1401 Sunset Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984702.3158 2105448.5558 37.76027550382771 -122.496024187798 (37.7602755038277, -122.496024187798)
122028 186674 Undocumented 2 Myoporum laetum :: Myoporum 1 1401 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984709.4341 2105459.8614 37.760306962768205 -122.49600040337201 (37.7603069627682, -122.496000403372)
129592 186830 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 93 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984826.8059 2106580.9981 37.7633921640535 -122.49567717299999 (37.7633921640535, -122.495677173)
46675 186799 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 77 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984838.6936 2106905.4238 37.764283642033 -122.495659989112 (37.764283642033, -122.495659989112)
46399 186797 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 75 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984845.6856 2106903.6111 37.7642790743182 -122.495635672409 (37.7642790743182, -122.495635672409)
182075 186798 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 76 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984847.2394 2106906.9776 37.7642884087703 -122.495630546663 (37.7642884087703, -122.495630546663)
55566 186757 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984856.9891 2106704.9578 37.7637342900898 -122.49558192416201 (37.7637342900898, -122.495581924162)
181337 186724 Undocumented 2 Myoporum laetum :: Myoporum 1 1300 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 0ft   5984849.7405 2106204.9407 37.762360958924106 -122.49557011228998 (37.7623609589241, -122.49557011229)
189002 186741 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984866.449 2106632.432 37.7635357085517 -122.495543856208 (37.7635357085517, -122.495543856208)
177097 181430 Undocumented 2 Myoporum laetum :: Myoporum 1 1500 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984894.5136 2104851.8242 37.7586483004402 -122.495315467353 (37.7586483004402, -122.495315467353)
133386 181383 Undocumented 2 Myoporum laetum :: Myoporum 1 1500 Sunset Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984896.421 2104481.2352 37.757630877743395 -122.495281541299 (37.7576308777434, -122.495281541299)
64716 181389 Undocumented 2 Myoporum laetum :: Myoporum 1 1500 Sunset Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984901.4336 2104544.1716 37.7578039770978 -122.495268847164 (37.7578039770978, -122.495268847164)
30884 181424 Undocumented 2 Myoporum laetum :: Myoporum 1 1500 Sunset Blvd 57 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984916.7919 2104797.7992 37.7585012671882 -122.495234435961 (37.7585012671882, -122.495234435961)
47839 185966 Undocumented 2 Myoporum laetum :: Myoporum 1 2001 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984856.249 2101288.6271 37.7488625039545 -122.49518504258499 (37.7488625039545, -122.495185042585)
31980 185695 Undocumented 2 Myoporum laetum :: Myoporum 1 2101 Sunset Blvd 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984855.8577 2100528.9081 37.74677650012389 -122.49513038098499 (37.7467765001239, -122.495130380985)
46239 185697 Undocumented 2 Myoporum laetum :: Myoporum 1 2101 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984860.4343 2100522.6969999997 37.746759714071004 -122.49511409785102 (37.746759714071, -122.495114097851)
37732 185698 Undocumented 2 Myoporum laetum :: Myoporum 1 2101 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984860.7612 2100520.7355 37.7467543474647 -122.495112822862 (37.7467543474647, -122.495112822862)
182170 185694 Undocumented 2 Myoporum laetum :: Myoporum 1 2101 Sunset Blvd 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984861.0881 2100529.8889 37.7467794993444 -122.495112367353 (37.7467794993444, -122.495112367353)
149963 187179 Undocumented 2 Myoporum laetum :: Myoporum 1 2301 Sunset Blvd 41 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5984914.0932 2099227.6174 37.7432069184805 -122.494833083055 (37.7432069184805, -122.494833083055)
48124 186292 Undocumented 2 Myoporum laetum :: Myoporum 1 1800 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984989.7259 2102642.6308 37.752588040554 -122.494823302768 (37.752588040554, -122.494823302768)
75945 186277 Undocumented 2 Myoporum laetum :: Myoporum 1 1800 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984988.115 2102492.8167 37.7521765979364 -122.494817828718 (37.7521765979364, -122.494817828718)
171452 187152 Undocumented 2 Myoporum laetum :: Myoporum 1 2301 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984930.5747 2099438.914 37.7437880464665 -122.494791670453 (37.7437880464665, -122.494791670453)
45849 185928 Undocumented 2 Myoporum laetum :: Myoporum 1 2000 Sunset Blvd 71 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5985021.4097 2101486.4323 37.7494152911337 -122.494628506041 (37.7494152911337, -122.494628506041)
66632 185873 Undocumented 2 Myoporum laetum :: Myoporum 1 2000 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5985024.9554 2101062.8913 37.748252570783 -122.49458502538401 (37.748252570783, -122.494585025384)
136974 185882 Undocumented 2 Myoporum laetum :: Myoporum 1 2000 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5985026.8493 2101115.2901 37.7483965544335 -122.494582338742 (37.7483965544335, -122.494582338742)
130581 187395 Undocumented 2 Myoporum laetum :: Myoporum 1 2100 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985039.3656 2100676.2331 37.7471917561772 -122.494506696584 (37.7471917561772, -122.494506696584)
71005 185626 Undocumented 2 Myoporum laetum :: Myoporum 1 2100 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985032.562000001 2100322.7551 37.7462208035944 -122.494504169101 (37.7462208035944, -122.494504169101)
146470 185630 Undocumented 2 Myoporum laetum :: Myoporum 1 2100 Sunset Blvd 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5985046.8517 2100330.1165 37.74624185231129 -122.494455300367 (37.7462418523113, -122.494455300367)
136891 187355 Undocumented 2 Myoporum laetum :: Myoporum 1 2200 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5985062.7652 2099776.5974 37.744722970464395 -122.494359480034 (37.7447229704644, -122.494359480034)
137429 187354 Undocumented 2 Myoporum laetum :: Myoporum 1 2200 Sunset Blvd 39 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985070.2132 2099768.1337 37.7447001673089 -122.49433310291401 (37.7447001673089, -122.494333102914)
150906 184983 Undocumented 2 Myoporum laetum :: Myoporum 1 2701 Sunset Blvd 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5985011.3339 2096668.7562 37.7361866651853 -122.49430828045601 (37.7361866651853, -122.494308280456)
63057 185078 Undocumented 2 Myoporum laetum :: Myoporum 1 2801 Sunset Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5985022.8488 2096075.8434 37.7345593586675 -122.494224780664 (37.7345593586675, -122.494224780664)
168081 185107 Undocumented 2 Myoporum laetum :: Myoporum 1 2801 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5985026.6173 2095934.5241 37.73417155402829 -122.49420133916 (37.7341715540283, -122.49420133916)
45881 210469 Undocumented 2 Myoporum laetum :: Myoporum 1 1746 Noriega St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 5ft   5991258.53148 2103577.67743 37.7555203884603 -122.47321309092399 (37.7555203884603, -122.473213090924)
48697 177826 Undocumented 2 Myoporum laetum :: Myoporum 1 89 Belle Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   5991639.3875 2086487.5926299999 37.708617351468895 -122.47065126593999 (37.7086173514689, -122.47065126594)
27203 210530 Undocumented 2 Myoporum laetum :: Myoporum 1 717 Sargent St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 6ft   5992156.75064 2089178.54268 37.7160359561589 -122.46905891645399 (37.7160359561589, -122.469058916454)
59099 210525 Undocumented 2 Myoporum laetum :: Myoporum 1 489 Vernon St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5992458.06658 2091088.62387 37.7212979802935 -122.46815630197901 (37.7212979802935, -122.468156301979)
117949 98373 Undocumented 2 Myoporum laetum :: Myoporum 1 701@ de Soto Urbano Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5993201.0 2091808.0 37.7233160913053 -122.46564044909799 (37.7233160913053, -122.465640449098)
99055 98374 Undocumented 2 Myoporum laetum :: Myoporum 1 106 De Soto St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5993231.0 2091825.0 37.7233644995117 -122.465537980019 (37.7233644995117, -122.465537980019)
105502 98375 Undocumented 2 Myoporum laetum :: Myoporum 1 106 De Soto St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5993231.0 2091825.0 37.7233644995117 -122.465537980019 (37.7233644995117, -122.465537980019)
74293 210566 Undocumented 2 Myoporum laetum :: Myoporum 1 739 Ulloa St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   5993848.55082 2098110.04723 37.7406572903047 -122.463859221646 (37.7406572903047, -122.463859221646)
133947 210553 Undocumented 2 Myoporum laetum :: Myoporum 1 6 Locksley Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 3ft   5994306.7966 2105015.90747 37.75964542581129 -122.462775658193 (37.7596454258113, -122.462775658193)
27011 210522 Undocumented 2 Myoporum laetum :: Myoporum 1 800 Capitol Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   5995082.26055 2089674.2189 37.717565568077504 -122.45898290776 (37.7175655680775, -122.45898290776)
150167 210559 Undocumented 2 Myoporum laetum :: Myoporum 1 140 Hernandez Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 3ft   5995558.80371 2099639.21584 37.744954417407705 -122.45805649901699 (37.7449544174077, -122.458056499017)
24757 210558 Undocumented 2 Myoporum laetum :: Myoporum 1 140 Hernandez Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     27 Width 3ft   5995578.737319999 2099631.293 37.7449338085654 -122.457986999419 (37.7449338085654, -122.457986999419)
38798 131726 Undocumented 2 Myoporum laetum :: Myoporum 1 58 Iris Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 5ft   5997639.46293 2114124.8782099998 37.7848476941144 -122.451906844923 (37.7848476941144, -122.451906844923)
135025 210515 Undocumented 2 Myoporum laetum :: Myoporum 1 443 Gennessee St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     5997431.02942 2094954.3994200001 37.732198438912604 -122.451244915116 (37.7321984389126, -122.451244915116)
70891 131716 Undocumented 2 Myoporum laetum :: Myoporum 1 3250 Pacific Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 3ft   5998485.19807 2116566.1841 37.7915992797271 -122.449156826952 (37.7915992797271, -122.449156826952)
135456 131715 Undocumented 2 Myoporum laetum :: Myoporum 1 3250 Pacific Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5998491.43186 2116566.313 37.791599990194705 -122.449135267491 (37.7915999901947, -122.449135267491)
184453 131714 Undocumented 2 Myoporum laetum :: Myoporum 1 3250 Pacific Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5998496.90584 2116567.36238 37.791603184595104 -122.44911640329398 (37.7916031845951, -122.449116403294)
179582 131713 Undocumented 2 Myoporum laetum :: Myoporum 1 3250 Pacific Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   5998501.34187 2116568.43338 37.791606378991 -122.449101131933 (37.791606378991, -122.449101131933)
41556 131712 Undocumented 2 Myoporum laetum :: Myoporum 1 3250 Pacific Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5998504.875 2116569.78161 37.7916102829449 -122.449089004562 (37.7916102829449, -122.449089004562)
107866 112769 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111205 112771 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111811 112770 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
112482 112773 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
115212 112774 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
121815 112772 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
162072 210516 Undocumented 2 Myoporum laetum :: Myoporum 1 212 Staples Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32     5998671.88838 2093815.67028 37.7291427269309 -122.44687309392401 (37.7291427269309, -122.446873093924)
159389 210517 Undocumented 2 Myoporum laetum :: Myoporum 1 212 Staples Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     5998717.163269999 2093815.2255099998 37.7291440921051 -122.44671654353998 (37.7291440921051, -122.44671654354)
78648 112011 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
80283 112014 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
81019 112013 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
82492 112009 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
84128 112015 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
90475 112007 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
93993 112012 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
95977 112005 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
113702 112010 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
117009 112004 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
121140 112006 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
127458 112008 Undocumented 2 Myoporum laetum :: Myoporum 1 115 Red Rock Way   Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
120273 113891 Undocumented 2 Myoporum laetum :: Myoporum 1 1x STORRIE ST 3 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     12     6000722.0 2105303.0 37.76080110933629 -122.440609317727 (37.7608011093363, -122.440609317727)
173881 232322 Undocumented 2 Myoporum laetum :: Myoporum 1 1430 Douglass St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 6ft   6001368.29061 2099487.1068599997 37.7448688460173 -122.437957499335 (37.7448688460173, -122.437957499335)
125466 110020   Myoporum laetum :: Myoporum 1 1490X Douglass St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       9x9   6001386.81709 2099547.0285 37.745034430207795 -122.437897729467 (37.7450344302078, -122.437897729467)
53387 232323 Undocumented 2 Myoporum laetum :: Myoporum 1 689 28th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 8ft   6001401.88129 2099374.4805 37.7445615107998 -122.43783328409599 (37.7445615107998, -122.437833284096)
54124 232324 Undocumented 2 Myoporum laetum :: Myoporum 1 689 28th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 8ft   6001424.417119999 2099374.2637099996 37.7445621969905 -122.437755344346 (37.7445621969905, -122.437755344346)
66158 232325 Undocumented 2 Myoporum laetum :: Myoporum 1 689 28th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 8ft   6001461.4288099995 2099378.40597 37.7445756751258 -122.43762766218599 (37.7445756751258, -122.437627662186)
68612 232326 Undocumented 2 Myoporum laetum :: Myoporum 1 683 28th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 8ft   6001524.1187 2099381.75589 37.744588437417 -122.43741113332199 (37.744588437417, -122.437411133322)
63737 232410 Undocumented 2 Myoporum laetum :: Myoporum 1 395 Addison St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21     6001971.32528 2097704.62819 37.7400088512382 -122.43574481549601 (37.7400088512382, -122.435744815496)
156154 232331 Undocumented 2 Myoporum laetum :: Myoporum 1 1801 Diamond St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 6ft   6002072.189119999 2098811.70513 37.7430543549658 -122.43547524639999 (37.7430543549658, -122.4354752464)
24344 232330 Undocumented 2 Myoporum laetum :: Myoporum 1 1801 Diamond St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   6002073.993430001 2098798.17814 37.743017315492295 -122.435468040134 (37.7430173154923, -122.435468040134)
160197 232329 Undocumented 2 Myoporum laetum :: Myoporum 1 1801 Diamond St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   6002075.1191 2098772.01072 37.7429455298129 -122.435462276374 (37.7429455298129, -122.435462276374)
180202 232328 Undocumented 2 Myoporum laetum :: Myoporum 1 1801 Diamond St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 6ft   6002075.48932 2098744.22684 37.742869262806295 -122.435459009147 (37.7428692628063, -122.435459009147)
159667 232337 Undocumented 2 Myoporum laetum :: Myoporum 1 691 29th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6002080.83526 2098827.25693 37.743097547618 -122.43544646269501 (37.743097547618, -122.435446462695)
39656 232338 Undocumented 2 Myoporum laetum :: Myoporum 1 691 29th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6002085.619519999 2098828.73569 37.743101879661396 -122.43543002579399 (37.7431018796614, -122.435430025794)

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