82 rows where Supervisor Districts = 6 and qSpecies_id = 65 sorted by qSpecies_id

View and edit SQL

Supervisor 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)
138 203559 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 145 Lakeview Ave 1 : Tree Private 2     1 Width 3ft   5997146.51683 2089373.33367 37.7168578537955 -122.45182605794 (37.7168578537955, -122.45182605794) 9 8 6 28861 24
730 160454 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 11 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001177.46897 2090398.6691 37.7199032415307 -122.437966457494 (37.7199032415307, -122.437966457494) 9 7 6 28861 5
1937 78248 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 734 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6002539.24351 2089283.26415 37.716917933889 -122.433179625239 (37.716917933889, -122.433179625239) 9 7 6 28861 5
2206 70527 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 25 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004201.75826 2093380.33154 37.7282617492704 -122.427724869209 (37.7282617492704, -122.427724869209) 9 7 6 28861 5
3053 262433 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 470 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM   3x3   6001714 2091050 37.7217221467453 -122.43615844491 (37.7217221467453, -122.43615844491) 9 7 6 28861 5
3223 70495 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 41 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6004160.99444 2093317.30941 37.7280863985552 -122.427861302663 (37.7280863985552, -122.427861302663) 9 7 6 28861 5
6929 160451 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 99 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2020 12:00:00 AM 3 Width 0ft   6001258.21118 2090347.83316 37.7197682487796 -122.437683721428 (37.7197682487796, -122.437683721428) 9 7 6 28861 5
6932 112764 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 145 Lakeview Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2015 12:00:00 AM     Permit Number 774164 5997123.4 2089342.1 37.7167707693614 -122.45190370908 (37.7167707693614, -122.45190370908) 9 8 6 28861 24
7372 175205 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 653 Peru Ave 6 Side Yard : Yard Tree Private 2     15     6005071.6263 2092637.86098 37.7262722564417 -122.424664901662 (37.7262722564417, -122.424664901662) 9 7 6 28861 5
8169 160453 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 99 France Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2020 12:00:00 AM 3 Width 0ft   6001205.1197 2090381.66789 37.7198581324333 -122.437869661652 (37.7198581324333, -122.437869661652) 9 7 6 28861 5
8943 73896 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6004393.10182 2091444.69797 37.7229577492801 -122.426925586868 (37.7229577492801, -122.426925586868) 9 7 6 28861 5
9080 160643 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 556 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001401.85862 2090517.84189 37.7202432212254 -122.437199350171 (37.7202432212254, -122.437199350171) 9 7 6 28861 5
9579 74128 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Excelsior Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6004381.29063 2091452.37119 37.7229781503978 -122.426966961977 (37.7229781503978, -122.426966961977) 9 7 6 28861 5
13377 160452 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 99 France Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2020 12:00:00 AM 3 Width 0ft   6001241.76743 2090358.86031 37.719797591855 -122.437741350891 (37.719797591855, -122.437741350891) 9 7 6 28861 5
13433 161215 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 0ft   6003987.70302 2090927.51887 37.7215147582736 -122.428290125502 (37.7215147582736, -122.428290125502) 9 7 6 28861 5
13672 70491 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 26 Ina Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   18     6005035.04728 2091735.87999 37.7237935486115 -122.424727215697 (37.7237935486115, -122.424727215697) 9 7 6 28861 5
14111 74492 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Excelsior Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6004373.61085 2091456.86354 37.7229900511464 -122.42699382922 (37.7229900511464, -122.42699382922) 9 7 6 28861 5
14927 262428 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 99 France Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6001205.1197 2090381.66789 37.7198581324333 -122.437869661652 (37.7198581324333, -122.437869661652) 9 7 6 28861 5
15089 175203 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 655 Peru Ave 1 Side Yard : Yard Tree Private 2     52     6005189.8347 2092537.12043 37.7260023204239 -122.424249099221 (37.7260023204239, -122.424249099221) 9 7 6 28861 5
15492 262409 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 99 France Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2020 12:00:00 AM 3 Width 0ft   6001205.1197 2090381.66789 37.7198581324333 -122.437869661652 (37.7198581324333, -122.437869661652) 9 7 6 28861 5
16687 74647 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6004365.04367 2091463.54141 37.7230079026666 -122.42702391962 (37.7230079026666, -122.42702391962) 9 7 6 28861 5
16813 160908 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 615 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/2019 12:00:00 AM 3 Width 0ft   6002284.55838 2090317.50092 37.7197432674186 -122.434133839205 (37.7197432674186, -122.434133839205) 9 7 6 28861 5
18137 70176 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 307 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14 3.5x4 to 3.5x7   6004287.81152 2091470.53201 37.7230227297861 -122.42729139329 (37.7230227297861, -122.42729139329) 9 7 6 28861 5
19536 160455 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 11 France Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001161.40103 2090408.94535 37.719930544037 -122.438022734371 (37.719930544037, -122.438022734371) 9 7 6 28861 5
30708 175201 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 648 Peru Ave 7 Side Yard : Yard Tree Private 2     14     6005063.1365 2092591.26253 37.7261438278596 -122.424690937041 (37.7261438278596, -122.424690937041) 9 7 6 28861 5
31637 117427 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 690 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 776915 6002940.91679 2089412.44819 37.7172954225231 -122.431800455543 (37.7172954225231, -122.431800455543) 9 7 6 28861 5
36536 175211 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 66 Madison St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6005436.48818 2093200.64124 37.7278381272226 -122.423443582752 (37.7278381272226, -122.423443582752) 9 7 6 28861 5
45102 52520 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 54 Norton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM 30   Permit Number 48621 6001810.81862 2092293.71669 37.7251426126309 -122.4359127153 (37.7251426126309, -122.4359127153) 9 7 6 28861 25
48865 175202 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 654 Peru Ave 6 Side Yard : Yard Tree Private 2     13     6005192.08696 2092525.09672 37.7259694331304 -122.424240458534 (37.7259694331304, -122.424240458534) 9 7 6 28861 5
50392 203557 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 377 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5995020.43667 2088328.90175 37.7138680909275 -122.459099244044 (37.7138680909275, -122.459099244044) 9 8 6 28861 24
50747 65523 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 721 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1990 12:00:00 AM 21   Permit Number 28410 6001369.75843 2089371.25057 37.7170931137224 -122.437228255287 (37.7170931137224, -122.437228255287) 9 7 6 28861 5
55051 67285 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 119 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1992 12:00:00 AM     Permit Number 30761 6004716.66423484 2092675.63660854 37.7263559262182 -122.425894675863 (37.7263559262182, -122.425894675863) 9 7 6 28861 5
55860 175179 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 450 Italy Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6001771.83891 2089201.36797 37.7166495024579 -122.43582630935 (37.7166495024579, -122.43582630935) 9 7 6 28861 5
58638 175199 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 648 Peru Ave 4 Side Yard : Yard Tree Private 2     9     6005054.924 2092614.92051 37.7262083236385 -122.424721009467 (37.7262083236385, -122.424721009467) 9 7 6 28861 5
63762 53384 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 259 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/21/2016 12:00:00 AM     Permit Number 772607 5994713.25997575 2090306.35958478 37.7192800571495 -122.460304141 (37.7192800571495, -122.460304141) 9 8 6 28861 24
63890 35857 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 28 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1998 12:00:00 AM 28 4x6 Permit Number 39076 6002203.07861 2092639.23336 37.7261135989609 -122.434581409299 (37.7261135989609, -122.434581409299) 9 7 6 28861 25
65106 175181 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 690 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6002921.15596 2089379.53862 37.7172039398928 -122.431866410902 (37.7172039398928, -122.431866410902) 9 7 6 28861 5
66364 175206 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 653 Peru Ave 7 Side Yard : Yard Tree Private 2     13     6005071.10082 2092642.69367 37.7262854962678 -122.424667061852 (37.7262854962678, -122.424667061852) 9 7 6 28861 5
69194 175204 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 653 Peru Ave 1 Side Yard : Yard Tree Private 2     7     6005107.43376 2092594.03644 37.72615394614 -122.424538001034 (37.72615394614, -122.424538001034) 9 7 6 28861 5
69898 175184 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 190 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001047.00422 2087602.25445 37.7122174923141 -122.438217204682 (37.7122174923141, -122.438217204682) 9 7 6 28861 5
69909 175176 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 226 Rome St 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   5998630.92665 2088821.65601 37.7154279802818 -122.446655529047 (37.7154279802818, -122.446655529047) 9 7 6 28861 25
72092 175200 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 648 Peru Ave 6 Side Yard : Yard Tree Private 2     6     6005058.70512 2092602.03865 37.7261731664377 -122.424707022338 (37.7261731664377, -122.424707022338) 9 7 6 28861 5
73282 108847 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 970 Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 772762 6001586.13513 2086816.33243 37.7100901720951 -122.436297601751 (37.7100901720951, -122.436297601751) 9 7 6 28861 5
76373 175196 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 149 London St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6002904.02638 2092823.59155 37.7266595719653 -122.432171435767 (37.7266595719653, -122.432171435767) 9 7 6 28861 5
77660 175178 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 763 Morse St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998593.8483 2087142.30255 37.7108147396853 -122.44666292955 (37.7108147396853, -122.44666292955) 9 7 6 28861 5
80252 112745 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 179 Caine Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2014 12:00:00 AM     Permit Number 774163 5997059.3 2088800.2 37.7152791660762 -122.452086194059 (37.7152791660762, -122.452086194059) 9 8 6 28861 24
80295 175183 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 404 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6003446.11855 2091231.22966 37.7223180210418 -122.430183890869 (37.7223180210418, -122.430183890869) 9 7 6 28861 5
83894 108683 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 384 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2014 12:00:00 AM 3 3x3 Permit Number 774613 6000302.20846 2086863.37515 37.7101463059777 -122.440738464824 (37.7101463059777, -122.440738464824) 9 7 6 28861 5
87773 203558 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 179 Caine Ave 1 : Tree Private 2     3 Width 3ft   5997048.33435 2088809.54157 37.7153041877202 -122.45212476956 (37.7153041877202, -122.45212476956) 9 8 6 28861 24
93586 102654 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 203X Farallones St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5995004 2088355 37.7139388056528 -122.459157943572 (37.7139388056528, -122.459157943572) 9 8 6 28861 24
94208 52929 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Cotter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM 3 3x3 Permit Number 48913 6002555.71096 2093126.63865 37.7274719160952 -122.433397195531 (37.7274719160952, -122.433397195531) 9 7 6 28861 25
103379 60473 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 145 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2015 12:00:00 AM     Permit Number 774164 5997228.1128738 2089314.92516138 37.7167021506206 -122.451539811129 (37.7167021506206, -122.451539811129) 9 8 6 28861 24
105309 35840 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 621 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1998 12:00:00 AM 18 6x7 Permit Number 39067 6002271.78016 2090299.14404 37.7196921382746 -122.434176697315 (37.7196921382746, -122.434176697315) 9 7 6 28861 5
107710 175194 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 522 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6004004.48398 2092477.2158 37.7257708331541 -122.428342513702 (37.7257708331541, -122.428342513702) 9 7 6 28861 5
108513 254649 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 929 Cayuga Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2018 12:00:00 AM 3 3x3 Permit Number 781532 6000895.17385 2091578.90462 37.7231278434042 -122.439026791536 (37.7231278434042, -122.439026791536) 9 7 6 28861 25
110481 175078 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1584 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001809.64472 2092991.82578 37.7270593952569 -122.435966703417 (37.7270593952569, -122.435966703417) 9 7 6 28861 25
111705 74111 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 500X Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1994 12:00:00 AM 15 3x3   6003976.59234436 2092494.78352221 37.7258174919201 -122.428440184616 (37.7258174919201, -122.428440184616) 9 7 6 28861 5
115755 175195 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 522 Avalon Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6004033.56494 2092456.82753 37.7257164970033 -122.428240530581 (37.7257164970033, -122.428240530581) 9 7 6 28861 5
118838 203560 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 145 Lakeview Ave 2 : Tree Private 2     1 Width 3ft   5997153.12879 2089368.29033 37.7168443846497 -122.451802840126 (37.7168443846497, -122.451802840126) 9 8 6 28861 24
119492 203554 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5994942.92929 2088379.09284 37.7140014477918 -122.459370769157 (37.7140014477918, -122.459370769157) 9 8 6 28861 24
126749 175180 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 690 Athens St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6002933.07108 2089399.59548 37.7172596870602 -122.43182665728 (37.7172596870602, -122.43182665728) 9 7 6 28861 5
130503 175177 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 763 Morse St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5998527.33807 2087102.13623 37.7107006525794 -122.44688991486 (37.7107006525794, -122.44688991486) 9 7 6 28861 5
133303 160893 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 634 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2017 08:15:00 AM 3 Width 0ft   6002406.55833 2090085.42086 37.7191129505803 -122.433695551007 (37.7191129505803, -122.433695551007) 9 7 6 28861 5
143006 161013 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 46 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 Width 0ft Permit Number 781526 6004792.42669 2090835.59849 37.7213078665529 -122.425501874617 (37.7213078665529, -122.425501874617) 9 7 6 28861 5
146650 170415 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 216 Theresa St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 Width 3ft Permit Number 779296 6001929.08412 2093967.91374 37.7297462952572 -122.435623604862 (37.7297462952572, -122.435623604862) 9 7 6 28861 25
151528 175210 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 66 Madison St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   6005427.44885 2093231.28592 37.7279217605751 -122.423477009653 (37.7279217605751, -122.423477009653) 9 7 6 28861 5
156178 175175 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 231 Rome St 1 Sidewalk: Property side : Yard Tree Private 2     20 Width 3ft   5998599.64276 2088795.69735 37.7153549166607 -122.446761792925 (37.7153549166607, -122.446761792925) 9 7 6 28861 25
159787 203555 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5994968.99544 2088379.28856 37.7140034838548 -122.459280689461 (37.7140034838548, -122.459280689461) 9 8 6 28861 24
160387 203556 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5994991.30881 2088378.07982 37.7140014477822 -122.45920347906 (37.7140014477822, -122.45920347906) 9 8 6 28861 24
163287 160137 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 61 Seminole Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/08/2018 12:00:00 AM 3 Width 0ft Permit Number 781533 5999114.78388 2090156.18461 37.7191199185408 -122.445078994094 (37.7191199185408, -122.445078994094) 9 7 6 28861 25
167603 108846 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 970 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 772762 6001611.41863 2086816.80035 37.7100928934503 -122.436210250619 (37.7100928934503, -122.436210250619) 9 7 6 28861 5
168312 175182 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 647 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002406.62971 2090005.70634 37.718894076269 -122.433689610108 (37.718894076269, -122.433689610108) 9 7 6 28861 5
169503 65718 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 206 Pope St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1990 12:00:00 AM 22   Permit Number 28650 6000369.4893 2087691.53319 37.7124240746766 -122.440565289581 (37.7124240746766, -122.440565289581) 9 7 6 28861 5
171813 35138 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 832 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM 9   Permit Number 38668 6001976.8462 2088896.96126 37.7158253124776 -122.435095942923 (37.7158253124776, -122.435095942923) 9 7 6 28861 5
172010 175193 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 28 Harrington St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002083.86995 2092418.47999 37.7255006920777 -122.434977725241 (37.7255006920777, -122.434977725241) 9 7 6 28861 25
172356 175209 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6005385.77988 2093250.96165 37.7279734338052 -122.423622458831 (37.7279734338052, -122.423622458831) 9 7 6 28861 5
172987 95109 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 615 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM 9 3x3 Permit Number 54038 6001824.30736 2093468.52552 37.7283691373029 -122.435950110013 (37.7283691373029, -122.435950110013) 9 7 6 28861 25
182887 203553 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 259 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994715.67756 2090305.5088 37.7192778601644 -122.46029572277 (37.7192778601644, -122.46029572277) 9 8 6 28861 24
183128 175208 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6005371.81589 2093231.88981 37.727920278496 -122.423669377345 (37.727920278496, -122.423669377345) 9 7 6 28861 5
186585 175207 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6005359.84242 2093211.49837 37.7278636122004 -122.423709320725 (37.7278636122004, -122.423709320725) 9 7 6 28861 5
186672 160894 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 642 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2017 08:21:00 AM 3 Width 0ft   6002380.66916 2090044.63219 37.7189994849067 -122.433782126067 (37.7189994849067, -122.433782126067) 9 7 6 28861 5
188048 175198 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 648 Peru Ave 2 Side Yard : Yard Tree Private 2     12     6005048.079 2092617.03467 37.7262137420546 -122.424744822616 (37.7262137420546, -122.424744822616) 9 7 6 28861 5

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)
);