trees
29 rows where Fire Prevention Districts = 2, SiteOrder = 2 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135492 | 115202 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1352 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | 2 | 7 | 5 | 63 | 22 | |||
7501 | 262401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
35685 | 99537 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 3x3 | Permit Number 768635 | 6004924.7 | 2102557.1 | 37.7534999396673 | -122.425878575683 | (37.7534999396673, -122.425878575683) | 2 | 4 | 5 | 28862 | 22 | ||
52019 | 119902 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
63785 | 158240 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003134.83556 | 2096356.78559 | 37.7363740064603 | -122.43162567588 | (37.7363740064603, -122.43162567588) | 2 | 7 | 5 | 63 | 7 |
93872 | 102475 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 38389 | 6007298 | 2103932 | 37.7574089362149 | -122.417768621509 | (37.7574089362149, -122.417768621509) | 2 | 4 | 7 | 28859 | 19 | |||
17657 | 221821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6007305.19909 | 2096505.34711 | 37.7370174246124 | -122.417217471014 | (37.7370174246124, -122.417217471014) | 2 | 7 | 7 | 28859 | 2 | |||
132523 | 115548 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 20 | 4x6 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 | ||
12895 | 221826 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008314.44854 | 2096531.09899 | 37.7371448612571 | -122.413729852457 | (37.7371448612571, -122.413729852457) | 2 | 7 | 7 | 28859 | 2 | |||
28695 | 221842 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004251.52018 | 2095424.77714 | 37.7338781539609 | -122.427698444448 | (37.7338781539609, -122.427698444448) | 2 | 7 | 5 | 28861 | 25 | |||
43199 | 221866 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002528.4957 | 2095557.08411 | 37.734143822686 | -122.433664907521 | (37.734143822686, -122.433664907521) | 2 | 7 | 5 | 63 | 7 | |||
69139 | 221840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004312.44121 | 2095336.44977 | 37.7336390727743 | -122.427481531566 | (37.7336390727743, -122.427481531566) | 2 | 7 | 5 | 28861 | 25 | |||
167184 | 221846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6004388.2708 | 2095606.1808 | 37.7343839821397 | -122.427238573395 | (37.7343839821397, -122.427238573395) | 2 | 7 | 5 | 28861 | 25 | |||
1033 | 221901 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004253.74444 | 2095482.9703 | 37.7340380650904 | -122.427694899296 | (37.7340380650904, -122.427694899296) | 2 | 7 | 5 | 28861 | 25 | |||
3673 | 221872 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007332.3833 | 2097776.98457 | 37.740510589287 | -122.417213566178 | (37.740510589287, -122.417213566178) | 2 | 7 | 7 | 28859 | 2 | |||
32667 | 221878 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 18 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006985.0649 | 2099647.22119 | 37.7456262946341 | -122.41854704763 | (37.7456262946341, -122.41854704763) | 2 | 7 | 7 | 28859 | 2 | |||
44302 | 221856 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 310 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000610.61852 | 2101933.59312 | 37.7515431951678 | -122.440752837776 | (37.7515431951678, -122.440752837776) | 2 | 4 | 5 | 28862 | 22 | |||
53011 | 221889 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006689.37303 | 2102664.80303 | 37.7538952362014 | -122.419783585756 | (37.7538952362014, -122.419783585756) | 2 | 4 | 7 | 28859 | 19 | |||
95633 | 221883 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 34 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007121.00835 | 2099271.28888 | 37.7446017212974 | -122.418050328662 | (37.7446017212974, -122.418050328662) | 2 | 7 | 7 | 28859 | 2 | |||
99508 | 221835 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 585 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007295.48201 | 2103941.69106 | 37.7574354039359 | -122.41777801665 | (37.7574354039359, -122.41777801665) | 2 | 4 | 7 | 28859 | 19 | |||
135296 | 221865 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 592 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002930.8792 | 2095923.87336 | 37.7351737658507 | -122.432299929108 | (37.7351737658507, -122.432299929108) | 2 | 7 | 5 | 63 | 7 | |||
191257 | 221925 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003063.11799 | 2104395.60529 | 37.7584426581259 | -122.432447626582 | (37.7584426581259, -122.432447626582) | 2 | 4 | 5 | 28862 | 3 | |||
192627 | 221915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 476 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003301.60957 | 2102160.71382 | 37.7523196977161 | -122.431463273608 | (37.7523196977161, -122.431463273608) | 2 | 4 | 5 | 28862 | 22 | |||
115143 | 221806 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003875.18729 | 2100363.84416 | 37.7474184051535 | -122.429351626769 | (37.7474184051535, -122.429351626769) | 2 | 7 | 5 | 63 | 22 | |||
179502 | 221830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6008241.38226 | 2104159.63616 | 37.7580870167112 | -122.414522128209 | (37.7580870167112, -122.414522128209) | 2 | 4 | 7 | 28859 | 19 | |||
186130 | 221808 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004922.45206 | 2102542.08461 | 37.753458583869 | -122.425885280803 | (37.753458583869, -122.425885280803) | 2 | 4 | 5 | 28862 | 22 | |||
16727 | 227695 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4250 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6001245.67427 | 2103366.3123 | 37.7555132424609 | -122.438659390527 | (37.7555132424609, -122.438659390527) | 2 | 4 | 5 | 28862 | 3 | |||
99862 | 221909 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 6003227.24309 | 2101470.4878 | 37.7504202845862 | -122.43167116991 | (37.7504202845862, -122.43167116991) | 2 | 4 | 5 | 28862 | 22 | |||
101047 | 221790 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3456 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 5ft | 6005327.10837 | 2103145.45598 | 37.7551381613168 | -122.424528807253 | (37.7551381613168, -122.424528807253) | 2 | 4 | 5 | 28859 | 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) );