Street_Tree_List

Data source: data.sfgov.org

19 rows where SiteOrder = 3 and qCaretaker = 10

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, qSiteInfo, qCareAssistant, PlantDate, PlotSize, PermitNotes

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1905 251810 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 3 Unaccepted Street : Cutout 20 Tree 1 DPW for City Agency 10 Rec/Park 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
2535 246841 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 3 : 4 Tree 1 DPW for City Agency 10     14 Width 3ft   6001195.01805 2109899.62825 37.7734492368388 -122.439302846449 (37.7734492368388, -122.439302846449)
6064 98727 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 360 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     12 3x3   6006176.94483 2111455.11485 37.7780024719703 -122.422180149508 (37.7780024719703, -122.422180149508)
8408 103664 Undocumented 2 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 Significant Tree 6 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
46479 49665 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000243.34961 2120687.49551 37.8030157099616 -122.443369816371 (37.8030157099616, -122.443369816371)
62496 103654 Significant Tree 6 Tree(s) :: 17 307X Octavia St 3 Front Yard : Yard 7 Tree 1 DPW for City Agency 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
72352 98801 DPW Maintained 3 Ginkgo biloba :: Maidenhair Tree 44 950@Washington Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010237.16405 2117207.30409 37.794024789059996 -122.408540211182 (37.79402478906, -122.408540211182)
82784 95034 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 3224 Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
92640 109986 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 501X Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 DPW 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
94914 99004 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
95213 113810 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4101x 25TH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
95919 113866 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
97025 81841 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1299X Larkin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
107894 111381 Undocumented 2 Pinus radiata :: Monterey Pine 3 301x OCEAN AVE 3 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10 MTA 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
108530 110402 Undocumented 2 Juniperus chinensis :: Juniper 19 419X 18TH AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 MTA 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
115629 113707 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2801x CLEMENT ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
123900 98997 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
143072 97216 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300X Claremont Blvd 3 Back Yard : Cutout 16 Tree 1 DPW for City Agency 10           5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)

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