trees
41 rows where qSpecies_id = 343
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11280 | 255501 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1721 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781665 | 6004692 | 2098863 | 37.7433436417188 | -122.426420296182 | (37.7433436417188, -122.426420296182) | 2 | 7 | 5 | 63 | 22 | |
13330 | 256630 | Undocumented 4 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 4805 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2104713 | 37.7591256596381 | -122.443932088895 | (37.7591256596381, -122.443932088895) | 2 | 4 | 5 | 28862 | 3 | ||||
16257 | 225172 | Section 806 (d) 5 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 248 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | 4x4 | Permit Number 779647 | 6006535.62128 | 2098220.14009 | 37.7416825381227 | -122.419999905071 | (37.7416825381227, -122.419999905071) | 2 | 7 | 7 | 28859 | 2 | |
29244 | 105737 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 419 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | 2 | 4x4 | 6002669 | 2109966 | 37.7737152461646 | -122.434208882327 | (37.7737152461646, -122.434208882327) | 15 | 5 | 11 | 29492 | 10 | ||
30058 | 87568 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1590X Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | 13 | 9 | 10 | 28858 | 32 | |
32455 | 75714 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 40 Lomita Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.7588236399878 | -122.472871938091 | (37.7588236399878, -122.472871938091) | 1 | 8 | 4 | 56 | 12 | |||
33880 | 75595 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 40 Lomita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.7588236399878 | -122.472871938091 | (37.7588236399878, -122.472871938091) | 1 | 8 | 4 | 56 | 12 | |||
38207 | 75656 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 40 Lomita Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.7588236399878 | -122.472871938091 | (37.7588236399878, -122.472871938091) | 1 | 8 | 4 | 56 | 12 | |||
58047 | 75767 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 40 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.7588236399878 | -122.472871938091 | (37.7588236399878, -122.472871938091) | 1 | 8 | 4 | 56 | 12 | |||
60490 | 106359 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 276 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770436 | 6009994.6 | 2121304.9 | 37.805262192623 | -122.409668866645 | (37.805262192623, -122.409668866645) | 3 | 1 | 10 | 308 | 23 | ||||
62668 | 105726 | Undocumented 4 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 428A PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6002769.7 | 2110121.3 | 37.7741473764159 | -122.43387164824 | (37.7741473764159, -122.43387164824) | 15 | 5 | 11 | 29492 | 10 | |||
65662 | 109875 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 400 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | 1 | 4x4 | 6002729.7 | 2109998.5 | 37.773807928081 | -122.434001235387 | (37.773807928081, -122.434001235387) | 15 | 5 | 11 | 29492 | 10 | ||
67036 | 107315 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1400X Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.96329 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | 15 | 5 | 11 | 29492 | 10 | ||
67641 | 100422 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1701X 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | 1 | 8 | 4 | 56 | 12 | ||
72791 | 62051 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 276 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1985 12:00:00 AM | 17 | 7x15 | Permit Number 770436 | 6010004.5465 | 2121290.7324 | 37.8052238492822 | -122.409633444792 | (37.8052238492822, -122.409633444792) | 3 | 1 | 10 | 308 | 23 | |
78807 | 562 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 2946 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2016 07:44:00 AM | 3 | 3x3 | 6009264.69318 | 2102193.27439 | 37.7527452658941 | -122.410844191525 | (37.7527452658941, -122.410844191525) | 2 | 4 | 7 | 28859 | 19 | ||
79541 | 86743 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 2690 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | 13 | 9 | 1 | 57 | 27 | |||
87291 | 75468 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 40 Lomita Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.7588236399878 | -122.472871938091 | (37.7588236399878, -122.472871938091) | 1 | 8 | 4 | 56 | 12 | |||
89311 | 102042 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 307 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2012 12:00:00 AM | 3x3 | Permit Number 769064 | 5993385.6 | 2103903 | 37.7565365712381 | -122.465880727208 | (37.7565365712381, -122.465880727208) | 1 | 8 | 4 | 56 | 12 | ||
93305 | 100421 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1701X 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | 1 | 8 | 4 | 56 | 12 | ||
95543 | 96086 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 2120 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | Permit Number 767147 | 6004557 | 2116744 | 37.7924329253555 | -122.428161130615 | (37.7924329253555, -122.428161130615) | 13 | 9 | 1 | 28858 | 27 | |||
97180 | 109873 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 400 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | 1 | 4x4 | 6002729.7 | 2109998.5 | 37.773807928081 | -122.434001235387 | (37.773807928081, -122.434001235387) | 15 | 5 | 11 | 29492 | 10 | ||
110709 | 100420 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1701X 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | 1 | 8 | 4 | 56 | 12 | ||
111123 | 99618 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1590X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | 13 | 9 | 10 | 28858 | 32 | |
113128 | 107316 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1400X Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.96329 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | 15 | 5 | 11 | 29492 | 10 | ||
114104 | 105747 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 428A Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | 2 | 4x4 | Permit Number 771653 | 6002700 | 2110005 | 37.7738240899214 | -122.434104437093 | (37.7738240899214, -122.434104437093) | 15 | 5 | 11 | 29492 | 10 | |
116167 | 93912 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 2690 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | 13 | 9 | 1 | 57 | 27 | |||
123281 | 99619 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1590X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | 13 | 9 | 10 | 28858 | 32 | |
125011 | 22606 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 930 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2014 12:00:00 AM | 3 | 3X3 | Permit Number 773338 | 6005716.49366 | 2112844.21486 | 37.7817906187885 | -122.423871816525 | (37.7817906187885, -122.423871816525) | 7 | 9 | 11 | 28852 | 41 | |
135393 | 19209 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 395X Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/25/2014 02:29:00 PM | 3 | 3.5x3. 5 | 6012205.7972639 | 2118092.2355744 | 37.7965646535307 | -122.401790730678 | (37.7965646535307, -122.401790730678) | 3 | 1 | 10 | 28860 | 4 | ||
139237 | 112879 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 755 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 772774 | 5995320.1 | 2110503.8 | 37.7747720606524 | -122.459668664517 | (37.7747720606524, -122.459668664517) | 11 | 6 | 2 | 54 | 11 | |||
147851 | 86745 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 2690 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | 13 | 9 | 1 | 57 | 27 | |||
149799 | 107317 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1400X Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.96329 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | 15 | 5 | 11 | 29492 | 10 | ||
151554 | 75531 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 40 Lomita Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.7588236399878 | -122.472871938091 | (37.7588236399878, -122.472871938091) | 1 | 8 | 4 | 56 | 12 | |||
167244 | 99617 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1590X Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | 13 | 9 | 10 | 28858 | 32 | |
168421 | 241673 | Planning Code 138.1 required 2 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 21 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778206 | 6005133.3823 | 2108100.0759 | 37.7687314320489 | -122.425551368812 | (37.7687314320489, -122.425551368812) | 8 | 4 | 5 | 28853 | 19 | |
169687 | 107313 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1400X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.96329 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | 15 | 5 | 11 | 29492 | 10 | ||
172809 | 107318 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1400X Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.96329 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | 15 | 5 | 11 | 29492 | 10 | ||
173455 | 26186 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 538 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/18/2015 12:00:00 AM | 2 | 3X6 | Permit Number 772904 | 6002328.19294 | 2105046.72262 | 37.7601887674112 | -122.435035888908 | (37.7601887674112, -122.435035888908) | 2 | 4 | 5 | 28862 | 3 | |
180267 | 107314 | DPW Maintained 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1400X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.96329 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | 15 | 5 | 11 | 29492 | 10 | ||
185243 | 86744 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 2690 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | 13 | 9 | 1 | 57 | 27 |
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) );