Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237 | 3237 | 139408 | DPW Maintained 3 | Podocarpus gracilor :: Fern Pine 13 | 1500 GEARY BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1999 12:00:00 AM | 3 | Width 0ft | 6004238.7982 | 2114043.3981 | 37.7849997446788 | -122.429069479335 | (37.7849997446788, -122.429069479335) | ||
3994 | 3994 | 159208 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 210 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:54:00 AM | 3 | Width 0ft | 5998556.96811 | 2088452.2606799998 | 37.714409480083496 | -122.446884596259 | (37.7144094800835, -122.446884596259) | ||
3999 | 3999 | 181035 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 170 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:20:00 PM | 3 | Width 4ft | 6000927.8060099995 | 2088408.3131900001 | 37.7144239699579 | -122.438686909772 | (37.7144239699579, -122.438686909772) | ||
4055 | 4055 | 251746 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 700 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:33:00 AM | 3 | 3x3 | 6002943.0 | 2087289.0 | 37.711465016812205 | -122.431641737098 | (37.7114650168122, -122.431641737098) | ||
4078 | 4078 | 253099 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 210 Foote Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:59:00 AM | 3 | Width 0ft | 5998556.96811 | 2088452.2606799998 | 37.714409480083496 | -122.446884596259 | (37.7144094800835, -122.446884596259) | ||
4083 | 4083 | 181036 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 170 Rolph St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:16:00 PM | 3 | Width 4ft | 6000944.46471 | 2088397.62402 | 37.7143955675655 | -122.438628565353 | (37.7143955675655, -122.438628565353) | ||
4157 | 4157 | 216804 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 297 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:14:00 PM | 3 | Width 2ft | 5994075.3134 | 2088701.73413 | 37.7148374215779 | -122.462392942697 | (37.7148374215779, -122.462392942697) | ||
4229 | 4229 | 252890 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 301x Howth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:50:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
4261 | 4261 | 252888 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 301x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:03:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
4284 | 4284 | 175543 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 187 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:37:00 AM | 3 | Width 6ft | 6001178.343719999 | 2087386.3168 | 37.7116320444605 | -122.43774780171302 | (37.7116320444605, -122.437747801713) | ||
4513 | 4513 | 69411 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 400 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2017 12:00:00 PM | 3 | Permit Number 33516 | 6002017.91695 | 2087759.8378400002 | 37.712705354746106 | -122.43487271052601 | (37.7127053547461, -122.434872710526) | |
4627 | 4627 | 160610 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2017 04:01:00 PM | 3 | Width 0ft | 6002805.02204 | 2089330.87742 | 37.717063742780496 | -122.432264357312 | (37.7170637427805, -122.432264357312) | ||
4644 | 4644 | 160608 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:37:00 PM | 3 | Width 0ft | 6002772.883169999 | 2089351.94517 | 37.717119767831505 | -122.43237694973499 | (37.7171197678315, -122.432376949735) | |
4671 | 4671 | 160609 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2017 03:56:00 PM | 3 | Width 0ft | 6002789.45595 | 2089340.3546099998 | 37.71708888243629 | -122.432318838255 | (37.7170888824363, -122.432318838255) | ||
4686 | 4686 | 160611 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 04:11:00 PM | 3 | Width 0ft | 6002821.1864599995 | 2089320.8920099998 | 37.717037241564 | -122.432207771993 | (37.717037241564, -122.432207771993) | |
5242 | 5242 | 243740 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 550 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 776473 | 6003047.0557699995 | 2096015.8076799999 | 37.7354327831918 | -122.431904827248 | (37.7354327831918, -122.431904827248) | |
9792 | 9792 | 159358 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 49 Naglee Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998584.62871 | 2087583.8857099998 | 37.712026700246 | -122.446726546692 | (37.712026700246, -122.446726546692) | |
19691 | 19691 | 108972 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772927 | 6005770.7 | 2106026.5 | 37.7630738748169 | -122.42319951773399 | (37.7630738748169, -122.423199517734) |
20659 | 20659 | 53568 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 712 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2014 12:00:00 AM | 3 | 6x7 | Permit Number 774472 | 6002289.86675011 | 2108835.21130526 | 37.7705888548661 | -122.43543945468201 | (37.7705888548661, -122.435439454682) | |
43092 | 43092 | 31665 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1813 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 3 | Permit Number 35173 | 6006528.4802 | 2117109.7376 | 37.7935484974802 | -122.42136572658 | (37.7935484974802, -122.42136572658) | ||
79358 | 79358 | 108613 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 859 Moultrie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774597 | 6007577.26936 | 2095354.40031 | 37.7338724793659 | -122.416195309142 | (37.7338724793659, -122.416195309142) | |
82791 | 82791 | 109234 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773192 | 6004570.0 | 2097679.6 | 37.7400873981114 | -122.426757883918 | (37.7400873981114, -122.426757883918) |
84341 | 84341 | 107502 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 998 CHESTNUT ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773456 | 6007102.0 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | ||
84422 | 84422 | 107419 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
85088 | 85088 | 107418 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
85920 | 85920 | 107894 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 230X 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998916999 | (37.7726012817916, -122.41519998917) | |
87384 | 87384 | 86799 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 71 Miguel St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 49752 | 6003860.0 | 2097292.0 | 37.738982969029706 | -122.429185143196 | (37.7389829690297, -122.429185143196) | ||
92996 | 92996 | 94678 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 160 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778668 | 6004537.0 | 2097560.0 | 37.7397571378771 | -122.426863468968 | (37.7397571378771, -122.426863468968) |
100439 | 100439 | 107897 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 230X 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998916999 | (37.7726012817916, -122.41519998917) | |
101375 | 101375 | 115332 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 777441 | 5995305.9 | 2110591.8 | 37.7750128688555 | -122.459724160308 | (37.7750128688555, -122.459724160308) | ||
101634 | 101634 | 115378 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 42 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777462 | 6005449.5 | 2096333.6 | 37.7364412712621 | -122.42362125502599 | (37.7364412712621, -122.423621255026) | ||
102623 | 102623 | 107896 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 230X 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998916999 | (37.7726012817916, -122.41519998917) | |
103849 | 103849 | 107895 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 230X 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998916999 | (37.7726012817916, -122.41519998917) | |
104808 | 104808 | 107501 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 998 CHESTNUT ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773456 | 6007102.0 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | ||
108358 | 108358 | 108818 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 583 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774655 | 6002868.5584 | 2090237.17355 | 37.7195558341056 | -122.43210942658199 | (37.7195558341056, -122.432109426582) | |
109171 | 109171 | 115383 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 324 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | ||
110461 | 110461 | 109413 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 114 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773149 | 6006968.5 | 2095329.1 | 37.7337687610147 | -122.41829822041201 | (37.7337687610147, -122.418298220412) |
117298 | 117298 | 108904 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772986 | 6008567.7 | 2096169.9 | 37.7361673058735 | -122.41282871497101 | (37.7361673058735, -122.412828714971) |
120453 | 120453 | 117448 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776857 | 6007658.8 | 2115857.7 | 37.7901743736919 | -122.417365949941 | (37.7901743736919, -122.417365949941) | ||
126808 | 126808 | 115377 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 42 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777462 | 6005449.5 | 2096333.6 | 37.7364412712621 | -122.42362125502599 | (37.7364412712621, -122.423621255026) | ||
138319 | 138319 | 107893 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 73X Kissling St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998916999 | (37.7726012817916, -122.41519998917) |
140378 | 140378 | 107415 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
140998 | 140998 | 115320 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 775637 | 5992882.5 | 2111642.9 | 37.7777592485634 | -122.468183632004 | (37.7777592485634, -122.468183632004) | ||
142964 | 142964 | 107417 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
145801 | 145801 | 107416 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
187690 | 187690 | 141703 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 116 STANYAN BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5996565.9306 | 2112209.0509 | 37.7795257936095 | -122.45548237999901 | (37.7795257936095, -122.455482379999) |
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");