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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2276 | 2276 | 252994 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
3405 | 3405 | 180669 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 171 Winding Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6002170.184219999 | 2086635.71157 | 37.70962739445179 | -122.434266111507 | (37.7096273944518, -122.434266111507) | |||
4134 | 4134 | 216704 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 251 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:35:00 AM | 3 | Width 2ft | 5994715.27121 | 2090263.18688 | 37.719161630891705 | -122.46029406262699 | (37.7191616308917, -122.460294062627) | ||
4205 | 4205 | 251774 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 10:14:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.7886599998 | 37.711579156239296 | -122.435864336264 | (37.7115791562393, -122.435864336264) | ||
4722 | 4722 | 160433 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 401 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:12:00 PM | 3 | Width 0ft | 6002070.28716 | 2089835.8834 | 37.7184086896908 | -122.43484007413 | (37.7184086896908, -122.43484007413) | |
4838 | 4838 | 243005 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 301 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 6ft | 6004912.59389 | 2106510.6516400003 | 37.7643547760633 | -122.42620188801001 | (37.7643547760633, -122.42620188801) | |||
26639 | 26639 | 117155 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014460.76675 | 2103748.99279 | 37.757306918684 | -122.392983929988 | (37.757306918684, -122.392983929988) | |||
31110 | 31110 | 101612 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 681 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 7x5 | 6011003.086019999 | 2105162.84205 | 37.7609963604006 | -122.40504155884399 | (37.7609963604006, -122.405041558844) | |||
36116 | 36116 | 75673 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 618X Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 7 | 6013545.06469 | 2104202.26889 | 37.7585006086339 | -122.396182576568 | (37.7585006086339, -122.396182576568) | ||
37611 | 37611 | 230424 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 387 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007831.12637 | 2105698.0394200003 | 37.76228806116921 | -122.41604991899099 | (37.7622880611692, -122.416049918991) | |||
44441 | 44441 | 230406 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010469.85138 | 2104738.84531 | 37.7598023377254 | -122.406855910494 | (37.7598023377254, -122.406855910494) | |||
53201 | 53201 | 230399 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 635 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6010446.039030001 | 2105294.43136 | 37.761326519519 | -122.406977425991 | (37.761326519519, -122.406977425991) | |||
55809 | 55809 | 123781 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992148.272480001 | 2110704.3151 | 37.775139717422704 | -122.47065517411998 | (37.7751397174227, -122.47065517412) | |||
58655 | 58655 | 202021 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013834.37055 | 2091185.2446599999 | 37.722774667999 | -122.39427065747101 | (37.722774667999, -122.394270657471) | |||
61446 | 61446 | 230417 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003609.08364 | 2095506.47935 | 37.7340661284367 | -122.42992536726801 | (37.7340661284367, -122.429925367268) | |||
70356 | 70356 | 193410 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 551 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010705.60274 | 2105553.4377099997 | 37.762052213957794 | -122.40609794748501 | (37.7620522139578, -122.406097947485) | |||
107887 | 107887 | 93247 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 990 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369.0 | 2103119.0 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | ||
119799 | 119799 | 94256 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2777X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.40957339028499 | (37.7597963985886, -122.409573390285) | |||
123112 | 123112 | 18993 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2965 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1999 12:00:00 AM | 3 | 3X3 | 6000621.16815 | 2115478.56365 | 37.7887348935356 | -122.441688325582 | (37.7887348935356, -122.441688325582) | ||
124081 | 124081 | 93240 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 600X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | ||
126378 | 126378 | 45656 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994244.0 | 2106639.0 | 37.764098399310704 | -122.463110607355 | (37.7640983993107, -122.463110607355) | |||
128958 | 128958 | 100007 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
130484 | 130484 | 193429 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014506.85634 | 2103858.18885 | 37.7576093076281 | -122.39283217206699 | (37.7576093076281, -122.392832172067) | |||
138541 | 138541 | 230402 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6010527.0507 | 2103856.48907 | 37.7573827855076 | -122.406595905697 | (37.7573827855076, -122.406595905697) | |||
145552 | 145552 | 96632 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1212 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2011 12:00:00 AM | Permit Number 767886 | 5993035.2 | 2107183.3 | 37.7655231963247 | -122.467331039359 | (37.7655231963247, -122.467331039359) | |||
151479 | 151479 | 193416 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015128.54714 | 2101843.94886 | 37.75211314410829 | -122.390541350608 | (37.7521131441083, -122.390541350608) | |||
154854 | 154854 | 177455 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001518.96973 | 2094154.72477 | 37.7302359329302 | -122.43705478235701 | (37.7302359329302, -122.437054782357) | |||
172396 | 172396 | 193422 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015855.7958 | 2105797.31045 | 37.763008553013 | -122.388302284235 | (37.763008553013, -122.388302284235) | |||
183298 | 183298 | 193436 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 608 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013540.38062 | 2104266.7592 | 37.758677424352896 | -122.39620329606899 | (37.7586774243529, -122.396203296069) | |||
186395 | 186395 | 193434 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 598 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013537.98707 | 2104307.6187400003 | 37.758789482567295 | -122.396214437761 | (37.7587894825673, -122.396214437761) |
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");