Street_Tree_List

Data source: data.sfgov.org

1,729 rows where qSpecies = 54 sorted by PlotSize

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▼ PermitNotes XCoord YCoord Latitude Longitude Location
870 117001 DPW Maintained 3 :: 54 1X Bernal Heights Blvd 1 Front Yard : Yard 7 Tree 1 DPW 2                    
10128 173868 Permitted Site 1 :: 54 808 Capitol Ave 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
10139 173867 Permitted Site 1 :: 54 808 Capitol Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
18795 31192 Permitted Site 1 :: 54 744 Shields St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM     Permit Number 34885 5992088.16257343 2089881.74957895 37.7179628280945 -122.469347142572 (37.7179628280945, -122.469347142572)
19176 36500 Permitted Site 1 :: 54 78 Anderson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM     Permit Number 39380 6007942.28499887 2098248.55652594 37.741839715130894 -122.41513812883001 (37.7418397151309, -122.41513812883)
19242 36516 Permitted Site 1 :: 54 430 Crescent Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
20493 31189 Permitted Site 1 :: 54 744 Shields St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM     Permit Number 34885 5992088.16257343 2089881.74957895 37.7179628280945 -122.469347142572 (37.7179628280945, -122.469347142572)
30528 36517 Permitted Site 1 :: 54 430 Crescent Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
51323 33210 Permitted Site 1 :: 54 80 Ulloa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/06/1996 12:00:00 AM     Permit Number 37408 5996508.84910838 2099508.74034148 37.74465070488021 -122.454762009134 (37.7446507048802, -122.454762009134)
54627 36527 Permitted Site 1 :: 54 619 Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM     Permit Number 39400 6007328.0 2097732.0 37.74038682503829 -122.41722553506399 (37.7403868250383, -122.417225535064)
72532 116318 Undocumented 2 :: 54 1451 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
72583 114625 Undocumented 2 :: 54 2400X Post St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
77581 33407 Permitted Site 1 :: 54 100 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
77582 37456 Permitted Site 1 :: 54 442 Holladay Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1998 12:00:00 AM     Permit Number 39929 6010236.40979486 2098631.79989851 37.743020676259704 -122.40723276795299 (37.7430206762597, -122.407232767953)
78123 104843 Permitted Site 1 :: 54 1320 21st Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5989622.0 2106334.7 37.7629955389606 -122.47907431964701 (37.7629955389606, -122.479074319647)
78333 38003 Permitted Site 1 :: 54 2478 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/13/2002 12:00:00 AM     Permit Number 40215 5992069.67302471 2098579.11634993 37.74184256230679 -122.47004399101499 (37.7418425623068, -122.470043991015)
78523 108805 Undocumented 2 :: 54 401-499 University St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008323.152369999 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207)
78529 43025 Permitted Site 1 :: 54 430 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM     Permit Number 42886 6004125.6708626 2110297.9605007 37.774709297051004 -122.429193705112 (37.774709297051, -122.429193705112)
78656 35996 Permitted Site 1 :: 54 36 Mirabel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/27/1998 12:00:00 AM     Permit Number 39146 6007490.93822931 2099869.27557104 37.7462644727809 -122.416813538412 (37.7462644727809, -122.416813538412)
79036 116326 Undocumented 2 :: 54 1400X Potrero Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
79062 33409 Permitted Site 1 :: 54 100 Ulloa St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
79728 108812 Undocumented 2 :: 54 301-399 University St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008160.407269999 2092653.74948 37.726489845684796 -122.41398823310301 (37.7264898456848, -122.413988233103)
80004 35095 Permitted Site 1 :: 54 647 Edinburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM     Permit Number 38637 6002415.60861753 2090011.70468142 37.718911055862606 -122.43365900206499 (37.7189110558626, -122.433659002065)
80039 114619 Undocumented 2 :: 54 2400X Post St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
80342 36993 Permitted Site 1 :: 54 2974 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM     Permit Number 39613 6008419.31343349 2103324.4841573997 37.7558038738313 -122.413847688409 (37.7558038738313, -122.413847688409)
80868 116284 Undocumented 2 :: 54 700X Greenwich St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
80892 104890 Undocumented 2 :: 54 150 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1         empty 5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
81123 36532 Permitted Site 1 :: 54 3734St. Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM     Permit Number 39405 6008419.88910724 2097501.78967285 37.7398160862313 -122.413433924041 (37.7398160862313, -122.413433924041)
81298 104856 Permitted Site 1 :: 54 739 27th St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   02/12/2015 12:00:00 AM 3     6001722.3 2099959.7 37.746186600460604 -122.43676722664301 (37.7461866004606, -122.436767226643)
81482 38110 Permitted Site 1 :: 54 1296 29th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/1998 12:00:00 AM     Permit Number 40278 5987114.66231835 2106457.26685396 37.763186144894 -122.48775523264901 (37.763186144894, -122.487755232649)
81521 34737 Permitted Site 1 :: 54 575 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM     Permit Number 38387 6007300.76294173 2103973.10640079 37.757521960416604 -122.41776197976499 (37.7575219604166, -122.417761979765)
81650 45785 Permitted Site 1 :: 54 355 Granada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/16/2001 12:00:00 AM     Permit Number 44424 5995605.92038879 2092277.61806963 37.7247439722696 -122.457361104262 (37.7247439722696, -122.457361104262)
81995 37632 Permitted Site 1 :: 54 791 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1998 12:00:00 AM     Permit Number 40050 5990357.50342651 2110002.09732806 37.773107903504794 -122.476798459473 (37.7731079035048, -122.476798459473)
81999 108810 Undocumented 2 :: 54 301-399 University St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008160.407269999 2092653.74948 37.726489845684796 -122.41398823310301 (37.7264898456848, -122.413988233103)
82222 32457 Permitted Site 1 :: 54 210 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/1996 12:00:00 AM     Permit Number 36972 6003808.4224833 2109079.21792679 37.771344964126705 -122.430204165931 (37.7713449641267, -122.430204165931)
82559 116276 Undocumented 2 :: 54 700X Greenwich St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
82769 108801 Undocumented 2 :: 54 501-599 University St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
83119 114623 Undocumented 2 :: 54 2400X Post St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
83240 108802 Undocumented 2 :: 54 401-499 University St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008323.152369999 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207)
83254 110159 Permitted Site 1 :: 54 1041 Broadway 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3   Permit Number 55966 6008597.3 2118278.8 37.7968748776387 -122.414290174718 (37.7968748776387, -122.414290174718)
83415 114615 Undocumented 2 :: 54 2400X Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
83697 108792 Permitted Site 1 :: 54 201-299 University St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         6008053.41125 2093004.09823 37.727445818429295 -122.414382893832 (37.7274458184293, -122.414382893832)
83840 107144 Undocumented 2 :: 54 360 Spear St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1           6015708.0 2115219.0 37.7888702311939 -122.38947147438 (37.7888702311939, -122.38947147438)
83855 114626 Undocumented 2 :: 54 2400X Post St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
83909 109520 Undocumented 2 :: 54 4801X 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999644.57626 2104777.09851 37.759295701171105 -122.44429784106501 (37.7592957011711, -122.444297841065)
83937 33209 Permitted Site 1 :: 54 80 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/06/1996 12:00:00 AM     Permit Number 37408 5996508.84910838 2099508.74034148 37.74465070488021 -122.454762009134 (37.7446507048802, -122.454762009134)
84755 34736 Permitted Site 1 :: 54 569 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM     Permit Number 38386 6007298.90712997 2104006.62448648 37.7576138889301 -122.417770773708 (37.7576138889301, -122.417770773708)
84777 116279 Undocumented 2 :: 54 700X Greenwich St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
85159 108793 Permitted Site 1 :: 54 201-299 University St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         6008053.41125 2093004.09823 37.727445818429295 -122.414382893832 (37.7274458184293, -122.414382893832)
85267 46322 Permitted Site 1 :: 54 3080 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2002 12:00:00 AM     Permit Number 44576 5988871.55058969 2094853.71729449 37.731428183192705 -122.480829241755 (37.7314281831927, -122.480829241755)
85350 40070 Permitted Site 1 :: 54 1434 Thomas Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/19/1999 12:00:00 AM     Permit Number 41296 6015644.04223078 2093317.32333735 37.7287293601115 -122.388163675017 (37.7287293601115, -122.388163675017)
85364 115892 Permitted Site 1 :: 54 1900X Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
85374 114726 Significant Tree 6 :: 54 520 Townsend St 2 Front Yard : Yard 7 Tree 1 Private 1           6012508.1 2109575.3 37.7731959986981 -122.40014623691201 (37.7731959986981, -122.400146236912)
85490 52296 Permitted Site 1 :: 54 677DIAMOND ST Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/01/2005 12:00:00 AM     Permit Number 48457 6002165.96993722 2099704.44459938 37.7455109340163 -122.435214819168 (37.7455109340163, -122.435214819168)
85903 105084 Significant Tree 6 :: 54 344 Fulton St 4 Front Yard : Yard 7 Tree 1 Private 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
86041 105089 Significant Tree 6 :: 54 344 Fulton St 9 Front Yard : Yard 7 Tree 1 Private 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
86204 33463 Permitted Site 1 :: 54 20 Coleridge St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/20/1996 12:00:00 AM     Permit Number 37562 6006978.38557579 2099649.65289984 37.7456325955283 -122.418570316182 (37.7456325955283, -122.418570316182)
86244 41853 Permitted Site 1 :: 54 936 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM     Permit Number 42240 5992008.2421953 2105257.75589238 37.7601768237518 -122.470742754033 (37.7601768237518, -122.470742754033)
87071 115068 DPW Maintained 3 :: 54 70 Coral Rd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
87303 33408 Permitted Site 1 :: 54 100 Ulloa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
87372 33510 Permitted Site 1 :: 54 24 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1996 12:00:00 AM     Permit Number 37605 6006962.93911675 2099621.40648906 37.745554167617 -122.418621725138 (37.745554167617, -122.418621725138)
87576 114627 Undocumented 2 :: 54 2400X Post St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
87925 104864 Permitted Site 1 :: 54 45 Hoffman Ave   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1           6000629.3 2102650.0 37.7535113392088 -122.440739618385 (37.7535113392088, -122.440739618385)
88078 116321 Undocumented 2 :: 54 1400X Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
88172 33514 Permitted Site 1 :: 54 371 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/25/1996 12:00:00 AM     Permit Number 37614 6006108.24130768 2097930.15080676 37.7408622046731 -122.421457054715 (37.7408622046731, -122.421457054715)
88387 116329 Undocumented 2 :: 54 1400X Potrero Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
88816 115002 Undocumented 2 :: 54 46 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5993155.2 2098864.2 37.742688023212295 -122.46631133896999 (37.7426880232123, -122.46631133897)
89025 36518 Permitted Site 1 :: 54 430 Crescent Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
89497 30705 Permitted Site 1 :: 54 371 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1995 12:00:00 AM     Permit Number 34615 6005225.74804899 2110232.43831944 37.7745916029272 -122.425383648395 (37.7745916029272, -122.425383648395)
89960 114628 Undocumented 2 :: 54 2400X Post St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
91200 33411 Permitted Site 1 :: 54 100 Ulloa St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
91482 116332 Undocumented 2 :: 54 1400X Potrero Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
92236 43021 Permitted Site 1 :: 54 537 Steiner St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42882 6003129.08838274 2110095.37711913 37.7740965863099 -122.432626609315 (37.7740965863099, -122.432626609315)
92470 116283 Undocumented 2 :: 54 700X Greenwich St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
92536 114785 Permitted Site 1 :: 54 2459 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/09/2015 12:00:00 AM       6000398.9 2113706.0 37.7838552262656 -122.44233003645701 (37.7838552262656, -122.442330036457)
92619 115024 Permitted Site 1 :: 54 2500 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/06/2016 12:00:00 AM       5983385.7 2098079.0 37.739963544351504 -122.500032889381 (37.7399635443515, -122.500032889381)
92954 97034 Property Tree 7 :: 54 195B Kiska Rd   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
92969 110024 Undocumented 2 :: 54 432X Frederick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5997770.4 2107507.4 37.766685312872504 -122.450976500583 (37.7666853128725, -122.450976500583)
93124 116328 Undocumented 2 :: 54 1400X Potrero Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
93962 115298 Permitted Site 1 :: 54 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231)
94078 116333 Undocumented 2 :: 54 1400X Potrero Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
94106 116320 Undocumented 2 :: 54 1451 Hampshire St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
94877 42090 Permitted Site 1 :: 54 25 Stoneman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42397 6008240.69863747 2099401.70748619 37.7450227780609 -122.414187874949 (37.7450227780609, -122.414187874949)
94995 108989 Undocumented 2 :: 54 2073-2099X Jefferson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501)
95183 116324 Undocumented 2 :: 54 1400X Potrero Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
96301 101476 Significant Tree 6 :: 54 541 Congo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089.0 2095440.1 37.7336838892166 -122.44209059296301 (37.7336838892166, -122.442090592963)
96655 105086 Significant Tree 6 :: 54 344 Fulton St 6 Front Yard : Yard 7 Tree 1 Private 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
96844 114629 Undocumented 2 :: 54 2400X Post St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
97038 105091 Significant Tree 6 :: 54 344 Fulton St 11 Front Yard : Yard 7 Tree 1 Private 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
97519 114725 Significant Tree 6 :: 54 520 Townsend St 1 Front Yard : Yard 7 Tree 1 Private 1           6012508.1 2109575.3 37.7731959986981 -122.40014623691201 (37.7731959986981, -122.400146236912)
97624 114622 Undocumented 2 :: 54 2400X Post St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
98178 116335 Undocumented 2 :: 54 1400X Potrero Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
98575 115891 Permitted Site 1 :: 54 1900X Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
98644 106968 Property Tree 7 :: 54 351 26th Ave   Back Yard : Yard 13 Tree 1 Private 1           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226)
98757 116282 Undocumented 2 :: 54 700X Greenwich St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
98812 115061 DPW Maintained 3 :: 54 70 Coral Rd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
98945 116341 Undocumented 2 :: 54 201X Bright St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
99135 114630 Undocumented 2 :: 54 2400X Post St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
99142 116319 Undocumented 2 :: 54 1451 Hampshire St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
99156 33410 Permitted Site 1 :: 54 100 Ulloa St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)

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