Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111245 | 111245 | 99672 | DPW Maintained 3 | Shrub :: Shrub 98 | 1250X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 128536 | 128536 | 19363 | DPW Maintained 3 | Shrub :: Shrub 98 | 738 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5992103.0127542 | 2089880.5617979001 | 37.7179604248963 | -122.469295726054 | (37.7179604248963, -122.469295726054) | |||
| 131967 | 131967 | 181355 | Undocumented 2 | Shrub :: Shrub 98 | 2300 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985079.1419 | 2099429.3232 | 37.7437704079628 | -122.49427726096201 | (37.7437704079628, -122.494277260962) | |||
| 140313 | 140313 | 99583 | Undocumented 2 | Shrub :: Shrub 98 | 650X Brunswick St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
| 148012 | 148012 | 185313 | Undocumented 2 | Shrub :: Shrub 98 | 2601 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984983.1747 | 2097234.3473 | 37.7377379790483 | -122.49444731702299 | (37.7377379790483, -122.494447317023) | |||
| 150729 | 150729 | 186250 | Undocumented 2 | Shrub :: Shrub 98 | 1701 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984767.3503 | 2103112.4152 | 37.753864919503 | -122.495626952484 | (37.753864919503, -122.495626952484) | |||
| 164218 | 164218 | 185692 | Undocumented 2 | Shrub :: Shrub 98 | 2101 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984851.9348 | 2100530.8696 | 37.746781656202295 | -122.495144090409 | (37.7467816562023, -122.495144090409) | |||
| 177379 | 177379 | 181571 | Undocumented 2 | Shrub :: Shrub 98 | 1200 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984860.385 | 2106736.0056 | 37.7638197374851 | -122.49557246911101 | (37.7638197374851, -122.495572469111) | |||
| 179730 | 179730 | 184869 | Undocumented 2 | Shrub :: Shrub 98 | 1201 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984640.7069 | 2106821.7773 | 37.764042376179205 | -122.496338586447 | (37.7640423761792, -122.496338586447) | |||
| 182690 | 182690 | 181343 | Undocumented 2 | Shrub :: Shrub 98 | 2500 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985164.5677 | 2097705.9234 | 37.739043415002705 | -122.493854905389 | (37.7390434150027, -122.493854905389) | |||
| 183333 | 183333 | 187234 | Undocumented 2 | Shrub :: Shrub 98 | 2401 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984956.0101 | 2098625.8109 | 37.7415569740276 | -122.494643790117 | (37.7415569740276, -122.494643790117) | |||
| 185026 | 185026 | 187377 | Undocumented 2 | Shrub :: Shrub 98 | 2200 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985052.2703 | 2100029.8298 | 37.7454176637381 | -122.49441443213001 | (37.7454176637381, -122.49441443213) | |||
| 41030 | 41030 | 185311 | Undocumented 2 | Shrub :: Shrub 98 | 2601 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984965.5883 | 2097247.7465 | 37.737773740404 | -122.49450910826799 | (37.737773740404, -122.494509108268) | |||
| 110242 | 110242 | 106469 | Undocumented 2 | Shrub :: Shrub 98 | 100X HENRY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5x5 | 6002548.0 | 2107375.0 | 37.7665941299684 | -122.43444215139601 | (37.7665941299684, -122.434442151396) | |||
| 172267 | 172267 | 186364 | Undocumented 2 | Shrub :: Shrub 98 | 1801 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984815.8043 | 2102571.1093 | 37.7523814800587 | -122.495419470402 | (37.7523814800587, -122.495419470402) | |||
| 187550 | 187550 | 185258 | Undocumented 2 | Shrub :: Shrub 98 | 2101 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986433.4347 | 2097526.3066 | 37.7386243913853 | -122.489454599165 | (37.7386243913853, -122.489454599165) | |||
| 36265 | 36265 | 181582 | Undocumented 2 | Shrub :: Shrub 98 | 1200 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984863.0361 | 2106906.9776 | 37.7642893338004 | -122.49557591115601 | (37.7642893338004, -122.495575911156) | |||
| 32955 | 32955 | 184206 | Undocumented 2 | Shrub :: Shrub 98 | 1484 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983432.9268 | 2105012.9881 | 37.759005126774895 | -122.500382134012 | (37.7590051267749, -122.500382134012) | |||
| 40776 | 40776 | 181577 | Undocumented 2 | Shrub :: Shrub 98 | 1200 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984846.2035 | 2106866.5794 | 37.76417742600729 | -122.49563114953699 | (37.7641774260073, -122.495631149537) | |||
| 1090 | 1090 | 184622 | Undocumented 2 | Shrub :: Shrub 98 | 1778 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983811.7777 | 2103069.4322 | 37.7536908962098 | -122.498928317229 | (37.7536908962098, -122.498928317229) | |||
| 51487 | 51487 | 186362 | Undocumented 2 | Shrub :: Shrub 98 | 1801 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984819.5753 | 2102574.8802 | 37.7523920547151 | -122.49540670794501 | (37.7523920547151, -122.495406707945) | |||
| 142517 | 142517 | 102267 | DPW Maintained 3 | Shrub :: Shrub 98 | 100X Casitas Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6x3 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
| 142952 | 142952 | 102268 | DPW Maintained 3 | Shrub :: Shrub 98 | 100X Casitas Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6x3 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
| 70454 | 70454 | 186363 | Undocumented 2 | Shrub :: Shrub 98 | 1801 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984829.0026 | 2102575.9576 | 37.752395564949104 | -122.49537418673401 | (37.7523955649491, -122.495374186734) | |||
| 78136 | 78136 | 21133 | DPW Maintained 3 | Shrub :: Shrub 98 | 2292X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | ||||
| 97043 | 97043 | 27143 | DPW Maintained 3 | Shrub :: Shrub 98 | 1775 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011388.84182 | 2095356.57174 | 37.7340920254878 | -122.403017629645 | (37.7340920254878, -122.403017629645) | |||
| 119560 | 119560 | 21130 | DPW Maintained 3 | Shrub :: Shrub 98 | 2292X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | ||||
| 127970 | 127970 | 4893 | DPW Maintained 3 | Shrub :: Shrub 98 | 745X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009751.8988059005 | 2090059.5024836997 | 37.7194558413593 | -122.408303589874 | (37.7194558413593, -122.408303589874) | |||
| 92261 | 92261 | 117511 | DPW Maintained 3 | Shrub :: Shrub 98 | 2634 37TH AVE | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 20 | 3x3 | 5984921.0 | 2097163.0 | 37.737538439530795 | -122.49465702329901 | (37.7375384395308, -122.494657023299) | |||
| 126456 | 126456 | 116577 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 30 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) |
JSON shape: default, array, newline-delimited
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");