Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4850 | 4850 | 5460 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 595 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/27/2017 12:00:00 AM | 3 | 3X3 | 6005000.81386 | 2104899.04779 | 37.759934680147296 | -122.425782040418 | (37.7599346801473, -122.425782040418) | ||
| 13313 | 13313 | 2990 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 2266X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003475.85532 | 2115607.4866 | 37.7892511192874 | -122.43182073435601 | (37.7892511192874, -122.431820734356) | |||
| 17057 | 17057 | 18389 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 852 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/2005 12:00:00 AM | 3 | 3x3 | 6010416.63719 | 2104254.1287700003 | 37.7584684371764 | -122.407005787885 | (37.7584684371764, -122.407005787885) | ||
| 17257 | 17257 | 18477 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1290 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/1991 12:00:00 AM | 18 | 3x3 | 6010548.57225 | 2101900.54788 | 37.752013409302705 | -122.406383660293 | (37.7520134093027, -122.406383660293) | ||
| 17563 | 17563 | 687 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1299X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010636.022580001 | 2101844.6913400004 | 37.75186493122229 | -122.40607730804199 | (37.7518649312223, -122.406077308042) | |||
| 18002 | 18002 | 5408 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 398 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2012 12:00:00 AM | 5 | 3x3 | 6004847.1008 | 2106094.6203 | 37.763208751117396 | -122.426398786502 | (37.7632087511174, -122.426398786502) | ||
| 18052 | 18052 | 18369 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 635 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2016 12:00:00 AM | 3 | 4X4 | 6010448.75923 | 2105261.1592 | 37.761235313885706 | -122.406965672731 | (37.7612353138857, -122.406965672731) | ||
| 18185 | 18185 | 82828 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1590X Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | ||
| 20166 | 20166 | 5434 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 500X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/14/2009 12:00:00 AM | 3 | 6 | 6004889.66204 | 2105352.28361 | 37.7611728766429 | -122.426198728713 | (37.7611728766429, -122.426198728713) | ||
| 21461 | 21461 | 5433 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 500X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2008 12:00:00 AM | 3 | 6 | 6004888.034519999 | 2105376.13123 | 37.76123826456529 | -122.42620605546301 | (37.7612382645653, -122.426206055463) | ||
| 21509 | 21509 | 18378 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 732 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/31/2012 12:00:00 AM | 3 | 3x3 | 6010381.26044 | 2104876.29383 | 37.760174782967404 | -122.407171993386 | (37.7601747829674, -122.407171993386) | ||
| 21935 | 21935 | 18479 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1290 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/1991 12:00:00 AM | 18 | 3x3 | 6010549.62955 | 2101874.40132 | 37.75194167576571 | -122.40637816183799 | (37.7519416757657, -122.406378161838) | ||
| 22209 | 22209 | 18379 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 744 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/2005 12:00:00 AM | 3 | 3X4 | 6010385.6799800005 | 2104816.8587 | 37.7600118348065 | -122.40715251859301 | (37.7600118348065, -122.407152518593) | ||
| 23656 | 23656 | 100189 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 160 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 772698 | 5995944.7835 | 2113256.71049 | 37.782366726791295 | -122.457707006716 | (37.7823667267913, -122.457707006716) | ||
| 24306 | 24306 | 230371 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1298 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 6011383.11883 | 2102397.34825 | 37.753424164099 | -122.403532609747 | (37.753424164099, -122.403532609747) | |||
| 24714 | 24714 | 31537 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1364 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | 8 | Permit Number 35088 | 6011407.03261 | 2101949.80473 | 37.752196643481604 | -122.403418427315 | (37.7521966434816, -122.403418427315) | |
| 26580 | 26580 | 31702 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 320 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2016 12:00:00 AM | 8 | 3x3 | Permit Number 775273 | 5998457.5854 | 2107603.3505 | 37.766988085426505 | -122.448606565306 | (37.7669880854265, -122.448606565306) |
| 28565 | 28565 | 31536 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1360 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 11 | Permit Number 35087 | 6011404.38341 | 2101989.62813 | 37.752305841845605 | -122.40343039011101 | (37.7523058418456, -122.403430390111) | |
| 30828 | 30828 | 193401 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 151 Napoleon St | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012860.78478 | 2100025.51981 | 37.7469940609376 | -122.39825609664601 | (37.7469940609376, -122.398256096646) | |||
| 33191 | 33191 | 193385 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1701 19th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012546.6255 | 2105147.54735 | 37.7610405297218 | -122.399702020336 | (37.7610405297218, -122.399702020336) | |||
| 36743 | 36743 | 230359 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 74 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6005616.74873 | 2108631.0205599996 | 37.7702165787549 | -122.42391719903401 | (37.7702165787549, -122.423917199034) | |||
| 38775 | 38775 | 193381 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1800 20th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6012498.39561 | 2104730.49879 | 37.7598927177809 | -122.399839541976 | (37.7598927177809, -122.399839541976) | |||
| 40027 | 40027 | 193382 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1800 20th St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6012480.76033 | 2104730.48315 | 37.7598916916751 | -122.39990053310801 | (37.7598916916751, -122.399900533108) | |||
| 40234 | 40234 | 64113 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 155 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/2006 12:00:00 AM | 7 | Permit Number 24881 | 6013197.0039 | 2106190.5600099997 | 37.763940646370294 | -122.397525780603 | (37.7639406463703, -122.397525780603) | |
| 40969 | 40969 | 193383 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1701 19th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6012488.23279 | 2105143.9346 | 37.7610273546478 | -122.39990372297599 | (37.7610273546478, -122.399903722976) | |||
| 43084 | 43084 | 193404 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 151 Napoleon St | 15 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012914.94166 | 2100028.77373 | 37.7470060120314 | -122.39806905386601 | (37.7470060120314, -122.398069053866) | |||
| 44137 | 44137 | 70654 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 2405 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 9 | 6010594.69956 | 2105501.50012 | 37.761903401339396 | -122.40647786067801 | (37.7619034013394, -122.406477860678) | ||
| 44220 | 44220 | 46979 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1310 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 3 | Permit Number 44998 | 6015318.4768 | 2102468.70414 | 37.753839124779205 | -122.38992817666401 | (37.7538391247792, -122.389928176664) | ||
| 45539 | 45539 | 100348 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 622 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 1 | 8x10 | Permit Number 769139 | 6013248.11312 | 2104189.7017900003 | 37.758449574805105 | -122.397208694044 | (37.7584495748051, -122.397208694044) | |
| 46203 | 46203 | 230360 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 9 Scott St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002397.510369999 | 2108386.59466 | 37.7693631769914 | -122.435035024651 | (37.7693631769914, -122.435035024651) | |||
| 47044 | 47044 | 230370 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1298 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 6011381.02251 | 2102414.42534 | 37.753470936941596 | -122.40354106069401 | (37.7534709369416, -122.403541060694) | |||
| 53108 | 53108 | 230374 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 725 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008540.74616 | 2104312.6152 | 37.7585238758885 | -122.413497615138 | (37.7585238758885, -122.413497615138) | |||
| 54239 | 54239 | 230372 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1248 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010819.236769999 | 2102490.41358 | 37.7536481879148 | -122.405489197274 | (37.7536481879148, -122.405489197274) | |||
| 54273 | 54273 | 230367 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 66 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6006268.47063 | 2099645.39127 | 37.7455809013368 | -122.421024796751 | (37.7455809013368, -122.421024796751) | |||
| 55202 | 55202 | 193389 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 357 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 6ft | 6013519.95695 | 2105414.95396 | 37.7618289797317 | -122.39635440822701 | (37.7618289797317, -122.396354408227) | |||
| 55739 | 55739 | 230366 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 62 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 6006279.39712 | 2099668.2568099997 | 37.7456443008565 | -122.420988637738 | (37.7456443008565, -122.420988637738) | |||
| 58266 | 58266 | 230358 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 48 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6005612.30306 | 2108731.67387 | 37.770492697607295 | -122.423939735133 | (37.7704926976073, -122.423939735133) | |||
| 59796 | 59796 | 230365 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 398 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 7ft | 6004848.8503 | 2106072.66034 | 37.7631485531897 | -122.426391171909 | (37.7631485531897, -122.426391171909) | |||
| 62527 | 62527 | 193378 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1301 Minnesota St | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015354.84712 | 2102508.01149 | 37.7539490714005 | -122.38980514398999 | (37.7539490714005, -122.38980514399) | ||||
| 62591 | 62591 | 230361 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1294 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010548.423769999 | 2101854.23832 | 37.7518862451648 | -122.406380911045 | (37.7518862451648, -122.406380911045) | |||
| 63118 | 63118 | 193400 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 151 Napoleon St | 11 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012842.918219999 | 2100024.61277 | 37.7469905751716 | -122.398317814431 | (37.7469905751716, -122.398317814431) | |||
| 63901 | 63901 | 37941 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 730 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | 2 | Permit Number 40183 | 6015640.36164 | 2103965.71 | 37.7579674311726 | -122.388919522216 | (37.7579674311726, -122.388919522216) | ||
| 69219 | 69219 | 193379 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 500 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 9ft | 6012632.72668 | 2105144.08354 | 37.7610358181789 | -122.39940398859699 | (37.7610358181789, -122.399403988597) | |||
| 69374 | 69374 | 87165 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 70690 | 70690 | 61585 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 748 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 10 | Permit Number 21549 | 6012696.34573 | 2104009.38799 | 37.7579237394054 | -122.39910430751199 | (37.7579237394054, -122.399104307512) | |
| 76420 | 76420 | 193380 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 572 Wisconsin St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6012652.42015 | 2104742.48091 | 37.7599342035261 | -122.399307683824 | (37.7599342035261, -122.399307683824) | |||
| 78163 | 78163 | 87160 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 78944 | 78944 | 68470 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 2693 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52653 | 6010006.82390597 | 2103360.38504848 | 37.755991476144295 | -122.408360072526 | (37.7559914761443, -122.408360072526) | ||
| 79038 | 79038 | 107302 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 333 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2014 12:00:00 AM | Permit Number 767149 | 6015127.71951 | 2114620.09555 | 37.7871935864977 | -122.39143729580799 | (37.7871935864977, -122.391437295808) | |||
| 79424 | 79424 | 87164 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 79664 | 79664 | 37176 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 66 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53571 | 6006281.21006007 | 2099680.48261535 | 37.7456779723428 | -122.420983236738 | (37.7456779723428, -122.420983236738) | ||
| 81935 | 81935 | 115166 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 402 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775277 | 5998511.59251 | 2106738.31574 | 37.7646160064689 | -122.448357464082 | (37.7646160064689, -122.448357464082) | |||
| 82538 | 82538 | 92105 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1398 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52306 | 6016081.4 | 2093420.8 | 37.7290377092769 | -122.38665890051399 | (37.7290377092769, -122.386658900514) | ||
| 82742 | 82742 | 87168 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 84358 | 84358 | 110035 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 160 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | Permit Number 775209 | 5997364.1 | 2109993.9 | 37.77348933368629 | -122.45256127909599 | (37.7734893336863, -122.452561279096) | |
| 85529 | 85529 | 82261 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 850 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 4 | 4x4 | Permit Number 768603 | 6007525.28639452 | 2104705.22805815 | 37.759544830410704 | -122.417037358657 | (37.7595448304107, -122.417037358657) |
| 85769 | 85769 | 87166 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 86512 | 86512 | 114643 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 609 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774764 | 6009663.9 | 2100372.9 | 37.7477692975566 | -122.40933520293899 | (37.7477692975566, -122.409335202939) | |||
| 87431 | 87431 | 83171 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1590X Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | ||
| 87491 | 87491 | 87476 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 4437 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51125 | 6000067.0 | 2105741.0 | 37.7619664283465 | -122.442906118301 | (37.7619664283465, -122.442906118301) | ||
| 88067 | 88067 | 193393 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 151 Napoleon St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012653.35348 | 2099999.0304400004 | 37.7469097701736 | -122.398971521724 | (37.7469097701736, -122.398971521724) | |||
| 89096 | 89096 | 88077 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1590X Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015266.0 | 2094609.0 | 37.7322550915976 | -122.389560775326 | (37.7322550915976, -122.389560775326) | ||
| 89382 | 89382 | 28124 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 112 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2004 12:00:00 AM | 3 | 3X3 | 5995536.80725 | 2115362.80117 | 37.7881260406124 | -122.45927097722901 | (37.7881260406124, -122.459270977229) | ||
| 89688 | 89688 | 107301 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 333 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2014 12:00:00 AM | Permit Number 767149 | 6015127.71951 | 2114620.09555 | 37.7871935864977 | -122.39143729580799 | (37.7871935864977, -122.391437295808) | |||
| 90116 | 90116 | 92104 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1398 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52306 | 6016081.4 | 2093420.8 | 37.7290377092769 | -122.38665890051399 | (37.7290377092769, -122.386658900514) | ||
| 91889 | 91889 | 82262 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 850 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 4 | 4x4 | Permit Number 768603 | 6007525.28639452 | 2104705.22805815 | 37.759544830410704 | -122.417037358657 | (37.7595448304107, -122.417037358657) |
| 92165 | 92165 | 115165 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 402 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775277 | 5998511.59251 | 2106738.31574 | 37.7646160064689 | -122.448357464082 | (37.7646160064689, -122.448357464082) | |||
| 92278 | 92278 | 94899 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 175 Napoleon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53956 | 6012540.6 | 2099965.5 | 37.7468114191046 | -122.399359061968 | (37.7468114191046, -122.399359061968) | |
| 93000 | 93000 | 96058 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 118 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767686 | 6008231.0 | 2099363.0 | 37.7449159511255 | -122.414218673139 | (37.7449159511255, -122.414218673139) | |
| 94695 | 94695 | 87174 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 95795 | 95795 | 52956 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 478 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53570 | 5993279.13745627 | 2090341.45680434 | 37.7192938259954 | -122.46526387046801 | (37.7192938259954, -122.465263870468) | ||
| 96027 | 96027 | 92106 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1398 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52306 | 6016081.4 | 2093420.8 | 37.7290377092769 | -122.38665890051399 | (37.7290377092769, -122.386658900514) | ||
| 96284 | 96284 | 66687 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 45 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50886 | 5998400.68996099 | 2107200.48527227 | 37.765878666088604 | -122.448774336236 | (37.7658786660886, -122.448774336236) | ||
| 97075 | 97075 | 92383 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1201 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53830 | 6008606.0 | 2116275.0 | 37.791373424148 | -122.414118235332 | (37.791373424148, -122.414118235332) | |
| 97372 | 97372 | 40938 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 250 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52425 | 6008608.67126022 | 2109716.51836429 | 37.773365556377705 | -122.413644912079 | (37.7733655563777, -122.413644912079) | ||
| 98504 | 98504 | 52186 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 117 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52618 | 6001741.54156575 | 2105161.20855715 | 37.7604697895723 | -122.43707303146799 | (37.7604697895723, -122.437073031468) | |
| 99369 | 99369 | 82120 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 294 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49836 | 5995382.14705323 | 2097514.68391142 | 37.7391108272782 | -122.458513580611 | (37.7391108272782, -122.458513580611) | ||
| 100382 | 100382 | 115402 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 218 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776284 | 6005779.9 | 2096086.1 | 37.7357803359495 | -122.42246134044301 | (37.7357803359495, -122.422461340443) | ||
| 101144 | 101144 | 177450 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 655 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010679.56487 | 2091598.96237 | 37.7237347842164 | -122.40520532088699 | (37.7237347842164, -122.405205320887) | |||
| 102352 | 102352 | 115164 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 112 Clifford Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775244 | 5999576.0 | 2106584.4 | 37.7642541893967 | -122.444664912175 | (37.7642541893967, -122.444664912175) | |||
| 102485 | 102485 | 82260 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 850 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 3 | 4x4 | Permit Number 768603 | 6007525.28639452 | 2104705.22805815 | 37.759544830410704 | -122.417037358657 | (37.7595448304107, -122.417037358657) |
| 102741 | 102741 | 92103 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1398 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52306 | 6016081.4 | 2093420.8 | 37.7290377092769 | -122.38665890051399 | (37.7290377092769, -122.386658900514) | ||
| 102894 | 102894 | 102067 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 24 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769727 | 6007035.7 | 2099866.2 | 37.7462304116746 | -122.418387482558 | (37.7462304116746, -122.418387482558) |
| 103160 | 103160 | 108264 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 400x ELIZABETH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2015 12:00:00 AM | 3 | 4x5 | Permit Number 774411 | 6003752.0 | 2102232.0 | 37.7525409491736 | -122.429910836031 | (37.7525409491736, -122.429910836031) | |
| 104149 | 104149 | 102762 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 100X Russ St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.40821818771099 | (37.7785759102049, -122.408218187711) |
| 105921 | 105921 | 87173 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 106148 | 106148 | 83006 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1590X Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | ||
| 108425 | 108425 | 18419 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 645X POTRERO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/2005 12:00:00 AM | 3 | 3X3 | 6010440.0 | 2105310.0 | 37.7613689295586 | -122.40699940993099 | (37.7613689295586, -122.406999409931) | ||
| 109258 | 109258 | 55695 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 51 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52581 | 6005948.92964432 | 2097719.44263908 | 37.740274663612205 | -122.421992931257 | (37.7402746636122, -122.421992931257) | ||
| 109891 | 109891 | 87161 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 110143 | 110143 | 96070 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 757 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767694 | 6008574.7 | 2104126.2 | 37.75801392865829 | -122.413367004042 | (37.7580139286583, -122.413367004042) | |
| 110745 | 110745 | 84529 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 698X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52659 | 6009314.54246303 | 2104977.65271839 | 37.760393335954795 | -122.41086843864099 | (37.7603933359548, -122.410868438641) | ||
| 110806 | 110806 | 96069 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 757 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767694 | 6008574.7 | 2104126.2 | 37.75801392865829 | -122.413367004042 | (37.7580139286583, -122.413367004042) | |
| 111125 | 111125 | 87170 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 113291 | 113291 | 87167 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 114257 | 114257 | 105297 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 15 Karen Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774558 | 6010447.0 | 2091541.0 | 37.7235626269277 | -122.406005180928 | (37.7235626269277, -122.406005180928) | |
| 114323 | 114323 | 84528 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 698X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52659 | 6009314.54246303 | 2104977.65271839 | 37.760393335954795 | -122.41086843864099 | (37.7603933359548, -122.410868438641) | ||
| 116986 | 116986 | 87171 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 117302 | 117302 | 87163 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 215 Napoleon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714.0 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | ||
| 117866 | 117866 | 94900 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 175 Napoleon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53956 | 6012540.6 | 2099965.5 | 37.7468114191046 | -122.399359061968 | (37.7468114191046, -122.399359061968) |
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");