trees
979 rows where qSpecies_id = 13 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||||
| 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 | ||||||||||||
| 15038 | 259861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15229 | 259804 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
| 19358 | 259860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | |||
| 2825 | 92602 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
| 5427 | 146424 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2131 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6000557.07663 | 2120624.21431 | 37.8028598421591 | -122.442279615007 | (37.8028598421591, -122.442279615007) | 13 | 9 | 1 | 57 | 17 | |||
| 5771 | 18021 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.7869282913907 | -122.441128056615 | (37.7869282913907, -122.441128056615) | 13 | 6 | 1 | 29490 | 27 | |||
| 8309 | 55891 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1981 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1979 12:00:00 AM | 4 | Permit Number 17936 | 6003525.54431 | 2118603.6465 | 37.7974806237872 | -122.431862837898 | (37.7974806237872, -122.431862837898) | 13 | 9 | 1 | 57 | 17 | ||
| 10157 | 124335 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 176 Palm Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 5995959.20478 | 2113110.98096 | 37.7819674207447 | -122.457646568088 | (37.7819674207447, -122.457646568088) | 11 | 6 | 1 | 54 | 31 | |||
| 16255 | 130986 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3147 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004613.79741 | 2120397.19916 | 37.8024668888085 | -122.428225084716 | (37.8024668888085, -122.428225084716) | 13 | 9 | 1 | 57 | 17 | |||
| 16680 | 256664 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
| 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 | |||
| 22457 | 93624 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 149 Collins St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | Permit Number 53164 | 5998064 | 2113562 | 37.783326485193 | -122.450397500912 | (37.783326485193, -122.450397500912) | 15 | 6 | 1 | 54 | 31 | |||
| 23388 | 256663 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
| 24065 | 95100 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773992 | 5999642.14759 | 2120895.84862 | 37.8035534892505 | -122.445465271815 | (37.8035534892505, -122.445465271815) | 13 | 9 | 1 | 57 | 17 | |
| 24814 | 130998 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007580.24685 | 2119942.9983 | 37.8013871663302 | -122.417927457909 | (37.8013871663302, -122.417927457909) | 5 | 1 | 1 | 28858 | 32 | |||
| 26823 | 130979 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003392.63825 | 2118710.53887 | 37.7977665875245 | -122.432330365752 | (37.7977665875245, -122.432330365752) | 13 | 9 | 1 | 57 | 17 | |||
| 27502 | 92600 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
| 35091 | 95932 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 218 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767629 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) | 11 | 6 | 1 | 55 | 33 |
| 45290 | 112888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3980 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 774440 | 5995705.4 | 2115208.7 | 37.7877126116995 | -122.458676518899 | (37.7877126116995, -122.458676518899) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 50977 | 130984 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5999592.95513 | 2120888.49408 | 37.803530487293 | -122.445634974783 | (37.803530487293, -122.445634974783) | 13 | 9 | 1 | 57 | 17 | |||
| 52039 | 250725 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 782755 | 5987015.16529 | 2114429.97132 | 37.7850711441675 | -122.488685403333 | (37.7850711441675, -122.488685403333) | 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 | ||
| 54020 | 95101 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3601x Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 2 | 5999657.71874 | 2120941.08267 | 37.8036785786574 | -122.445414641767 | (37.8036785786574, -122.445414641767) | 13 | 9 | 1 | 57 | 17 | |||
| 54645 | 130980 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003394.29695 | 2118690.35312 | 37.797711256726 | -122.43232318378 | (37.797711256726, -122.43232318378) | 13 | 9 | 1 | 57 | 17 | |||
| 57946 | 88834 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 156 Collins St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51716 | 5998112 | 2113497 | 37.7831507592552 | -122.450226753873 | (37.7831507592552, -122.450226753873) | 15 | 6 | 1 | 54 | 31 | |||
| 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 |
| 59767 | 130975 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6002956.23707 | 2118277.75105 | 37.796553509993 | -122.433809483441 | (37.796553509993, -122.433809483441) | 13 | 9 | 1 | 57 | 17 | |||
| 67540 | 49737 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 251 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | 3 | 3x12 | Permit Number 46536 | 5987104.42255848 | 2114202.9919751 | 37.7844531321546 | -122.488359918659 | (37.7844531321546, -122.488359918659) | 11 | 6 | 1 | 55 | 33 | |
| 69215 | 130967 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 213 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998523.7164 | 2115638.03819 | 37.7890530400256 | -122.448956666639 | (37.7890530400256, -122.448956666639) | 13 | 6 | 1 | 54 | 31 | |||
| 70004 | 123549 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5994237.46417 | 2115165.09446 | 37.7875084040974 | -122.463752090061 | (37.7875084040974, -122.463752090061) | 11 | 6 | 1 | 54 | 11 | |||
| 70116 | 88597 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Jordan Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51542 | 5996162.8 | 2114014.5 | 37.7844599367093 | -122.457007600103 | (37.7844599367093, -122.457007600103) | 11 | 6 | 1 | 54 | 31 | |||
| 71387 | 130976 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6002956.82977 | 2118266.12381 | 37.796521618235 | -122.433806601098 | (37.796521618235, -122.433806601098) | 13 | 9 | 1 | 57 | 17 | |||
| 71965 | 124566 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3943 Sacramento St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 5995914.73243 | 2114852.94659 | 37.7867478376308 | -122.457926519067 | (37.7867478376308, -122.457926519067) | 11 | 6 | 1 | 54 | 31 | |||
| 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 |
| 76365 | 92601 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
| 79934 | 106843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1869 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2014 12:00:00 AM | Permit Number 773317 | 6004088.44172 | 2118602.99638 | 37.7975107321666 | -122.429915018594 | (37.7975107321666, -122.429915018594) | 13 | 9 | 1 | 57 | 17 | |||
| 82405 | 130983 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5999604.29073 | 2120890.91469 | 37.8035377808009 | -122.44559592174 | (37.8035377808009, -122.44559592174) | 13 | 9 | 1 | 57 | 17 | |||
| 82925 | 130977 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 2ft | 6002958.54941 | 2118258.62149 | 37.7965011163873 | -122.433800114279 | (37.7965011163873, -122.433800114279) | 13 | 9 | 1 | 57 | 17 | |||
| 84525 | 30506 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3615 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1998 12:00:00 AM | 6 | Permit Number 40581 | 5997549.20453 | 2115073.94574 | 37.7874484120486 | -122.452287614306 | (37.7874484120486, -122.452287614306) | 11 | 6 | 1 | 54 | 31 | ||
| 84792 | 130969 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Heather Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5997355.4901 | 2113891.63765 | 37.7841910082488 | -122.452872452398 | (37.7841910082488, -122.452872452398) | 15 | 6 | 1 | 54 | 31 | ||||
| 85985 | 130974 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 2ft | 6002954.53886 | 2118286.2899 | 37.7965768590991 | -122.433815970239 | (37.7965768590991, -122.433815970239) | 13 | 9 | 1 | 57 | 17 | |||
| 89454 | 254862 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2715 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 782755 | 5987015.16529 | 2114429.97132 | 37.7850711441675 | -122.488685403333 | (37.7850711441675, -122.488685403333) | 11 | 6 | 1 | 55 | 33 |
| 91579 | 130972 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6002950.18497 | 2118317.4913 | 37.7966622830002 | -122.433833266913 | (37.7966622830002, -122.433833266913) | 13 | 9 | 1 | 57 | 17 | |||
| 93861 | 124611 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3931 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995971.07063 | 2115182.72875 | 37.787656567418 | -122.457755475318 | (37.787656567418, -122.457755475318) | 11 | 6 | 1 | 54 | 31 | |||
| 94413 | 104138 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3067 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001906.1 | 2118706.9 | 37.7976721947069 | -122.437473929103 | (37.7976721947069, -122.437473929103) | 13 | 9 | 1 | 57 | 17 | ||
| 94680 | 132274 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2160 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005107.40746 | 2116851.05926 | 37.7927580094371 | -122.426264329748 | (37.7927580094371, -122.426264329748) | 13 | 9 | 1 | 28858 | 27 | |
| 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 | ||
| 99113 | 87077 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2565 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006603.98041 | 2120038.08601 | 37.8015932612686 | -122.421312536668 | (37.8015932612686, -122.421312536668) | 5 | 9 | 1 | 28858 | 32 | |
| 101443 | 49736 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 251 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | 3 | 3x12 | Permit Number 46536 | 5987104.42255848 | 2114202.9919751 | 37.7844531321546 | -122.488359918659 | (37.7844531321546, -122.488359918659) | 11 | 6 | 1 | 55 | 33 | |
| 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 | |||
| 106540 | 130968 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5997356.68218 | 2113906.91877 | 37.7842330344764 | -122.452869431598 | (37.7842330344764, -122.452869431598) | 15 | 6 | 1 | 54 | 31 | ||||
| 107450 | 4378 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2425X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6006994.61601 | 2120672.53629 | 37.8033573165358 | -122.420005806422 | (37.8033573165358, -122.420005806422) | 5 | 1 | 1 | 28858 | 32 | |||
| 108505 | 108357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.44706 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | 13 | 9 | 1 | 57 | 17 | |
| 109181 | 109089 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 218 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 3x3 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) | 11 | 6 | 1 | 55 | 33 | ||
| 111243 | 66134 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3259 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 3 | Permit Number 768243 | 5999299.78945 | 2120070.84719 | 37.8012687076388 | -122.446590621369 | (37.8012687076388, -122.446590621369) | 13 | 9 | 1 | 57 | 17 | ||
| 116678 | 31977 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 134 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | Permit Number 35376 | 5995230.64434 | 2114664.73917 | 37.7861917443429 | -122.460279644251 | (37.7861917443429, -122.460279644251) | 11 | 6 | 1 | 54 | 11 | |
| 117947 | 108633 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2610 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | 11 | 6 | 1 | 55 | 33 |
| 121381 | 98842 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 313 Maple St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2012 12:00:00 AM | 1 | Permit Number 768890 | 5996633.94495 | 2115242.03804 | 37.7878574732038 | -122.455466360678 | (37.7878574732038, -122.455466360678) | 11 | 6 | 1 | 54 | 31 | ||
| 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 | |||
| 123980 | 95129 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200@Broderick Beach St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5999690 | 2120891 | 37.8035429078816 | -122.445299328106 | (37.8035429078816, -122.445299328106) | 13 | 9 | 1 | 57 | 17 | ||||
| 127103 | 92603 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
| 127354 | 94730 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 418 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53862 | 5997217.67326 | 2114882.8026 | 37.7869045857318 | -122.45342083293 | (37.7869045857318, -122.45342083293) | 11 | 6 | 1 | 54 | 31 |
| 130421 | 130982 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3601 Broderick St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5999659.44076 | 2120919.32346 | 37.8036189320344 | -122.445407117147 | (37.8036189320344, -122.445407117147) | 13 | 9 | 1 | 57 | 17 | |||
| 133316 | 130999 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2009 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008124.35834 | 2119571.24818 | 37.8003970406522 | -122.416018243071 | (37.8003970406522, -122.416018243071) | 5 | 1 | 1 | 308 | 32 | |||
| 135375 | 109088 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 218 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) | 11 | 6 | 1 | 55 | 33 | ||
| 139673 | 127383 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2160 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005103.8437 | 2116881.77559 | 37.792842147287 | -122.426278848408 | (37.792842147287, -122.426278848408) | 13 | 9 | 1 | 28858 | 27 | |
| 140052 | 92604 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
| 142173 | 130973 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002952.36205 | 2118301.89076 | 37.7966195714971 | -122.433824618115 | (37.7966195714971, -122.433824618115) | 13 | 9 | 1 | 57 | 17 | |||
| 142516 | 130978 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002959.93216 | 2118244.90398 | 37.7964635301195 | -122.433794348725 | (37.7964635301195, -122.433794348725) | 13 | 9 | 1 | 57 | 17 | |||
| 145251 | 108356 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.7984161192732 | -122.436618162405 | (37.7984161192732, -122.436618162405) | 13 | 9 | 1 | 57 | 17 | |
| 146912 | 125204 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2000 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005093.29974 | 2116822.56414 | 37.7926789715987 | -122.426311113392 | (37.7926789715987, -122.426311113392) | 13 | 9 | 1 | 28858 | 27 | |
| 148719 | 95104 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5 | 5999633.73017 | 2120895.6152 | 37.8035523678131 | -122.445494383786 | (37.8035523678131, -122.445494383786) | 13 | 9 | 1 | 57 | 17 | |||
| 148842 | 104140 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001711.91514 | 2118723.596 | 37.7977069957146 | -122.438147056882 | (37.7977069957146, -122.438147056882) | 13 | 9 | 1 | 57 | 17 | ||
| 149568 | 95105 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 2 | 5999611.30639 | 2120892.81198 | 37.8035433907753 | -122.445571780333 | (37.8035433907753, -122.445571780333) | 13 | 9 | 1 | 57 | 17 | |||
| 150499 | 88037 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Lyon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51052 | 5999275.57165 | 2116691.87228 | 37.7919895603315 | -122.446431199448 | (37.7919895603315, -122.446431199448) | 11 | 6 | 1 | 29490 | 30 | |
| 153558 | 34927 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2625 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2012 12:00:00 AM | 3 | Permit Number 768761 | 5999601.94789 | 2117876.97454 | 37.7952621734732 | -122.445387189083 | (37.7952621734732, -122.445387189083) | 13 | 9 | 1 | 57 | 17 | ||
| 154327 | 104139 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001711.91514 | 2118723.596 | 37.7977069957146 | -122.438147056882 | (37.7977069957146, -122.438147056882) | 13 | 9 | 1 | 57 | 17 | ||
| 158712 | 124612 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3931 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995955.42177 | 2115180.15749 | 37.7876486084254 | -122.457809430854 | (37.7876486084254, -122.457809430854) | 11 | 6 | 1 | 54 | 31 | |||
| 159186 | 34926 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2625 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2012 12:00:00 AM | 4 | Permit Number 768761 | 5999600.82758 | 2117890.72086 | 37.7952998532682 | -122.445392054402 | (37.7952998532682, -122.445392054402) | 13 | 9 | 1 | 57 | 17 | ||
| 163418 | 113661 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3060 JACKSON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 5x5 | Permit Number 776720 | 5999534 | 2116404 | 37.7912138957856 | -122.445516329339 | (37.7912138957856, -122.445516329339) | 13 | 6 | 1 | 29490 | 27 | ||
| 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 | ||
| 172192 | 12725 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1544 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | 3 | 3X3 | 5990592.79668 | 2114771.31925 | 37.7862165141869 | -122.476332998319 | (37.7862165141869, -122.476332998319) | 11 | 6 | 1 | 54 | 33 | ||
| 175085 | 89299 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2825 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51902 | 6000069.8 | 2117048.2 | 37.7930132732955 | -122.443708782466 | (37.7930132732955, -122.443708782466) | 13 | 6 | 1 | 29490 | 27 | ||
| 175599 | 130981 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003397.35892 | 2118675.30556 | 37.7976701136348 | -122.432311513284 | (37.7976701136348, -122.432311513284) | 13 | 9 | 1 | 57 | 17 | |||
| 176927 | 130997 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007578.93915 | 2119952.78886 | 37.8014139751467 | -122.417932677574 | (37.8014139751467, -122.417932677574) | 5 | 1 | 1 | 28858 | 32 | |||
| 177003 | 108358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.02459 | 2118966.98612 | 37.7983986535418 | -122.436741939704 | (37.7983986535418, -122.436741939704) | 13 | 9 | 1 | 57 | 17 | |
| 181538 | 87076 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2565 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006601.66741 | 2120051.34913 | 37.8016295480248 | -122.421321483111 | (37.8016295480248, -122.421321483111) | 5 | 9 | 1 | 28858 | 32 | |
| 184962 | 130966 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 Moulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002966.56472 | 2119407.57255 | 37.7996562924699 | -122.433854543963 | (37.7996562924699, -122.433854543963) | 13 | 9 | 1 | 57 | 17 | |||
| 188023 | 130971 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6002947.99505 | 2118332.47012 | 37.7967032866916 | -122.43384191569 | (37.7967032866916, -122.43384191569) | 13 | 9 | 1 | 57 | 17 | |||
| 188688 | 13238 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2322 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1998 12:00:00 AM | 3 | 3X3 | 6001219.43305 | 2119376.81704 | 37.7994725475626 | -122.439898035919 | (37.7994725475626, -122.439898035919) | 13 | 9 | 1 | 57 | 17 | ||
| 189398 | 130985 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2098 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999249.25927 | 2121180.66389 | 37.8043130782603 | -122.446845381305 | (37.8043130782603, -122.446845381305) | 13 | 9 | 1 | 57 | 17 | |||
| 191056 | 130970 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002945.56276 | 2118345.79466 | 37.796739734404 | -122.433851284829 | (37.796739734404, -122.433851284829) | 13 | 9 | 1 | 57 | 17 | |||
| 191835 | 136108 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2160 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005089.07981 | 2116957.29381 | 37.7930486667182 | -122.426335311432 | (37.7930486667182, -122.426335311432) | 13 | 9 | 1 | 28858 | 27 | |
| 194094 | 124334 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 176 Palm Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 5995958.15323 | 2113125.95358 | 37.782008471168 | -122.457651289636 | (37.782008471168, -122.457651289636) | 11 | 6 | 1 | 54 | 31 | |||
| 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 |
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) );