Street_Tree_List

Data source: data.sfgov.org

17 rows where qSiteInfo = 3 and qSpecies = 28

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Median : Yard · 17 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29933 29933 188870 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1300x De Haro St 30 Median : Yard 3 Tree 1 DPW 2     15     6012283.09076 2102020.40062 37.7524393767806 -122.40039382202299 (37.7524393767806, -122.400393822023)
30631 30631 205755 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Terrace Dr 36 Median : Yard 3 Tree 1 DPW 2     5     5993878.86602 2096471.7721400002 37.7361607421118 -122.463635532375 (37.7361607421118, -122.463635532375)
33017 33017 218260 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1400x Portola Dr 18 Median : Yard 3 Tree 1 DPW 2     12     5992795.95946 2097207.23373 37.738117677685 -122.46743301504 (37.738117677685, -122.46743301504)
41943 41943 218261 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1400x Portola Dr 19 Median : Yard 3 Tree 1 DPW 2     8     5992797.06764 2097201.3875599997 37.738101689549296 -122.467428758544 (37.7381016895493, -122.467428758544)
41989 41989 251049 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 5700x Geary Blvd 11 Median : Yard 3 Tree 1 DPW 2     3 Width 10ft   5989182.8738 2112626.0902 37.7802444522785 -122.481053773582 (37.7802444522785, -122.481053773582)
46065 46065 205754 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Terrace Dr 35 Median : Yard 3 Tree 1 DPW 2     5     5993872.8693 2096472.5281599998 37.7361624724174 -122.46365632018 (37.7361624724174, -122.46365632018)
47847 47847 125865 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 47 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6011401.82838 2120281.49833 37.8025309385205 -122.404726857271 (37.8025309385205, -122.404726857271)
51953 51953 205753 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Terrace Dr 34 Median : Yard 3 Tree 1 DPW 2     4     5993866.87232 2096473.28451 37.7361642036105 -122.463677108908 (37.7361642036105, -122.463677108908)
73197 73197 205752 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Terrace Dr 33 Median : Yard 3 Tree 1 DPW 2     5     5993857.73884 2096475.3667 37.7361693944936 -122.46370883791501 (37.7361693944936, -122.463708837915)
73337 73337 125866 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 48 Median : Yard 3 Tree 1 DPW 2     6 Width 8ft   6011400.87154 2120290.44992 37.802555463919 -122.40473079899401 (37.802555463919, -122.404730798994)
131510 131510 125867 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 49 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6011400.22925 2120293.8654 37.802564806093294 -122.40473326224199 (37.8025648060933, -122.404733262242)
131755 131755 125864 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 46 Median : Yard 3 Tree 1 DPW 2     11 Width 8ft   6011404.31889 2120270.9561400004 37.8025021314422 -122.404717496217 (37.8025021314422, -122.404717496217)
133038 133038 125868 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 50 Median : Yard 3 Tree 1 DPW 2     9 Width 8ft   6011397.07627 2120306.83138 37.80260023127779 -122.404745086537 (37.8026002312778, -122.404745086537)
150115 150115 188865 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 900x Carolina St 41 Median : Yard 3 Tree 1 DPW 2     12     6012505.22674 2103087.46941 37.7553817004262 -122.39970055083401 (37.7553817004262, -122.399700550834)
158594 158594 251036 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 5317x Geary Blvd 10 Median : Yard 3 Tree 1 DPW 2     1 Width 10ft   5990401.2433 2112674.4808 37.780448069653296 -122.47684245414699 (37.7804480696533, -122.476842454147)
162994 162994 188866 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 900x Carolina St 42 Median : Yard 3 Tree 1 DPW 2     9     6012505.62203 2103079.77232 37.7553605879327 -122.39969864337499 (37.7553605879327, -122.399698643375)
178472 178472 251037 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 5317x Geary Blvd 11 Median : Yard 3 Tree 1 DPW 2     1 Width 10ft   5990398.0172 2112670.1794 37.780436072061896 -122.476853300249 (37.7804360720619, -122.476853300249)

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