trees
29 rows where Zip Codes = 29492 and qSpecies_id = 65 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |
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 | |||
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 | |
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 | |||||
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 | |||
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 | ||
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 | |||
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 | ||||
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 | ||
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 | |||
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
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) );