Street_Tree_List

Data source: data.sfgov.org

616 rows where qSpecies = 45 sorted by Location

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
10851 52794 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
10944 35742 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/1998 12:00:00 AM     Permit Number 39016          
10980 52793 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
13065 52792 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
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          
131206 179380 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 77 Santa Cruz Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5993077.06779 2086425.7469099998 37.7085305695939 -122.46567800964199 (37.7085305695939, -122.465678009642)
43641 179373 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 670 Brunswick St 17 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7     5998557.70629 2086647.36142 37.709453678716706 -122.446752254708 (37.7094536787167, -122.446752254708)
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)
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)
160254 48460 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 102 Pope St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2002 12:00:00 AM 2   Permit Number 45825 6000209.55112 2088191.07942 37.71378660783029 -122.44115390123999 (37.7137866078303, -122.44115390124)
174549 179376 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 11 Cross St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6000146.4091300005 2088205.43619 37.7138224314379 -122.441373172128 (37.7138224314379, -122.441373172128)
148592 179377 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 11 Cross St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6000163.43149 2088211.60643 37.7138403432439 -122.441314779179 (37.7138403432439, -122.441314779179)
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)
26795 179378 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2016 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6012163.289480001 2088075.41369 37.7141426692356 -122.39982900101299 (37.7141426692356, -122.399829001013)
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)
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)
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)
53292 217579 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 636 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5992273.5996 2088560.7555 37.714346412845295 -122.46861011007299 (37.7143464128453, -122.468610110073)
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)
188758 217581 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 500 Randolph St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5992611.7697 2088555.8456 37.714352460703104 -122.467440914144 (37.7143524607031, -122.467440914144)
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)
105407 25463 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 308 Randolph St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM 3 3X3   5993157.11936 2088546.32287 37.714357782974204 -122.46555529463001 (37.7143577829742, -122.46555529463)
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)
74280 217578 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 308 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5993138.4427 2088550.8537 37.7143691463099 -122.46562017697799 (37.7143691463099, -122.465620176978)
19205 17244 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 10X Randolph St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/08/2005 12:00:00 AM 6 3X3   5993945.3779 2088542.9193 37.7143938707274 -122.462830535838 (37.7143938707274, -122.462830535838)
124635 1772 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 2000X Bay Shore Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
155347 179374 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 906 Madrid St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6001350.07755 2088911.8778 37.71583065984 -122.437263408906 (37.71583065984, -122.437263408906)
162778 179375 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 778 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001912.74857 2089301.2462099998 37.7169317492882 -122.435346396016 (37.7169317492882, -122.435346396016)
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)
177864 214036 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 262 Ralston St 1 : 4 Tree 1 Private 1     7 Width 3ft   5992219.26388 2089623.39625 37.7172610279406 -122.46887519663 (37.7172610279406, -122.46887519663)
99989 50515 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1 Ankeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/2003 12:00:00 AM     Permit Number 47153 6011089.84046191 2089620.59314796 37.718325516545704 -122.40364792757799 (37.7183255165457, -122.403647927578)
171047 214038 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 638 Head St 1 : 4 Tree 1 Private 1     5 Width 3ft   5993525.3619099995 2090091.0611400001 37.718620496206796 -122.46439460152901 (37.7186204962068, -122.464394601529)
99237 48566 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 638 Head St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/23/2002 12:00:00 AM     Permit Number 45985 5993535.88564574 2090091.48019383 37.7186222534444 -122.464358255955 (37.7186222534444, -122.464358255955)
155782 179379 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 899 Mansell St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009540.44789 2090000.72733 37.71928261398529 -122.40903035607 (37.7192826139853, -122.40903035607)
135936 214037 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 510 Ramsell St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   5993017.248790001 2090566.81293 37.719897493047704 -122.466185481793 (37.7198974930477, -122.466185481793)
106143 87075 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 395 Byxbee St 6 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
111937 87074 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 395 Byxbee St 5 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
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)
89337 40785 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 410 Monticello St 3 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)
96644 40784 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 410 Monticello St 2 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)
122873 40786 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 410 Monticello St 4 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)
33870 95740 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 61 Ina Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 4 3x3 Permit Number 767486 6004943.22126 2091523.89765 37.7232063048111 -122.42502956775499 (37.7232063048111, -122.425029567755)
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)
173397 179371 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 479 Goettingen St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010448.30169 2092366.9553099999 37.7258306011814 -122.40605884135401 (37.7258306011814, -122.406058841354)
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)
98066 38216 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 350 Wayland St 2 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)
140049 38215 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 350 Wayland St 3 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)
79913 179372 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 479 Goettingen St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010444.86472 2092384.67512 37.72587906384779 -122.40607197057 (37.7258790638478, -122.40607197057)
171501 214019 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 112 Dorado Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5994645.417119999 2093146.00663 37.7270731423102 -122.460744326189 (37.7270731423102, -122.460744326189)
40581 214021 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 75 Fairfield Way 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5993799.03412 2093427.92907 37.727798498601295 -122.463690690492 (37.7277984986013, -122.463690690492)
188052 214020 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 75 Fairfield Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5993790.82197 2093445.17793 37.727845386546605 -122.46372033123501 (37.7278453865466, -122.463720331235)
47021 179382 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 143 University St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007980.64963 2093237.8287400003 37.728083504546596 -122.414650965095 (37.7280835045466, -122.414650965095)
159513 214043 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 212 Edna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   5998768.52981 2093586.90837 37.7285201208974 -122.446522546303 (37.7285201208974, -122.446522546303)
47685 214042 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 22 Gennessee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 10ft   5997465.40478 2093699.4723200002 37.728754675784394 -122.451035610522 (37.7287546757844, -122.451035610522)
125174 53143 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1498@ KEITH Underwood Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792)
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)
155475 199669 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1909 Keith St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6015195.1623 2093397.888 37.7289256934462 -122.38972111920602 (37.7289256934462, -122.389721119206)
46883 214041 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 431 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5997281.4748599995 2093791.4004 37.7289965565343 -122.451678093372 (37.7289965565343, -122.451678093372)
47444 68867 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 123 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/08/1994 12:00:00 AM     Permit Number 32831 5999260.75597787 2093758.61799029 37.7290196985316 -122.444833238065 (37.7290196985316, -122.444833238065)
31386 214044 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 119 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5999274.87025 2093768.2240099998 37.729046879900295 -122.444785134325 (37.7290468799003, -122.444785134325)
185216 214045 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 115 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5999297.76132 2093768.33781 37.7290484986852 -122.444706006572 (37.7290484986852, -122.444706006572)
27695 214032 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 342 Staples Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997805.133780001 2093821.6600400002 37.729109618413 -122.449869953332 (37.729109618413, -122.449869953332)
73887 214033 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 342 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997821.19553 2093821.6931599998 37.7291106283447 -122.449814429211 (37.7291106283447, -122.449814429211)
69594 214034 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 218 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 1ft   5998609.02608 2093807.55818 37.729116861544206 -122.447089829625 (37.7291168615442, -122.447089829625)
41315 95661 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 231 Brussels St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/08/2011 12:00:00 AM 3 3x3 Permit Number 767423 6010393.1108800005 2093567.05478 37.7291227359169 -122.406334153496 (37.7291227359169, -122.406334153496)
78709 67518 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 342 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/08/1994 12:00:00 AM     Permit Number 31054 5997814.69503285 2093832.35785798 37.729139539152705 -122.44983767011499 (37.7291395391527, -122.449837670115)
64497 214035 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 142 Staples Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     5999120.59989 2093807.09624 37.72914480888021 -122.445321250796 (37.7291448088802, -122.445321250796)
103072 68820 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 215 Detroit St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/30/1993 12:00:00 AM     Permit Number 32768 5999394.70937931 2093830.63611547 37.729225087217294 -122.444375326018 (37.7292250872173, -122.444375326018)
172891 51254 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 258 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2008 12:00:00 AM 5 3x3 Permit Number 50492 6005094.58295 2093781.1160400002 37.7294126791284 -122.42466683341699 (37.7294126791284, -122.424666833417)
31525 214031 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 119 Gennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5997420.89454 2093944.4368 37.7294247417474 -122.45120714359501 (37.7294247417474, -122.451207143595)
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)
175504 179381 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 211 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004791.2259599995 2093805.4606400002 37.7294623864734 -122.42571730003901 (37.7294623864734, -122.425717300039)
18565 68830 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 111 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/30/1993 12:00:00 AM     Permit Number 32781 6000000.33338592 2094041.19205625 37.729837760714204 -122.44229674739599 (37.7298377607142, -122.442296747396)
134723 214040 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 111 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5999932.25708 2094051.5429 37.729862301496 -122.442532837136 (37.729862301496, -122.442532837136)
134645 214022 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 659 Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5997050.53703 2094389.3323099997 37.7306251064676 -122.45251959171101 (37.7306251064676, -122.452519591711)
129131 68856 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 111 Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1993 12:00:00 AM     Permit Number 32819 6000663.76465174 2094326.91833664 37.7306600888757 -122.440023675014 (37.7306600888757, -122.440023675014)
158872 197351 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1240 Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6017537.11653 2093985.5056900003 37.7306687649511 -122.381665582497 (37.7306687649511, -122.381665582497)
98390 11347 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 1300X Ingalls St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/06/1997 12:00:00 AM 18 3X3   6017347.6886145 2093992.5867035 37.730677746775605 -122.382320962891 (37.7306777467756, -122.382320962891)
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)
36061 214023 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 111 Hearst Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6000598.84895 2094335.4471599997 37.7306798113107 -122.44024870933599 (37.7306798113107, -122.440248709336)
138246 197352 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1240 Ingalls St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6017442.65456 2093993.31463 37.7306849905143 -122.381992698304 (37.7306849905143, -122.381992698304)
63135 82850 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1457 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM 5 3x3 Permit Number 52367 6015981.5985 2094038.4652 37.730728169212 -122.387046987845 (37.730728169212, -122.387046987845)
73278 113422 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1583 Shafter Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   11 3x3   6015014.3399 2094064.2928 37.7307454784064 -122.390392783554 (37.7307454784064, -122.390392783554)
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)
2099 200057 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1898x Lane St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6014825.8229 2094079.4071 37.7307765200208 -122.39104557773999 (37.7307765200208, -122.39104557774)
111749 113423 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1583 Shafter Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3   6015002.21794725 2094078.95124561 37.730785055109294 -122.39043571521799 (37.7307850551093, -122.390435715218)
183319 106008 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1800X Lane St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6014836.2656 2094091.4986 37.7308103003106 -122.391010320168 (37.7308103003106, -122.391010320168)
83275 94656 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 118 Baden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2010 12:00:00 AM 3 3x3 Permit Number 53795 6000765.0 2094410.0 37.7308939745429 -122.439679643784 (37.7308939745429, -122.439679643784)
97280 94657 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 118 Baden St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2010 12:00:00 AM 3 3x3 Permit Number 53795 6000765.0 2094410.0 37.7308939745429 -122.439679643784 (37.7308939745429, -122.439679643784)
170778 200056 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1800 Lane St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6014859.3493 2094125.5746 37.730905147018106 -122.390932896146 (37.7309051470181, -122.390932896146)
90176 38637 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1595 Shafter Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/2010 12:00:00 AM   3x3 Permit Number 767658 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611)
112909 38640 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1595 Shafter Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/1998 12:00:00 AM     Permit Number 40566 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611)
119285 38636 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1595 Shafter Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/16/2011 12:00:00 AM   3x3 Permit Number 767658 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611)
124237 38635 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1595 Shafter Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/16/2011 12:00:00 AM   33 Permit Number 767658 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611)
140727 38639 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1595 Shafter Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/1998 12:00:00 AM     Permit Number 40566 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611)
141716 38638 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1595 Shafter Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/1998 12:00:00 AM     Permit Number 40566 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611)
97449 102592 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 124 Baden St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1 FUF 1 04/17/2010 12:00:00 AM 3 6x6   6000765.0 2094428.0 37.7309433983829 -122.439680933747 (37.7309433983829, -122.439680933747)
50906 200055 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1800 Lane St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6014871.4407 2094140.9637 37.7309480732984 -122.390892168964 (37.7309480732984, -122.390892168964)
27566 200054 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1800 Lane St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6014879.1353 2094151.956 37.73097868287971 -122.39086633517 (37.7309786828797, -122.39086633517)
105918 94658 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 130 Baden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2010 12:00:00 AM 3 3x3 Permit Number 53796 6000765.0 2094447.0 37.73099556799129 -122.43968229537701 (37.7309955679913, -122.439682295377)

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