trees
979 rows where qSpecies_id = 13 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21421 | 193318 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 4 | : | Tree | Private 2 | 10 | Width 2ft | 6013332.96782 | 2113640.49809 | 37.7844040630434 | -122.397578060899 | (37.7844040630434, -122.397578060899) | 6 | 2 | 9 | 28856 | 6 | |||
| 21530 | 120427 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 459 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989038.74655 | 2112201.43488 | 37.7790700882049 | -122.481521260476 | (37.7790700882049, -122.481521260476) | 11 | 6 | 2 | 55 | 26 | |||
| 21538 | 123622 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 111 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995179.48554 | 2114830.2995 | 37.7866433854107 | -122.460468639914 | (37.7866433854107, -122.460468639914) | 11 | 6 | 1 | 54 | 11 | |||
| 21839 | 230285 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 112 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6005732.266 | 2100246.49817 | 37.7472011631029 | -122.422921627052 | (37.7472011631029, -122.422921627052) | 2 | 7 | 5 | 28859 | 22 | |||
| 22156 | 150165 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 3 | Width 3ft | 6014460.64342 | 2105255.76526 | 37.7614441832169 | -122.39308978288 | (37.7614441832169, -122.39308978288) | 10 | 3 | 8 | 28856 | 29 | ||
| 23346 | 177418 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6009516.77243 | 2090302.76478 | 37.7201106197971 | -122.409133494811 | (37.7201106197971, -122.409133494811) | 9 | 3 | 7 | 309 | 28 | |||
| 24065 | 95100 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773992 | 5999642.14759 | 2120895.84862 | 37.8035534892505 | -122.445465271815 | (37.8035534892505, -122.445465271815) | 13 | 9 | 1 | 57 | 17 | |
| 24131 | 177447 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 762 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002442.74838 | 2087164.23323 | 37.7110940664123 | -122.433361825211 | (37.7110940664123, -122.433361825211) | 9 | 7 | 6 | 28861 | 5 | |||
| 24293 | 94928 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 929#4 Broderick St | Sidewalk: Curb side : | Landscaping | Private 2 | 12/08/2010 12:00:00 AM | 3 | 26x6 | Permit Number 54775 | 6000937 | 2111843 | 37.7787705583514 | -122.440334763546 | (37.7787705583514, -122.440334763546) | 15 | 5 | 11 | 29490 | 41 | ||
| 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 | |
| 24707 | 230280 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201 Webster St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6004189.92363 | 2109488.51079 | 37.7724903832539 | -122.428913720795 | (37.7724903832539, -122.428913720795) | 7 | 9 | 11 | 29492 | 10 | |||
| 24814 | 130998 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007580.24685 | 2119942.9983 | 37.8013871663302 | -122.417927457909 | (37.8013871663302, -122.417927457909) | 5 | 1 | 1 | 28858 | 32 | |||
| 25069 | 193337 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1270 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015308.47907 | 2102559.27559 | 37.7540872603324 | -122.389969077812 | (37.7540872603324, -122.389969077812) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 26112 | 112553 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 2 | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 19 | ||
| 26823 | 130979 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003392.63825 | 2118710.53887 | 37.7977665875245 | -122.432330365752 | (37.7977665875245, -122.432330365752) | 13 | 9 | 1 | 57 | 17 | |||
| 26858 | 193333 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015305.27356 | 2102653.19148 | 37.7543449556813 | -122.389986723422 | (37.7543449556813, -122.389986723422) | 10 | 3 | 8 | 28856 | 29 | |||
| 26944 | 105800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 207 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2014 12:00:00 AM | 3 | Permit Number 769635 | 6010004.04754 | 2087785.06673 | 37.71322482385 | -122.407271751589 | (37.71322482385, -122.407271751589) | 9 | 7 | 8 | 309 | 39 | ||
| 27090 | 130990 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1465 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007716.27446 | 2117147.85171 | 37.7937200456874 | -122.417258554752 | (37.7937200456874, -122.417258554752) | 5 | 1 | 10 | 28858 | 32 | |||
| 27143 | 193373 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013783.27133 | 2116255.65231 | 37.7916097334637 | -122.396203501097 | (37.7916097334637, -122.396203501097) | 12 | 2 | 9 | 28855 | 6 | |||
| 27321 | 243475 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 109X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779653 | 6007857.826 | 2097024.89565 | 37.7384750655589 | -122.415343555473 | (37.7384750655589, -122.415343555473) | 2 | 7 | 7 | 28859 | 2 | |
| 27525 | 230338 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 31 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003171.49131 | 2108119.01737 | 37.7686723924455 | -122.43233874923 | (37.7686723924455, -122.43233874923) | 15 | 5 | 5 | 28862 | 3 | |||
| 29086 | 112523 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995199.36548 | 2114291.31706 | 37.7851646286632 | -122.460360793578 | (37.7851646286632, -122.460360793578) | 11 | 6 | 2 | 54 | 11 | |
| 29659 | 250186 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 665 Parker Ave | 3 | : | Tree | Private 2 | 2 | Width 4ft | 5997220.39466 | 2110886.14724 | 37.7759309780695 | -122.4531227967 | (37.7759309780695, -122.4531227967) | 15 | 6 | 2 | 54 | 16 | |||
| 29714 | 65128 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 184 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50320 | 5989636.73328 | 2114131.59369 | 37.7844045165702 | -122.47959386665 | (37.7844045165702, -122.47959386665) | 11 | 6 | 2 | 55 | 26 | |
| 30093 | 98453 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768642 | 6014340.87186 | 2104676.45619 | 37.7598468721503 | -122.393463482668 | (37.7598468721503, -122.393463482668) | 10 | 3 | 8 | 28856 | 29 | |
| 30292 | 230302 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2908 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009976.47339 | 2101651.34742 | 37.7512971397648 | -122.408344495308 | (37.7512971397648, -122.408344495308) | 2 | 4 | 7 | 28859 | 19 | |||
| 30957 | 251545 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 347 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004948 | 2106317 | 37.7638250559684 | -122.426065641314 | (37.7638250559684, -122.426065641314) | 8 | 4 | 5 | 28859 | 19 | ||||
| 31341 | 230282 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 175 Haight St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005285.87309 | 2109545.94561 | 37.7727100570619 | -122.425126806975 | (37.7727100570619, -122.425126806975) | 7 | 9 | 11 | 28852 | 10 | |||
| 32076 | 208848 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 281 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994210.24416 | 2088699.7294 | 37.7148396860693 | -122.461926423875 | (37.7148396860693, -122.461926423875) | 9 | 8 | 6 | 28861 | 24 | |||
| 32238 | 177429 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 278 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005195.23308 | 2094056.19803 | 37.7301736773527 | -122.424338433387 | (37.7301736773527, -122.424338433387) | 9 | 7 | 6 | 28861 | 5 | |||
| 32359 | 193327 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1398 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015585.42977 | 2102602.25227 | 37.7542206208044 | -122.389014307158 | (37.7542206208044, -122.389014307158) | 10 | 3 | 8 | 28856 | 29 | |||
| 32889 | 193331 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015302.57075 | 2102682.83592 | 37.754426203129 | -122.38999814121 | (37.754426203129, -122.38999814121) | 10 | 3 | 8 | 28856 | 29 | |||
| 33124 | 218387 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 50 San Marcos Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5993857.52408 | 2100226.90247 | 37.7464701590844 | -122.463981819901 | (37.7464701590844, -122.463981819901) | 1 | 8 | 4 | 29491 | 40 | |||
| 33289 | 248252 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 110 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006810.41598 | 2098914.4324 | 37.7436043875329 | -122.41909899034 | (37.7436043875329, -122.41909899034) | 2 | 7 | 7 | 28859 | 2 | |||
| 33479 | 116924 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015542.44799 | 2102559.60008 | 37.7541011242826 | -122.389159972153 | (37.7541011242826, -122.389159972153) | 10 | 3 | 8 | 28856 | 29 | ||
| 33505 | 110563 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x9 | 6002082.974 | 2093709.61136 | 37.7290457953117 | -122.435073124425 | (37.7290457953117, -122.435073124425) | 9 | 7 | 6 | 28861 | 25 | |||
| 33582 | 103859 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1475 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | 13 | 9 | 10 | 28858 | 21 | ||
| 33672 | 103773 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | |||
| 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 | |||
| 33704 | 249813 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6010621.11973 | 2121031.89357 | 37.8045476726861 | -122.407481446514 | (37.8045476726861, -122.407481446514) | 3 | 1 | 10 | 308 | 23 | |||
| 34068 | 119038 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 675 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5982249.27103 | 2111200.72651 | 37.7759253222044 | -122.504934234985 | (37.7759253222044, -122.504934234985) | 11 | 6 | 2 | 55 | 26 | |||
| 34100 | 103787 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1217 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006790.1 | 2115111 | 37.7880752061995 | -122.420318570601 | (37.7880752061995, -122.420318570601) | 13 | 9 | 10 | 28858 | 21 | ||
| 34124 | 99576 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 301X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2012 12:00:00 AM | 3 | 3x3 | 768682 | 6002944.2 | 2106475.3 | 37.7641462544056 | -122.433007480488 | (37.7641462544056, -122.433007480488) | 15 | 4 | 5 | 28862 | 3 | |
| 34619 | 131007 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013687.07221 | 2117423.51513 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | 4 | 1 | 10 | 28860 | 6 | |||
| 34828 | 116927 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015494.24319 | 2102557.91546 | 37.7540938262957 | -122.389326559889 | (37.7540938262957, -122.389326559889) | 10 | 3 | 8 | 28856 | 29 | ||
| 35478 | 141579 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 0ft | 6000650.2876 | 2110740.0178 | 37.7757257205697 | -122.441247451765 | (37.7757257205697, -122.441247451765) | 15 | 5 | 11 | 29492 | 10 | |||
| 37097 | 193317 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 3 | : | Tree | Private 2 | 9 | Width 2ft | 6013319.34244 | 2113654.62795 | 37.7844421016727 | -122.397626191699 | (37.7844421016727, -122.397626191699) | 6 | 2 | 9 | 28856 | 6 | |||
| 37561 | 230306 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005267.4467 | 2105080.91438 | 37.7604491067472 | -122.424872824933 | (37.7604491067472, -122.424872824933) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 37880 | 53932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 140 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 1 | Permit Number 9646 | 5993064.17697 | 2114524.47346 | 37.7856817557629 | -122.467764782699 | (37.7856817557629, -122.467764782699) | 11 | 6 | 2 | 54 | 11 | ||
| 38086 | 85870 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2310 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008150.98253 | 2104964.863142 | 37.7602929064273 | -122.414891759956 | (37.7602929064273, -122.414891759956) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 38155 | 43751 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 255 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/2015 12:00:00 AM | 3 | Permit Number 773834 | 5991170.79793 | 2113718.28394 | 37.7833586747671 | -122.474256417664 | (37.7833586747671, -122.474256417664) | 11 | 6 | 2 | 54 | 26 | |
| 38674 | 177406 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 618 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002461.15734 | 2090172.80832 | 37.7193559950662 | -122.433513065093 | (37.7193559950662, -122.433513065093) | 9 | 7 | 6 | 28861 | 5 | |||
| 38675 | 109898 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1786 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775112 | 5987249.9 | 2103123.1 | 37.7540393206485 | -122.487042615101 | (37.7540393206485, -122.487042615101) | 1 | 8 | 3 | 56 | 35 |
| 38952 | 177433 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 439 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008733.06168 | 2093861.61414 | 37.7298385306021 | -122.412093908309 | (37.7298385306021, -122.412093908309) | 9 | 3 | 7 | 309 | 28 | |||
| 39488 | 177445 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Karen Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010506.33995 | 2091553.32971 | 37.7235998004623 | -122.405800920297 | (37.7235998004623, -122.405800920297) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | ||
| 39755 | 247755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 52 Alpine Ter | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6001613.95356 | 2108514.35375 | 37.7696694492075 | -122.437754457603 | (37.7696694492075, -122.437754457603) | 15 | 5 | 5 | 29492 | 9 | |||
| 39763 | 177405 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 688 Vienna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002677.69306 | 2089500.91725 | 37.7175234141583 | -122.432716611994 | (37.7175234141583, -122.432716611994) | 9 | 7 | 6 | 28861 | 5 | |||
| 40035 | 105251 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984733.08187 | 2112389.43293 | 37.7793349822998 | -122.496429952441 | (37.7793349822998, -122.496429952441) | 11 | 6 | 2 | 55 | 26 | ||
| 40064 | 84782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 228 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | 5 | Permit No. 49243 | 6013990.15625 | 2105982.37522 | 37.7634131481085 | -122.394767902514 | (37.7634131481085, -122.394767902514) | 14 | 3 | 8 | 28856 | 29 | ||
| 40320 | 177441 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 71 Karen Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010258.66598 | 2091491.87018 | 37.7234171913236 | -122.406652760812 | (37.7234171913236, -122.406652760812) | 10 | 3 | 7 | 309 | 28 | |||
| 41323 | 177426 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003455.72001 | 2092686.06716 | 37.7263132250654 | -122.430254442684 | (37.7263132250654, -122.430254442684) | 9 | 7 | 6 | 28861 | 5 | |||
| 41578 | 193336 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1270 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015307.25652 | 2102573.04925 | 37.7541250120819 | -122.389974267815 | (37.7541250120819, -122.389974267815) | 10 | 3 | 8 | 28856 | 29 | |||
| 41966 | 49512 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1928& 21st AVE Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2003 12:00:00 AM | 4 | Permit Number 46417 | 5989493.41802 | 2113376.93915 | 37.7823241210106 | -122.480034435471 | (37.7823241210106, -122.480034435471) | 11 | 6 | 2 | 55 | 26 | ||
| 42370 | 83565 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 647 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769747 | 6003095.84203 | 2089582.30789 | 37.7177706009018 | -122.431277069882 | (37.7177706009018, -122.431277069882) | 9 | 7 | 6 | 28861 | 5 |
| 42861 | 103782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1237 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | 13 | 9 | 10 | 28858 | 21 | ||
| 43419 | 108518 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600-602 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773792 | 5993757.57798 | 2110759.58067 | 37.7753843907715 | -122.465092287532 | (37.7753843907715, -122.465092287532) | 11 | 6 | 2 | 54 | 11 |
| 43601 | 94709 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 739 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53847 | 5992236.9095 | 2110392.30167 | 37.7742881380791 | -122.470325834679 | (37.7742881380791, -122.470325834679) | 11 | 6 | 2 | 54 | 11 |
| 44564 | 177412 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 539 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6003697.34204 | 2090030.0653 | 37.719034114214 | -122.429229863064 | (37.719034114214, -122.429229863064) | 9 | 7 | 6 | 28861 | 5 | |||
| 44619 | 177424 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 85 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000559.94682 | 2092109.10715 | 37.7245645787726 | -122.440223605655 | (37.7245645787726, -122.440223605655) | 9 | 7 | 6 | 28861 | 25 | |||
| 45229 | 13059 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 583 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:23:00 AM | 3 | 2x2 | 6009557.0524 | 2120495.5376 | 37.8030153566132 | -122.41112585507 | (37.8030153566132, -122.41112585507) | 3 | 1 | 10 | 308 | 23 | ||
| 45290 | 112888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3980 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 774440 | 5995705.4 | 2115208.7 | 37.7877126116995 | -122.458676518899 | (37.7877126116995, -122.458676518899) | 11 | 6 | 1 | 54 | 31 | |||
| 45307 | 85039 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 740 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49387 | 6008855.33926 | 2110725.28618 | 37.7761492435388 | -122.412862984239 | (37.7761492435388, -122.412862984239) | 8 | 2 | 9 | 28853 | 34 | |
| 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 | |
| 46000 | 130996 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 48 Bonita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006123.48756 | 2118486.00095 | 37.7973045284306 | -122.422864892409 | (37.7973045284306, -122.422864892409) | 13 | 9 | 10 | 28858 | 32 | |||
| 46494 | 48393 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1325 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 4 | Permit Number 45775 | 5994526.88441 | 2112095.32134 | 37.7790963088496 | -122.462528007047 | (37.7790963088496, -122.462528007047) | 11 | 6 | 2 | 54 | 11 | |
| 46594 | 112556 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 19 | |||
| 47323 | 120376 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 123 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5987996.34408 | 2115176.14425 | 37.787177130209 | -122.485345649143 | (37.787177130209, -122.485345649143) | 11 | 6 | 1 | 55 | 33 | |||
| 47632 | 208834 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1669 18th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990551.61783 | 2104055.61326 | 37.7567917168824 | -122.475692689987 | (37.7567917168824, -122.475692689987) | 1 | 8 | 4 | 56 | 12 | |||
| 47704 | 108089 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010157.47788 | 2105483.07585 | 37.7618283430246 | -122.407988746007 | (37.7618283430246, -122.407988746007) | 10 | 4 | 8 | 28859 | 19 | ||
| 47775 | 230315 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 131 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010141.92441 | 2100150.42012 | 37.7471851875523 | -122.407666527004 | (37.7471851875523, -122.407666527004) | 2 | 7 | 7 | 28859 | 2 | |||
| 47926 | 110564 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x9 | 6002092.75194 | 2093699.46339 | 37.7290184865087 | -122.435038595882 | (37.7290184865087, -122.435038595882) | 9 | 7 | 6 | 28861 | 25 | |||
| 48650 | 250187 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 665 Parker Ave | 4 | : | Tree | Private 2 | 1 | Width 4ft | 5997222.68042 | 2110871.6887 | 37.7758914096851 | -122.453113845732 | (37.7758914096851, -122.453113845732) | 15 | 6 | 2 | 54 | 16 | |||
| 48719 | 116933 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1275 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015369.14789 | 2102590.92817 | 37.7541775360745 | -122.389761479208 | (37.7541775360745, -122.389761479208) | 10 | 3 | 8 | 28856 | 29 | ||
| 48747 | 177428 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 274 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005170.17326 | 2094055.30176 | 37.7301698012868 | -122.424425004805 | (37.7301698012868, -122.424425004805) | 9 | 7 | 6 | 28861 | 5 | |||
| 48795 | 145061 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 618 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2018 12:00:00 AM | 3 | 5x5 | 5991308.93205 | 2111174.50243 | 37.7763821517422 | -122.47359291598 | (37.7763821517422, -122.47359291598) | 11 | 6 | 2 | 54 | 26 | ||
| 48899 | 84780 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 224 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | 4 | Permit No. 49287 | 6013987.25375 | 2106041.39506 | 37.7635750422708 | -122.394782074949 | (37.7635750422708, -122.394782074949) | 14 | 3 | 8 | 28856 | 29 | ||
| 49029 | 26689 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1295X Pierce St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6002245.89461 | 2112942.9215 | 37.7818651028046 | -122.435885513106 | (37.7818651028046, -122.435885513106) | 15 | 5 | 11 | 29490 | 41 | |||
| 49090 | 51497 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 741 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50950 | 6009247.81044 | 2119754.33215 | 37.8009628437188 | -122.412143582356 | (37.8009628437188, -122.412143582356) | 3 | 1 | 10 | 308 | 4 | |
| 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 |
| 49376 | 99539 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 801X Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.7769767308218 | -122.445040600733 | (37.7769767308218, -122.445040600733) | 15 | 5 | 11 | 29492 | 16 | |
| 49638 | 123123 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992600.03768 | 2110148.99607 | 37.7736410746067 | -122.469052008303 | (37.7736410746067, -122.469052008303) | 11 | 6 | 2 | 54 | 11 | |||
| 49648 | 143618 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3634 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5987351.65597 | 2111892.16723 | 37.7781226861604 | -122.487334792473 | (37.7781226861604, -122.487334792473) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 49934 | 243477 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 109 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779653 | 6007827.74992 | 2097028.56453 | 37.7384834490575 | -122.415447803985 | (37.7384834490575, -122.415447803985) | 2 | 7 | 7 | 28859 | 2 | |
| 49967 | 130991 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006783.4642 | 2117013.95966 | 37.7932998878436 | -122.420476658169 | (37.7932998878436, -122.420476658169) | 13 | 9 | 10 | 28858 | 32 |
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) );