Street_Tree_List

Data source: data.sfgov.org

1,729 rows where qSpecies = 54 sorted by qLegalStatus

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
1389 251532 Permitted Site 1 :: 54 2100X 20th St 4 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   05/15/2017 12:00:00 AM 3 4x11            
1391 251531 Permitted Site 1 :: 54 2100X 20th St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   05/15/2017 12:00:00 AM 3 4x11            
1800 251700 Permitted Site 1 :: 54 1560 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   06/05/2017 12:00:00 AM 3 410x11 Permit Number 780193 6003924.0 2099150.0 37.7440882334859 -122.429096301435 (37.7440882334859, -122.429096301435)
1824 251724 Permitted Site 1 :: 54 1630 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/2017 12:00:00 AM 3 3x3   6006933.88533 2116748.92044 37.792580631742204 -122.419937373279 (37.7925806317422, -122.419937373279)
2270 253008 Permitted Site 1 :: 54 1201 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
2865 253261 Permitted Site 1 :: 54 339 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5990256.0 2113097.0 37.78159976365421 -122.477375802178 (37.7815997636542, -122.477375802178)
2881 253260 Permitted Site 1 :: 54 734 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993234.0 2110465.0 37.7745453462497 -122.46688203122801 (37.7745453462497, -122.466882031228)
2900 70091 Permitted Site 1 :: 54 752 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/12/1992 12:00:00 AM 6 3x3   5988512.5089 2110855.81451 37.7753447787774 -122.483243045223 (37.7753447787774, -122.483243045223)
3276 149033 Permitted Site 1 :: 54 3916 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/28/2017 12:00:00 AM 3 5.5x12   5996085.364440001 2114918.02173 37.7869363183091 -122.45734088598302 (37.7869363183091, -122.457340885983)
3639 253517 Permitted Site 1 :: 54 559 24th Ave 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 2x4.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3643 253515 Permitted Site 1 :: 54 559 24th Ave 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 7x9.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3650 253518 Permitted Site 1 :: 54 559 24th Ave 3 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 2x1   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3660 253516 Permitted Site 1 :: 54 559 24th Ave 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 2x2   5988392.0 2112177.0 37.778965370493495 -122.483756799769 (37.7789653704935, -122.483756799769)
4723 253676 Permitted Site 1 :: 54 2975 Van Ness Ave 6 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
4726 253675 Permitted Site 1 :: 54 2975 Van Ness Ave 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   10/24/2017 12:00:00 AM 3 3.2x14.2   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
5211 253829 Permitted Site 1 :: 54 869 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
5216 253831 Permitted Site 1 :: 54 651X Polk St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
5222 253825 Permitted Site 1 :: 54 725 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
5224 253827 Permitted Site 1 :: 54 825 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5226 253832 Permitted Site 1 :: 54 665 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
5228 253828 Permitted Site 1 :: 54 825 Polk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5229 253834 Permitted Site 1 :: 54 747 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
5230 253826 Permitted Site 1 :: 54 701 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
5236 253833 Permitted Site 1 :: 54 607 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
5239 253830 Permitted Site 1 :: 54 651X Polk St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
10092 173852 Permitted Site 1 :: 54 450 Toland St 7 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10093 173849 Permitted Site 1 :: 54 450 Toland St 4 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 17.6x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10096 173850 Permitted Site 1 :: 54 450 Toland St 5 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 13.9x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10097 173851 Permitted Site 1 :: 54 450 Toland St 6 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10098 173848 Permitted Site 1 :: 54 450 Toland St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 19.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10101 173846 Permitted Site 1 :: 54 450 Toland St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 15x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10104 173847 Permitted Site 1 :: 54 450 Toland St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 11.85x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10106 173853 Permitted Site 1 :: 54 450 Toland St 8 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
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)
20483 109769 Permitted Site 1 :: 54 2502X Bush St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       1.5x12.75   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381)
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)
42994 109343 Permitted Site 1 :: 54 3211 Baker St 2 Sidewalk: Property side : Yard 9 Landscaping 2 Private 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
49594 112605 Permitted Site 1 :: 54 1534 Hayes St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   08/10/2015 12:00:00 AM   5.6x12   6000465.0 2110329.2 37.7745871625182 -122.441858914128 (37.7745871625182, -122.441858914128)
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)
61493 105361 Permitted Site 1 :: 54 850 Guerrero St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602)
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)
77940 114567 Permitted Site 1 :: 54 1930 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/24/2015 12:00:00 AM   3x3   6008702.7 2119505.5 37.8002490116896 -122.414012289596 (37.8002490116896, -122.414012289596)
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)
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)
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)
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)
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)
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)
81163 104152 Permitted Site 1 :: 54 525X Church St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 SFUSD 4 DPW 4     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
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)
81722 104155 Permitted Site 1 :: 54 525X Church St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 SFUSD 4 DPW 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
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)
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)
83041 109366 Permitted Site 1 :: 54 1205 Filbert St 3 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1 FUF 1 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
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)
83497 105359 Permitted Site 1 :: 54 850 Guerrero St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602)
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)
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)
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)
85310 105043 Permitted Site 1 :: 54 2660 Harrison St 5 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       2x4   6008902.0 2102968.0 37.754852144595795 -122.41215320319701 (37.7548521445958, -122.412153203197)
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)
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)
85839 105039 Permitted Site 1 :: 54 2660 Harrison St 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
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)
86957 109262 Permitted Site 1 :: 54 3338X Ortega St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3   5983663.54917 2102222.75157 37.7513574508855 -122.499378353213 (37.7513574508855, -122.499378353213)
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)
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)
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)
88689 109762 Permitted Site 1 :: 54 1801 Scott St 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       1.5x6.5   6001511.7 2114646.3 37.786500410729104 -122.43854756475099 (37.7865004107291, -122.438547564751)
88984 109756 Permitted Site 1 :: 54 601 Steiner St 3 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
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)
89307 105925 Permitted Site 1 :: 54 4166 20th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3X3   6002608.6 2104160.0 37.7577699584222 -122.434002709079 (37.7577699584222, -122.434002709079)
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)
91070 105360 Permitted Site 1 :: 54 850 Guerrero St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602)
91154 109365 Permitted Site 1 :: 54 1205 Filbert St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
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)
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)
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)
92935 104156 Permitted Site 1 :: 54 525X Church St 4 Sidewalk: Curb side : Cutout 1 Landscaping 2 SFUSD 4 DPW 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
93908 51029 Permitted Site 1 :: 54 133 Ellert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2011 12:00:00 AM   3x3 Permit Number 767941 6007256.96585115 2097027.84886938 37.7384493854458 -122.417421253654 (37.7384493854458, -122.417421253654)
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)
94853 104637 Permitted Site 1 :: 54 217 Montcalm St   Front Yard : Yard 7 Landscaping 2 Private 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)

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