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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57068 | 57068 | 91303 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011733.09402 | 2106250.1739 | 37.764022712206895 | -122.402593229194 | (37.7640227122069, -122.402593229194) | |
58924 | 58924 | 39581 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011726.24536 | 2106360.66695 | 37.764325718987 | -122.402624687477 | (37.764325718987, -122.402624687477) | |
62328 | 62328 | 39578 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011723.1047 | 2106429.85063 | 37.764515506505795 | -122.402640415745 | (37.7645155065058, -122.402640415745) | |
62933 | 62933 | 39582 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52049 | 6011727.82221 | 2106332.27183 | 37.764247840391995 | -122.402617236619 | (37.764247840392, -122.402617236619) | |
66803 | 66803 | 91320 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011737.57842 | 2106176.43383 | 37.7638204888591 | -122.402572533108 | (37.7638204888591, -122.402572533108) | |
78688 | 78688 | 91312 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
78931 | 78931 | 91324 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
80753 | 80753 | 91302 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
82141 | 82141 | 91313 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
82942 | 82942 | 91308 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
86347 | 86347 | 91300 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
87665 | 87665 | 91296 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
93615 | 93615 | 91325 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
94573 | 94573 | 91307 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
95616 | 95616 | 91305 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
96291 | 96291 | 91317 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
97167 | 97167 | 91323 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
98456 | 98456 | 91311 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
100853 | 100853 | 91309 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
101802 | 101802 | 91306 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
107112 | 107112 | 91315 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
110244 | 110244 | 91322 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
115325 | 115325 | 91314 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
116390 | 116390 | 91301 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
116877 | 116877 | 91299 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
124496 | 124496 | 91316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
125444 | 125444 | 91326 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
126929 | 126929 | 91318 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
127987 | 127987 | 91298 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
131213 | 131213 | 39577 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52049 | 6011722.01888 | 2106470.62948 | 37.7646274154535 | -122.40264703923201 | (37.7646274154535, -122.402647039232) | |
141790 | 141790 | 91310 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
142686 | 142686 | 91297 | Permitted Site 1 | Celtis australis :: European Hackberry 282 | 450 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
147619 | 147619 | 91304 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011733.902840001 | 2106231.09001 | 37.763970357278104 | -122.40258908962 | (37.7639703572781, -122.40258908962) | |
147667 | 147667 | 91321 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011737.811869999 | 2106152.59445 | 37.7637550442951 | -122.40257004917 | (37.7637550442951, -122.40257004917) | |
163827 | 163827 | 39580 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011724.32766 | 2106384.06369 | 37.764389854120395 | -122.402632965739 | (37.7643898541204, -122.402632965739) | |
174408 | 174408 | 39583 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011728.45947 | 2106316.5282900003 | 37.764204647739895 | -122.40261392531099 | (37.7642046477399, -122.402613925311) | |
175772 | 175772 | 91319 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011735.90976 | 2106200.3023900003 | 37.7638859334175 | -122.40257998308998 | (37.7638859334175, -122.40257998309) | |
177995 | 177995 | 39579 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011724.07511 | 2106406.95003 | 37.7644526807755 | -122.40263544879 | (37.7644526807755, -122.40263544879) |
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");