trees
147 rows where qSpecies_id = 248 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3044 | 87165 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
14214 | 82828 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1590X Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
22138 | 80571 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 2810-2812 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52647 | 6009530.44783515 | 2105029.99995831 | 37.7605491735628 | -122.41012541478 | (37.7605491735628, -122.41012541478) | 2 | 4 | 7 | 28859 | 19 | ||
34566 | 82128 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 3239 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49904 | 6006723.81163078 | 2103763.20932527 | 37.7569131469298 | -122.419742420734 | (37.7569131469298, -122.419742420734) | 2 | 4 | 7 | 28859 | 19 | ||
34643 | 88348 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 100 Vienna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | 9 | 7 | 6 | 28861 | 5 | |||
35321 | 107300 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 333 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2014 12:00:00 AM | Permit Number 767149 | 6015127.71951 | 2114620.09555 | 37.7871935864977 | -122.391437295808 | (37.7871935864977, -122.391437295808) | 6 | 2 | 9 | 28855 | 6 | |||
37852 | 87160 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
37934 | 83016 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 4304 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52616 | 6001686.99553555 | 2105291.62841186 | 37.7608247901347 | -122.437271019328 | (37.7608247901347, -122.437271019328) | 15 | 4 | 5 | 28862 | 3 | |
38145 | 52187 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 117 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52618 | 6001741.54156575 | 2105161.20855715 | 37.7604697895723 | -122.437073031468 | (37.7604697895723, -122.437073031468) | 2 | 4 | 5 | 28862 | 3 | |
39772 | 37176 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 66 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53571 | 6006281.21006007 | 2099680.48261535 | 37.7456779723428 | -122.420983236738 | (37.7456779723428, -122.420983236738) | 2 | 7 | 5 | 28859 | 2 | ||
40259 | 87164 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
43563 | 107302 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 333 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2014 12:00:00 AM | Permit Number 767149 | 6015127.71951 | 2114620.09555 | 37.7871935864977 | -122.391437295808 | (37.7871935864977, -122.391437295808) | 6 | 2 | 9 | 28855 | 6 | |||
45397 | 68470 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 2693 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52653 | 6010006.82390597 | 2103360.38504848 | 37.7559914761443 | -122.408360072526 | (37.7559914761443, -122.408360072526) | 2 | 4 | 7 | 28859 | 19 | ||
51520 | 115166 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 402 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775277 | 5998511.59251 | 2106738.31574 | 37.7646160064689 | -122.448357464082 | (37.7646160064689, -122.448357464082) | 15 | 5 | 11 | 29492 | 9 | |||
55941 | 92105 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1398 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52306 | 6016081.4 | 2093420.8 | 37.7290377092769 | -122.386658900514 | (37.7290377092769, -122.386658900514) | 10 | 3 | 8 | 58 | 1 | ||
56225 | 87168 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
57495 | 92104 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1398 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52306 | 6016081.4 | 2093420.8 | 37.7290377092769 | -122.386658900514 | (37.7290377092769, -122.386658900514) | 10 | 3 | 8 | 58 | 1 | ||
58079 | 107301 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 333 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2014 12:00:00 AM | Permit Number 767149 | 6015127.71951 | 2114620.09555 | 37.7871935864977 | -122.391437295808 | (37.7871935864977, -122.391437295808) | 6 | 2 | 9 | 28855 | 6 | |||
59872 | 87476 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 4437 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51125 | 6000067 | 2105741 | 37.7619664283465 | -122.442906118301 | (37.7619664283465, -122.442906118301) | 15 | 5 | 5 | 28862 | 3 | ||
63355 | 87166 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
63928 | 83171 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1590X Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
65207 | 88077 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1590X Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015266 | 2094609 | 37.7322550915976 | -122.389560775326 | (37.7322550915976, -122.389560775326) | 10 | 3 | 8 | 58 | 1 | ||
71392 | 114643 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 609 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774764 | 6009663.9 | 2100372.9 | 37.7477692975566 | -122.409335202939 | (37.7477692975566, -122.409335202939) | 2 | 7 | 7 | 28859 | 2 | |||
77344 | 40938 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 250 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52425 | 6008608.67126022 | 2109716.51836429 | 37.7733655563777 | -122.413644912079 | (37.7733655563777, -122.413644912079) | 8 | 2 | 9 | 28853 | 34 | ||
77479 | 92383 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1201 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53830 | 6008606 | 2116275 | 37.791373424148 | -122.414118235332 | (37.791373424148, -122.414118235332) | 5 | 1 | 10 | 28858 | 21 | |
78621 | 66687 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 45 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50886 | 5998400.68996099 | 2107200.48527227 | 37.7658786660886 | -122.448774336236 | (37.7658786660886, -122.448774336236) | 15 | 5 | 11 | 29492 | 9 | ||
79940 | 94899 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 175 Napoleon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53956 | 6012540.6 | 2099965.5 | 37.7468114191046 | -122.399359061968 | (37.7468114191046, -122.399359061968) | 10 | 3 | 8 | 58 | 1 | |
80823 | 52956 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 478 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53570 | 5993279.13745627 | 2090341.45680434 | 37.7192938259954 | -122.465263870468 | (37.7192938259954, -122.465263870468) | 9 | 8 | 6 | 64 | 24 | ||
86199 | 96058 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 118 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767686 | 6008231 | 2099363 | 37.7449159511255 | -122.414218673139 | (37.7449159511255, -122.414218673139) | 2 | 7 | 7 | 28859 | 2 | |
91668 | 115165 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 402 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775277 | 5998511.59251 | 2106738.31574 | 37.7646160064689 | -122.448357464082 | (37.7646160064689, -122.448357464082) | 15 | 5 | 11 | 29492 | 9 | |||
94844 | 92106 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1398 Shafter Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52306 | 6016081.4 | 2093420.8 | 37.7290377092769 | -122.386658900514 | (37.7290377092769, -122.386658900514) | 10 | 3 | 8 | 58 | 1 | ||
94947 | 87174 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
100036 | 82120 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 294 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49836 | 5995382.14705323 | 2097514.68391142 | 37.7391108272782 | -122.458513580611 | (37.7391108272782, -122.458513580611) | 9 | 7 | 4 | 59 | 40 | ||
100246 | 92103 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1398 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52306 | 6016081.4 | 2093420.8 | 37.7290377092769 | -122.386658900514 | (37.7290377092769, -122.386658900514) | 10 | 3 | 8 | 58 | 1 | ||
106145 | 115164 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 112 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775244 | 5999576 | 2106584.4 | 37.7642541893967 | -122.444664912175 | (37.7642541893967, -122.444664912175) | 15 | 5 | 5 | 29492 | 9 | |||
112099 | 52186 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 117 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52618 | 6001741.54156575 | 2105161.20855715 | 37.7604697895723 | -122.437073031468 | (37.7604697895723, -122.437073031468) | 2 | 4 | 5 | 28862 | 3 | |
116274 | 55695 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 51 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52581 | 6005948.92964432 | 2097719.44263908 | 37.7402746636122 | -122.421992931257 | (37.7402746636122, -122.421992931257) | 2 | 7 | 7 | 28859 | 2 | ||
122383 | 96070 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 757 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767694 | 6008574.7 | 2104126.2 | 37.7580139286583 | -122.413367004042 | (37.7580139286583, -122.413367004042) | 2 | 4 | 7 | 28859 | 19 | |
126826 | 87161 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
127171 | 83006 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1590X Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
127514 | 87173 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
136515 | 87170 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
136952 | 87167 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
141193 | 96069 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 757 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767694 | 6008574.7 | 2104126.2 | 37.7580139286583 | -122.413367004042 | (37.7580139286583, -122.413367004042) | 2 | 4 | 7 | 28859 | 19 | |
142690 | 84529 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 698X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52659 | 6009314.54246303 | 2104977.65271839 | 37.7603933359548 | -122.410868438641 | (37.7603933359548, -122.410868438641) | 2 | 4 | 7 | 28859 | 19 | ||
148021 | 84528 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 698X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52659 | 6009314.54246303 | 2104977.65271839 | 37.7603933359548 | -122.410868438641 | (37.7603933359548, -122.410868438641) | 2 | 4 | 7 | 28859 | 19 | ||
152376 | 38835 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 254 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50625 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
153771 | 87162 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
165180 | 87171 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
166169 | 94900 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 175 Napoleon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53956 | 6012540.6 | 2099965.5 | 37.7468114191046 | -122.399359061968 | (37.7468114191046, -122.399359061968) | 10 | 3 | 8 | 58 | 1 | |
166905 | 83671 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 25 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52293 | 6013925.21011822 | 2094015.07224933 | 37.7305498525123 | -122.394154659806 | (37.7305498525123, -122.394154659806) | 10 | 3 | 8 | 58 | 1 | ||
169640 | 87163 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
172884 | 87172 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
175169 | 80633 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 285 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52574 | 6006308.16820091 | 2098297.87960957 | 37.7418831759387 | -122.420791880852 | (37.7418831759387, -122.420791880852) | 2 | 7 | 7 | 28859 | 2 | ||
178318 | 87169 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 215 Napoleon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50142 | 6012245.5 | 2099714 | 37.7461044022911 | -122.400361833701 | (37.7461044022911, -122.400361833701) | 10 | 3 | 8 | 58 | 1 | ||
19834 | 177450 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 655 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010679.56487 | 2091598.96237 | 37.7237347842164 | -122.405205320887 | (37.7237347842164, -122.405205320887) | 10 | 3 | 7 | 309 | 28 | |||
84320 | 100189 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 160 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 772698 | 5995944.7835 | 2113256.71049 | 37.7823667267913 | -122.457707006716 | (37.7823667267913, -122.457707006716) | 11 | 6 | 1 | 54 | 31 | ||
91408 | 103423 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 131 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2015 12:00:00 AM | 1 | 3x3 | Permit Number 770059 | 6012899.88652 | 2106401.44605 | 37.7645031444165 | -122.398568227055 | (37.7645031444165, -122.398568227055) | 14 | 3 | 8 | 28856 | 29 | |
92816 | 100348 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 622 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 1 | 8x10 | Permit Number 769139 | 6013248.11312 | 2104189.70179 | 37.7584495748051 | -122.397208694044 | (37.7584495748051, -122.397208694044) | 10 | 3 | 8 | 28856 | 29 | |
190496 | 65898 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 160 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2014 12:00:00 AM | 1 | 3x3 | Permit Number 772698 | 5995945.63615 | 2113245.27605 | 37.7823353798467 | -122.457703229311 | (37.7823353798467, -122.457703229311) | 11 | 6 | 1 | 54 | 31 |
6729 | 61585 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 748 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 10 | Permit Number 21549 | 6012696.34573 | 2104009.38799 | 37.7579237394054 | -122.399104307512 | (37.7579237394054, -122.399104307512) | 10 | 3 | 8 | 28856 | 29 | |
27699 | 230374 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 725 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008540.74616 | 2104312.6152 | 37.7585238758885 | -122.413497615138 | (37.7585238758885, -122.413497615138) | 2 | 4 | 7 | 28859 | 19 | |||
130493 | 193385 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1701 19th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012546.6255 | 2105147.54735 | 37.7610405297218 | -122.399702020336 | (37.7610405297218, -122.399702020336) | 10 | 3 | 8 | 28856 | 29 | |||
86581 | 193379 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 500 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6012632.72668 | 2105144.08354 | 37.7610358181789 | -122.399403988597 | (37.7610358181789, -122.399403988597) | 10 | 3 | 8 | 28856 | 29 | |||
113990 | 230364 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1384 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009527.68213 | 2101137.2789 | 37.7498604799747 | -122.409860188422 | (37.7498604799747, -122.409860188422) | 2 | 4 | 7 | 28859 | 19 | |||
175535 | 31536 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1360 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 11 | Permit Number 35087 | 6011404.38341 | 2101989.62813 | 37.7523058418456 | -122.403430390111 | (37.7523058418456, -122.403430390111) | 10 | 4 | 8 | 28859 | 19 | |
55116 | 193389 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 357 Missouri St | 1 | : | Tree | Private 2 | 12 | Width 6ft | 6013519.95695 | 2105414.95396 | 37.7618289797317 | -122.396354408227 | (37.7618289797317, -122.396354408227) | 10 | 3 | 8 | 28856 | 29 | |||
158785 | 193386 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1701 19th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012561.08135 | 2105147.58467 | 37.7610414380218 | -122.399652026121 | (37.7610414380218, -122.399652026121) | 10 | 3 | 8 | 28856 | 29 | |||
162469 | 193380 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 572 Wisconsin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6012652.42015 | 2104742.48091 | 37.7599342035261 | -122.399307683824 | (37.7599342035261, -122.399307683824) | 10 | 3 | 8 | 28856 | 29 | |||
30928 | 2990 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 2266X California St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003475.85532 | 2115607.4866 | 37.7892511192874 | -122.431820734356 | (37.7892511192874, -122.431820734356) | 13 | 9 | 1 | 29490 | 27 | |||
31280 | 18477 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1290 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/1991 12:00:00 AM | 18 | 3x3 | 6010548.57225 | 2101900.54788 | 37.7520134093027 | -122.406383660293 | (37.7520134093027, -122.406383660293) | 10 | 4 | 7 | 28859 | 19 | ||
137336 | 105297 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 15 Karen Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774558 | 6010447 | 2091541 | 37.7235626269277 | -122.406005180928 | (37.7235626269277, -122.406005180928) | 10 | 3 | 7 | 309 | 28 | |
172947 | 18479 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1290 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/1991 12:00:00 AM | 18 | 3x3 | 6010549.62955 | 2101874.40132 | 37.7519416757657 | -122.406378161838 | (37.7519416757657, -122.406378161838) | 10 | 4 | 7 | 28859 | 19 | ||
24097 | 230366 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 62 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 7ft | 6006279.39712 | 2099668.25681 | 37.7456443008565 | -122.420988637738 | (37.7456443008565, -122.420988637738) | 2 | 7 | 5 | 28859 | 2 | |||
69443 | 193390 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 151 Napoleon St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012604.40245 | 2099978.37692 | 37.7468503321847 | -122.399139341508 | (37.7468503321847, -122.399139341508) | 10 | 3 | 8 | 58 | 1 | |||
73009 | 230372 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1248 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010819.23677 | 2102490.41358 | 37.7536481879148 | -122.405489197274 | (37.7536481879148, -122.405489197274) | 10 | 4 | 8 | 28859 | 19 | |||
76690 | 102795 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 873 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770021 | 6012177.73114 | 2104340.16154 | 37.758803056042 | -122.400921145798 | (37.758803056042, -122.400921145798) | 10 | 3 | 8 | 28856 | 29 | |
129346 | 37941 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 730 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | 2 | Permit Number 40183 | 6015640.36164 | 2103965.71 | 37.7579674311726 | -122.388919522216 | (37.7579674311726, -122.388919522216) | 10 | 3 | 8 | 28856 | 29 | ||
192527 | 193403 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 151 Napoleon St | 14 | : | Tree | Private 2 | 2 | Width 3ft | 6012896.33959 | 2100027.519 | 37.7470015307137 | -122.398133290628 | (37.7470015307137, -122.398133290628) | 10 | 3 | 8 | 58 | 1 | |||
185724 | 687 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1299X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | 6010636.02258 | 2101844.69134 | 37.7518649312223 | -122.406077308042 | (37.7518649312223, -122.406077308042) | 10 | 4 | 8 | 28859 | 19 | |||
6664 | 226514 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1225 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781565 | 6005204.64951 | 2101211.39699 | 37.7498207677153 | -122.424814719741 | (37.7498207677153, -122.424814719741) | 2 | 4 | 5 | 28859 | 19 | |
11438 | 18389 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 852 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/02/2005 12:00:00 AM | 3 | 3x3 | 6010416.63719 | 2104254.12877 | 37.7584684371764 | -122.407005787885 | (37.7584684371764, -122.407005787885) | 10 | 4 | 7 | 28859 | 19 | ||
29356 | 193396 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 151 Napoleon St | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6012770.52712 | 2100020.27801 | 37.7469746400861 | -122.398567834043 | (37.7469746400861, -122.398567834043) | 10 | 3 | 8 | 58 | 1 | |||
46804 | 106764 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 2900x Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | Permit Number 781463 | 6003486.1984 | 2118369.16676 | 37.7968345724214 | -122.431982232797 | (37.7968345724214, -122.431982232797) | 13 | 9 | 1 | 57 | 17 | ||
46834 | 193404 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 151 Napoleon St | 15 | : | Tree | Private 2 | 3 | Width 3ft | 6012914.94166 | 2100028.77373 | 37.7470060120314 | -122.398069053866 | (37.7470060120314, -122.398069053866) | 10 | 3 | 8 | 58 | 1 | |||
58086 | 110035 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 160 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2015 12:00:00 AM | 3 | Permit Number 775209 | 5997364.1 | 2109993.9 | 37.7734893336863 | -122.452561279096 | (37.7734893336863, -122.452561279096) | 15 | 5 | 11 | 29492 | 16 | |
60710 | 193378 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1301 Minnesota St | 40 | Front Yard : Yard | Tree | Private 2 | 3 | 6015354.84712 | 2102508.01149 | 37.7539490714005 | -122.38980514399 | (37.7539490714005, -122.38980514399) | 10 | 3 | 8 | 28856 | 29 | ||||
62780 | 193399 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 151 Napoleon St | 10 | : | Tree | Private 2 | 3 | Width 3ft | 6012824.86969 | 2100023.70943 | 37.7469870893958 | -122.398380161711 | (37.7469870893958, -122.398380161711) | 10 | 3 | 8 | 58 | 1 | |||
77305 | 5434 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 500X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/14/2009 12:00:00 AM | 3 | 6 | 6004889.66204 | 2105352.28361 | 37.7611728766429 | -122.426198728713 | (37.7611728766429, -122.426198728713) | 2 | 4 | 5 | 28862 | 3 | ||
80562 | 66075 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 381 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51883 | 6013523.39392 | 2105319.18697 | 37.7615662158338 | -122.396335808474 | (37.7615662158338, -122.396335808474) | 10 | 3 | 8 | 28856 | 29 | |
85362 | 193393 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 151 Napoleon St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6012653.35348 | 2099999.03044 | 37.7469097701736 | -122.398971521724 | (37.7469097701736, -122.398971521724) | 10 | 3 | 8 | 58 | 1 | |||
94993 | 193397 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 151 Napoleon St | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6012788.95459 | 2100021.89909 | 37.7469801178326 | -122.398504226789 | (37.7469801178326, -122.398504226789) | 10 | 3 | 8 | 58 | 1 | |||
96132 | 28124 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 112 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2004 12:00:00 AM | 3 | 3X3 | 5995536.80725 | 2115362.80117 | 37.7881260406124 | -122.459270977229 | (37.7881260406124, -122.459270977229) | 11 | 6 | 1 | 54 | 31 | ||
100619 | 102067 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 24 Coso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769727 | 6007035.7 | 2099866.2 | 37.7462304116746 | -122.418387482558 | (37.7462304116746, -122.418387482558) | 2 | 7 | 7 | 28859 | 2 |
103125 | 115402 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 218 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776284 | 6005779.9 | 2096086.1 | 37.7357803359495 | -122.422461340443 | (37.7357803359495, -122.422461340443) | 2 | 7 | 7 | 28859 | 2 | ||
104868 | 108264 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 400x ELIZABETH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2015 12:00:00 AM | 3 | 4x5 | Permit Number 774411 | 6003752 | 2102232 | 37.7525409491736 | -122.429910836031 | (37.7525409491736, -122.429910836031) | 2 | 4 | 5 | 28862 | 22 | |
107675 | 5433 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 500X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2008 12:00:00 AM | 3 | 6 | 6004888.03452 | 2105376.13123 | 37.7612382645653 | -122.426206055463 | (37.7612382645653, -122.426206055463) | 2 | 4 | 5 | 28862 | 3 | ||
112138 | 82260 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 850 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2011 12:00:00 AM | 3 | 4x4 | Permit Number 768603 | 6007525.28639452 | 2104705.22805815 | 37.7595448304107 | -122.417037358657 | (37.7595448304107, -122.417037358657) | 2 | 4 | 7 | 28859 | 19 |
115922 | 102762 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 100X Russ St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.408218187711 | (37.7785759102049, -122.408218187711) | 14 | 2 | 9 | 28853 | 34 |
117896 | 46979 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1310 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 3 | Permit Number 44998 | 6015318.4768 | 2102468.70414 | 37.7538391247792 | -122.389928176664 | (37.7538391247792, -122.389928176664) | 10 | 3 | 8 | 28856 | 29 |
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) );