Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
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) | ||
825 | 825 | 244349 | Undocumented 2 | Shrub :: Shrub 98 | 300 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2017 02:48:00 PM | 3 | Width 0ft | 6005619.6911 | 2110403.6421 | 37.77508393621179 | -122.424033097665 | (37.7750839362118, -122.424033097665) | ||
831 | 831 | 244348 | DPW Maintained 3 | Shrub :: Shrub 98 | 300 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2017 02:44:00 PM | 3 | Width 0ft | 6005622.9962 | 2110384.2841 | 37.7750309704349 | -122.424020287681 | (37.7750309704349, -122.424020287681) | ||
852 | 852 | 244300 | DPW Maintained 3 | Shrub :: Shrub 98 | 350 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 11:46:00 AM | 3 | Width 0ft | 6005602.4578 | 2110538.44 | 37.775453085580295 | -122.424102299872 | (37.7754530855803, -122.424102299872) | ||
856 | 856 | 244351 | DPW Maintained 3 | Shrub :: Shrub 98 | 300 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 07:17:00 AM | 3 | Width 0ft | 6005616.3861 | 2110436.6924 | 37.7751744977295 | -122.42404688124701 | (37.7751744977295, -122.424046881247) | ||
863 | 863 | 244299 | DPW Maintained 3 | Shrub :: Shrub 98 | 350 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 11:32:00 AM | 3 | Width 0ft | 6005603.4021 | 2110525.6921 | 37.7754181362545 | -122.424098126533 | (37.7754181362545, -122.424098126533) | ||
866 | 866 | 244301 | DPW Maintained 3 | Shrub :: Shrub 98 | 350 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 11:53:00 AM | 3 | Width 0ft | 6005600.097 | 2110553.5487 | 37.775494437113295 | -122.42411154116199 | (37.7754944371133, -122.424111541162) | ||
1585 | 1585 | 23896 | DPW Maintained 3 | Shrub :: Shrub 98 | 1581 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2017 12:00:00 AM | 3 | 3x3 | 6003535.353102201 | 2114132.0136397 | 37.7852032161945 | -122.43150950273301 | (37.7852032161945, -122.431509502733) | ||
9895 | 9895 | 24292 | DPW Maintained 3 | Shrub :: Shrub 98 | 403 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/1992 12:00:00 AM | 3 | 3X3 | |||||||
82634 | 82634 | 26499 | DPW Maintained 3 | Shrub :: Shrub 98 | 2710 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x3 | 6008889.7812 | 2102567.01926 | 37.7537504562032 | -122.41216712165199 | (37.7537504562032, -122.412167121652) | |||
92800 | 92800 | 12755 | DPW Maintained 3 | Shrub :: Shrub 98 | 1733 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 3X3 | 5990033.85435 | 2114674.56985 | 37.785918437001705 | -122.478259694764 | (37.7859184370017, -122.478259694764) | ||
93443 | 93443 | 15888 | DPW Maintained 3 | Shrub :: Shrub 98 | 5625 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5998561.46984 | 2087228.1352400002 | 37.711048567191604 | -122.446781008521 | (37.7110485671916, -122.446781008521) | |||
94867 | 94867 | 15877 | DPW Maintained 3 | Shrub :: Shrub 98 | 5508 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/1997 12:00:00 AM | 3 | 3X3 | 5999048.25069 | 2087729.15393 | 37.7124520473945 | -122.445134579389 | (37.7124520473945, -122.445134579389) | ||
104095 | 104095 | 22545 | DPW Maintained 3 | Shrub :: Shrub 98 | 7 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X3 | 6001395.6747592995 | 2098711.0868843 | 37.742739635423206 | -122.43780724032301 | (37.7427396354232, -122.437807240323) | |||
128536 | 128536 | 19363 | DPW Maintained 3 | Shrub :: Shrub 98 | 738 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5992103.0127542 | 2089880.5617979001 | 37.7179604248963 | -122.469295726054 | (37.7179604248963, -122.469295726054) |
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");