Street_Tree_List

Data source: data.sfgov.org

21 rows where qSiteInfo = 9 and qSpecies = 88

✎ View and edit SQL

This data as json, CSV (advanced)

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

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 21 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
9719 9719 173651 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 80 Entrada Ct 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
26535 26535 177420 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 121 Cotter St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   6001985.26237 2093449.7289900002 37.728326668619296 -122.435392337892 (37.7283266686193, -122.435392337892)
29022 29022 208856 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 331 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   5999876.46994 2094937.06877 37.732290569037104 -122.44278926080901 (37.7322905690371, -122.442789260809)
30883 30883 119446 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 881 32nd Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   5986011.18097 2109924.94508 37.7726429911374 -122.49182705320801 (37.7726429911374, -122.491827053208)
32904 32904 130968 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 95 Heather Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     5997356.6821800005 2113906.91877 37.7842330344764 -122.45286943159799 (37.7842330344764, -122.452869431598)
39525 39525 208855 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 358 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5999047.687609999 2095262.2243 37.7331360864596 -122.445677914709 (37.7331360864596, -122.445677914709)
45725 45725 130982 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3601 Broderick St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5999659.44076 2120919.3234599996 37.8036189320344 -122.44540711714701 (37.8036189320344, -122.445407117147)
47863 47863 177393 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1657 Sunnydale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   6006855.18138 2087491.9955900002 37.7122433757141 -122.41813457086599 (37.7122433757141, -122.418134570866)
53993 53993 177425 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1764 Cayuga Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 8ft   5997936.35064 2088551.93116 37.7146476772225 -122.44903686276301 (37.7146476772225, -122.449036862763)
55251 55251 130983 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2200 Beach St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   5999604.2907300005 2120890.91469 37.8035377808009 -122.44559592174 (37.8035377808009, -122.44559592174)
61520 61520 130998 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2201 Leavenworth St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6007580.24685 2119942.9983 37.8013871663302 -122.41792745790899 (37.8013871663302, -122.417927457909)
65862 65862 130969 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 95 Heather Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     5997355.4901 2113891.63765 37.7841910082488 -122.452872452398 (37.7841910082488, -122.452872452398)
98773 98773 106368 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 426 Country Club Dr   Sidewalk: Property side : Yard 9 Tree 1 Private 1   04/23/2014 12:00:00 AM     Permit Number 770073 5984817.1 2094918.3 37.731369010287 -122.494850794258 (37.731369010287, -122.494850794258)
131019 131019 177392 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1654 Sunnydale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   6006773.14965 2087593.0806 37.7125163163365 -122.41842526053101 (37.7125163163365, -122.418425260531)
138917 138917 98077 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 731 Duboce Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6001992.2 2108216.2 37.768872292925295 -122.436424775079 (37.7688722929253, -122.436424775079)
157255 157255 230354 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 531 30th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   6003165.5903900005 2098301.47872 37.7417154299181 -122.431658143201 (37.7417154299181, -122.431658143201)
160542 160542 130984 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2200 Beach St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   5999592.955130001 2120888.49408 37.803530487293 -122.445634974783 (37.803530487293, -122.445634974783)
161788 161788 130997 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2201 Leavenworth St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6007578.93915 2119952.7888599997 37.8014139751467 -122.417932677574 (37.8014139751467, -122.417932677574)
161888 161888 217796 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 21 Sloat Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   5991264.945169999 2095927.55542 37.7345154980788 -122.472633170284 (37.7345154980788, -122.472633170284)
181142 181142 208857 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1 Gennessee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5997408.7613699995 2093610.5667299998 37.7285073190505 -122.451225020336 (37.7285073190505, -122.451225020336)
181254 181254 208834 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1669 18th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5990551.61783 2104055.61326 37.756791716882404 -122.47569268998699 (37.7567917168824, -122.475692689987)

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