139 rows where SiteOrder = 2 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

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)
67282 203548 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 181 Flood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999484.36005 2094058.99303 37.7298572167403 -122.444081798854 (37.7298572167403, -122.444081798854) 9 7 4 63 40
80302 203507 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 920 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   5991972.62617 2105259.84917 37.7601805116332 -122.470866084321 (37.7601805116332, -122.470866084321) 1 8 4 56 12
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
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
101270 125542 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 65 Heather Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5997338.84626 2114106.78779 37.78478079984 -122.452945569076 (37.78478079984, -122.452945569076) 15 6 1 54 31
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
111117 120170 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2115 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5988998.98639 2111212.7958 37.7763532490624 -122.481586377549 (37.7763532490624, -122.481586377549) 11 6 2 55 26
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
123884 203541 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 510 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5998007.81838 2094409.85226 37.7307362500822 -122.449211618134 (37.7307362500822, -122.449211618134) 9 7 4 59 40
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
135296 221865 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 592 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002930.8792 2095923.87336 37.7351737658507 -122.432299929108 (37.7351737658507, -122.432299929108) 2 7 5 63 7
137740 124329 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 122 Palm Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5995931.07902 2113567.14983 37.7832183231598 -122.457776888478 (37.7832183231598, -122.457776888478) 11 6 1 54 31
157942 221798 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 430 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004116.67022 2110321.94704 37.7747746486742 -122.429226550889 (37.7747746486742, -122.429226550889) 7 9 11 28852 10
159587 203566 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Colon Ave 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5996063.41122 2094232.89601 37.7301389635391 -122.455920909543 (37.7301389635391, -122.455920909543) 9 7 4 28861 40
173406 122030 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 791 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5990356.68598 2110010.07931 37.7731297724256 -122.476801870398 (37.7731297724256, -122.476801870398) 11 6 2 55 26
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
190842 123821 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1851 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992885.6569 2112034.46491 37.7788345620747 -122.468201203152 (37.7788345620747, -122.468201203152) 11 6 2 54 11
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
194442 221796 Prune Opt Out 3 Agonis flexuosa :: Peppermint Willow 65 436 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft Permit Number 787981 6004110.94859 2110346.00561 37.7748403836965 -122.429248059072 (37.7748403836965, -122.429248059072) 7 9 11 28852 10
652 144195 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 630 42nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:17:00 PM 0 Width 4ft   5982905.71974 2111464.01201 37.7766868258595 -122.502682939079 (37.7766868258595, -122.502682939079) 11 6 2 55 26
43499 203561 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 509 Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5992707.23353 2104539.55392 37.7582452263566 -122.468273046583 (37.7582452263566, -122.468273046583) 1 8 4 56 12
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
115143 221806 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1350 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6003875.18729 2100363.84416 37.7474184051535 -122.429351626769 (37.7474184051535, -122.429351626769) 2 7 5 63 22
115309 203525 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2428 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992054.69549 2098894.88306 37.74270871135 -122.470118765694 (37.74270871135, -122.470118765694) 1 8 4 29491 40
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
142588 203516 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 301 Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5993037.18841 2102512.99868 37.7526998825032 -122.466984597774 (37.7526998825032, -122.466984597774) 1 8 4 29491 12
145252 123201 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1310 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5993108.25102 2112027.19449 37.7788274527304 -122.467430639975 (37.7788274527304, -122.467430639975) 11 6 2 54 11
146877 203582 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 24 Gennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5997457.41638 2093726.64675 37.7288288329774 -122.451065185614 (37.7288288329774, -122.451065185614) 9 7 4 28861 40
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
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
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
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
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
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
46307 203579 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 312 Joost Ave 2 Sidewalk: Property side : Yard Tree Private 2     14 Width 6ft   5999939.25303 2094981.39881 37.7324158679899 -122.44257538767 (37.7324158679899, -122.44257538767) 9 7 4 63 40
77602 203529 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 24 Santa Ana Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 8ft   5992569.96638 2096706.93709 37.7367309392805 -122.468177995418 (37.7367309392805, -122.468177995418) 1 8 4 59 40
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

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