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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4697 | 4697 | 60547 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 507 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2017 09:50:00 AM | 3 | Permit Number 20157 | 5984999.38205 | 2112385.8100400004 | 37.779340631831495 | -122.49550845523501 | (37.7793406318315, -122.495508455235) | |
| 4933 | 4933 | 3676 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 112 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:24:00 AM | 3 | 3X3 | 6016964.487509999 | 2099042.50937 | 37.74452264751721 | -122.38399727276101 | (37.7445226475172, -122.383997272761) | ||
| 4944 | 4944 | 3666 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 102 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/02/2017 03:06:00 PM | 3 | 3X3 | 6017134.48475 | 2098914.37607 | 37.744180216238604 | -122.383400533034 | (37.7441802162386, -122.383400533034) | ||
| 4959 | 4959 | 3681 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 117 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/02/2017 03:27:00 PM | 3 | 3X3 | 6016866.9573099995 | 2099120.49255 | 37.7447313810499 | -122.384339945926 | (37.7447313810499, -122.384339945926) | ||
| 4971 | 4971 | 3674 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 110 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:22:00 AM | 3 | 3X3 | 6016998.30504 | 2099015.89853 | 37.7444514490906 | -122.383878484902 | (37.7444514490906, -122.383878484902) | ||
| 4976 | 4976 | 3673 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 109 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:21:00 AM | 3 | 3X3 | 6017015.17172 | 2099002.6203400004 | 37.7444159222737 | -122.38381923847601 | (37.7444159222737, -122.383819238476) | ||
| 5053 | 5053 | 3667 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 103 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/02/2017 03:19:00 PM | 3 | 3X3 | 6017116.62756 | 2098928.27448 | 37.744217391521396 | -122.38346324724199 | (37.7442173915214, -122.383463247242) | ||
| 10352 | 10352 | 27283 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 630 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2008 12:00:00 AM | 6 | 3X3 | 6005560.769069999 | 2093525.90712 | 37.7287382496569 | -122.423037049614 | (37.7287382496569, -122.423037049614) | ||
| 10369 | 10369 | 83563 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 422 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769753 | 6002333.8721199995 | 2090986.9240400002 | 37.721584152666104 | -122.434011205875 | (37.7215841526661, -122.434011205875) | |
| 10468 | 10468 | 27000 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1236 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6008836.56983 | 2094066.26048 | 37.7304062528391 | -122.411750521985 | (37.7304062528391, -122.411750521985) | ||
| 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) |
| 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) | ||
| 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) | |
| 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) | ||
| 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) |
| 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) | |
| 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) |
| 31123 | 31123 | 88188 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43-25 Dore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51193 | 6008699.51281 | 2110034.52168 | 37.7742438193359 | -122.413353170509 | (37.7742438193359, -122.413353170509) | |
| 31529 | 31529 | 52954 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.1163299999 | 37.7224704120511 | -122.43945112037399 | (37.7224704120511, -122.439451120374) | |
| 33050 | 33050 | 95911 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1845 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767612 | 5989071.1412 | 2105102.6181 | 37.7595805696676 | -122.480889318141 | (37.7595805696676, -122.480889318141) |
| 33778 | 33778 | 52557 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1671 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 5 | Permit Number 48653 | 5984052.4061 | 2103791.5706 | 37.7556877987927 | -122.498149511058 | (37.7556877987927, -122.498149511058) | |
| 34436 | 34436 | 88394 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 139 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.78679857243979 | -122.485322676521 | (37.7867985724398, -122.485322676521) | ||
| 34687 | 34687 | 88066 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012463.39117 | 2096075.79817 | 37.736126817888 | -122.399353026719 | (37.736126817888, -122.399353026719) | |
| 35363 | 35363 | 98849 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 2 | 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) | |
| 36288 | 36288 | 31158 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 600 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2001 12:00:00 AM | 1 | Permit Number 34860 | 5993522.80361 | 2089878.90243 | 37.71803781197371 | -122.464388049089 | (37.7180378119737, -122.464388049089) | |
| 36879 | 36879 | 69182 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1371 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50160 | 5982122.5039 | 2105769.199 | 37.7610044592096 | -122.50497015556499 | (37.7610044592096, -122.504970155565) | |
| 38736 | 38736 | 100491 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3978 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770312 | 5995766.62837 | 2114872.73446 | 37.786793659691895 | -122.45844035359801 | (37.7867936596919, -122.458440353598) | |
| 39062 | 39062 | 88481 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014818.59944 | 2096228.0421 | 37.7366758342199 | -122.391220684988 | (37.7366758342199, -122.391220684988) | |
| 39095 | 39095 | 84344 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 581 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49738 | 5987802.4392099995 | 2112041.1140799997 | 37.778557929673205 | -122.485786324881 | (37.7785579296732, -122.485786324881) | |
| 40793 | 40793 | 78252 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 541 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776648 | 6003018.571219999 | 2090471.0211200002 | 37.7202064317688 | -122.43160757344299 | (37.7202064317688, -122.431607573443) | |
| 41516 | 41516 | 46433 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011103.47209 | 2089684.5822599998 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | |
| 41560 | 41560 | 41808 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999945.6987 | 2112165.7027 | 37.7796001259133 | -122.44378724216601 | (37.7796001259133, -122.443787242166) | |
| 41903 | 41903 | 73594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.787580529660794 | -122.41454729843399 | (37.7875805296608, -122.414547298434) | |
| 42969 | 42969 | 95722 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 43685 | 43685 | 46431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2002 12:00:00 AM | 1 | Permit Number 44652 | 6011089.42189 | 2089718.35805 | 37.7185939356546 | -122.40365624942899 | (37.7185939356546, -122.403656249429) | ||
| 44865 | 44865 | 46434 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | |
| 45203 | 45203 | 83910 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1515 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50152 | 5982467.7611 | 2104767.4351 | 37.7582742066085 | -122.50370189101801 | (37.7582742066085, -122.503701891018) |
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");