trees
1,121 rows where qSpecies_id = 6 sorted by DBH
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36793 | 95431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1938 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767296 | 5988810.2856 | 2102122.1786 | 37.7513819161329 | -122.481573187512 | (37.7513819161329, -122.481573187512) | 1 | 8 | 3 | 29491 | 35 |
| 37491 | 95899 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989072.0669 | 2103701.2996 | 37.7557329794721 | -122.480783524363 | (37.7557329794721, -122.480783524363) | 1 | 8 | 3 | 56 | 35 |
| 39349 | 98850 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | |
| 39727 | 182826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1781 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986558.6884 | 2103101.4836 | 37.7539396409234 | -122.48943136929 | (37.7539396409234, -122.48943136929) | 1 | 8 | 3 | 56 | 35 | |||
| 44290 | 140758 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.7815689287559 | -122.442554464995 | (37.7815689287559, -122.442554464995) | 15 | 5 | 1 | 29490 | 16 | |||
| 45396 | 227112 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007863.71848 | 2099963.32211 | 37.7465436642568 | -122.41553116305 | (37.7465436642568, -122.41553116305) | 2 | 7 | 7 | 28859 | 2 | |||
| 46414 | 112583 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | |||
| 46503 | 201810 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6021035.70856 | 2093179.80399 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | 10 | 3 | 8 | 58 | 1 | |||
| 48643 | 98849 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | |
| 51610 | 176885 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008580.05361 | 2087004.56736 | 37.7110019335603 | -122.412138452652 | (37.7110019335603, -122.412138452652) | 9 | 7 | 8 | 309 | 39 | |||
| 51774 | 184549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3501 Moraga St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5983411.1343 | 2103548.3965 | 37.754982490057 | -122.500349218821 | (37.754982490057, -122.500349218821) | 1 | 8 | 3 | 56 | 35 | |||
| 54445 | 201812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 3 | : | Tree | Private 2 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.7287741263267 | -122.369414113788 | (37.7287741263267, -122.369414113788) | 10 | 3 | 8 | 58 | 1 | |||
| 55754 | 176898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005619.38027 | 2092788.13013 | 37.7267157831975 | -122.422782016296 | (37.7267157831975, -122.422782016296) | 9 | 7 | 7 | 309 | 5 | |||
| 56104 | 182307 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1509 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987118.7965 | 2104973.5941 | 37.7591126281614 | -122.487631931758 | (37.7591126281614, -122.487631931758) | 1 | 8 | 3 | 56 | 35 | |||
| 56826 | 176874 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | 10 | 3 | 8 | 309 | 1 | |||
| 56938 | 206999 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 404 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991570.38275 | 2099794.54343 | 37.7451509372588 | -122.471858917877 | (37.7451509372588, -122.471858917877) | 1 | 8 | 4 | 29491 | 40 | |||
| 57255 | 176878 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.7098626625021 | -122.396290845073 | (37.7098626625021, -122.396290845073) | 10 | 3 | 8 | 309 | 1 | |||
| 63426 | 117686 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 34 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5982669.57188 | 2112585.47797 | 37.7797521626965 | -122.503582898398 | (37.7797521626965, -122.503582898398) | 11 | 6 | 2 | 55 | 26 | |||
| 64471 | 207005 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 171 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 773294 | 5992787.45104 | 2098017.32873 | 37.7403415032629 | -122.467521326669 | (37.7403415032629, -122.467521326669) | 1 | 8 | 4 | 59 | 40 | |
| 65213 | 176887 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 13 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002286.64114 | 2092541.40018 | 37.7258497144844 | -122.434285547657 | (37.7258497144844, -122.434285547657) | 9 | 7 | 6 | 28861 | 25 | |||
| 65853 | 116538 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 1 | Median : Yard | Tree | DPW 1 | 1 | 3x3 | 6001578.10158 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | 9 | 7 | 6 | 28861 | 5 | |||
| 67278 | 58124 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 527 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1978 12:00:00 AM | 1 | Permit Number 17106 | 5991241.86963 | 2111793.32926 | 37.778077396785 | -122.473870058582 | (37.778077396785, -122.473870058582) | 11 | 6 | 2 | 54 | 26 | ||
| 71829 | 206984 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1498 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990877.91026 | 2105249.91359 | 37.7600898599821 | -122.474651424322 | (37.7600898599821, -122.474651424322) | 1 | 8 | 4 | 56 | 12 | |||
| 76042 | 79199 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 409 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2015 12:00:00 AM | 1 | Permit Number 777130 | 5998120.56156 | 2115036.84682 | 37.7873792631851 | -122.450308169597 | (37.7873792631851, -122.450308169597) | 11 | 6 | 1 | 54 | 31 | |
| 77256 | 227128 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 248 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004363.96226 | 2096949.74054 | 37.7380717187222 | -122.427418297528 | (37.7380717187222, -122.427418297528) | 2 | 7 | 5 | 63 | 7 | |||
| 80475 | 92440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1352 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52830 | 5982162.934 | 2105885.2573 | 37.7613255007309 | -122.504838927947 | (37.7613255007309, -122.504838927947) | 1 | 8 | 3 | 56 | 35 |
| 80907 | 98851 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | |
| 80935 | 207042 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 40 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995660.33467 | 2100048.89738 | 37.746085134133 | -122.457735064227 | (37.746085134133, -122.457735064227) | 1 | 5 | 4 | 59 | 40 | |||
| 82485 | 118666 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 465 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5982506.22463 | 2112651.75572 | 37.7799245369815 | -122.504152889313 | (37.7799245369815, -122.504152889313) | 11 | 6 | 2 | 55 | 26 | |||
| 82669 | 46431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2002 12:00:00 AM | 1 | Permit Number 44652 | 6011089.42189 | 2089718.35805 | 37.7185939356546 | -122.403656249429 | (37.7185939356546, -122.403656249429) | 10 | 7 | 8 | 309 | 28 | ||
| 83077 | 119164 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5981372.52859 | 2109725.62562 | 37.7718235084184 | -122.507857566702 | (37.7718235084184, -122.507857566702) | 11 | 6 | 2 | 55 | 26 | |||
| 83413 | 119242 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981417.66127 | 2111333.86508 | 37.7762419210818 | -122.507820820241 | (37.7762419210818, -122.507820820241) | 11 | 6 | 2 | 55 | 26 | |||
| 84471 | 27064 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 801 Silver Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 1 | 4 | 6007054.44286 | 2093598.36831 | 37.7290213868102 | -122.417878446659 | (37.7290213868102, -122.417878446659) | 9 | 3 | 7 | 309 | 28 | ||
| 85415 | 207038 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 270 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994641.46146 | 2100307.89339 | 37.7467376875983 | -122.461276941602 | (37.7467376875983, -122.461276941602) | 1 | 8 | 4 | 29491 | 40 | |||
| 95475 | 46434 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | 10 | 7 | 8 | 309 | 28 | |
| 96117 | 184640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1650 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983160.9711 | 2103902.0944 | 37.7559389581009 | -122.501240500695 | (37.7559389581009, -122.501240500695) | 1 | 8 | 3 | 56 | 35 | |||
| 102912 | 88207 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 187 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51211 | 5996848.1239 | 2111670.4224 | 37.7780630497691 | -122.454467238117 | (37.7780630497691, -122.454467238117) | 15 | 6 | 2 | 54 | 16 | |
| 104768 | 207004 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 171 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 773294 | 5992803.19794 | 2098037.09896 | 37.7403966964551 | -122.46746831791 | (37.7403966964551, -122.46746831791) | 1 | 8 | 4 | 59 | 40 | |
| 104812 | 117687 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 8ft | 5982599.26265 | 2112595.13886 | 37.7797745547632 | -122.503826840405 | (37.7797745547632, -122.503826840405) | 11 | 6 | 2 | 55 | 26 | |||
| 104950 | 183303 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1286 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982766.9656 | 2106385.9546 | 37.7627357893861 | -122.502786935917 | (37.7627357893861, -122.502786935917) | 1 | 8 | 3 | 56 | 35 | |||
| 106816 | 181949 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2450 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986451.9754 | 2098568.253 | 37.7414863814969 | -122.489467090095 | (37.7414863814969, -122.489467090095) | 1 | 8 | 3 | 29491 | 35 | |||
| 109442 | 206995 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1584 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993720.55073 | 2104714.02617 | 37.7587827556425 | -122.464781251568 | (37.7587827556425, -122.464781251568) | 1 | 8 | 4 | 56 | 12 | |||
| 109495 | 184723 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1635 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983115.9866 | 2103988.5253 | 37.7561736313112 | -122.501402462618 | (37.7561736313112, -122.501402462618) | 1 | 8 | 3 | 56 | 35 | |||
| 113032 | 111713 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
| 113649 | 117934 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982916.92515 | 2109877.96567 | 37.7723326617078 | -122.502526759002 | (37.7723326617078, -122.502526759002) | 11 | 6 | 2 | 55 | 26 | |||
| 114221 | 95521 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1510 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767313 | 5985302.4962 | 2104889.3961 | 37.7587753414156 | -122.493907267319 | (37.7587753414156, -122.493907267319) | 1 | 8 | 3 | 56 | 35 |
| 114283 | 118588 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982305.68238 | 2112631.11012 | 37.7798560544886 | -122.504845112217 | (37.7798560544886, -122.504845112217) | 11 | 6 | 2 | 55 | 26 | |||
| 125237 | 201811 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | 10 | 3 | 8 | 58 | 1 | |||
| 128256 | 117895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5984097.32613 | 2111483.29523 | 37.7768097259285 | -122.498562310404 | (37.7768097259285, -122.498562310404) | 11 | 6 | 2 | 55 | 26 | |||
| 129143 | 181684 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1347 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986459.3313 | 2106064.8642 | 37.7620704697574 | -122.489992909675 | (37.7620704697574, -122.489992909675) | 1 | 8 | 3 | 56 | 35 | |||
| 129314 | 113356 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 Point Lobos Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 5982735.90689 | 2112577.00884 | 37.7797328087219 | -122.503352793138 | (37.7797328087219, -122.503352793138) | 11 | 6 | 2 | 55 | 26 | |||
| 134028 | 181690 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1374 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982168.1662 | 2105754.9295 | 37.7609679655916 | -122.504811174863 | (37.7609679655916, -122.504811174863) | 1 | 8 | 3 | 56 | 35 | |||
| 134071 | 227103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998021.55452 | 2105968.74453 | 37.7624749295086 | -122.449996897152 | (37.7624749295086, -122.449996897152) | 15 | 5 | 11 | 29492 | 9 | |||
| 135455 | 201808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 247 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | 10 | 3 | 8 | 58 | 1 | |||
| 136000 | 95898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989073.1619 | 2103670.6386 | 37.755648856222 | -122.48077749294 | (37.755648856222, -122.48077749294) | 1 | 8 | 3 | 56 | 35 |
| 137770 | 206987 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1248 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992091.43933 | 2106913.61789 | 37.7647281934706 | -122.470575621288 | (37.7647281934706, -122.470575621288) | 11 | 8 | 11 | 56 | 12 | |||
| 139164 | 118188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 762 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985415.78787 | 2110692.34221 | 37.7747152280145 | -122.493943116599 | (37.7747152280145, -122.493943116599) | 11 | 6 | 2 | 55 | 26 | |||
| 140883 | 184598 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983770.321 | 2103008.0087 | 37.7535198125919 | -122.499067143504 | (37.7535198125919, -122.499067143504) | 1 | 8 | 3 | 56 | 35 | |||
| 145798 | 140302 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 143 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997780.8586 | 2110053.3207 | 37.773676357183 | -122.451123943319 | (37.773676357183, -122.451123943319) | 15 | 5 | 11 | 29492 | 16 | |||
| 148114 | 227117 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003535.84775 | 2095026.78251 | 37.7327448417949 | -122.430144356698 | (37.7327448417949, -122.430144356698) | 9 | 7 | 5 | 28861 | 25 | |||
| 148332 | 113418 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 598X BENTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007207 | 2095355 | 37.7338532991757 | -122.417475487879 | (37.7338532991757, -122.417475487879) | 2 | 7 | 7 | 28859 | 2 | |||
| 151427 | 176883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6011048.63475 | 2088252.82193 | 37.7145675926038 | -122.403694172945 | (37.7145675926038, -122.403694172945) | 9 | 7 | 8 | 309 | 39 | ||||
| 153956 | 176899 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005613.54422 | 2092807.28897 | 37.7267680598911 | -122.422803552358 | (37.7267680598911, -122.422803552358) | 9 | 7 | 7 | 309 | 5 | |||
| 154132 | 119243 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981398.37029 | 2111333.42566 | 37.7762395779827 | -122.507887519226 | (37.7762395779827, -122.507887519226) | 11 | 6 | 2 | 55 | 26 | |||
| 155044 | 52456 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 757 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2013 12:00:00 AM | 1 | Permit Number 770898 | 5992550.20906 | 2110320.92766 | 37.7741102732547 | -122.469236887906 | (37.7741102732547, -122.469236887906) | 11 | 6 | 2 | 54 | 11 | |
| 156906 | 46375 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2214 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51267 | 5982984.1214 | 2100027.2965 | 37.745289455195 | -122.501565454542 | (37.745289455195, -122.501565454542) | 1 | 8 | 3 | 29491 | 35 | |
| 157522 | 207028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 227 Ramsell St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992956.15905 | 2088729.24095 | 37.7148484391912 | -122.46626317241 | (37.7148484391912, -122.46626317241) | 9 | 8 | 6 | 64 | 24 | |||
| 161367 | 182659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2252 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986985.3742 | 2102363.8158 | 37.7519391046129 | -122.487901613135 | (37.7519391046129, -122.487901613135) | 1 | 8 | 3 | 56 | 35 | |||
| 163710 | 108371 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.7196058887813 | -122.43642558878 | (37.7196058887813, -122.43642558878) | 9 | 7 | 6 | 28861 | 5 | ||
| 163976 | 140699 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 224 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998816.4363 | 2109919.7991 | 37.7733689769062 | -122.447532121663 | (37.7733689769062, -122.447532121663) | 15 | 5 | 11 | 29492 | 16 | |||
| 165946 | 207007 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 127 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993382.10868 | 2093854.31743 | 37.7289452232334 | -122.465162955333 | (37.7289452232334, -122.465162955333) | 9 | 8 | 4 | 59 | 40 | |||
| 166863 | 140780 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.443550757384 | (37.7796937331341, -122.443550757384) | 15 | 5 | 1 | 29490 | 16 | |||
| 169035 | 47267 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1386 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45208 | 5988680.1995 | 2105896.4201 | 37.7617374028544 | -122.48229953296 | (37.7617374028544, -122.48229953296) | 1 | 8 | 3 | 56 | 35 | |
| 169302 | 118589 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982275.32502 | 2112634.79146 | 37.779864376411 | -122.50495040284 | (37.779864376411, -122.50495040284) | 11 | 6 | 2 | 55 | 26 | |||
| 172292 | 176884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.403646486396 | (37.7145850034576, -122.403646486396) | 9 | 7 | 8 | 309 | 39 | ||||
| 172462 | 206985 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1498 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990877.17813 | 2105275.09317 | 37.7601589539866 | -122.474655794123 | (37.7601589539866, -122.474655794123) | 1 | 8 | 4 | 56 | 12 | |||
| 173829 | 227084 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1217 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010060.56336 | 2102014.94468 | 37.7523002058063 | -122.408079341009 | (37.7523002058063, -122.408079341009) | 2 | 4 | 7 | 28859 | 19 | |||
| 175350 | 191223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1112 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012178.19052 | 2103217.19746 | 37.7557196692435 | -122.400840661869 | (37.7557196692435, -122.400840661869) | 10 | 3 | 8 | 28856 | 29 | |||
| 176426 | 227107 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 39 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998391.27095 | 2106242.70654 | 37.7632483086886 | -122.448737922716 | (37.7632483086886, -122.448737922716) | 15 | 5 | 11 | 29492 | 9 | |||
| 176687 | 63095 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1314 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 1 | Permit Number 775034 | 5982157.61974918 | 2106142.20642168 | 37.7620306969809 | -122.504876348182 | (37.7620306969809, -122.504876348182) | 1 | 8 | 3 | 56 | 35 | ||
| 177745 | 78252 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 541 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776648 | 6003018.57122 | 2090471.02112 | 37.7202064317688 | -122.431607573443 | (37.7202064317688, -122.431607573443) | 9 | 7 | 6 | 28861 | 5 | |
| 181692 | 182658 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2242 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987004.6631 | 2102364.6195 | 37.7519424365087 | -122.487834969288 | (37.7519424365087, -122.487834969288) | 1 | 8 | 3 | 56 | 35 | |||
| 183256 | 88394 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 139 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.7867985724398 | -122.485322676521 | (37.7867985724398, -122.485322676521) | 11 | 6 | 1 | 55 | 33 | ||
| 184601 | 119241 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.5077607921 | (37.776245435782, -122.5077607921) | 11 | 6 | 2 | 55 | 26 | |||
| 184989 | 207009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 451 Hearst Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998610.96321 | 2094365.8508 | 37.7306499124634 | -122.447123295197 | (37.7306499124634, -122.447123295197) | 9 | 7 | 4 | 28861 | 40 | |||
| 186887 | 119083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | 11 | 6 | 2 | 55 | 26 | |||
| 186958 | 120000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 818 30th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5986676.70436 | 2110336.54693 | 37.7738120096448 | -122.489555240793 | (37.7738120096448, -122.489555240793) | 11 | 6 | 2 | 55 | 26 | |||
| 187150 | 227568 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002743.27179 | 2104198.28781 | 37.7578827294299 | -122.433539694925 | (37.7578827294299, -122.433539694925) | 2 | 4 | 5 | 28862 | 3 | |||
| 193198 | 111714 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
| 193987 | 201809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 237 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020945.51773 | 2093059.30039 | 37.7283131886973 | -122.369818081152 | (37.7283131886973, -122.369818081152) | 10 | 3 | 8 | 58 | 1 | |||
| 194199 | 118595 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | 11 | 6 | 2 | 55 | 26 | |||
| 13551 | 10193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6005736.25987 | 2102154.58599 | 37.7524405594089 | -122.423043415947 | (37.7524405594089, -122.423043415947) | 2 | 4 | 5 | 28859 | 19 | |||
| 34639 | 93188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53196 | 6014934.44131 | 2097265.12572 | 37.7395298812852 | -122.39089262491 | (37.7395298812852, -122.39089262491) | 10 | 3 | 8 | 58 | 1 | |
| 37187 | 227140 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997729.62744 | 2105927.06337 | 37.7623437750648 | -122.451003555094 | (37.7623437750648, -122.451003555094) | 15 | 5 | 11 | 29492 | 9 | |||
| 102170 | 39552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013009.1617 | 2107035.865 | 37.7662512051775 | -122.398234785624 | (37.7662512051775, -122.398234785624) | 14 | 3 | 8 | 28856 | 20 | ||
| 111372 | 105757 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1278 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2014 12:00:00 AM | 10 | 3x3 | Permit Number 771070 | 5999104.9 | 2105310.4 | 37.7607292094813 | -122.446202658218 | (37.7607292094813, -122.446202658218) | 15 | 5 | 5 | 28862 | 3 | |
| 140171 | 227080 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1405 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007868.4281 | 2107357.29935 | 37.7668461005058 | -122.416038416642 | (37.7668461005058, -122.416038416642) | 8 | 4 | 7 | 28853 | 19 | |||
| 145694 | 40073 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014207.29735 | 2094114.30982 | 37.7308380137496 | -122.393186376362 | (37.7308380137496, -122.393186376362) | 10 | 3 | 8 | 58 | 1 | |
| 145954 | 184331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4020 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 11:29:00 AM | 10 | Width 0ft | 5981969.4907 | 2105600.2172 | 37.7605314799939 | -122.505486826629 | (37.7605314799939, -122.505486826629) | 1 | 8 | 3 | 56 | 35 | ||
| 152733 | 40072 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014219.27435 | 2094112.15212 | 37.7308327545053 | -122.393144818701 | (37.7308327545053, -122.393144818701) | 10 | 3 | 8 | 58 | 1 |
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) );