trees
979 rows where qSpecies_id = 13 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109571 | 177421 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 0 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001079.38248 | 2091791.86287 | 37.7237230579705 | -122.438405269984 | (37.7237230579705, -122.438405269984) | 9 | 7 | 6 | 28861 | 25 | |||
155652 | 177422 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 0 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001061.39064 | 2091803.12496 | 37.7237529577069 | -122.438468271097 | (37.7237529577069, -122.438468271097) | 9 | 7 | 6 | 28861 | 25 | |||
183715 | 114593 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1 BRADFORD ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15 | 6x9 | 6009441 | 2096050 | 37.7358870660731 | -122.409800886333 | (37.7358870660731, -122.409800886333) | 10 | 7 | 7 | 28859 | 2 | |||
50384 | 208857 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5997408.76137 | 2093610.56673 | 37.7285073190505 | -122.451225020336 | (37.7285073190505, -122.451225020336) | 9 | 7 | 4 | 28861 | 40 | |||
58994 | 114753 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777133 | 6010495.97692 | 2091580.43732 | 37.7236736527876 | -122.405838652231 | (37.7236736527876, -122.405838652231) | 10 | 3 | 7 | 309 | 28 | ||
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 | |
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 | |
137284 | 46093 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 100 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | 4 | Permit Number 44465 | 5989926.67635 | 2114640.81602 | 37.785819536272 | -122.478628027687 | (37.785819536272, -122.478628027687) | 11 | 6 | 2 | 55 | 26 | ||
120185 | 30531 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 100 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/1986 12:00:00 AM | 2 | 3x3 | Permit Number 34534 | 5989617.18715 | 2114630.73389 | 37.7857738797228 | -122.479698023599 | (37.7857738797228, -122.479698023599) | 11 | 6 | 2 | 55 | 26 |
116128 | 177419 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 100 Capistrano Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001443.85417 | 2093560.72279 | 37.7286006695825 | -122.437271950666 | (37.7286006695825, -122.437271950666) | 9 | 7 | 6 | 28861 | 25 | |||
80700 | 253542 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 10 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:42:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
95991 | 253541 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 9 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 03:59:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
106265 | 253543 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 11 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:35:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
118918 | 253544 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 12 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:38:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
163713 | 253540 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 8 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 04:11:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
50069 | 130988 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008672.99088 | 2115994.19666 | 37.7906061691929 | -122.41386657548 | (37.7906061691929, -122.41386657548) | 5 | 1 | 10 | 28857 | 21 | |||
172181 | 130989 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008668.89448 | 2116022.78913 | 37.7906844470866 | -122.413882772283 | (37.7906844470866, -122.413882772283) | 5 | 1 | 10 | 28857 | 21 | |||
23205 | 81367 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.419830397182 | (37.7858955407321, -122.419830397182) | 13 | 9 | 9 | 28858 | 36 | |||
104335 | 120377 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5987995.99107 | 2115194.27342 | 37.7872268871617 | -122.485348201277 | (37.7872268871617, -122.485348201277) | 11 | 6 | 1 | 55 | 33 | |||
4664 | 171655 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007664.95872 | 2093252.16101 | 37.7281051161408 | -122.415743336498 | (37.7281051161408, -122.415743336498) | 9 | 3 | 7 | 309 | 5 | |||
51683 | 87914 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Wool St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398 | 2097753 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | 2 | 7 | 7 | 28859 | 2 | ||
81178 | 87912 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Wool St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398 | 2097753 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | 2 | 7 | 7 | 28859 | 2 | ||
126866 | 87913 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Wool St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398 | 2097753 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | 2 | 7 | 7 | 28859 | 2 | ||
148308 | 87911 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398 | 2097753 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | 2 | 7 | 7 | 28859 | 2 | ||
155964 | 59614 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1014 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767137 | 6015492.62077 | 2104343.80938 | 37.7589974211239 | -122.389456881532 | (37.7589974211239, -122.389456881532) | 10 | 3 | 8 | 28856 | 29 | |
117667 | 177448 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1022 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001291.58576 | 2086844.22821 | 37.7101500273691 | -122.437317616421 | (37.7101500273691, -122.437317616421) | 9 | 7 | 6 | 28861 | 5 | |||
162700 | 136 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1025X 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6001971.14414 | 2107605.72409 | 37.7671948800673 | -122.436453906645 | (37.7671948800673, -122.436453906645) | 15 | 5 | 5 | 28862 | 3 | |||
144821 | 114986 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1028 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 1 | Permit Number 770492 | 6001259.4385 | 2086848.65908 | 37.7101603659725 | -122.437429040618 | (37.7101603659725, -122.437429040618) | 9 | 7 | 6 | 28861 | 5 | ||
59490 | 12529 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 105 Lake St | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 07/12/2004 12:00:00 AM | 6 | 3x3 | Permit Number 773769 | 5995136.95364 | 2114887.49287 | 37.7867979761022 | -122.460619935074 | (37.7867979761022, -122.460619935074) | 11 | 6 | 1 | 54 | 11 |
171901 | 82180 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 105 Lake St | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.7867910649613 | -122.460471849521 | (37.7867910649613, -122.460471849521) | 11 | 6 | 1 | 54 | 11 | ||
178900 | 121810 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 106 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5989928.89895 | 2114601.72994 | 37.7857123459232 | -122.478617478776 | (37.7857123459232, -122.478617478776) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
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 | ||
143709 | 230301 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1083 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010010.1738 | 2102926.15109 | 37.754799354323 | -122.40831786098 | (37.754799354323, -122.40831786098) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |
121950 | 84574 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1090X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003150 | 2101890 | 37.7515677875779 | -122.431968234423 | (37.7515677875779, -122.431968234423) | 2 | 4 | 5 | 28862 | 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 | ||
79462 | 150164 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 3 | Width 3ft | 6014439.46295 | 2105255.42016 | 37.7614420590332 | -122.393163013761 | (37.7614420590332, -122.393163013761) | 10 | 3 | 8 | 28856 | 29 | ||
131049 | 150163 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 0 | Width 3ft | 6014400.34034 | 2105251.569 | 37.7614293111323 | -122.393298054181 | (37.7614293111323, -122.393298054181) | 10 | 3 | 8 | 28856 | 29 | ||
150561 | 150166 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 0 | Width 3ft | 6014482.7986 | 2105256.28423 | 37.7614468389081 | -122.393013193016 | (37.7614468389081, -122.393013193016) | 10 | 3 | 8 | 28856 | 29 | ||
10144 | 97101 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
74030 | 97099 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
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 | |
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 | |
126116 | 236828 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 11 Woodland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 783065 | 5997011.57389 | 2106623.6128 | 37.7642151878129 | -122.453537316698 | (37.7642151878129, -122.453537316698) | 15 | 5 | 11 | 29492 | 12 | |
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 | |||
78363 | 96057 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 110 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 2 | 3.5x6 | Permit Number 767685 | 6006775.4 | 2098937.3 | 37.7436652048745 | -122.419221689065 | (37.7436652048745, -122.419221689065) | 2 | 7 | 7 | 28859 | 2 |
131626 | 84840 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1107 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | 7 | Permit No. 49267 | 6009440.82091 | 2117125.31431 | 37.7937550347318 | -122.411289855968 | (37.7937550347318, -122.411289855968) | 3 | 1 | 10 | 28857 | 21 | ||
54419 | 131003 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011959.67514 | 2119544.33527 | 37.8005380309676 | -122.402744545519 | (37.8005380309676, -122.402744545519) | 3 | 1 | 10 | 308 | 23 | |||
108983 | 131005 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011966.28047 | 2119507.31076 | 37.8004367394276 | -122.40271908303 | (37.8004367394276, -122.40271908303) | 3 | 1 | 10 | 308 | 23 | |||
112413 | 131004 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011962.57681 | 2119524.82057 | 37.8004846103385 | -122.402733131341 | (37.8004846103385, -122.402733131341) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
143819 | 108839 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1112 Russia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770758 | 6003955.6442 | 2089384.80901 | 37.7172770009516 | -122.428291049376 | (37.7172770009516, -122.428291049376) | 9 | 7 | 6 | 28861 | 5 | |
167956 | 177400 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1112 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003994.8137 | 2089359.31728 | 37.7172092225078 | -122.428153843121 | (37.7172092225078, -122.428153843121) | 9 | 7 | 6 | 28861 | 5 | |||
171907 | 59600 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1116 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 9 | Permit Number 19001 | 6015518.08801 | 2103793.04215 | 37.757486543884 | -122.389330342431 | (37.757486543884, -122.389330342431) | 10 | 3 | 8 | 28856 | 29 | ||
37490 | 113226 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006956 | 2114756 | 37.787109810462 | -122.419719385886 | (37.787109810462, -122.419719385886) | 13 | 9 | 10 | 28858 | 21 | ||||
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 | |||
59269 | 193346 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1133 19th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6014187.49963 | 2105244.21667 | 37.761397296172 | -122.394033672633 | (37.761397296172, -122.394033672633) | 10 | 3 | 8 | 28856 | 29 | |||
104011 | 193345 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1133 19th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6014171.26133 | 2105242.63423 | 37.7613920486234 | -122.394089723782 | (37.7613920486234, -122.394089723782) | 10 | 3 | 8 | 28856 | 29 | |||
172647 | 193344 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1133 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6014141.435 | 2105240.82312 | 37.7613854179142 | -122.394192754591 | (37.7613854179142, -122.394192754591) | 10 | 3 | 8 | 28856 | 29 | |||
40470 | 87788 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
89811 | 87785 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
157236 | 87786 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
164923 | 87787 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
105559 | 103810 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
176203 | 103811 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
189600 | 103809 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
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 | |
34827 | 103801 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
38286 | 103800 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
177229 | 103802 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
114311 | 88268 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1158 Stanyan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51254 | 5997417.6 | 2106243.4 | 37.7631944867864 | -122.452105561067 | (37.7631944867864, -122.452105561067) | 15 | 5 | 11 | 29492 | 9 | |||
186179 | 230297 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008685.11737 | 2101744.284 | 37.7514799242568 | -122.412816735721 | (37.7514799242568, -122.412816735721) | 2 | 4 | 7 | 28859 | 19 | |||
112469 | 88269 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1175 Stanyan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51255 | 5997354 | 2106147 | 37.7629261534889 | -122.452318574624 | (37.7629261534889, -122.452318574624) | 15 | 5 | 11 | 29492 | 12 | |||
13493 | 170483 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 118 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003249.09726 | 2094449.59806 | 37.7311437787481 | -122.431094542601 | (37.7311437787481, -122.431094542601) | 9 | 7 | 5 | 28861 | 25 | ||
101891 | 193323 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1189 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015597.77316 | 2103545.22894 | 37.7568105190107 | -122.389037454833 | (37.7568105190107, -122.389037454833) | 10 | 3 | 8 | 28856 | 29 | |||
116145 | 110653 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1189 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2015 12:00:00 AM | 3 | 3x4 | 6015597.65588 | 2103555.71384 | 37.7568393018153 | -122.389038592471 | (37.7568393018153, -122.389038592471) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
90525 | 230323 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 12 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004674.70805 | 2103511.60917 | 37.7561066672951 | -122.426811073486 | (37.7561066672951, -122.426811073486) | 2 | 4 | 5 | 28862 | 22 | |||
141670 | 62233 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 120 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 3 | Permit Number 22359 | 6001435.36273 | 2093541.49048 | 37.7285473793362 | -122.437299929461 | (37.7285473793362, -122.437299929461) | 9 | 7 | 6 | 28861 | 25 | |
121719 | 12532 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 120 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6x7.4 | 5995061.51034 | 2114935.24706 | 37.7869247555074 | -122.460884411661 | (37.7869247555074, -122.460884411661) | 11 | 6 | 1 | 54 | 11 | |||
10565 | 65035 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1205 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51820 | 6003879.11104946 | 2101261.18670708 | 37.7498825208731 | -122.429402039878 | (37.7498825208731, -122.429402039878) | 2 | 4 | 5 | 28862 | 22 | ||
190423 | 177420 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Cotter St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6001985.26237 | 2093449.72899 | 37.7283266686193 | -122.435392337892 | (37.7283266686193, -122.435392337892) | 9 | 7 | 6 | 28861 | 25 | |||
73885 | 123609 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782700 | 5995062.26821 | 2114886.47744 | 37.786790890934 | -122.460878253711 | (37.786790890934, -122.460878253711) | 11 | 6 | 1 | 54 | 11 |
98197 | 123608 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2018 12:00:00 AM | 19 | Width 5ft | 5995078.16732 | 2114887.75716 | 37.7867953195114 | -122.46082333969 | (37.7867953195114, -122.46082333969) | 11 | 6 | 1 | 54 | 11 | ||
4490 | 224675 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007745.9196 | 2107233.93005 | 37.7665004685576 | -122.4164534151 | (37.7665004685576, -122.4164534151) | 8 | 4 | 7 | 28853 | 19 | |||
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 | ||
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 | ||
8414 | 260883 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 122 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988999.56708 | 2114522.30916 | 37.7854402782048 | -122.481826844764 | (37.7854402782048, -122.481826844764) | 11 | 6 | 2 | 55 | 26 | ||
741 | 262415 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 122 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003235 | 2094463 | 37.731179778599 | -122.431144235496 | (37.731179778599, -122.431144235496) | 9 | 7 | 5 | 28861 | 25 | ||
53361 | 230300 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1225 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010064.03861 | 2101924.13354 | 37.7520510531386 | -122.408060919271 | (37.7520510531386, -122.408060919271) | 2 | 4 | 7 | 28859 | 19 | |||
179999 | 94820 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1227 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53900 | 5992334 | 2107055.2 | 37.7651309632558 | -122.469746983482 | (37.7651309632558, -122.469746983482) | 11 | 8 | 11 | 56 | 12 | |
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 | |||
53557 | 67205 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 123 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1992 12:00:00 AM | 3 | Permit Number 30659 | 5987996.0292 | 2115149.70283 | 37.7871045112839 | -122.485344797558 | (37.7871045112839, -122.485344797558) | 11 | 6 | 1 | 55 | 33 | ||
7146 | 112795 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.7637354441658 | -122.499848016409 | (37.7637354441658, -122.499848016409) | 1 | 8 | 3 | 56 | 35 | |||
19938 | 103781 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1237 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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 | ||
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 | ||
174684 | 193329 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1240 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015301.01703 | 2102739.65572 | 37.7545821320765 | -122.390007483381 | (37.7545821320765, -122.390007483381) | 10 | 3 | 8 | 28856 | 29 | |||
46287 | 164504 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1241 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2018 12:00:00 AM | 3 | 4x4 | Permit Number 775664 | 5997725 | 2106255 | 37.7632439412228 | -122.451043208712 | (37.7632439412228, -122.451043208712) | 15 | 5 | 11 | 29492 | 9 |
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) );