trees
21 rows where DBH = 3, SiteOrder = 3 and qSpecies_id = 65 sorted by Longitude
This data as json, CSV (advanced)
These facets timed out: SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67823 | 103022 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 40X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770067 | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 |
117767 | 158241 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003145.71012 | 2096365.89505 | 37.7363996353363 | -122.431588728148 | (37.7363996353363, -122.431588728148) | 2 | 7 | 5 | 63 | 7 |
8169 | 160453 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||
108513 | 254649 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 929 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781532 | 6000895.17385 | 2091578.90462 | 37.7231278434042 | -122.439026791536 | (37.7231278434042, -122.439026791536) | 9 | 7 | 6 | 28861 | 25 |
52586 | 109284 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
171554 | 21401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2692X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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) );