Street_Tree_List

Data source: data.sfgov.org

295 rows where SiteOrder = 1 and qSpecies = 45 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize

SiteOrder

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
21370 22 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 725 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2017 08:22:00 AM 3 3X3   6003898.66598 2107719.95316 37.7676178644975 -122.429795042015 (37.7676178644975, -122.429795042015)
19634 31 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 753 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/2016 06:04:00 AM 3 3X3   6003785.60824 2107710.67637 37.7675859898405 -122.430185432325 (37.7675859898405, -122.430185432325)
20666 33 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 755 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/17/1998 12:00:00 AM 3 3X3   6003762.7674 2107707.98129 37.7675772960935 -122.43026424352199 (37.7675772960935, -122.430264243522)
18331 34 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 759 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6003742.09963 2107707.8799900003 37.767575847275204 -122.430335723414 (37.7675758472752, -122.430335723414)
83025 7243 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 1929X Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6002956.0424065 2114080.0912444 37.7850277993699 -122.43351002509701 (37.7850277993699, -122.433510025097)
126995 9330 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 159 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2015 03:37:00 AM 3 3x3   6000991.502255901 2098643.2192577 37.7425302962209 -122.439199887043 (37.7425302962209, -122.439199887043)
79717 10670 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1045 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6002868.606349099 2110598.6567928 37.775463691965896 -122.43356363564301 (37.7754636919659, -122.433563635643)
105619 11343 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1300X Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/1999 12:00:00 AM 16 3X3   6017347.6886145 2093992.5867035 37.730677746775605 -122.382320962891 (37.7306777467756, -122.382320962891)
143705 13408 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 364 Marietta Dr 1 Median : Cutout 11 Tree 1 DPW 2     45 5   5999660.108164 2097381.7238333 37.738990678772396 -122.443712833155 (37.7389906787724, -122.443712833155)
113357 18570 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 698X Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/1997 12:00:00 AM 6 3X3   5992368.005846401 2088553.4079402 37.7143316913291 -122.46828327353701 (37.7143316913291, -122.468283273537)
17486 18596 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 409 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/26/1996 12:00:00 AM 6 3X3   5992903.2652 2088492.7734 37.7141961040887 -122.46642881780501 (37.7141961040887, -122.466428817805)
113563 18603 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 520 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/25/1996 12:00:00 AM 6 3X3   5992619.61154 2088559.40218 37.7143626789426 -122.467414068351 (37.7143626789426, -122.467414068351)
21649 18607 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 530 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/26/1996 12:00:00 AM 6 3x3   5992558.0676 2088557.0731 37.7143527306111 -122.467626617395 (37.7143527306111, -122.467626617395)
17788 18608 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 550 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/1997 12:00:00 AM 6 3X3   5992502.2173 2088557.38 37.7143503484358 -122.467819678694 (37.7143503484358, -122.467819678694)
98414 22550 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 23 Topaz Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2008 12:00:00 AM 4 2x3   6001475.729427099 2098645.6307198997 37.742564460006896 -122.437525748228 (37.7425644600069, -122.437525748228)
111533 25183 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 3448X Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/19/1996 12:00:00 AM 6 3X3   6000085.2661190005 2103906.7160847997 37.7569309776636 -122.442711229464 (37.7569309776636, -122.442711229464)
18385 25468 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 437 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/26/1996 12:00:00 AM 6 3X3   5992774.4094 2088493.0908 37.7141895393891 -122.466874212626 (37.7141895393891, -122.466874212626)
17804 26068 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 282 Orizaba Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/27/2003 12:00:00 AM 3 2X3   5994051.2236 2088339.7969 37.7138422407476 -122.46244996961 (37.7138422407476, -122.46244996961)
18943 26157 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 260 Orizaba Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/27/1997 12:00:00 AM 3 3X3   5994051.6997 2088243.7899 37.713578655736 -122.462441364614 (37.713578655736, -122.462441364614)
15769 30659 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 54 Lafayette St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/13/2015 12:00:00 AM 3 3x3 Permit Number 34592 6007591.74325 2109572.72569 37.7729135790239 -122.41715242667 (37.7729135790239, -122.41715242667)
130691 30907 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2363 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1996 12:00:00 AM 4   Permit Number 37373 5987310.298054401 2099201.63941585 37.743275562979605 -122.486545838163 (37.7432755629796, -122.486545838163)
29132 31972 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 100 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/1995 12:00:00 AM 5   Permit Number 35372 5995228.46958 2114784.79077 37.786521248530995 -122.46029586964701 (37.786521248531, -122.460295869647)
147065 32517 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 837 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM 5   Permit Number 39421 6007583.92915 2095468.81341 37.734187007231796 -122.41618038453998 (37.7341870072318, -122.41618038454)
40556 32518 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 842 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/23/2007 12:00:00 AM 9   Permit Number 49664 6007548.7449 2095423.3131 37.7340600948986 -122.41629880637 (37.7340600948986, -122.41629880637)
183550 32520 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 848 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/15/1996 12:00:00 AM 6   Permit Number 37022 6007545.9989 2095398.0670900003 37.7339906204551 -122.416306512649 (37.7339906204551, -122.416306512649)
60527 32523 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 861 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/15/1996 12:00:00 AM 8   Permit Number 37025 6007568.6691 2095324.89508 37.7337909808565 -122.416222953925 (37.7337909808565, -122.416222953925)
68843 32524 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 862 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/15/1996 12:00:00 AM 4   Permit Number 37026 6007537.57048 2095302.13495 37.733726737790796 -122.416328859904 (37.7337267377908, -122.416328859904)
54592 32576 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1366 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 2   Permit Number 37050 5986201.05883385 2105941.9596711 37.7617179230551 -122.49087711798 (37.7617179230551, -122.49087711798)
176744 32595 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1383 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 2   Permit Number 37063 5985531.94877095 2105814.83097448 37.7613297510328 -122.49318190152901 (37.7613297510328, -122.493181901529)
66939 32596 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1474 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 2   Permit Number 37064 5985605.53989408 2105188.12612078 37.759613297357895 -122.492881221287 (37.7596132973579, -122.492881221287)
54735 32597 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1478 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 2   Permit Number 37065 5985606.43921528 2105161.9851204 37.759541574007 -122.492876185531 (37.759541574007, -122.492876185531)
29717 32611 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2926 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 0   Permit Number 37076 5985807.8579886 2105043.58172562 37.7592282476447 -122.492170870983 (37.7592282476447, -122.492170870983)
141851 32857 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 499 Hoffman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/30/1996 12:00:00 AM     Permit Number 37207 6000703.6978076 2101134.48618072 37.7493543400616 -122.440373654783 (37.7493543400616, -122.440373654783)
118244 32863 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 369 Jersey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/1996 12:00:00 AM     Permit Number 37210 6002757.72867407 2101496.8738153 37.7504661097568 -122.433296668218 (37.7504661097568, -122.433296668218)
92257 33453 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 343 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/20/1996 12:00:00 AM     Permit Number 37554 6006165.48085512 2098035.43238588 37.7411545114342 -122.421266615711 (37.7411545114342, -122.421266615711)
128723 33551 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 242 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1996 12:00:00 AM     Permit Number 37659 6007042.9412775 2097614.40669633 37.740047898701604 -122.418202822848 (37.7400478987016, -122.418202822848)
25175 34531 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 635 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/1997 12:00:00 AM 5   Permit Number 38240 5988437.8449 2111647.649 37.7775145896121 -122.483559386935 (37.7775145896121, -122.483559386935)
126722 34910 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 234 Orizaba Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/23/1997 12:00:00 AM     Permit Number 38511 5994034.02525385 2087990.46611796 37.712882070912 -122.462484089909 (37.712882070912, -122.462484089909)
146231 34936 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 11 Whitney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/1997 12:00:00 AM     Permit Number 38531 6004292.24994663 2098281.86304207 37.741725367299104 -122.427761131369 (37.7417253672991, -122.427761131369)
93817 35102 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 778 Edinburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767512 6001912.66160072 2089308.81779253 37.716952534231794 -122.435347237927 (37.7169525342318, -122.435347237927)
50125 35432 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1506 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/16/1998 12:00:00 AM 7   Permit Number 38878 6014141.4984800005 2102013.02263 37.7525225775725 -122.39396657421499 (37.7525225775725, -122.393966574215)
14122 35743 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/1998 12:00:00 AM     Permit Number 39016          
136514 35869 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1 Boutwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/24/1998 12:00:00 AM 6   Permit Number 39080 6010666.93779 2096840.63562 37.7381266097475 -122.40561798198799 (37.7381266097475, -122.405617981988)
120373 35894 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 225 Industrial St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/24/1998 12:00:00 AM     Permit Number 39088 6010847.02207847 2096940.13108018 37.7384098714444 -122.405002340826 (37.7384098714444, -122.405002340826)
124738 37419 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 557 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM     Permit Number 39897 6002931.14322816 2099749.14332352 37.7456770883652 -122.432572163971 (37.7456770883652, -122.432572163971)
141016 37981 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1199 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/06/1998 12:00:00 AM     Permit Number 40204 6015599.59779117 2103398.4652457 37.756407638243296 -122.38902089785499 (37.7564076382433, -122.389020897855)
99110 38000 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2454 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/08/1998 12:00:00 AM     Permit Number 40212 5992064.31245936 2098735.51233127 37.742271675931896 -122.47007391125601 (37.7422716759319, -122.470073911256)
128574 38029 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2490X 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1998 12:00:00 AM     Permit Number 40235 5992179.14418088 2098457.94829189 37.7415161934278 -122.46965666006399 (37.7415161934278, -122.469656660064)
114634 38033 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1400 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1998 12:00:00 AM     Permit Number 40236 5991713.73808693 2098444.67646581 37.7414528421268 -122.471264893104 (37.7414528421268, -122.471264893104)
99913 38034 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 71 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1998 12:00:00 AM     Permit Number 40237 5993126.63617522 2098605.576855 37.7419762612493 -122.466391311334 (37.7419762612493, -122.466391311334)
87400 38061 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1802 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1998 12:00:00 AM     Permit Number 40254 6001102.14351194 2114546.50782632 37.786203101297396 -122.439957367186 (37.7862031012974, -122.439957367186)
11876 38200 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 514 Goettingen St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2002 12:00:00 AM 12 3x3 Permit Number 45184 6010449.69037 2092207.2371 37.7253921259422 -122.406042793857 (37.7253921259422, -122.406042793857)
83910 38217 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 350 Wayland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/17/1998 12:00:00 AM     Permit Number 40338 6010576.45287423 2092372.10995681 37.7258519216371 -122.405616192564 (37.7258519216371, -122.405616192564)
82592 38845 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1333 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1998 12:00:00 AM     Permit Number 40675 5989863.06342131 2106288.82741716 37.76288358166779 -122.47823721882601 (37.7628835816678, -122.478237218826)
66650 38870 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1551 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 2   Permit Number 43029 5989746.74182688 2105808.42580632 37.7615577752966 -122.47860439661501 (37.7615577752966, -122.478604396615)
101850 38881 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 101 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1998 12:00:00 AM     Permit Number 40703 5996508.72142362 2113802.71293841 37.7838982845648 -122.455795523067 (37.7838982845648, -122.455795523067)
77080 38895 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 123 Parker Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1998 12:00:00 AM 4   Permit Number 40710 5996840.66245358 2113625.05698332 37.7834295330259 -122.454634297306 (37.7834295330259, -122.454634297306)
111478 39381 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1367 Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/28/2001 12:00:00 AM     Permit Number 43822 6007199.57850018 2107537.80288531 37.7673040926749 -122.418364663242 (37.7673040926749, -122.418364663242)
159694 39695 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1583 Shafter Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1999 12:00:00 AM 7   Permit Number 41080 6014997.8516 2094075.2851 37.730774746396 -122.390450554434 (37.730774746396, -122.390450554434)
80145 39731 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3472 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1999 12:00:00 AM     Permit Number 41103 6003734.27078033 2106581.04610194 37.7644813903829 -122.430282399811 (37.7644813903829, -122.430282399811)
167372 40008 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 950 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM 8   Permit Number 41261 6018990.20826 2094681.6711099998 37.7326604269313 -122.376690235261 (37.7326604269313, -122.376690235261)
96051 40031 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1656 Newcomb Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM     Permit Number 41273 6014957.20136248 2095924.63791994 37.7358504391775 -122.390720277971 (37.7358504391775, -122.390720277971)
86331 40032 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1660 Newcomb Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM     Permit Number 41274 6014934.45622927 2095941.56583888 37.7358956578297 -122.390800100159 (37.7358956578297, -122.390800100159)
64837 40044 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1322 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM 1   Permit Number 41281 6016731.9607 2093562.0843 37.729461643225704 -122.384419676567 (37.7294616432257, -122.384419676567)
102334 40175 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1779 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1999 12:00:00 AM     Permit Number 41366 6008032.61088554 2108096.47604813 37.7688849366199 -122.415522872015 (37.7688849366199, -122.415522872015)
75380 40197 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4845 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1999 12:00:00 AM 5   Permit Number 41381 5983545.15866 2111697.12052 37.7773644306872 -122.50048820674401 (37.7773644306872, -122.500488206744)
117895 40701 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 547 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/10/1999 12:00:00 AM     Permit Number 41680 6005025.18813412 2093548.59411277 37.7287703058889 -122.424890201858 (37.7287703058889, -122.424890201858)
78673 40783 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 410 Monticello St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/16/1999 12:00:00 AM     Permit Number 41739 5991762.23808711 2091284.45671221 37.7217954779898 -122.470575817994 (37.7217954779898, -122.470575817994)
26737 41177 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1555 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/23/1999 12:00:00 AM 3   Permit Number 41896 6002761.3685800005 2121278.33423 37.804781267115104 -122.43469844348301 (37.8047812671151, -122.434698443483)
70953 41210 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3537 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/29/1999 12:00:00 AM 2   Permit Number 41919 6002146.81597 2120360.9832900004 37.8022275558181 -122.436759454895 (37.8022275558181, -122.436759454895)
70411 41218 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 21 Mallorca Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/2005 12:00:00 AM 5   Permit Number 41926 6001937.22199 2119965.3728 37.8011293999489 -122.43745640431001 (37.8011293999489, -122.43745640431)
125273 41593 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 538 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM     Permit Number 43228 6003084.80949648 2098934.42438565 37.7434487728436 -122.431982642828 (37.7434487728436, -122.431982642828)
80885 41663 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1376 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42129 5999046.52257313 2104716.21389633 37.7590943881005 -122.44636181286998 (37.7590943881005, -122.44636181287)
78865 41694 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 444 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42146 6003561.9148943005 2096429.88916823 37.7365989305362 -122.430154297904 (37.7365989305362, -122.430154297904)
95064 41700 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 135 Moffitt St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42150 6002619.11270974 2096812.53264581 37.7375961375204 -122.43344130209499 (37.7375961375204, -122.433441302095)
91962 41706 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 235 Surrey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42155 6001936.91803675 2096162.95952183 37.7357738321427 -122.435753508421 (37.7357738321427, -122.435753508421)
145443 41726 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 99X 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702)
121751 41727 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1803 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702)
109498 41751 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1100 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42181 6009068.76416013 2116381.28511649 37.7916912386009 -122.41252459171899 (37.7916912386009, -122.412524591719)
44130 41755 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1630 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/2000 12:00:00 AM 5   Permit Number 42184 6008378.01882 2118113.9596 37.79640994672071 -122.415037267971 (37.7964099467207, -122.415037267971)
106034 41818 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 66 Encanto Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM     Permit Number 42204 6000020.46726166 2112594.97224476 37.7807830542731 -122.44355943151699 (37.7807830542731, -122.443559431517)
144346 41875 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 66 Belcher St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM     Permit Number 42253 6003778.26782897 2107952.91484982 37.768250702181504 -122.430228105724 (37.7682507021815, -122.430228105724)
114768 42054 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 326 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42369 6006171.20759912 2101208.97418807 37.749868660690005 -122.42147214171999 (37.74986866069, -122.42147214172)
143720 42161 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2010 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42456 5989367.84309334 2111281.28093807 37.776562731283796 -122.480315427669 (37.7765627312838, -122.480315427669)
178425 42274 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1522 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM 5   Permit Number 42512 5987167.45157267 2104900.21174724 37.7589139779601 -122.48745827105 (37.7589139779601, -122.48745827105)
162768 42678 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1097 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM 8   Permit Number 42702 6007821.24509 2118860.5405 37.7984285685682 -122.417016754032 (37.7984285685682, -122.417016754032)
120057 42682 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1646 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM 1 3x3 Permit Number 49825 5999927.74605546 2110588.07160314 37.7752673299483 -122.443735976936 (37.7752673299483, -122.443735976936)
144305 42698 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1659 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/2002 12:00:00 AM     Permit Number 45472 6009187.38661424 2118931.29098858 37.798699585947 -122.412294470142 (37.798699585947, -122.412294470142)
107845 42769 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1045 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42745 6002868.75255453 2110597.66752235 37.7754609839703 -122.43356305917 (37.7754609839703, -122.43356305917)
143527 42777 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 65 Hermann St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/2004 12:00:00 AM     Permit Number 47615 6004966.00219495 2108807.30598956 37.7706638565131 -122.42618068058701 (37.7706638565131, -122.426180680587)
141720 42953 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2490X Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/11/2016 12:00:00 AM 3   Permit Number 778307 6000770.46048888 2116827.23264279 37.792446492390205 -122.441268603286 (37.7924464923902, -122.441268603286)
10245 43062 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 490 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2017 12:00:00 AM 3 3x3 Permit Number 51464 5985348.18764 2112571.6735099996 37.779871377757296 -122.49431551232401 (37.7798713777573, -122.494315512324)
134013 43231 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1371 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 3   Permit Number 43018 5989871.41437878 2106041.52738456 37.7622050471688 -122.47819025383801 (37.7622050471688, -122.478190253838)
135718 43234 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1442 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 0   Permit Number 43021 5989629.54713999 2105535.31198119 37.760801073285705 -122.478989743073 (37.7608010732857, -122.478989743073)
125793 43585 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 237 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM     Permit Number 43246 6004367.379779 2099245.61051184 37.7443758465625 -122.427570002743 (37.7443758465625, -122.427570002743)
49623 43808 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1420 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/26/2000 12:00:00 AM 1   Permit Number 43438 5991181.63114 2110671.05879 37.77499245989021 -122.473996541351 (37.7749924598902, -122.473996541351)
126645 44207 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 701 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2000 12:00:00 AM     Permit Number 43655 6009221.06713893 2115299.96241651 37.7887307349007 -122.411921176175 (37.7887307349007, -122.411921176175)
133840 44311 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 339 Walnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/02/2001 12:00:00 AM 1   Permit Number 43708 5998562.918 2115355.99866 37.788280875801505 -122.44880071158899 (37.7882808758015, -122.448800711589)
113228 46365 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4529 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/20/2016 12:00:00 AM 3   Permit Number 777876 6000886.82649096 2105194.29533435 37.7605120176306 -122.44003146279199 (37.7605120176306, -122.440031462792)
79175 47698 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 297 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/2002 12:00:00 AM     Permit Number 45496 6000129.38189454 2094930.1458917998 37.732285975496104 -122.44191439219401 (37.7322859754961, -122.441914392194)

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