36 rows where SiteOrder = 4 and qSpecies_id = 65 sorted by PermitNotes

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)
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
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
17363 90797 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3547 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 04/07/2008 12:00:00 AM 3 3x3   5984636.960359 2110382.796105 37.7738197034196 -122.496614350171 (37.7738197034196, -122.496614350171) 11 6 2 55 26
29277 256167 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 200 Laguna St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF         6005182.68808 2109644.93499 37.772976028407 -122.425490781615 (37.772976028407, -122.425490781615) 7 9 11 28852 10
34838 90754 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4139 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5982739.53556 2110307.53915 37.7735017206369 -122.503172166183 (37.7735017206369, -122.503172166183) 11 6 2 55 26
48444 221887 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4107 Ogden Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008432.72367 2096048.99248 37.7358277429522 -122.41328683742 (37.7358277429522, -122.41328683742) 10 7 7 28859 2
49622 113208 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
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
60782 90788 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3651 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984266.19034 2110362.18854 37.773741391309 -122.497895361604 (37.773741391309, -122.497895361604) 11 6 2 55 26
81526 90661 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3500X Cabrillo St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984678.30481 2110433.19729 37.7739605128473 -122.496475055086 (37.7739605128473, -122.496475055086) 11 6 2 55 26
86233 90689 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4000X Cabrillo St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5983112.49812 2110376.37698 37.7737126452226 -122.501887149528 (37.7737126452226, -122.501887149528) 11 6 2 55 26
88932 203571 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 551 Pacheco St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993265.94889 2101843.04784 37.7508735707655 -122.466144828838 (37.7508735707655, -122.466144828838) 1 8 4 29491 40
93698 203506 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 910 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5992059 2105289 37.7602655469825 -122.470569484113 (37.7602655469825, -122.470569484113) 1 8 4 56 12
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
107403 185945 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2001 Sunset Blvd 4 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984839.2608 2101514.9951 37.7494830539023 -122.495260478283 (37.7494830539023, -122.495260478283) 1 8 3 29491 35
113771 90773 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3899X Cabrillo St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5983556.085422 2110343.567935 37.7736486085903 -122.500350310129 (37.7736486085903, -122.500350310129) 11 6 2 55 26
114879 203587 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 77 Staples Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     39 Width 3ft   5999512.80503 2093756.92182 37.7290294222638 -122.443961766319 (37.7290294222638, -122.443961766319) 9 7 4 63 40
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
117746 109922 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Dashiell Hammett St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6010385.90065 2115990.02467 37.7906907621072 -122.407939683476 (37.7906907621072, -122.407939683476) 5 1 10 28857 21
138917 118284 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3549 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5984589.17158 2110373.61993 37.773791708306 -122.496778979398 (37.773791708306, -122.496778979398) 11 6 2 55 26
143712 1265 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3995X Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM 3 3x3   5992172.84146 2087217.03484 37.7106510585713 -122.468860642897 (37.7106510585713, -122.468860642897) 9 8 4 64 24
144708 117946 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3851 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5983654.61491 2110341.88423 37.773649768576 -122.500009362473 (37.773649768576, -122.500009362473) 11 6 2 55 26
145465 96870 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 620 Palmetto Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     12 2x3   5991859.90832 2087240.59875 37.7106976749231 -122.469943914081 (37.7106976749231, -122.469943914081) 9 8 4 64 24
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
150317 90779 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3801X Cabrillo St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 04/14/2008 12:00:00 AM 3 3x3   5983846.387262 2110354.103876 37.7736945730016 -122.499346906142 (37.7736945730016, -122.499346906142) 11 6 2 55 26
160833 125544 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1410 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002431.61204 2121624.28708 37.8057124359506 -122.435864366851 (37.8057124359506, -122.435864366851) 13 9 1 57 17
166822 221848 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004429.19741 2095585.11426 37.7343284525969 -122.427095576708 (37.7343284525969, -122.427095576708) 2 7 5 28861 25
169633 203549 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 181 Flood Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5999506.56732 2094057.55855 37.7298545448296 -122.444004922987 (37.7298545448296, -122.444004922987) 9 7 4 63 40
182873 125555 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Dashiell Hammett St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 1ft   6010375.3917 2116064.19944 37.7908938398292 -122.40798127711 (37.7908938398292, -122.40798127711) 5 1 10 28857 21
43175 38227 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1099 Mississippi St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM 14   Permit Number 40351 6014264.01456 2102105.05687 37.7527820922208 -122.393549330162 (37.7527820922208, -122.393549330162) 10 3 8 28856 29
139304 97553 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 250@Flood Detroit St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 42524 5999434 2093931 37.7295029047189 -122.444246704733 (37.7295029047189, -122.444246704733) 9 7 4 63 40
167316 91465 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1001 Greenwich St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2009 12:00:00 AM 9 3x3 Permit Number 52106 6008039.0019 2119934.2418 37.8013889308135 -122.416339336112 (37.8013889308135, -122.416339336112) 5 1 1 308 32
126015 109285 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 1530 Sloat Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773632 5986383.9 2095952.1 37.7342991443311 -122.489510139546 (37.7342991443311, -122.489510139546) 1 8 3 64 35
110235 87815 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2000 10th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 777426 5993220.6 2101817.5 37.750800806475 -122.466299791721 (37.750800806475, -122.466299791721) 1 8 4 29491 40
38682 158242 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 225 Bemis St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 778932 6003158.9626 2096376.80466 37.7364303417798 -122.431543687401 (37.7364303417798, -122.431543687401) 2 7 5 63 7
153032 243747 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 217 Whitney St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 Width 2ft Permit Number 780010 6004399.27823 2097187.62567 37.7387268946327 -122.427313133507 (37.7387268946327, -122.427313133507) 2 7 5 63 7

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