Street_Tree_List

Data source: data.sfgov.org

23 rows where DBH = 3 and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
6018 6018 19926 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY37 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 20ST            
11287 11287 20003 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY46 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 2            
16066 16066 22498 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 6404 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2003 12:00:00 AM 3 3X3   6013069.4059 2090221.21293 37.720085079934705 -122.39684744087799 (37.7200850799347, -122.396847440878)
24799 24799 120350 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2122 Lake St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988813.63616 2114710.28976 37.7859456052821 -122.482483881641 (37.7859456052821, -122.482483881641)
26210 26210 118831 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 662 46th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5981671.941000001 2111218.67307 37.775940615740105 -122.50693266579799 (37.7759406157401, -122.506932665798)
29285 29285 207725 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 380 Ralston St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   5992234.508719999 2090438.5826599998 37.7195002121526 -122.468881791362 (37.7195002121526, -122.468881791362)
38723 38723 191689 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1 01st St 27 : Yard 23 Tree 1 Private 1     3     6014402.09171 2105890.67407 37.7631842517621 -122.393336722306 (37.7631842517621, -122.393336722306)
50134 50134 191700 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 1700x Quesada Ave 39 Median : Yard 3 Tree 1 DPW 2     3     6014384.30677 2095263.8272900002 37.7340041867507 -122.39265480417801 (37.7340041867507, -122.392654804178)
55093 55093 202013 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 7 Wheat St 2 : 4 Tree 1 Private 1     3 Width 3ft   6012149.42791 2091374.5561400002 37.723200675946394 -122.40010846893601 (37.7232006759464, -122.400108468936)
55948 55948 207724 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 132 Ralston St 1 : 4 Tree 1 Private 1     3 Width 3ft   5992208.616230001 2088772.7459099998 37.71492473315389 -122.46885013341999 (37.7149247331539, -122.46885013342)
59361 59361 176270 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 195 Rome St 1 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   5998756.35201 2088943.21744 37.7157689240671 -122.44623074418001 (37.7157689240671, -122.44623074418)
65580 65580 191710 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 1427x Innes Ave 28 Median : Yard 3 Tree 1 DPW 2     3     6016141.2133599995 2096757.17707 37.7382020430791 -122.386684681762 (37.7382020430791, -122.386684681762)
70263 70263 48553 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 378 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/22/2002 12:00:00 AM 3   Permit Number 45869 5990302.44703 2112853.20794 37.780933073312504 -122.477197298017 (37.7809330733125, -122.477197298017)
79512 79512 804 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 680X 39th Ave 2 Median : Cutout 11 Tree 1 DPW 2     3 6-HOA   5983823.94935 2111143.69789 37.7758612538886 -122.499482885033 (37.7758612538886, -122.499482885033)
115840 115840 176282 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 35 Tomaso Ct 8 Side Yard : Yard 17 Tree 1 Private 1     3 Width 3ft   6009202.48899 2086331.0577900002 37.709187518951296 -122.40993964441401 (37.7091875189513, -122.409939644414)
154658 154658 207718 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 315 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994723.84306 2090686.3460799998 37.7203240181088 -122.46029507616998 (37.7203240181088, -122.46029507617)
158994 158994 207710 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 641 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992286.81518 2103851.81856 37.7563325940936 -122.46967695664 (37.7563325940936, -122.46967695664)
165907 165907 126567 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2843 Larkin St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6006455.5801099995 2121070.56705 37.8044198232789 -122.42189945398998 (37.8044198232789, -122.42189945399)
177760 177760 184363 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2251 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5981706.71 2099767.9271 37.7445021893581 -122.50596322728998 (37.7445021893581, -122.50596322729)
177778 177778 176281 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 600 Blanken Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6013188.37125 2086854.32403 37.710846891333105 -122.39620037057101 (37.7108468913331, -122.396200370571)
179929 179929 207728 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3802 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.47466105158199 (37.7196901687566, -122.474661051582)
180486 180486 176271 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 195 Rome St 2 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   5998766.3474 2088951.7637599998 37.715792961145205 -122.446196810045 (37.7157929611452, -122.446196810045)
182532 182532 247879 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 388 Mayflower St 8 Side Yard : Yard 17 Tree 1 Private 1     3     6009924.148030001 2098382.32436 37.7423181897436 -122.408294896795 (37.7423181897436, -122.408294896795)

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