Street_Tree_List

Data source: data.sfgov.org

884 rows where qSpecies = 100 sorted by qLegalStatus

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PermitNotes

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
724 25734 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 16 10   6013899.49111 2118360.1858599996 37.7973947538281 -122.395948920127 (37.7973947538281, -122.395948920127)
1312 25735 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 16 10   6013816.07307 2118422.78251 37.7975619881486 -122.396241959692 (37.7975619881486, -122.396241959692)
1379 25668 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6014174.0749699995 2117868.41683 37.796059744425996 -122.394964320767 (37.796059744426, -122.394964320767)
2027 25628 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650 The Embarcadero 1 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 4X4   6014034.02503 2117986.25531 37.796375512586 -122.39545718430401 (37.796375512586, -122.395457184304)
4067 25799 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1300X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6012220.09673 2120843.1378 37.8041187644177 -122.401934728525 (37.8041187644177, -122.401934728525)
5331 25671 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6014100.8579 2117974.29057 37.7963463772386 -122.395225088169 (37.7963463772386, -122.395225088169)
5467 27939 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 8 Median : Cutout 11 Tree 1 Port 9     36 4X4   6013788.66429 2118525.16075 37.7978415693921 -122.396343981507 (37.7978415693921, -122.396343981507)
5785 25798 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1100X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6012871.9305 2119823.23547 37.801354716114 -122.39960734420201 (37.801354716114, -122.399607344202)
5927 25672 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6014076.201780001 2118013.23421 37.796451936061295 -122.39531313361799 (37.7964519360613, -122.395313133618)
6093 26031 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 36 10   6014122.12078 2117941.0950599997 37.7962564126589 -122.39514918719999 (37.7962564126589, -122.3951491872)
6610 25631 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650 The Embarcadero 4 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 4X4   6014105.621619999 2117876.68788 37.7960786481665 -122.395201764263 (37.7960786481665, -122.395201764263)
6748 26030 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 36 10   6014150.34723 2117905.1373099997 37.796159250800294 -122.395048997307 (37.7961592508003, -122.395048997307)
7009 27938 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9     36 4X4   6013758.52527 2118508.2804400004 37.7977935429048 -122.396447087875 (37.7977935429048, -122.396447087875)
7108 25783 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6013938.98446 2118296.9177 37.7972232315271 -122.39580782638599 (37.7972232315271, -122.395807826386)
7340 25782 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 36 10   6013997.3565 2118221.08563 37.7970182616509 -122.395600527244 (37.7970182616509, -122.395600527244)
8064 25629 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650 The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 4X4   6014059.75449 2117949.14567 37.79627504929729 -122.39536555327801 (37.7962750492973, -122.395365553278)
8404 25630 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650 The Embarcadero 3 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 4X4   6014084.49775 2117912.38554 37.7961754907607 -122.395277359473 (37.7961754907607, -122.395277359473)
8788 27937 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9     36 4X4   6013847.17816 2118440.8928400003 37.797613445554205 -122.396135596873 (37.7976134455542, -122.396135596873)
8987 25784 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6013869.26975 2118339.24702 37.797335579338004 -122.396052026484 (37.797335579338, -122.396052026484)
9337 113319 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 VALENCIA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6005986.0 2109035.0 37.7713466487942 -122.42266867187 (37.7713466487942, -122.42266867187)
9471 18535 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 270 PROSPECT AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6006489.0 2098160.0 37.74151478014 -122.420156839009 (37.74151478014, -122.420156839009)
13733 29537 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2600X Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6015071.7012 2091079.6967 37.7225535544976 -122.38998606447299 (37.7225535544976, -122.389986064473)
14133 29536 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2600X Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6015127.6919 2091149.846 37.7227492757118 -122.38979741293699 (37.7227492757118, -122.389797412937)
14829 95065 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 4801 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6014916.5089 2095299.5463 37.7341318071091 -122.390817297505 (37.7341318071091, -122.390817297505)
17598 9369 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 276 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 2x2   6001136.50681 2098095.27018 37.7410340073111 -122.438659251142 (37.7410340073111, -122.438659251142)
19785 25785 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6013445.7547399 2119056.6213273997 37.7992817461076 -122.39756784649201 (37.7992817461076, -122.397567846492)
20932 5679 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1470 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/08/2003 12:00:00 AM 6 3x3   6005190.57812 2099817.1721900003 37.7459917521253 -122.424764205708 (37.7459917521253, -122.424764205708)
34895 67033 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 174 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/13/1992 12:00:00 AM 30 5x5 Permit Number 30405 5992451.37715 2114312.24159 37.7850636224737 -122.469869417746 (37.7850636224737, -122.469869417746)
37148 96681 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 375@32nd Ave 32nd Ave 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/28/2011 12:00:00 AM 25   Permit Number 768040 5985880.88078 2113443.18167 37.7822954478301 -122.49253691723301 (37.7822954478301, -122.492536917233)
44570 27941 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 699 The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
69372 25749 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1301X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
76348 27944 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 999 The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9     24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
77513 27958 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 307X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
77877 28025 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6014170.25601 2117873.24701 37.796072794607895 -122.39497787369301 (37.7960727946079, -122.394977873693)
78155 25795 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800X The Embarcadero 9 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6012764.87501 2119980.6770099998 37.80178104459689 -122.39998886869199 (37.8017810445969, -122.399988868692)
78230 27930 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 799 The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
78576 25731 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 501X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 16 10   6013387.7643744005 2119020.8269614 37.799180234142106 -122.39776600258999 (37.7991802341421, -122.39776600259)
78635 60467 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 152 MAJESTIC AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1982 12:00:00 AM     Permit Number 20060 5996883.0 2089135.0 37.716188348676894 -122.45271971026699 (37.7161883486769, -122.452719710267)
78636 28030 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 10 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6014322.16601 2117689.8700099997 37.795577730351205 -122.39443938464899 (37.7955777303512, -122.394439384649)
78875 27848 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015938.91901 2112416.43301 37.7811878161514 -122.388476823036 (37.7811878161514, -122.388476823036)
78913 25684 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 3X3   6015953.02501 2112484.79201 37.781376296324 -122.388432795571 (37.781376296324, -122.388432795571)
79708 27959 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 307X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
80037 86731 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2 Pico Ave   Front Yard : Cutout 8 Tree 1 Private 1         Permit Number 49705 5994102.9 2092171.9 37.724367252780496 -122.462549157922 (37.7243672527805, -122.462549157922)
80104 25796 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800X The Embarcadero 10 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6012816.959009999 2119901.25001 37.80156586089179 -122.399803052325 (37.8015658608918, -122.399803052325)
81176 27963 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1101X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
81297 28024 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6014145.300009999 2117911.2250099997 37.7961756855245 -122.39506688844999 (37.7961756855245, -122.39506688845)
81328 25745 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 801X The Embarcadero 10 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
81991 25679 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 350X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
82090 27775 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 299X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
82580 28021 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4x4   6014080.19501 2118017.56101 37.796464038519396 -122.39529961933201 (37.7964640385194, -122.395299619332)
83420 27948 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 999 The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
83890 27801 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
86291 25738 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 801X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
86502 25797 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800X The Embarcadero 11 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6012870.34401 2119824.4270099998 37.801357899362394 -122.399612917904 (37.8013578993624, -122.399612917904)
87101 96694 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 3132@32nd Ave Clement St 16 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
87172 26029 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 499X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 36 10   6013385.9217822 2119009.0450001 37.7991477810775 -122.397771551765 (37.7991477810775, -122.397771551765)
87650 27777 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 299X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
89592 25669 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6013579.1997782 2118911.837786 37.7988916345337 -122.397095919657 (37.7988916345337, -122.397095919657)
89841 25748 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1301X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
89908 27997 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 300 The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
90111 27847 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 8 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
91110 27949 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 999 The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
91142 28372 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 199X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
91779 26017 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 899X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
92133 27942 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 699 The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
92364 27782 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 399X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
92465 26024 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 899X The Embarcadero 8 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
92652 27780 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 399X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
92971 28023 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4x4   6014119.25801 2117944.86201 37.7962665966149 -122.395159357042 (37.7962665966149, -122.395159357042)
92998 25682 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 350X The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
93392 26026 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 599X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 36 4X4   6012976.7050292995 2119636.8551197 37.8008488002257 -122.399231684673 (37.8008488002257, -122.399231684673)
93856 27960 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 307X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
94589 25673 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6013579.1997782 2118911.837786 37.7988916345337 -122.397095919657 (37.7988916345337, -122.397095919657)
94674 27870 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800 The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   01/31/2001 12:00:00 AM 24 4X4   6015155.50001 2116672.0830099997 37.79282941355329 -122.391484690649 (37.7928294135533, -122.391484690649)
94898 28032 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 12 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6014349.29301 2117643.21201 37.7954511263865 -122.394342251353 (37.7954511263865, -122.394342251353)
95406 25670 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6013579.1997782 2118911.837786 37.7988916345337 -122.397095919657 (37.7988916345337, -122.397095919657)
95434 27933 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 799 The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
96124 27767 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 299X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   12/10/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
96132 25786 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6013445.7547399 2119056.6213273997 37.7992817461076 -122.39756784649201 (37.7992817461076, -122.397567846492)
98209 25737 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 801X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
98325 27947 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 999 The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
99547 27845 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
100132 27778 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 299X The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
100729 27843 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
101121 27717 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 307X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   09/11/2000 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
101160 25742 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 801X The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
101187 5485 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 700X Dolores St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     100 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
101242 27788 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 199X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
101776 25752 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1301X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
102648 28027 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6014263.57201 2117754.9750099997 37.795753235969 -122.394646693031 (37.795753235969, -122.394646693031)
103442 96695 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 3132@32nd Ave Clement St 17 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
103830 27697 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1100X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9     36 10   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
104366 28002 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 300 The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
104388 28031 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 11 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6014334.10201 2117669.25401 37.7955217871698 -122.394396639485 (37.7955217871698, -122.394396639485)
104498 25741 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 801X The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
104738 25646 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 550X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
105106 25746 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1101X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
105556 27842 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
105677 27827 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
106008 28003 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 300 The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)

Next page

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 552.281ms · Data source: data.sfgov.org