Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
772 | 772 | 221430 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | ||
3394 | 3394 | 118348 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 3 | ||||||||
4354 | 4354 | 221470 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:30:00 AM | 1 | Width 3ft | 6005530.44166 | 2106496.00345 | 37.7643494583795 | -122.42406388114401 | (37.7643494583795, -122.424063881144) | ||
4392 | 4392 | 221453 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:40:00 PM | 1 | Width 3ft | 6005462.88888 | 2107675.99901 | 37.7675856309877 | -122.424381462352 | (37.7675856309877, -122.424381462352) | ||
4403 | 4403 | 221458 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:49:00 AM | 2 | Width 3ft | 6005493.2574 | 2107088.45627 | 37.7659740935515 | -122.424234630048 | (37.7659740935515, -122.424234630048) | ||
4523 | 4523 | 221496 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 12:00:00 AM | 2 | Width 3ft | 6005594.03058 | 2105332.56679 | 37.761158526170895 | -122.423761214331 | (37.7611585261709, -122.423761214331) | ||
5114 | 5114 | 152414 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005626.99355 | 2104746.96336 | 37.7595524574982 | -122.423605573157 | (37.7595524574982, -122.423605573157) | |||
32785 | 32785 | 221538 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005757.68157 | 2102409.38047 | 37.7531413749784 | -122.422987443927 | (37.7531413749784, -122.422987443927) | |||
39265 | 39265 | 201713 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 724 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015343.41284 | 2088314.94317 | 37.7149771465452 | -122.38885388790001 | (37.7149771465452, -122.3888538879) | |||
47639 | 47639 | 221528 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005788.731319999 | 2101828.76193 | 37.7515488824818 | -122.422838806667 | (37.7515488824818, -122.422838806667) | |||
48258 | 48258 | 221518 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005823.14172 | 2101242.96968 | 37.7499423731511 | -122.42267818684799 | (37.7499423731511, -122.422678186848) | |||
55253 | 55253 | 203291 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 11 Jules Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994415.48252 | 2089998.39973 | 37.7184173393668 | -122.461311125716 | (37.7184173393668, -122.461311125716) | |||
71884 | 71884 | 221560 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.42459 | 2102519.64651 | 37.7534669142699 | -122.42159904898001 | (37.7534669142699, -122.42159904898) | |||
80584 | 80584 | 110774 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 03:02:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
82614 | 82614 | 91242 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
84876 | 84876 | 91279 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1170x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005728.0 | 2102148.0 | 37.752422009696005 | -122.42307151190799 | (37.752422009696, -122.423071511908) | |||
112173 | 112173 | 43727 | Permitted Site 1 | Acacia stenophylla :: Shoestring Acacia 109 | 760 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | |||
113542 | 113542 | 110761 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:49:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
113634 | 113634 | 91283 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005738.0 | 2101906.0 | 37.7517580978369 | -122.42301973133999 | (37.7517580978369, -122.42301973134) | |||
115942 | 115942 | 221483 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005560.35948 | 2105916.5024900003 | 37.7627599750213 | -122.42391919281201 | (37.7627599750213, -122.423919192812) | |||
126273 | 126273 | 109695 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 12:00:00 AM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
128230 | 128230 | 110620 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:30:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
134735 | 134735 | 221425 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005689.68683 | 2103597.2936 | 37.7563992716189 | -122.42330702161301 | (37.7563992716189, -122.423307021613) | |||
135861 | 135861 | 221547 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005723.41397 | 2102999.7023 | 37.7547603282456 | -122.42314790545299 | (37.7547603282456, -122.423147905453) | |||
159637 | 159637 | 221417 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005673.16306 | 2103886.4908 | 37.7571924071266 | -122.42338472483101 | (37.7571924071266, -122.423384724831) | |||
179875 | 179875 | 221564 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001316.917769999 | 2102341.7359599997 | 37.7527040553705 | -122.438339609582 | (37.7527040553705, -122.438339609582) |
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");