Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16169 | 16169 | 100329 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768623 | 6013411.2884599995 | 2111661.36797 | 37.7789741867392 | -122.39716827132 | (37.7789741867392, -122.39716827132) | |
| 16787 | 16787 | 100332 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768623 | 6013356.21451 | 2111717.71239 | 37.779125829518705 | -122.397362747904 | (37.7791258295187, -122.397362747904) | |
| 17378 | 17378 | 29984 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1622X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005923.58357 | 2099590.01571 | 37.7454094051301 | -122.422213431617 | (37.7454094051301, -122.422213431617) | ||
| 17649 | 17649 | 30005 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 795X San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005615.08127 | 2098546.14287 | 37.7425257613504 | -122.423205996259 | (37.7425257613504, -122.423205996259) | ||
| 19536 | 19536 | 29706 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005915.3087 | 2099718.0441099997 | 37.745760475271204 | -122.422251139273 | (37.7457604752712, -122.422251139273) | |||
| 19998 | 19998 | 30014 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 738X San Jose Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005753.20487 | 2098967.8779700003 | 37.7436915444264 | -122.422758369527 | (37.7436915444264, -122.422758369527) | ||
| 20337 | 20337 | 29707 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005916.90216 | 2099727.1189900003 | 37.74578548271 | -122.422246273943 | (37.74578548271, -122.422246273943) | |||
| 20789 | 20789 | 29999 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 681X San Jose Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005890.72277 | 2099411.68829 | 37.7449179049514 | -122.422314391296 | (37.7449179049514, -122.422314391296) | ||
| 21577 | 21577 | 30015 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 738X San Jose Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005757.33905 | 2098980.75435 | 37.7437271333024 | -122.422744989392 | (37.7437271333024, -122.422744989392) | ||
| 21879 | 21879 | 29710 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005894.4456400005 | 2100106.5973900002 | 37.7468261772965 | -122.422350883111 | (37.7468261772965, -122.422350883111) | |||
| 22067 | 22067 | 16311 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 3 | 5 | 5997346.34886 | 2094713.5127 | 37.7315321725506 | -122.45152030461901 | (37.7315321725506, -122.451520304619) | ||
| 40866 | 40866 | 225175 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3309 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008515.82219 | 2099330.37365 | 37.7448423609829 | -122.41323150034901 | (37.7448423609829, -122.413231500349) | |||
| 45931 | 45931 | 190000 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 770 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6012104.84568 | 2104756.14819 | 37.7599411975544 | -122.401202450128 | (37.7599411975544, -122.401202450128) | |||
| 66694 | 66694 | 225148 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1199 Capp St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6007231.69522 | 2100624.49408 | 37.7483235475968 | -122.417763493512 | (37.7483235475968, -122.417763493512) | |||
| 137477 | 137477 | 189995 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1301 Minnesota St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015392.22277 | 2102247.2850900004 | 37.753235244428204 | -122.389657680355 | (37.7532352444282, -122.389657680355) | ||||
| 158218 | 158218 | 190007 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012984.44615 | 2103792.30277 | 37.7573437216454 | -122.398092698838 | (37.7573437216454, -122.398092698838) | ||||
| 172254 | 172254 | 190033 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 651 Missouri St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6013606.61157 | 2104092.53416 | 37.7582027253025 | -122.39596202861901 | (37.7582027253025, -122.395962028619) |
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");