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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1748 | 1748 | 17869 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2132 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 12 | 3X3 | 6003712.3639 | 2115281.4031 | 37.788369180682295 | -122.430979161307 | (37.7883691806823, -122.430979161307) | ||
| 6782 | 6782 | 42639 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1651 Union St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/2014 12:00:00 AM | 8 | 3x3 | Permit Number 42688 | 6005258.416780001 | 2118846.41372 | 37.798245281357204 | -122.425883928195 | (37.7982452813572, -122.425883928195) |
| 11215 | 11215 | 75214 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x5 | 6002868.59368 | 2092460.8085599998 | 37.725661442297294 | -122.432268027453 | (37.7256614422973, -122.432268027453) | |
| 12861 | 12861 | 75133 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x4 | 6002899.19862 | 2092441.61812 | 37.7256104849218 | -122.43216085884501 | (37.7256104849218, -122.432160858845) | |
| 13648 | 13648 | 25580 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1511 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6016141.48149 | 2097069.66658 | 37.7390600907376 | -122.386705539738 | (37.7390600907376, -122.386705539738) | |||
| 22254 | 22254 | 16148 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 383 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1998 12:00:00 AM | 3 | 3X3 | 5999549.4531 | 2094641.0103799999 | 37.7314590136113 | -122.443898565568 | (37.7314590136113, -122.443898565568) | ||
| 24426 | 24426 | 11480 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10X Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 1 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | ||
| 52863 | 52863 | 193537 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2x Dukes Ct | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6016137.541569999 | 2096287.1710299999 | 37.736911298305394 | -122.386664611588 | (37.7369112983054, -122.386664611588) | ||||
| 64916 | 64916 | 193539 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2x Dukes Ct | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 53 | 6016139.60304 | 2096356.71022 | 37.7371023529977 | -122.3866623318 | (37.7371023529977, -122.3866623318) | ||||
| 78332 | 78332 | 11476 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 6 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | ||
| 80896 | 80896 | 11479 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10X Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | ||
| 86699 | 86699 | 32726 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 20 | 6x9 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
| 87708 | 87708 | 32729 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
| 98638 | 98638 | 11485 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10X Jennings St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | ||
| 117844 | 117844 | 24729 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 7426 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2002 12:00:00 AM | 3 | 3X3 | 5983935.56611 | 2112495.9733599997 | 37.7795807585716 | -122.49919672398701 | (37.7795807585716, -122.499196723987) | ||
| 119394 | 119394 | 42643 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600X GREEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 12 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 119826 | 119826 | 11490 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 100 Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 142357 | 142357 | 42987 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 8 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 142877 | 142877 | 16478 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 9X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 6 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | ||
| 145909 | 145909 | 42986 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 3 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 167021 | 167021 | 193538 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2x Dukes Ct | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016137.39736 | 2096296.36368 | 37.7369365314813 | -122.386665751027 | (37.7369365314813, -122.386665751027) |
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");