trees
33 rows where Fire Prevention Districts = 14 and qSpecies_id = 8 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109402 | 255703 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782078 | 6009781.99069 | 2112750.42942 | 37.7817617797421 | -122.409800416291 | (37.7817617797421, -122.409800416291) | 14 | 2 | 9 | 28853 | 34 | |
114137 | 253629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
181047 | 253628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
134922 | 106798 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009957 | 2113442 | 37.783670474647 | -122.409243780474 | (37.783670474647, -122.409243780474) | 14 | 10 | 9 | 28852 | 36 | ||||
119957 | 253631 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6009957.29008 | 2113442.89538 | 37.7836729493992 | -122.409242840109 | (37.7836729493992, -122.409242840109) | 14 | 10 | 9 | 28852 | 36 | ||||
127278 | 81551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 555 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50132 | 6009979.0752 | 2111765.16578 | 37.7790675210845 | -122.409049052091 | (37.7790675210845, -122.409049052091) | 14 | 2 | 9 | 28853 | 34 | |
172574 | 87147 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 555 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50132 | 6010000.21916 | 2111782.15708 | 37.7791153596345 | -122.408977105416 | (37.7791153596345, -122.408977105416) | 14 | 2 | 9 | 28853 | 34 | |
104786 | 191065 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Clara St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011631.45196 | 2111618.92007 | 37.7787583899224 | -122.403322487638 | (37.7787583899224, -122.403322487638) | 14 | 2 | 9 | 28856 | 34 | |||
88212 | 191064 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6011636.45479 | 2111621.63376 | 37.7787661204973 | -122.403305371746 | (37.7787661204973, -122.403305371746) | 14 | 2 | 9 | 28856 | 34 | |||
153520 | 191063 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6011640.41223 | 2111625.07225 | 37.7787757828176 | -122.403291923287 | (37.7787757828176, -122.403291923287) | 14 | 2 | 9 | 28856 | 34 | |||
92791 | 191062 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6011643.64166 | 2111627.47024 | 37.7787825475055 | -122.403280920094 | (37.7787825475055, -122.403280920094) | 14 | 2 | 9 | 28856 | 34 | |||
31166 | 191060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 1 | Width 2ft | 6011653.22625 | 2111699.06795 | 37.7789796735174 | -122.403252800969 | (37.7789796735174, -122.403252800969) | 14 | 2 | 9 | 28856 | 34 | |||
68081 | 191061 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 6 | Width 3ft | 6011653.56606 | 2111728.79849 | 37.779061325667 | -122.403253717397 | (37.779061325667, -122.403253717397) | 14 | 2 | 9 | 28856 | 34 | |||
160632 | 191058 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011781.36835 | 2111952.66121 | 37.7796831376017 | -122.402827343412 | (37.7796831376017, -122.402827343412) | 14 | 2 | 9 | 28856 | 34 | |||
9467 | 191059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 2 | : | Tree | Private 2 | 6 | Width 5ft | 6011805.95608 | 2111927.87879 | 37.7796164636776 | -122.402740539939 | (37.7796164636776, -122.402740539939) | 14 | 2 | 9 | 28856 | 34 | |||
136185 | 28906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.7795285306637 | -122.402635398413 | (37.7795285306637, -122.402635398413) | 14 | 2 | 9 | 28856 | 34 | |
24502 | 191066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011926.00282 | 2111797.31864 | 37.7792646776498 | -122.40231606173 | (37.7792646776498, -122.40231606173) | 14 | 2 | 9 | 28856 | 34 | |||
108598 | 191067 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/2014 12:00:00 AM | 8 | Width 3ft | 6011934.76855 | 2111785.94153 | 37.779233928048 | -122.402284937117 | (37.779233928048, -122.402284937117) | 14 | 2 | 9 | 28856 | 34 | ||
123555 | 44768 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 712 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | 6 | Permit Number 43876 | 6012361.28636 | 2111165.48886 | 37.7775541068837 | -122.400765825683 | (37.7775541068837, -122.400765825683) | 14 | 2 | 9 | 28856 | 34 | ||
146836 | 44769 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 712 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43876 | 6012402.09298601 | 2111195.83512486 | 37.7776397067003 | -122.400626793323 | (37.7776397067003, -122.400626793323) | 14 | 2 | 9 | 28856 | 34 | |||
54558 | 102355 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
89001 | 102356 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
141839 | 191089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012552.52179 | 2106660.8958 | 37.7651961772892 | -122.399787893906 | (37.7651961772892, -122.399787893906) | 14 | 3 | 8 | 28856 | 20 | |||
140307 | 191091 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012554.29768 | 2106630.73656 | 37.7651134657424 | -122.399779633617 | (37.7651134657424, -122.399779633617) | 14 | 3 | 8 | 28856 | 20 | |||
161565 | 191090 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012554.60334 | 2106645.79178 | 37.765154821059 | -122.399779633629 | (37.765154821059, -122.399779633629) | 14 | 3 | 8 | 28856 | 20 | |||
164893 | 67391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1992 12:00:00 AM | Permit Number 30888 | 6012577.17209413 | 2106598.24360902 | 37.7650255224957 | -122.399698234444 | (37.7650255224957, -122.399698234444) | 14 | 3 | 8 | 28856 | 20 | ||
55558 | 191092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014058.4688 | 2105768.40922 | 37.7628294422497 | -122.394516646351 | (37.7628294422497, -122.394516646351) | 14 | 3 | 8 | 28856 | 29 | |||
124140 | 191087 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | 14 | 3 | 8 | 28856 | 29 | ||||
33794 | 191086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6014399.78897 | 2105779.8886 | 37.762879931094 | -122.393336933676 | (37.762879931094, -122.393336933676) | 14 | 3 | 8 | 28856 | 29 | |||
46308 | 191085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6014420.63086 | 2105780.43179 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | 14 | 3 | 8 | 28856 | 29 | ||||
23656 | 191084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014440.03961 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | 14 | 3 | 8 | 28856 | 29 | ||||
186400 | 191083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597749 | (37.7628958266015, -122.39315597749) | 14 | 3 | 8 | 28856 | 29 | ||||
118388 | 191088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 01st St | 19 | : Yard | Tree | Private 2 | 18 | 6014455.34951 | 2105889.69248 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | 14 | 3 | 8 | 28856 | 29 |
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) );