home / trees

Street_Tree_List

Data source: data.sfgov.org

46 rows where qSpecies = 2

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
2 10 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 97 12th St 4 Median : Cutout 1 Tree 1 DPW 1     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651) 8 2 9 28853 19
3321 103698 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 1306 Montgomery St 1 Median : 15 Tree 1 DPW 1     24     6011461.604719999 2119835.9957 37.8013110378213 -122.404488622371 (37.8013110378213, -122.404488622371) 3 1 10 308 23
3847 104332 Undocumented 3 Palm (unknown Genus) :: Palm Spp 2 1X Beaver St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002844.0 2106791.0 37.765007405875295 -122.43337660406901 (37.7650074058753, -122.433376604069) 15 5 5 28862 3
8757 11 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 97 12th St 5 Median : Cutout 1 Tree 1 DPW 1     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651) 8 2 9 28853 19
12795 114536 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 1485 Florida St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/23/2015 12:00:00 AM   3x3 Permit Number 776941 6009615.7 2100644.1 37.748511252235 -122.409521014405 (37.748511252235, -122.409521014405) 2 4 7 28859 19
12966 114712 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 601X Somerset St 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685) 10 3 7 309 28
12967 114713 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 601X Somerset St 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685) 10 3 7 309 28
12968 114714 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 601X Somerset St 3 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685) 10 3 7 309 28
12969 114715 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 601X Somerset St 4 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685) 10 3 7 309 28
12970 114716 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 601X Somerset St 5 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685) 10 3 7 309 28
12971 114717 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 601X Somerset St 6 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685) 10 3 7 309 28
12972 114718 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 601X Somerset St 7 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685) 10 3 7 309 28
12973 114719 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 601X Somerset St 8 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685) 10 3 7 309 28
18774 121373 Undocumented 3 Palm (unknown Genus) :: Palm Spp 2 99x Santa Marina St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006202.0 2097575.0 37.73989232614821 -122.421107660096 (37.7398923261482, -122.421107660096) 2 7 7 28859 2
18775 121374 Undocumented 3 Palm (unknown Genus) :: Palm Spp 2 99x Santa Marina St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006202.0 2097575.0 37.73989232614821 -122.421107660096 (37.7398923261482, -122.421107660096) 2 7 7 28859 2
18776 121375 Undocumented 3 Palm (unknown Genus) :: Palm Spp 2 99x Santa Marina St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006202.0 2097575.0 37.73989232614821 -122.421107660096 (37.7398923261482, -122.421107660096) 2 7 7 28859 2
18777 121376 Undocumented 3 Palm (unknown Genus) :: Palm Spp 2 99x Santa Marina St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006202.0 2097575.0 37.73989232614821 -122.421107660096 (37.7398923261482, -122.421107660096) 2 7 7 28859 2
20189 122813 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 889 York St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2         6009956.83094511 2104043.07852524 37.757863199609794 -122.40858112241999 (37.7578631996098, -122.40858112242) 2 4 7 28859 19
44431 16287 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 700X Monterey Blvd 4 Median : Cutout 1 Tree 1 DPW 1   02/02/2003 12:00:00 AM 0 5   5997448.036427 2094744.2173306 37.7316223027997 -122.45117096626998 (37.7316223027997, -122.45117096627) 9 7 4 59 40
70388 198428 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 1560 22nd St 1 Front Yard : Yard 4 Tree 1 Private 2     3     6013411.47886 2103834.6299099997 37.7574837182091 -122.39661880803699 (37.7574837182091, -122.396618808037) 10 3 8 28856 29
70389 198429 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 1560 22nd St 2 Front Yard : Yard 4 Tree 1 Private 2     3     6013408.610280001 2103841.14201 37.7575014393701 -122.3966291853 (37.7575014393701, -122.3966291853) 10 3 8 28856 29
105772 233905 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 450 Florida St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3     6009177.10779 2106306.71252 37.7640349231894 -122.411437660415 (37.7640349231894, -122.411437660415) 8 4 7 28859 19
105773 233906 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 450 Florida St 11 Sidewalk: Property side : Yard 5 Tree 1 Private 2     13     6009180.25132 2106253.63038 37.7638893481264 -122.411423037456 (37.7638893481264, -122.411423037456) 8 4 7 28859 19
105774 233907 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 450 Florida St 12 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3     6009190.66745 2106248.17582 37.7638749553765 -122.411386625691 (37.7638749553765, -122.411386625691) 8 4 7 28859 19
105775 233908 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 450 Florida St 13 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4     6009186.786859999 2106242.26457 37.763858506786 -122.411399629895 (37.763858506786, -122.411399629895) 8 4 7 28859 19
105776 233909 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 450 Florida St 14 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3     6009192.34018 2106238.03277 37.7638471987064 -122.411380123589 (37.7638471987064, -122.411380123589) 8 4 7 28859 19
105778 233910 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 450 Florida St 20 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     5 Width 4ft   6009190.59946 2106060.78327 37.7633604145703 -122.41137362151699 (37.7633604145703, -122.411373621517) 8 4 7 28859 19
113273 240948 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 450 Florida St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     24     6009180.27377 2106318.53915 37.764067573978295 -122.411427545759 (37.7640675739783, -122.411427545759) 8 4 7 28859 19
123311 252828 Significant Tree 4 Palm (unknown Genus) :: Palm Spp 2 3852 17th St 7 Front Yard : Yard 4 Tree 1 Private 2           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
123312 252829 Significant Tree 4 Palm (unknown Genus) :: Palm Spp 2 3852 17th St 8 Front Yard : Yard 4 Tree 1 Private 2           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
124319 254285 Undocumented 3 Palm (unknown Genus) :: Palm Spp 2 298 Ward St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6011279.0 2089720.0 37.718609032350294 -122.403001067047 (37.7186090323503, -122.403001067047) 10 7 8 309 28
140371 39106 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 3380 26th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/03/2009 12:00:00 AM   3x3 Permit Number 52869 6007272.11335441 2100921.86164387 37.749142326181996 -122.41764480189501 (37.749142326182, -122.417644801895) 2 4 7 28859 19
144337 4278 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 4258 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 2X2   6002201.9710475 2100350.5784148 37.747287109692294 -122.435136538682 (37.7472871096923, -122.435136538682) 2 4 5 63 22
144348 4279 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 4262 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 2X2   6002186.2336 2100363.9378400003 37.7473228978664 -122.435191912932 (37.7473228978664, -122.435191912932) 2 4 5 63 22
152112 50000 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 1101X 19th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46740 6014343.0 2105248.0 37.761416325617496 -122.393496122336 (37.7614163256175, -122.393496122336) 10 3 8 28856 29
152113 50001 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 1101X 19th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46740 6014343.0 2105248.0 37.761416325617496 -122.393496122336 (37.7614163256175, -122.393496122336) 10 3 8 28856 29
152116 50005 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 400 Pennsylvania Ave 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46740 6014320.5085713 2105254.32227407 37.761432435497 -122.39357435392401 (37.761432435497, -122.393574353924) 10 3 8 28856 29
152117 50006 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 400 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/28/2004 12:00:00 AM 12 3x3 Permit Number 46740 6014320.5085713 2105254.32227407 37.761432435497 -122.39357435392401 (37.761432435497, -122.393574353924) 10 3 8 28856 29
160991 58273 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 211 Brighton Ave 1 Front Yard : Yard 4 Tree 1 Private 2   09/20/1978 12:00:00 AM     Permit Number 17285 5996205.3244984 2091294.13562794 37.722077972487504 -122.455218010255 (37.7220779724875, -122.455218010255) 9 8 4 28861 24
162444 59642 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 783 Page St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/16/1981 12:00:00 AM     Permit Number 19053 6002834.53649888 2109552.08345216 37.7725881276189 -122.433606678937 (37.7725881276189, -122.433606678937) 15 5 11 29492 9
166903 63802 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 77 Putnam St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/03/2009 12:00:00 AM   3x3 Permit Number 52071 6009185.15509201 2097023.23947975 37.7385450297946 -122.410754158421 (37.7385450297946, -122.410754158421) 10 7 7 28859 2
185941 93973 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 59@ Golden gate Ave Roselyn Ter 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2         Tree 1 on Golden gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487) 15 6 2 54 16
185942 93974 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 59@ Golden Gate Ave Roselyn Ter 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2         Tree 2 on Golden Gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487) 15 6 2 54 16
185943 93975 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 59@ Golden gate Ave Roselyn Ter 3 Sidewalk: Property side : Cutout 9 Tree 1 Private 2         Tree 3 on Golden Gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487) 15 6 2 54 16
186004 94066 Significant Tree 4 Palm (unknown Genus) :: Palm Spp 2 548 Page St   Front Yard : 12 Tree 1 Private 2   06/02/2010 12:00:00 AM     Permit Number 53460 6003937.0 2109751.0 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526) 7 9 11 29492 10
186928 95078 Permitted Site 2 Palm (unknown Genus) :: Palm Spp 2 1110 Mariposa St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013929.4 2106263.3 37.7641811276583 -122.394997717565 (37.7641811276583, -122.394997717565) 14 3 8 28856 29

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