trees
115 rows where Supervisor Districts = 7 and qSpecies_id = 5 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
178019 | 248274 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006747.61558 | 2098750.15701 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | 2 | 7 | 7 | 28859 | 2 | |||
53125 | 248260 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | 2 | 7 | 7 | 28859 | 2 | |||
64807 | 248261 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | 2 | 7 | 7 | 28859 | 2 | |||
59723 | 248262 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | 2 | 7 | 7 | 28859 | 2 | |||
111174 | 248263 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.7431418122345 | -122.419409127839 | (37.7431418122345, -122.419409127839) | 2 | 7 | 7 | 28859 | 2 | |||
114352 | 248264 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006711.60121 | 2098736.37276 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | 2 | 7 | 7 | 28859 | 2 | |||
12569 | 111886 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
32244 | 111887 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
124822 | 111888 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | ||||
32911 | 248271 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | 2 | 7 | 7 | 28859 | 2 | |||
64038 | 248270 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | 2 | 7 | 7 | 28859 | 2 | |||
151186 | 222896 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006441.81181 | 2107164.43854 | 37.7662362369242 | -122.420959163358 | (37.7662362369242, -122.420959163358) | 8 | 4 | 7 | 28853 | 19 | |||
115285 | 222894 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3080 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 27054 | 6006296.82054 | 2106727.45524 | 37.765028210007 | -122.421429624803 | (37.765028210007, -122.421429624803) | 8 | 4 | 7 | 28853 | 19 | |
169536 | 222895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.09401 | 37.7650176483701 | -122.421511125848 | (37.7650176483701, -122.421511125848) | 8 | 4 | 7 | 28853 | 19 | ||
90289 | 22896 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 201 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 2X2 | 6006117.69751 | 2108447.07837 | 37.7697397858216 | -122.422171347799 | (37.7697397858216, -122.422171347799) | 8 | 4 | 7 | 28853 | 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) );