37 rows where qSpecies_id = 371

View and edit SQL

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
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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);