trees

139 rows where SiteOrder = 2 and qSpecies_id = 65 sorted by Supervisor Districts

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
167184 221846 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6004388.2708 2095606.1808 37.7343839821397 -122.427238573395 (37.7343839821397, -122.427238573395) 2 7 5 28861 25
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3673 221872 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 619 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007332.3833 2097776.98457 37.740510589287 -122.417213566178 (37.740510589287, -122.417213566178) 2 7 7 28859 2
4556 35737 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 351 Hale St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/14/1998 12:00:00 AM 11   Permit Number 39011 6008822.29863 2094308.62612 37.7310709363673 -122.411816979173 (37.7310709363673, -122.411816979173) 9 3 7 309 28
7501 262401 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1X Benton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/21/2020 12:00:00 AM 3 3x3   6004556 2094831 37.732264993682 -122.426603497453 (37.732264993682, -122.426603497453) 2 7 7 28861 2
12895 221826 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008314.44854 2096531.09899 37.7371448612571 -122.413729852457 (37.7371448612571, -122.413729852457) 2 7 7 28859 2
17657 221821 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 3x5   6007305.19909 2096505.34711 37.7370174246124 -122.417217471014 (37.7370174246124, -122.417217471014) 2 7 7 28859 2
32667 221878 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 18 Coleridge St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6006985.0649 2099647.22119 37.7456262946341 -122.41854704763 (37.7456262946341, -122.41854704763) 2 7 7 28859 2
45238 175213 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 87x Valmar Ter 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6005270.21686 2092560.99775 37.7260724207817 -122.423972920124 (37.7260724207817, -122.423972920124) 9 7 7 309 5
46915 38203 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 691 Goettingen St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM 14   Permit Number 40328 6010707.71448 2091513.67595 37.7235021790704 -122.405102009451 (37.7235021790704, -122.405102009451) 10 3 7 309 28
52355 175197 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 701 Peru Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6005286.47432 2092498.92071 37.7259028886841 -122.423912306729 (37.7259028886841, -122.423912306729) 9 7 7 309 5
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
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
95633 221883 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 34 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007121.00835 2099271.28888 37.7446017212974 -122.418050328662 (37.7446017212974, -122.418050328662) 2 7 7 28859 2
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
132523 115548 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   20 4x6   6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
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
188123 248074 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 440 Holladay Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6010189.61639 2098448.43347 37.742514572897 -122.407381643363 (37.742514572897, -122.407381643363) 10 7 7 28859 2
19773 113547 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2017 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2015 12:00:00 AM 1   Permit Number 775016 6011715.20847 2105100.54779 37.7608650971692 -122.40257424272 (37.7608650971692, -122.40257424272) 10 3 8 28856 29
44134 189216 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1660 La Salle Ave 2 Sidewalk: Property side : Yard Tree Private 2     19 Width 9ft   6015290.99277 2096384.28248 37.7371310431648 -122.389598311625 (37.7371310431648, -122.389598311625) 10 3 8 58 1
47655 189217 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1634 Jerrold Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6015116.50224 2097212.0883 37.7393943516633 -122.390259427548 (37.7393943516633, -122.390259427548) 10 3 8 58 1
93867 189215 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1400 20th St 2 : Tree Private 2     14 Width 3ft   6013696.29673 2104791.67795 37.7601274111746 -122.395700842123 (37.7601274111746, -122.395700842123) 10 3 8 28856 29
175566 53159 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1747@ 3RD ST Quesada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM 13   Permit Number 49080 6014484.90518 2095154.52732 37.7337096578753 -122.392299359741 (37.7337096578753, -122.392299359741) 10 3 8 58 1
182539 38225 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1099 Mississippi St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM 13   Permit Number 40351 6014263.22127 2102058.4146 37.7526539784223 -122.39354880945 (37.7526539784223, -122.39354880945) 10 3 8 28856 29

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