29 rows where Zip Codes = 29492 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

These facets timed out: SiteOrder, Zip Codes

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)
24285 115206 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 390 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2016 12:00:00 AM     Permit Number 775334 6003427 2108679.3 37.7702252763858 -122.431494968546 (37.7702252763858, -122.431494968546) 15 9 11 29492 10
54908 63857 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 317 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24557 6002233.40181795 2109560.38159908 37.7725767859044 -122.435686656968 (37.7725767859044, -122.435686656968) 15 5 11 29492 9
55347 63855 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 728 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24554 6003932.92812606 2110451.32130531 37.7751194750929 -122.429871382589 (37.7751194750929, -122.429871382589) 7 9 11 29492 10
61402 64790 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 221 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1989 12:00:00 AM     Permit Number 25786 6002754.53875379 2109297.20875 37.7718837652657 -122.433865178188 (37.7718837652657, -122.433865178188) 15 5 11 29492 9
77926 63770 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 533 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/20/1999 12:00:00 AM     Permit Number 24449 6003130.90758036 2110082.2752919 37.7740607150966 -122.432619380335 (37.7740607150966, -122.432619380335) 15 9 11 29492 10
85775 30579 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 396 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM 2   Permit Number 34554 6003425.76209 2108645.89167 37.7701334751172 -122.43149686511 (37.7701334751172, -122.43149686511) 15 9 11 29492 10
122230 69299 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1632 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1994 12:00:00 AM 25   Permit Number 33374 5999947.983 2110939.1774 37.7762325313103 -122.443691201885 (37.7762325313103, -122.443691201885) 15 5 11 29492 16
129534 247526 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1101 Waller St 7 Side Yard : Yard Tree Private 2     25     6000042.11565 2108480.23517 37.7694862662998 -122.44318892675 (37.7694862662998, -122.44318892675) 15 5 11 29492 9
155801 55230 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 1214 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/2015 12:00:00 AM 3   Permit Number 774077 5998221.35114249 2106191.93019124 37.7630991715617 -122.449321957902 (37.7630991715617, -122.449321957902) 15 5 11 29492 9
178793 64789 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 214 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1989 12:00:00 AM     Permit Number 25785 6002808.76039687 2109284.75060862 37.7718526350484 -122.433676731328 (37.7718526350484, -122.433676731328) 15 5 11 29492 9
188694 65036 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 69 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1992 12:00:00 AM     Permit Number 31412 6002360.88534811 2108648.78551282 37.7700810087641 -122.435180464659 (37.7700810087641, -122.435180464659) 15 5 5 29492 9
160970 107168 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 65 SCOTT ST   Sidewalk: Curb side : Cutout Tree Private 2       2x2   6002336.3 2108640.7 37.7700574118158 -122.435264926513 (37.7700574118158, -122.435264926513) 15 5 5 29492 9
63335 102588 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 222 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002344.3 2109244.2 37.7717149279992 -122.435280428905 (37.7717149279992, -122.435280428905) 15 5 11 29492 9
135999 109068 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 1216 COLE ST   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/2015 12:00:00 AM 3 3x3 Permit Number 774077 5998287 2106143.6 37.762970223958 -122.449091419823 (37.762970223958, -122.449091419823) 15 5 11 29492 9
163225 120637 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 401 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     27 3x3   6000628.4194 2110406.526 37.77480879071 -122.441299165195 (37.77480879071, -122.441299165195) 15 5 11 29492 16
189079 253703 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1221 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998953 2105574 37.7614443133046 -122.446746977382 (37.7614443133046, -122.446746977382) 15 5 11 29492 12
12478 246193 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 755 Buena Vista Ave West 1 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2019 12:00:00 AM 3 Width 0ft   5999885.5759 2108037.456 37.7682615787189 -122.443698575802 (37.7682615787189, -122.443698575802) 15 5 11 29492 9
130358 247338 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 220 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6002315.9732 2109334.9211 37.7719624169971 -122.435384903619 (37.7719624169971, -122.435384903619) 15 5 11 29492 9
155522 247495 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 537 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003124.7415 2110167.9221 37.7742955303854 -122.432646828997 (37.7742955303854, -122.432646828997) 15 9 11 29492 10
181596 140134 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1624 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5999973.0263 2110940.5311 37.7762376765447 -122.443604667807 (37.7762376765447, -122.443604667807) 15 5 11 29492 16
183625 244227 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 332 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003264.0141 2109482.4208 37.7724212100587 -122.43211609665 (37.7724212100587, -122.43211609665) 15 9 11 29492 10
59779 221868 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 30 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5997080.14125 2106419.81481 37.7636595407827 -122.45328544896 (37.7636595407827, -122.45328544896) 15 5 11 29492 12
117834 221786 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 65 Scott St 1 : Tree Private 2     20 Width 2ft   6002363.3837 2108638.99661 37.7700542727214 -122.435171122647 (37.7700542727214, -122.435171122647) 15 5 5 29492 9
34536 221809 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1216 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5998224.25103 2106127.66613 37.7629228845101 -122.449307297897 (37.7629228845101, -122.449307297897) 15 5 11 29492 9
64215 221934 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 210 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003798.91454 2109132.99672 37.7714920890238 -122.430240891706 (37.7714920890238, -122.430240891706) 7 9 11 29492 10
75216 221785 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 69 Scott St 1 : Tree Private 2     19 Width 3ft   6002359.55948 2108655.68222 37.7700998701305 -122.435185544178 (37.7700998701305, -122.435185544178) 15 5 5 29492 9
97000 221811 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 115 Clifford Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999522.48156 2106496.55689 37.7640099400302 -122.444843701773 (37.7640099400302, -122.444843701773) 15 5 5 29492 9
103782 221810 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1214 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5998223.78162 2106145.07477 37.7629706574012 -122.449310175733 (37.7629706574012, -122.449310175733) 15 5 11 29492 9
72775 125543 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 511 Webster St 1 : Tree Private 2     1 Width 4ft   6004027.82216 2110630.44547 37.7756166793921 -122.429555900592 (37.7756166793921, -122.429555900592) 7 9 11 29492 10

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