48 rows where Fire Prevention Districts = 15 and qSpecies_id = 65 sorted by PlantType

View and edit SQL

Fire Prevention Districts

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)
3367 221931 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2136 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003273.64696 2107146.54353 37.7660080078823 -122.431915952764 (37.7660080078823, -122.431915952764) 15 5 5 28862 3
11193 221927 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 30 Collingwood St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001978.23682 2105679.10169 37.7619052494464 -122.436291477373 (37.7619052494464, -122.436291477373) 15 4 5 28862 3
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
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
31198 84402 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1852 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM 4 3x3 Permit Number 51006 6000688.3478 2111734.5053 37.778458498926 -122.441187160325 (37.778458498926, -122.441187160325) 15 5 11 29490 41
31207 32474 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/10/1996 12:00:00 AM 15   Permit Number 36982 6000854.39467 2106273.37873 37.7634730690508 -122.440221013784 (37.7634730690508, -122.440221013784) 15 5 5 28862 3
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
48932 221930 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2134 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6003302.06195 2107147.52772 37.7660123210304 -122.431817741407 (37.7660123210304, -122.431817741407) 15 5 5 28862 3
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
56352 238396 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2221 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2018 12:00:00 AM 3 3x3 Permit Number 782349 6002719.76824 2107072.27368 37.7657726661007 -122.433826396093 (37.7657726661007, -122.433826396093) 15 5 5 28862 3
59484 221933 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4166 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001253.22781 2105851.44827 37.7623372504834 -122.438811343586 (37.7623372504834, -122.438811343586) 15 5 5 28862 3
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
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
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
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
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
90849 221932 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 265 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001846.56535 2107325.41516 37.7664181410013 -122.436864736716 (37.7664181410013, -122.436864736716) 15 5 5 28862 3
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
97742 141702 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 154 BEAUMONT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5996846.4318 2111948.6051 37.7788267693983 -122.454493192496 (37.7788267693983, -122.454493192496) 15 6 2 54 16
100013 112856 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 1700x BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6000040 2114920 37.7871680933118 -122.443658934554 (37.7871680933118, -122.443658934554) 15 6 1 29490 31
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
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
107364 221928 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3666 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002501.47722 2106518.4971 37.7642397410968 -122.434541817574 (37.7642397410968, -122.434541817574) 15 5 5 28862 3
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
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
124927 114086 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Cook St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     5997489.0948 2113600.1035 37.783398187645 -122.452389185424 (37.783398187645, -122.452389185424) 15 6 1 54 31
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
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
134976 255531 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2130 15th St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782019 6003380.68215 2107148.89983 37.7660205449408 -122.431545908158 (37.7660205449408, -122.431545908158) 15 5 5 28862 3
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
139226 221921 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 474 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002945.55902 2105503.88006 37.7614790472472 -122.432933374683 (37.7614790472472, -122.432933374683) 15 4 5 28862 3
151367 64508 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 841 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/21/1988 12:00:00 AM 36   Permit Number 25389 6000432.9415 2111897.9264 37.7788926598871 -122.442082438032 (37.7788926598871, -122.442082438032) 15 5 11 29490 16
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
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
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
163162 141448 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 194 Beaumont Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5996892.1188 2111627.1044 37.7779466329687 -122.454311915058 (37.7779466329687, -122.454311915058) 15 6 2 54 16
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
165916 125541 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 65 Heather Ave 1 Sidewalk: Curb side : Pot Tree Private 2     4     5997339.5515 2114115.46943 37.7848046777406 -122.452943756065 (37.7848046777406, -122.452943756065) 15 6 1 54 31
172187 114784 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1350 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2015 12:00:00 AM     Permit Number 773262 6000262.8 2113654.9 37.7837071608561 -122.442797219915 (37.7837071608561, -122.442797219915) 15 6 1 29490 13
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
180027 114084 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Cook St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     5997493.8327 2113562.2002 37.7832943866098 -122.452370058209 (37.7832943866098, -122.452370058209) 15 6 1 54 31
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
185444 221929 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 70 Beaver St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002463.4686 2106805.25277 37.7650249445694 -122.434693785007 (37.7650249445694, -122.434693785007) 15 5 5 28862 3
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
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
193468 114082 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Cook St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     5997500.7704 2113521.7588 37.7831837426404 -122.452343137457 (37.7831837426404, -122.452343137457) 15 6 1 54 31

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