trees
1,121 rows where qSpecies_id = 6 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | ||
| 61823 | 109689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.73547 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) | 9 | 7 | 6 | 28861 | 5 |
| 179045 | 19350 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 618 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781612 | 5992350.09465 | 2089866.75515 | 37.7179367902328 | -122.468440675709 | (37.7179367902328, -122.468440675709) | 9 | 8 | 6 | 64 | 24 | |
| 12222 | 31158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 600 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Permit Number 785248 | 5993522.80361 | 2089878.90243 | 37.7180378119737 | -122.464388049089 | (37.7180378119737, -122.464388049089) | 9 | 8 | 6 | 64 | 24 | |
| 174741 | 38921 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.7181598049858 | -122.460857119734 | (37.7181598049858, -122.460857119734) | 9 | 8 | 6 | 28861 | 24 | ||
| 72730 | 251681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550 | 2089909 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | 9 | 8 | 6 | 28861 | 24 | ||
| 194470 | 254768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 415 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781626 | 5993212 | 2089957 | 37.7182343284954 | -122.4654680237 | (37.7182343284954, -122.4654680237) | 9 | 8 | 6 | 64 | 24 |
| 111662 | 252898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 28861 | 24 | ||||
| 68598 | 109688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.93373 | 2090069.72294 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) | 9 | 7 | 6 | 28861 | 5 |
| 28327 | 162331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.51041 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | 9 | 8 | 6 | 28861 | 24 | ||
| 189393 | 162332 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 36 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:06:00 PM | 3 | Width 0ft | 5996526.7373 | 2090117.21242 | 37.7188648537082 | -122.45402201441 | (37.7188648537082, -122.45402201441) | 9 | 8 | 6 | 28861 | 24 | ||
| 141360 | 176880 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3333 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012013.01229 | 2090122.10429 | 37.7197540907522 | -122.400492099948 | (37.7197540907522, -122.400492099948) | 10 | 7 | 8 | 309 | 28 | |||
| 102650 | 120680 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717 | 2090174 | 37.7194304401491 | -122.42917217064 | (37.7194304401491, -122.42917217064) | 9 | 7 | 6 | 28861 | 5 | ||
| 30581 | 252889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:45:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
| 161792 | 216723 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:05:00 AM | 3 | Width 2ft | 5995305.86266 | 2090248.98741 | 37.7191565973781 | -122.458251599737 | (37.7191565973781, -122.458251599737) | 9 | 8 | 6 | 28861 | 24 | ||
| 23429 | 176881 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3303 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011991.79808 | 2090250.44255 | 37.7201052985 | -122.400574440964 | (37.7201052985, -122.400574440964) | 10 | 7 | 8 | 309 | 28 | |||
| 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 | ||
| 27595 | 63507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.436537823274 | (37.7196774559426, -122.436537823274) | 9 | 7 | 6 | 28861 | 5 | ||
| 41454 | 253116 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 96295 | 253108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 156762 | 253110 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:46:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 172760 | 253118 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 01:35:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 173524 | 253112 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 182173 | 253114 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:55:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 143452 | 160073 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:36:00 AM | 3 | Width 0ft | 6000082.99934 | 2090399.7386 | 37.7198438772755 | -122.441749724582 | (37.7198438772755, -122.441749724582) | 9 | 7 | 6 | 28861 | 25 | ||
| 161401 | 37831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.35388 | 37.7200688687581 | -122.428658848427 | (37.7200688687581, -122.428658848427) | 9 | 7 | 6 | 28861 | 5 |
| 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 | ||
| 186495 | 57147 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 578 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2012 12:00:00 AM | 6 | 4x4 | Permit Number 14422 | 6001353.29798 | 2090440.69811 | 37.7200286411902 | -122.4373616868 | (37.7200286411902, -122.4373616868) | 9 | 7 | 6 | 28861 | 5 |
| 194372 | 37826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003896.37457 | 2090444.78719 | 37.7201841150858 | -122.428571430748 | (37.7201841150858, -122.428571430748) | 9 | 7 | 6 | 28861 | 5 |
| 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 |
| 165323 | 160071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:31:00 AM | 3 | Width 0ft | 6000209.4859 | 2090450.10808 | 37.7199893866688 | -122.44131611827 | (37.7199893866688, -122.44131611827) | 9 | 7 | 6 | 28861 | 25 | ||
| 194422 | 37823 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:49:00 AM | 3 | 3x3 | Permit Number 40134 | 6003922.69393 | 2090463.29382 | 37.7202364196636 | -122.428481771941 | (37.7202364196636, -122.428481771941) | 9 | 7 | 6 | 28861 | 5 |
| 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 | |
| 194398 | 162836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/2020 12:00:00 AM | 0 | 4x6 | 5996489.45825 | 2090475.5577 | 37.7198466480955 | -122.454176740991 | (37.7198466480955, -122.454176740991) | 9 | 8 | 6 | 28861 | 24 | |
| 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 |
| 176834 | 37820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003945.80086 | 2090498.97809 | 37.7203357084188 | -122.428404441018 | (37.7203357084188, -122.428404441018) | 9 | 7 | 6 | 28861 | 5 |
| 101905 | 43742 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 107401 | 43741 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 139435 | 43740 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 144972 | 43739 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 |
| 14976 | 160069 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:26:00 AM | 3 | Width 0ft | 6000296.79811 | 2090527.78789 | 37.7202076512361 | -122.441019880684 | (37.7202076512361, -122.441019880684) | 9 | 7 | 6 | 28861 | 25 | ||
| 112582 | 207022 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.7200365066592 | -122.452230901246 | (37.7200365066592, -122.452230901246) | 9 | 8 | 6 | 28861 | 24 | |||
| 151234 | 207023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997061.02366 | 2090546.31892 | 37.7200737008175 | -122.452206152789 | (37.7200737008175, -122.452206152789) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |
| 34235 | 207024 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997067.34432 | 2090557.59428 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | 9 | 8 | 6 | 28861 | 24 | |||
| 120285 | 207025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997075.91635 | 2090573.81293 | 37.7201500460637 | -122.452156656813 | (37.7201500460637, -122.452156656813) | 9 | 8 | 6 | 28861 | 24 | |||
| 13676 | 262543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015062.6163 | 2090599.75011 | 37.7212352119804 | -122.389983958896 | (37.7212352119804, -122.389983958896) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 99068 | 176488 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 295 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 09:25:00 AM | 3 | Width 2ft | 6004452.71642 | 2090718.28415 | 37.7209665468512 | -122.4266678079 | (37.7209665468512, -122.4266678079) | 9 | 7 | 6 | 28861 | 5 | ||
| 104234 | 160065 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:13:00 AM | 3 | Width 0ft | 6000417.53141 | 2090750.67913 | 37.7208265358932 | -122.440618525839 | (37.7208265358932, -122.440618525839) | 9 | 7 | 6 | 28861 | 25 | ||
| 91359 | 103118 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 443 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2013 12:00:00 AM | Permit Number 769638 | 5992399.1 | 2090786.9 | 37.72046611452 | -122.468338191478 | (37.72046611452, -122.468338191478) | 9 | 8 | 6 | 64 | 24 | |||
| 27543 | 83558 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52321 | 6001949.50225 | 2090800.06366 | 37.7210492547906 | -122.435326507535 | (37.7210492547906, -122.435326507535) | 9 | 7 | 6 | 28861 | 5 | |
| 133607 | 83264 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52321 | 6001958.21107 | 2090814.31383 | 37.7210888771378 | -122.43529742254 | (37.7210888771378, -122.43529742254) | 9 | 7 | 6 | 28861 | 5 | |
| 80180 | 160063 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:07:00 AM | 3 | Width 0ft | 6000471.59074 | 2090857.95331 | 37.7211241647202 | -122.440439349407 | (37.7211241647202, -122.440439349407) | 9 | 7 | 6 | 28861 | 25 | ||
| 190083 | 216655 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 161 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 02:49:00 PM | 3 | Width 3ft | 5995318.74701 | 2090961.58454 | 37.7211139601174 | -122.45825861266 | (37.7211139601174, -122.45825861266) | 9 | 8 | 6 | 28861 | 24 | ||
| 9949 | 162295 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010903.85659 | 2090979.54911 | 37.7220465400048 | -122.404386400036 | (37.7220465400048, -122.404386400036) | 10 | 3 | 7 | 309 | 28 | ||
| 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 | ||
| 41858 | 83563 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 422 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769753 | 6002333.87212 | 2090986.92404 | 37.7215841526661 | -122.434011205875 | (37.7215841526661, -122.434011205875) | 9 | 7 | 6 | 28861 | 5 | |
| 117585 | 160061 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:02:00 AM | 3 | Width 0ft | 6000547.45442 | 2091000.21878 | 37.7215191128017 | -122.440187308101 | (37.7215191128017, -122.440187308101) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | ||
| 122431 | 160059 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 10:50:00 AM | 3 | Width 0ft | 6000588.55744 | 2091082.64129 | 37.7217477663201 | -122.440051133668 | (37.7217477663201, -122.440051133668) | 9 | 7 | 6 | 28861 | 25 | ||
| 111712 | 253162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 323 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004481 | 2091226 | 37.7223622223708 | -122.426606175157 | (37.7223622223708, -122.426606175157) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | |||
| 131707 | 52954 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.11633 | 37.7224704120511 | -122.439451120374 | (37.7224704120511, -122.439451120374) | 9 | 7 | 6 | 28861 | 25 | |
| 140514 | 95742 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 86 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767488 | 6004830.44311 | 2091416.58174 | 37.7229052675357 | -122.425411786848 | (37.7229052675357, -122.425411786848) | 9 | 7 | 6 | 28861 | 5 |
| 134136 | 84680 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49721 | 5996259.49937321 | 2091420.61840977 | 37.722428372357 | -122.45503987717 | (37.722428372357, -122.45503987717) | 9 | 8 | 4 | 28861 | 24 | ||
| 102267 | 207020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996253.66444 | 2091441.06295 | 37.7224841734802 | -122.455061523672 | (37.7224841734802, -122.455061523672) | 9 | 8 | 4 | 28861 | 24 | |||
| 13726 | 80104 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 425 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 52309 | 6003144.80516 | 2091503.70271 | 37.7230491006299 | -122.43124489935 | (37.7230491006299, -122.43124489935) | 9 | 7 | 6 | 28861 | 5 | ||
| 178481 | 117431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776696 | 6004211.11578 | 2091567.32576 | 37.7232841663055 | -122.427563407639 | (37.7232841663055, -122.427563407639) | 9 | 7 | 6 | 28861 | 5 | ||
| 85730 | 43321 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 283 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49915 | 6004368.56572 | 2091597.24704 | 37.7233752280736 | -122.427021263027 | (37.7233752280736, -122.427021263027) | 9 | 7 | 6 | 28861 | 5 | |
| 29101 | 176889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004392.5622 | 2091665.65248 | 37.7235644112504 | -122.426943181195 | (37.7235644112504, -122.426943181195) | 9 | 7 | 6 | 28861 | 5 | |||
| 89273 | 38913 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 154355 | 38914 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 185386 | 83364 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 319 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52323 | 6002520.66221 | 2091711.14442 | 37.7235832988126 | -122.433417250421 | (37.7235832988126, -122.433417250421) | 9 | 7 | 6 | 28861 | 5 | |
| 12664 | 45661 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 315 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/2001 12:00:00 AM | 6 | Permit Number 44357 | 6002302.86118 | 2091870.52112 | 37.7240085522374 | -122.434181537449 | (37.7240085522374, -122.434181537449) | 9 | 7 | 6 | 28861 | 5 | |
| 37676 | 176896 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005242.33299 | 2091887.73518 | 37.7242222149627 | -122.424021456542 | (37.7242222149627, -122.424021456542) | 9 | 7 | 6 | 28861 | 5 | |||
| 56393 | 176895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005265.09064 | 2091962.62602 | 37.7244291336757 | -122.42394810962 | (37.7244291336757, -122.42394810962) | 9 | 7 | 6 | 28861 | 5 | |||
| 10786 | 95722 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 24139 | 95719 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 25141 | 95718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 53300 | 95720 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 84749 | 95721 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 101773 | 176894 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 La Grande Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005238.00808 | 2092009.90059 | 37.7245574102793 | -122.424045090732 | (37.7245574102793, -122.424045090732) | 9 | 7 | 6 | 28861 | 5 | |||
| 136480 | 83533 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 242 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769751 | 6002979.54268 | 2092016.08462 | 37.724446620113 | -122.431852745731 | (37.724446620113, -122.431852745731) | 9 | 7 | 6 | 28861 | 5 |
| 123988 | 176893 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 La Grande Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005229.89136 | 2092027.90961 | 37.7246064008395 | -122.424074429316 | (37.7246064008395, -122.424074429316) | 9 | 7 | 6 | 28861 | 5 | |||
| 65352 | 176897 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 338 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006634.64196 | 2092369.41813 | 37.7256233218417 | -122.419242591383 | (37.7256233218417, -122.419242591383) | 9 | 7 | 7 | 309 | 5 | |||
| 23899 | 95684 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 334 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767433 | 6006626.2 | 2092405.9 | 37.72572301772 | -122.419274361386 | (37.72572301772, -122.419274361386) | 9 | 7 | 7 | 309 | 5 | |
| 17874 | 170661 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000920.86362 | 2092466.57168 | 37.7255666366796 | -122.439001572678 | (37.7255666366796, -122.439001572678) | 9 | 7 | 6 | 28861 | 25 | ||
| 10461 | 170660 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2020 12:00:00 AM | 3 | Width 3ft | 6000886.10189 | 2092489.73569 | 37.7256282618212 | -122.439123400224 | (37.7256282618212, -122.439123400224) | 9 | 7 | 6 | 28861 | 25 | ||
| 3013 | 109184 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 148517 | 109183 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 14410 | 170659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 6x4 | 6000830.95965 | 2092528.01217 | 37.7257302224446 | -122.439316764384 | (37.7257302224446, -122.439316764384) | 9 | 7 | 6 | 28861 | 25 | ||
| 30949 | 176888 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002306.40089 | 2092528.29831 | 37.7258148612434 | -122.434216303453 | (37.7258148612434, -122.434216303453) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | ||
| 15013 | 170657 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000770.58972 | 2092571.08998 | 37.7258450685777 | -122.439528544816 | (37.7258450685777, -122.439528544816) | 9 | 7 | 6 | 28861 | 25 | ||
| 186425 | 109577 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002290.3134 | 2092582.02308 | 37.72596146424 | -122.434275755847 | (37.72596146424, -122.434275755847) | 9 | 7 | 6 | 28861 | 25 |
| 93865 | 109578 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.7260084870829 | -122.434372977031 | (37.7260084870829, -122.434372977031) | 9 | 7 | 6 | 28861 | 25 |
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) );