trees
37 rows where qSpecies_id = 371 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16782 | 237960 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 571 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6002836.92742 | 2099745.95433 | 37.7456629887692 | -122.432897720155 | (37.7456629887692, -122.432897720155) | 2 | 7 | 5 | 63 | 22 | |||
22992 | 178860 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 89 Belle Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 5991691.41062 | 2086487.07285 | 37.7086189324765 | -122.470471431226 | (37.7086189324765, -122.470471431226) | 9 | 8 | 4 | 64 | 24 | |||
38721 | 24263 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 300X Winding Way | 1 | Median : Cutout | Tree | DPW 1 | 30 | 8 | 6001575.13411 | 2086503.14158 | 37.7092295937538 | -122.436313223902 | (37.7092295937538, -122.436313223902) | 9 | 7 | 6 | 28861 | 5 | |||
46081 | 214363 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1549 15th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5991540.65145 | 2104932.9857 | 37.7592580392483 | -122.472336237554 | (37.7592580392483, -122.472336237554) | 1 | 8 | 4 | 56 | 12 | ||||
48244 | 237961 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 177 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6000805.94873 | 2103333.15476 | 37.7553971750633 | -122.440177715934 | (37.7553971750633, -122.440177715934) | 2 | 4 | 5 | 28862 | 38 | ||||
48253 | 249619 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 2398 Golden Gate Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 5998061.53273 | 2111381.56318 | 37.7773394333005 | -122.450248814341 | (37.7773394333005, -122.450248814341) | 15 | 6 | 2 | 54 | 16 | |||
56202 | 178859 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 300x Winding Way | 2 | Median : Cutout | Tree | DPW 1 | 36 | Width 0ft | 6001566.6929 | 2086499.15435 | 37.7092181660671 | -122.436342112826 | (37.7092181660671, -122.436342112826) | 9 | 7 | 6 | 28861 | 5 | |||
59580 | 214368 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 711 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | 5997395.8129 | 2094969.98374 | 37.7322392132673 | -122.451367789509 | (37.7322392132673, -122.451367789509) | 9 | 7 | 4 | 59 | 40 | ||||
59724 | 123750 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 2 Cabrillo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5995617 | 2110854 | 37.775750686051 | -122.458666990683 | (37.775750686051, -122.458666990683) | 11 | 6 | 2 | 54 | 11 | |||
79390 | 135877 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1998 Jefferson St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 1ft | 5999700.17509 | 2121253.84302 | 37.804539757774 | -122.445290220574 | (37.804539757774, -122.445290220574) | 13 | 9 | 1 | 57 | 17 | |||
82308 | 214370 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 280 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5992489.60576 | 2089794.03711 | 37.7177451815858 | -122.4679531649 | (37.7177451815858, -122.4679531649) | 9 | 8 | 6 | 64 | 24 | |||
82460 | 178862 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 475 Country Club Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5984727.35234 | 2094646.97301 | 37.7306187644333 | -122.49514106342 | (37.7306187644333, -122.49514106342) | 1 | 8 | 4 | 64 | 35 | |||
83318 | 214362 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1549 15th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 5991544.57337 | 2104931.26078 | 37.7592535300574 | -122.472322548047 | (37.7592535300574, -122.472322548047) | 1 | 8 | 4 | 56 | 12 | ||||
85303 | 214364 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1549 15th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5991543.36526 | 2104936.54185 | 37.7592679605603 | -122.472327111216 | (37.7592679605603, -122.472327111216) | 1 | 8 | 4 | 56 | 12 | ||||
100483 | 237959 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 4301 26th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6001852.48827 | 2100568.36234 | 37.747865241384 | -122.436360606479 | (37.747865241384, -122.436360606479) | 2 | 4 | 5 | 63 | 22 | |||
104554 | 2756 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 130 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 5995174.76257 | 2110814.06482 | 37.7756156072533 | -122.460193896477 | (37.7756156072533, -122.460193896477) | 11 | 6 | 2 | 54 | 11 | |||
106820 | 214366 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1549 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5991544.33826 | 2104943.58363 | 37.7592873517403 | -122.472324259478 | (37.7592873517403, -122.472324259478) | 1 | 8 | 4 | 56 | 12 | ||||
108651 | 214371 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 280 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5992489.13857 | 2089808.10753 | 37.7177837885668 | -122.46795580262 | (37.7177837885668, -122.46795580262) | 9 | 8 | 6 | 64 | 24 | |||
110789 | 237958 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 4301 26th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6001845.26134 | 2100568.224 | 37.747864450895 | -122.436385586923 | (37.747864450895, -122.436385586923) | 2 | 4 | 5 | 63 | 22 | |||
112835 | 237957 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 612 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001964.12241 | 2099450.71378 | 37.7448027845374 | -122.435894623662 | (37.7448027845374, -122.435894623662) | 2 | 7 | 5 | 63 | 22 | |||
112975 | 107342 | Significant Tree 6 | Prunus laurocerasus :: English laurel 371 | 110 JULIAN AVE | 1 | Back Yard : Yard | Tree | Private 2 | 100 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | 8 | 4 | 7 | 28853 | 19 | ||||
113143 | 237962 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 177 Grand View Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | 6000813.89685 | 2103347.44097 | 37.7554368540311 | -122.440151253392 | (37.7554368540311, -122.440151253392) | 2 | 4 | 5 | 28862 | 38 | ||||
114067 | 214367 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 711 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5997381.65215 | 2094970.27905 | 37.7322392132504 | -122.451416767471 | (37.7322392132504, -122.451416767471) | 9 | 7 | 4 | 59 | 40 | ||||
121254 | 123442 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 770 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Width 4ft | 5995072.84677 | 2110398.87908 | 37.7744697543778 | -122.46051635392 | (37.7744697543778, -122.46051635392) | 11 | 6 | 2 | 54 | 11 | |||
128727 | 237956 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 225 Kingston St | 1 | : | Tree | Private 2 | 26 | Width 4ft | 6006307.0177 | 2098035.04162 | 37.7411614169794 | -122.420777203522 | (37.7411614169794, -122.420777203522) | 2 | 7 | 7 | 28859 | 2 | |||
132276 | 135876 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1998 Jefferson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5999716.36995 | 2121255.20068 | 37.8045444099615 | -122.445234274639 | (37.8045444099615, -122.445234274639) | 13 | 9 | 1 | 57 | 17 | |||
136426 | 178861 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 475 Country Club Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5984726.53104 | 2094657.37794 | 37.7306472855285 | -122.495144669717 | (37.7306472855285, -122.495144669717) | 1 | 8 | 4 | 64 | 35 | |||
143998 | 214360 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1549 15th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5991543.46931 | 2104921.03616 | 37.7592253920544 | -122.472325621024 | (37.7592253920544, -122.472325621024) | 1 | 8 | 4 | 56 | 12 | ||||
153649 | 214369 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 280 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5992489.92941 | 2089773.12953 | 37.7176877931326 | -122.467950526298 | (37.7176877931326, -122.467950526298) | 9 | 8 | 6 | 64 | 24 | |||
162891 | 249739 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 2500 Broderick St | 23 | : | Tree | Private 2 | 12 | Width 3ft | 6000181.57325 | 2117191.47862 | 37.793413053123 | -122.443332338011 | (37.793413053123, -122.443332338011) | 13 | 9 | 1 | 57 | 27 | |||
168844 | 214365 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1549 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5991540.76565 | 2104938.40333 | 37.7592729212382 | -122.472336237538 | (37.7592729212382, -122.472336237538) | 1 | 8 | 4 | 56 | 12 | ||||
171189 | 214361 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1549 15th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5991542.49822 | 2104926.70561 | 37.7592409026637 | -122.472329392783 | (37.7592409026637, -122.472329392783) | 1 | 8 | 4 | 56 | 12 | ||||
188834 | 135875 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1998 Jefferson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5999729.52384 | 2121257.63856 | 37.8045518545403 | -122.445188929927 | (37.8045518545403, -122.445188929927) | 13 | 9 | 1 | 57 | 17 | |||
35476 | 55322 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1174 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 9 | Permit Number 11252 | 6011343.89577 | 2089330.65772 | 37.7175436012422 | -122.402749381186 | (37.7175436012422, -122.402749381186) | 10 | 7 | 8 | 309 | 39 | ||
33093 | 46368 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 1839 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2010 12:00:00 AM | 4 | Permit Number 53354 | 6004357.9818 | 2115208.0648 | 37.7882043731201 | -122.428740197102 | (37.7882043731201, -122.428740197102) | 13 | 9 | 11 | 29490 | 27 | ||
133606 | 100571 | Permitted Site 7 | Prunus laurocerasus :: English laurel 371 | 20 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2014 12:00:00 AM | 3x3 | Permit Number 770316 | 6004449 | 2107658 | 37.7674789047962 | -122.427887091326 | (37.7674789047962, -122.427887091326) | 8 | 4 | 5 | 28862 | 3 | ||
107033 | 104876 | Planning Code 138.1 required 2 | Prunus laurocerasus :: English laurel 371 | 2478 43rd Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | Permit Number 778928 | 5983068.6 | 2098273.8 | 37.7404797966413 | -122.501143676277 | (37.7404797966413, -122.501143676277) | 1 | 8 | 3 | 29491 | 35 |
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) );