trees
26 rows where DBH = 16 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6628 | 73438 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 212 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5989642.98356 | 2113924.77294 | 37.7838370079244 | -122.479557105797 | (37.7838370079244, -122.479557105797) | 11 | 6 | 2 | 55 | 26 | |||
12867 | 73402 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1434 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5982802.3301 | 2105339.2702 | 37.759863969648 | -122.502587148941 | (37.759863969648, -122.502587148941) | 1 | 8 | 3 | 56 | 35 | |||
14208 | 70581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 366 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5989681.74367 | 2112910.59233 | 37.7810546031553 | -122.47934879186 | (37.7810546031553, -122.47934879186) | 11 | 6 | 2 | 55 | 26 | |||
65829 | 68256 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.409219186739 | (37.7281816043806, -122.409219186739) | 10 | 3 | 7 | 309 | 28 | |
165874 | 38552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1820 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 16 | Permit Number 40520 | 6015364.9925 | 2093693.5794 | 37.7297470188732 | -122.389154637038 | (37.7297470188732, -122.389154637038) | 10 | 3 | 8 | 58 | 1 | |
190685 | 39931 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 175 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 16 | Permit Number 41202 | 6010293.70332 | 2087956.69983 | 37.7137123004597 | -122.406282682604 | (37.7137123004597, -122.406282682604) | 9 | 7 | 8 | 309 | 39 | |
193468 | 114082 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Cook St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5997500.7704 | 2113521.7588 | 37.7831837426404 | -122.452343137457 | (37.7831837426404, -122.452343137457) | 15 | 6 | 1 | 54 | 31 | |||
30504 | 37659 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 486 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51139 | 5991909.24916 | 2112157.7974 | 37.7791167592266 | -122.471587940686 | (37.7791167592266, -122.471587940686) | 11 | 6 | 2 | 54 | 11 | |
33356 | 138630 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1702 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000078.3648 | 2114795.7207 | 37.7868290426993 | -122.443517270296 | (37.7868290426993, -122.443517270296) | 13 | 6 | 1 | 29490 | 27 | |||
97742 | 141702 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 154 BEAUMONT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5996846.4318 | 2111948.6051 | 37.7788267693983 | -122.454493192496 | (37.7788267693983, -122.454493192496) | 15 | 6 | 2 | 54 | 16 | |||
181596 | 140134 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1624 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999973.0263 | 2110940.5311 | 37.7762376765447 | -122.443604667807 | (37.7762376765447, -122.443604667807) | 15 | 5 | 11 | 29492 | 16 | |||
71152 | 221844 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6004153.19016 | 2095736.31086 | 37.7347279926082 | -122.428060594226 | (37.7347279926082, -122.428060594226) | 2 | 7 | 5 | 28861 | 25 | |||
125012 | 221854 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4418 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6000475.00831 | 2102295.38218 | 37.7525288566262 | -122.441247749083 | (37.7525288566262, -122.441247749083) | 2 | 4 | 5 | 28862 | 22 | |||
6832 | 221870 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 530 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008584.18129 | 2096552.27767 | 37.7372181568784 | -122.412798757353 | (37.7372181568784, -122.412798757353) | 10 | 7 | 7 | 28859 | 2 | |||
16984 | 203543 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 518 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997969.26989 | 2094410.6553 | 37.7307362500808 | -122.449344943519 | (37.7307362500808, -122.449344943519) | 9 | 7 | 4 | 59 | 40 | |||
45404 | 221907 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1217 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003244.02772 | 2101149.87665 | 37.7495409130801 | -122.431590240821 | (37.7495409130801, -122.431590240821) | 2 | 4 | 5 | 28862 | 22 | |||
49629 | 221833 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 577 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007293.94274 | 2103980.62531 | 37.7575422218038 | -122.417786099775 | (37.7575422218038, -122.417786099775) | 2 | 4 | 7 | 28859 | 19 | |||
103811 | 189214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1498 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6014376.75149 | 2102028.72002 | 37.7525787510095 | -122.393154121288 | (37.7525787510095, -122.393154121288) | 10 | 3 | 8 | 28856 | 29 | |||
139320 | 203578 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999939.80462 | 2094974.46238 | 37.7323968536154 | -122.442572982852 | (37.7323968536154, -122.442572982852) | 9 | 7 | 4 | 63 | 40 | |||
143155 | 221914 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 476 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003319.74249 | 2102160.73191 | 37.7523207750848 | -122.431400568387 | (37.7523207750848, -122.431400568387) | 2 | 4 | 5 | 28862 | 22 | |||
149081 | 221900 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004249.68912 | 2095508.61359 | 37.7341082463924 | -122.427710746252 | (37.7341082463924, -122.427710746252) | 2 | 7 | 5 | 28861 | 25 | |||
154673 | 221886 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 121 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006322.71195 | 2097511.22057 | 37.7397240062552 | -122.420685761336 | (37.7397240062552, -122.420685761336) | 2 | 7 | 7 | 28859 | 2 | |||
157942 | 221798 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004116.67022 | 2110321.94704 | 37.7747746486742 | -122.429226550889 | (37.7747746486742, -122.429226550889) | 7 | 9 | 11 | 28852 | 10 | |||
171216 | 203540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 305 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998091.57112 | 2094441.2535 | 37.7308272605603 | -122.448924334186 | (37.7308272605603, -122.448924334186) | 9 | 7 | 4 | 59 | 40 | |||
176460 | 124540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5992434.91117 | 2111337.17059 | 37.7768939384148 | -122.469709718849 | (37.7768939384148, -122.469709718849) | 11 | 6 | 2 | 54 | 11 | |||
35544 | 221939 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 21 Harry St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003408.10773 | 2097774.81236 | 37.740283068906 | -122.430782023672 | (37.740283068906, -122.430782023672) | 2 | 7 | 5 | 63 | 7 |
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) );