Street_Tree_List

Data source: data.sfgov.org

15 rows where PlotSize = "Width 4ft", qSiteInfo = 2 and qSpecies = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, PlantDate, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2383 2383 201821 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
2387 2387 201822 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
2408 2408 201820 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
2417 2417 201819 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
4096 4096 181028 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Rolph St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.4676599998 37.715132307492794 -122.44007027934201 (37.7151323074928, -122.440070279342)
4113 4113 181027 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.2481099998 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188)
4220 4220 181020 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 183 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.9301099998 37.714476492181895 -122.438602919392 (37.7144764921819, -122.438602919392)
4227 4227 181017 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 197 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.43836906510201 (37.7143700996689, -122.438369065102)
4245 4245 181019 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 191 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.714429647391896 -122.438501549606 (37.7144296473919, -122.438501549606)
4257 4257 181010 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 215 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.9005900002 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327)
4273 4273 181018 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 197 Rolph St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.0469099998 37.714394713229105 -122.43841724088999 (37.7143947132291, -122.43841724089)
4306 4306 181011 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 207 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.315830001 2088326.0025400002 37.714208969932706 -122.438012171843 (37.7142089699327, -122.438012171843)
50907 50907 207039 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 270 Magellan Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994635.03268 2100302.9111 37.7467236374953 -122.461298810415 (37.7467236374953, -122.461298810415)
56930 56930 207038 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 270 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994641.46146 2100307.8933900003 37.7467376875983 -122.461276941602 (37.7467376875983, -122.461276941602)
134809 134809 227089 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6009456.29094 2095946.4902299999 37.735603707435395 -122.409740715285 (37.7356037074354, -122.409740715285)

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