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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34440 | 34440 | 88670 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016858.92761 | 2102116.1469400004 | 37.7529563862427 | -122.384576334524 | (37.7529563862427, -122.384576334524) | |
46259 | 46259 | 88675 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
47155 | 47155 | 88663 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016462.36488 | 2102094.25346 | 37.752874333003795 | -122.38594621066002 | (37.7528743330038, -122.38594621066) | |
60523 | 60523 | 88664 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51637 | 6016498.80939 | 2102095.90957 | 37.752880897153396 | -122.385820292998 | (37.7528808971534, -122.385820292998) | |
62051 | 62051 | 88661 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51637 | 6016379.4847 | 2102091.5410599997 | 37.752862298279 | -122.386232639338 | (37.752862298279, -122.386232639338) | |
78248 | 78248 | 88677 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
78385 | 78385 | 91478 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
79726 | 79726 | 91481 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
81149 | 81149 | 91472 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
85465 | 85465 | 88674 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
85815 | 85815 | 91477 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
86487 | 86487 | 88680 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
87367 | 87367 | 88682 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
92599 | 92599 | 88665 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
101128 | 101128 | 88684 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
101882 | 101882 | 88685 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
105153 | 105153 | 91474 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
105225 | 105225 | 88672 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016937.47244 | 2102122.1356099998 | 37.7529771731841 | -122.384305125986 | (37.7529771731841, -122.384305125986) | |
105435 | 105435 | 88678 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
108806 | 108806 | 91480 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
109689 | 109689 | 91479 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
116237 | 116237 | 88681 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
117206 | 117206 | 88676 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
127151 | 127151 | 88679 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
129334 | 129334 | 91470 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
135598 | 135598 | 88666 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016578.93003 | 2102100.6702900003 | 37.7528984024518 | -122.385543550016 | (37.7528984024518, -122.385543550016) | |
140700 | 140700 | 88673 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
141049 | 141049 | 91471 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
141272 | 141272 | 91473 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
141518 | 141518 | 88683 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
144321 | 144321 | 91475 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
145817 | 145817 | 91476 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
154499 | 154499 | 88668 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51637 | 6016777.6314900005 | 2102112.60454 | 37.7529421634534 | -122.38485722789 | (37.7529421634534, -122.38485722789) | |
156099 | 156099 | 88662 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51637 | 6016419.5289900005 | 2102093.1245 | 37.7528688624307 | -122.386094267831 | (37.7528688624307, -122.386094267831) | |
170081 | 170081 | 88671 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016898.1799800005 | 2102118.1456400002 | 37.7529640448765 | -122.38444073025299 | (37.7529640448765, -122.384440730253) | |
178225 | 178225 | 88669 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016819.28345 | 2102114.55479 | 37.7529498220865 | -122.384713321982 | (37.7529498220865, -122.384713321982) | |
184278 | 184278 | 88667 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016620.614130001 | 2102104.21301 | 37.7529104362915 | -122.38539964408001 | (37.7529104362915, -122.38539964408) | |
185454 | 185454 | 88660 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016339.82415 | 2102089.15306 | 37.7528535460529 | -122.38636962767299 | (37.7528535460529, -122.386369627673) |
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");