Street_Tree_List

Data source: data.sfgov.org

11,394 rows where qSpecies = 15 sorted by qLegalStatus

View and edit SQL

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28 21823 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2741 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/19/2006 12:00:00 AM 3 4x4   6008229.33947 2122327.41953 37.8079706947476 -122.415850241604 (37.8079706947476, -122.415850241604)
33 2889 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1545 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     65 3X3   6006951.47041 2116025.01423 37.79059395549061 -122.419825138035 (37.7905939554906, -122.419825138035)
55 2909 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1700 California St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 4X4   6006037.49643 2115968.63965 37.7903876339283 -122.422983431149 (37.7903876339283, -122.422983431149)
75 138824 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 729 GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6004305.1004 2111150.1162 37.77705926326529 -122.428633779399 (37.7770592632653, -122.428633779399)
111 7749 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 400X Franklin St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3X3   6006371.15759 2111615.2483900003 37.7784531123456 -122.421519673008 (37.7784531123456, -122.421519673008)
157 3193 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3698 California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X3   5996969.37189 2114704.2549799997 37.7864001056199 -122.454266992435 (37.7864001056199, -122.454266992435)
180 18700 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 100X Richardson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5999457.6873699995 2119517.78462 37.799759164102895 -122.44600442526199 (37.7997591641029, -122.446004425262)
200 134567 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   07/06/2011 12:00:00 AM 4 Width 4ft   6007561.6986 2111595.58464 37.778466176805296 -122.417399738421 (37.7784661768053, -122.417399738421)
203 134565 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     15 Width 4ft   6007431.26589 2111583.6583 37.7784260904314 -122.41785010990299 (37.7784260904314, -122.417850109903)
205 134566 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     14 Width 4ft   6007493.55732 2111589.9734900002 37.7784469358085 -122.417635067622 (37.7784469358085, -122.417635067622)
209 134568 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   12/17/2009 12:00:00 AM 5 Width 4ft   6007669.37768 2111613.23365 37.778520694605795 -122.41702848568501 (37.7785206946058, -122.417028485685)
214 251244 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.778441154342296 -122.41816626519301 (37.7784411543423, -122.418166265193)
356 5230 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1051 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2004 12:00:00 AM 3 4x4   6001389.4157 2112056.3671 37.7793821590717 -122.43878497743201 (37.7793821590717, -122.438784977432)
408 23369 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1350 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 4x4   6006387.07969 2115184.64805 37.788254707334 -122.421718185767 (37.788254707334, -122.421718185767)
422 23174 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 240 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     5 3x3   6006908.21847 2111432.04348 37.777980343250796 -122.419648771078 (37.7779803432508, -122.419648771078)
435 95185 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1401X Divisadero St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6001223.4102 2113260.1588 37.78267801898829 -122.43944557401699 (37.7826780189883, -122.439445574017)
488 2821 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6008831.67633 2116355.92064 37.7916082855564 -122.41334312239701 (37.7916082855564, -122.413343122397)
534 2998 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2314 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6003265.59996 2115577.92692 37.7891580349704 -122.43254607984501 (37.7891580349704, -122.432546079845)
550 3006 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2380 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     75 3X3   6002989.49365 2115542.57517 37.7890453067372 -122.433498845012 (37.7890453067372, -122.433498845012)
589 26916 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1901 Geary Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     18 3X3   6002555.1851 2113680.9302 37.783909052953 -122.43486830704398 (37.783909052953, -122.434868307044)
612 23503 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2550 Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6005820.29029 2119236.56275 37.7993482683535 -122.42396743424999 (37.7993482683535, -122.42396743425)
730 195047 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 360 06th St 2 : 4 Tree 1 DPW 2   03/26/2005 12:00:00 AM 3 Width 3ft Permit Number 42039 6011214.59355 2111232.18316 37.777673209496605 -122.404737337955 (37.7776732094966, -122.404737337955)
917 8555 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2141 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3X3   6001312.669 2113446.883 37.7831957953331 -122.43915016448999 (37.7831957953331, -122.43915016449)
997 95184 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1401X Divisadero St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6001220.026000001 2113275.7262 37.7827205704951 -122.439458398161 (37.7827205704951, -122.439458398161)
1061 7724 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 211 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/16/2012 12:00:00 AM 3 3x3 Permit Number 767727 6006415.79653 2110907.1088900003 37.7765112494182 -122.421314949539 (37.7765112494182, -122.421314949539)
1085 245467 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3286 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/10/2004 12:00:00 AM 6 Width 0ft   6006306.9956 2099162.9834 37.7442584900037 -122.42085734017799 (37.7442584900037, -122.420857340178)
1115 2987 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2266X California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6003539.7936 2115618.85396 37.7892859554236 -122.431600327591 (37.7892859554236, -122.431600327591)
1123 28040 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1500 The Embarcadero 8 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6011973.34792 2120976.9306 37.8044723526732 -122.40279804081499 (37.8044723526732, -122.402798040815)
1136 3286 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 4620 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5993188.57682 2114188.1560400003 37.784765502430794 -122.467309935148 (37.7847655024308, -122.467309935148)
1198 3004 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2361 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6003049.1023 2115481.5645 37.788881168762295 -122.433288245694 (37.7888811687623, -122.433288245694)
1319 23465 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2305 Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3X3   6005845.91849 2118326.2505200002 37.796850228717105 -122.42381398834699 (37.7968502287171, -122.423813988347)
1415 9957 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 165X Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 4x4   6007023.214790001 2111521.59802 37.778232715494205 -122.41925731148399 (37.7782327154942, -122.419257311484)
1478 2891 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1555 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     65 3x3   6006907.6574099995 2116020.89539 37.7905801778777 -122.419976436385 (37.7905801778777, -122.419976436385)
1506 3068 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2848 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6000738.310819999 2115229.75603 37.788058406004296 -122.441265170758 (37.7880584060043, -122.441265170758)
1584 3173 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3506 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/01/1992 12:00:00 AM 6 3X3   5997608.68374 2114790.70836 37.786674124564 -122.45206138623301 (37.786674124564, -122.452061386233)
1685 251478 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2x Virginia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 02/21/2004 12:00:00 AM   3x3   6006146.0 2098692.0 37.7429562000135 -122.42138058886101 (37.7429562000135, -122.421380588861)
1692 2957 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2045 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004590.8896 2115694.3359 37.7895527302687 -122.427969040021 (37.7895527302687, -122.427969040021)
1721 23308 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1000 Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/1998 12:00:00 AM 5 3X3   6006538.20918 2114040.94612 37.785122904641796 -122.42111406077 (37.7851229046418, -122.42111406077)
1899 25838 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 800X The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   10/30/1995 12:00:00 AM 6 4X4   6013225.308119999 2119220.74162 37.7997201038678 -122.39834219506099 (37.7997201038678, -122.398342195061)
1925 2958 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2055 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004523.0139999995 2115687.6045 37.7895304073237 -122.428203402517 (37.7895304073237, -122.428203402517)
1989 133618 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 150 Richardson Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   5999272.2292 2119684.41545 37.8002060956892 -122.446658172159 (37.8002060956892, -122.446658172159)
2018 238617 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 4302 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2012 12:00:00 AM 5 Width 4ft Permit Number 769743 6001157.09349 2101748.35409 37.751065679453504 -122.438849790481 (37.7510656794535, -122.438849790481)
2024 139198 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1900 GEARY BLVD 26 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     18 Width 0ft   6001803.3539 2113704.6103 37.783931357581395 -122.437471057097 (37.7839313575814, -122.437471057097)
2033 139199 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1900 GEARY BLVD 27 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     19 Width 0ft   6001773.0984 2113703.8723 37.7839276110688 -122.437575676931 (37.7839276110688, -122.437575676931)
2088 3013 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2450 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002627.84431 2115492.11411 37.7888862283618 -122.43474649336599 (37.7888862283618, -122.434746493366)
2090 25842 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 800X The Embarcadero 6 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   10/30/1995 12:00:00 AM 6 4X4   6013279.137069999 2119139.97441 37.799501334781795 -122.398150256355 (37.7995013347818, -122.398150256355)
2167 3158 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3410 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   5998012.98689 2114846.6357400003 37.7868508368504 -122.45066663485201 (37.7868508368504, -122.450666634852)
2205 123677 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 4308 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5994223.96504 2114319.57116 37.7851860492976 -122.46373740171002 (37.7851860492976, -122.46373740171)
2298 108161 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2559 Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2014 12:00:00 AM 3 3x3 Permit Number 770697 6005729.40099 2119172.75383 37.79916793360329 -122.424277402689 (37.7991679336033, -122.424277402689)
2314 138948 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 738 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/07/2008 12:00:00 AM 4 Width 0ft Permit Number 51651 6004303.429 2110848.9359 37.7762322016228 -122.428618087069 (37.7762322016228, -122.428618087069)
2320 1739 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 111 Bay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13   08/19/2006 12:00:00 AM 3     6010211.1306 2121614.8438 37.8061253525476 -122.408941413862 (37.8061253525476, -122.408941413862)
2388 12913 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 200 Larkin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Asian Arts Commission 16     50 3X3   6007759.03449 2112296.07509 37.7804006563122 -122.416766716427 (37.7804006563122, -122.416766716427)
2430 201600 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 98 Kirkwood Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020594.26008 2092766.53995 37.7274900446232 -122.371012172182 (37.7274900446232, -122.371012172182)
2441 201599 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 98 Kirkwood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020607.895690001 2092757.2128700002 37.72746518285071 -122.37096438849899 (37.7274651828507, -122.370964388499)
2456 201598 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 98 Kirkwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020624.74965 2092745.3424200001 37.7274335141325 -122.370905303063 (37.7274335141325, -122.370905303063)
2491 235511 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1002 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/1982 12:00:00 AM 25 Width 4ft Permit Number 20185 5998857.80295 2106434.63527 37.7638019637156 -122.4471381628 (37.7638019637156, -122.4471381628)
2539 141221 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3749 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/1994 12:00:00 AM 15 Width 0ft Permit Number 33472 5996558.7733 2114582.8804 37.7860432889249 -122.45567877478399 (37.7860432889249, -122.455678774784)
2730 7762 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 455 Franklin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6006322.26322 2111614.07343 37.7784471291735 -122.421688733864 (37.7784471291735, -122.421688733864)
2810 23452 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2209 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6005880.951090001 2118079.82441 37.796175582497504 -122.423675237326 (37.7961755824975, -122.423675237326)
2826 28035 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1500 The Embarcadero 3 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6011869.41049 2121075.03017 37.804735906188796 -122.403164632367 (37.8047359061888, -122.403164632367)
2877 2888 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1541 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     65 3X3   6007004.32462 2116031.27674 37.7906141281881 -122.41964270965201 (37.7906141281881, -122.419642709652)
2941 246063 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 657 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft Permit Number 41993 5998975.8774 2108455.663 37.769357942133205 -122.446875218626 (37.7693579421332, -122.446875218626)
2942 95170 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1306 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/2015 12:00:00 AM 3 3x3   6001329.6747 2112935.9507 37.781793873207 -122.439054702012 (37.781793873207, -122.439054702012)
3114 25811 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1300X The Embarcadero 7 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   10/15/1995 12:00:00 AM 6 4X4   6012315.257619999 2120560.3270799997 37.8033475454092 -122.401585526252 (37.8033475454092, -122.401585526252)
3160 109437 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 940 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x6   6003136.3777 2111029.1486 37.7766609049 -122.432668109569 (37.7766609049, -122.432668109569)
3168 33093 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
3185 3123 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3195 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X2   5999194.2227 2114949.0037 37.787199455340705 -122.44658721654801 (37.7871994553407, -122.446587216548)
3277 3186 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3633 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   5997046.4391 2114650.2263 37.7862561763922 -122.45399645741999 (37.7862561763922, -122.45399645742)
3301 3014 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2450 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 3X3   6002569.4448 2115483.65814 37.7888596947603 -122.43494794241501 (37.7888596947603, -122.434947942415)
3391 2983 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2226 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6003696.67837 2115640.99047 37.7893556277051 -122.431059105706 (37.7893556277051, -122.431059105706)
3415 58712 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 688 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/10/1979 12:00:00 AM 12 3x3 Permit Number 17946 6004581.34636 2110890.2862299997 37.776361463754604 -122.427659641397 (37.7763614637546, -122.427659641397)
3442 2868 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1389 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6007715.890269999 2116130.82655 37.790927523941704 -122.417187783496 (37.7909275239417, -122.417187783496)
3452 2818 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6008957.0218 2116372.57941 37.79166106316271 -122.412910605154 (37.7916610631627, -122.412910605154)
3454 23347 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1245 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 0   6006327.19373 2114871.36437 37.7873911306548 -122.421903118752 (37.7873911306548, -122.421903118752)
3457 108164 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1501X Filbert St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2014 12:00:00 AM 3 3x3 Permit Number 770697 6005639.99861 2119248.14004 37.7993698763863 -122.42459213123301 (37.7993698763863, -122.424592131233)
3460 249511 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1243 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6006333.62129 2114827.84877 37.7872720100542 -122.421877788428 (37.7872720100542, -122.421877788428)
3631 133550 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3498 Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/07/2014 12:00:00 AM 1 Width 3ft Permit Number 772596 5998146.13345 2115528.5550599997 37.7887308273139 -122.450255153677 (37.7887308273139, -122.450255153677)
3633 133551 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3498 Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/07/2014 12:00:00 AM 1 Width 3ft Permit Number 772596 5998134.73529 2115528.0239 37.788728716592104 -122.45029455117701 (37.7887287165921, -122.450294551177)
3638 2840 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1255 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6008320.47773 2116218.27733 37.7912016363983 -122.41510212258301 (37.7912016363983, -122.415102122583)
3657 25806 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1300X The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   10/15/1995 12:00:00 AM 6 4X4   6012234.78854 2120695.21971 37.8037134372885 -122.401873481994 (37.8037134372885, -122.401873481994)
3673 3073 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2880 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/12/1998 12:00:00 AM 3 3X3   6000583.9217 2115208.18648 37.7879903857924 -122.44179777983999 (37.7879903857924, -122.44179777984)
3684 27830 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 900X The Embarcadero 3 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/20/2000 12:00:00 AM 24     6013136.88249 2119351.75589 37.800074911578 -122.398657381345 (37.800074911578, -122.398657381345)
3722 2900 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1675 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6006330.22809 2115940.35545 37.7903264863286 -122.4219685876 (37.7903264863286, -122.4219685876)
3836 3098 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3014 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   5999901.41366 2115112.8463 37.7876896938595 -122.444152274206 (37.7876896938595, -122.444152274206)
3878 28034 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1500 The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6011851.06099 2121093.24306 37.8047848895665 -122.403229415001 (37.8047848895665, -122.403229415001)
3891 2801 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1000X California St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3X3   6009324.7749 2116423.80567 37.791822353872796 -122.411641798449 (37.7918223538728, -122.411641798449)
4009 34002 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 37940          
4171 39901 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2002 12:00:00 AM     Permit Number 41185          
4198 25837 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 800X The Embarcadero 1 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   10/30/1995 12:00:00 AM 6 4X4   6013209.63865 2119244.79078 37.7997852642353 -122.39839810591299 (37.7997852642353, -122.398398105913)
4234 28039 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1500 The Embarcadero 7 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6011949.43377 2121001.73319 37.8045391192453 -122.402882543817 (37.8045391192453, -122.402882543817)
4313 2803 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1055 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3X3   6009318.69522 2116357.3469700003 37.791639533399795 -122.41165813642999 (37.7916395333998, -122.41165813643)
4339 3082 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2913 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6000319.2838 2115099.7465 37.7876775552832 -122.442705587482 (37.7876775552832, -122.442705587482)
4361 2887 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1530 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     65 3x3   6007023.220480001 2116101.4928900003 37.7908079887437 -122.41958231479401 (37.7908079887437, -122.419582314794)
4460 55487 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 601 Steiner St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/16/1987 12:00:00 AM 20 6x9 Permit Number 24565 6003098.1372 2110364.0779 37.774832616894706 -122.43275287348601 (37.7748326168947, -122.432752873486)
4495 2802 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1055 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3X3   6009267.5769 2116351.4322900004 37.7916204254988 -122.411834587904 (37.7916204254988, -122.411834587904)
4628 3096 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3003 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   5999955.8775 2115049.7006 37.787519419160795 -122.443959301682 (37.7875194191608, -122.443959301682)
4670 9956 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 155 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     12 4X4   6007076.052730001 2111529.8614 37.7782583803491 -122.41907511154801 (37.7782583803491, -122.419075111548)
4737 18665 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 68 Richardson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5999650.82657 2119343.62461 37.799291994198796 -122.445323565644 (37.7992919941988, -122.445323565644)
4784 248429 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 735 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5998546.7685 2108037.7588 37.7681859595657 -122.448329381959 (37.7681859595657, -122.448329381959)
4818 2858 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1350 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3X3   6007920.97179 2116228.0555 37.7912060259903 -122.416485098214 (37.7912060259903, -122.416485098214)

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