Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1317 | 1317 | 14834 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1288 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003007.4145 | 2111705.9811 | 37.7785120037891 | -122.433162602474 | (37.7785120037891, -122.433162602474) | |||
| 6353 | 6353 | 20138 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002950.7346 | 2111726.0933 | 37.7785640114636 | -122.43336011714199 | (37.7785640114636, -122.433360117142) | |||
| 6554 | 6554 | 20146 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1006 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002941.3315 | 2111813.3334 | 37.7788030175273 | -122.43339888180901 | (37.7788030175273, -122.433398881809) | |||
| 7183 | 7183 | 20140 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | Permit Number 770990 | 6002946.5554 | 2111769.9745 | 37.7786842611853 | -122.433377711101 | (37.7786842611853, -122.433377711101) | ||
| 7593 | 7593 | 20139 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002949.1674 | 2111752.2131 | 37.7786356410017 | -122.433367405651 | (37.7786356410017, -122.433367405651) | |||
| 7959 | 7959 | 14833 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1288 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003019.4296 | 2111708.0707 | 37.7785184228745 | -122.43312118705799 | (37.7785184228745, -122.433121187058) | |||
| 8779 | 8779 | 20145 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1006 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002942.8987 | 2111794.0047 | 37.778750034657605 | -122.433392078669 | (37.7787500346576, -122.433392078669) | |||
| 11194 | 11194 | 15688 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 4199 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1995 12:00:00 AM | 3 | 3X3 | 6003628.481269999 | 2094078.5751200002 | 37.7301465241442 | -122.429756492581 | (37.7301465241442, -122.429756492581) | ||
| 12135 | 12135 | 15689 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 4199 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1995 12:00:00 AM | 3 | 3X3 | 6003642.63298 | 2094097.24722 | 37.7301985948914 | -122.429708899543 | (37.7301985948914, -122.429708899543) | ||
| 12544 | 12544 | 24857 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1996 12:00:00 AM | 20 | 3X3 | 6010898.5282 | 2093826.1579 | 37.7298624387628 | -122.404605107856 | (37.7298624387628, -122.404605107856) | ||
| 14472 | 14472 | 12222 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1543 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6015840.7459 | 2095893.0455 | 37.7358126735457 | -122.387663285334 | (37.7358126735457, -122.387663285334) | ||
| 17079 | 17079 | 4224 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3978 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1995 12:00:00 AM | 3 | 3X3 | 6004063.19493 | 2100446.35832 | 37.74765561211429 | -122.428707390249 | (37.7476556121143, -122.428707390249) | ||
| 17612 | 17612 | 28717 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 593 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002404.32296 | 2104787.5580599997 | 37.759481486596705 | -122.434754058477 | (37.7594814865967, -122.434754058477) | |
| 17760 | 17760 | 614 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 3130 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6008131.4648 | 2102133.22317 | 37.752516771554205 | -122.41475886214899 | (37.7525167715542, -122.414758862149) | |||
| 18121 | 18121 | 28716 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 588 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002337.13955 | 2104792.2766299997 | 37.7594906282039 | -122.43498674903499 | (37.7594906282039, -122.434986749035) | |
| 19344 | 19344 | 26197 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 519 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | Permit Number 772904 | 6002381.63954 | 2105165.88105 | 37.76051898227939 | -122.434859564238 | (37.7605189822794, -122.434859564238) | ||
| 19871 | 19871 | 16685 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250X Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/25/2010 12:00:00 AM | 3 | 3X3 | 6002901.6582 | 2106832.0518 | 37.7651233950804 | -122.43318011235 | (37.7651233950804, -122.43318011235) | ||
| 20194 | 20194 | 18470 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1221 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2003 12:00:00 AM | 12 | 3X3 | 6010619.64201 | 2102143.08548 | 37.752683339465705 | -122.406154975289 | (37.7526833394657, -122.406154975289) | ||
| 20204 | 20204 | 16686 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250X Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1998 12:00:00 AM | 3 | 3X3 | 6002901.0969 | 2106818.0205 | 37.7650848366999 | -122.433181051108 | (37.7650848366999, -122.433181051108) | ||
| 21065 | 21065 | 28710 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 420 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2004 12:00:00 AM | 6 | 3X3 | Permit Number 772904 | 6002287.50765 | 2105730.51136 | 37.7620639753051 | -122.435225510065 | (37.7620639753051, -122.435225510065) | |
| 22136 | 22136 | 28718 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 597 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002404.2246199995 | 2104762.59172 | 37.759412929468496 | -122.434752613241 | (37.7594129294685, -122.434752613241) | |
| 96378 | 96378 | 24937 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2591 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 16 | 3X3 | 6011042.037930001 | 2093526.3228 | 37.7290471738075 | -122.404087882402 | (37.7290471738075, -122.404087882402) |
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");