Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1388 | 1388 | 251519 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1395 | 1395 | 251525 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 173 Sanchez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1401 | 1401 | 251523 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1413 | 1413 | 246406 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | |||
1414 | 1414 | 251524 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1416 | 1416 | 251521 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1425 | 1425 | 251522 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1433 | 1433 | 251520 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
2568 | 2568 | 227812 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 79 Piedmont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x15 | 5999345.2069 | 2106945.6167 | 37.765232827359 | -122.44548913263701 | (37.765232827359, -122.445489132637) | |||
9773 | 9773 | 114349 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1240 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x15 | Permit Number 777354 | 5981849.8 | 2106648.5 | 37.7634027199113 | -122.50597849798001 | (37.7634027199113, -122.50597849798) | ||
11978 | 11978 | 112948 | Property Tree 7 | Ligustrum japonicum :: Japanese Privet 4 | 400 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x15 | 6005670.66964 | 2093276.94718 | 37.7280608613968 | -122.42263943148599 | (37.7280608613968, -122.422639431486) | |||
14563 | 14563 | 116184 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013385.98536 | 2092427.1118400001 | 37.7261596505439 | -122.395907620544 | (37.7261596505439, -122.395907620544) | |||
15470 | 15470 | 116187 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013439.38211 | 2092375.3069099998 | 37.7260203752154 | -122.395719401447 | (37.7260203752154, -122.395719401447) | |||
16551 | 16551 | 116185 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013402.92261 | 2092407.9070599999 | 37.7261078603777 | -122.395847723887 | (37.7261078603777, -122.395847723887) | |||
79308 | 79308 | 111069 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1836 08TH AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | ||||
80498 | 80498 | 115704 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2820 LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 5986689.0 | 2114483.0 | 37.7851977068092 | -122.489817718558 | (37.7851977068092, -122.489817718558) | ||||
85207 | 85207 | 100504 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
86302 | 86302 | 100499 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
88034 | 88034 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1836 08TH AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | |||
90281 | 90281 | 110146 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 64 WOODLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x15 | 5997139.6 | 2106104.1 | 37.76279607600021 | -122.45305700914801 | (37.7627960760002, -122.453057009148) | |||
90866 | 90866 | 116182 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
91438 | 91438 | 100506 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
92775 | 92775 | 100507 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
93355 | 93355 | 111359 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1637 OAK ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x15 | 5999143.0 | 2109364.0 | 37.771861551181395 | -122.44636250519699 | (37.7718615511814, -122.446362505197) | ||||
93602 | 93602 | 111358 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1637 OAK ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x15 | 5999143.0 | 2109364.0 | 37.771861551181395 | -122.44636250519699 | (37.7718615511814, -122.446362505197) | ||||
94479 | 94479 | 116171 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
98099 | 98099 | 116167 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
100414 | 100414 | 116168 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
100554 | 100554 | 100505 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
100715 | 100715 | 100500 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
100716 | 100716 | 116173 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
103820 | 103820 | 111068 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1836 08TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | ||||
107117 | 107117 | 116172 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
108418 | 108418 | 110145 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 64 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x15 | 5997139.6 | 2106104.1 | 37.76279607600021 | -122.45305700914801 | (37.7627960760002, -122.453057009148) | |||
110457 | 110457 | 100503 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
110822 | 110822 | 116166 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
121731 | 121731 | 100508 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
121908 | 121908 | 115702 | Undocumented 2 | Tree(s) :: 17 | 2820 LAKE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x15 | Permit Number 777795 | 5986689.0 | 2114483.0 | 37.7851977068092 | -122.489817718558 | (37.7851977068092, -122.489817718558) | |
122788 | 122788 | 116170 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
123616 | 123616 | 100502 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
127052 | 127052 | 115699 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2840 LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 5986626.0 | 2114487.0 | 37.785205010982 | -122.49003597043699 | (37.785205010982, -122.490035970437) | ||||
127375 | 127375 | 115701 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2840 LAKE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 5986626.0 | 2114487.0 | 37.785205010982 | -122.49003597043699 | (37.785205010982, -122.490035970437) | ||||
127795 | 127795 | 115703 | Undocumented 2 | Tree(s) :: 17 | 2820 LAKE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x15 | Permit Number 777795 | 5986689.0 | 2114483.0 | 37.7851977068092 | -122.489817718558 | (37.7851977068092, -122.489817718558) | |
139495 | 139495 | 115700 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2840 LAKE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 5986626.0 | 2114487.0 | 37.785205010982 | -122.49003597043699 | (37.785205010982, -122.490035970437) | ||||
139627 | 139627 | 112262 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x15 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | |||
139654 | 139654 | 116183 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1751 CARROLL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013485.0 | 2092424.0 | 37.72615661412179 | -122.395565112125 | (37.7261566141218, -122.395565112125) | |||
139884 | 139884 | 116175 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
143651 | 143651 | 116169 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
143713 | 143713 | 100501 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x15 | 6008884.6 | 2107581.7 | 37.7675193335945 | -122.412539495737 | (37.7675193335945, -122.412539495737) | |||
143970 | 143970 | 116174 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
145010 | 145010 | 116176 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) |
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");