79 rows where Police Districts = 4 and qSpecies_id = 65 sorted by Neighborhoods (old)

View and edit SQL

Police Districts

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old) ▼
754 34739 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM   3x3 Permit Number 38389 6007302.61875581 2103939.58827334 37.7574300317864 -122.417753185833 (37.7574300317864, -122.417753185833) 2 4 7 28859 19
15498 221829 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6008243.92561 2104140.04763 37.7580333739666 -122.414511946088 (37.7580333739666, -122.414511946088) 2 4 7 28859 19
20666 221837 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 109 Bartlett St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   6006703.42014 2103074.38684 37.7550206505078 -122.419764067776 (37.7550206505078, -122.419764067776) 2 4 7 28859 19
21022 69205 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2860 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33254 6008952.43931379 2101803.50283851 37.7516575269948 -122.411896484829 (37.7516575269948, -122.411896484829) 2 4 7 28859 19
41894 221832 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 573 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007293.28891 2103997.59658 37.7575887842104 -122.417789563935 (37.7575887842104, -122.417789563935) 2 4 7 28859 19
42770 221831 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 569 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007292.05586 2104018.90213 37.7576472149557 -122.417795338504 (37.7576472149557, -122.417795338504) 2 4 7 28859 19
49629 221833 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 577 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007293.94274 2103980.62531 37.7575422218038 -122.417786099775 (37.7575422218038, -122.417786099775) 2 4 7 28859 19
53011 221889 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 190 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006689.37303 2102664.80303 37.7538952362014 -122.419783585756 (37.7538952362014, -122.419783585756) 2 4 7 28859 19
61694 26511 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2850 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008945.12722 2101866.39993 37.7518298180943 -122.411926215341 (37.7518298180943, -122.411926215341) 2 4 7 28859 19
74836 66622 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 867 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/15/1991 12:00:00 AM     Permit Number 29826 6010209.78585513 2104179.32451342 37.7582514640983 -122.407715901057 (37.7582514640983, -122.407715901057) 10 4 7 28859 19
87625 221792 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2818 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009842.62719 2102814.79283 37.7544842057885 -122.408889429605 (37.7544842057885, -122.408889429605) 2 4 7 28859 19
88668 221892 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3272 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007901.84296 2101535.98387 37.7508639830901 -122.415510655785 (37.7508639830901, -122.415510655785) 2 4 7 28859 19
91117 221789 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3456 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6005341.04131 2103147.38287 37.7551442389361 -122.424480760089 (37.7551442389361, -122.424480760089) 2 4 5 28859 19
91243 221828 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1070 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6008613.25764 2102303.67809 37.7530118609308 -122.413104786776 (37.7530118609308, -122.413104786776) 2 4 7 28859 19
93872 102475 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 38389 6007298 2103932 37.7574089362149 -122.417768621509 (37.7574089362149, -122.417768621509) 2 4 7 28859 19
98506 221791 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 867 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/1991 12:00:00 AM 30 Width 6ft Permit Number 29826 6010196.62735 2104192.74111 37.7582875664398 -122.407762355146 (37.7582875664398, -122.407762355146) 10 4 7 28859 19
99508 221835 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 585 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007295.48201 2103941.69106 37.7574354039359 -122.41777801665 (37.7574354039359, -122.41777801665) 2 4 7 28859 19
101047 221790 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3456 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 5ft   6005327.10837 2103145.45598 37.7551381613168 -122.424528807253 (37.7551381613168, -122.424528807253) 2 4 5 28859 19
101142 65305 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3629 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 28122 6005455.44263685 2104863.06150764 37.7598615508482 -122.424207139046 (37.7598615508482, -122.424207139046) 2 4 5 28859 19
120305 221888 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 192 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006128.60788 2102045.32396 37.7521626832758 -122.421678849418 (37.7521626832758, -122.421678849418) 2 4 5 28859 19
129894 69204 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2850 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33252 6008949.31851966 2101859.27420808 37.7518104876034 -122.411911217702 (37.7518104876034, -122.411911217702) 2 4 7 28859 19
130543 221890 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 190 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006689.76882 2102684.09428 37.7539482278401 -122.419783585763 (37.7539482278401, -122.419783585763) 2 4 7 28859 19
130795 81299 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 109 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 12 3x3 Permit Number 50541 6006708.25661782 2103139.88479614 37.7552007652727 -122.419751988993 (37.7552007652727, -122.419751988993) 2 4 7 28859 19
150990 64607 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/1988 12:00:00 AM 20   Permit Number 25510 6008240.6573587 2104159.54552526 37.7580867271242 -122.414524628823 (37.7580867271242, -122.414524628823) 2 4 7 28859 19
152125 221834 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6007293.84054 2103959.34746 37.7574837919732 -122.417784945026 (37.7574837919732, -122.417784945026) 2 4 7 28859 19
162952 221836 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 585 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007298.30885 2103900.40234 37.7573221936904 -122.417765313729 (37.7573221936904, -122.417765313729) 2 4 7 28859 19
167156 69206 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2864 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33255 6008953.68763074 2101781.1943032 37.7515963427841 -122.411890591701 (37.7515963427841, -122.411890591701) 2 4 7 28859 19
179502 221830 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6008241.38226 2104159.63616 37.7580870167112 -122.414522128209 (37.7580870167112, -122.414522128209) 2 4 7 28859 19
129447 63292 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3075 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23858 6009183.06965006 2100534.27317896 37.7481854410784 -122.411009292537 (37.7481854410784, -122.411009292537) 2 4 7 28859 2
10243 221904 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 583 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2020 12:00:00 AM 3 Width 3ft Permit Number 785229 6001404.83719 2101424.58127 37.7501907685919 -122.437969880314 (37.7501907685919, -122.437969880314) 2 4 5 28862 22
22632 221918 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 78 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6004080.11539 2102633.34286 37.7536615185686 -122.428804766139 (37.7536615185686, -122.428804766139) 2 4 5 28862 22
24073 221906 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 879 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6002491.82292 2103096.81966 37.7548440920015 -122.434330562332 (37.7548440920015, -122.434330562332) 2 4 5 28862 22
30130 221910 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6003225.80615 2101486.76003 37.7504648828526 -122.431677300586 (37.7504648828526, -122.431677300586) 2 4 5 28862 22
35685 99537 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2012 12:00:00 AM   3x3 Permit Number 768635 6004924.7 2102557.1 37.7534999396673 -122.425878575683 (37.7534999396673, -122.425878575683) 2 4 5 28862 22
44302 221856 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 310 Hoffman Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000610.61852 2101933.59312 37.7515431951678 -122.440752837776 (37.7515431951678, -122.440752837776) 2 4 5 28862 22
45404 221907 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1217 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003244.02772 2101149.87665 37.7495409130801 -122.431590240821 (37.7495409130801, -122.431590240821) 2 4 5 28862 22
47906 67034 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3947 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1992 12:00:00 AM     Permit Number 30406 6003485.5850907 2102413.54143102 37.7530243281476 -122.430845098487 (37.7530243281476, -122.430845098487) 2 4 5 28862 22
65253 114757 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 861 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM     Permit Number 777137 6000857.2 2101959.2 37.7516275450509 -122.439901966271 (37.7516275450509, -122.439901966271) 2 4 5 28862 22
67738 221916 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 429 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6004184.08219 2101438.38346 37.7503863234716 -122.428360063075 (37.7503863234716, -122.428360063075) 2 4 5 28862 22
71288 53235 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 80 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31473 6004075.80842764 2102593.23401919 37.7535511453461 -122.428816801411 (37.7535511453461, -122.428816801411) 2 4 5 28862 22
71659 221855 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 310 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000611.21677 2101947.64163 37.7515818030572 -122.440751776575 (37.7515818030572, -122.440751776575) 2 4 5 28862 22
72559 221853 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 430 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002339.61262 2100938.00703 37.7489078650277 -122.434702583968 (37.7489078650277, -122.434702583968) 2 4 5 28862 22
72933 221807 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6004936.8002 2102544.12819 37.7534650059101 -122.425835807291 (37.7534650059101, -122.425835807291) 2 4 5 28862 22
73986 221859 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 861 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6000847.19345 2101982.10251 37.7516898602076 -122.439938212095 (37.7516898602076, -122.439938212095) 2 4 5 28862 22
85505 221920 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 963 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     29 4x4   6003802.10196 2102678.82151 37.7537706531042 -122.429769441907 (37.7537706531042, -122.429769441907) 2 4 5 28862 22
87919 221912 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 424 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003582.26596 2102758.00468 37.7539756202844 -122.43053533425 (37.7539756202844, -122.43053533425) 2 4 5 28862 22
89825 67817 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 76 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31472 6004074.53693177 2102616.18239315 37.7536140842238 -122.428822834401 (37.7536140842238, -122.428822834401) 2 4 5 28862 22
99045 221908 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6003228.29657 2101452.81084 37.7503718075255 -122.431666264992 (37.7503718075255, -122.431666264992) 2 4 5 28862 22
99862 221909 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 5ft   6003227.24309 2101470.4878 37.7504202845862 -122.43167116991 (37.7504202845862, -122.43167116991) 2 4 5 28862 22
100080 67827 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 429 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1992 12:00:00 AM     Permit Number 31487 6004187.64685523 2101514.68763135 37.7505960386394 -122.428353174015 (37.7505960386394, -122.428353174015) 2 4 5 28862 22
100713 221919 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 80 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 5ft   6004080.1128 2102611.51792 37.7536015922648 -122.428803219313 (37.7536015922648, -122.428803219313) 2 4 5 28862 22
103785 63866 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 879 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24569 6002490.08825783 2103093.39072976 37.7548345785172 -122.434336316133 (37.7548345785172, -122.434336316133) 2 4 5 28862 22
106236 120108 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3528 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2016 12:00:00 AM 3 3x3 Permit Number 778087 6004858 2103141 37.7550994230029 -122.426150804554 (37.7550994230029, -122.426150804554) 2 4 5 28862 22
121593 221917 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1033 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6003826.31981 2102255.52555 37.7526097533439 -122.429655503209 (37.7526097533439, -122.429655503209) 2 4 5 28862 22
125012 221854 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4418 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6000475.00831 2102295.38218 37.7525288566262 -122.441247749083 (37.7525288566262, -122.441247749083) 2 4 5 28862 22
131328 221913 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3947 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6003448.79955 2102413.03039 37.7530208406643 -122.430972273466 (37.7530208406643, -122.430972273466) 2 4 5 28862 22
139150 221852 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4338 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 4ft   6001688.98407 2100608.31061 37.747965638118 -122.436928854805 (37.747965638118, -122.436928854805) 2 4 5 28862 22
143155 221914 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 476 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003319.74249 2102160.73191 37.7523207750848 -122.431400568387 (37.7523207750848, -122.431400568387) 2 4 5 28862 22
144494 221905 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 572 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6002660.0308 2103294.31011 37.7553958998276 -122.433762967812 (37.7553958998276, -122.433762967812) 2 4 5 28862 22
148866 67788 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3879 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31428 6003934.74347541 2102438.27189101 37.7531176706218 -122.42929358548 (37.7531176706218, -122.42929358548) 2 4 5 28862 22
149504 221911 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 5ft   6003226.50292 2101503.3413 37.7505104506147 -122.431676074804 (37.7505104506147, -122.431676074804) 2 4 5 28862 22
155147 221860 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 516 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/1998 12:00:00 AM 15 Width 3ft Permit Number 39568 6001163.03933 2103237.69221 37.7551553815387 -122.438935950032 (37.7551553815387, -122.438935950032) 2 4 5 28862 22
159463 57100 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2012 12:00:00 AM     Permit Number 768635 6004924.75692274 2102545.44998856 37.7534679546686 -122.425877549626 (37.7534679546686, -122.425877549626) 2 4 5 28862 22
163176 67814 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 963 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31468 6003800.96031756 2102663.38209888 37.7537281954709 -122.429772288819 (37.7537281954709, -122.429772288819) 2 4 5 28862 22
186130 221808 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6004922.45206 2102542.08461 37.753458583869 -122.425885280803 (37.753458583869, -122.425885280803) 2 4 5 28862 22
192627 221915 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 476 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003301.60957 2102160.71382 37.7523196977161 -122.431463273608 (37.7523196977161, -122.431463273608) 2 4 5 28862 22
193961 63264 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 474 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1999 12:00:00 AM     Permit Number 23819 6003326.56560874 2102164.81247283 37.7523323660448 -122.431377264225 (37.7523323660448, -122.431377264225) 2 4 5 28862 22
8855 221923 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 274 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002696.84533 2104324.2367 37.758225920618 -122.433709258485 (37.758225920618, -122.433709258485) 2 4 5 28862 3
11193 221927 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 30 Collingwood St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001978.23682 2105679.10169 37.7619052494464 -122.436291477373 (37.7619052494464, -122.436291477373) 15 4 5 28862 3
16727 227695 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4250 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6001245.67427 2103366.3123 37.7555132424609 -122.438659390527 (37.7555132424609, -122.438659390527) 2 4 5 28862 3
25181 221922 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 142 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002658.74413 2105066.93812 37.7602630379377 -122.433894115042 (37.7602630379377, -122.433894115042) 2 4 5 28862 3
31052 109288 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 274 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/2015 12:00:00 AM 3 3x3 Permit Number 773379 6002625.7 2104315.8 37.7581987182413 -122.433954706682 (37.7581987182413, -122.433954706682) 2 4 5 28862 3
73676 102018 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 4252 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6001333 2103370 37.7555283353782 -122.438357655981 (37.7555283353782, -122.438357655981) 2 4 5 28862 3
105651 32556 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 233 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1996 12:00:00 AM 7   Permit Number 37043 6004755.28395 2103949.67696 37.7573140539292 -122.42656360702 (37.7573140539292, -122.42656360702) 2 4 5 28862 3
108472 109743 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 142 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775046 6002641.7 2105066.1 37.7602597694278 -122.433953002704 (37.7602597694278, -122.433953002704) 2 4 5 28862 3
114883 221926 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003063.55536 2104400.84265 37.7584570634637 -122.432446488035 (37.7584570634637, -122.432446488035) 2 4 5 28862 3
139226 221921 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 474 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002945.55902 2105503.88006 37.7614790472472 -122.432933374683 (37.7614790472472, -122.432933374683) 15 4 5 28862 3
163060 221924 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6003063.54599 2104384.44794 37.7584120469841 -122.432445349468 (37.7584120469841, -122.432445349468) 2 4 5 28862 3
191257 221925 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003063.11799 2104395.60529 37.7584426581259 -122.432447626582 (37.7584426581259, -122.432447626582) 2 4 5 28862 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);