Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1573 | 1573 | 251597 | Landmark tree 9 | Ficus macrophylla :: Morton Bay Fig 148 | 1650 Valencia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6006336.0 | 2100501.0 | 37.747934015176504 | -122.42085202386299 | (37.7479340151765, -122.420852023863) | |||||
| 9987 | 9987 | 173779 | Significant Tree 6 | Ficus macrophylla :: Morton Bay Fig 148 | 99X Cleveland St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 32979 | 32979 | 61822 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 2749 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1985 12:00:00 AM | 88 | Permit Number 21854 | 5999853.53427 | 2118084.4694 | 37.7958462579399 | -122.44453158308201 | (37.7958462579399, -122.444531583082) | ||
| 53176 | 53176 | 593 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 3055 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6008560.02694 | 2102081.1908400003 | 37.7523979726269 | -122.413273137321 | (37.7523979726269, -122.413273137321) | |||
| 82159 | 82159 | 14816 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 1234 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003203.08523 | 2111751.85063 | 37.7786490478282 | -122.43248898077 | (37.7786490478282, -122.43248898077) | |||
| 83767 | 83767 | 9688 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 332 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6006025.5202 | 2110969.11106 | 37.7766594813407 | -122.42266943618799 | (37.7766594813407, -122.422669436188) | |||
| 83898 | 83898 | 7355 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 2301 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6002738.35026 | 2116220.4352 | 37.7908922847939 | -122.434416252231 | (37.7908922847939, -122.434416252231) | |||
| 84534 | 84534 | 4512 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 20X Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
| 87395 | 87395 | 14658 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 655X McAllister St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | |||
| 87886 | 87886 | 14659 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 655X McAllister St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | |||
| 90529 | 90529 | 10620 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 350 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6005978.95579 | 2110975.7557099997 | 37.7766750987359 | -122.422830988707 | (37.7766750987359, -122.422830988707) | |||
| 91511 | 91511 | 599 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 3077 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008567.5453 | 2102081.22398 | 37.7523984857225 | -122.413247139853 | (37.7523984857225, -122.413247139853) | |||
| 97410 | 97410 | 113742 | Landmark tree 9 | Ficus macrophylla :: Morton Bay Fig 148 | 1580 Valencia St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 80 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | ||||
| 101324 | 101324 | 51879 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 3552 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2016 12:00:00 AM | 3 | Permit Number 48096 | 6005953.65643869 | 2102602.75030728 | 37.7536833804238 | -122.422323460817 | (37.7536833804238, -122.422323460817) | ||
| 103179 | 103179 | 10619 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 350 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6006025.521509999 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | |||
| 106755 | 106755 | 24811 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 2142 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002873.2693 | 2115779.53407 | 37.789689340569204 | -122.43391791014099 | (37.7896893405692, -122.433917910141) | |||
| 115716 | 115716 | 26549 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 3085 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008510.86068 | 2102109.8045200002 | 37.7524737788845 | -122.413445186333 | (37.7524737788845, -122.413445186333) | |||
| 121165 | 121165 | 4514 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 20X Cleary Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
| 123686 | 123686 | 4511 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 20X Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
| 123770 | 123770 | 92387 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 2810 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52790 | 6001269.0 | 2116290.0 | 37.7909997773984 | -122.439505117215 | (37.7909997773984, -122.439505117215) | |||
| 126867 | 126867 | 115318 | Undocumented 2 | Ficus macrophylla :: Morton Bay Fig 148 | 3370 WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5998663.0 | 2115944.0 | 37.7899010948859 | -122.448496808995 | (37.7899010948859, -122.448496808995) | ||||
| 128736 | 128736 | 51880 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 3552 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2016 12:00:00 AM | 3 | Permit Number 48096 | 6005953.65643869 | 2102602.75030728 | 37.7536833804238 | -122.422323460817 | (37.7536833804238, -122.422323460817) | ||
| 140712 | 140712 | 10621 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 350 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006025.521509999 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | |||
| 142241 | 142241 | 4513 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 20X Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
| 142646 | 142646 | 27623 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 3085 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008510.86068 | 2102109.8045200002 | 37.7524737788845 | -122.413445186333 | (37.7524737788845, -122.413445186333) | |||
| 142833 | 142833 | 7367 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 2400 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002811.86324 | 2116558.11792 | 37.7918236474661 | -122.434186051668 | (37.7918236474661, -122.434186051668) | |||
| 146230 | 146230 | 7369 | DPW Maintained 3 | Ficus macrophylla :: Morton Bay Fig 148 | 2401 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 22 | 3X3 | 6002691.3684 | 2116552.51656 | 37.7918014280029 | -122.434602562579 | (37.7918014280029, -122.434602562579) |
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");