trees
48 rows where Fire Prevention Districts = 15 and qSpecies_id = 65 sorted by PlotSize
This data as json, CSV (advanced)
These facets timed out: 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |
| 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 | ||||
| 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 | |
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );