Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295 | 295 | 230413 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 310 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:33:00 AM | 1 | Width 7ft | 6004826.22566 | 2106515.9879900003 | 37.7643645463025 | -122.42650099174601 | (37.7643645463025, -122.426500991746) | ||
1839 | 1839 | 251756 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 233 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001887.0 | 2086528.0 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | ||||
2289 | 2289 | 252993 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 2 | 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) | |||
4279 | 4279 | 78830 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 35 Laura St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/2017 04:01:00 PM | 3 | 5997431.0713 | 2086896.39523 | 37.7100730444948 | -122.450664016958 | (37.7100730444948, -122.450664016958) | ||
4368 | 4368 | 251755 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 101X Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:50:00 AM | 3 | 3x3 | 6001862.0 | 2086566.0 | 37.709418484595 | -122.43532626528601 | (37.709418484595, -122.435326265286) | ||
4632 | 4632 | 160422 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 591 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:59:00 PM | 3 | Width 0ft | 6002364.11048 | 2089653.5699900002 | 37.7179247752893 | -122.43381142685 | (37.7179247752893, -122.43381142685) | |
14228 | 14228 | 46416 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 700 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015974.86179 | 2105759.1893599997 | 37.7629104774528 | -122.38788781187701 | (37.7629104774528, -122.387887811877) | |
18980 | 18980 | 5478 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 655 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2013 12:00:00 AM | 2 | 3X3 | 6005024.7062 | 2104455.06021 | 37.7587169450524 | -122.42566780763501 | (37.7587169450524, -122.425667807635) | ||
21177 | 21177 | 18475 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1260 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010550.213330001 | 2101942.07688 | 37.75212753057279 | -122.406380911075 | (37.7521275305728, -122.406380911075) | ||
26689 | 26689 | 193419 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 610 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015956.40459 | 2106139.49843 | 37.763953701820604 | -122.387978189259 | (37.7639537018206, -122.387978189259) | |||
54038 | 54038 | 202020 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013858.20959 | 2091166.1399 | 37.7227235352339 | -122.39418691350599 | (37.7227235352339, -122.394186913506) | |||
58037 | 58037 | 193432 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 572 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013532.897999999 | 2104416.8953299997 | 37.759089249099105 | -122.39623969701401 | (37.7590892490991, -122.396239697014) | |||
58293 | 58293 | 193413 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2200 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011171.17043 | 2105584.0111700003 | 37.7621621911485 | -122.404489872412 | (37.7621621911485, -122.404489872412) | |||
60282 | 60282 | 193428 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014491.22334 | 2103857.32403 | 37.7576060646987 | -122.392886177259 | (37.7576060646987, -122.392886177259) | |||
61175 | 61175 | 117154 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014461.75742 | 2103731.13458 | 37.757257938912 | -122.3929792544 | (37.757257938912, -122.3929792544) | |||
63489 | 63489 | 177454 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001501.639719999 | 2094151.35591 | 37.730225697742796 | -122.43711445328998 | (37.7302256977428, -122.43711445329) | |||
67572 | 67572 | 123782 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992174.172809999 | 2110703.76964 | 37.7751397174253 | -122.470565540203 | (37.7751397174253, -122.470565540203) | |||
74087 | 74087 | 230423 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 387 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007832.95914 | 2105672.86461 | 37.7622190400112 | -122.416041797198 | (37.7622190400112, -122.416041797198) | |||
75391 | 75391 | 230416 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003629.87373 | 2095518.0627099997 | 37.734099111076496 | -122.429854315422 | (37.7340991110765, -122.429854315422) | |||
85349 | 85349 | 87807 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 291 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50584 | 5987096.8 | 2114028.5 | 37.783973582398794 | -122.48837346173 | (37.7839735823988, -122.48837346173) | |
85527 | 85527 | 58794 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1979 12:00:00 AM | Permit Number 18041 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
86642 | 86642 | 39178 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1050 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |
91544 | 91544 | 93246 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 990 Church St | 2 | 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) | ||
97825 | 97825 | 93239 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 600X Church St | 2 | 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) | ||
116397 | 116397 | 94257 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2777X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.40957339028499 | (37.7597963985886, -122.409573390285) | |||
118040 | 118040 | 109566 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 56 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821.0 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) |
118297 | 118297 | 45655 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 Irving St | 2 | 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) | |||
119015 | 119015 | 8129 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 899 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2013 12:00:00 AM | 12 | 3X3 | Permit Number 770378 | 6003470.39544 | 2111382.10126 | 37.7776489625125 | -122.431537848369 | (37.7776489625125, -122.431537848369) | |
124084 | 124084 | 117301 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2238 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.49182069563601 | (37.7453216318219, -122.491820695636) | ||
124691 | 124691 | 100003 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 2 | 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) | |||
140028 | 140028 | 115265 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1634 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.47974063936701 | (37.7571489820097, -122.479740639367) | |||
144968 | 144968 | 17872 | Section 143 8 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2148 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/21/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53638 | 6003654.7045158 | 2115269.5781823 | 37.788333445178104 | -122.43117780902399 | (37.7883334451781, -122.431177809024) |
146792 | 146792 | 101611 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 681 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 6011008.341990001 | 2105144.37638 | 37.7609459516243 | -122.40502208042 | (37.7609459516243, -122.40502208042) | |||
159837 | 159837 | 193415 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015129.4675 | 2101818.79874 | 37.75204413825129 | -122.390536410622 | (37.7520441382513, -122.390536410622) | |||
162305 | 162305 | 230396 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 675 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010452.66825 | 2105159.82839 | 37.7609573010551 | -122.406945010817 | (37.7609573010551, -122.406945010817) | |||
170086 | 170086 | 37947 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 255 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40187 | 6013212.35398 | 2105880.56458 | 37.7630903220716 | -122.39745094713001 | (37.7630903220716, -122.39745094713) | |
175041 | 175041 | 193421 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015817.08868 | 2105796.2011 | 37.763003362128 | -122.38843608266899 | (37.763003362128, -122.388436082669) | |||
175478 | 175478 | 230405 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010473.72719 | 2104680.02328 | 37.7596410425128 | -122.406838360202 | (37.7596410425128, -122.406838360202) | |||
187968 | 187968 | 193409 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 551 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010674.14728 | 2105512.6689400002 | 37.7619385126714 | -122.40620386783701 | (37.7619385126714, -122.406203867837) |
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");