Street_Tree_List

Data source: data.sfgov.org

2,202 rows where qSpecies = 55 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188850 207816 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 236 Gennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   5997465.81636 2094312.11288 37.73043686484979 -122.45107834899599 (37.7304368648498, -122.451078348996)
188803 201857 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1104 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6010239.403 2110891.1863 37.776682357885896 -122.408086815194 (37.7766823578859, -122.408086815194)
188762 65630 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2510 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1990 12:00:00 AM 8   Permit Number 28538 6001388.347 2114610.3564 37.7863947012265 -122.43897175770701 (37.7863947012265, -122.438971757707)
188748 207927 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1630 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5991926.85515 2096424.2337 37.7359175438479 -122.470380908151 (37.7359175438479, -122.470380908151)
188541 191491 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 190 09th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008660.87674 2110356.51617 37.7751257709745 -122.41350959771299 (37.7751257709745, -122.413509597713)
188519 129635 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1181 Union St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007311.91376 2119137.96682 37.799161647339204 -122.41879888656099 (37.7991616473392, -122.418798886561)
188479 207867 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1350 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5994282.22065 2106308.08088 37.7631919832571 -122.46295440383498 (37.7631919832571, -122.462954403835)
188436 207812 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 635 Hearst Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5997216.39115 2094387.61086 37.7306298809467 -122.451946087746 (37.7306298809467, -122.451946087746)
188377 137560 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1250 PIERCE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6002310.5713 2112882.3991 37.781702597408795 -122.435657430814 (37.7817025974088, -122.435657430814)
188363 227455 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 122 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6001675.52241 2108124.5913400003 37.7686027588258 -122.43751357779101 (37.7686027588258, -122.437513577791)
188060 244960 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 202 Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6005166.2714 2109775.654 37.7733340235563 -122.425556873948 (37.7733340235563, -122.425556873948)
188031 227333 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 245 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5998975.3756099995 2106713.7250599996 37.7645749912571 -122.446751599103 (37.7645749912571, -122.446751599103)
188009 177141 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 355 Naples St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6003671.36983 2091507.3370599998 37.7230889064227 -122.429424930532 (37.7230889064227, -122.429424930532)
187923 114432 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 700 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3 Permit Number 777170 5992893.39745 2110635.08838 37.774992699186 -122.468072606609 (37.774992699186, -122.468072606609)
187892 177123 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 342 Harvard St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 4ft   6006356.99395 2092231.60745 37.7252292829921 -122.4201926235 (37.7252292829921, -122.4201926235)
187844 64559 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1562 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/1988 12:00:00 AM 12   Permit Number 25450 6000352.3546 2110302.164 37.774506509156204 -122.442246634385 (37.7745065091562, -122.442246634385)
187836 138111 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2109 BUSH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6003316.4709 2114827.0332 37.787099156045606 -122.432316422563 (37.7870991560456, -122.432316422563)
187811 101108 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1790 24th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3X3 Permit Number 14067 5988777.5028 2103198.1315 37.754334289199704 -122.481765355128 (37.7543342891997, -122.481765355128)
187790 226726 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2730 23rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010313.932519999 2102839.26817 37.7545777982407 -122.40726125021601 (37.7545777982407, -122.407261250216)
187706 55001 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 546 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/1972 12:00:00 AM 12   Permit Number 10879 5990967.23553 2111663.9992 37.777706381155205 -122.474810664746 (37.7777063811552, -122.474810664746)
187665 124007 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 317 06th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993994.36391 2113305.2433 37.7823877470983 -122.464458070673 (37.7823877470983, -122.464458070673)
187520 226741 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1160 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6010258.15584 2102463.0673700003 37.7535417126867 -122.407427621191 (37.7535417126867, -122.407427621191)
187511 226663 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 109 Buchanan St 2 : 4 Tree 1 Private 1     10 Width 4ft   6004754.99125 2108900.4446099997 37.77090766370029 -122.426917205171 (37.7709076637003, -122.426917205171)
187508 191440 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2212 25th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6012152.298359999 2101896.5627900003 37.75209205051161 -122.40083742701401 (37.7520920505116, -122.400837427014)
187456 191461 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 26 South Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   6014466.473259999 2112793.29077 37.782140875944 -122.393597178563 (37.782140875944, -122.393597178563)
187447 129666 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2208 Powell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6009347.64919 2121645.06555 37.806159927791 -122.41193178303101 (37.806159927791, -122.411931783031)
187438 227401 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 569 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6002632.3517 2103249.18042 37.75527041381021 -122.433855464885 (37.7552704138102, -122.433855464885)
187414 129671 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2208 Powell St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6009327.569680001 2121786.16938 37.8065462369833 -122.41201124983101 (37.8065462369833, -122.412011249831)
187412 207389 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1726 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993749.768130001 2103720.2567 37.7560558061474 -122.464608044838 (37.7560558061474, -122.464608044838)
187356 207814 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 235 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 1ft   5999174.291680001 2094063.56835 37.729852086101396 -122.44515406592899 (37.7298520861014, -122.445154065929)
187310 227505 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 11 Ohlone Way 2 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002170.3179 2096422.89629 37.7365008135581 -122.434965139225 (37.7365008135581, -122.434965139225)
187210 177060 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 550 Geneva Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   5999004.711019999 2090533.4907900002 37.7201496314864 -122.445486588437 (37.7201496314864, -122.445486588437)
187170 207869 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1541 12th Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5992429.29261 2104765.0149 37.7588482262841 -122.46925068878599 (37.7588482262841, -122.469250688786)
187155 227443 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4200 20th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002302.88704 2104151.22566 37.7577285118836 -122.43505936211099 (37.7577285118836, -122.435059362111)
186971 72130 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2030 23rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/25/1984 12:00:00 AM 7     6012329.14835 2102847.44399 37.7547128260461 -122.400292629422 (37.7547128260461, -122.400292629422)
186959 66501 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1625 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/21/1991 12:00:00 AM 7   Permit Number 29664 5999574.2556 2114579.9293 37.7862077735321 -122.44524584382 (37.7862077735321, -122.44524584382)
186910 200608 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1403 La Salle Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6016392.0635 2095142.0480000002 37.7337811080514 -122.385704820187 (37.7337811080514, -122.385704820187)
186737 73860 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1652 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/11/1993 12:00:00 AM 12     6008793.24364 2118610.57457 37.7977968533 -122.41363563948299 (37.7977968533, -122.413635639483)
186720 226746 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 41 Peralta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010705.09671 2100401.8324 37.7479070202997 -122.40573681752599 (37.7479070202997, -122.405736817526)
186701 177068 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 26 Curtis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6000490.27056 2088504.66061 37.7146636177052 -122.440206107549 (37.7146636177052, -122.440206107549)
186663 122136 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     5991117.00305 2114994.0290099997 37.786858399358294 -122.47453565898 (37.7868583993583, -122.47453565898)
186625 61561 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2018 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/25/1984 12:00:00 AM 13   Permit Number 21521 6012372.92464 2102851.20002 37.754725580248 -122.40014150193399 (37.754725580248, -122.400141501934)
186582 191488 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 288 07th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6010222.32118 2110959.01545 37.776867644449204 -122.40815069140301 (37.7768676444492, -122.408150691403)
186375 114467 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2351 Powell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6009280.92289 2121766.4788599997 37.8064895545061 -122.412171287793 (37.8064895545061, -122.412171287793)
186369 226757 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 209 Day St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6004291.47259 2098662.3001599996 37.7427699165123 -122.427790919941 (37.7427699165123, -122.427790919941)
186286 129567 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 245 Locust St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5997570.752730001 2115509.3434099997 37.788645132713796 -122.45224449091101 (37.7886451327138, -122.452244490911)
185976 227167 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 119 Grattan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998089.83813 2106503.39659 37.76394685618 -122.449799262145 (37.76394685618, -122.449799262145)
185957 207972 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 204 Cresta Vista Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5996281.29923 2096182.49278 37.7355045886606 -122.45530848830299 (37.7355045886606, -122.455308488303)
185883 67262 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 511 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/1992 12:00:00 AM 6   Permit Number 30729 5981280.933019999 2112230.5095 37.7786957851972 -122.508360365452 (37.7786957851972, -122.508360365452)
185859 226736 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3652 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   6005358.92953 2102566.09607 37.7535491707736 -122.424377554773 (37.7535491707736, -122.424377554773)
185760 191462 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 44 South Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014434.11551 2112764.95464 37.7820612733549 -122.393707138698 (37.7820612733549, -122.393707138698)
185719 207828 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 100 Staples Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 1ft   5999348.944080001 2093797.91328 37.729132626663706 -122.444531189165 (37.7291326266637, -122.444531189165)
185710 129631 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2615 Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006581.14621 2120178.38554 37.8019772007523 -122.421401522778 (37.8019772007523, -122.421401522778)
185708 120477 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2201 Lake St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 1ft   5988623.03819 2114641.82381 37.785746527658 -122.483138270198 (37.785746527658, -122.483138270198)
185675 141039 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 82 Cook St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5997548.9955 2113146.6183 37.7821564681962 -122.45214922274799 (37.7821564681962, -122.452149222748)
185619 191460 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 110 Main St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   6014521.60501 2115886.5907099997 37.7906374305211 -122.393623012505 (37.7906374305211, -122.393623012505)
185550 227343 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3915 Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008417.48534 2096717.53633 37.737662563174 -122.41338678718901 (37.737662563174, -122.413386787189)
185546 129643 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 926 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6007928.293190001 2120314.2038 37.8024259849283 -122.416749372103 (37.8024259849283, -122.416749372103)
185519 227229 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3181 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6007106.48426 2103203.24866 37.7553971732524 -122.418379289898 (37.7553971732524, -122.418379289898)
185445 226712 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1089 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6010271.799319999 2102896.97753 37.754733897156 -122.407411026915 (37.754733897156, -122.407411026915)
185371 227352 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 20 Appleton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6005581.68888 2097079.0360400002 37.738495532331704 -122.42321719373999 (37.7384955323317, -122.42321719374)
185158 227512 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1175 Stevenson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   6006402.46798 2109528.79831 37.772725988548395 -122.42126315847601 (37.7727259885484, -122.421263158476)
185105 177128 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 100 Yale St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6006947.17025 2093387.19061 37.728435500994394 -122.418234330861 (37.7284355009944, -122.418234330861)
185010 141369 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 340 BAKER ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6000731.4526 2110189.2685 37.7742181251853 -122.440927164049 (37.7742181251853, -122.440927164049)
184929 227509 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 41 Brady St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6006621.39205 2109628.6264 37.7730124325176 -122.420512962002 (37.7730124325176, -122.420512962002)
184900 227457 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 38 Levant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6000239.37945 2106664.2294799997 37.7645112140449 -122.442376209409 (37.7645112140449, -122.442376209409)
184817 227298 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4233 Cesar Chavez St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6002393.51458 2100323.84062 37.7472245688541 -122.434472284662 (37.7472245688541, -122.434472284662)
184650 54966 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 734 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/11/1972 12:00:00 AM 16   Permit Number 10844 5993209.18585 2111421.27834 37.777169597209 -122.467037406046 (37.777169597209, -122.467037406046)
184368 227204 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 475 Tompkins Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 2ft   6007551.4691 2096600.33455 37.737292091044104 -122.41637272882299 (37.7372920910441, -122.416372728823)
184261 227300 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4233 Cesar Chavez St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6002388.83562 2100326.88873 37.7472326726441 -122.434488682032 (37.7472326726441, -122.434488682032)
184221 227217 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 775 Alabama St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6009108.8338 2104653.1063200003 37.7594906686717 -122.411556961793 (37.7594906686717, -122.411556961793)
184181 120484 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2309 Lake St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 1ft   5988270.499009999 2114625.30582 37.785680652510294 -122.48435672889299 (37.7856806525103, -122.484356728893)
184110 227208 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 35 Powhattan Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     22 Width 3ft   6007523.932469999 2098207.4852299998 37.741703423083294 -122.416581750143 (37.7417034230833, -122.416581750143)
184064 62716 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1125 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/23/1986 12:00:00 AM 17   Permit Number 23059 6007595.431480001 2119179.891 37.799292719927294 -122.417820789314 (37.7992927199273, -122.417820789314)
184012 207997 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 395 Joost Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 10ft   5999481.71143 2094946.11387 37.73229289198321 -122.444154676308 (37.7322928919832, -122.444154676308)
183928 141966 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 801 Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6004861.3228 2111665.6559 37.7785062716793 -122.42674635400101 (37.7785062716793, -122.426746354001)
183847 227240 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1041 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   6005776.90584 2102650.34664 37.753804097106205 -122.422938087332 (37.7538040971062, -122.422938087332)
183840 226751 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 188 Buchanan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6004780.64342 2109066.90336 37.7713661695481 -122.42684033024099 (37.7713661695481, -122.426840330241)
183799 227236 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3271 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006927.020169999 2106115.20922 37.7633826377237 -122.41920648270201 (37.7633826377237, -122.419206482702)
183784 226662 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 109 Buchanan St 1 : 4 Tree 1 Private 1     10 Width 3ft   6004759.3932300005 2108882.7963099997 37.7708594546408 -122.42690072149901 (37.7708594546408, -122.426900721499)
183703 227267 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 739 27th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 7ft   6001720.54184 2099972.41794 37.7462214209976 -122.436774216378 (37.7462214209976, -122.436774216378)
183646 141038 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 88 Cook St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5997552.7181 2113122.5903 37.7820907068665 -122.452134610087 (37.7820907068665, -122.452134610087)
183560 227186 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 260 Upper Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5999465.27543 2106151.00222 37.7630578682481 -122.445016716945 (37.7630578682481, -122.445016716945)
183308 177056 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 765 Delano Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5998961.55007 2090188.4526900002 37.71919977204001 -122.44561098175801 (37.71919977204, -122.445610981758)
183307 129678 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6012048.39516 2116793.1627 37.7929889247624 -122.402243998167 (37.7929889247624, -122.402243998167)
183260 207993 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 395 Joost Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   5999470.9807400005 2094940.5496900002 37.732277001865604 -122.444191374942 (37.7322770018656, -122.444191374942)
183200 227303 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2211 Castro St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9     6002724.72616 2099043.5598 37.7437280128274 -122.43323551541701 (37.7437280128274, -122.433235515417)
183136 207985 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 394 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5998813.609180001 2095274.4257 37.733156221377 -122.446488060895 (37.733156221377, -122.446488060895)
183099 207973 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5995100.87909 2096206.0642799998 37.7355015111722 -122.459391325848 (37.7355015111722, -122.459391325848)
183091 207373 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 805 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5993247.553309999 2106602.4010900003 37.7639404575053 -122.46655433693701 (37.7639404575053, -122.466554336937)
183038 227370 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1156 Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6008042.48405 2101188.10567 37.749916692119704 -122.414999684386 (37.7499166921197, -122.414999684386)
182931 207380 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1251 Funston Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 8ft   5992036.83974 2106822.46143 37.764474744735395 -122.470757824839 (37.7644747447354, -122.470757824839)
182818 123765 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 773 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993254.87771 2110685.3073 37.775151455932104 -122.466825830328 (37.7751514559321, -122.466825830328)
182800 227173 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 146 Alma St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5997978.59141 2106212.21025 37.763140966494 -122.450163039697 (37.763140966494, -122.450163039697)
182691 246495 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 359 Duncan St 1 : 4 Tree 1 Private 1     15 Width 3ft   6004220.129819999 2099827.66275 37.7459656978564 -122.428120633885 (37.7459656978564, -122.428120633885)
182678 67465 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 937 Olmstead St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/01/1992 12:00:00 AM 9   Permit Number 30978 6008961.1272 2090382.77007 37.7202991536555 -122.41105982826001 (37.7202991536555, -122.41105982826)
182669 227377 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3440 25th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006820.372690001 2101479.14572 37.7506470711158 -122.41924645667 (37.7506470711158, -122.41924645667)
182667 244099 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1601 Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5998841.7867 2108999.0531 37.7708422919425 -122.44737814683 (37.7708422919425, -122.44737814683)
182610 207409 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2119 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   5992555.1152 2101006.21366 37.7485348028432 -122.46854205627199 (37.7485348028432, -122.468542056272)
182511 207835 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1209 Capitol Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5995030.31814 2091918.85126 37.723725807194704 -122.459324908222 (37.7237258071947, -122.459324908222)

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