Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16011 | 16011 | 47239 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1004X Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013984.3411 | 2089670.3406 | 37.718623377888896 | -122.393646260173 | (37.7186233778889, -122.393646260173) |
| 30923 | 30923 | 188479 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2208 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010817.79084 | 2106032.71885 | 37.763374486260204 | -122.40574369103201 | (37.7633744862602, -122.405743691032) | |||
| 32711 | 32711 | 124322 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Jordan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5996192.87314 | 2113669.7360400003 | 37.7835150337529 | -122.456878613619 | (37.7835150337529, -122.456878613619) | |||
| 49414 | 49414 | 115847 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003582.67693 | 2120834.7351599997 | 37.80360985246121 | -122.431824529496 | (37.8036098524612, -122.431824529496) | |||
| 64383 | 64383 | 248208 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 37 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007034.71089 | 2099281.8609599997 | 37.744625892375396 | -122.41834947827101 | (37.7446258923754, -122.418349478271) | |||
| 65181 | 65181 | 248195 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006895.3062 | 2099022.5140400003 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | |||
| 69332 | 69332 | 225073 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 904 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009377.25257 | 2103854.7897900003 | 37.757313724754795 | -122.410572259011 | (37.7573137247548, -122.410572259011) | |||
| 72501 | 72501 | 225044 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007468.43971 | 2099454.94472 | 37.7451255476034 | -122.4168619861 | (37.7451255476034, -122.4168619861) | |||
| 76853 | 76853 | 225071 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009374.803830001 | 2103883.5621599997 | 37.7573925899019 | -122.410582759505 | (37.7573925899019, -122.410582759505) | |||
| 122019 | 122019 | 205987 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | |||
| 129912 | 129912 | 225061 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 5997502.5049 | 2105021.0962900002 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | |||
| 133409 | 133409 | 222927 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 912 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998760.527480001 | 2106841.60616 | 37.764913845009 | -122.44750390358 | (37.764913845009, -122.44750390358) | |||
| 158717 | 158717 | 61724 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.39430169937599 | (37.7307052783181, -122.394301699376) | |
| 170749 | 170749 | 189944 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 162 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014676.15778 | 2116259.76194 | 37.791670658917106 | -122.393114386531 | (37.7916706589171, -122.393114386531) | |||
| 178393 | 178393 | 225075 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3334 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007507.05129 | 2101513.0888099996 | 37.750778919809 | -122.416874263658 | (37.750778919809, -122.416874263658) | |||
| 179431 | 179431 | 189853 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.742069463331106 | -122.382594511142 | (37.7420694633311, -122.382594511142) |
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");