Street_Tree_List

Data source: data.sfgov.org

837 rows where qSpecies = 42

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
33878 220678 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 3607 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006149.55219 2104320.61277 37.758411280773394 -122.421768019002 (37.7584112807734, -122.421768019002)
33978 203629 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 138 Encline Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   5998295.84832 2098462.32087 37.7418798313816 -122.448507597342 (37.7418798313816, -122.448507597342)
34367 220083 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 4133 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002828.79114 2104135.9049299997 37.7577162927799 -122.43323947601401 (37.7577162927799, -122.433239476014)
34582 174966 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 44 Hamilton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009006.884330001 2093841.0199900002 37.729797343475596 -122.411145814235 (37.7297973434756, -122.411145814235)
34587 78000 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2804 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/13/2000 12:00:00 AM 7     5985608.4149 2096224.5025 37.735001786065 -122.492211254352 (37.735001786065, -122.492211254352)
34898 40295 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 48 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/13/1999 12:00:00 AM     Permit Number 41439 6005981.28847445 2102313.08870522 37.7528895951686 -122.42220732508801 (37.7528895951686, -122.422207325088)
34990 124760 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1055 Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007817.3795 2119902.3991900003 37.8012890341312 -122.417103992782 (37.8012890341312, -122.417103992782)
34993 188525 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 10 Bell Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6016572.5482 2095212.67149 37.7339850114017 -122.38508574382799 (37.7339850114017, -122.385085743828)
35351 42685 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2335 Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM 8   Permit Number 42709 6006717.2254 2119230.45195 37.7993820864644 -122.420863284838 (37.7993820864644, -122.420863284838)
35427 203633 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 458 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   5997727.849830001 2094119.15999 37.7299220605503 -122.45015856377199 (37.7299220605503, -122.450158563772)
35471 140101 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 771 Central Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999584.517999999 2111094.1746 37.7766373769699 -122.44495966716002 (37.7766373769699, -122.44495966716)
36367 203642 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1700 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 5ft   5993150.97673 2103877.75625 37.7564537210662 -122.466690296437 (37.7564537210662, -122.466690296437)
37273 37949 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 530 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/08/1998 12:00:00 AM 8   Permit Number 40189 6013245.07108 2104267.20859 37.7586622221997 -122.39722464979602 (37.7586622221997, -122.397224649796)
37289 220029 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 4107 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6002428.99773 2102359.29201 37.7528154507744 -122.434495098689 (37.7528154507744, -122.434495098689)
37323 44456 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 95 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/28/2004 12:00:00 AM 5   Permit Number 43779 6002571.72829 2086874.98861 37.710307180311105 -122.432895389109 (37.7103071803111, -122.432895389109)
37452 140100 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 785 Central Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5999576.3959 2111131.7395 37.7767400570235 -122.44499046488501 (37.7767400570235, -122.444990464885)
38222 103892 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1750 Fulton St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5999308.7043 2110849.4957 37.7759498061666 -122.44589618201 (37.7759498061666, -122.44589618201)
38263 68132 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1526 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/1993 12:00:00 AM 0   Permit Number 31884 6000696.86081651 2113890.04393367 37.7843775414062 -122.44131241543998 (37.7843775414062, -122.44131241544)
38287 220026 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 685 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001902.38031 2102621.8344 37.753506421492 -122.436335023459 (37.753506421492, -122.436335023459)
38437 142346 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 505 Central Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5999691.4094 2110243.208 37.7743069396367 -122.44452872557699 (37.7743069396367, -122.444528725577)
38639 174959 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 103 De Long St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 10ft   5994397.11424 2086788.06602 37.709601466104104 -122.461142043293 (37.7096014661041, -122.461142043293)
38771 174961 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 54 Santa Ynez Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6000769.59798 2092028.9930200002 37.7243565377 -122.43949313040899 (37.7243565377, -122.439493130409)
38779 68329 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1342 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 12   Permit Number 32144 5991421.402000001 2110674.853 37.7750167634254 -122.47316740712401 (37.7750167634254, -122.473167407124)
40035 220081 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 780 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003049.24321 2103668.76893 37.756446152387795 -122.432443698342 (37.7564461523878, -122.432443698342)
40082 38526 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 3031 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/15/1998 12:00:00 AM 9   Permit Number 40508 6001945.50794 2118614.30712 37.797420199240996 -122.437330933595 (37.797420199241, -122.437330933595)
40232 50534 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1853 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/06/2003 12:00:00 AM 9   Permit Number 47173 6004174.32371 2118346.10209 37.7968102295769 -122.42959951321899 (37.7968102295769, -122.429599513219)
40646 219991 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 13 Bronte St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6009385.52811 2097403.7869700002 37.739601163374 -122.41008822049601 (37.739601163374, -122.410088220496)
41095 220673 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 100 Alemany Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6009345.21028 2095878.12902 37.735409776738294 -122.410119940478 (37.7354097767383, -122.410119940478)
41593 220031 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 541 Grand View Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6000040.44223 2101732.89415 37.7509596367958 -122.44271016275101 (37.7509596367958, -122.442710162751)
41668 203664 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 123 Detroit St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5999403.203369999 2093610.5277599997 37.7286212055976 -122.444330150233 (37.7286212055976, -122.444330150233)
41760 203657 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 226 Joost Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6000556.64604 2094979.3129099999 37.7324453144793 -122.440440771241 (37.7324453144793, -122.440440771241)
41788 138778 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2250 Sutter St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6001713.8653 2114306.3395 37.785578464198 -122.437823766308 (37.785578464198, -122.437823766308)
41964 246075 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 635 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5998492.5621 2108432.0423 37.7692654626532 -122.44854527514299 (37.7692654626532, -122.448545275143)
42028 188510 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 25 Front Yard : Yard 7 Tree 1 Private 1     2     6014318.1653 2106535.6894400003 37.76495065967789 -122.39367214607401 (37.7649506596779, -122.393672146074)
42347 203665 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 123 Detroit St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   5999403.44951 2093584.38933 37.728549449599704 -122.444327421686 (37.7285494495997, -122.444327421686)
42359 138339 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2250 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6001909.1348 2114331.7204 37.7856592553419 -122.437150009777 (37.7856592553419, -122.437150009777)
42523 220064 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 4086 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6002590.76073 2102413.7777400003 37.7529742368948 -122.43393958746701 (37.7529742368948, -122.433939587467)
42561 203661 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 582 Mangels Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5997537.55728 2095290.5878599999 37.7331276310309 -122.450900858796 (37.7331276310309, -122.450900858796)
42577 139655 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 848 BAKER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6000491.15 2111934.8144 37.7789972619427 -122.441883720544 (37.7789972619427, -122.441883720544)
42992 32891 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1515 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/1996 12:00:00 AM     Permit Number 37234 5994269.30013039 2105266.22888454 37.760330583946796 -122.462923499947 (37.7603305839468, -122.462923499947)
43321 220677 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 3625 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006108.91147 2104316.6789599997 37.758398187543996 -122.42190829343399 (37.758398187544, -122.421908293434)
43560 67530 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/22/1992 12:00:00 AM 12   Permit Number 31068 6013998.45944 2106956.61768 37.766088665392296 -122.394807417822 (37.7660886653923, -122.394807417822)
43667 203624 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 15 Teresita Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5997319.6106 2099609.0427 37.7449725828299 -122.45196580449199 (37.7449725828299, -122.451965804492)
44083 32557 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 3822 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/22/1996 12:00:00 AM     Permit Number 770192 6002956.41958884 2103022.59282687 37.7546666427143 -122.43271855723499 (37.7546666427143, -122.432718557235)
44341 220066 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1109 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6002537.114630001 2102291.1496200003 37.7526344847082 -122.434116340213 (37.7526344847082, -122.434116340213)
44369 42898 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2060 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/13/2002 12:00:00 AM 7   Permit Number 45580 5986523.9754 2097068.6969 37.737373201510295 -122.489107923346 (37.7373732015103, -122.489107923346)
44479 220686 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 430 Hickory St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6004903.16789 2110400.7033700002 37.775035387294295 -122.426511501216 (37.7750353872943, -122.426511501216)
44560 54500 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 475 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/1992 12:00:00 AM 8   Permit Number 31133 6013270.33865 2104862.70543 37.760298732933 -122.39717901909599 (37.760298732933, -122.397179019096)
44833 34144 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1754 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39666 6003955.69985192 2098004.27278913 37.740944124338895 -122.428905023889 (37.7409441243389, -122.428905023889)
44871 36124 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1324 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/29/1998 12:00:00 AM 10   Permit Number 39220 5988358.7841 2106301.1655 37.7628300220311 -122.483440838848 (37.7628300220311, -122.483440838848)
45030 220037 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 4263 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6002187.26734 2100592.3557700003 37.74795013829029 -122.43520467366301 (37.7479501382903, -122.435204673663)
45041 188518 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 805 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6011322.68807 2104548.86682 37.75932838242 -122.403892982475 (37.75932838242, -122.403892982475)
45099 184964 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1990 41st Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5983545.7781 2101731.1432 37.7500007203614 -122.499749280915 (37.7500007203614, -122.499749280915)
45153 140717 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 556 SCOTT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6002162.097 2110427.6982 37.774954171002 -122.43599537996201 (37.774954171002, -122.435995379962)
45189 220002 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1001 Jarboe Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 8ft   6009383.355930001 2096884.0702099998 37.7381740121064 -122.4100590501 (37.7381740121064, -122.4100590501)
45254 220074 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 148 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002660.22221 2105037.36162 37.7601819118789 -122.43388688897 (37.7601819118789, -122.43388688897)
45390 220087 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 69 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6001718.50654 2105457.8427 37.7612829653482 -122.437173938027 (37.7612829653482, -122.437173938027)
45531 220666 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1 Dorland St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6005487.19676 2105743.72088 37.7622814268651 -122.42415994852199 (37.7622814268651, -122.424159948522)
45939 138342 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2250 Sutter St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6001808.8392 2114319.4393 37.7856198329437 -122.437496123305 (37.7856198329437, -122.437496123305)
46001 41430 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 514 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 5   Permit Number 43060 6013229.56642 2104526.4373 37.7593731443828 -122.39729645077699 (37.7593731443828, -122.397296450777)
47055 40817 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1770 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/26/1999 12:00:00 AM 10   Permit Number 41760 6001600.476 2114446.9395 37.785958067470204 -122.43822613537901 (37.7859580674702, -122.438226135379)
47068 220057 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 938 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007984.69118 2102236.05472 37.752790875909 -122.41527371052099 (37.752790875909, -122.415273710521)
47075 220067 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 3781 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003185.70208 2103572.60316 37.756189841101296 -122.431964909158 (37.7561898411013, -122.431964909158)
47147 73391 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 237 Theresa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/27/1994 12:00:00 AM 10     6001816.88591 2094039.23102 37.72993574283429 -122.43601658701999 (37.7299357428343, -122.43601658702)
47237 220016 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 70 Quartz Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998965.77386 2099787.09557 37.74555562500829 -122.44628649854201 (37.7455556250083, -122.446286498542)
47279 35103 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 786 Edinburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM     Permit Number 38645 6001885.65115289 2089265.94057695 37.7168332689419 -122.43543753433399 (37.7168332689419, -122.435437534334)
47618 220674 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 3548 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6005923.11971 2104936.6524900002 37.760090010159104 -122.42259489975201 (37.7600900101591, -122.422594899752)
47710 44248 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1960 Jefferson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2001 12:00:00 AM 8   Permit Number 43683 5999863.264769999 2121264.87303 37.8045793513217 -122.44472662894199 (37.8045793513217, -122.444726628942)
47761 250191 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 11 Alta St 1 Back Yard : Yard 13 Tree 1 Private 1     11 Width 0ft   6011795.08799 2119945.2148 37.8016295579248 -122.40334230423099 (37.8016295579248, -122.403342304231)
47962 219999 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 62 Santa Marina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6005999.49716 2097639.92479 37.740059177277004 -122.421812441905 (37.740059177277, -122.421812441905)
48083 43179 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2299 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 5 3x3 Permit Number 42985 6001635.1083 2114240.3384 37.7853927633961 -122.438091512505 (37.7853927633961, -122.438091512505)
48265 220667 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1337 Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6007176.0273400005 2107716.44116 37.767793265562894 -122.41845879174801 (37.7677932655629, -122.418458791748)
48501 188519 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1451 Rhode Island St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6012046.50101 2101636.39558 37.7513717861857 -122.401185012303 (37.7513717861857, -122.401185012303)
48557 50472 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 3010X Lyon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2003 12:00:00 AM 5 3x3 Permit Number 47106 5999184.20401146 2119093.85477845 37.798579545974704 -122.446920252577 (37.7985795459747, -122.446920252577)
48563 117040 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2220x SUTTER ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
48670 220058 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 564 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6007852.78726 2104670.9495900003 37.7594691272161 -122.415902267384 (37.7594691272161, -122.415902267384)
49170 220036 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1711 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6002636.29383 2100481.40221 37.747670974341396 -122.43364403244 (37.7476709743414, -122.43364403244)
49836 103888 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1750 Fulton St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   5999371.6507 2110859.3099 37.775980347483504 -122.44567914075701 (37.7759803474835, -122.445679140757)
49864 203621 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 21 Juanita Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5997303.382119999 2099336.74248 37.7442239835511 -122.452002277389 (37.7442239835511, -122.452002277389)
50057 220672 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 25 Cumberland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6005444.88154 2104573.79472 37.759066695887 -122.42422309172701 (37.759066695887, -122.424223091727)
50236 103891 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1750 Fulton St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   5999322.5796 2110851.5262 37.7759561736689 -122.445848329979 (37.7759561736689, -122.445848329979)
50333 220053 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 50 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006880.915569999 2099461.25928 37.7451098211639 -122.418893994368 (37.7451098211639, -122.418893994368)
50358 35258 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1304 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1998 12:00:00 AM 11   Permit Number 38744 6006066.5782 2120048.78389 37.8015923223752 -122.42317295609199 (37.8015923223752, -122.423172956092)
50765 244169 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1752 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5998187.9203 2108956.9743 37.7706893684237 -122.449636842472 (37.7706893684237, -122.449636842472)
50887 43172 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 370 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 2   Permit Number 42981 6005806.0739 2092004.6857099999 37.7245751476096 -122.42208098844101 (37.7245751476096, -122.422080988441)
51056 203627 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 133 Maywood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   5994260.237269999 2095673.9858 37.7339921852793 -122.462259143365 (37.7339921852793, -122.462259143365)
51120 66858 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 103 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/15/1991 12:00:00 AM 9   Permit Number 30164 5998644.5770000005 2110362.2819 37.774574098301294 -122.448158471707 (37.7745740983013, -122.448158471707)
51454 44091 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 807 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2000 12:00:00 AM 6   Permit Number 43606 6011323.913930001 2104520.92035 37.759251716121796 -122.40388677626001 (37.7592517161218, -122.40388677626)
52495 220079 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 4021 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003566.56829 2104171.42308 37.7578556427516 -122.43069047448799 (37.7578556427516, -122.430690474488)
53161 67491 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1053 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/08/1992 12:00:00 AM 11   Permit Number 31016 6011662.712180001 2103457.28078 37.7563501191849 -122.402640243074 (37.7563501191849, -122.402640243074)
53450 220065 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 561 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002722.15364 2102085.17478 37.7520794267235 -122.43346172547501 (37.7520794267235, -122.433461725475)
53649 219989 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 936 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998793.85425 2106724.38466 37.7645938887298 -122.447380197361 (37.7645938887298, -122.447380197361)
53663 220045 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 160 Marview Way 1 : 4 Tree 1 Private 1     5 Width 3ft   5998323.68704 2103258.27383 37.755049936933 -122.448756699664 (37.755049936933, -122.448756699664)
53685 220687 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 430 Hickory St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6004894.475319999 2110399.44382 37.775031437471704 -122.426541481018 (37.7750314374717, -122.426541481018)
53857 220052 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 50 Coleridge St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006851.995619999 2099403.94647 37.7449508246175 -122.418989930439 (37.7449508246175, -122.418989930439)
53977 220014 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 60 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6005833.61465 2102298.65201 37.7528416246662 -122.422716983617 (37.7528416246662, -122.422716983617)
54206 220691 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 455 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002941.274019999 2099459.3166400003 37.7448818664203 -122.432516435499 (37.7448818664203, -122.432516435499)
54226 137665 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1901 GOLDEN GATE AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6000382.7272 2111637.7254 37.778175352566 -122.44223746490101 (37.778175352566, -122.442237464901)
54358 219993 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Prospect Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13     6006993.27252 2098944.7494 37.7436979269164 -122.418468865069 (37.7436979269164, -122.418468865069)
54361 203635 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 418 Flood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   5997950.41926 2094116.13567 37.7299264906077 -122.44938890058201 (37.7299264906077, -122.449388900582)

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