home / trees

Street_Tree_List

Data source: data.sfgov.org

38 rows where qSpecies = 72

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, 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
387 100420 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1701X 09th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/17/2012 12:00:00 AM   3x4 Permit Number 769064 5993374.0 2103847.1 37.7563824151434 -122.465916782185 (37.7563824151434, -122.465916782185) 1 8 4 56 12
388 100421 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1701X 09th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/17/2012 12:00:00 AM   3x4 Permit Number 769064 5993374.0 2103847.1 37.7563824151434 -122.465916782185 (37.7563824151434, -122.465916782185) 1 8 4 56 12
389 100422 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1701X 09th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/17/2012 12:00:00 AM   3x4 Permit Number 769064 5993374.0 2103847.1 37.7563824151434 -122.465916782185 (37.7563824151434, -122.465916782185) 1 8 4 56 12
1765 102042 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 307 Moraga St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/13/2012 12:00:00 AM   3x3 Permit Number 769064 5993385.6 2103903.0 37.7565365712381 -122.465880727208 (37.7565365712381, -122.465880727208) 1 8 4 56 12
5062 105726 Undocumented 3 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 428A PIERCE ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 4x4   6002769.7 2110121.3 37.7741473764159 -122.43387164824 (37.7741473764159, -122.43387164824) 15 5 11 29492 10
5070 105737 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 419 Pierce St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/2014 12:00:00 AM 2 4x4   6002669.0 2109966.0 37.773715246164606 -122.434208882327 (37.7737152461646, -122.434208882327) 15 5 11 29492 10
5076 105747 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 428A Pierce St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/2014 12:00:00 AM 2 4x4 Permit Number 771653 6002700.0 2110005.0 37.7738240899214 -122.434104437093 (37.7738240899214, -122.434104437093) 15 5 11 29492 10
5552 106359 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 276 Francisco St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 770436 6009994.6 2121304.9 37.805262192623 -122.40966886664499 (37.805262192623, -122.409668866645) 3 1 10 308 23
6315 107313 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1400X Grove St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/20/2014 12:00:00 AM   3x3 Permit Number 770271 6000871.66317 2110692.9632900003 37.775609128624 -122.440478284704 (37.775609128624, -122.440478284704) 15 5 11 29492 10
6316 107314 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1400X Grove St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/20/2014 12:00:00 AM   3x3 Permit Number 770271 6000871.66317 2110692.9632900003 37.775609128624 -122.440478284704 (37.775609128624, -122.440478284704) 15 5 11 29492 10
6317 107315 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1400X Grove St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/20/2014 12:00:00 AM   3x3 Permit Number 770271 6000871.66317 2110692.9632900003 37.775609128624 -122.440478284704 (37.775609128624, -122.440478284704) 15 5 11 29492 10
6318 107316 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1400X Grove St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/20/2014 12:00:00 AM   3x3 Permit Number 770271 6000871.66317 2110692.9632900003 37.775609128624 -122.440478284704 (37.775609128624, -122.440478284704) 15 5 11 29492 10
6319 107317 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1400X Grove St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/20/2014 12:00:00 AM   3x3 Permit Number 770271 6000871.66317 2110692.9632900003 37.775609128624 -122.440478284704 (37.775609128624, -122.440478284704) 15 5 11 29492 10
6320 107318 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1400X Grove St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/20/2014 12:00:00 AM   3x3 Permit Number 770271 6000871.66317 2110692.9632900003 37.775609128624 -122.440478284704 (37.775609128624, -122.440478284704) 15 5 11 29492 10
8662 109873 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 400 PIERCE ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/2014 12:00:00 AM 1 4x4   6002729.7 2109998.5 37.773807928081006 -122.434001235387 (37.773807928081, -122.434001235387) 15 5 11 29492 10
8664 109875 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 400 PIERCE ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/2014 12:00:00 AM 1 4x4   6002729.7 2109998.5 37.773807928081006 -122.434001235387 (37.773807928081, -122.434001235387) 15 5 11 29492 10
11312 112879 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 755 02nd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/26/2015 12:00:00 AM     Permit Number 772774 5995320.1 2110503.8 37.774772060652396 -122.459668664517 (37.7747720606524, -122.459668664517) 11 6 2 54 11
63599 19209 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 395X Jackson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   09/25/2014 02:29:00 PM 3 3.5x3. 5   6012205.797263901 2118092.2355744 37.7965646535307 -122.401790730678 (37.7965646535307, -122.401790730678) 3 1 10 28860 4
97330 22606 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 930 Gough St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/24/2014 12:00:00 AM 3 3X3 Permit Number 773338 6005716.49366 2112844.2148599997 37.7817906187885 -122.42387181652501 (37.7817906187885, -122.423871816525) 7 9 11 28852 41
114059 241673 Planning Code 138.1 required 8 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 21 Rosemont Pl 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/02/2018 12:00:00 AM 3 4x4 Permit Number 778206 6005133.3823 2108100.0759 37.768731432048895 -122.42555136881201 (37.7687314320489, -122.425551368812) 8 4 5 28853 19
126893 26186 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 538 Castro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   08/18/2015 12:00:00 AM 2 3X6 Permit Number 772904 6002328.19294 2105046.72262 37.7601887674112 -122.435035888908 (37.7601887674112, -122.435035888908) 2 4 5 28862 3
158781 562 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 2946 24th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/19/2016 07:44:00 AM 3 3x3   6009264.69318 2102193.2743900004 37.752745265894106 -122.410844191525 (37.7527452658941, -122.410844191525) 2 4 7 28859 19
165002 62051 DPW Maintained 1 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 276 Francisco St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/15/1985 12:00:00 AM 17 7x15 Permit Number 770436 6010004.5465 2121290.7324 37.8052238492822 -122.40963344479201 (37.8052238492822, -122.409633444792) 3 1 10 308 23
174861 75468 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 40 Lomita Ave 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/10/2013 12:00:00 AM     Permit Number 769934 5991382.48989166 2104778.11125906 37.758823639987796 -122.47287193809099 (37.7588236399878, -122.472871938091) 1 8 4 56 12
174874 75531 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 40 Lomita Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/10/2013 12:00:00 AM     Permit Number 769934 5991382.48989166 2104778.11125906 37.758823639987796 -122.47287193809099 (37.7588236399878, -122.472871938091) 1 8 4 56 12
174885 75595 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 40 Lomita Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/10/2013 12:00:00 AM     Permit Number 769934 5991382.48989166 2104778.11125906 37.758823639987796 -122.47287193809099 (37.7588236399878, -122.472871938091) 1 8 4 56 12
174898 75656 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 40 Lomita Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/10/2013 12:00:00 AM     Permit Number 769934 5991382.48989166 2104778.11125906 37.758823639987796 -122.47287193809099 (37.7588236399878, -122.472871938091) 1 8 4 56 12
174916 75714 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 40 Lomita Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/10/2013 12:00:00 AM     Permit Number 769934 5991382.48989166 2104778.11125906 37.758823639987796 -122.47287193809099 (37.7588236399878, -122.472871938091) 1 8 4 56 12
174929 75767 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 40 Lomita Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/10/2013 12:00:00 AM     Permit Number 769934 5991382.48989166 2104778.11125906 37.758823639987796 -122.47287193809099 (37.7588236399878, -122.472871938091) 1 8 4 56 12
179801 86743 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 2690 Broadway 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
179802 86744 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 2690 Broadway 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
179803 86745 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 2690 Broadway 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
180489 87568 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1590X Vallejo St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/07/2012 12:00:00 AM 24 3x3 Permit Number 768864 6006002.5 2118362.3 37.7969580495509 -122.423274742897 (37.7969580495509, -122.423274742897) 13 9 10 28858 32
185886 93912 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 2690 Broadway 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
187951 96086 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 2120 Washington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/24/2011 12:00:00 AM     Permit Number 767147 6004557.0 2116744.0 37.7924329253555 -122.42816113061501 (37.7924329253555, -122.428161130615) 13 9 1 28858 27
191198 99617 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1590X Vallejo St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/07/2012 12:00:00 AM 24 3x3 Permit Number 768864 6006002.5 2118362.3 37.7969580495509 -122.423274742897 (37.7969580495509, -122.423274742897) 13 9 10 28858 32
191199 99618 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1590X Vallejo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/07/2012 12:00:00 AM 24 3x3 Permit Number 768864 6006002.5 2118362.3 37.7969580495509 -122.423274742897 (37.7969580495509, -122.423274742897) 13 9 10 28858 32
191200 99619 Permitted Site 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 72 1590X Vallejo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/07/2012 12:00:00 AM 24 3x3 Permit Number 768864 6006002.5 2118362.3 37.7969580495509 -122.423274742897 (37.7969580495509, -122.423274742897) 13 9 10 28858 32

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