Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1599 | 1599 | 13014 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 412 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2016 02:25:00 PM | 3 | 3X3 | 6010343.163 | 2120639.8328 | 37.803455608926704 | -122.408415674405 | (37.8034556089267, -122.408415674405) | ||
| 4295 | 4295 | 12999 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 349 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 09:03:00 AM | 3 | 3X3 | 6010644.3554 | 2120634.1907 | 37.803456979280796 | -122.407372982577 | (37.8034569792808, -122.407372982577) | ||
| 4303 | 4303 | 9125 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 5827 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 11:55:00 AM | 3 | 3X3 | 5988965.7697498 | 2112572.6420628 | 37.780085075713295 | -122.481800911494 | (37.7800850757133, -122.481800911494) | ||
| 4321 | 4321 | 12988 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 324 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 06:56:00 AM | 3 | 3X3 | 6010748.7594 | 2120699.4941 | 37.803642129208605 | -122.407016292062 | (37.8036421292086, -122.407016292062) | ||
| 4886 | 4886 | 17862 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.43099633374901 | (37.7882072868246, -122.430996333749) | ||
| 5406 | 5406 | 13016 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 407 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2016 02:31:00 PM | 3 | 3X3 | 6010356.171 | 2120603.3463 | 37.8033561544514 | -122.408368084374 | (37.8033561544514, -122.408368084374) | ||
| 5543 | 5543 | 13010 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 396 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:16:00 AM | 3 | 3X3 | 6010502.3453 | 2120665.4782 | 37.803534937788704 | -122.407866624342 | (37.8035349377887, -122.407866624342) | ||
| 5794 | 5794 | 13024 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 445 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/04/2014 02:58:00 PM | 3 | 3X3 | 6010214.1933 | 2120583.5975 | 37.8032939775537 | -122.40885801148998 | (37.8032939775537, -122.40885801149) | ||
| 5910 | 5910 | 13011 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 396 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:12:00 AM | 3 | 3X3 | 6010476.6325 | 2120660.3892 | 37.8035195251148 | -122.40795524597999 | (37.8035195251148, -122.40795524598) | ||
| 6621 | 6621 | 13040 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 515-519 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 07:26:00 AM | 3 | 3X3 | 6009890.5899 | 2120540.3695 | 37.8031571528751 | -122.409974803368 | (37.8031571528751, -122.409974803368) | ||
| 7217 | 7217 | 17911 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2321 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 10:58:00 AM | 3 | 3X3 | 6002821.482999999 | 2115107.812 | 37.7878420242306 | -122.434049048426 | (37.7878420242306, -122.434049048426) | ||
| 7645 | 7645 | 13025 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 451 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 07:02:00 AM | 3 | 3X3 | 6010198.7145 | 2120581.4625 | 37.8032872483458 | -122.40891142592 | (37.8032872483458, -122.40891142592) | ||
| 8514 | 8514 | 13017 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 416 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2016 12:00:00 AM | 3 | 3X3 | 6010320.6699 | 2120636.9765 | 37.8034465065935 | -122.408493311466 | (37.8034465065935, -122.408493311466) | ||
| 8564 | 8564 | 13015 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 407 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2016 12:00:00 AM | 12 | 3X3 | 6010332.686000001 | 2120602.2788 | 37.803351908204796 | -122.408449280112 | (37.8033519082048, -122.408449280112) | ||
| 9819 | 9819 | 13083 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 660 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 11:06:00 AM | 3 | 3X3 | 6009215.12 | 2120489.4566 | 37.8029794783612 | -122.412308693696 | (37.8029794783612, -122.412308693696) | ||
| 50090 | 50090 | 13071 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
| 81377 | 81377 | 683 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | |
| 96845 | 96845 | 13075 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/22/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774508 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |
| 125041 | 125041 | 13072 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2008 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
| 128494 | 128494 | 13022 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 431 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:20:00 AM | 3 | 3X3 | 6010276.62799 | 2120585.425 | 37.803302492372396 | -122.408642082138 | (37.8033024923724, -122.408642082138) | ||
| 145289 | 145289 | 25159 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2600X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 12:55:00 PM | 3 | 3X3 | 6001683.708124 | 2105708.1424058997 | 37.7619682491468 | -122.43731221388599 | (37.7619682491468, -122.437312213886) |
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");