Street_Tree_List

Data source: data.sfgov.org

39 rows where qSpecies = 351

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
26604 61079 Permitted Site 1 Nerium oleander :: Oleander 351 2605 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/17/1983 12:00:00 AM 4   Permit Number 20916 5999614.0204 2113612.0437 37.7835524809627 -122.445038661991 (37.7835524809627, -122.445038661991)
31473 131774 Undocumented 2 Nerium oleander :: Oleander 351 1920 Beach St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6000970.69286 2121018.51466 37.80396605054771 -122.440876596189 (37.8039660505477, -122.440876596189)
31875 232428 Undocumented 2 Nerium oleander :: Oleander 351 3590 21st St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004408.04732 2103685.00061 37.756567678684 -122.427745630074 (37.756567678684, -122.427745630074)
32043 139851 Undocumented 2 Nerium oleander :: Oleander 351 745 GOUGH ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6005737.8288 2112306.3675 37.780315026191 -122.423759752344 (37.780315026191, -122.423759752344)
46473 194106 Undocumented 2 Nerium oleander :: Oleander 351 535 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6014415.94841 2104620.80812 37.7596982456973 -122.39319993362601 (37.7596982456973, -122.393199933626)
47851 232425 Undocumented 2 Nerium oleander :: Oleander 351 3590 21st St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004459.056530001 2103683.49614 37.756566433101 -122.427569114725 (37.756566433101, -122.427569114725)
49006 232421 Undocumented 2 Nerium oleander :: Oleander 351 4412 23rd St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6000516.95294 2102297.95962 37.7525383228891 -122.441102882707 (37.7525383228891, -122.441102882707)
53996 232420 Undocumented 2 Nerium oleander :: Oleander 351 4443 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6001073.94489 2101115.72493 37.7493239003969 -122.43909199051001 (37.7493239003969, -122.43909199051)
57378 187519 Undocumented 2 Nerium oleander :: Oleander 351 228 Lauren Ct 1 : 4 Tree 1 Private 1     2 Width 1ft   6012451.9483900005 2088119.4639299999 37.7142797106237 -122.39883436792401 (37.7142797106237, -122.398834367924)
61271 118195 Undocumented 2 Nerium oleander :: Oleander 351 858 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5985129.694569999 2110010.45788 37.7728262247758 -122.494882469642 (37.7728262247758, -122.494882469642)
63111 139856 Undocumented 2 Nerium oleander :: Oleander 351 715 GOUGH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6005763.0211 2112117.0353 37.7797965883541 -122.42365913508002 (37.7797965883541, -122.42365913508)
63945 194105 Undocumented 2 Nerium oleander :: Oleander 351 545 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6014417.7827 2104595.3243400003 37.759628374655705 -122.393191806467 (37.7596283746557, -122.393191806467)
64933 232422 Undocumented 2 Nerium oleander :: Oleander 351 4412 23rd St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6000503.77394 2102296.8541099997 37.7525345367475 -122.441148378505 (37.7525345367475, -122.441148378505)
71893 194108 Undocumented 2 Nerium oleander :: Oleander 351 368 Texas St 1 : 4 Tree 1 Private 1     10 Width 3ft   6013743.33639 2105379.84222 37.7617449983419 -122.39557936170701 (37.7617449983419, -122.395579361707)
72410 131770 Undocumented 2 Nerium oleander :: Oleander 351 3161 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6002794.72228 2119491.9933 37.7998783368826 -122.434455220044 (37.7998783368826, -122.434455220044)
74129 232426 Undocumented 2 Nerium oleander :: Oleander 351 3590 21st St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004444.4891 2103684.24986 37.7565676786584 -122.427619547826 (37.7565676786584, -122.427619547826)
76872 118194 Undocumented 2 Nerium oleander :: Oleander 351 858 35th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5985130.26203 2110017.353 37.772845190029294 -122.494881015244 (37.7728451900293, -122.494881015244)
98153 114309 Undocumented 2 Nerium oleander :: Oleander 351 595 ELLIS ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008020.0 2113749.0 37.7844047125189 -122.415966831143 (37.7844047125189, -122.415966831143)
103435 92432 Permitted Site 1 Nerium oleander :: Oleander 351 534 Natoma St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52822 6010140.0 2111945.0 37.779570317083994 -122.40850503429701 (37.779570317084, -122.408505034297)
115277 9743 Permitted Site 1 Nerium oleander :: Oleander 351 715 Gough St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4   6005764.58972 2112125.4972099997 37.7798199112352 -122.423654310333 (37.7798199112352, -122.423654310333)
117731 9762 DPW Maintained 3 Nerium oleander :: Oleander 351 745 Gough St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005306.03378 2112177.46067 37.7799366952092 -122.425244357372 (37.7799366952092, -122.425244357372)
132503 194107 Undocumented 2 Nerium oleander :: Oleander 351 1447 20th St 1 : 4 Tree 1 Private 1     8 Width 1ft   6013582.3833099995 2104737.66515 37.7599727664564 -122.396091031903 (37.7599727664564, -122.396091031903)
146334 187534 Undocumented 2 Nerium oleander :: Oleander 351 96 Megan Dr 1 : 4 Tree 1 Private 1     1 Width 4ft   6012629.72487 2087860.6612599997 37.713578993957206 -122.39820175240601 (37.7135789939572, -122.398201752406)
146759 232424 Undocumented 2 Nerium oleander :: Oleander 351 3590 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004483.72015 2103686.16481 37.7565751556437 -122.427484009182 (37.7565751556437, -122.427484009182)
148295 187537 Undocumented 2 Nerium oleander :: Oleander 351 38 Megan Dr 1 : 4 Tree 1 Private 1     3 Width 1ft   6012599.06597 2088003.21705 37.7139687160564 -122.398317717311 (37.7139687160564, -122.398317717311)
148933 232427 Undocumented 2 Nerium oleander :: Oleander 351 3590 21st St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004428.1089 2103685.4949 37.7565701707031 -122.427676285143 (37.7565701707031, -122.427676285143)
153576 187539 Undocumented 2 Nerium oleander :: Oleander 351 18 Megan Dr 1 : 4 Tree 1 Private 1     3 Width 1ft   6012576.27604 2088054.60024 37.7141085345515 -122.398400091593 (37.7141085345515, -122.398400091593)
159562 194104 Undocumented 2 Nerium oleander :: Oleander 351 801 19th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6015143.45963 2105289.88586 37.761575778325295 -122.390730569759 (37.7615757783253, -122.390730569759)
159952 131771 Undocumented 2 Nerium oleander :: Oleander 351 3161 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6002800.51817 2119461.63557 37.7997953114739 -122.434432992409 (37.7997953114739, -122.434432992409)
161492 232419 Undocumented 2 Nerium oleander :: Oleander 351 629 York St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009868.938680001 2105140.1189099997 37.760870502078205 -122.408962494142 (37.7608705020782, -122.408962494142)
163637 187518 Undocumented 2 Nerium oleander :: Oleander 351 238 Lauren Ct 1 : 4 Tree 1 Private 1     2 Width 1ft   6012469.15492 2088126.39797 37.714299708845296 -122.398775381376 (37.7142997088453, -122.398775381376)
165430 177852 Undocumented 2 Nerium oleander :: Oleander 351 521 Lisbon St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 6ft   6002035.79624 2090425.6768200002 37.720026172549794 -122.43500145298 (37.7200261725498, -122.43500145298)
169117 131772 Undocumented 2 Nerium oleander :: Oleander 351 1920 Beach St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6001006.99118 2121024.03439 37.80398327346221 -122.440751379974 (37.8039832734622, -122.440751379974)
170363 232423 Undocumented 2 Nerium oleander :: Oleander 351 3590 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004499.74747 2103689.91865 37.7565863692953 -122.427428848357 (37.7565863692953, -122.427428848357)
179721 187540 Undocumented 2 Nerium oleander :: Oleander 351 2 Megan Dr 1 : 4 Tree 1 Private 1     3 Width 1ft   6012559.1048 2088097.8051099998 37.7142262099584 -122.39846247216002 (37.7142262099584, -122.39846247216)
180737 57113 Permitted Site 1 Nerium oleander :: Oleander 351 531 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/23/1974 12:00:00 AM 8   Permit Number 14383 6001543.07582 2090663.01106 37.7206498496809 -122.436721596137 (37.7206498496809, -122.436721596137)
184673 131773 Undocumented 2 Nerium oleander :: Oleander 351 1920 Beach St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6000974.22236 2121019.17087 37.803968053338 -122.44086442925699 (37.803968053338, -122.440864429257)
187166 131775 Undocumented 2 Nerium oleander :: Oleander 351 575 Ellis St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008072.74326 2113748.53186 37.784406392296795 -122.415784324012 (37.7844063922968, -122.415784324012)
187537 210578 Undocumented 2 Nerium oleander :: Oleander 351 1035 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 Width 3ft   6000825.310219999 2096196.7068900003 37.7358032894806 -122.43959918025601 (37.7358032894806, -122.439599180256)

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