trees
979 rows where qSpecies_id = 13 sorted by Zip Codes descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▲ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
| 3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 11800 | 262282 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 18060 | 258219 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
| 97176 | 106368 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 426 Country Club Dr | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 770073 | 5984817.1 | 2094918.3 | 37.731369010287 | -122.494850794258 | (37.731369010287, -122.494850794258) | 1 | 8 | 4 | 64 | 35 | ||||
| 161402 | 217796 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 21 Sloat Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5991264.94517 | 2095927.55542 | 37.7345154980788 | -122.472633170284 | (37.7345154980788, -122.472633170284) | 1 | 8 | 4 | 64 | 40 | |||
| 172950 | 87071 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 2 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 179923 | 122379 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 466 Vernon St | 1 | Front Yard : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521 | 2090937 | 37.7208852925782 | -122.467927737968 | (37.7208852925782, -122.467927737968) | 9 | 8 | 6 | 64 | 24 | ||
| 188216 | 87070 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 194351 | 265046 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 1556 | 158441 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 49 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785489 | 6002069.34164 | 2096386.56921 | 37.7363953338756 | -122.435311658815 | (37.7363953338756, -122.435311658815) | 2 | 7 | 5 | 63 | 7 | |
| 1903 | 220552 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 13 Ohlone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 785489 | 6002169.64489 | 2096371.31931 | 37.7363591568587 | -122.434963778568 | (37.7363591568587, -122.434963778568) | 2 | 7 | 5 | 63 | 7 | ||
| 5797 | 230342 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Chenery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004911.05921 | 2097907.10852 | 37.7407313620627 | -122.425594827655 | (37.7407313620627, -122.425594827655) | 2 | 7 | 5 | 63 | 7 | |||
| 15356 | 251313 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 390 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 | |
| 17760 | 158440 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 49 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785489 | 6002067.69843 | 2096375.7626 | 37.7363655681024 | -122.435316567307 | (37.7363655681024, -122.435316567307) | 2 | 7 | 5 | 63 | 7 | |
| 18657 | 251312 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 | |
| 25495 | 208853 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 54 Martha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6000650.73977 | 2095621.13276 | 37.7342129598544 | -122.440161475975 | (37.7342129598544, -122.440161475975) | 9 | 7 | 5 | 63 | 40 | |||
| 33693 | 230355 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 397 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004002.34815 | 2098351.08289 | 37.7418990256315 | -122.428768448829 | (37.7418990256315, -122.428768448829) | 2 | 7 | 5 | 63 | 7 | |||
| 33699 | 230351 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 132 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002667.45566 | 2096824.4771 | 37.7376316768553 | -122.433275010943 | (37.7376316768553, -122.433275010943) | 2 | 7 | 5 | 63 | 7 | |||
| 37616 | 230346 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1801 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004582.48938 | 2098325.90354 | 37.7418627065067 | -122.426760715042 | (37.7418627065067, -122.426760715042) | 2 | 7 | 5 | 63 | 7 | |||
| 38136 | 230345 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1801 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004583.18993 | 2098311.13062 | 37.7418221830485 | -122.426757240969 | (37.7418221830485, -122.426757240969) | 2 | 7 | 5 | 63 | 7 | |||
| 49758 | 230319 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 119 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005056.96104 | 2098704.08914 | 37.7429279327818 | -122.425147048897 | (37.7429279327818, -122.425147048897) | 2 | 7 | 5 | 63 | 22 | |||
| 59519 | 95549 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1712 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767351 | 6002582 | 2100598 | 37.7479880436154 | -122.433840109923 | (37.7479880436154, -122.433840109923) | 2 | 4 | 5 | 63 | 22 | |
| 64728 | 107495 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4089 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 5x5 | Permit Number 774317 | 6003351.8 | 2100635.3 | 37.7481341140921 | -122.431180836539 | (37.7481341140921, -122.431180836539) | 2 | 4 | 5 | 63 | 22 | |
| 69408 | 230344 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1801 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004583.81865 | 2098292.85658 | 37.7417720422523 | -122.426753765994 | (37.7417720422523, -122.426753765994) | 2 | 7 | 5 | 63 | 7 | |||
| 80833 | 230356 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 137 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004658.9023 | 2097536.10277 | 37.7396984133428 | -122.42644028119 | (37.7396984133428, -122.42644028119) | 2 | 7 | 5 | 63 | 7 | |||
| 81305 | 230322 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4089 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6003345.45819 | 2100655.86235 | 37.7481902141138 | -122.431204233783 | (37.7481902141138, -122.431204233783) | 2 | 4 | 5 | 63 | 22 | |||
| 81960 | 230333 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 629 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001808.67707 | 2099403.33262 | 37.7446638554471 | -122.436428732821 | (37.7446638554471, -122.436428732821) | 2 | 7 | 5 | 63 | 22 | |||
| 87755 | 4334 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 852 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001755.94767 | 2095865.71194 | 37.7349473777015 | -122.436357925586 | (37.7349473777015, -122.436357925586) | 2 | 7 | 5 | 63 | 7 | |||
| 88701 | 230357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 137 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004642.12984 | 2097534.33192 | 37.7396926028383 | -122.426498147168 | (37.7396926028383, -122.426498147168) | 2 | 7 | 5 | 63 | 7 | |||
| 91895 | 230354 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 531 30th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003165.59039 | 2098301.47872 | 37.7417154299181 | -122.431658143201 | (37.7417154299181, -122.431658143201) | 2 | 7 | 5 | 63 | 7 | |||
| 97874 | 230343 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Chenery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004910.05584 | 2097921.66035 | 37.7407712613889 | -122.42559933235 | (37.7407712613889, -122.42559933235) | 2 | 7 | 5 | 63 | 7 | |||
| 100807 | 230326 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 383 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004064.30243 | 2100111.91698 | 37.7467373764274 | -122.428679723506 | (37.7467373764274, -122.428679723506) | 2 | 7 | 5 | 63 | 22 | |||
| 111438 | 1922 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 66 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2016 02:50:00 PM | 3 | 3x3 | 6001235.3932896 | 2097346.6778621 | 37.7389841732277 | -122.438263722762 | (37.7389841732277, -122.438263722762) | 2 | 7 | 5 | 63 | 7 | ||
| 114911 | 230318 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 107 Valley St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6005160.92225 | 2099293.15868 | 37.7445512558398 | -122.424829478514 | (37.7445512558398, -122.424829478514) | 2 | 7 | 5 | 63 | 22 | |||
| 118195 | 80286 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50470 | 6004535.68280027 | 2096559.61306431 | 37.7370102276711 | -122.426796798587 | (37.7370102276711, -122.426796798587) | 2 | 7 | 5 | 63 | 7 | ||
| 120107 | 230339 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Chenery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004912.08615 | 2097855.70847 | 37.7405902872201 | -122.425587619594 | (37.7405902872201, -122.425587619594) | 2 | 7 | 5 | 63 | 7 | |||
| 126159 | 246460 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Duncan St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005150.47679 | 2099924.83113 | 37.7462850938946 | -122.424910529003 | (37.7462850938946, -122.424910529003) | 2 | 7 | 5 | 63 | 22 | |||
| 130311 | 107776 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4115 26TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003143.1 | 2100622.5 | 37.7480871393693 | -122.431901599648 | (37.7480871393693, -122.431901599648) | 2 | 4 | 5 | 63 | 22 | |||||
| 136036 | 30800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199 Burnside Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 4 | Permit Number 34666 | 6001059.22701 | 2095245.36746 | 37.7332044430184 | -122.438722291799 | (37.7332044430184, -122.438722291799) | 9 | 7 | 5 | 63 | 40 | |
| 137702 | 230320 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 469 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002876.4268 | 2099458.33871 | 37.7448755037027 | -122.432740595108 | (37.7448755037027, -122.432740595108) | 2 | 7 | 5 | 63 | 22 | |||
| 138035 | 230340 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Chenery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004910.8116 | 2097869.74707 | 37.7406287620114 | -122.425593025396 | (37.7406287620114, -122.425593025396) | 2 | 7 | 5 | 63 | 7 | |||
| 138688 | 230327 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 204 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005133.40342 | 2100215.61494 | 37.747082555133 | -122.4249902521 | (37.747082555133, -122.4249902521) | 2 | 7 | 5 | 63 | 22 | |||
| 150010 | 208856 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 331 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999876.46994 | 2094937.06877 | 37.7322905690371 | -122.442789260809 | (37.7322905690371, -122.442789260809) | 9 | 7 | 4 | 63 | 40 | |||
| 153303 | 208854 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 403 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000738.25752 | 2095246.23801 | 37.7331885682037 | -122.439832030035 | (37.7331885682037, -122.439832030035) | 9 | 7 | 5 | 63 | 40 | |||
| 158639 | 230350 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002643.63835 | 2096299.62877 | 37.7361892128574 | -122.433319865541 | (37.7361892128574, -122.433319865541) | 2 | 7 | 5 | 63 | 7 | |||
| 169695 | 230352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002654.78135 | 2096839.90131 | 37.7376733091617 | -122.433319933881 | (37.7376733091617, -122.433319933881) | 2 | 7 | 5 | 63 | 7 | |||
| 174450 | 230341 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Chenery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004909.36728 | 2097888.20066 | 37.7406793497697 | -122.425599332346 | (37.7406793497697, -122.425599332346) | 2 | 7 | 5 | 63 | 7 | |||
| 183036 | 230347 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1801 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004579.28935 | 2098353.48586 | 37.7419382603343 | -122.426773743522 | (37.7419382603343, -122.426773743522) | 2 | 7 | 5 | 63 | 7 | |||
| 185828 | 230353 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 210 Moffitt St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002369.42033 | 2097177.7522 | 37.7385847765781 | -122.434330709794 | (37.7385847765781, -122.434330709794) | 2 | 7 | 5 | 63 | 7 | |||
| 186211 | 247777 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 240 30th St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005014.99439 | 2098457.52943 | 37.7422485651112 | -122.425274616848 | (37.7422485651112, -122.425274616848) | 2 | 7 | 5 | 63 | 22 | |||
| 189702 | 230349 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 222 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001969.40377 | 2096197.83075 | 37.73587142571 | -122.435643686718 | (37.73587142571, -122.435643686718) | 2 | 7 | 5 | 63 | 7 | |||
| 192999 | 230348 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6004547.50076 | 2096560.53724 | 37.7370134334286 | -122.42675600438 | (37.7370134334286, -122.42675600438) | 2 | 7 | 5 | 63 | 7 | |||
| 821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
| 6755 | 264922 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
| 8374 | 208843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 40 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997291.06099 | 2098595.63938 | 37.7421883896873 | -122.451991423486 | (37.7421883896873, -122.451991423486) | 9 | 7 | 4 | 59 | 40 | |||
| 12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 15881 | 264923 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
| 17477 | 166394 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 842 Monterey Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/30/2019 12:00:00 AM | 3 | Width 3ft | 5996498.63435 | 2094752.41973 | 37.731590420751 | -122.454453810411 | (37.731590420751, -122.454453810411) | 9 | 7 | 4 | 59 | 40 | ||
| 18618 | 170106 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 6x10 | Permit Number 783167 | 5997920.28587 | 2095246.22061 | 37.7330277118397 | -122.449574473879 | (37.7330277118397, -122.449574473879) | 9 | 7 | 4 | 59 | 40 | |
| 26576 | 173651 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 80 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.45657 | 2092194.59394 | 37.7243327619491 | -122.468352901223 | (37.7243327619491, -122.468352901223) | 9 | 8 | 4 | 59 | 40 | ||
| 56875 | 82146 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1083 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51167 | 5995391.16373818 | 2098013.23554983 | 37.7404802453018 | -122.458518484651 | (37.7404802453018, -122.458518484651) | 9 | 7 | 4 | 59 | 40 | ||
| 67384 | 112573 | Section 143 10 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 56 ROCKWOOD CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685 | 2098946 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | 1 | 8 | 4 | 59 | 40 | ||
| 70653 | 208855 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 358 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5999047.68761 | 2095262.2243 | 37.7331360864596 | -122.445677914709 | (37.7331360864596, -122.445677914709) | 9 | 7 | 4 | 59 | 40 | |||
| 86762 | 208850 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994846.41703 | 2099381.92654 | 37.7442070079607 | -122.46050114503 | (37.7442070079607, -122.46050114503) | 1 | 8 | 4 | 59 | 40 | |||
| 104425 | 208844 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 335 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5995829.06738 | 2094841.15023 | 37.7317956298598 | -122.456775035249 | (37.7317956298598, -122.456775035249) | 9 | 7 | 4 | 59 | 40 | |||
| 139250 | 208851 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994827.47674 | 2099365.31036 | 37.7441602944536 | -122.460565432153 | (37.7441602944536, -122.460565432153) | 1 | 8 | 4 | 59 | 40 | |||
| 144718 | 112574 | Section 143 10 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 56 ROCKWOOD CT | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685 | 2098946 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | 1 | 8 | 4 | 59 | 40 | ||
| 170390 | 203239 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 115 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995169.40317 | 2099688.3978 | 37.7450670773024 | -122.459406527086 | (37.7450670773024, -122.459406527086) | 1 | 8 | 4 | 59 | 40 | |
| 180821 | 208839 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992959.48741 | 2098205.81206 | 37.74086896193 | -122.466940197353 | (37.74086896193, -122.466940197353) | 1 | 8 | 4 | 59 | 40 | |||
| 895 | 56729 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | 10 | 3 | 8 | 58 | 1 | ||
| 12863 | 154063 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1781 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014599.10763 | 2096821.84485 | 37.7382941111836 | -122.392021081628 | (37.7382941111836, -122.392021081628) | 10 | 3 | 8 | 58 | 1 |
| 20416 | 17382 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | 10 | 3 | 8 | 58 | 1 | |
| 24379 | 84492 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1726 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50144 | 6014424.88297 | 2094914.9156 | 37.733048399857 | -122.392490121246 | (37.733048399857, -122.392490121246) | 10 | 3 | 8 | 58 | 1 | |
| 30764 | 97025 | Property Tree 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 39534 | 8225 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:37:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
| 45035 | 88479 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1751 Newcomb Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51431 | 6014386 | 2096253.8 | 37.7367225430205 | -122.392718181551 | (37.7367225430205, -122.392718181551) | 10 | 3 | 8 | 58 | 1 | ||
| 45858 | 88076 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 674 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51071 | 6011923.03733 | 2094336.64392 | 37.7313213328046 | -122.401099095547 | (37.7313213328046, -122.401099095547) | 10 | 3 | 8 | 58 | 1 | |
| 49171 | 94884 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2010 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53951 | 6013072.55459 | 2096282.04692 | 37.736727066797 | -122.397261344859 | (37.736727066797, -122.397261344859) | 10 | 3 | 8 | 58 | 1 |
| 50336 | 94885 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.08413 | 37.736769849332 | -122.397340238786 | (37.736769849332, -122.397340238786) | 10 | 3 | 8 | 58 | 1 |
| 52659 | 6741 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:50:00 PM | 3 | 3x3 | 6016924.03316 | 2097256.88159 | 37.7396174392826 | -122.384012840031 | (37.7396174392826, -122.384012840031) | 10 | 3 | 8 | 58 | 1 | ||
| 54957 | 193353 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 75 Latona St | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6014356.71381 | 2094130.91489 | 37.7308919074363 | -122.392670976684 | (37.7308919074363, -122.392670976684) | 10 | 3 | 8 | 58 | 1 | |||
| 83365 | 6755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/2017 06:41:00 AM | 3 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
| 86141 | 88503 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 7 Wheat St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51441 | 6012178 | 2091435 | 37.7233682355202 | -122.400013942822 | (37.7233682355202, -122.400013942822) | 10 | 3 | 8 | 58 | 1 | |||
| 87006 | 113267 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 83 Exeter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | 2 | Permit Number 774551 | 6012507.04437 | 2090789.37208 | 37.7216138123142 | -122.398831200496 | (37.7216138123142, -122.398831200496) | 10 | 3 | 8 | 58 | 1 | ||
| 107537 | 193351 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1752 Quesada Ave | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6014452.02014 | 2095263.45344 | 37.7340069206852 | -122.392420670182 | (37.7340069206852, -122.392420670182) | 10 | 3 | 8 | 58 | 1 | |||
| 117325 | 30768 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.7278377210513 | -122.391915390574 | (37.7278377210513, -122.391915390574) | 10 | 3 | 8 | 58 | 1 | |
| 123198 | 61691 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 61 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 4 | Permit Number 31258 | 6014147.06906 | 2093799.26826 | 37.7299696274983 | -122.393372558494 | (37.7299696274983, -122.393372558494) | 10 | 3 | 8 | 58 | 1 | |
| 137832 | 113270 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1570 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 773602 | 6015432.5 | 2094545.1 | 37.7320888656597 | -122.388980682272 | (37.7320888656597, -122.388980682272) | 10 | 3 | 8 | 58 | 1 | |||
| 147550 | 113269 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1328 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774425 | 6016744.9 | 2093624.7 | 37.7296342890732 | -122.384379303046 | (37.7296342890732, -122.384379303046) | 10 | 3 | 8 | 58 | 1 | |||
| 151472 | 193354 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 75 Latona St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6014363.50892 | 2094164.90475 | 37.7309856140862 | -122.392649861509 | (37.7309856140862, -122.392649861509) | 10 | 3 | 8 | 58 | 1 | |||
| 152301 | 193350 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1752 Quesada Ave | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6014471.5284 | 2095248.21375 | 37.7339661589078 | -122.392352158028 | (37.7339661589078, -122.392352158028) | 10 | 3 | 8 | 58 | 1 | |||
| 154786 | 248942 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:56:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 154917 | 26561 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 430 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6010306.7503709 | 2097855.6706051 | 37.7408935295991 | -122.406934857164 | (37.7408935295991, -122.406934857164) | 10 | 3 | 7 | 58 | 2 | ||
| 163849 | 8230 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:33:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
| 183758 | 8223 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:24:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
| 190220 | 96333 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 11 Robblee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767342 | 6012676.77436 | 2095976.0416 | 37.7358647977189 | -122.398608271155 | (37.7358647977189, -122.398608271155) | 10 | 3 | 8 | 58 | 1 | |
| 191282 | 248924 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Cashmere St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/29/2017 10:39:00 AM | 3 | 3x3 | 6016272 | 2096170 | 37.7365970133228 | -122.386191558691 | (37.7365970133228, -122.386191558691) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );