Street_Tree_List

Data source: data.sfgov.org

830 rows where qSpecies = 88 sorted by PlantType

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType ▼ qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
500 6742 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1300X Fairfax Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 01:53:00 PM 3 3x3   6016901.500630001 2097278.26947 37.7396749203573 -122.384092237585 (37.7396749203573, -122.384092237585)
505 6741 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1300X Fairfax Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 01:50:00 PM 3 3x3   6016924.03316 2097256.8815900004 37.739617439282604 -122.38401284003099 (37.7396174392826, -122.384012840031)
528 248942 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1500x Galvez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/18/2017 12:56:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
1063 248924 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 201x Cashmere St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/29/2017 10:39:00 AM 3 3x3   6016272.0 2096170.0 37.7365970133228 -122.38619155869101 (37.7365970133228, -122.386191558691)
1480 251545 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 347 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6004948.0 2106317.0 37.7638250559684 -122.426065641314 (37.7638250559684, -122.426065641314)
2247 95100 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2200 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2014 12:00:00 AM 3 3x3 Permit Number 773992 5999642.14759 2120895.8486200003 37.8035534892505 -122.445465271815 (37.8035534892505, -122.445465271815)
2310 102805 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 600 Kansas St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011492.26434 2105507.65774 37.7619704808857 -122.403373953167 (37.7619704808857, -122.403373953167)
2326 32310 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 600 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.21346 2105535.41825 37.762046590490705 -122.40338299943899 (37.7620465904907, -122.403382999439)
2327 53079 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 600 Kansas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.70702 2105522.9440900004 37.7620123668039 -122.4033804148 (37.7620123668039, -122.4033804148)
2512 178827 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 927 Brazil Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004338.08735 2090755.04432 37.7210610008535 -122.427066663506 (37.7210610008535, -122.427066663506)
2517 178826 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 927 Brazil Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004356.8834 2090741.4764900003 37.7210248094256 -122.427000725205 (37.7210248094256, -122.427000725205)
2537 230348 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 280 Arlington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6004547.50076 2096560.5372400002 37.7370134334286 -122.42675600438 (37.7370134334286, -122.42675600438)
3174 253344 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2586 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945)
3318 253415 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 55 Stoneybrook Ave   Front Yard : Cutout 8 Tree 1 Private 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
3386 243475 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 109X Jarboe Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/05/2017 12:00:00 AM 3 3x3 Permit Number 779653 6007857.826 2097024.89565 37.738475065558895 -122.415343555473 (37.7384750655589, -122.415343555473)
3389 243477 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 109 Jarboe Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/05/2017 12:00:00 AM 3 3x3 Permit Number 779653 6007827.749919999 2097028.5645299999 37.7384834490575 -122.415447803985 (37.7384834490575, -122.415447803985)
3896 253542 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 10 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:42:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3899 253541 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 9 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 03:59:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3900 253543 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 11 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:35:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3902 253544 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 12 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:38:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3906 253540 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 8 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 04:11:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3940 179536 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1880 Alemany Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 10:42:00 AM 3 Width 3ft   6000969.55481 2091096.3953200001 37.7218072142025 -122.438735113438 (37.7218072142025, -122.438735113438)
4168 13059 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 583 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/28/2015 07:23:00 AM 3 2x2   6009557.0524 2120495.5376 37.8030153566132 -122.41112585507 (37.8030153566132, -122.41112585507)
4899 109487 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1314 POLK ST 2 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   10/31/2017 02:27:00 PM 3 3x3   6006825.7 2115468.8 37.7890596427133 -122.420220804515 (37.7890596427133, -122.420220804515)
5133 242839 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1151 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 7ft   6005182.8356800005 2101610.74761 37.750916060132106 -122.424918561756 (37.7509160601321, -122.424918561756)
5141 237496 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3927 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6003620.49393 2101843.48933 37.751466742003295 -122.430337889878 (37.7514667420033, -122.430337889878)
5195 253341 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1935 46th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.6810099995 2101921.14451 37.750428327874204 -122.505299944249 (37.7504283278742, -122.505299944249)
5246 243453 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 73 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 4x6   6007416.818030001 2098970.61704 37.74379278831079 -122.41700617529699 (37.7437927883108, -122.417006175297)
6628 17981 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2583 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/28/2014 12:00:00 AM 3 3x3   6001557.63 2114929.1565 37.7872796746141 -122.438408931359 (37.7872796746141, -122.438408931359)
6714 97108 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1472 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/12/2011 12:00:00 AM 3 3x3 Permit Number 768373 6007110.8589699995 2117762.02293 37.795372327823 -122.419396941128 (37.795372327823, -122.419396941128)
6833 4378 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2425X Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6006994.61601 2120672.53629 37.803357316535795 -122.42000580642201 (37.8033573165358, -122.420005806422)
9341 116840 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 636 POTRERO AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6010345.0 2105335.0 37.761432257364994 -122.40732973919701 (37.761432257365, -122.407329739197)
9719 173651 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 80 Entrada Ct 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
9784 115368 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 79 ELSIE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 778647 6007415.0 2098925.0 37.7436674318334 -122.417009230148 (37.7436674318334, -122.417009230148)
9836 6755 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1215 Fairfax Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/03/2017 06:41:00 AM 3 3x3   6017521.099066501 2096743.3718321999 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319)
9960 173748 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1259 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/13/2017 12:00:00 AM 3 3x3 Permit Number 773489 5989520.0 2106786.0 37.764228762563896 -122.47946011839899 (37.7642287625639, -122.479460118399)
10309 108845 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 420 Woolsey St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010479.05335 2091857.99264 37.7244348155857 -122.405916697196 (37.7244348155857, -122.405916697196)
10311 27188 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 258 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/2002 12:00:00 AM 5 2X3   6002908.14927 2093727.2885 37.729141154025506 -122.43222169348999 (37.7291411540255, -122.43222169349)
10319 109211 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 819 Brussels St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/04/2015 12:00:00 AM 3 3x3 Permit Number 773413 6011187.7232800005 2090968.5283099997 37.722032138266 -122.403404362845 (37.722032138266, -122.403404362845)
10860 104506 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 631 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   3 3x3   6002582.75614 2089515.1433 37.7175570910528 -122.43304578096 (37.7175570910528, -122.43304578096)
10886 83673 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 618 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52311 6003154.7737300005 2089756.30482 37.7182516977425 -122.43108578140499 (37.7182516977425, -122.431085781405)
10963 108843 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 420 Woolsey St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010519.109209999 2091869.71455 37.7244692416558 -122.40577905416201 (37.7244692416558, -122.405779054162)
11033 83366 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 618 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52311 6003144.474669999 2089738.5573200001 37.718202383405206 -122.43112011482701 (37.7182023834052, -122.431120114827)
11066 109684 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 250 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 773450 6005044.41141 2093779.7607 37.729406123972296 -122.42484018495001 (37.7294061239723, -122.42484018495)
11429 83565 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 647 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769747 6003095.84203 2089582.30789 37.7177706009018 -122.43127706988199 (37.7177706009018, -122.431277069882)
11730 108558 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 222 Theresa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773717 6001903.01628 2093995.18892 37.729819706015704 -122.43571567476101 (37.7298197060157, -122.435715674761)
12646 115976 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2x Olmstead St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757)
12772 109685 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 266 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 775044 6005143.37702 2093783.4945099999 37.7294219655289 -122.424498316649 (37.7294219655289, -122.424498316649)
12835 109714 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 250 Trumbull St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/02/2015 12:00:00 AM 3 3x3 Permit Number 772039 6005020.03097 2094315.2579700002 37.7308751035831 -122.424962554792 (37.7308751035831, -122.424962554792)
13056 108448 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 90-98X Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3 3x3   6004670.84101 2090640.5659299998 37.7207654791334 -122.42590828635599 (37.7207654791334, -122.425908286356)
13472 110653 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1189 Tennessee St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/28/2015 12:00:00 AM 3 3x4   6015597.65588 2103555.7138400003 37.7568393018153 -122.38903859247101 (37.7568393018153, -122.389038592471)
13608 116924 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015542.44799 2102559.60008 37.754101124282606 -122.389159972153 (37.7541011242826, -122.389159972153)
13642 33785 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013812.6799 2116223.3583 37.7915226979635 -122.39609948281701 (37.7915226979635, -122.396099482817)
13895 33780 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013824.14126 2116210.79912 37.7914888510795 -122.39605894586 (37.7914888510795, -122.39605894586)
14030 116926 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015510.15678 2102558.1918900004 37.7540954675573 -122.389271545654 (37.7540954675573, -122.389271545654)
14067 116930 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015446.80292 2102557.08015 37.7540889024884 -122.389490562948 (37.7540889024884, -122.389490562948)
14233 33800 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013865.37275 2116161.97621 37.7913570887062 -122.39591286179899 (37.7913570887062, -122.395912861799)
14247 33783 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013842.9233800005 2116188.62598 37.7914290137913 -122.395992405042 (37.7914290137913, -122.395992405042)
14678 59614 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1014 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2011 12:00:00 AM 3 3x3 Permit Number 767137 6015492.62077 2104343.80938 37.7589974211239 -122.389456881532 (37.7589974211239, -122.389456881532)
14755 33779 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013803.37475 2116233.23226 37.79154929181811 -122.396132371028 (37.7915492918181, -122.396132371028)
14797 116925 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015524.58204 2102559.09611 37.7540987500629 -122.389221722302 (37.7540987500629, -122.389221722302)
15251 108093 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2501X 18th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010203.41719 2105485.67353 37.7618380476045 -122.40783004261999 (37.7618380476045, -122.40783004262)
15260 116923 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015559.42731 2102560.4848599997 37.7541044949445 -122.389101314797 (37.7541044949445, -122.389101314797)
15315 116934 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1275 Minnesota St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015367.98495 2102613.01131 37.7542381072096 -122.38976704331999 (37.7542381072096, -122.38976704332)
15441 108091 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2501X 18th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010179.28671 2105483.3887400003 37.7618304231561 -122.407913339641 (37.7618304231561, -122.407913339641)
15461 109908 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1401 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/18/2015 02:04:00 PM 3 3x3 Permit Number 778313 6008340.42119 2109862.66125 37.773751763372395 -122.414583173274 (37.7737517633724, -122.414583173274)
15812 95581 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3881 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2017 12:00:00 AM 3 3x3 Permit Number 779561 6003940.0 2101864.0 37.7515411523314 -122.429234461777 (37.7515411523314, -122.429234461777)
15996 116935 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1275 Minnesota St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015368.355880001 2102637.50716 37.7543053881926 -122.389767471397 (37.7543053881926, -122.389767471397)
16017 116931 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015431.47773 2102556.1938099996 37.754085619065705 -122.38954349973301 (37.7540856190657, -122.389543499733)
16231 33782 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013852.02109 2116179.41654 37.7914042329729 -122.395960281264 (37.7914042329729, -122.395960281264)
16330 107963 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 33 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770900 6011844.7795 2114609.58385 37.786981966990105 -122.40279488510201 (37.7869819669901, -122.402794885102)
16512 116928 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015476.82973 2102557.66932 37.754092185022394 -122.38938676319599 (37.7540921850224, -122.389386763196)
16526 33774 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013834.28126 2116198.48682 37.791455608540396 -122.396022998165 (37.7914556085404, -122.396022998165)
16533 33792 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013856.54517 2116173.60161 37.7913885182281 -122.395944220262 (37.7913885182281, -122.395944220262)
16552 116933 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1275 Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015369.147890001 2102590.92817 37.7541775360745 -122.38976147920799 (37.7541775360745, -122.389761479208)
16611 116932 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015412.75293 2102554.60022 37.7540802051572 -122.38960814389799 (37.7540802051572, -122.389608143898)
16727 116927 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015494.24319 2102557.91546 37.7540938262957 -122.38932655988899 (37.7540938262957, -122.389326559889)
16791 108089 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2501X 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010157.47788 2105483.07585 37.761828343024604 -122.407988746007 (37.7618283430246, -122.407988746007)
16892 116929 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900x 24th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2016 12:00:00 AM 3 5x5   6015461.93425 2102556.8401200003 37.7540890823654 -122.38943821792401 (37.7540890823654, -122.389438217924)
17580 4334 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 852 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6001755.94767 2095865.71194 37.7349473777015 -122.436357925586 (37.7349473777015, -122.436357925586)
17962 5397 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 347 Dolores St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/10/2014 12:00:00 AM 30 6x6   6004921.39011 2106378.39566 37.7639921298444 -122.42616204806002 (37.7639921298444, -122.42616204806)
18361 99292 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1300 Minnesota St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.38992452193199 (37.753957014382, -122.389924521932)
18733 88323 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 125 Lisbon St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51312 6003417.0 2092629.0 37.7261543381556 -122.430384225952 (37.7261543381556, -122.430384225952)
19246 97101 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1096@Jones Pine St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008668.0 2115966.0 37.7905284677514 -122.41388184826499 (37.7905284677514, -122.413881848265)
21415 136 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1025X 14th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 3X3   6001971.14414 2107605.72409 37.767194880067294 -122.436453906645 (37.7671948800673, -122.436453906645)
22057 5393 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 347 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/10/2014 12:00:00 AM 3 6x7   6004928.4905 2106245.9446799997 37.7636288523174 -122.426128059965 (37.7636288523174, -122.426128059965)
22940 103859 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1475 Polk St 3 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   08/21/2013 12:00:00 AM 3 3x3   6006677.0 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582)
22953 103852 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1507 Polk St 1 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   08/21/2013 12:00:00 AM 3 3x3   6006614.6 2116113.6 37.7908182067111 -122.420996984718 (37.7908182067111, -122.420996984718)
22958 103860 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1475 Polk St 4 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   08/21/2013 12:00:00 AM 3 3x3   6006677.0 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582)
22964 109898 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1786 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2015 12:00:00 AM 3 3x3 Permit Number 775112 5987249.9 2103123.1 37.754039320648495 -122.48704261510099 (37.7540393206485, -122.487042615101)
22965 103768 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1323 Polk St 2 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   08/21/2013 12:00:00 AM 3 3x3   6006757.0 2115467.0 37.7890508291132 -122.42045837028401 (37.7890508291132, -122.420458370284)
22989 37859 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 127 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/2004 12:00:00 AM 6   Permit Number 47618 6004006.380580001 2093054.46604 37.7273559413142 -122.42837708183399 (37.7273559413142, -122.428377081834)
23030 17382 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1627 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/21/2015 12:00:00 AM 1 3X3 Permit Number 776412 6014690.32946 2095358.97831 37.7342824432881 -122.39160343105 (37.7342824432881, -122.39160343105)
23545 177395 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 715 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6001937.656140001 2089768.77997 37.718216907458704 -122.435293726344 (37.7182169074587, -122.435293726344)
23594 230297 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1171 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008685.11737 2101744.284 37.7514799242568 -122.412816735721 (37.7514799242568, -122.412816735721)
23977 177421 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 0 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6001079.38248 2091791.86287 37.7237230579705 -122.438405269984 (37.7237230579705, -122.438405269984)
24130 96862 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 387 29th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/2011 12:00:00 AM 2 3x3 Permit Number 768142 5986827.805480001 2113344.76478 37.7820805427479 -122.48925378416 (37.7820805427479, -122.48925378416)
24356 123622 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 111 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995179.48554 2114830.2995 37.786643385410706 -122.460468639914 (37.7866433854107, -122.460468639914)
24465 95104 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2200 Beach St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   01/08/2008 12:00:00 AM 5     5999633.730169999 2120895.6152 37.803552367813104 -122.445494383786 (37.8035523678131, -122.445494383786)
24569 230346 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1801 Church St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004582.48938 2098325.9035400003 37.74186270650671 -122.426760715042 (37.7418627065067, -122.426760715042)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 581.863ms · Data source: data.sfgov.org