home / trees

Street_Tree_List

Data source: data.sfgov.org

39 rows where qSpecies = 97

View and edit SQL

Suggested facets: qLegalStatus, 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
753 100844 Undocumented 3 Araucaria columnaris :: Coral reef araucaria 97 1 Estero Ave 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
12107 113754 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 129 Lisbon St 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2     7 3x3   6003441.615680001 2092643.9430799999 37.726196762848794 -122.430300196616 (37.7261967628488, -122.430300196616) 9 7 6 28861 5
16451 118426 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 5400 Anza St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 4ft   5981892.75436 2111697.28192 37.777267736458704 -122.506204325215 (37.7772677364587, -122.506204325215) 11 6 2 55 26
21975 124518 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 2600 McAllister St 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     3 Width 3ft   5996667.884380001 2110828.33109 37.7757405490967 -122.45502988344101 (37.7757405490967, -122.455029883441) 11 6 2 54 16
23114 125569 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 2843 Larkin St 14 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 5ft   6006460.46289 2121010.84559 37.8042561187834 -122.421878311841 (37.8042561187834, -122.421878311841) 5 9 1 28858 32
23116 125570 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 12 Hastings Ter 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4     6007279.62627 2119274.74098 37.799535376818795 -122.41892031844499 (37.7995353768188, -122.418920318445) 5 1 1 28858 32
23117 125571 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 12 Hastings Ter 9 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5     6007261.69375 2119272.4360700003 37.799528038350395 -122.418982207971 (37.7995280383504, -122.418982207971) 5 1 1 28858 32
23118 125572 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1120 Greenwich St 4 Front Yard : Yard 4 Tree 1 Private 2     11     6007488.07621 2119895.66738 37.8012520198356 -122.418243052479 (37.8012520198356, -122.418243052479) 5 1 1 28858 32
23119 125573 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1132 Greenwich St 1 Front Yard : Yard 4 Tree 1 Private 2     20     6007454.382180001 2119897.9971 37.8012565200205 -122.418359814172 (37.8012565200205, -122.418359814172) 5 1 1 28858 32
23120 125574 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 315 Beach St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 6ft   6008427.90807 2122059.2905200003 37.8072456415422 -122.415144050765 (37.8072456415422, -122.415144050765) 3 1 10 308 23
46240 175233 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 36 Rome St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 6ft   5999259.77065 2089432.8970700002 37.717142210424 -122.444525876885 (37.717142210424, -122.444525876885) 9 7 6 28861 25
46241 175234 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 231 Delano Ave 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 8ft   6000062.85031 2092281.5628099998 37.7250097881633 -122.44195437071001 (37.7250097881633, -122.44195437071) 9 7 6 28861 25
46242 175235 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 43 Athens St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     20     6005247.80473 2092998.47729 37.727272378110705 -122.42408149526301 (37.7272723781107, -122.424081495263) 9 7 6 28861 5
46243 175236 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 226 Pioche St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 2ft   6006139.03922 2093414.22187 37.7284642010627 -122.42103000293999 (37.7284642010627, -122.42103000294) 9 7 7 309 5
46244 175237 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 569 Sweeny St 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 2ft   6008064.597490001 2094285.18998 37.7309640492513 -122.414434832812 (37.7309640492513, -122.414434832812) 9 3 7 309 28
56654 18549 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1700X Quesada Ave 4 Median : Cutout 1 Tree 1 DPW 1     30 19   6014666.78443 2095063.48399 37.733469769099706 -122.39166418116301 (37.7334697690997, -122.391664181163) 10 3 8 58 1
58760 187580 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 297 Elliot St 1 Side Yard : Yard 27 Tree 1 Private 2     5     6008925.29742 2088423.47753 37.7149173344326 -122.411045360877 (37.7149173344326, -122.411045360877) 9 7 8 309 39
58761 187581 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 297 Elliot St 2 Side Yard : Yard 27 Tree 1 Private 2     4     6008926.43225 2088428.3515400002 37.7149307810954 -122.411041782475 (37.7149307810954, -122.411041782475) 9 7 8 309 39
59195 187999 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 2300 18th St 6 Front Yard : Yard 4 Tree 1 Private 2     1     6010894.819759999 2105549.3478099997 37.7620515655611 -122.40544322755 (37.7620515655611, -122.40544322755) 8 3 8 28856 29
59198 188000 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 2300 18th St 7 Front Yard : Yard 4 Tree 1 Private 2     2     6010884.88497 2105533.94268 37.7620087110478 -122.40547650333201 (37.7620087110478, -122.405476503332) 8 3 8 28856 29
59199 188001 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 900x Carolina St 21 Median : Yard 11 Tree 1 DPW 1     10     6012468.44405 2103516.87619 37.7565587070327 -122.399857908825 (37.7565587070327, -122.399857908825) 10 3 8 28856 29
59200 188002 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1 Jack Balestreri Way 9 Front Yard : Yard 4 Tree 1 Private 2     2     6012414.55011 2104744.40828 37.759926235526294 -122.40013050142001 (37.7599262355263, -122.40013050142) 10 3 8 28856 29
59201 188003 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1801 22nd St 1 : 14 Tree 1 Private 2     14 Width 4ft   6012518.996590001 2103742.8327900004 37.7571819525135 -122.399698943778 (37.7571819525135, -122.399698943778) 10 3 8 28856 29
59202 188004 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1414 De Haro St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8     6012268.57202 2101597.231 37.7512766352204 -122.400414309479 (37.7512766352204, -122.400414309479) 10 3 8 28856 29
59203 188005 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1700x Quesada Ave 36 Median : Yard 11 Tree 1 DPW 1     1     6014418.79198 2095243.03437 37.733949008825896 -122.39253412326799 (37.7339490088259, -122.392534123268) 10 3 8 58 1
76182 204756 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1977 16th Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 5ft   5991243.68284 2102007.63394 37.7512086006104 -122.473149945926 (37.7512086006104, -122.473149945926) 1 8 4 29491 12
76183 204757 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 301 Joost Ave 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 10ft   6000049.907930001 2094942.19372 37.7323145269931 -122.44219001556299 (37.7323145269931, -122.442190015563) 9 7 4 63 40
92970 222014 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1200 San Jose Ave 2 Front Yard : Yard 4 Tree 1 Private 2     2     6004280.12792 2096177.4617 37.7359464741465 -122.42765314738399 (37.7359464741465, -122.427653147384) 2 7 5 63 7
92971 222015 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1200 San Jose Ave 3 Front Yard : Yard 4 Tree 1 Private 2     2     6004279.486930001 2096174.9077299999 37.735939425264704 -122.427655181635 (37.7359394252647, -122.427655181635) 2 7 5 63 7
92972 222016 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 1155 York St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 4ft   6010034.97837 2102478.93544 37.753572788768395 -122.40820053994301 (37.7535727887684, -122.408200539943) 2 4 7 28859 19
92973 222017 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 78 Addison St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     11 Width 4ft   6002921.496280001 2096896.93509 37.7378450383028 -122.432401845685 (37.7378450383028, -122.432401845685) 2 7 5 63 7
92974 222018 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 26 Harry St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     13     6003391.09205 2097782.07632 37.7403020499999 -122.43084137533 (37.7403020499999, -122.43084137533) 2 7 5 63 7
118617 247025 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 550x Valley St 5 Median : Yard 11 Tree 1 DPW 1     13     6002368.139690001 2099161.55707 37.7440317705626 -122.434476939553 (37.7440317705626, -122.434476939553) 2 7 5 63 22
118728 247141 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 500 27th St 11 Front Yard : Yard 4 Tree 1 Private 2     3     6003162.24361 2100091.8574599996 37.7466312042731 -122.431797519264 (37.7466312042731, -122.431797519264) 2 7 5 63 22
119256 247641 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 351 Bradford St 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 4ft   6009481.78912 2096454.38247 37.7369996989807 -122.409688395396 (37.7369996989807, -122.409688395396) 10 7 7 28859 2
119885 248213 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 67 Fair Ave 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     13 Width 6ft   6006991.17569 2099459.70847 37.7451117709 -122.418512623363 (37.7451117709, -122.418512623363) 2 7 7 28859 2
121649 250214 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 300 Filbert St 3 Front Yard : Yard 4 Tree 1 Private 2     17 Width 0ft   6011356.85647 2120074.2009099997 37.8019592368004 -122.404867879958 (37.8019592368004, -122.404867879958) 3 1 10 308 23
150920 48880 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 508 (Revised) Missouri St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/19/2002 12:00:00 AM 3   Permit Number 46086 6013522.2483 2104632.20048 37.7596798374789 -122.396291619384 (37.7596798374789, -122.396291619384) 10 3 8 28856 29
171845 68467 DPW Maintained 1 Araucaria columnaris :: Coral reef araucaria 97 65 Badger St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/04/1993 12:00:00 AM 2   Permit Number 32329 6002400.383640001 2094417.82503 37.731008407413505 -122.43402642057801 (37.7310084074135, -122.434026420578) 9 7 5 28861 25

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