Street_Tree_List

Data source: data.sfgov.org

209 rows where SiteOrder = 3 and qSpecies = 55 sorted by qSiteInfo

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize

SiteOrder

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
262 141360 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1499X Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
323 27392 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2240 Hyde St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6007139.14869 2120046.64789 37.801646927424706 -122.419461214785 (37.8016469274247, -122.419461214785)
1858 12328 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1025 Laguna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6004756.1585 2112422.6893 37.780578952523996 -122.427164094387 (37.780578952524, -122.427164094387)
2010 142062 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1100 Golden Gate Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   01/02/2014 12:00:00 AM 10 Width 0ft Permit Number 771276 6004214.4178 2112228.4 37.780014831771 -122.429024376887 (37.780014831771, -122.429024376887)
2240 122755 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 693 Vermont St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   14     6011274.22678 2105356.76628 37.7615439863765 -122.40411744427601 (37.7615439863765, -122.404117444276)
2249 191500 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1196 La Salle Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 3ft   6016876.9140800005 2094649.78681 37.732456273623704 -122.38399426453998 (37.7324562736237, -122.38399426454)
2918 140306 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2084 HAYES ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5997911.1716 2109955.9635 37.773416499401705 -122.450666152059 (37.7734164994017, -122.450666152059)
3258 253374 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
3852 244053 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 401 Cole St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5997903.1431 2109164.16 37.7712419510675 -122.450636826227 (37.7712419510675, -122.450636826227)
4593 129647 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2210 Stockton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009820.66032 2121686.06094 37.80629901694589 -122.41029773825899 (37.8062990169459, -122.410297738259)
6106 7959 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1800 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005709.66614 2116337.52814 37.791382005314 -122.424143948706 (37.791382005314, -122.424143948706)
7129 20204 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1315 Steiner St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6002765.7195 2112737.651 37.7813309972121 -122.434072484072 (37.7813309972121, -122.434072484072)
7677 11437 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2100X Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6005576.77796 2117294.0070599997 37.7940007519905 -122.42467181025499 (37.7940007519905, -122.424671810255)
11530 77642 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1300X Silliman St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/26/1984 12:00:00 AM 12 4x4   6006942.1040900005 2093179.9332599998 37.7278661320969 -122.418237156514 (37.7278661320969, -122.418237156514)
13198 25303 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 286 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x9   5999775.2112 2091625.73202 37.7231926324273 -122.4429016302 (37.7231926324273, -122.4429016302)
14433 17144 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1030 Oakdale Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/30/1997 12:00:00 AM 3 3X3   6017899.57967 2093362.5240900002 37.728978186084 -122.38036919809099 (37.728978186084, -122.380369198091)
16260 25705 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 564 06th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 2X2   6012100.37031 2110300.97089 37.7751657827012 -122.40160764957399 (37.7751657827012, -122.401607649574)
21469 15341 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1735 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6006768.902000001 2108274.3401 37.769302196475294 -122.419906586242 (37.7693021964753, -122.419906586242)
24247 227356 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 701 Ogden Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6007559.31004 2096165.80664 37.7360994137559 -122.41631485115101 (37.7360994137559, -122.416314851151)
24746 207954 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 20 Sotelo Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994065.04944 2100893.3637099997 37.7483120506561 -122.46331257952801 (37.7483120506561, -122.463312579528)
26130 207916 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 Pacheco St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5994697.354069999 2099701.1071099997 37.7450748213407 -122.46103969864201 (37.7450748213407, -122.461039698642)
26336 129613 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 711 Taylor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6009198.53973 2115384.83404 37.7889625079688 -122.412005118241 (37.7889625079688, -122.412005118241)
28015 227442 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4200 20th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002319.53063 2104152.62296 37.7577332935784 -122.435001901726 (37.7577332935784, -122.435001901726)
28037 226729 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3659 20th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6005899.1239599995 2104305.56232 37.758355830368096 -122.422633042687 (37.7583558303681, -122.422633042687)
28195 191490 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 190 09th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008642.47534 2110374.13795 37.775173122971296 -122.41357449906299 (37.7751731229713, -122.413574499063)
29762 191469 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 Jack London Aly 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014280.37989 2112692.06341 37.7818525865622 -122.39423389317699 (37.7818525865622, -122.394233893177)
30046 227374 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 395 Bartlett St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6006788.4113 2101535.34281 37.7507995754546 -122.419360968246 (37.7507995754546, -122.419360968246)
30331 177074 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 250 Blanken Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6012293.95082 2087148.96015 37.711606095404704 -122.399312384552 (37.7116060954047, -122.399312384552)
32273 227514 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1175 Stevenson St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6006464.67083 2109591.57876 37.7729018752621 -122.42105245002399 (37.7729018752621, -122.421052450024)
32506 227216 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 775 Alabama St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6009109.62388 2104630.73399 37.7594292836568 -122.41155264863 (37.7594292836568, -122.41155264863)
32666 245945 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 97 Downey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5998847.6292 2107686.9313 37.7672398720062 -122.44726348656 (37.7672398720062, -122.44726348656)
32769 226755 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 209 Day St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004144.01902 2098653.98264 37.7427387360976 -122.428300179912 (37.7427387360976, -122.428300179912)
33447 208010 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 126 Edna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5998766.05843 2093398.5760400002 37.728002863243205 -122.446517546066 (37.7280028632432, -122.446517546066)
33606 207898 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 450 Wawona St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5991548.15864 2097071.69595 37.7376734080929 -122.471737369979 (37.7376734080929, -122.471737369979)
33838 129561 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3299 Scott St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6000845.88514 2119539.08728 37.7998968278242 -122.44120229016501 (37.7998968278242, -122.441202290165)
33915 98646 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2110 Greenwich St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4   8 5x5   6002771.23879 2119243.65965 37.799195144410795 -122.43451871576099 (37.7991951444108, -122.434518715761)
34291 207820 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 298 Staples Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5998217.897469999 2093812.4595700002 37.729107964547794 -122.44844233986099 (37.7291079645478, -122.448442339861)
34352 227426 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4681 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6000732.63696 2104644.90008 37.7589947339321 -122.440525327306 (37.7589947339321, -122.440525327306)
35298 207929 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 101 San Ramon Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5995760.63845 2092696.4312900002 37.7259028185378 -122.45685654350599 (37.7259028185378, -122.456856543506)
36975 177081 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 299 Blanken Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6012270.95689 2087199.0340099998 37.711742306725995 -122.39939537131 (37.711742306726, -122.39939537131)
39043 191474 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 135 South Park 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6014326.7569699995 2112466.04784 37.781234576959896 -122.39405762156 (37.7812345769599, -122.39405762156)
39732 140575 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1221 McAllister St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6003289.1195 2111701.1038 37.7785145879996 -122.43218773018499 (37.7785145879996, -122.432187730185)
40608 129578 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2434 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6000794.176109999 2116746.49388 37.7922261557494 -122.441180751388 (37.7922261557494, -122.441180751388)
46122 191503 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 15 Baldwin Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6017915.59707 2093553.456 37.7295033317063 -122.380327088241 (37.7295033317063, -122.380327088241)
47937 37498 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 645 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/22/1998 12:00:00 AM 10   Permit Number 39964 6010355.28098 2115804.39021 37.790179340162794 -122.40803252947201 (37.7901793401628, -122.408032529472)
49205 129595 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1730 Jackson St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6005777.14779 2117244.21265 37.793875343329795 -122.42397496697599 (37.7938753433298, -122.423974966976)
49343 227489 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 363 Waller St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6004002.39724 2109025.74245 37.7712091182481 -122.42952938408199 (37.7712091182481, -122.429529384082)
49898 129598 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2111 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6005541.322269999 2117252.79941 37.7938856036766 -122.42479155769101 (37.7938856036766, -122.424791557691)
51847 191496 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1198 La Salle Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6016644.61171 2094800.97865 37.732858570949205 -122.38480792526899 (37.7328585709492, -122.384807925269)
52188 36155 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 70 Commonwealth Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1998 12:00:00 AM 6   Permit Number 39238 5996549.1283 2114145.8086 37.784842652821496 -122.45568053932399 (37.7848426528215, -122.455680539324)
53062 201240 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 832 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6011987.3715 2112559.9702 37.781362167572205 -122.402157393633 (37.7813621675722, -122.402157393633)
53485 227366 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 176 Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008045.71887 2101127.40788 37.749750211412604 -122.41498420258002 (37.7497502114126, -122.41498420258)
54644 227344 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3915 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008419.04093 2096682.95648 37.7375677017941 -122.413378963976 (37.7375677017941, -122.413378963976)
55331 177080 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 411 Blanken Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6012673.3507900005 2087069.8441 37.7114099964555 -122.397995521673 (37.7114099964555, -122.397995521673)
59557 142177 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1490 Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6000750.4323 2110355.4784 37.7746755766034 -122.44087343567 (37.7746755766034, -122.44087343567)
60067 207405 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2692 16th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5991464.745630001 2097109.88885 37.737773449589795 -122.47202854890499 (37.7377734495898, -122.472028548905)
60162 244025 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1849 Page St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   5997747.9602 2108846.3652 37.7703604843866 -122.451150685898 (37.7703604843866, -122.451150685898)
60721 245070 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 6 Lyon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6000404.9733 2108969.9375 37.7708515497475 -122.441968974427 (37.7708515497475, -122.441968974427)
61290 227360 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 790 Alabama St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6009074.13968 2104572.98929 37.7592687393775 -122.41167129082301 (37.7592687393775, -122.411671290823)
63493 227262 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1334 Douglass St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6001352.76553 2099787.74958 37.745693456895204 -122.43803271325001 (37.7456934568952, -122.43803271325)
65316 191478 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 33 South Park 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6014500.76851 2112629.04154 37.781691790478796 -122.39346703317499 (37.7816917904788, -122.393467033175)
67542 200695 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1603 Newcomb Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6015131.4073 2095732.6408 37.735332917815704 -122.39010456562599 (37.7353329178157, -122.390104565626)
69900 141422 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 550 IVY ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6004543.5906 2111042.8919 37.7767783457628 -122.42780112527001 (37.7767783457628, -122.42780112527)
71249 227183 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 833 Ashbury St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5999115.77081 2107425.5617299997 37.7665375350105 -122.446317222982 (37.7665375350105, -122.446317222982)
76192 191481 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 526 05th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6012554.15249 2111142.6647900003 37.777502192597495 -122.40009702957799 (37.7775021925975, -122.400097029578)
78963 12206 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1365X La Salle Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016707.244956 2094751.5031778 37.7327261850679 -122.38458793904199 (37.7327261850679, -122.384587939042)
79769 113436 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 198x HIGHLAND AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
80636 33769 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 3101 20th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 37819 6009092.65010174 2104478.80438725 37.759011167375796 -122.41160061802 (37.7590111673758, -122.41160061802)
80698 12309 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 949 Laguna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6004806.2528800005 2112097.03189 37.7796876103034 -122.426967593325 (37.7796876103034, -122.426967593325)
80877 25291 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 136 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6000743.1124599995 2091772.81119 37.7236516133979 -122.439566330441 (37.7236516133979, -122.439566330441)
82008 105875 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2X 27th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006029.156359999 2100240.43464 37.7472012619439 -122.421894571047 (37.7472012619439, -122.421894571047)
82162 20277 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2291 Stockton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X2   6009755.789969999 2121736.88906 37.8064349417299 -122.410525825802 (37.8064349417299, -122.410525825802)
82533 42985 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2X Yale St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 09/16/2000 12:00:00 AM 12 9x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
82832 6003 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1680 Eddy St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/2009 12:00:00 AM 12 3x3 Permit Number 52927 6002410.467190799 2112668.0181364 37.7811196348904 -122.43529649933501 (37.7811196348904, -122.435296499335)
84373 12120 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1325X La Salle Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6016848.207852599 2094661.9057693002 37.732487962838604 -122.38409435335 (37.7324879628386, -122.38409435335)
84994 89034 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 272 Main St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 51778 6014884.0 2115520.0 37.7896509872655 -122.392343484767 (37.7896509872655, -122.392343484767)
86507 105174 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1601X NEWCOMB AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Arts Commission 19     40 3x3 Permit Number 770204 6015135.0 2095759.0 37.735405494081505 -122.390093985074 (37.7354054940815, -122.390093985074)
89620 114798 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 103 Grattan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998130.990703201 2106502.59817932 37.7639470183873 -122.44965687078998 (37.7639470183873, -122.44965687079)
89649 27488 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2113 Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005940.11472 2117615.5981 37.7949042735724 -122.42343749988899 (37.7949042735724, -122.423437499889)
89702 20267 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2211 Stockton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X2   6009744.4688 2121738.42252 37.8064385175351 -122.41056511327 (37.8064385175351, -122.41056511327)
96962 12285 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 803X Laguna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6004627.99576 2111737.28964 37.7786897656705 -122.427558625827 (37.7786897656705, -122.427558625827)
97255 110187 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 625 Holly Park Cir 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4           6006167.62160945 2096413.49051844 37.736701142359294 -122.421144072665 (37.7367011423593, -122.421144072665)
97683 98677 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 199X Park St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
98083 10181 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1097X Guerrero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6005777.346268901 2102574.3880576002 37.753595557271 -122.422931166019 (37.753595557271, -122.422931166019)
98674 37252 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 4200 20th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1998 12:00:00 AM     Permit Number 39805 6002396.16255256 2104159.25249428 37.7577558475859 -122.434737351341 (37.7577558475859, -122.434737351341)
99189 20272 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2290 Stockton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/29/2005 12:00:00 AM 3 2X2   6009846.48172 2121764.7141400003 37.8065164263834 -122.41021393510599 (37.8065164263834, -122.410213935106)
99318 5483 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 700X Dolores St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   04/28/2008 12:00:00 AM 6 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
100018 78992 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 450X Banks St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
102161 103603 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 100X Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/2015 12:00:00 AM 3 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218)
102300 35728 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 190 Dartmouth St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/14/1998 12:00:00 AM     Permit Number 39007 6008565.46175199 2093223.89460892 37.7280780839519 -122.41262825854099 (37.7280780839519, -122.412628258541)
104609 121041 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2101 Polk St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006363.0 2118098.0 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697)
105226 138704 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2521 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6001167.2865 2114524.96 37.786147644599 -122.439730444644 (37.786147644599, -122.439730444644)
106702 10129 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 892 Guerrero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   6005646.9391641 2103763.6492254 37.7568536327232 -122.42346668441999 (37.7568536327232, -122.42346668442)
107948 8121 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 850X Fulton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6003699.00422 2111459.33104 37.777873970946295 -122.43075252591801 (37.7778739709463, -122.430752525918)
108877 107463 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1629 Taylor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008753.83856 2118472.3887 37.7974152162793 -122.413762212943 (37.7974152162793, -122.413762212943)
114668 14799 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1135 McAllister St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003745.74789 2111758.98852 37.778699404291395 -122.43061221122801 (37.7786994042914, -122.430612211228)
115150 96700 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1849 Page St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5997732.0 2108845.0 37.770355822096704 -122.451205793491 (37.7703558220967, -122.451205793491)
116161 34044 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 298 Alabama St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37957 6008878.33665025 2106854.71470607 37.7655228486031 -122.41250976517 (37.7655228486031, -122.41250976517)
117602 12166 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 1439X La Salle Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6016344.6880818 2095251.8114423 37.7340798748876 -122.38587626093799 (37.7340798748876, -122.385876260938)
119444 15325 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1698X Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 1X1   6006725.5802 2108585.93757 37.7701553284346 -122.420078550817 (37.7701553284346, -122.420078550817)

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