Street_Tree_List

Data source: data.sfgov.org

1,729 rows where qSpecies = 54

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
161 142720 Undocumented 2 :: 54 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
443 251293 Undocumented 2 :: 54 3789 Market St 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
514 251312 Undocumented 2 :: 54 1499 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
518 251314 Planning Code 138.1 required 4 :: 54 1108 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001901.0 2100825.0 37.7485726639367 -122.43621121860001 (37.7485726639367, -122.4362112186)
533 251313 Planning Code 138.1 required 4 :: 54 390 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
631 251294 Property Tree 7 :: 54 7126 Geary Blvd 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
667 251356 Undocumented 2 :: 54 519 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989039.0 2111772.0 37.777890994652296 -122.481488924787 (37.7778909946523, -122.481488924787)
870 117001 DPW Maintained 3 :: 54 1X Bernal Heights Blvd 1 Front Yard : Yard 7 Tree 1 DPW 2                    
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            
1410 139164 Undocumented 2 :: 54 1975 POST ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6002726.0596 2114048.1262 37.784926980365206 -122.43430340574699 (37.7849269803652, -122.434303405747)
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)
1988 252845 DPW Maintained 3 :: 54 544 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/29/2014 12:00:00 AM   3x3   5993963.0 2110797.0 37.7754989773977 -122.46438440768401 (37.7754989773977, -122.464384407684)
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)
2526 141913 Undocumented 2 :: 54 900 MCALLISTER ST 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004416.1749 2111910.2001 37.779152551854104 -122.42830372330299 (37.7791525518541, -122.428303723303)
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)
3255 253377 Planning Code 138.1 required 4 :: 54 2 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
3275 253378 Planning Code 138.1 required 4 :: 54 2 Alpine Ter 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
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)
3345 253419 Planning Code 138.1 required 4 :: 54 3499 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997570.0 2115996.0 37.78998131889129 -122.452282225129 (37.7899813188913, -122.452282225129)
3620 139511 Undocumented 2 :: 54 1400 Fulton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6001017.0 2111110.0 37.776762480662704 -122.440005440059 (37.7767624806627, -122.440005440059)
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)
5050 253762 Planning Code 138.1 required 4 :: 54 520 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993490.0 2111935.0 37.778596343165496 -122.46610332918101 (37.7785963431655, -122.466103329181)
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            
6373 138089 Undocumented 2 :: 54 1600 SUTTER ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004809.7961 2114741.3813 37.7869485378128 -122.427143741054 (37.7869485378128, -122.427143741054)
7654 139157 Undocumented 2 :: 54 1699 FILLMORE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6003069.5459 2114034.3612 37.7849086753549 -122.433114070807 (37.7849086753549, -122.433114070807)
9914 173708 DPW Maintained 3 :: 54 126 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001214.0 2098705.0 37.7427125900371 -122.438434982469 (37.7427125900371, -122.438434982469)
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)
18412 247322 Undocumented 2 :: 54 218 Pierce St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6002795.6845 2109344.9924 37.7720173021936 -122.433726268045 (37.7720173021936, -122.433726268045)
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)
22368 183808 Undocumented 2 :: 54 1823 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987517.377 2100286.1656 37.7462654526109 -122.48590940972 (37.7462654526109, -122.48590940972)
22811 185829 Undocumented 2 :: 54 2061 34th Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985695.3610000005 2101217.9835 37.7487176270346 -122.49227823369301 (37.7487176270346, -122.492278233693)
22852 138173 Undocumented 2 :: 54 1953 GOLDEN GATE AVE 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     0 Width 0ft   6000211.2401 2111613.6154 37.7780993776744 -122.44282896766 (37.7780993776744, -122.44282896766)
23417 183167 Undocumented 2 :: 54 2422 45th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5982411.0498 2098597.3573 37.741329561902596 -122.50344114283101 (37.7413295619026, -122.503441142831)
23724 181665 Undocumented 2 :: 54 1275 34th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985511.3315 2106531.7973 37.7632971348656 -122.49330603001499 (37.7632971348656, -122.493306030015)
23777 183752 Undocumented 2 :: 54 2287 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987917.4443 2099749.9687 37.7448165037016 -122.484486720736 (37.7448165037016, -122.484486720736)
23835 182329 Undocumented 2 :: 54 1501 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985565.7361 2104954.3084 37.75896897093661 -122.493001657059 (37.7589689709366, -122.493001657059)
23845 142111 Undocumented 2 :: 54 36 HEMWAY TER 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5998636.7696 2110968.1942 37.7762373313333 -122.448229118378 (37.7762373313333, -122.448229118378)
23926 181820 Undocumented 2 :: 54 2299 Santiago St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985846.0311 2099546.7997 37.7441378151504 -122.491634223287 (37.7441378151504, -122.491634223287)
24053 181971 Undocumented 2 :: 54 2467 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985787.1457 2098434.4072 37.7410800425161 -122.49175595946801 (37.7410800425161, -122.491755959468)
24081 183742 Undocumented 2 :: 54 2278 25th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988578.8889999995 2099828.4885 37.745070593746796 -122.482205348546 (37.7450705937468, -122.482205348546)
24104 248307 Undocumented 2 :: 54 1323 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5999369.7066 2108379.5015 37.7691713129844 -122.44550750940901 (37.7691713129844, -122.445507509409)
24148 182529 Undocumented 2 :: 54 1583 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986203.973999999 2104470.5925 37.7576781250927 -122.490758769583 (37.7576781250927, -122.490758769583)
24206 181982 Undocumented 2 :: 54 2479 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986720.0054 2098392.2737 37.7410188327151 -122.488527415956 (37.7410188327151, -122.488527415956)
24275 184454 Undocumented 2 :: 54 2153 48th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981374.6331 2100381.1786 37.7461664541179 -122.507156946857 (37.7461664541179, -122.507156946857)
24313 184893 Undocumented 2 :: 54 1786 46th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5981952.8719 2102926.7078 37.753189803786896 -122.505346142178 (37.7531898037869, -122.505346142178)
24402 182453 Undocumented 2 :: 54 1500 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986555.3586 2104541.3333 37.7578928802813 -122.489548755928 (37.7578928802813, -122.489548755928)
24496 184100 Undocumented 2 :: 54 1614 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985016.0366 2104172.5195 37.756790232687 -122.494845106619 (37.756790232687, -122.494845106619)
24523 141857 Undocumented 2 :: 54 1100 TURK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004651.3626 2112630.8889 37.781144690344895 -122.42754147050199 (37.7811446903449, -122.427541470502)
24606 181614 Undocumented 2 :: 54 1246 36th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984927.2833 2106710.1633 37.7637526989564 -122.49533918573601 (37.7637526989564, -122.495339185736)
24662 124715 Undocumented 2 :: 54 599X 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002687.0 2100013.0 37.7463877287793 -122.433435226166 (37.7463877287793, -122.433435226166)
24683 183508 Undocumented 2 :: 54 2547 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5988598.1694 2097978.5588 37.7399922937625 -122.482003188533 (37.7399922937625, -122.482003188533)
24723 181788 Undocumented 2 :: 54 3131 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986265.505 2098198.358 37.740459860841 -122.49008463083 (37.740459860841, -122.49008463083)
24732 141579 Undocumented 2 :: 54 500 BAKER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000650.2876 2110740.0178 37.7757257205697 -122.44124745176501 (37.7757257205697, -122.441247451765)
24890 183769 Undocumented 2 :: 54 2295 28th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987606.9921 2099681.9039 37.7446115325485 -122.48555519813499 (37.7446115325485, -122.485555198135)
25062 247418 Undocumented 2 :: 54 1001 Fell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6002608.194 2110213.5869 37.7743916070028 -122.43443692499599 (37.7743916070028, -122.434436924996)
25160 244247 Undocumented 2 :: 54 200 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6005673.0642 2110022.6890000002 37.7740409443959 -122.423821374378 (37.7740409443959, -122.423821374378)
25293 182679 Undocumented 2 :: 54 2631 Moraga St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986083.8267 2103639.2241 37.7553883964845 -122.49111310108299 (37.7553883964845, -122.491113101083)
25460 181596 Undocumented 2 :: 54 1683 37th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5984674.4393 2103735.9717 37.7555715918184 -122.495994253801 (37.7555715918184, -122.495994253801)
25506 137920 Undocumented 2 :: 54 2028 FILLMORE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6002940.7431 2115305.2702 37.788390961736795 -122.433650548643 (37.7883909617368, -122.433650548643)
25583 139608 Undocumented 2 :: 54 1724 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6001827.9162 2112238.3787 37.7799068540457 -122.437281058847 (37.7799068540457, -122.437281058847)
25649 182532 Undocumented 2 :: 54 1581 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985581.6988 2104465.1884 37.7576269162189 -122.492910423341 (37.7576269162189, -122.492910423341)
25748 182187 Undocumented 2 :: 54 1622 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5989666.9072 2104289.3052 37.757382042273996 -122.47876940221 (37.757382042274, -122.47876940221)
25969 183335 Undocumented 2 :: 54 1211 43rd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5982706.9565 2106839.0545 37.7639763455704 -122.503028028557 (37.7639763455704, -122.503028028557)
25978 182524 Undocumented 2 :: 54 1579 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985892.4217 2104503.3998 37.757750000215005 -122.491838645138 (37.757750000215, -122.491838645138)
26076 181698 Undocumented 2 :: 54 1809 Lincoln Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5990006.9617 2107176.8497 37.7653302032624 -122.47780444851401 (37.7653302032624, -122.477804448514)
26178 186047 Undocumented 2 :: 54 1900 37th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984778.2299 2102058.2647 37.7509711496958 -122.495511585412 (37.7509711496958, -122.495511585412)
26182 142482 Undocumented 2 :: 54 1501 GRANT AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6010536.0572 2119686.9897 37.800850136387204 -122.407680928456 (37.8008501363872, -122.407680928456)
26491 184713 Undocumented 2 :: 54 1626 38th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984397.6244 2104083.8858 37.756510650266705 -122.496977229466 (37.7565106502667, -122.496977229466)
26507 184509 Undocumented 2 :: 54 1886 Lower Great Hwy 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981125.5546 2102268.3878 37.751333525850896 -122.50815826243401 (37.7513335258509, -122.508158262434)

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