trees
19 rows where SiteOrder = 1, Supervisor Districts = 4 and qSpecies_id = 5
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 239 | 205987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | 1 | 8 | 4 | 56 | 12 | |||
| 24361 | 206014 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | 9 | 8 | 4 | 59 | 40 | |||
| 37929 | 82121 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.446593550118 | (37.7365973852663, -122.446593550118) | 9 | 7 | 4 | 59 | 40 | ||
| 47941 | 218315 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 437 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993144.55141 | 2099923.03964 | 37.7455947140337 | -122.466425098064 | (37.7455947140337, -122.466425098064) | 1 | 8 | 4 | 29491 | 40 | |||
| 50124 | 206005 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553 | (37.7394900683054, -122.47345704553) | 1 | 8 | 4 | 29491 | 40 | |||
| 63208 | 206021 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | 9 | 7 | 4 | 59 | 40 | |||
| 67228 | 206013 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992845.13508 | 2095810.81929 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | 9 | 8 | 4 | 59 | 40 | |||
| 75171 | 206004 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | 1 | 8 | 4 | 56 | 12 | |||
| 114437 | 206015 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.456394837862 | (37.7296789783055, -122.456394837862) | 9 | 7 | 4 | 28861 | 40 | |||
| 120839 | 206020 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 146 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994480.54768 | 2101060.81011 | 37.7487957447457 | -122.461887948175 | (37.7487957447457, -122.461887948175) | 1 | 8 | 4 | 29491 | 40 | |||
| 129163 | 205988 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1469 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993333.43827 | 2105504.18267 | 37.7609299931406 | -122.466177475131 | (37.7609299931406, -122.466177475131) | 1 | 8 | 4 | 56 | 12 | |||
| 150580 | 82143 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
| 152645 | 205995 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998862.6525 | 2096533.61775 | 37.7366164654663 | -122.446409060855 | (37.7366164654663, -122.446409060855) | 9 | 7 | 4 | 59 | 40 | |||
| 159417 | 57469 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 71 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1987 12:00:00 AM | Permit Number 24965 | 5992451.26080169 | 2092911.00734917 | 37.7263014049972 | -122.468312338233 | (37.7263014049972, -122.468312338233) | 9 | 8 | 4 | 59 | 40 | ||
| 159563 | 205993 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 334 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994259.77922 | 2101011.29176 | 37.7486470679175 | -122.462647767404 | (37.7486470679175, -122.462647767404) | 1 | 8 | 4 | 29491 | 40 | |||
| 164683 | 112815 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10 LOMITA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991472 | 2104830 | 37.7589712942358 | -122.472566156736 | (37.7589712942358, -122.472566156736) | 1 | 8 | 4 | 56 | 12 | ||||
| 164831 | 206009 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990946.44352 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | 1 | 8 | 4 | 29491 | 40 | |||
| 169891 | 205990 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993405.09676 | 2093676.51676 | 37.7284583518695 | -122.46507057606 | (37.7284583518695, -122.46507057606) | 9 | 8 | 4 | 59 | 40 | |||
| 191561 | 206003 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1593 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991725.49788 | 2104502.2556 | 37.7580860643266 | -122.471665566325 | (37.7580860643266, -122.471665566325) | 1 | 8 | 4 | 56 | 12 |
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) );