trees
22 rows where qSpecies_id = 244 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2774 | 166308 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 3280 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006941.12307 | 2106165.79363 | 37.7635223249106 | -122.419161293582 | (37.7635223249106, -122.419161293582) | 8 | 4 | 7 | 28859 | 19 | |||
4545 | 259402 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 1266 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6016876.75185 | 2093089.8714 | 37.7281730449098 | -122.383886247591 | (37.7281730449098, -122.383886247591) | 10 | 3 | 8 | 58 | 1 | ||
5440 | 258159 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 760 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6008719 | 2093255 | 37.7281721087609 | -122.412099667236 | (37.7281721087609, -122.412099667236) | 9 | 3 | 7 | 309 | 28 | ||
7096 | 254943 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2500 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998850 | 2088787 | 37.7153453344322 | -122.445895826002 | (37.7153453344322, -122.445895826002) | 9 | 7 | 6 | 28861 | 25 | ||||
8719 | 258160 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 760 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008719 | 2093255 | 37.7281721087609 | -122.412099667236 | (37.7281721087609, -122.412099667236) | 9 | 3 | 7 | 309 | 28 | |||
11757 | 152639 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2608 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2x3 | 6010363.37539 | 2103427.31306 | 37.7561952055556 | -122.407131710975 | (37.7561952055556, -122.407131710975) | 10 | 4 | 7 | 28859 | 19 | |||
28447 | 242815 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2701 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009780.14565 | 2104995.56148 | 37.7604686058483 | -122.409259390033 | (37.7604686058483, -122.409259390033) | 2 | 4 | 8 | 28859 | 19 | |||
62216 | 242811 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2745 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009688.52485 | 2104990.07805 | 37.7604484160935 | -122.409575878526 | (37.7604484160935, -122.409575878526) | 2 | 4 | 8 | 28859 | 19 | |||
86438 | 242812 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2745 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009701.72656 | 2104990.85902 | 37.7604513002023 | -122.409530274826 | (37.7604513002023, -122.409530274826) | 2 | 4 | 8 | 28859 | 19 | |||
127557 | 120038 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 854 28th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5987294.25132 | 2110228.98103 | 37.7735526974552 | -122.487411171522 | (37.7735526974552, -122.487411171522) | 11 | 6 | 2 | 55 | 26 | |||
139359 | 242813 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2745 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009725.73602 | 2104991.41978 | 37.7604541852183 | -122.409447276397 | (37.7604541852183, -122.409447276397) | 2 | 4 | 8 | 28859 | 19 | |||
157997 | 254937 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2400 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999054 | 2088906 | 37.7156837277395 | -122.445199265239 | (37.7156837277395, -122.445199265239) | 9 | 7 | 6 | 28861 | 25 | ||||
176392 | 254942 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2484 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998889 | 2088843 | 37.7155013245106 | -122.445765050288 | (37.7155013245106, -122.445765050288) | 9 | 7 | 6 | 28861 | 25 | ||||
188716 | 171134 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2406 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5999155.34859 | 2089024.08 | 37.7160137330124 | -122.44485744251 | (37.7160137330124, -122.44485744251) | 9 | 7 | 6 | 28861 | 25 | |||
189131 | 242814 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2745 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009744.75824 | 2104993.1324 | 37.7604599534949 | -122.40938160789 | (37.7604599534949, -122.40938160789) | 2 | 4 | 8 | 28859 | 19 | |||
67002 | 83546 | Permitted Site 7 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 1637 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52247 | 6008761.11402026 | 2118496.02129158 | 37.7974805140976 | -122.413738710342 | (37.7974805140976, -122.413738710342) | 5 | 1 | 10 | 308 | 21 | ||
80822 | 91338 | Permitted Site 7 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 829 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100 | 2112601 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | 6 | 2 | 9 | 28856 | 34 | ||
115911 | 84543 | Permitted Site 7 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2747 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52650 | 6009716.06976497 | 2104988.12537503 | 37.7604445979168 | -122.40948047515 | (37.7604445979168, -122.40948047515) | 2 | 4 | 8 | 28859 | 19 | ||
137895 | 84160 | Permitted Site 7 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2747 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52650 | 6009716 | 2104988 | 37.7604442497563 | -122.409480707587 | (37.7604442497563, -122.409480707587) | 2 | 4 | 8 | 28859 | 19 | |
142228 | 84542 | Permitted Site 7 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2747 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52650 | 6009716.06976497 | 2104988.12537503 | 37.7604445979168 | -122.40948047515 | (37.7604445979168, -122.40948047515) | 2 | 4 | 8 | 28859 | 19 | ||
152824 | 84172 | Permitted Site 7 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2747 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52650 | 6009716.06976497 | 2104988.12537503 | 37.7604445979168 | -122.40948047515 | (37.7604445979168, -122.40948047515) | 2 | 4 | 8 | 28859 | 19 | ||
186097 | 84455 | Permitted Site 7 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 2747 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52650 | 6009716.06976497 | 2104988.12537503 | 37.7604445979168 | -122.40948047515 | (37.7604445979168, -122.40948047515) | 2 | 4 | 8 | 28859 | 19 |
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) );