home / trees

Street_Tree_List

Data source: data.sfgov.org

36 rows where qSpecies = 95

View and edit SQL

Suggested facets: qLegalStatus, qAddress, 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
737 100826 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 3661 Buchanan St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003080.13774 2120956.29501 37.803915123748105 -122.433572281852 (37.8039151237481, -122.433572281852) 13 9 1 57 17
738 100827 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 3661 Buchanan St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003081.8479 2120946.98391 37.8038896549426 -122.433565697914 (37.8038896549426, -122.433565697914) 13 9 1 57 17
739 100828 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1601X North Point St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003033.04227 2120970.8985599997 37.8039525490422 -122.433736302911 (37.8039525490422, -122.433736302911) 13 9 1 57 17
742 100830 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1601X North Point St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003038.84698 2120959.7606900004 37.8039222967503 -122.433715418836 (37.8039222967503, -122.433715418836) 13 9 1 57 17
873 101014 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 122 Clayton St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/26/2012 12:00:00 AM 12 3x3 Permit Number 769370 5998315.7 2110195.2 37.7740965282123 -122.44928407650801 (37.7740965282123, -122.449284076508) 15 5 11 29492 16
6989 108096 Significant Tree 4 Ficus rubiginosa :: Port Jackson Fig 95 3370 Washington St 1 Front Yard : Cutout 10 Tree 1 Private 2     17   Permit Number 773610 5998674.83986 2115933.37372 37.789872594881295 -122.44845507873801 (37.7898725948813, -122.448455078738) 13 6 1 54 31
26640 128786 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 2616 Union St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     18 Width 2ft   6000449.78816 2118234.95075 37.7962934440368 -122.44247924832099 (37.7962934440368, -122.442479248321) 13 9 1 57 17
26641 128787 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 2616 Union St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14 Width 2ft   6000444.41051 2118233.9638400003 37.79629042771771 -122.44249778516199 (37.7962904277177, -122.442497785162) 13 9 1 57 17
26642 128788 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 2616 Union St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14 Width 2ft   6000439.82382 2118233.11772 37.7962878430531 -122.442513595237 (37.7962878430531, -122.442513595237) 13 9 1 57 17
26643 128789 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 2616 Union St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     16 Width 2ft   6000435.240119999 2118232.42844 37.796285689198 -122.442529406231 (37.796285689198, -122.442529406231) 13 9 1 57 17
26645 128790 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 2616 Union St 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2     18 Width 2ft   6000429.22949 2118231.29811 37.796282242996796 -122.442550123001 (37.7962822429968, -122.442550123001) 13 9 1 57 17
26646 128791 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 3250 Pacific Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     25 Width 4ft   5998512.05475 2116571.7004299997 37.7916159621469 -122.44906430110001 (37.7916159621469, -122.4490643011) 11 6 1 54 30
26647 128792 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 3641 Jackson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 Width 3ft   5996821.020959999 2115954.80185 37.7898252644679 -122.454870635381 (37.7898252644679, -122.454870635381) 11 6 1 54 31
26648 128793 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 215 Marina Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 2ft   6002431.76066 2121815.30127 37.806236918750294 -122.435877528418 (37.8062369187503, -122.435877528418) 13 9 1 57 17
26649 128794 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 215 Marina Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 3ft   6002443.63505 2121804.63249 37.806208299634 -122.435835671285 (37.806208299634, -122.435835671285) 13 9 1 57 17
26650 128795 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 3661 Buchanan St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 3ft   6003083.04444 2120936.9507299997 37.8038621743528 -122.433560839757 (37.8038621743528, -122.433560839757) 13 9 1 57 17
26651 128796 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1601 North Point St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 3ft   6003043.93821 2120973.56715 37.80396049455071 -122.43369878768299 (37.8039604945507, -122.433698787683) 13 9 1 57 17
26652 128797 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1601 North Point St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 3ft   6003054.0198 2120974.69416 37.8039641610666 -122.433663980313 (37.8039641610666, -122.433663980313) 13 9 1 57 17
36502 138304 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1899 FILLMORE ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 0ft   6002975.0751 2114699.5712 37.7867298142136 -122.43348846341001 (37.7867298142136, -122.43348846341) 13 9 11 29490 27
36503 138305 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1899 FILLMORE ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 Width 0ft   6002976.5618 2114681.7311 37.78668091417529 -122.433482044409 (37.7866809141753, -122.433482044409) 13 9 11 29490 27
36581 138376 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1805 FILLMORE ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 0ft   6002992.9152 2114550.4079 37.786321261782 -122.43341607773998 (37.786321261782, -122.43341607774) 13 9 11 29490 27
36582 138377 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1805 FILLMORE ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 Width 0ft   6002995.392999999 2114531.5766 37.7862696963806 -122.433406159019 (37.7862696963806, -122.433406159019) 13 9 11 29490 27
36583 138378 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1805 FILLMORE ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/07/2019 09:40:00 AM 3 Width 0ft   6002996.8797 2114513.7365 37.7862207963337 -122.43339974011299 (37.7862207963337, -122.433399740113) 13 9 11 29490 27
63683 192169 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1501 22nd St 8 Front Yard : Yard 4 Tree 1 Private 2     4     6013427.99446 2103808.10107 37.7574117949334 -122.396559830485 (37.7574117949334, -122.396559830485) 10 3 8 28856 29
63685 192170 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1601 Kansas St 9 : 14 Tree 1 Private 2     51 Width 7ft   6011813.79085 2100866.0430099997 37.749243580141204 -122.40193560806001 (37.7492435801412, -122.40193560806) 10 3 8 58 1
63686 192171 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1601 Kansas St 9 : 14 Tree 1 Private 2     51 Width 7ft   6011813.79085 2100866.0430099997 37.749243580141204 -122.40193560806001 (37.7492435801412, -122.40193560806) 10 3 8 58 1
63687 192172 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1601 Kansas St 9 : 14 Tree 1 Private 2     51 Width 7ft   6011813.79085 2100866.0430099997 37.749243580141204 -122.40193560806001 (37.7492435801412, -122.40193560806) 10 3 8 58 1
63688 192173 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1601 Kansas St 9 : 14 Tree 1 Private 2     51 Width 7ft   6011813.79085 2100866.0430099997 37.749243580141204 -122.40193560806001 (37.7492435801412, -122.40193560806) 10 3 8 58 1
96592 225377 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1353 Stevenson St 1 : 14 Tree 1 Private 2     11 Width 3ft   6006283.07566 2108788.03737 37.7706853045028 -122.42162352851801 (37.7706853045028, -122.421623528518) 8 2 9 28853 19
141867 40486 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 3659 Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/10/1980 12:00:00 AM 12 3x3 Permit Number 41565 6003084.56298 2120922.5668200003 37.803822766069395 -122.43355455619101 (37.8038227660694, -122.433554556191) 13 9 1 57 17
147616 458 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 760x 23rd Ave 24 Median : Cutout 1 Tree 1 DPW 1     12     5988831.51293 2110000.66067 37.7730153231025 -122.482076888223 (37.7730153231025, -122.482076888223) 11 6 2 55 26
148142 463 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 760x 23rd Ave 19 Median : Cutout 1 Tree 1 DPW 1     12 8-HOA   5988827.93614 2110070.28551 37.7732062855999 -122.482094362253 (37.7732062855999, -122.482094362253) 11 6 2 55 26
174123 7280 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1805 Fillmore St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 4X4   6002990.932999999 2114560.8146 37.786349723483895 -122.433423679579 (37.7863497234839, -122.433423679579) 13 9 11 29490 27
174127 7282 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1833 Fillmore St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 4X4   6002982.0129 2114634.653 37.7865519589269 -122.433459819388 (37.7865519589269, -122.433459819388) 13 9 11 29490 27
174129 7283 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1833 Fillmore St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 4X4   6002987.4641 2114608.3883 37.7864801519947 -122.433439081994 (37.7864801519947, -122.433439081994) 13 9 11 29490 27
174140 7285 DPW Maintained 1 Ficus rubiginosa :: Port Jackson Fig 95 1843 Fillmore St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 4X4   6002980.0307 2114661.9087 37.786626683704 -122.433468625779 (37.786626683704, -122.433468625779) 13 9 11 29490 27

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