trees

22 rows where qSpecies_id = 244

✎ View and edit SQL

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
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
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
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
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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);