trees

139 rows where Zip Codes = 28861 and qSpecies_id = 65 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

Zip Codes ✖

  • 28861 · 39 ✖
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)
118130 67911 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 66 Marston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31614 5998875.49490681 2093226.9126308 37.7275377658836 -122.446126879833 (37.7275377658836, -122.446126879833) 9 7 4 28861 40
3392 70645 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 67 Lamartine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6002626.20323 2094469.32888 37.7311626384362 -122.433249403638 (37.7311626384362, -122.433249403638) 9 7 5 28861 25
71957 95120 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 67 Lamartine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54047 6002640 2094338 37.7308028218422 -122.433192325631 (37.7308028218422, -122.433192325631) 9 7 5 28861 25
3472 95121 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 68 Lamartine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54048 6002661 2094358 37.7308589285589 -122.433121153797 (37.7308589285589, -122.433121153797) 9 7 5 28861 25
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
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
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
1033 221901 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6004253.74444 2095482.9703 37.7340380650904 -122.427694899296 (37.7340380650904, -122.427694899296) 2 7 5 28861 25
50598 221896 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 7 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6004330.56552 2095607.66514 37.7343847942306 -122.427438185126 (37.7343847942306, -122.427438185126) 2 7 5 28861 25
72140 221898 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6004300.13641 2095569.34378 37.7342778513286 -122.427540659282 (37.7342778513286, -122.427540659282) 2 7 5 28861 25
95845 221899 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6004290.71623 2095557.06224 37.7342435961597 -122.427572353179 (37.7342435961597, -122.427572353179) 2 7 5 28861 25
143450 221902 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6004251.61559 2095453.80279 37.7339578572562 -122.427700181935 (37.7339578572562, -122.427700181935) 2 7 5 28861 25
149081 221900 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004249.68912 2095508.61359 37.7341082463924 -122.427710746252 (37.7341082463924, -122.427710746252) 2 7 5 28861 25
181669 221897 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 6 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6004313.27155 2095583.983 37.7343187902678 -122.427496289445 (37.7343187902678, -122.427496289445) 2 7 5 28861 25
104709 66250 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 718 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1990 12:00:00 AM     Permit Number 29350 5994696.57852166 2091262.84709817 37.721905383508 -122.460431070774 (37.721905383508, -122.460431070774) 9 8 4 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
69139 221840 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 98 Bosworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 2ft   6004312.44121 2095336.44977 37.7336390727743 -122.427481531566 (37.7336390727743, -122.427481531566) 2 7 5 28861 25
76041 59441 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 98 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1980 12:00:00 AM     Permit Number 18804 6004258.9190799 2095333.58373446 37.7336281759245 -122.42766636908 (37.7336281759245, -122.42766636908) 2 7 5 28861 25
177042 221839 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 98 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6004329.20117 2095336.95284 37.7336414020218 -122.42742362331 (37.7336414020218, -122.42742362331) 2 7 5 28861 25
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
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
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
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
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

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