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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139900 | 139900 | 91017 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 457 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 5988087.568302 | 2112897.540762 | 37.7809260463619 | -122.48486281200898 | (37.7809260463619, -122.484862812009) | |
| 99422 | 99422 | 90510 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988112.407888 | 2112207.812683 | 37.7790336942222 | -122.48472626983101 | (37.7790336942222, -122.484726269831) | |
| 102101 | 102101 | 90511 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 569 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988115.7266919995 | 2112113.5102150002 | 37.7787749594642 | -122.48470786940099 | (37.7787749594642, -122.484707869401) | |
| 102220 | 102220 | 90517 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 619 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988128.545308 | 2111752.691709 | 37.777784999781794 | -122.48463705113701 | (37.7777849997818, -122.484637051137) | |
| 118636 | 118636 | 90471 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 534 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5988147.641992 | 2112343.937312 | 37.779409506079396 | -122.484614370085 | (37.7794095060794, -122.484614370085) | |
| 90847 | 90847 | 90526 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988149.756261 | 2111164.589328 | 37.7761714707406 | -122.484520528522 | (37.7761714707406, -122.484520528522) | |
| 66010 | 66010 | 90469 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 578 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988158.072517 | 2112047.558198 | 37.778596339842 | -122.48455654153601 | (37.778596339842, -122.484556541536) | |
| 78169 | 78169 | 90468 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 600 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988164.289455 | 2111871.41207 | 37.778113054108296 | -122.48452211150601 | (37.7781130541083, -122.484522111506) | |
| 113740 | 113740 | 89640 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 3349X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5988302.001433 | 2111876.734088 | 37.7781356853217 | -122.484046112267 | (37.7781356853217, -122.484046112267) | |
| 98157 | 98157 | 90211 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2349X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988326.615747 | 2111197.527168 | 37.77627220634061 | -122.48391114694901 | (37.7762722063406, -122.483911146949) | |
| 120567 | 120567 | 90212 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2349X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988326.615747 | 2111197.527168 | 37.77627220634061 | -122.48391114694901 | (37.7762722063406, -122.483911146949) | |
| 103835 | 103835 | 86347 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2385 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/18/2006 12:00:00 AM | 6 | 3x3 | 5988561.573064 | 2099100.588411 | 37.7430709645331 | -122.48221190478901 | (37.7430709645331, -122.482211904789) | |
| 109181 | 109181 | 90915 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3228 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988669.966739 | 2111929.945878 | 37.7783032057889 | -122.482777102874 | (37.7783032057889, -122.482777102874) | |
| 124975 | 124975 | 90867 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 2133 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989018.500813 | 2110541.8150979998 | 37.774512057064904 | -122.481469721054 | (37.7745120570649, -122.481469721054) | |
| 96755 | 96755 | 90870 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 2045 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989292.971461 | 2110551.77641 | 37.7745553629802 | -122.48052101423 | (37.7745553629802, -122.48052101423) | |
| 109216 | 109216 | 90573 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989607.117119 | 2110603.2040279997 | 37.7747148208537 | -122.47943809850099 | (37.7747148208537, -122.479438098501) | |
| 84637 | 84637 | 90876 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 1935 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989632.284630001 | 2110564.0911 | 37.7746088893469 | -122.47934817793801 | (37.7746088893469, -122.479348177938) | |
| 143644 | 143644 | 90881 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989882.489844 | 2110573.171827 | 37.7746483516209 | -122.478483342296 | (37.7746483516209, -122.478483342296) | |
| 143691 | 143691 | 91888 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1104 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992367.653968 | 2106623.490856 | 37.763947549515 | -122.469599153768 | (37.763947549515, -122.469599153768) | |
| 142077 | 142077 | 91685 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 383 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007417.550958999 | 2107460.112945 | 37.767103042082795 | -122.417605218645 | (37.7671030420828, -122.417605218645) | ||
| 85635 | 85635 | 91684 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 387 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007418.830408 | 2107437.729103 | 37.7670416532981 | -122.41759920657 | (37.7670416532981, -122.41759920657) | ||
| 82540 | 82540 | 91660 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 999 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007618.393891 | 2103856.158531 | 37.7572187178563 | -122.416655196612 | (37.7572187178563, -122.416655196612) | ||
| 84596 | 84596 | 91753 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2500X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/07/2007 12:00:00 AM | 5 | 3x3 | 6008845.834759 | 2103888.876448 | 37.7573775113883 | -122.41241252654301 | (37.7573775113883, -122.412412526543) |
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");