trees
290 rows where Police Districts = 7 and qSpecies_id = 6 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 | ||
194121 | 52944 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 20 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2006 12:00:00 AM | Permit Number 48931 | 6000207.27773758 | 2093260.71462594 | 37.727706542786 | -122.441525334084 | (37.727706542786, -122.441525334084) | 9 | 7 | 6 | 28861 | 25 | |||
193291 | 45368 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 201x OGDEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2001 12:00:00 AM | Permit Number 44193 | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | |||
192118 | 96065 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 168 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767690 | 6005459.8 | 2096128.8 | 37.7358795176789 | -122.423571087421 | (37.7358795176789, -122.423571087421) | 2 | 7 | 7 | 28859 | 2 | |
190265 | 227118 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005870.45988 | 2099040.93392 | 37.7438987545141 | -122.422358119057 | (37.7438987545141, -122.422358119057) | 2 | 7 | 7 | 28859 | 2 | |||
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 |
189614 | 94670 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
189084 | 247053 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 507 Valley St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6002585.44242 | 2099146.18361 | 37.744001891474 | -122.433724457916 | (37.744001891474, -122.433724457916) | 2 | 7 | 5 | 63 | 22 | |||
188729 | 227153 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008266.03922 | 2099383.96222 | 37.7449754768472 | -122.414098996293 | (37.7449754768472, -122.414098996293) | 2 | 7 | 7 | 28859 | 2 | |||
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 |
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 |
185824 | 95108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 445 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54037 | 6002085.32525 | 2093826.71651 | 37.7293674729177 | -122.435073368138 | (37.7293674729177, -122.435073368138) | 9 | 7 | 6 | 28861 | 25 |
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 | |
184989 | 207009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 451 Hearst Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998610.96321 | 2094365.8508 | 37.7306499124634 | -122.447123295197 | (37.7306499124634, -122.447123295197) | 9 | 7 | 4 | 28861 | 40 | |||
184322 | 47592 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | |||
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 | ||
178337 | 227110 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008268.06848 | 2099378.06711 | 37.7449594041621 | -122.41409156248 | (37.7449594041621, -122.41409156248) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | |||
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 |
175351 | 27251 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X3 | 6005015.49022 | 2093543.05731 | 37.7287545552706 | -122.424923334442 | (37.7287545552706, -122.424923334442) | 9 | 7 | 6 | 28861 | 5 | |||
175025 | 115381 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1657X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
173911 | 207046 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997758.19926 | 2095006.4821 | 37.7323601729864 | -122.450117573561 | (37.7323601729864, -122.450117573561) | 9 | 7 | 4 | 59 | 40 | |||
173908 | 251743 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 143 Cordova St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001773 | 2087479 | 37.7119203272299 | -122.43569914015 | (37.7119203272299, -122.43569914015) | 9 | 7 | 6 | 28861 | 5 | |||||
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 | ||
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 | ||
172292 | 176884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.403646486396 | (37.7145850034576, -122.403646486396) | 9 | 7 | 8 | 309 | 39 | ||||
172275 | 227111 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.7450521251663 | -122.414033173096 | (37.7450521251663, -122.414033173096) | 2 | 7 | 7 | 28859 | 2 | |||
171991 | 47551 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45415 | 6003395.23441175 | 2098403.20907691 | 37.7420077721371 | -122.430871369414 | (37.7420077721371, -122.430871369414) | 2 | 7 | 5 | 63 | 22 | ||
171958 | 159348 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:44:00 AM | 3 | Width 0ft | 5998312.68186 | 2087372.36678 | 37.7114303786888 | -122.447651252104 | (37.7114303786888, -122.447651252104) | 9 | 7 | 6 | 28861 | 25 | ||
171605 | 83555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003936.82497 | 2093347.62291 | 37.7281569485605 | -122.428638423918 | (37.7281569485605, -122.428638423918) | 9 | 7 | 6 | 28861 | 5 |
171342 | 47598 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
169270 | 27286 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 682 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6005885.56477 | 2093523.1174 | 37.7287489124796 | -122.421914010506 | (37.7287489124796, -122.421914010506) | 9 | 7 | 7 | 309 | 5 | ||
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 | ||
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 | |
167819 | 176886 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 119 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002169.33644 | 2093633.71931 | 37.7288423165165 | -122.434769138285 | (37.7288423165165, -122.434769138285) | 9 | 7 | 6 | 28861 | 25 | |||
167721 | 102093 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
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 | ||
164972 | 59404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 770892 | 6003547.68037437 | 2095024.45734525 | 37.7327391275899 | -122.430103282559 | (37.7327391275899, -122.430103282559) | 9 | 7 | 5 | 28861 | 25 | |||
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 | ||||
163948 | 42105 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51455 | 5999382.77994639 | 2094344.80390055 | 37.730636191214 | -122.444453504412 | (37.730636191214, -122.444453504412) | 9 | 7 | 4 | 28861 | 40 | ||
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 | ||
162043 | 227159 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 156 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005558.07312 | 2099948.5227 | 37.7463731599945 | -122.423502792335 | (37.7463731599945, -122.423502792335) | 2 | 7 | 5 | 28859 | 22 | |||
161683 | 207045 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 607 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998977.59415 | 2096753.43976 | 37.7372266087217 | -122.446027465895 | (37.7372266087217, -122.446027465895) | 9 | 7 | 4 | 59 | 40 | |||
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 |
161307 | 176916 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 380 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001888.93185 | 2087835.89796 | 37.7129068748214 | -122.435323960636 | (37.7129068748214, -122.435323960636) | 9 | 7 | 6 | 28861 | 5 | |||
160467 | 27283 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 630 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/2008 12:00:00 AM | 6 | 3X3 | 6005560.76907 | 2093525.90712 | 37.7287382496569 | -122.423037049614 | (37.7287382496569, -122.423037049614) | 9 | 7 | 7 | 309 | 5 | ||
157521 | 27181 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 225 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6002702.00816 | 2093915.39197 | 37.7296459533895 | -122.432947772843 | (37.7296459533895, -122.432947772843) | 9 | 7 | 6 | 28861 | 25 | ||
156893 | 27081 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
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 | ||
155326 | 176918 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 9 | Median : Yard | Tree | DPW 1 | 4 | 6001604.80367 | 2088215.91202 | 37.7139341694897 | -122.436333178956 | (37.7139341694897, -122.436333178956) | 9 | 7 | 6 | 28861 | 5 | ||||
154918 | 52292 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48451 | 6006201.82590602 | 2099532.89904471 | 37.7452682661505 | -122.421247257698 | (37.7452682661505, -122.421247257698) | 2 | 7 | 5 | 28859 | 2 | ||
154340 | 176919 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 140 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6001505.61042 | 2087336.29034 | 37.7115132862848 | -122.436613103724 | (37.7115132862848, -122.436613103724) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
151770 | 27220 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 387 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2009 12:00:00 AM | 6 | 3X3 | 6003946.67652 | 2093508.21672 | 37.7285984608433 | -122.428615809579 | (37.7285984608433, -122.428615809579) | 9 | 7 | 6 | 28861 | 5 | ||
151427 | 176883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6011048.63475 | 2088252.82193 | 37.7145675926038 | -122.403694172945 | (37.7145675926038, -122.403694172945) | 9 | 7 | 8 | 309 | 39 | ||||
148992 | 94654 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53793 | 6003689 | 2095884 | 37.7351072400417 | -122.429675988088 | (37.7351072400417, -122.429675988088) | 2 | 7 | 5 | 63 | 7 | |
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 | |||
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 |
148332 | 113418 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 598X BENTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007207 | 2095355 | 37.7338532991757 | -122.417475487879 | (37.7338532991757, -122.417475487879) | 2 | 7 | 7 | 28859 | 2 | |||
148114 | 227117 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003535.84775 | 2095026.78251 | 37.7327448417949 | -122.430144356698 | (37.7327448417949, -122.430144356698) | 9 | 7 | 5 | 28861 | 25 | |||
148035 | 176891 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 128 Craut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004014.42285 | 2094241.19444 | 37.7306148874672 | -122.428433829062 | (37.7306148874672, -122.428433829062) | 9 | 7 | 6 | 28861 | 5 | |||
147878 | 207049 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997703.56918 | 2095007.7992 | 37.7323606631136 | -122.450306536421 | (37.7323606631136, -122.450306536421) | 9 | 7 | 4 | 59 | 40 | |||
145882 | 27201 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 300 Silver Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/2012 12:00:00 AM | 3 | 3X3 | 6003188.8907382 | 2093541.6739542 | 37.728647412081 | -122.431237903911 | (37.728647412081, -122.431237903911) | 9 | 7 | 6 | 28861 | 5 | ||
145329 | 110718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 201x OGDEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 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 | ||
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 | |||
144492 | 116789 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 530 CRESCENT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007719 | 2095661 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | 2 | 7 | 7 | 28859 | 2 | ||||
144424 | 116545 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 1 | Median : Yard | Tree | DPW 1 | 2 | 3x3 | 6001537.05763 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
141967 | 159345 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:39:00 AM | 3 | Width 0ft | 5998268.07471 | 2087327.6085 | 37.7113049331395 | -122.447802205131 | (37.7113049331395, -122.447802205131) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
140777 | 27106 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 559 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6005090.49243 | 2093546.0118 | 37.7287669038667 | -122.424664256843 | (37.7287669038667, -122.424664256843) | 9 | 7 | 6 | 28861 | 5 | ||
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 |
139943 | 115757 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1718 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998122.34061 | 2088716.21291 | 37.7151093927473 | -122.448405831859 | (37.7151093927473, -122.448405831859) | 9 | 7 | 6 | 28861 | 25 | ||
139841 | 176902 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 676 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005861.55708 | 2093540.19411 | 37.7287944473924 | -122.421998219354 | (37.7287944473924, -122.421998219354) | 9 | 7 | 7 | 309 | 5 | |||
139614 | 159347 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:27:00 AM | 3 | Width 0ft | 5998288.37354 | 2087349.92963 | 37.7113673820764 | -122.44773365339 | (37.7113673820764, -122.44773365339) | 9 | 7 | 6 | 28861 | 25 | ||
139455 | 116549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 5 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001562.82912 | 2088145.24079 | 37.7137377368707 | -122.436473203396 | (37.7137377368707, -122.436473203396) | 9 | 7 | 6 | 28861 | 5 | |||
138739 | 82870 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 110 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 53934 | 6006630.39976 | 2094273.0498 | 37.730850041274 | -122.419392243064 | (37.730850041274, -122.419392243064) | 9 | 7 | 7 | 309 | 5 |
138570 | 116539 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 2 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001567.48738 | 2088213.72569 | 37.7139260459311 | -122.436462001442 | (37.7139260459311, -122.436462001442) | 9 | 7 | 6 | 28861 | 5 | |||
138388 | 116548 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 4 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001544.87474 | 2088178.15499 | 37.7138270917124 | -122.436537614614 | (37.7138270917124, -122.436537614614) | 9 | 7 | 6 | 28861 | 5 | |||
137268 | 176906 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 769 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006512.6379 | 2093630.87617 | 37.7290801395131 | -122.419753817278 | (37.7290801395131, -122.419753817278) | 9 | 7 | 7 | 309 | 5 | |||
136837 | 95677 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 231 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767429 | 6006245.60839 | 2092760.95718 | 37.7266764855102 | -122.420615232913 | (37.7266764855102, -122.420615232913) | 9 | 7 | 7 | 309 | 5 |
136658 | 227102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1451 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003961.99133 | 2099782.46881 | 37.7458269972341 | -122.4290100202 | (37.7458269972341, -122.4290100202) | 2 | 7 | 5 | 63 | 22 | |||
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 |
136110 | 27042 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6006159.18902 | 2093550.73679 | 37.7288401770086 | -122.420970032554 | (37.7288401770086, -122.420970032554) | 9 | 7 | 7 | 309 | 5 | ||
136013 | 227148 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 401 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008617.64213 | 2096897.82478 | 37.7381688320284 | -122.412707488766 | (37.7381688320284, -122.412707488766) | 10 | 7 | 7 | 28859 | 2 | |||
134804 | 82755 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50226 | 6009275.52393785 | 2099776.98643755 | 37.746111283151 | -122.410636116717 | (37.746111283151, -122.410636116717) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |
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 | ||
132775 | 180842 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.451155786013 | (37.710473721248, -122.451155786013) | 9 | 7 | 6 | 28861 | 25 | ||
132281 | 254353 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2 Ankeny St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011131.69741 | 2089639.6721 | 37.7183802415409 | -122.403504586485 | (37.7183802415409, -122.403504586485) | 10 | 7 | 8 | 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 | |
130620 | 227108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007939.95228 | 2098099.81155 | 37.7414311632286 | -122.415135668203 | (37.7414311632286, -122.415135668203) | 2 | 7 | 7 | 28859 | 2 |
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) );