Street_Tree_List

Data source: data.sfgov.org

12 rows where qLegalStatus = 3 and qSpecies = 72

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus ✖

  • DPW Maintained · 12 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2707 2707 14854 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1357 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/21/1992 12:00:00 AM 6 3x3   6002671.377 2111611.0853 37.7782323757584 -122.43431829621201 (37.7782323757584, -122.434318296212)
6012 6012 27414 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2300 Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2     12 9   6005892.4011 2118361.12861 37.7969486190501 -122.42365562852801 (37.7969486190501, -122.423655628528)
6567 6567 18905 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2602 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6002286.89222 2115779.97328 37.789657253131 -122.435946744753 (37.789657253131, -122.435946744753)
6873 6873 23463 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2300 Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     12 9   6005896.8378 2118341.60488 37.7968952622641 -122.423638887645 (37.7968952622641, -122.423638887645)
8282 8282 27415 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2300 Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2     12 9   6005889.8891 2118381.22689 37.7970036620469 -122.423665750374 (37.7970036620469, -122.423665750374)
15860 15860 26103 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1557 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/22/1988 12:00:00 AM 12 3x3   6015264.4135 2095277.0122 37.734089230154204 -122.38961289841002 (37.7340892301542, -122.38961289841)
17124 17124 29888 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1126 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3x3   6005721.57126 2102405.52669 37.7531287556897 -122.42311204680901 (37.7531287556897, -122.423112046809)
38489 38489 214330 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 12 Median : Yard 3 Tree 1 DPW 2     10 Width 9ft   5995527.4625 2099368.48178 37.7442092481691 -122.458145280077 (37.7442092481691, -122.458145280077)
51364 51364 214329 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 11 Median : Yard 3 Tree 1 DPW 2     11 Width 9ft   5995487.46893 2099377.84768 37.744232666505106 -122.45828424602301 (37.7442326665051, -122.458284246023)
137327 137327 214332 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 18 Median : Yard 3 Tree 1 DPW 2     9 Width 9ft   5995718.21124 2099321.8453599997 37.7440921546362 -122.457482343055 (37.7440921546362, -122.457482343055)
153868 153868 214322 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 350x Kensington Way 2 Median : Cutout 11 Tree 1 DPW 2     12 Width 6ft   5994251.85903 2099042.92229 37.7432419652355 -122.462532396964 (37.7432419652355, -122.462532396964)
174532 174532 214331 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 13 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995540.56521 2099364.9270200003 37.7442002405496 -122.458099716827 (37.7442002405496, -122.458099716827)

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