Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125699 | 125699 | 88320 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | |||
| 106504 | 106504 | 88322 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | ||
| 18733 | 18733 | 88323 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 125 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417.0 | 2092629.0 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | |||
| 103099 | 103099 | 88326 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | |||
| 120151 | 120151 | 88327 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | ||
| 112316 | 112316 | 88332 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 659 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51320 | 6002140.0 | 2090092.0 | 37.7191158866353 | -122.434617409737 | (37.7191158866353, -122.434617409737) | |||
| 146771 | 146771 | 88351 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51333 | 6002622.22718 | 2089414.5665400003 | 37.7172831683531 | -122.432902166399 | (37.7172831683531, -122.432902166399) | |
| 95030 | 95030 | 88376 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 563 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51354 | 5991545.8 | 2111599.6 | 37.777563068378704 | -122.472804534873 | (37.7775630683787, -122.472804534873) | |||
| 28196 | 28196 | 88382 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 355 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51360 | 5990561.77007 | 2113010.94096 | 37.7813812065074 | -122.476311706446 | (37.7813812065074, -122.476311706446) | ||
| 110943 | 110943 | 88424 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1465 Washington St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51388 | 6007689.0 | 2117147.0 | 37.7937161726159 | -122.417352866644 | (37.7937161726159, -122.417352866644) | |||
| 82853 | 82853 | 88479 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1751 Newcomb Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51431 | 6014386.0 | 2096253.8 | 37.7367225430205 | -122.392718181551 | (37.7367225430205, -122.392718181551) | ||
| 94923 | 94923 | 88503 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 7 Wheat St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51441 | 6012178.0 | 2091435.0 | 37.723368235520205 | -122.400013942822 | (37.7233682355202, -122.400013942822) | |||
| 110286 | 110286 | 88514 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 640 Faxon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51446 | 5994921.4 | 2092497.3 | 37.7253078255283 | -122.459743296133 | (37.7253078255283, -122.459743296133) | |||
| 89605 | 89605 | 88526 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1680 McAllister St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51817 | 6001106.0 | 2111441.0 | 37.7776763890724 | -122.43972129937299 | (37.7776763890724, -122.439721299373) | |||
| 88138 | 88138 | 88597 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Jordan Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51542 | 5996162.8 | 2114014.5 | 37.7844599367093 | -122.457007600103 | (37.7844599367093, -122.457007600103) | |||
| 104309 | 104309 | 88650 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 400 Haight St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51631 | 6004213.0 | 2109445.0 | 37.772372219374105 | -122.428830794856 | (37.7723722193741, -122.428830794856) | |||
| 87360 | 87360 | 88834 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 156 Collins St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51716 | 5998112.0 | 2113497.0 | 37.78315075925521 | -122.45022675387301 | (37.7831507592552, -122.450226753873) | |||
| 96094 | 96094 | 88841 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2008 12:00:00 AM | 3x3 | Permit Number 51719 | 6006820.0 | 2115342.0 | 37.788711160036996 | -122.42023152280301 | (37.788711160037, -122.420231522803) | ||
| 94334 | 94334 | 89047 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4552 19th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51787 | 6000860.0 | 2104654.0 | 37.7590269716409 | -122.440085499527 | (37.7590269716409, -122.440085499527) | |||
| 77905 | 77905 | 89162 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||
| 101412 | 101412 | 89164 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||
| 123609 | 123609 | 89169 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 102499 | 102499 | 89170 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 121536 | 121536 | 89171 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 115103 | 115103 | 89172 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 118087 | 118087 | 89184 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 110669 | 110669 | 89185 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 122431 | 122431 | 89187 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 108377 | 108377 | 89188 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 140338 | 140338 | 89189 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 94680 | 94680 | 89190 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 143973 | 143973 | 89191 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 116964 | 116964 | 89192 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||
| 123890 | 123890 | 89193 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | |||||
| 106643 | 106643 | 89194 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | |||||
| 143562 | 143562 | 89299 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2825 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51902 | 6000069.8 | 2117048.2 | 37.7930132732955 | -122.44370878246599 | (37.7930132732955, -122.443708782466) | ||
| 127852 | 127852 | 92600 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 93683 | 93683 | 92601 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 124094 | 124094 | 92602 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 109413 | 109413 | 92603 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 113114 | 113114 | 92604 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 155904 | 155904 | 93189 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 651 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53197 | 5988441.61799 | 2111543.24899 | 37.77722815601879 | -122.483538678985 | (37.7772281560188, -122.483538678985) | |
| 124910 | 124910 | 93624 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 149 Collins St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | Permit Number 53164 | 5998064.0 | 2113562.0 | 37.783326485193 | -122.450397500912 | (37.783326485193, -122.450397500912) | |||
| 144432 | 144432 | 94054 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 185 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2010 12:00:00 AM | 3 | 3x9 | 6005268.81764 | 2109524.34557 | 37.7726497850887 | -122.425184266439 | (37.7726497850887, -122.425184266439) | ||
| 105507 | 105507 | 94055 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 179 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2010 12:00:00 AM | 3 | 3x9 | 6005293.287409999 | 2109516.64513 | 37.7726300238656 | -122.42509907481 | (37.7726300238656, -122.42509907481) | ||
| 119879 | 119879 | 94144 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1670 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992831.3 | 2104104.9 | 37.757058944886396 | -122.467812361688 | (37.7570589448864, -122.467812361688) | ||
| 90961 | 90961 | 94705 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 682 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53845 | 5992291.3 | 2110837.3 | 37.7755131276945 | -122.470170100471 | (37.7755131276945, -122.470170100471) | ||
| 179928 | 179928 | 94708 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 696 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53846 | 5992270.38847 | 2110735.82166 | 37.775233286679104 | -122.470235046427 | (37.7752332866791, -122.470235046427) |
| 70176 | 70176 | 94709 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 739 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53847 | 5992236.9095 | 2110392.30167 | 37.7742881380791 | -122.47032583467899 | (37.7742881380791, -122.470325834679) |
| 152466 | 152466 | 94730 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 418 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53862 | 5997217.67326 | 2114882.8026 | 37.7869045857318 | -122.45342083293001 | (37.7869045857318, -122.45342083293) |
| 90318 | 90318 | 94819 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1551 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53898 | 5993027.2 | 2104915.2 | 37.759295127513106 | -122.467193784759 | (37.7592951275131, -122.467193784759) | |
| 141970 | 141970 | 94820 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1227 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53900 | 5992334.0 | 2107055.2 | 37.7651309632558 | -122.469746983482 | (37.7651309632558, -122.469746983482) | |
| 138212 | 138212 | 94884 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53951 | 6013072.55459 | 2096282.04692 | 37.736727066797 | -122.397261344859 | (37.736727066797, -122.397261344859) |
| 188017 | 188017 | 94885 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.0841299999 | 37.736769849332 | -122.39734023878599 | (37.736769849332, -122.397340238786) |
| 153587 | 153587 | 95071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 319 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767740 | 5990554.377 | 2113243.49278 | 37.7820193005134 | -122.476354274932 | (37.7820193005134, -122.476354274932) | |
| 2247 | 2247 | 95100 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773992 | 5999642.14759 | 2120895.8486200003 | 37.8035534892505 | -122.445465271815 | (37.8035534892505, -122.445465271815) | |
| 177901 | 177901 | 95101 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3601x Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 2 | 5999657.71874 | 2120941.08267 | 37.8036785786574 | -122.445414641767 | (37.8036785786574, -122.445414641767) | |||
| 24465 | 24465 | 95104 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 5 | 5999633.730169999 | 2120895.6152 | 37.803552367813104 | -122.445494383786 | (37.8035523678131, -122.445494383786) | |||
| 182258 | 182258 | 95105 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 2 | 5999611.3063900005 | 2120892.8119799998 | 37.803543390775296 | -122.445571780333 | (37.8035433907753, -122.445571780333) | |||
| 78911 | 78911 | 95113 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 887 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54041 | 6001057.0 | 2091844.3 | 37.7238657652599 | -122.43848639746099 | (37.7238657652599, -122.438486397461) | |
| 131930 | 131930 | 95118 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 70 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54045 | 6002845.36735 | 2094508.37035 | 37.7312822680527 | -122.432494502827 | (37.7312822680527, -122.432494502827) |
| 96004 | 96004 | 95123 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Oneida Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54050 | 6000595.4 | 2090675.6 | 37.720630512863295 | -122.439998309146 | (37.7206305128633, -122.439998309146) | |
| 105665 | 105665 | 95129 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200@Broderick Beach St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 5999690.0 | 2120891.0 | 37.80354290788161 | -122.445299328106 | (37.8035429078816, -122.445299328106) | ||||
| 149661 | 149661 | 95133 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 450@ Wayland Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 1 | 3x3 | Permit Number 54066 | 6010089.84133 | 2092358.2905700002 | 37.725786753837 | -122.407297408351 | (37.725786753837, -122.407297408351) | |
| 120994 | 120994 | 95216 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3623 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Magnolia planted in Fall; 2010 without permit; to replace Acacia baileyana; which there was no permit for planting or removing. | 6005441.0 | 2105452.0 | 37.761477821729706 | -122.424298976847 | (37.7614778217297, -122.424298976847) | ||
| 88687 | 88687 | 95549 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1712 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767351 | 6002582.0 | 2100598.0 | 37.7479880436154 | -122.433840109923 | (37.7479880436154, -122.433840109923) | |
| 61145 | 61145 | 95563 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |||
| 126909 | 126909 | 95564 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 142179 | 142179 | 95565 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 15812 | 15812 | 95581 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3881 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779561 | 6003940.0 | 2101864.0 | 37.7515411523314 | -122.429234461777 | (37.7515411523314, -122.429234461777) |
| 121384 | 121384 | 95582 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1352 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767370 | 6002514.0 | 2101648.0 | 37.7508672366014 | -122.434150301439 | (37.7508672366014, -122.434150301439) | |
| 40091 | 40091 | 95676 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.1071400002 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) |
| 84591 | 84591 | 95703 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 127266 | 127266 | 95734 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 626 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767481 | 6002384.8 | 2090170.7 | 37.7193458734928 | -122.43377685304199 | (37.7193458734928, -122.433776853042) | |
| 147335 | 147335 | 95762 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 417 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004100.3891199995 | 2090668.84671 | 37.720810876907 | -122.427882177716 | (37.720810876907, -122.427882177716) |
| 108616 | 108616 | 95787 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3234 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767531 | 6008132.0 | 2101545.0 | 37.750901673491995 | -122.41471538692801 | (37.750901673492, -122.414715386928) | |
| 78394 | 78394 | 95830 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 5 Lucerne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767564 | 6011975.0 | 2109856.0 | 37.7739369979495 | -122.402010048031 | (37.7739369979495, -122.402010048031) | |
| 105494 | 105494 | 95926 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 651 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767623 | 5988426.1 | 2111542.8 | 37.777226019991204 | -122.483592327097 | (37.7772260199912, -122.483592327097) | |
| 126977 | 126977 | 95932 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 218 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767629 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) |
| 97250 | 97250 | 96057 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 110 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 2 | 3.5x6 | Permit Number 767685 | 6006775.4 | 2098937.3 | 37.7436652048745 | -122.419221689065 | (37.7436652048745, -122.419221689065) |
| 87866 | 87866 | 96066 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 957 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767691 | 6008013.0 | 2102358.0 | 37.753127300999395 | -122.415184444517 | (37.7531273009994, -122.415184444517) | |
| 110527 | 110527 | 96067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 981 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767692 | 6008020.0 | 2102218.0 | 37.7527432860874 | -122.415150327914 | (37.7527432860874, -122.415150327914) | |
| 94972 | 94972 | 96116 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577.0 | 2097739.0 | 37.7404200508617 | -122.41636508469699 | (37.7404200508617, -122.416365084697) | |
| 81271 | 81271 | 96117 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577.0 | 2097739.0 | 37.7404200508617 | -122.41636508469699 | (37.7404200508617, -122.416365084697) | |
| 96203 | 96203 | 96118 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577.0 | 2097739.0 | 37.7404200508617 | -122.41636508469699 | (37.7404200508617, -122.416365084697) | |
| 106722 | 106722 | 96167 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1325X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767799 | 6003578.5 | 2095430.2 | 37.7338549505754 | -122.430025664845 | (37.7338549505754, -122.430025664845) |
| 63323 | 63323 | 96333 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 11 Robblee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767342 | 6012676.77436 | 2095976.0416 | 37.7358647977189 | -122.398608271155 | (37.7358647977189, -122.398608271155) | |
| 62134 | 62134 | 96861 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 387 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768142 | 5986826.57443 | 2113361.96386 | 37.7821276946473 | -122.489259307913 | (37.7821276946473, -122.489259307913) | |
| 24130 | 24130 | 96862 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 387 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768142 | 5986827.805480001 | 2113344.76478 | 37.7820805427479 | -122.48925378416 | (37.7820805427479, -122.48925378416) | |
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 88700 | 88700 | 97099 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1096@Jones Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008668.0 | 2115966.0 | 37.7905284677514 | -122.41388184826499 | (37.7905284677514, -122.413881848265) | ||||
| 19246 | 19246 | 97101 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1096@Jones Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008668.0 | 2115966.0 | 37.7905284677514 | -122.41388184826499 | (37.7905284677514, -122.413881848265) | ||||
| 6714 | 6714 | 97108 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1472 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768373 | 6007110.8589699995 | 2117762.02293 | 37.795372327823 | -122.419396941128 | (37.795372327823, -122.419396941128) |
| 138917 | 138917 | 98077 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 731 Duboce Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6001992.2 | 2108216.2 | 37.768872292925295 | -122.436424775079 | (37.7688722929253, -122.436424775079) | |||||
| 91295 | 91295 | 98410 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
| 96447 | 96447 | 98411 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
| 89118 | 89118 | 98412 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 4 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
| 45272 | 45272 | 98453 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768642 | 6014340.87186 | 2104676.4561900003 | 37.7598468721503 | -122.393463482668 | (37.7598468721503, -122.393463482668) | |
| 53809 | 53809 | 98842 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 313 Maple St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2012 12:00:00 AM | 1 | Permit Number 768890 | 5996633.94495 | 2115242.03804 | 37.7878574732038 | -122.455466360678 | (37.7878574732038, -122.455466360678) | ||
| 109870 | 109870 | 99290 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) |
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");