trees
2,180 rows where qSpecies_id = 57 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33758 | 101245 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.7638658419872 | -122.465411719392 | (37.7638658419872, -122.465411719392) | 1 | 8 | 11 | 56 | 12 | |||
142314 | 54212 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1301X 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993618.71802201 | 2106620.31797794 | 37.7640110640874 | -122.465271900961 | (37.7640110640874, -122.465271900961) | 1 | 8 | 11 | 56 | 12 | |||
186036 | 252819 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 407 Miguel St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | Permit Number 780051 | 6004479 | 2096413 | 37.7366044563371 | -122.426982337456 | (37.7366044563371, -122.426982337456) | 2 | 7 | 5 | 63 | 7 | ||
9687 | 121554 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 330 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 779292 | 6001441 | 2103840 | 37.7568249841019 | -122.438017823933 | (37.7568249841019, -122.438017823933) | 2 | 4 | 5 | 28862 | 3 | ||
133053 | 120901 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2032 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778866 | 6001448.95372 | 2115547.55562 | 37.7889714571097 | -122.438829258958 | (37.7889714571097, -122.438829258958) | 13 | 6 | 1 | 29490 | 27 | |
92422 | 114432 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 700 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777170 | 5992893.39745 | 2110635.08838 | 37.774992699186 | -122.468072606609 | (37.774992699186, -122.468072606609) | 11 | 6 | 2 | 54 | 11 | ||
48534 | 114558 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.425814460096 | (37.7936541667538, -122.425814460096) | 13 | 9 | 1 | 28858 | 27 | ||
151462 | 62699 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005257.84776 | 2117174.75811 | 37.793655307103 | -122.425766849977 | (37.793655307103, -122.425766849977) | 13 | 9 | 1 | 28858 | 27 | ||
76573 | 61934 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2015 12:00:00 AM | 3 | 6x12 | Permit Number 775576 | 6005635.57133528 | 2100244.82922864 | 37.747191123988 | -122.42325587148 | (37.747191123988, -122.42325587148) | 2 | 7 | 5 | 28859 | 22 |
113675 | 38523 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2014 12:00:00 AM | 3 | Permit Number 773138 | 6008768.83808 | 2118471.22766 | 37.7974128706661 | -122.41371022836 | (37.7974128706661, -122.41371022836) | 5 | 1 | 10 | 308 | 21 | |
41981 | 57660 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4417 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1976 12:00:00 AM | 3x3 | Permit Number 772993 | 6001718.02788931 | 2104070.42319625 | 37.7574734209258 | -122.437076257467 | (37.7574734209258, -122.437076257467) | 2 | 4 | 5 | 28862 | 3 | ||
124284 | 26194 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | Permit Number 772904 | 6002390.549968 | 2104882.2284699 | 37.7597406467411 | -122.434808462305 | (37.7597406467411, -122.434808462305) | 2 | 4 | 5 | 28862 | 3 | ||
194071 | 142062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | 7 | 9 | 11 | 29490 | 41 | |
52988 | 99678 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | |
75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
78795 | 102165 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769758 | 6003795.7 | 2104247.9 | 37.7580786087619 | -122.429903496461 | (37.7580786087619, -122.429903496461) | 2 | 4 | 5 | 28862 | 3 |
160174 | 101866 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 851 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2013 12:00:00 AM | 2 | 3x3 | Permit Number 769709 | 6001077.03769 | 2088890.9773 | 37.7157577463948 | -122.438205662778 | (37.7157577463948, -122.438205662778) | 9 | 7 | 6 | 28861 | 5 | |
59530 | 101406 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50-52 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769364 | 6005160.9 | 2107520.2 | 37.7671407866326 | -122.425414915098 | (37.7671407866326, -122.425414915098) | 8 | 4 | 5 | 28853 | 19 | |
21457 | 73647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769028 | 6011581.87532 | 2119117.15178 | 37.7993439875935 | -122.404021813977 | (37.7993439875935, -122.404021813977) | 3 | 1 | 10 | 308 | 23 | |
13594 | 96006 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009630.99676 | 2116399.7599 | 37.7917735027068 | -122.410580567837 | (37.7917735027068, -122.410580567837) | 5 | 1 | 10 | 28857 | 21 |
35027 | 96011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009766.64536 | 2116419.41202 | 37.7918350666884 | -122.410112610112 | (37.7918350666884, -122.410112610112) | 5 | 1 | 10 | 28857 | 21 |
63465 | 96010 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767660 | 6009745.43326 | 2116416.20911 | 37.7918250833144 | -122.410185778057 | (37.7918250833144, -122.410185778057) | 5 | 1 | 10 | 28857 | 21 |
108182 | 96009 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009716.90014 | 2116412.09513 | 37.7918121879409 | -122.410284212457 | (37.7918121879409, -122.410284212457) | 5 | 1 | 10 | 28857 | 21 |
108834 | 96008 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009692.64051 | 2116408.65151 | 37.791801372693 | -122.410367907846 | (37.791801372693, -122.410367907846) | 5 | 1 | 10 | 28857 | 21 |
125787 | 96007 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009660.15049 | 2116404.46705 | 37.7917880618207 | -122.410480028126 | (37.7917880618207, -122.410480028126) | 5 | 1 | 10 | 28857 | 21 |
35577 | 68980 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2258 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53507 | 6000514.3803 | 2119968.02762 | 37.8010556951124 | -122.442380229379 | (37.8010556951124, -122.442380229379) | 13 | 9 | 1 | 57 | 17 | |
51373 | 6003 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.4671908 | 2112668.0181364 | 37.7811196348904 | -122.435296499335 | (37.7811196348904, -122.435296499335) | 15 | 5 | 11 | 29490 | 41 | |
52357 | 6001 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.4671908 | 2112668.0181364 | 37.7811196348904 | -122.435296499335 | (37.7811196348904, -122.435296499335) | 15 | 5 | 11 | 29490 | 41 | |
124351 | 92632 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | 15 | 5 | 11 | 29490 | 41 | ||
146790 | 92634 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | 15 | 5 | 11 | 29490 | 41 | ||
178030 | 6002 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.4671908 | 2112668.0181364 | 37.7811196348904 | -122.435296499335 | (37.7811196348904, -122.435296499335) | 15 | 5 | 11 | 29490 | 41 | |
90343 | 64694 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 114 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005548.53237974 | 2104042.55194245 | 37.7576138796481 | -122.423826843051 | (37.7576138796481, -122.423826843051) | 2 | 4 | 5 | 28859 | 19 | ||
145375 | 89007 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 114 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005558 | 2104034 | 37.757590932481 | -122.42379349206 | (37.757590932481, -122.42379349206) | 2 | 4 | 5 | 28859 | 19 | ||
102984 | 102084 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52515 | 5991161.35766 | 2114023.19945 | 37.7841953413 | -122.474311334384 | (37.7841953413, -122.474311334384) | 11 | 6 | 2 | 54 | 26 |
114604 | 129587 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1911 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 15 | Width 4ft | Permit Number 52344 | 6003864.05358 | 2118305.88007 | 37.7966822173737 | -122.430670247849 | (37.7966822173737, -122.430670247849) | 13 | 9 | 1 | 57 | 17 | |
68654 | 89034 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
68814 | 89032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
85101 | 89033 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
163617 | 89035 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
171918 | 89036 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
25015 | 54931 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1466 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 3x3 | Permit Number 51416 | 6003271.64345897 | 2099695.83318704 | 37.7455500147976 | -122.43139096057 | (37.7455500147976, -122.43139096057) | 2 | 7 | 5 | 63 | 22 | ||
35329 | 88365 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 10 Lyon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411 | (37.7707473776731, -122.44194989411) | 15 | 5 | 11 | 29492 | 9 | |||
61795 | 88217 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51182 | 6002528.21368 | 2117927.18 | 37.7955666353375 | -122.435265448048 | (37.7955666353375, -122.435265448048) | 13 | 9 | 1 | 57 | 17 | |
181148 | 87383 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 431 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 11 | 3x3 | Permit Number 50363 | 5997173.61731 | 2114868.15858 | 37.7868618517374 | -122.453572197813 | (37.7868618517374, -122.453572197813) | 11 | 6 | 1 | 54 | 31 | |
36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
67290 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
129455 | 87082 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3119 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50024 | 5999240.5872 | 2116291.11958 | 37.7908872010279 | -122.446523400642 | (37.7908872010279, -122.446523400642) | 13 | 6 | 1 | 29490 | 31 | |
34718 | 62107 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 373 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49980 | 6006792.08421569 | 2101617.3134298 | 37.7510248549528 | -122.419354081346 | (37.7510248549528, -122.419354081346) | 2 | 4 | 7 | 28859 | 19 | ||
102212 | 51620 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 419 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48838 | 6004007.75048659 | 2096078.78682851 | 37.7356601244905 | -122.428587833263 | (37.7356601244905, -122.428587833263) | 2 | 7 | 5 | 63 | 7 | |||
161700 | 52481 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 338HOLLY PARK Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48591 | 6006994.57282255 | 2096259.62185295 | 37.7363252369186 | -122.418274030892 | (37.7363252369186, -122.418274030892) | 2 | 7 | 7 | 28859 | 2 | ||
97197 | 52416 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 734 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/2005 12:00:00 AM | Permit Number 48535 | 6001832.35713287 | 2089688.63788093 | 37.717990874718 | -122.435651969168 | (37.717990874718, -122.435651969168) | 9 | 7 | 6 | 28861 | 5 | ||
144851 | 52006 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1489 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48222 | 6011774.4965411 | 2101419.07057833 | 37.7507598806074 | -122.402110363809 | (37.7507598806074, -122.402110363809) | 10 | 3 | 8 | 28856 | 29 | ||||
44461 | 51606 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2321 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 47903 | 6001273.37015 | 2116460.68929 | 37.7914686945789 | -122.439502237855 | (37.7914686945789, -122.439502237855) | 13 | 6 | 1 | 29490 | 27 | |||
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
115057 | 34423 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47622 | 6003411.17015121 | 2096158.68200715 | 37.7358457184137 | -122.430656139914 | (37.7358457184137, -122.430656139914) | 2 | 7 | 5 | 63 | 7 | ||
130273 | 51073 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 553 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2004 12:00:00 AM | Permit Number 47535 | 6002758.66460209 | 2103250.32502289 | 37.7552807236709 | -122.433418719485 | (37.7552807236709, -122.433418719485) | 2 | 4 | 5 | 28862 | 22 | |||
42955 | 51053 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 557 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2004 12:00:00 AM | Permit Number 47523 | 6002734.05323147 | 2103248.96658127 | 37.7552755973804 | -122.433503735784 | (37.7552755973804, -122.433503735784) | 2 | 4 | 5 | 28862 | 22 | |||
33910 | 50451 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.7689532065783 | -122.445784947419 | (37.7689532065783, -122.445784947419) | 15 | 5 | 11 | 29492 | 9 | |||
50748 | 50368 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2784 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 4 | Permit Number 47035 | 6000204.6547 | 2114445.9464 | 37.7858758547183 | -122.443055209056 | (37.7858758547183, -122.443055209056) | 13 | 6 | 1 | 29490 | 27 | ||
43434 | 49432 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 364@ KEARNY Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 7 | Permit Number 46371 | 6011662.83332 | 2116037.23111 | 37.7908917875712 | -122.403524862095 | (37.7908917875712, -122.403524862095) | 4 | 1 | 10 | 28854 | 6 | ||
122720 | 49433 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 364@ KEARNY Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 8 | Permit Number 46371 | 6011642.68179 | 2116034.05853 | 37.7908819508039 | -122.403594362585 | (37.7908819508039, -122.403594362585) | 4 | 1 | 10 | 28854 | 6 | ||
150936 | 39756 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 430 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/2002 12:00:00 AM | Permit Number 45959 | 6003532.62268975 | 2103345.12328431 | 37.7555848966333 | -122.430748907314 | (37.7555848966333, -122.430748907314) | 2 | 4 | 5 | 28862 | 22 | ||
134547 | 47892 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 725 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2002 12:00:00 AM | 1 | Permit Number 45636 | 6000495.8068 | 2111504.9503 | 37.7778172299888 | -122.441836750591 | (37.7778172299888, -122.441836750591) | 15 | 5 | 11 | 29490 | 16 | |
131590 | 47214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 570 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 12 | 6x4 | Permit Number 45165 | 6008824.68232 | 2093406.49274 | 37.7285940046859 | -122.411745018113 | (37.7285940046859, -122.411745018113) | 9 | 3 | 7 | 309 | 28 |
124680 | 46971 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1686 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.6238 | 2103640.11 | 37.7551837030962 | -122.50333530778 | (37.7551837030962, -122.50333530778) | 1 | 8 | 3 | 56 | 35 | |
129378 | 46972 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228082 | -122.50333832645 | (37.755217228082, -122.50333832645) | 1 | 8 | 3 | 56 | 35 | |
74157 | 46271 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 325 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2002 12:00:00 AM | Permit Number 44555 | 6006560.87997001 | 2097281.80561087 | 37.739107504355 | -122.419846001297 | (37.739107504355, -122.419846001297) | 2 | 7 | 7 | 28859 | 2 | |||
179184 | 45683 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 107 Bernard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2001 12:00:00 AM | 4 | Permit Number 44370 | 6008292.83323 | 2118060.93092 | 37.79625955578 | -122.415328273299 | (37.79625955578, -122.415328273299) | 5 | 1 | 10 | 28858 | 21 | ||
57313 | 44826 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 129 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2001 12:00:00 AM | Permit Number 43918 | 6010308.29040288 | 2087358.77915196 | 37.7120713475932 | -122.406190163796 | (37.7120713475932, -122.406190163796) | 9 | 7 | 8 | 309 | 39 | |||
54545 | 42985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 12 | 9x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
103561 | 42990 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
110301 | 42989 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
120765 | 42988 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
28646 | 42768 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | 7 | 9 | 11 | 29492 | 10 | ||
39231 | 41268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
70767 | 41267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
20777 | 41179 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.92482 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | 13 | 9 | 1 | 57 | 17 | |
26783 | 41176 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.19311 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | 13 | 9 | 1 | 57 | 17 | |
25788 | 40954 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | 10 | 3 | 8 | 309 | 1 | ||||
5401 | 40626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1999 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | 13 | 1 | 9 | 28858 | 36 | |
60017 | 40560 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.477076541974 | (37.779256995112, -122.477076541974) | 11 | 6 | 2 | 55 | 26 | |
166744 | 40227 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.01784 | 37.7813803084996 | -122.3938724152 | (37.7813803084996, -122.3938724152) | 6 | 2 | 9 | 28856 | 6 | ||
122469 | 40057 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | 10 | 3 | 8 | 58 | 1 | ||
178739 | 40056 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 9 | Permit Number 41291 | 6016422.4594 | 2093017.6709 | 37.727949672355 | -122.385451738871 | (37.727949672355, -122.385451738871) | 10 | 3 | 8 | 58 | 1 | |
77862 | 39881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.7830638517017 | -122.394581669285 | (37.7830638517017, -122.394581669285) | 6 | 2 | 9 | 28856 | 6 | ||
66842 | 38432 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3844 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1998 12:00:00 AM | Permit Number 40460 | 5995813.83516301 | 2115862.46033815 | 37.7895138928462 | -122.45834869498 | (37.7895138928462, -122.45834869498) | 11 | 6 | 1 | 54 | 31 | |||
132714 | 37584 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40015 | 5999640.19520847 | 2104544.9581721 | 37.7586580511622 | -122.444296310612 | (37.7586580511622, -122.444296310612) | 2 | 4 | 5 | 28862 | 3 | ||
119688 | 37554 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4515#A 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1998 12:00:00 AM | Permit Number 39993 | 6000985.32111964 | 2105199.93654746 | 37.7605331136342 | -122.439691220259 | (37.7605331136342, -122.439691220259) | 2 | 4 | 5 | 28862 | 3 | ||
183933 | 37549 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 533 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39989 | 6009274.16052214 | 2114821.41225481 | 37.7874197302007 | -122.411703653187 | (37.7874197302007, -122.411703653187) | 5 | 1 | 10 | 28852 | 36 | ||
174197 | 37544 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 825 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39986 | 6008203.02144852 | 2114810.28677718 | 37.7873290368122 | -122.415408797554 | (37.7873290368122, -122.415408797554) | 13 | 1 | 9 | 28858 | 36 | ||
142017 | 37534 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1138 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | Permit Number 39980 | 6008135.8621207 | 2116394.85818942 | 37.7916761076557 | -122.415753397731 | (37.7916761076557, -122.415753397731) | 5 | 1 | 10 | 28858 | 21 | |||
45856 | 37501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 830 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | 9 | Permit Number 39965 | 6009497.37561 | 2115737.1064 | 37.7899465245609 | -122.410996073526 | (37.7899465245609, -122.410996073526) | 5 | 1 | 10 | 28857 | 21 | ||
145386 | 37500 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 830 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39965 | 6009516.4157 | 2115739.57789 | 37.7899543783457 | -122.410930370855 | (37.7899543783457, -122.410930370855) | 5 | 1 | 10 | 28857 | 21 | |
134760 | 37499 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010316.35975 | 2115796.38999 | 37.790155194247 | -122.408166630084 | (37.790155194247, -122.408166630084) | 5 | 1 | 10 | 28857 | 6 | |
134917 | 37498 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 10 | Permit Number 39964 | 6010355.28098 | 2115804.39021 | 37.7901793401628 | -122.408032529472 | (37.7901793401628, -122.408032529472) | 5 | 1 | 10 | 28857 | 6 | |
158132 | 37497 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010338.55748 | 2115802.28849 | 37.790172633 | -122.408090243478 | (37.790172633, -122.408090243478) | 5 | 1 | 10 | 28857 | 6 | |
86724 | 37256 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
88005 | 37257 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
94622 | 37259 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
98412 | 37252 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 |
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) );