trees
1,121 rows where qSpecies_id = 6 sorted by qSiteInfo descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12682 | 260425 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 508 Dwight St | Unaccepted Street : Yard | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010099.90949 | 2091269.80828 | 37.7227985719868 | -122.407185909529 | (37.7227985719868, -122.407185909529) | 10 | 3 | 7 | 309 | 28 | |||
5680 | 227559 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6000741.27617 | 2104538.3206 | 37.7587025846742 | -122.44048780488 | (37.7587025846742, -122.44048780488) | 2 | 4 | 5 | 28862 | 38 | |||
9404 | 176900 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005606.72127 | 2092829.97134 | 37.7268299557374 | -122.422828750447 | (37.7268299557374, -122.422828750447) | 9 | 7 | 7 | 309 | 5 | |||
13391 | 119240 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981455.34518 | 2111336.83463 | 37.776252294734 | -122.507690683983 | (37.776252294734, -122.507690683983) | 11 | 6 | 2 | 55 | 26 | |||
25424 | 176901 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005600.43917 | 2092849.05844 | 37.7268820102711 | -122.422851823466 | (37.7268820102711, -122.422851823466) | 9 | 7 | 7 | 309 | 5 | |||
31711 | 227556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | 2 | 4 | 5 | 28862 | 38 | |||
40165 | 191226 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6011107.06002 | 2104648.42845 | 37.7595897074225 | -122.404645742032 | (37.7595897074225, -122.404645742032) | 10 | 3 | 8 | 28856 | 29 | |||
45123 | 107987 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 233 Laidley St | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
57763 | 207044 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 755 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | 9 | 7 | 4 | 59 | 40 | |||
71720 | 227560 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.7587502280493 | -122.440503723791 | (37.7587502280493, -122.440503723791) | 2 | 4 | 5 | 28862 | 38 | |||
78745 | 176904 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 Cambridge St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006443.50632 | 2094472.10137 | 37.7313860651023 | -122.420052485745 | (37.7313860651023, -122.420052485745) | 9 | 7 | 7 | 28861 | 5 | |||
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 | |||
144465 | 227561 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | 2 | 4 | 5 | 28862 | 38 | |||
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 | |||
170413 | 191224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011129.67031 | 2104650.44992 | 37.7595965215873 | -122.404567686256 | (37.7595965215873, -122.404567686256) | 10 | 3 | 8 | 28856 | 29 | ||||
174893 | 191225 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011119.4005 | 2104649.28038 | 37.7595927363317 | -122.404603122242 | (37.7595927363317, -122.404603122242) | 10 | 3 | 8 | 28856 | 29 | ||||
177530 | 176905 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 Cambridge St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006453.00873 | 2094472.53688 | 37.7313877962987 | -122.420019664972 | (37.7313877962987, -122.420019664972) | 9 | 7 | 7 | 28861 | 5 | |||
181974 | 227119 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 799 Duncan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6001473.16561 | 2099668.76787 | 37.7453736076231 | -122.437607869022 | (37.7453736076231, -122.437607869022) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
192824 | 227120 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 799 Duncan St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6001486.23397 | 2099669.55813 | 37.7453765205103 | -122.43756273743 | (37.7453765205103, -122.43756273743) | 2 | 7 | 5 | 63 | 22 | |||
1777 | 260927 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 354 Point Lobos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 4ft | 5981645 | 2112753 | 37.7801518383055 | -122.507139709579 | (37.7801518383055, -122.507139709579) | 11 | 6 | 2 | 55 | 26 | ||||
16685 | 251006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 348 Point Lobos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5981660.38525 | 2112713.01394 | 37.7800429545487 | -122.507083518802 | (37.7800429545487, -122.507083518802) | 11 | 6 | 2 | 55 | 26 | |||
23895 | 92663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
41654 | 112585 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | |||
73269 | 92664 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
76214 | 37822 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 10 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:46:00 AM | 3 | 3x3 | Permit Number 40134 | 6003933.77466 | 2090481.79158 | 37.7202878374987 | -122.428444787301 | (37.7202878374987, -122.428444787301) | 9 | 7 | 6 | 28861 | 5 |
84190 | 253150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:41:00 AM | 3 | 3x3 | 6003965.72194 | 2090553.13154 | 37.7204855291627 | -122.428339438009 | (37.7204855291627, -122.428339438009) | 9 | 7 | 6 | 28861 | 5 | |
92790 | 37817 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 5 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003961.27408 | 2090526.10251 | 37.7204110616965 | -122.428352887393 | (37.7204110616965, -122.428352887393) | 9 | 7 | 6 | 28861 | 5 |
122415 | 92665 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
132551 | 112584 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
147556 | 112586 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
167882 | 94679 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 218 Roanoke St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53815 | 6003547 | 2096007 | 37.7354369283878 | -122.430175705062 | (37.7354369283878, -122.430175705062) | 2 | 7 | 5 | 63 | 7 | |
189866 | 37825 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 13 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003912.01731 | 2090448.66207 | 37.7201956398999 | -122.428517635078 | (37.7201956398999, -122.428517635078) | 9 | 7 | 6 | 28861 | 5 |
1932 | 250999 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 206 Point Lobos Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5982160.80138 | 2112648.74636 | 37.7798959540729 | -122.505347618625 | (37.7798959540729, -122.505347618625) | 11 | 6 | 2 | 55 | 26 | |||
9692 | 183446 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2511 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | Width 0ft | 5988279.6214 | 2098205.3016 | 37.7405963382743 | -122.483121197886 | (37.7405963382743, -122.483121197886) | 1 | 8 | 3 | 29491 | 35 | ||
10101 | 180653 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.431934068713 | (37.7100419513527, -122.431934068713) | 9 | 7 | 6 | 28861 | 5 | ||
27064 | 182564 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2122 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | Permit Number 783239 | 5989402.8067 | 2098365.7306 | 37.7411021315374 | -122.479249432397 | (37.7411021315374, -122.479249432397) | 1 | 8 | 3 | 29491 | 35 | ||
30385 | 181018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.04691 | 37.7143947132291 | -122.43841724089 | (37.7143947132291, -122.43841724089) | 9 | 7 | 6 | 28861 | 5 | ||
39381 | 181028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.46766 | 37.7151323074928 | -122.440070279342 | (37.7151323074928, -122.440070279342) | 9 | 7 | 6 | 28861 | 5 | ||
44798 | 184494 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | 1 | 8 | 3 | 56 | 35 | |||
48766 | 207033 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993145.27059 | 2101214.49823 | 37.7491407714503 | -122.466516461993 | (37.7491407714503, -122.466516461993) | 1 | 8 | 4 | 29491 | 12 | |||
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 | |||
59117 | 184544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3425 Moraga St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781517 | 5983632.4928 | 2103556.7404 | 37.7550183908439 | -122.499584326949 | (37.7550183908439, -122.499584326949) | 1 | 8 | 3 | 56 | 35 | |
70068 | 207041 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1414 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995889.45634 | 2093373.14104 | 37.727768297568 | -122.456460143934 | (37.727768297568, -122.456460143934) | 9 | 7 | 4 | 28861 | 40 | |||
72364 | 216718 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.459124173263 | (37.7196152839906, -122.459124173263) | 9 | 8 | 6 | 28861 | 24 | ||
72800 | 121883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 18th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5990230.48175 | 2114847.31405 | 37.786404156248 | -122.477592056385 | (37.786404156248, -122.477592056385) | 11 | 6 | 1 | 55 | 33 | |||
80376 | 184160 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3538 Lawton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/28/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781479 | 5983222.1931 | 2104276.0104 | 37.7569692214498 | -122.50105643195 | (37.7569692214498, -122.50105643195) | 1 | 8 | 3 | 56 | 35 | |
81876 | 227086 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6009619.77164 | 2096165.81934 | 37.7362150980513 | -122.409190969587 | (37.7362150980513, -122.409190969587) | 10 | 7 | 7 | 28859 | 2 | |||
82053 | 121884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 18th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5990230.57834 | 2114834.81932 | 37.7863698548312 | -122.477590808601 | (37.7863698548312, -122.477590808601) | 11 | 6 | 1 | 55 | 33 | |||
83192 | 227092 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 30 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 9ft | 6009197.49082 | 2095788.04823 | 37.7351541534232 | -122.410624304588 | (37.7351541534232, -122.410624304588) | 10 | 7 | 7 | 28859 | 2 | |||
83985 | 227091 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6009293.03444 | 2095834.73547 | 37.735287702767 | -122.410297269721 | (37.735287702767, -122.410297269721) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
87952 | 207035 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993108.07657 | 2101214.12996 | 37.7491376139164 | -122.466645051533 | (37.7491376139164, -122.466645051533) | 1 | 8 | 4 | 29491 | 12 | |||
93370 | 255421 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2727 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780223 | 5985829 | 2096861 | 37.7367623321138 | -122.491495459369 | (37.7367623321138, -122.491495459369) | 1 | 8 | 3 | 29491 | 35 | |
98535 | 227088 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 6009533.30641 | 2096029.17809 | 37.7358350661275 | -122.409480276115 | (37.7358350661275, -122.409480276115) | 10 | 7 | 7 | 28859 | 2 | |||
109143 | 181019 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.7144296473919 | -122.438501549606 | (37.7144296473919, -122.438501549606) | 9 | 7 | 6 | 28861 | 5 | ||
110146 | 227090 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6009411.625 | 2095915.20486 | 37.7355153013828 | -122.409892935407 | (37.7355153013828, -122.409892935407) | 10 | 7 | 7 | 28859 | 2 | |||
111414 | 227548 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Jersey St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003268.76291 | 2101573.30364 | 37.7507049460775 | -122.431534930712 | (37.7507049460775, -122.431534930712) | 2 | 4 | 5 | 28862 | 22 | |||
117385 | 181020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.93011 | 37.7144764921819 | -122.438602919392 | (37.7144764921819, -122.438602919392) | 9 | 7 | 6 | 28861 | 5 | ||
129549 | 184161 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3540 Lawton St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/28/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781479 | 5983209.359 | 2104274.4825 | 37.7569642726582 | -122.501100703383 | (37.7569642726582, -122.501100703383) | 1 | 8 | 3 | 56 | 35 | |
133452 | 181027 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.24811 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | 9 | 7 | 6 | 28861 | 5 | ||
139625 | 184669 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1679 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782746 | 5984671.7436 | 2103779.4399 | 37.7556907855566 | -122.496006782875 | (37.7556907855566, -122.496006782875) | 1 | 8 | 3 | 56 | 35 | |
140576 | 207034 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993127.03688 | 2101215.11136 | 37.7491414027515 | -122.466579558421 | (37.7491414027515, -122.466579558421) | 1 | 8 | 4 | 29491 | 12 | |||
145000 | 227089 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6009456.29094 | 2095946.49023 | 37.7356037074354 | -122.409740715285 | (37.7356037074354, -122.409740715285) | 10 | 7 | 7 | 28859 | 2 | |||
145011 | 117426 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 395 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775297 | 6003998.92006 | 2091015.17385 | 37.7217560742586 | -122.428257595231 | (37.7217560742586, -122.428257595231) | 9 | 7 | 6 | 28861 | 5 | ||
147718 | 201819 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021071.50009 | 2093300.77069 | 37.7289831323462 | -122.369399226393 | (37.7289831323462, -122.369399226393) | 10 | 3 | 8 | 58 | 1 | ||
148726 | 227093 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 31 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 9ft | 6009184.48132 | 2095791.05398 | 37.7351616771725 | -122.410669495512 | (37.7351616771725, -122.410669495512) | 10 | 7 | 7 | 28859 | 2 | |||
149415 | 201820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021056.53291 | 2093279.09213 | 37.7289227860515 | -122.369449472416 | (37.7289227860515, -122.369449472416) | 10 | 3 | 8 | 58 | 1 | ||
158809 | 184688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1611 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782745 | 5984657.9281 | 2104207.7196 | 37.7568659135367 | -122.496086155975 | (37.7568659135367, -122.496086155975) | 1 | 8 | 3 | 56 | 35 | |
159328 | 201821 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021045.51426 | 2093266.44708 | 37.7288874606638 | -122.369486691782 | (37.7288874606638, -122.369486691782) | 10 | 3 | 8 | 58 | 1 | ||
164477 | 227094 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6009153.63089 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | 10 | 7 | 7 | 28859 | 2 | ||||
168066 | 181011 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 207 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:21:00 AM | 3 | Width 4ft | 6001121.31583 | 2088326.00254 | 37.7142089699327 | -122.438012171843 | (37.7142089699327, -122.438012171843) | 9 | 7 | 6 | 28861 | 5 | ||
176832 | 207039 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 270 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994635.03268 | 2100302.9111 | 37.7467236374953 | -122.461298810415 | (37.7467236374953, -122.461298810415) | 1 | 8 | 4 | 29491 | 40 | |||
181063 | 182513 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1573 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/23/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 777985 | 5985578.9968 | 2104511.5721 | 37.7577541150318 | -122.492923184352 | (37.7577541150318, -122.492923184352) | 1 | 8 | 3 | 56 | 35 | |
184554 | 201822 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021035.49669 | 2093250.02992 | 37.7288418326792 | -122.369520189723 | (37.7288418326792, -122.369520189723) | 10 | 3 | 8 | 58 | 1 | ||
187202 | 183640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1484 47th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5981572.1323 | 2104991.2828 | 37.7588361283195 | -122.506815916291 | (37.7588361283195, -122.506815916291) | 1 | 8 | 3 | 56 | 35 | |||
192989 | 181010 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 215 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:17:00 AM | 3 | Width 4ft | 6001139.6561 | 2088316.90059 | 37.7141850209845 | -122.437948129327 | (37.7141850209845, -122.437948129327) | 9 | 7 | 6 | 28861 | 5 | ||
194177 | 181017 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:28:00 AM | 3 | Width 4ft | 6001019.31887 | 2088386.79799 | 37.7143700996689 | -122.438369065102 | (37.7143700996689, -122.438369065102) | 9 | 7 | 6 | 28861 | 5 | ||
31769 | 227126 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6003395.21055 | 2098417.4445 | 37.742046857971 | -122.430872467617 | (37.742046857971, -122.430872467617) | 2 | 7 | 5 | 63 | 22 | |||
150091 | 129390 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 902 Vallejo St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009192.86484 | 2118752.75452 | 37.798209676283 | -122.412262888224 | (37.798209676283, -122.412262888224) | 3 | 1 | 10 | 308 | 21 | |||
8 | 264824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6012032 | 2089425 | 37.7178410421308 | -122.400377527521 | (37.7178410421308, -122.400377527521) | 10 | 7 | 8 | 309 | 39 | |||
25 | 49783 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | Permit Number 46568 | 6011944.29976 | 2088937.30454 | 37.7164970376796 | -122.400646428989 | (37.7164970376796, -122.400646428989) | 10 | 7 | 8 | 309 | 39 | |
334 | 162296 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010920.41592 | 2090984.45712 | 37.7220609417541 | -122.40432950351 | (37.7220609417541, -122.40432950351) | 10 | 3 | 7 | 309 | 28 | ||
425 | 10157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x7 | 6005745.76106 | 2103227.37374 | 37.7553867222415 | -122.423086804612 | (37.7553867222415, -122.423086804612) | 2 | 4 | 5 | 28859 | 19 | |||
618 | 238270 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 4102 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002298.332 | 2104734.40291 | 37.7593295173753 | -122.435116825204 | (37.7593295173753, -122.435116825204) | 2 | 4 | 5 | 28862 | 3 | |||
639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
664 | 262379 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 925 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2020 12:00:00 AM | 3 | 3x3 | 5998032 | 2106999 | 37.7653043483693 | -122.450035028723 | (37.7653043483693, -122.450035028723) | 15 | 5 | 11 | 29492 | 9 | |
887 | 60297 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1982 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.398152546702 | (37.7662525295396, -122.398152546702) | 14 | 3 | 8 | 28856 | 20 | |
1126 | 262542 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015016 | 2090665 | 37.7214117898675 | -122.390149655616 | (37.7214117898675, -122.390149655616) | 10 | 3 | 8 | 58 | 1 | |||
1269 | 262440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
1415 | 171287 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 339 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003711.94249 | 2092708.61039 | 37.7263896332495 | -122.429370301207 | (37.7263896332495, -122.429370301207) | 9 | 7 | 6 | 28861 | 5 | ||
1417 | 88463 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
1481 | 172310 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 63 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | Width 3ft | 6001999.53893 | 2087418.49495 | 37.7117670587831 | -122.434911834617 | (37.7117670587831, -122.434911834617) | 9 | 7 | 6 | 28861 | 5 | ||
1882 | 170658 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000800.50336 | 2092551.29112 | 37.7257924078835 | -122.439423717141 | (37.7257924078835, -122.439423717141) | 9 | 7 | 6 | 28861 | 25 | ||
1967 | 259348 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450x Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
1972 | 64568 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1888 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51776 | 6000584.4368 | 2111720.243 | 37.7784134187795 | -122.441545602938 | (37.7784134187795, -122.441545602938) | 15 | 5 | 11 | 29490 | 41 |
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) );