trees
18 rows where Fire Prevention Districts = 11, SiteOrder = 3 and qSpecies_id = 65 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15441 | 70583 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1801 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5989858.46515 | 2113331.71432 | 37.7822211492768 | -122.478768239422 | (37.7822211492768, -122.478768239422) | 11 | 6 | 2 | 55 | 26 | |||
| 175001 | 124270 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2 03rd Ave | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 5994893.51688 | 2115041.88961 | 37.78720789934 | -122.461473360648 | (37.78720789934, -122.461473360648) | 11 | 6 | 1 | 54 | 11 | ||||
| 10290 | 90682 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3900 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983432.26602 | 2110389.71572 | 37.7737680483939 | -122.500782026808 | (37.7737680483939, -122.500782026808) | 11 | 6 | 2 | 55 | 26 | ||
| 24090 | 90673 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3750x CABRILLO ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984009 | 2110380 | 37.7737752151611 | -122.498786325695 | (37.7737752151611, -122.498786325695) | 11 | 6 | 2 | 55 | 26 | |
| 43723 | 90660 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3500X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984694.72726 | 2110433.79882 | 37.7739631265543 | -122.496418292329 | (37.7739631265543, -122.496418292329) | 11 | 6 | 2 | 55 | 26 | ||
| 51801 | 90784 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3701X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984081.19373 | 2110355.47188 | 37.7737121020185 | -122.498534787816 | (37.7737121020185, -122.498534787816) | 11 | 6 | 2 | 55 | 26 | ||
| 67477 | 90697 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982827.55624 | 2110364.98681 | 37.7736646287423 | -122.502871948318 | (37.7736646287423, -122.502871948318) | 11 | 6 | 2 | 55 | 26 | ||
| 79370 | 90796 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3549 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984574.63821 | 2110374.75064 | 37.7737939613496 | -122.496829335351 | (37.7737939613496, -122.496829335351) | 11 | 6 | 2 | 55 | 26 | ||
| 114939 | 90793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3601 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984413.80757 | 2110367.78962 | 37.7737654233107 | -122.49738515175 | (37.7737654233107, -122.49738515175) | 11 | 6 | 2 | 55 | 26 | ||
| 121570 | 90766 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3951X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983343.71874 | 2110330.47884 | 37.7736002020107 | -122.501083938875 | (37.7736002020107, -122.501083938875) | 11 | 6 | 2 | 55 | 26 | ||
| 152099 | 90778 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3801X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983771.39601 | 2110344.03814 | 37.773662535505 | -122.499605564361 | (37.773662535505, -122.499605564361) | 11 | 6 | 2 | 55 | 26 | ||
| 154640 | 90688 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4000X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983129.59902 | 2110378.53332 | 37.7737195704462 | -122.501828155386 | (37.7737195704462, -122.501828155386) | 11 | 6 | 2 | 55 | 26 | ||
| 154869 | 90808 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3403 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985025.16514 | 2110390.85068 | 37.7738645554816 | -122.495272101296 | (37.7738645554816, -122.495272101296) | 11 | 6 | 2 | 55 | 26 | ||
| 156379 | 90787 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3651 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984249.69419 | 2110361.4466 | 37.7737383870444 | -122.497952368705 | (37.7737383870444, -122.497952368705) | 11 | 6 | 2 | 55 | 26 | ||
| 164551 | 90753 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4139 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982725.59216 | 2110306.95683 | 37.7734993021465 | -122.503220354519 | (37.7734993021465, -122.503220354519) | 11 | 6 | 2 | 55 | 26 | ||
| 175685 | 90772 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3899X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983556.085422 | 2110343.567935 | 37.7736486085903 | -122.500350310129 | (37.7736486085903, -122.500350310129) | 11 | 6 | 2 | 55 | 26 | ||
| 187831 | 90759 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4101X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982835.15592 | 2110311.87807 | 37.773519254193 | -122.502841728095 | (37.773519254193, -122.502841728095) | 11 | 6 | 2 | 55 | 26 | ||
| 139805 | 117947 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3851 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5983640.26853 | 2110338.90864 | 37.7736407564987 | -122.500058768002 | (37.7736407564987, -122.500058768002) | 11 | 6 | 2 | 55 | 26 |
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) );