trees
27 rows where PlotSize = "3x3", SiteOrder = 3 and qSpecies_id = 65
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1070 | 261149 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 322x Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991839 | 2099782 | 37.7451320352893 | -122.470929181064 | (37.7451320352893, -122.470929181064) | 1 | 8 | 4 | 29491 | 40 | ||||
4034 | 158226 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6004403.18115 | 2097173.01672 | 37.7386870025035 | -122.427298598675 | (37.7386870025035, -122.427298598675) | 2 | 7 | 5 | 63 | 7 | |||
9568 | 261150 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | ||
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 |
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 | ||
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 |
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 | ||
92398 | 91464 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52106 | 6008023.92041 | 2119932.41057 | 37.8013830546338 | -122.416391395149 | (37.8013830546338, -122.416391395149) | 5 | 1 | 1 | 308 | 32 | |
93586 | 102654 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 203X Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5995004 | 2088355 | 37.7139388056528 | -122.459157943572 | (37.7139388056528, -122.459157943572) | 9 | 8 | 6 | 28861 | 24 | |||
106840 | 82673 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Jennings Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52499 | 6012920.29338 | 2089198.31583 | 37.7172681083272 | -122.397291182543 | (37.7172681083272, -122.397291182543) | 10 | 3 | 8 | 58 | 1 | |
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 |
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 | ||
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 |
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 | ||
151383 | 1266 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5992143.83128 | 2087204.78999 | 37.7106157610663 | -122.46896001711 | (37.7106157610663, -122.46896001711) | 9 | 8 | 4 | 64 | 24 | |||
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 | ||
186665 | 87813 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
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 |
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) );