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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 586 | 586 | 237035 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/12/2017 02:27:00 PM | 3 | Width 4ft | 6005709.86547 | 2109855.10938 | 37.7735828886787 | -122.423682154918 | (37.7735828886787, -122.423682154918) | ||
| 622 | 622 | 237036 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/13/2017 02:42:00 PM | 3 | Width 4ft | 6005705.053180001 | 2109878.39065 | 37.7736465417793 | -122.423700457022 | (37.7736465417793, -122.423700457022) | ||
| 643 | 643 | 239154 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 6 | : 4 | Tree 1 | DPW 2 | 04/13/2017 02:47:00 PM | 3 | Width 4ft | 6005701.84613 | 2109911.12293 | 37.773736235682 | -122.42371387848999 | (37.773736235682, -122.42371387849) | ||
| 2066 | 2066 | 252868 | Undocumented 2 | Shrub :: Shrub 98 | 15 Foerster St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5998080.65269 | 2093664.7185 | 37.7286944544712 | -122.44890616611099 | (37.7286944544712, -122.448906166111) | ||||
| 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) | |||
| 90472 | 90472 | 120871 | Undocumented 2 | Shrub :: Shrub 98 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 5993606.0 | 2106068.0 | 37.762493810072606 | -122.465275766733 | (37.7624938100726, -122.465275766733) | |||||
| 87585 | 87585 | 121391 | Undocumented 2 | Shrub :: Shrub 98 | 1301x 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993851.0 | 2106604.0 | 37.763979651815205 | -122.464467327674 | (37.7639796518152, -122.464467327674) | ||||
| 92104 | 92104 | 121390 | Undocumented 2 | Shrub :: Shrub 98 | 1301x 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993851.0 | 2106604.0 | 37.763979651815205 | -122.464467327674 | (37.7639796518152, -122.464467327674) | ||||
| 31848 | 31848 | 184755 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984688.1718 | 2106071.0721 | 37.7619839309054 | -122.496119032944 | (37.7619839309054, -122.496119032944) | |||
| 32844 | 32844 | 184753 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984707.1578 | 2106087.4001 | 37.76202987507679 | -122.496054573405 | (37.7620298750768, -122.496054573405) | |||
| 47657 | 47657 | 184756 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984687.2225 | 2106057.4022 | 37.761946341588 | -122.496121307582 | (37.761946341588, -122.496121307582) | |||
| 50614 | 50614 | 184751 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984675.641 | 2106097.6525 | 37.7620561792493 | -122.4961643326 | (37.7620561792493, -122.4961643326) | |||
| 77017 | 77017 | 184752 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984700.7025 | 2106093.8553 | 37.7620472211463 | -122.496077375707 | (37.7620472211463, -122.496077375707) | |||
| 179154 | 179154 | 184750 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984665.0089 | 2106100.6902 | 37.7620638971415 | -122.496201328503 | (37.7620638971415, -122.496201328503) | |||
| 181183 | 181183 | 184754 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984657.4145 | 2106082.8434 | 37.762014449980704 | -122.496226277389 | (37.7620144499807, -122.496226277389) | |||
| 57230 | 57230 | 181567 | Undocumented 2 | Shrub :: Shrub 98 | 1300 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984855.7554 | 2106265.0899 | 37.7625264639896 | -122.49555374589599 | (37.7625264639896, -122.495553745896) | |||
| 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) | ||
| 79753 | 79753 | 107409 | Undocumented 2 | Shrub :: Shrub 98 | 125 VILLA TER | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5999028.2 | 2104385.8 | 37.758186107000796 | -122.44640141076401 | (37.7581861070008, -122.446401410764) | |||||
| 85503 | 85503 | 96631 | Permitted Site 1 | Shrub :: Shrub 98 | 1212 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 4x4 | Permit Number 776835 | 5993035.2 | 2107183.3 | 37.7655231963247 | -122.467331039359 | (37.7655231963247, -122.467331039359) | ||
| 88899 | 88899 | 119673 | Undocumented 2 | Shrub :: Shrub 98 | 1207 De Haro St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012287.0 | 2102743.0 | 37.7544236952833 | -122.40043105492799 | (37.7544236952833, -122.400431054928) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 1718 | 1718 | 251667 | Undocumented 2 | Shrub :: Shrub 98 | 1090x Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5988120.0 | 2094796.0 | 37.731225993649296 | -122.483423232518 | (37.7312259936493, -122.483423232518) | ||||
| 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) | |||
| 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) | |||
| 79695 | 79695 | 114527 | Undocumented 2 | Shrub :: Shrub 98 | 1 TIOGA AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
| 94733 | 94733 | 114528 | Undocumented 2 | Shrub :: Shrub 98 | 1 TIOGA AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) |
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");