home / trees

Street_Tree_List

Data source: data.sfgov.org

37 rows where qSpecies = 87

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
519 100571 Permitted Site 2 Prunus laurocerasus :: English laurel 87 20 Landers St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/31/2014 12:00:00 AM   3x3 Permit Number 770316 6004449.0 2107658.0 37.76747890479621 -122.42788709132601 (37.7674789047962, -122.427887091326) 8 4 5 28862 3
4336 104876 Planning Code 138.1 required 8 Prunus laurocerasus :: English laurel 87 2478 43rd Ave   Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.740479796641296 -122.50114367627701 (37.7404797966413, -122.501143676277) 1 8 3 29491 35
6331 107342 Significant Tree 4 Prunus laurocerasus :: English laurel 87 110 JULIAN AVE 1 Back Yard : Yard 6 Tree 1 Private 2     100     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366) 8 4 7 28853 19
20852 123442 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 770 03rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     41 Width 4ft   5995072.84677 2110398.87908 37.7744697543778 -122.46051635392 (37.7744697543778, -122.46051635392) 11 6 2 54 11
21176 123750 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 2 Cabrillo St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 3ft   5995617.0 2110854.0 37.775750686051005 -122.458666990683 (37.775750686051, -122.458666990683) 11 6 2 54 11
34329 135875 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1998 Jefferson St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 3ft   5999729.52384 2121257.63856 37.80455185454029 -122.445188929927 (37.8045518545403, -122.445188929927) 13 9 1 57 17
34330 135876 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1998 Jefferson St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 3ft   5999716.36995 2121255.20068 37.8045444099615 -122.44523427463899 (37.8045444099615, -122.445234274639) 13 9 1 57 17
34331 135877 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1998 Jefferson St 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 1ft   5999700.17509 2121253.84302 37.804539757774 -122.445290220574 (37.804539757774, -122.445290220574) 13 9 1 57 17
50109 178859 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 300x Winding Way 2 Median : Cutout 1 Tree 1 DPW 1     36 Width 0ft   6001566.6929 2086499.15435 37.7092181660671 -122.436342112826 (37.7092181660671, -122.436342112826) 9 7 6 28861 5
50111 178860 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 89 Belle Ave 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     15 Width 2ft   5991691.410619999 2086487.07285 37.708618932476504 -122.470471431226 (37.7086189324765, -122.470471431226) 9 8 4 64 24
50112 178861 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 475 Country Club Dr 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 4ft   5984726.53104 2094657.3779400003 37.7306472855285 -122.495144669717 (37.7306472855285, -122.495144669717) 1 8 4 64 35
50113 178862 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 475 Country Club Dr 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 4ft   5984727.35234 2094646.9730099998 37.730618764433295 -122.49514106342 (37.7306187644333, -122.49514106342) 1 8 4 64 35
86413 214360 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1549 15th Ave 7 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     6     5991543.46931 2104921.0361599997 37.759225392054404 -122.472325621024 (37.7592253920544, -122.472325621024) 1 8 4 56 12
86414 214361 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1549 15th Ave 6 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     5     5991542.4982199995 2104926.70561 37.759240902663706 -122.472329392783 (37.7592409026637, -122.472329392783) 1 8 4 56 12
86415 214362 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1549 15th Ave 5 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     23     5991544.573369999 2104931.26078 37.7592535300574 -122.472322548047 (37.7592535300574, -122.472322548047) 1 8 4 56 12
86416 214363 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1549 15th Ave 4 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     19     5991540.65145 2104932.9857 37.759258039248294 -122.472336237554 (37.7592580392483, -122.472336237554) 1 8 4 56 12
86417 214364 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1549 15th Ave 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     20     5991543.365259999 2104936.54185 37.7592679605603 -122.47232711121599 (37.7592679605603, -122.472327111216) 1 8 4 56 12
86418 214365 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1549 15th Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     13     5991540.76565 2104938.40333 37.7592729212382 -122.47233623753799 (37.7592729212382, -122.472336237538) 1 8 4 56 12
86419 214366 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1549 15th Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     18     5991544.33826 2104943.58363 37.7592873517403 -122.472324259478 (37.7592873517403, -122.472324259478) 1 8 4 56 12
86420 214367 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 711 Joost Ave 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     36     5997381.65215 2094970.27905 37.7322392132504 -122.451416767471 (37.7322392132504, -122.451416767471) 9 7 4 59 40
86421 214368 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 711 Joost Ave 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     44     5997395.8129 2094969.98374 37.7322392132673 -122.45136778950899 (37.7322392132673, -122.451367789509) 9 7 4 59 40
86422 214369 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 280 Vernon St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 4ft   5992489.929409999 2089773.12953 37.7176877931326 -122.46795052629801 (37.7176877931326, -122.467950526298) 9 8 6 64 24
86423 214370 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 280 Vernon St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 4ft   5992489.60576 2089794.03711 37.7177451815858 -122.4679531649 (37.7177451815858, -122.4679531649) 9 8 6 64 24
86424 214371 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 280 Vernon St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 4ft   5992489.1385699995 2089808.10753 37.7177837885668 -122.46795580262 (37.7177837885668, -122.46795580262) 9 8 6 64 24
110200 237956 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 225 Kingston St 1 : 14 Tree 1 Private 2     26 Width 4ft   6006307.0177 2098035.0416200003 37.7411614169794 -122.420777203522 (37.7411614169794, -122.420777203522) 2 7 7 28859 2
110201 237957 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 612 28th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 Width 2ft   6001964.12241 2099450.71378 37.7448027845374 -122.435894623662 (37.7448027845374, -122.435894623662) 2 7 5 63 22
110202 237958 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 4301 26th St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     10 Width 8ft   6001845.26134 2100568.224 37.747864450895 -122.43638558692301 (37.747864450895, -122.436385586923) 2 4 5 63 22
110203 237959 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 4301 26th St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 8ft   6001852.48827 2100568.36234 37.747865241384 -122.436360606479 (37.747865241384, -122.436360606479) 2 4 5 63 22
110205 237960 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 571 Duncan St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 10ft   6002836.92742 2099745.95433 37.745662988769205 -122.432897720155 (37.7456629887692, -122.432897720155) 2 7 5 63 22
110206 237961 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 177 Grand View Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     12     6000805.94873 2103333.15476 37.755397175063294 -122.44017771593398 (37.7553971750633, -122.440177715934) 2 4 5 28862 38
110207 237962 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 177 Grand View Ave 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     39     6000813.89685 2103347.44097 37.7554368540311 -122.44015125339199 (37.7554368540311, -122.440151253392) 2 4 5 28862 38
115095 24263 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 300X Winding Way 1 Median : Cutout 1 Tree 1 DPW 1     30 8   6001575.13411 2086503.1415799998 37.7092295937538 -122.43631322390199 (37.7092295937538, -122.436313223902) 9 7 6 28861 5
121009 249619 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 2398 Golden Gate Ave 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 7ft   5998061.53273 2111381.56318 37.7773394333005 -122.450248814341 (37.7773394333005, -122.450248814341) 15 6 2 54 16
121130 249739 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 2500 Broderick St 23 : 14 Tree 1 Private 2     12 Width 3ft   6000181.57325 2117191.47862 37.793413053123004 -122.443332338011 (37.793413053123, -122.443332338011) 13 9 1 57 27
128217 2756 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 130 Cabrillo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3X3   5995174.762569999 2110814.06482 37.7756156072533 -122.460193896477 (37.7756156072533, -122.460193896477) 11 6 2 54 11
148216 46368 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1839 Laguna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/08/2010 12:00:00 AM 4   Permit Number 53354 6004357.9818 2115208.0648 37.7882043731201 -122.42874019710199 (37.7882043731201, -122.428740197102) 13 9 11 29490 27
157833 55322 DPW Maintained 1 Prunus laurocerasus :: English laurel 87 1174 Goettingen St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/26/1972 12:00:00 AM 9   Permit Number 11252 6011343.895769999 2089330.65772 37.717543601242205 -122.40274938118601 (37.7175436012422, -122.402749381186) 10 7 8 309 39

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 21.678ms · Data source: data.sfgov.org