home / trees

Street_Tree_List

Data source: data.sfgov.org

42 rows where qSpecies = 56

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, 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
249 100253 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1456 08th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/14/2012 12:00:00 AM   4x4 Permit Number 769196 5993711.5 2105567.7 37.761126200258296 -122.46487454888901 (37.7611262002583, -122.464874548889) 1 8 11 56 12
1907 102196 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 195 Eureka St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769771 6001469.4 2104733.4 37.7592796588141 -122.43798359789801 (37.7592796588141, -122.437983597898) 2 4 5 28862 3
1908 102197 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 195 Eureka St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769771 6001469.4 2104733.4 37.7592796588141 -122.43798359789801 (37.7592796588141, -122.437983597898) 2 4 5 28862 3
1909 102198 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 195 Eureka St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769771 6001469.4 2104733.4 37.7592796588141 -122.43798359789801 (37.7592796588141, -122.437983597898) 2 4 5 28862 3
1910 102199 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 195 Eureka St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769771 6001469.4 2104733.4 37.7592796588141 -122.43798359789801 (37.7592796588141, -122.437983597898) 2 4 5 28862 3
7548 108661 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 263 17th Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/30/2014 12:00:00 AM 3 3x3 Permit Number 773001 5990542.4091 2113638.3996200003 37.783102910833 -122.47642453468399 (37.783102910833, -122.476424534684) 11 6 2 55 26
7992 109091 Property Tree 5 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 4235 23rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876002 (37.7525900037408, -122.43731782876) 2 4 5 28862 22
9615 111018 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 90x DOWNEY ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/14/2015 12:00:00 AM   3x3   5998894.0 2107683.0 37.7672317271747 -122.447102814384 (37.7672317271747, -122.447102814384) 15 5 11 29492 9
15494 117337 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 715 Central Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/07/2016 12:00:00 AM 3   Permit Number 778487 5999567.1 2110966.9 37.7762869193631 -122.445010769125 (37.7762869193631, -122.445010769125) 15 5 11 29492 16
24659 12699 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1400 Lake St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/14/2002 12:00:00 AM 12 3X3   5991084.01432 2114808.42096 37.7863468599999 -122.47463623978001 (37.7863468599999, -122.47463623978) 11 6 1 54 33
37592 1393 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 30 Ardath Ct 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/20/2004 12:00:00 AM 3 3X4   6017322.644640099 2095453.2669696999 37.7346871027897 -122.382509138453 (37.7346871027897, -122.382509138453) 10 3 8 58 1
39017 1406 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 70 Ardath Ct 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/20/2004 12:00:00 AM 3 3X4   6017447.2721522 2095316.9187051998 37.73431960119021 -122.38206877273599 (37.7343196011902, -122.382068772736) 10 3 8 58 1
42413 14493 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 331 Masonic Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/20/2015 12:00:00 AM 3 3X3   5998922.83591 2111648.48667 37.7781215891061 -122.447288514652 (37.7781215891061, -122.447288514652) 15 6 2 54 16
44744 16582 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 810X Lake St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/1997 12:00:00 AM 6 3X3   5992991.92524 2114858.80829 37.7865955752076 -122.46803907898199 (37.7865955752076, -122.468039078982) 11 6 1 54 11
63631 19212 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 710X Duboce Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/31/1998 12:00:00 AM 3 3X3   6002366.0960506 2108316.0051988 37.7691675719148 -122.435138635645 (37.7691675719148, -122.435138635645) 15 5 5 29492 9
63642 19213 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 710X Duboce Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/09/1997 12:00:00 AM 3 3X3   6002366.0960506 2108316.0051988 37.7691675719148 -122.435138635645 (37.7691675719148, -122.435138635645) 15 5 5 29492 9
109088 23694 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 444 Washington St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   01/23/2004 12:00:00 AM 6 3X3   6012360.1719452 2117827.4460445 37.795846218583 -122.401237940514 (37.795846218583, -122.401237940514) 3 1 10 28860 4
120687 24922 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2199X Post St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   04/05/2003 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313) 13 6 11 29490 13
120688 24923 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2199X Post St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   02/22/1996 12:00:00 AM 6 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313) 13 6 11 29490 13
120690 24925 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2099X Post St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   02/09/1996 12:00:00 AM 6 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199) 13 6 11 29490 13
120691 24926 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2099X Post St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3     6 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199) 13 6 11 29490 13
127333 26643 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2199X Post St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   06/22/1998 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313) 13 6 11 29490 13
127334 26644 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2199X Post St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   06/22/1998 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313) 13 6 11 29490 13
127335 26645 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2199X Post St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   06/22/1998 12:00:00 AM 6 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313) 13 6 11 29490 13
127336 26647 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2199X Post St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   06/22/1998 12:00:00 AM 6 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313) 13 6 11 29490 13
127423 26750 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2099X Post St 15 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   04/05/2003 12:00:00 AM 3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199) 13 6 11 29490 13
127424 26751 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 2099X Post St 16 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   04/05/2003 12:00:00 AM 3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199) 13 6 11 29490 13
129372 28709 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1200X Evans Ave 16 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3X3   6017521.99801 2097204.46801 37.7395065622406 -122.381941669129 (37.7395065622406, -122.381941669129) 10 3 8 58 1
153920 5167 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 300 Divisadero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/13/1997 12:00:00 AM 6 3X3   6001869.08625 2109505.82986 37.7724063003864 -122.436942953857 (37.7724063003864, -122.436942953857) 15 5 11 29492 9
162552 59742 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 678 Castro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769762 6002373.84394228 2104261.94389375 37.7580365463466 -122.43482188178301 (37.7580365463466, -122.434821881783) 2 4 5 28862 3
167500 6438 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1100X Evans Ave 20 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   07/31/1998 12:00:00 AM 3 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173) 10 3 8 58 1
167543 6442 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1100X Evans Ave 24 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/20/1997 12:00:00 AM 6 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173) 10 3 8 58 1
167587 6446 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1100X Evans Ave 28 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/20/1997 12:00:00 AM 6 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173) 10 3 8 58 1
167745 6461 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1200X Evans Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/21/1997 12:00:00 AM 6 3X3   6017793.9540099995 2096998.1150099998 37.7389549728339 -122.38098701155 (37.7389549728339, -122.38098701155) 10 3 8 58 1
167777 6464 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1200X Evans Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   01/09/2004 12:00:00 AM 3 3X3   6017745.050009999 2097036.2840099998 37.739057077864 -122.38115875390801 (37.739057077864, -122.381158753908) 10 3 8 58 1
167860 6472 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1200X Evans Ave 12 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/04/2004 12:00:00 AM 3 3X3   6017584.02301 2097148.4070099997 37.7393560550275 -122.381723313495 (37.7393560550275, -122.381723313495) 10 3 8 58 1
167881 6474 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1200X Evans Ave 15 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/03/2004 12:00:00 AM 3 3X3   6017537.50401 2097191.3470099997 37.7394713908932 -122.38188714318599 (37.7394713908932, -122.381887143186) 10 3 8 58 1
167892 6475 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1200X Evans Ave 17 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/03/2004 12:00:00 AM 3 3X3   6017506.49201 2097214.01001 37.7395319063462 -122.381995946234 (37.7395319063462, -122.381995946234) 10 3 8 58 1
169612 6637 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 1499 Evans Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/15/2001 12:00:00 AM 6 3X3   6016187.3727289 2098094.9741145 37.7418779170755 -122.386618343631 (37.7418779170755, -122.386618343631) 10 3 8 58 1
169650 66405 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 443 Ellsworth St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/2009 12:00:00 AM 2 3x3 Permit Number 52584 6008076.49630227 2096789.35262597 37.7378406037529 -122.41457083366801 (37.7378406037529, -122.414570833668) 2 7 7 28859 2
174723 74997 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 465 Missouri St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/22/2010 12:00:00 AM   3x3 Permit Number 53589 6013543.86536349 2104925.00004946 37.7604850039816 -122.396237377585 (37.7604850039816, -122.396237377585) 10 3 8 28856 29
185007 92852 Significant Tree 4 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 3794 16th St 1 Front Yard : Yard 4 Tree 1 Private 2   12/14/2009 12:00:00 AM     Permit Number 53072 6001901.0 2106436.0 37.76397911869721 -122.436612788339 (37.7639791186972, -122.436612788339) 15 5 5 28862 3

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 23.137ms · Data source: data.sfgov.org