Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10693 | 10693 | 37723 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 05:05:00 PM | 3 | 3x3 | Permit Number 774917 | 5983867.1917 | 2098797.5436 | 37.741964716019396 | -122.498421176446 | (37.7419647160194, -122.498421176446) | |
| 10726 | 10726 | 26985 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1353 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6009441.55287 | 2094364.79553 | 37.731259886623896 | -122.409680064978 | (37.7312598866239, -122.409680064978) | ||
| 10740 | 10740 | 27042 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 730 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6006159.1890199995 | 2093550.7367900002 | 37.7288401770086 | -122.420970032554 | (37.7288401770086, -122.420970032554) | ||
| 10843 | 10843 | 27202 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003502.33889 | 2093475.71167 | 37.7284840526724 | -122.43014959163601 | (37.7284840526724, -122.430149591636) | ||
| 10849 | 10849 | 37721 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 05:19:00 PM | 3 | 3x3 | Permit Number 774917 | 5983882.4138 | 2098796.867 | 37.74196375089279 | -122.498368494175 | (37.7419637508928, -122.498368494175) | |
| 10990 | 10990 | 109578 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.72600848708289 | -122.434372977031 | (37.7260084870829, -122.434372977031) |
| 11119 | 11119 | 27314 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 884 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3 | 3X3 | 6007123.27309 | 2093533.58449 | 37.728847377904394 | -122.41763590486799 | (37.7288473779044, -122.417635904868) | ||
| 11129 | 11129 | 57147 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 578 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2012 12:00:00 AM | 6 | 4x4 | Permit Number 14422 | 6001353.29798 | 2090440.6981099998 | 37.720028641190204 | -122.4373616868 | (37.7200286411902, -122.4373616868) |
| 11161 | 11161 | 27102 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 669 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2009 12:00:00 AM | 3 | 3X3 | 6005822.11431 | 2093583.57584 | 37.7289113394767 | -122.422137656546 | (37.7289113394767, -122.422137656546) | ||
| 11210 | 11210 | 27282 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 710 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6006026.1077 | 2093547.18457 | 37.7288229208214 | -122.421429852322 | (37.7288229208214, -122.421429852322) | ||
| 11229 | 11229 | 27181 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 225 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6002702.00816 | 2093915.39197 | 37.7296459533895 | -122.432947772843 | (37.7296459533895, -122.432947772843) | ||
| 11343 | 11343 | 37722 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 04:53:00 PM | 3 | 3x3 | Permit Number 774917 | 5983850.6165 | 2098795.1757 | 37.741957242405206 | -122.498478312402 | (37.7419572424052, -122.498478312402) | |
| 11369 | 11369 | 83554 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003920.58239 | 2093359.5974299998 | 37.728188908672294 | -122.428695428367 | (37.7281889086723, -122.428695428367) |
| 11394 | 11394 | 27044 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 750 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1999 12:00:00 AM | 3 | 3X3 | 6006334.59281 | 2093563.7909400002 | 37.7288859066417 | -122.42036457476001 | (37.7288859066417, -122.42036457476) | ||
| 11601 | 11601 | 27009 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1446 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 3 | 3X3 | 6010020.23018 | 2094527.09535 | 37.731737938333104 | -122.40769090313299 | (37.7317379383331, -122.407690903133) | ||
| 11687 | 11687 | 83518 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003951.4498 | 2093338.17621 | 37.7281318376981 | -122.428587192249 | (37.7281318376981, -122.428587192249) |
| 11715 | 11715 | 26976 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 504X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3 | 3x3 | 6004631.3919400005 | 2093482.01374 | 37.7285652398765 | -122.42624684333201 | (37.7285652398765, -122.426246843332) | ||
| 11736 | 11736 | 26988 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1339 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 6 | 3X3 | 6009367.01038 | 2094339.1416200001 | 37.731185268979395 | -122.409935962601 | (37.7311852689794, -122.409935962601) | ||
| 11819 | 11819 | 115757 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1718 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998122.34061 | 2088716.2129099998 | 37.715109392747294 | -122.44840583185899 | (37.7151093927473, -122.448405831859) | ||
| 11827 | 11827 | 27212 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003753.294 | 2093466.8220900001 | 37.7284738543786 | -122.429281393342 | (37.7284738543786, -122.429281393342) | ||
| 11861 | 11861 | 117431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 730 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776696 | 6004211.115780001 | 2091567.32576 | 37.7232841663055 | -122.42756340763901 | (37.7232841663055, -122.427563407639) | ||
| 11936 | 11936 | 109688 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.933730001 | 2090069.7229400002 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) |
| 12018 | 12018 | 27177 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 241 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 2X3 | 6002847.37275 | 2093824.8510200002 | 37.729405592491496 | -122.432438768257 | (37.7294055924915, -122.432438768257) | ||
| 12031 | 12031 | 37717 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 04:45:00 PM | 3 | 3x3 | Permit Number 774917 | 5983817.4661 | 2098794.1609 | 37.7419525119456 | -122.498592859082 | (37.7419525119456, -122.498592859082) | |
| 12126 | 12126 | 27207 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003623.95003 | 2093470.2864400002 | 37.7284760433174 | -122.429728788952 | (37.7284760433174, -122.429728788952) | ||
| 12172 | 12172 | 80104 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 425 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2005 12:00:00 AM | 3 | 3x3 | Permit Number 52309 | 6003144.80516 | 2091503.7027099999 | 37.7230491006299 | -122.43124489934999 | (37.7230491006299, -122.43124489935) | |
| 12199 | 12199 | 27193 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 284 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2009 12:00:00 AM | 6 | 3X3 | 6003096.09594 | 2093601.65823 | 37.7288068562446 | -122.431562981455 | (37.7288068562446, -122.431562981455) | ||
| 12241 | 12241 | 27220 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 387 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2009 12:00:00 AM | 6 | 3X3 | 6003946.676519999 | 2093508.2167200001 | 37.728598460843294 | -122.42861580957899 | (37.7285984608433, -122.428615809579) | ||
| 12306 | 12306 | 27287 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1036 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2008 12:00:00 AM | 6 | 3X3 | 6007731.14975 | 2093596.42391 | 37.729054108643 | -122.415538874723 | (37.729054108643, -122.415538874723) | ||
| 12324 | 12324 | 27008 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1430 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009940.18408 | 2094497.7501400001 | 37.731652881356396 | -122.407965571349 | (37.7316528813564, -122.407965571349) | ||
| 12350 | 12350 | 83555 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003936.8249699995 | 2093347.62291 | 37.7281569485605 | -122.428638423918 | (37.7281569485605, -122.428638423918) |
| 12392 | 12392 | 27007 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1424 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009909.30958 | 2094487.23688 | 37.731622285542706 | -122.408071569962 | (37.7316222855427, -122.408071569962) | ||
| 12497 | 12497 | 27237 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 279 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3 | 3X3 | 6003060.07524 | 2093688.7909799998 | 37.7290440614247 | -122.43169372578501 | (37.7290440614247, -122.431693725785) | ||
| 12537 | 12537 | 109577 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 10X Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002290.3134 | 2092582.02308 | 37.72596146424 | -122.434275755847 | (37.72596146424, -122.434275755847) |
| 12620 | 12620 | 27251 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6005015.49022 | 2093543.0573099998 | 37.7287545552706 | -122.424923334442 | (37.7287545552706, -122.424923334442) | |||
| 12688 | 12688 | 27048 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 896 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6007189.55023 | 2093517.44233 | 37.7288067843062 | -122.417405636178 | (37.7288067843062, -122.417405636178) | ||
| 12790 | 12790 | 27106 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 559 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6005090.492430001 | 2093546.0118 | 37.7287669038667 | -122.42466425684299 | (37.7287669038667, -122.424664256843) | ||
| 12859 | 12859 | 27036 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1328 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009383.50137 | 2094296.42093 | 37.7310688913025 | -122.409875935553 | (37.7310688913025, -122.409875935553) | ||
| 12863 | 12863 | 27284 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 636 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2009 12:00:00 AM | 3 | 3X3 | 6005588.17954 | 2093528.26307 | 37.7287462653044 | -122.422942457136 | (37.7287462653044, -122.422942457136) | ||
| 12904 | 12904 | 117426 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 395 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775297 | 6003998.920059999 | 2091015.17385 | 37.7217560742586 | -122.428257595231 | (37.7217560742586, -122.428257595231) | ||
| 12933 | 12933 | 27010 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1462 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010153.37045 | 2094576.2882400001 | 37.7318804638018 | -122.407234074496 | (37.7318804638018, -122.407234074496) | ||
| 12940 | 12940 | 27051 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1008 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 6 | 3x3 | 6007619.46607 | 2093557.16905 | 37.7289400449304 | -122.415922196353 | (37.7289400449304, -122.415922196353) | ||
| 13061 | 13061 | 27046 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 790 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 6 | 3X3 | 6006496.082169999 | 2093583.10222 | 37.728948030017904 | -122.419807663316 | (37.7289480300179, -122.419807663316) | ||
| 13067 | 13067 | 83533 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 242 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769751 | 6002979.54268 | 2092016.08462 | 37.724446620113 | -122.43185274573099 | (37.724446620113, -122.431852745731) |
| 13068 | 13068 | 109689 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.7354700002 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) |
| 13072 | 13072 | 27052 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1016 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6007658.95865 | 2093571.8872599998 | 37.7289826781912 | -122.415786708996 | (37.7289826781912, -122.415786708996) | ||
| 13144 | 13144 | 108829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.7470099998 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | ||
| 13204 | 13204 | 27035 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1300X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009326.50967 | 2094276.52484 | 37.731011066700894 | -122.410071562372 | (37.7310110667009, -122.410071562372) | ||
| 13205 | 13205 | 27117 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 415 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6004172.1589 | 2093507.5126900002 | 37.7286092859714 | -122.42783625385701 | (37.7286092859714, -122.427836253857) | ||
| 13218 | 13218 | 27205 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003575.96193 | 2093472.3389700002 | 37.7284789616109 | -122.429894832577 | (37.7284789616109, -122.429894832577) | ||
| 13749 | 13749 | 68842 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.39337550020399 | (37.7588942535933, -122.393375500204) |
| 13879 | 13879 | 50774 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 14988 | 14988 | 27169 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2080 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2x3 | 6012550.77406 | 2096074.9927599998 | 37.73612947627829 | -122.39905085001999 | (37.7361294762783, -122.39905085002) | ||
| 16012 | 16012 | 88475 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2350 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51428 | 6011686.38123 | 2099767.14104 | 37.7462191214225 | -122.402298941348 | (37.7462191214225, -122.402298941348) | |
| 16132 | 16132 | 88474 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2350 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51428 | 6011695.42869 | 2099760.86607 | 37.7462023967426 | -122.402267215055 | (37.7462023967426, -122.402267215055) | |
| 19613 | 19613 | 109184 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 5 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270.0 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) |
| 20472 | 20472 | 89331 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4658 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201.0 | 2105201.0 | 37.760491360371596 | -122.4424038966 | (37.7604913603716, -122.4424038966) | |||
| 20660 | 20660 | 88463 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 22291 | 22291 | 95431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1938 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767296 | 5988810.2856 | 2102122.1786 | 37.7513819161329 | -122.481573187512 | (37.7513819161329, -122.481573187512) |
| 22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
| 22862 | 22862 | 176910 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009561.38521 | 2094361.93193 | 37.7312587382014 | -122.409265579153 | (37.7312587382014, -122.409265579153) | |||
| 22870 | 22870 | 176911 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009574.07755 | 2094366.6897 | 37.731272513113296 | -122.409222034865 | (37.7312725131133, -122.409222034865) | |||
| 22875 | 22875 | 176912 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009589.47798 | 2094371.19963 | 37.7312857592085 | -122.409169110679 | (37.7312857592085, -122.409169110679) | |||
| 22876 | 22876 | 176913 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009673.25426 | 2094402.8730900001 | 37.7313774208194 | -122.40888171341999 | (37.7313774208194, -122.40888171342) | |||
| 22968 | 22968 | 115802 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1218 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 774518 | 5981226.5 | 2106751.9 | 37.7636499175412 | -122.50814192748999 | (37.7636499175412, -122.50814192749) | ||
| 24382 | 24382 | 96110 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 714 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767765 | 5982615.54512 | 2110891.71154 | 37.7750983990599 | -122.503644329704 | (37.7750983990599, -122.503644329704) |
| 24388 | 24388 | 63507 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.43653782327401 | (37.7196774559426, -122.436537823274) | ||
| 24647 | 24647 | 227111 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.745052125166296 | -122.414033173096 | (37.7450521251663, -122.414033173096) | |||
| 24713 | 24713 | 71549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.41462566084101 | (37.7875672592553, -122.414625660841) |
| 24816 | 24816 | 47267 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1386 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 1 | Permit Number 45208 | 5988680.1995 | 2105896.4201 | 37.7617374028544 | -122.48229953296001 | (37.7617374028544, -122.48229953296) | |
| 25321 | 25321 | 227575 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001460.70601 | 2108045.90078 | 37.7683744785129 | -122.43825097062 | (37.7683744785129, -122.43825097062) | |||
| 25454 | 25454 | 227130 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999573.3022300005 | 2100550.7346900003 | 37.747687072210105 | -122.44424063169599 | (37.7476870722101, -122.444240631696) | |||
| 25567 | 25567 | 227123 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002011.92527 | 2100876.5046200003 | 37.748720385135705 | -122.43583132576201 | (37.7487203851357, -122.435831325762) | |||
| 25668 | 25668 | 118581 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 104 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982478.43556 | 2112606.9372400003 | 37.7797998443253 | -122.504245701476 | (37.7797998443253, -122.504245701476) | |||
| 25776 | 25776 | 227129 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 291 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001319.20971 | 2096463.3667400002 | 37.7365635736601 | -122.43791067344401 | (37.7365635736601, -122.437910673444) | |||
| 25925 | 25925 | 206997 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5992719.48539 | 2106665.14578 | 37.7640822509305 | -122.46838531523998 | (37.7640822509305, -122.46838531524) | |||
| 26189 | 26189 | 83205 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3437 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52337 | 6002190.72031 | 2120034.66861 | 37.8013340766633 | -122.436584154541 | (37.8013340766633, -122.436584154541) | |
| 26324 | 26324 | 50815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 131 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2004 12:00:00 AM | 4 | Permit Number 47338 | 5993943.23893 | 2114634.67726 | 37.7860350644754 | -122.464731509757 | (37.7860350644754, -122.464731509757) | ||
| 26337 | 26337 | 227551 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.75989588789739 | -122.432585790315 | (37.7598958878974, -122.432585790315) | |||
| 26381 | 26381 | 251002 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5981992.43445 | 2112670.6708 | 37.7799462432625 | -122.50593169049299 | (37.7799462432625, -122.505931690493) | |||
| 26506 | 26506 | 191237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014127.4828 | 2095367.51286 | 37.7342746191851 | -122.39354998485001 | (37.7342746191851, -122.39354998485) | |||
| 26796 | 26796 | 47678 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | |
| 26976 | 26976 | 82736 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3219 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767127 | 5984285.2795 | 2103578.3364 | 37.755115968323395 | -122.49732843264 | (37.7551159683234, -122.49732843264) |
| 27087 | 27087 | 191234 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014153.116769999 | 2095403.12134 | 37.734373817081796 | -122.39346385049299 | (37.7343738170818, -122.393463850493) | |||
| 27138 | 27138 | 206991 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1383 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992691.10596 | 2106043.8640900003 | 37.7623747360262 | -122.468438266429 | (37.7623747360262, -122.468438266429) | |||
| 27198 | 27198 | 140780 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.44355075738399 | (37.7796937331341, -122.443550757384) | |||
| 27360 | 27360 | 191232 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.39882697638201 | (37.7363832218132, -122.398826976382) | |||
| 27395 | 27395 | 227153 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008266.03922 | 2099383.96222 | 37.7449754768472 | -122.41409899629299 | (37.7449754768472, -122.414098996293) | |||
| 27407 | 27407 | 98851 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | |
| 28135 | 28135 | 41812 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | |
| 28351 | 28351 | 248531 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997658.267999999 | 2107761.8815 | 37.767377634072794 | -122.451382700243 | (37.7673776340728, -122.451382700243) | |||
| 28609 | 28609 | 227574 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 11 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002707.53405 | 2106779.67068 | 37.764968555288 | -122.43384779545299 | (37.764968555288, -122.433847795453) | |||
| 28890 | 28890 | 182659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2252 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986985.3742 | 2102363.8158 | 37.7519391046129 | -122.487901613135 | (37.7519391046129, -122.487901613135) | |||
| 29103 | 29103 | 227140 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997729.62744 | 2105927.06337 | 37.7623437750648 | -122.45100355509399 | (37.7623437750648, -122.451003555094) | |||
| 29298 | 29298 | 191239 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014110.40607 | 2095343.3649799998 | 37.7342073651799 | -122.39360733551399 | (37.7342073651799, -122.393607335514) | |||
| 29460 | 29460 | 191230 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014739.49892 | 2096121.8776900002 | 37.7363799383901 | -122.391486752132 | (37.7363799383901, -122.391486752132) | |||
| 29931 | 29931 | 129373 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2133 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000002.55629 | 2120892.7221 | 37.8035654727314 | -122.444217840184 | (37.8035654727314, -122.444217840184) | |||
| 30112 | 30112 | 207019 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 234 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5998513.62611 | 2093807.4558 | 37.7291111292533 | -122.447419626323 | (37.7291111292533, -122.447419626323) | |||
| 30724 | 30724 | 92441 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1368 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52832 | 5982163.8853 | 2105798.2136 | 37.7610865595393 | -122.504829187778 | (37.7610865595393, -122.504829187778) |
| 31107 | 31107 | 129376 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.43618176277398 | (37.7925242837291, -122.436181762774) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");