Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, DBH, PlotSize, PermitNotes, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20071 | 20071 | 99485 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |||
78281 | 78281 | 111082 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 130 JUNIPERO SERRA BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5991393.0 | 2095322.0 | 37.7328602072681 | -122.472146321186 | (37.7328602072681, -122.472146321186) | ||||
82410 | 82410 | 99464 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 550X Miramar Ave | 9 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
83274 | 83274 | 99496 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
86969 | 86969 | 99459 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 550X Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |
87404 | 87404 | 99494 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
89076 | 89076 | 97486 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
90742 | 90742 | 99463 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 550X Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
91074 | 91074 | 99452 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |||
94507 | 94507 | 99469 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 4 | 15x280 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |||
97066 | 97066 | 99466 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |||
99750 | 99750 | 92208 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
100862 | 100862 | 99476 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
101136 | 101136 | 99470 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 8 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |||
102939 | 102939 | 99481 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |||
106153 | 106153 | 99462 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 550X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
111872 | 111872 | 97492 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Miramar Ave | 8 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
112226 | 112226 | 92209 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
117015 | 117015 | 97487 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
118496 | 118496 | 99484 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |||
119791 | 119791 | 99453 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |||
122780 | 122780 | 99495 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
123808 | 123808 | 99468 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 15x280 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |||
126415 | 126415 | 99483 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |||
127626 | 127626 | 97493 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Miramar Ave | 9 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
128399 | 128399 | 99493 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |||
128765 | 128765 | 99475 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2014 12:00:00 AM | 44 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
139081 | 139081 | 92211 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
139244 | 139244 | 99492 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |||
141106 | 141106 | 99467 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 15x280 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) |
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");