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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1735 | 1735 | 251679 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 5 Dwight St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011495.0 | 2091622.0 | 37.7238435952898 | -122.40238810251101 | (37.7238435952898, -122.402388102511) | |||||
| 29286 | 29286 | 191035 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 30 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009859.31671 | 2111047.24968 | 37.77708958274221 | -122.409412667772 | (37.7770895827422, -122.409412667772) | |||
| 30022 | 30022 | 183465 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2530 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988020.0365 | 2098057.0209999997 | 37.7401740893942 | -122.484007860756 | (37.7401740893942, -122.484007860756) | |||
| 34609 | 34609 | 182248 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1454 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985596.8527 | 2105324.6327 | 37.7599875985541 | -122.492921320569 | (37.7599875985541, -122.492921320569) | |||
| 35901 | 35901 | 184740 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984699.9431 | 2106237.7689 | 37.762442323054294 | -122.49609061999399 | (37.7624423230543, -122.496090619994) | |||
| 37152 | 37152 | 207426 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 404 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6000774.5178 | 2095253.0810900002 | 37.7332094216698 | -122.439707159174 | (37.7332094216698, -122.439707159174) | ||||
| 39055 | 39055 | 246391 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1302 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999418.9163 | 2108430.2253 | 37.7693133969257 | -122.445340943975 | (37.7693133969257, -122.445340943975) | |||
| 39416 | 39416 | 141601 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1882 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998863.8341 | 2110436.3604 | 37.77479003056 | -122.447405354515 | (37.77479003056, -122.447405354515) | |||
| 41620 | 41620 | 126461 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1990 Beach St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000743.635919999 | 2120987.57838 | 37.8038681737437 | -122.441660117946 | (37.8038681737437, -122.441660117946) | |||
| 49139 | 49139 | 114654 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001378.1104 | 2113915.8269 | 37.7844871189173 | -122.438957381866 | (37.7844871189173, -122.438957381866) | |||
| 50624 | 50624 | 141254 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 45 PARKER AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5996808.5286 | 2114260.026 | 37.7851711462005 | -122.454791358921 | (37.7851711462005, -122.454791358921) | |||
| 52169 | 52169 | 82920 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 1 | 5982872.9956 | 2103302.6049 | 37.754276013066104 | -122.502192036803 | (37.7542760130661, -122.502192036803) | ||
| 60665 | 60665 | 183413 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2350 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985629.7915 | 2097026.6067 | 37.737205400625 | -122.492196390733 | (37.737205400625, -122.492196390733) | |||
| 67051 | 67051 | 207425 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 359 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991937.91081 | 2090925.4069599998 | 37.7208197721094 | -122.469942439193 | (37.7208197721094, -122.469942439193) | |||
| 68022 | 68022 | 184739 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984690.4501 | 2106251.0591 | 37.7624782581791 | -122.496124432854 | (37.7624782581791, -122.496124432854) | |||
| 69521 | 69521 | 73455 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 24 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 9 | 6009841.50181 | 2111066.87201 | 37.777142462880995 | -122.409475680552 | (37.777142462881, -122.409475680552) | ||
| 71417 | 71417 | 246395 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999349.2656 | 2108419.0206 | 37.769278655482296 | -122.445581055639 | (37.7692786554823, -122.445581055639) | |||
| 89766 | 89766 | 121619 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1465 Rhode Island St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012073.0 | 2101555.0 | 37.7511497699027 | -122.40108765644301 | (37.7511497699027, -122.401087656443) | |||||
| 97168 | 97168 | 106921 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 112-118 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6007680.5 | 2107244.2 | 37.7665249882726 | -122.416680417976 | (37.7665249882726, -122.416680417976) | |||
| 123721 | 123721 | 246397 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264092996 | -122.445696997639 | (37.769264264093, -122.445696997639) | |||
| 142237 | 142237 | 102442 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6008344.0 | 2095883.0 | 37.735366982034996 | -122.413581854524 | (37.735366982035, -122.413581854524) | |||
| 150358 | 150358 | 187339 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985079.353999999 | 2099690.9452 | 37.7444887635366 | -122.494295807794 | (37.7444887635366, -122.494295807794) | |||
| 151873 | 151873 | 140845 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 527 EUCLID AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5996698.8799 | 2113809.925 | 37.7839289983891 | -122.455138170133 | (37.7839289983891, -122.455138170133) | |||
| 157189 | 157189 | 246392 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1310 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999402.5635 | 2108427.4999 | 37.7693049801732 | -122.44539731131901 | (37.7693049801732, -122.445397311319) | |||
| 159169 | 159169 | 246396 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999332.61 | 2108417.5065 | 37.769273547251004 | -122.445638557414 | (37.769273547251, -122.445638557414) | |||
| 159867 | 159867 | 70368 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.50150735953899 | (37.7598111971708, -122.501507359539) | ||
| 164594 | 164594 | 248448 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 136 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998284.3672 | 2107976.1331 | 37.768001745714 | -122.449232557107 | (37.768001745714, -122.449232557107) | |||
| 166412 | 166412 | 141253 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 45 PARKER AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996809.5439 | 2114265.4407 | 37.7851860717648 | -122.454788237668 | (37.7851860717648, -122.454788237668) | |||
| 171936 | 171936 | 246393 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1318 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999383.4853 | 2108424.4716 | 37.769295576121394 | -122.445463083857 | (37.7692955761214, -122.445463083857) | |||
| 171963 | 171963 | 247352 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 717 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003091.9924 | 2109593.0641 | 37.772715254913294 | -122.432719040926 | (37.7727152549133, -122.432719040926) | |||
| 174014 | 174014 | 72596 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1551 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1997 12:00:00 AM | 5 | 5988056.3788 | 2104735.0481 | 37.758512285148605 | -122.48437186974199 | (37.7585122851486, -122.484371869742) | ||
| 174354 | 174354 | 72614 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1586 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1997 12:00:00 AM | 6 | 5987797.3449 | 2104500.8291 | 37.757854096737205 | -122.485250528016 | (37.7578540967372, -122.485250528016) | ||
| 178672 | 178672 | 246394 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999365.9212 | 2108422.0489 | 37.769287921296204 | -122.44552366275299 | (37.7692879212962, -122.445523662753) | |||
| 181134 | 181134 | 114652 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001448.056 | 2113923.3749 | 37.7845118231904 | -122.438715935573 | (37.7845118231904, -122.438715935573) | |||
| 183202 | 183202 | 126462 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1990 Beach St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000762.32542 | 2120990.48851 | 37.803877229006204 | -122.441595650935 | (37.8038772290062, -122.441595650935) | |||
| 188090 | 188090 | 114656 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6001274.7016 | 2113900.9823 | 37.78444047533 | -122.439314075739 | (37.78444047533, -122.439314075739) |
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");