Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5146 | 5146 | 228435 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 178 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004070.0 | 2107898.0 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | |||
| 5169 | 5169 | 228433 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 300 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004139.02513 | 2107107.02985 | 37.7659485330168 | -122.4289199675 | (37.7659485330168, -122.4289199675) | |||
| 31656 | 31656 | 228466 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 315 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004209.32869 | 2107056.55416 | 37.7658139179905 | -122.42867320340599 | (37.7658139179905, -122.428673203406) | |||
| 33760 | 33760 | 228480 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 602 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007650.87527 | 2096524.2069599999 | 37.7370886509206 | -122.416023645289 | (37.7370886509206, -122.416023645289) | |||
| 34455 | 34455 | 228481 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 430 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008039.5755 | 2096830.96729 | 37.7379527941736 | -122.414701431422 | (37.7379527941736, -122.414701431422) | |||
| 40043 | 40043 | 228498 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 450 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6004181.58169 | 2106402.65123 | 37.764016887284704 | -122.42872255552 | (37.7640168872847, -122.42872255552) | |||
| 46133 | 46133 | 228504 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 60 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006682.42728 | 2109519.39101 | 37.7727159377106 | -122.420294078716 | (37.7727159377106, -122.420294078716) | |||
| 52316 | 52316 | 190655 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 354 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012900.86657 | 2105367.98453 | 37.7616655423506 | -122.398492314369 | (37.7616655423506, -122.398492314369) | |||
| 53257 | 53257 | 228494 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004270.96724 | 2105879.99485 | 37.7625868564077 | -122.42837614294201 | (37.7625868564077, -122.428376142942) | |||
| 56231 | 56231 | 228455 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009383.67351 | 2106374.02164 | 37.7642313225287 | -122.410727961341 | (37.7642313225287, -122.410727961341) | |||
| 57920 | 57920 | 228456 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009403.2734199995 | 2106375.12773 | 37.7642354585115 | -122.410660248687 | (37.7642354585115, -122.410660248687) | |||
| 68876 | 68876 | 228449 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009256.91005 | 2106366.76259 | 37.76420428262279 | -122.411165888909 | (37.7642042826228, -122.411165888909) | |||
| 73664 | 73664 | 228453 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009339.05918 | 2106371.48119 | 37.7642218454873 | -122.41088209075899 | (37.7642218454873, -122.410882090759) | |||
| 95037 | 95037 | 91195 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 422 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2011 12:00:00 AM | 1 | 3x3 | 6004087.9204 | 2109490.98672 | 37.772491407466205 | -122.429266736662 | (37.7724914074662, -122.429266736662) | ||
| 148393 | 148393 | 228505 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006699.63588 | 2109500.73575 | 37.772665684492395 | -122.420233227899 | (37.7726656844924, -122.420233227899) | |||
| 149630 | 149630 | 228454 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009362.10361 | 2106372.48972 | 37.7642259068175 | -122.410802457572 | (37.7642259068175, -122.410802457572) | |||
| 153175 | 153175 | 228452 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009318.2366 | 2106370.18067 | 37.7642171069559 | -122.41095401853799 | (37.7642171069559, -122.410954018538) | |||
| 155607 | 155607 | 228471 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 237 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004185.6843 | 2107453.8801 | 37.7669035410995 | -122.428783311922 | (37.7669035410995, -122.428783311922) | |||
| 160222 | 160222 | 228451 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009297.41402 | 2106368.8801700003 | 37.7642123684355 | -122.411025946309 | (37.7642123684355, -122.411025946309) | |||
| 166771 | 166771 | 228450 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009278.09164 | 2106368.2886 | 37.764209660560205 | -122.41109273536699 | (37.7642096605602, -122.411092735367) | |||
| 168166 | 168166 | 228462 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.768304778378294 | -122.418472926402 | (37.7683047783783, -122.418472926402) | |||
| 186641 | 186641 | 228467 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 309 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004207.05311 | 2107076.17172 | 37.7658676543027 | -122.428682472728 | (37.7658676543027, -122.428682472728) | |||
| 188130 | 188130 | 228457 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009423.8763 | 2106376.9257400003 | 37.7642415505399 | -122.410589115888 | (37.7642415505399, -122.410589115888) |
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");