trees
979 rows where qSpecies_id = 13 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3743 | 193316 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6013300.83104 | 2113672.81478 | 37.7844910077044 | -122.397691511273 | (37.7844910077044, -122.397691511273) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 54957 | 193353 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 75 Latona St | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6014356.71381 | 2094130.91489 | 37.7308919074363 | -122.392670976684 | (37.7308919074363, -122.392670976684) | 10 | 3 | 8 | 58 | 1 | |||
| 60800 | 230281 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Haight St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005261.48002 | 2109543.28647 | 37.772701377697 | -122.425210996096 | (37.772701377697, -122.425210996096) | 7 | 9 | 11 | 28852 | 10 | |||
| 69450 | 250184 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 665 Parker Ave | 1 | : | Tree | Private 2 | 2 | Width 4ft | 5997216.13133 | 2110917.44789 | 37.7760166771611 | -122.453139804667 | (37.7760166771611, -122.453139804667) | 15 | 6 | 2 | 54 | 16 | |||
| 71219 | 193342 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 401 Texas St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013812.69862 | 2105193.07398 | 37.7612360315304 | -122.395326379719 | (37.7612360315304, -122.395326379719) | 10 | 3 | 8 | 28856 | 29 | |||
| 102407 | 193347 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 444 Mississippi St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6014042.11061 | 2105043.11718 | 37.7608370392312 | -122.394522434371 | (37.7608370392312, -122.394522434371) | 10 | 3 | 8 | 28856 | 29 | |||
| 107537 | 193351 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1752 Quesada Ave | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6014452.02014 | 2095263.45344 | 37.7340069206852 | -122.392420670182 | (37.7340069206852, -122.392420670182) | 10 | 3 | 8 | 58 | 1 | |||
| 109857 | 250185 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 665 Parker Ave | 2 | : | Tree | Private 2 | 2 | Width 4ft | 5997218.61444 | 2110901.95743 | 37.7759742867055 | -122.453130096488 | (37.7759742867055, -122.453130096488) | 15 | 6 | 2 | 54 | 16 | |||
| 126159 | 246460 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Duncan St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005150.47679 | 2099924.83113 | 37.7462850938946 | -122.424910529003 | (37.7462850938946, -122.424910529003) | 2 | 7 | 5 | 63 | 22 | |||
| 131548 | 246808 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 162 Brewster St | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6010230.46229 | 2099004.50541 | 37.744043711743 | -122.407279600877 | (37.744043711743, -122.407279600877) | 2 | 7 | 7 | 28859 | 2 | |||
| 142577 | 247756 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 52 Alpine Ter | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6001615.48849 | 2108494.65039 | 37.7696154359451 | -122.437747736977 | (37.7696154359451, -122.437747736977) | 15 | 5 | 5 | 29492 | 9 | |||
| 151472 | 193354 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 75 Latona St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6014363.50892 | 2094164.90475 | 37.7309856140862 | -122.392649861509 | (37.7309856140862, -122.392649861509) | 10 | 3 | 8 | 58 | 1 | |||
| 152301 | 193350 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1752 Quesada Ave | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6014471.5284 | 2095248.21375 | 37.7339661589078 | -122.392352158028 | (37.7339661589078, -122.392352158028) | 10 | 3 | 8 | 58 | 1 | |||
| 173449 | 193315 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6013291.13873 | 2113684.88595 | 37.7845236126199 | -122.39772589056 | (37.7845236126199, -122.39772589056) | 6 | 2 | 9 | 28856 | 6 | |||
| 179747 | 193343 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 698 Arkansas St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012989.11402 | 2103849.31958 | 37.7575005373464 | -122.398080555283 | (37.7575005373464, -122.398080555283) | 10 | 3 | 8 | 28856 | 29 | |||
| 186211 | 247777 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 240 30th St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005014.99439 | 2098457.52943 | 37.7422485651112 | -122.425274616848 | (37.7422485651112, -122.425274616848) | 2 | 7 | 5 | 63 | 22 | |||
| 187624 | 246941 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 269 Frederick St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5998752.12288 | 2107600.57401 | 37.7669972990085 | -122.447587610674 | (37.7669972990085, -122.447587610674) | 15 | 5 | 11 | 29492 | 9 | |||
| 192930 | 193352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1707 McKinnon Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014777.57623 | 2096343.32459 | 37.736990099615 | -122.391370577692 | (37.736990099615, -122.391370577692) | 10 | 3 | 8 | 58 | 1 | |||
| 12808 | 254368 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 590X Orizaba Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
| 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 | ||
| 3226 | 107892 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 162 Brewster St | Front Yard : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.407278527778 | (37.7440766668365, -122.407278527778) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 |
| 64837 | 253415 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 Stoneybrook Ave | Front Yard : Cutout | Tree | Private 2 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.42686 | 37.7299849530428 | -122.421802746417 | (37.7299849530428, -122.421802746417) | 9 | 7 | 6 | 28861 | 5 | |||
| 131019 | 114688 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 231 Dwight St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.7232793364177 | -122.404549596707 | (37.7232793364177, -122.404549596707) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | ||
| 172950 | 87071 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 2 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 179923 | 122379 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 466 Vernon St | 1 | Front Yard : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521 | 2090937 | 37.7208852925782 | -122.467927737968 | (37.7208852925782, -122.467927737968) | 9 | 8 | 6 | 64 | 24 | ||
| 188216 | 87070 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 4724 | 262586 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
| 9218 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 188 The Embarcadero | 1 | Front Yard : Yard | Tree | Private 2 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | 12 | 2 | 9 | 28855 | 6 | |||
| 12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 15827 | 262585 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 101232 | 107902 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 Elsie St | Front Yard : Yard | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | Permit Number 773996 | 6007164.40736 | 2098513.65139 | 37.742523860764 | -122.417846568545 | (37.742523860764, -122.417846568545) | 2 | 7 | 7 | 28859 | 2 | |||
| 139506 | 254366 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
| 158442 | 254367 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
| 192239 | 107674 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 ELSIE ST | 1 | Front Yard : Yard | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | 6007164.4 | 2098513.7 | 37.742523993822 | -122.417846597438 | (37.742523993822, -122.417846597438) | 2 | 7 | 7 | 28859 | 2 | |||
| 76797 | 177417 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1x Rolph St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 4ft | 6000503.4246 | 2088653.73075 | 37.7150736797726 | -122.440171325345 | (37.7150736797726, -122.440171325345) | 9 | 7 | 6 | 28861 | 5 | |||
| 152426 | 450 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 700x 23rd Ave | 10 | Median : Cutout | Tree | DPW 1 | 05/29/2015 01:42:00 PM | 3 | 5988819.93055 | 2110324.80979 | 37.773904673102 | -122.482140704549 | (37.773904673102, -122.482140704549) | 11 | 6 | 2 | 55 | 26 | |||
| 3991 | 131008 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 3 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013685.84477 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | 4 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 68819 | 131009 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 4 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013684.35472 | 2117443.22893 | 37.7948650355324 | -122.396629040522 | (37.7948650355324, -122.396629040522) | 4 | 1 | 10 | 28860 | 6 | |||
| 74008 | 249952 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 3 | Side Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011371.46837 | 2120040.8031 | 37.8018683513038 | -122.404814962944 | (37.8018683513038, -122.404814962944) | 3 | 1 | 10 | 308 | 23 | |||
| 93475 | 249954 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011374.5207 | 2120037.63727 | 37.8018598293151 | -122.404804177386 | (37.8018598293151, -122.404804177386) | 3 | 1 | 10 | 308 | 23 | |||
| 96748 | 249953 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011372.65237 | 2120041.55492 | 37.8018704817969 | -122.404810918689 | (37.8018704817969, -122.404810918689) | 3 | 1 | 10 | 308 | 23 | |||
| 97084 | 250221 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 312 Filbert St | 2 | Side Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011282.00764 | 2120080.85256 | 37.8019733165766 | -122.405127362244 | (37.8019733165766, -122.405127362244) | 3 | 1 | 10 | 308 | 23 | |||
| 114696 | 193341 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1751 22nd St | 6 | Side Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6012847.48484 | 2103764.38864 | 37.7572594461781 | -122.398564409431 | (37.7572594461781, -122.398564409431) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 66805 | 258499 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
| 73635 | 98412 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 4 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
| 76660 | 98411 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 3 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
| 80624 | 98410 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
| 85859 | 258498 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
| 37 | 264963 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | 6005706 | 2110306 | 37.7748207071365 | -122.423727591769 | (37.7748207071365, -122.423727591769) | 7 | 9 | 11 | 28852 | 10 | ||
| 558 | 230313 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 968 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010194.52879 | 2103588.60829 | 37.7566286356186 | -122.407727015404 | (37.7566286356186, -122.407727015404) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 743 | 236478 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 222 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785288 | 6007898.7538 | 2097586.28669 | 37.7400188220044 | -122.415241775611 | (37.7400188220044, -122.415241775611) | 2 | 7 | 7 | 28859 | 2 | |
| 863 | 230293 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006188.70146 | 2104951.15176 | 37.7601448013679 | -122.421677407793 | (37.7601448013679, -122.421677407793) | 2 | 4 | 5 | 28859 | 19 | ||
| 895 | 56729 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |
| 1439 | 72311 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3769 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5996250.37824 | 2115874.50597 | 37.7895720432509 | -122.456839183887 | (37.7895720432509, -122.456839183887) | 11 | 6 | 1 | 54 | 31 | |||
| 1513 | 146932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 619 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:30:00 PM | 0 | Width 3ft | 5982546.66357 | 2111553.12275 | 37.7769103910512 | -122.503931600958 | (37.7769103910512, -122.503931600958) | 11 | 6 | 2 | 55 | 26 | ||
| 1556 | 158441 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 49 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785489 | 6002069.34164 | 2096386.56921 | 37.7363953338756 | -122.435311658815 | (37.7363953338756, -122.435311658815) | 2 | 7 | 5 | 63 | 7 | |
| 1859 | 243453 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 73 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 04/01/2016 12:00:00 AM | 0 | 4x6 | Permit Number 777687 | 6007416.81803 | 2098970.61704 | 37.7437927883108 | -122.417006175297 | (37.7437927883108, -122.417006175297) | 2 | 7 | 7 | 28859 | 2 |
| 1903 | 220552 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 13 Ohlone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 785489 | 6002169.64489 | 2096371.31931 | 37.7363591568587 | -122.434963778568 | (37.7363591568587, -122.434963778568) | 2 | 7 | 5 | 63 | 7 | ||
| 2106 | 193374 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008975.96564 | 2110229.86919 | 37.7747957152898 | -122.412410677425 | (37.7747957152898, -122.412410677425) | 8 | 2 | 9 | 28853 | 34 | |||
| 2285 | 95676 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.10714 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) | 10 | 3 | 7 | 309 | 28 |
| 2308 | 144457 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 566 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/2019 12:00:00 AM | 3 | 4x6 | 5987536.08738 | 2112106.24218 | 37.7787212290426 | -122.486712509289 | (37.7787212290426, -122.486712509289) | 11 | 6 | 2 | 55 | 26 | |
| 2501 | 78191 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 680 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6015407.71241 | 2105894.14692 | 37.7632496064147 | -122.389858829046 | (37.7632496064147, -122.389858829046) | 14 | 3 | 8 | 28856 | 29 | |||
| 2571 | 219957 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3933 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003591.26694 | 2101840.52548 | 37.7514569483989 | -122.430438748853 | (37.7514569483989, -122.430438748853) | 2 | 4 | 5 | 28862 | 22 | |||
| 2708 | 50426 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2014 12:00:00 AM | 3 | Permit Number 773627 | 5997303.25557645 | 2090612.9654569 | 37.7202705700793 | -122.45137364778 | (37.7202705700793, -122.45137364778) | 9 | 8 | 6 | 28861 | 24 | |
| 3141 | 117754 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 406 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5983780.49053 | 2113060.07342 | 37.7811205143771 | -122.499774894109 | (37.7811205143771, -122.499774894109) | 11 | 6 | 2 | 55 | 26 | |||
| 3356 | 74692 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | 3 | 1 | 10 | 308 | 23 | |||
| 3837 | 255657 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1421 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2018 12:00:00 AM | 3 | 6000959.70168 | 2111031.39919 | 37.7765434007218 | -122.44019801367 | (37.7765434007218, -122.44019801367) | 15 | 5 | 11 | 29492 | 10 | |||
| 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 | |
| 4377 | 88323 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417 | 2092629 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 4564 | 264686 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2455 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782284 | 5990129.23032 | 2098669.31502 | 37.7419778589065 | -122.476759924113 | (37.7419778589065, -122.476759924113) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | |||
| 4723 | 259742 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 259 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/11/2019 12:00:00 AM | 3 | 6005340.35583 | 2109906.90312 | 37.7737042366543 | -122.424964031136 | (37.7737042366543, -122.424964031136) | 7 | 9 | 11 | 28852 | 10 | ||
| 4773 | 165865 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x4 | 6006836.83511 | 2097542.23848 | 37.7398381374333 | -122.418910337746 | (37.7398381374333, -122.418910337746) | 2 | 7 | 7 | 28859 | 2 | |||
| 4879 | 260889 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981905.91133 | 2112171.65096 | 37.7785709887537 | -122.506193994794 | (37.7785709887537, -122.506193994794) | 11 | 6 | 2 | 55 | 26 | |||
| 4904 | 144219 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 876 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982678 | 2109818 | 37.7721539708604 | -122.503348768347 | (37.7721539708604, -122.503348768347) | 11 | 6 | 2 | 55 | 26 | ||
| 4996 | 255545 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201X San Carlos St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006716 | 2104916 | 37.7600780028247 | -122.419851234809 | (37.7600780028247, -122.419851234809) | 2 | 4 | 7 | 28859 | 19 | ||||
| 5106 | 147909 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 69 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5995874.31253 | 2112332.21787 | 37.7798242673223 | -122.45788388223 | (37.7798242673223, -122.45788388223) | 11 | 6 | 2 | 54 | 16 | |||
| 5226 | 259803 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 5290 | 89193 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | |||||
| 5292 | 241594 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 687 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007646.0169 | 2096174.81068 | 37.7361290122323 | -122.416015706955 | (37.7361290122323, -122.416015706955) | 2 | 7 | 7 | 28859 | 2 |
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) );