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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150199 | 150199 | 88615 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 521 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51567 | 5994972.63478 | 2111950.42136 | 37.7787241118896 | -122.46097548106701 | (37.7787241118896, -122.460975481067) | |
| 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) | |
| 151310 | 151310 | 64568 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1888 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51776 | 6000584.4368 | 2111720.2430000002 | 37.7784134187795 | -122.441545602938 | (37.7784134187795, -122.441545602938) | |
| 86531 | 86531 | 54968 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 526 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2015 12:00:00 AM | 3 | Permit Number 775624 | 5993160.60664 | 2111866.07895 | 37.7783880954675 | -122.46723780492201 | (37.7783880954675, -122.467237804922) | ||
| 126920 | 126920 | 41825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2511 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | Permit Number 42211 | 5998436.39026341 | 2111725.32035622 | 37.77830474661771 | -122.44897683474 | (37.7783047466177, -122.44897683474) | |||
| 108159 | 108159 | 41826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2517 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | Permit Number 42212 | 5998421.57666404 | 2111723.27260806 | 37.7782982768263 | -122.449027932684 | (37.7782982768263, -122.449027932684) | |||
| 154400 | 154400 | 141717 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2545 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998369.6346 | 2111707.5824 | 37.778252224784005 | -122.44920648801201 | (37.778252224784, -122.449206488012) | |||
| 174137 | 174137 | 84659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5996845.0781 | 2111686.6666 | 37.7781074773999 | -122.45447894833201 | (37.7781074773999, -122.454478948332) | |||
| 89138 | 89138 | 88206 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51211 | 5996832.5 | 2111680.5 | 37.7780898241501 | -122.45452201468201 | (37.7780898241501, -122.454522014682) | |||
| 187121 | 187121 | 58124 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 527 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1978 12:00:00 AM | 1 | Permit Number 17106 | 5991241.869630001 | 2111793.32926 | 37.778077396785 | -122.473870058582 | (37.778077396785, -122.473870058582) | ||
| 122015 | 122015 | 88207 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51211 | 5996848.1239 | 2111670.4224 | 37.7780630497691 | -122.454467238117 | (37.7780630497691, -122.454467238117) | |
| 179813 | 179813 | 137671 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | |||
| 61295 | 61295 | 42963 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 560 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42852 | 5981647.94996 | 2111905.75128 | 37.7778257173711 | -122.50706663602502 | (37.7778257173711, -122.507066636025) | ||
| 98532 | 98532 | 115939 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 607 34TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777685 | 5985316.0 | 2111712.0 | 37.7775090776113 | -122.49436347548901 | (37.7775090776113, -122.494363475489) | |
| 96405 | 96405 | 89539 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 5238 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982360.37978 | 2111711.22049 | 37.7773335253891 | -122.50458771883699 | (37.7773335253891, -122.504587718837) | ||
| 19267 | 19267 | 89545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 5328 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982088.22815 | 2111702.2127400003 | 37.7772927805161 | -122.505528495685 | (37.7772927805161, -122.505528495685) | ||
| 58875 | 58875 | 191246 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 22 Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009574.51886 | 2111002.08454 | 37.776949608681 | -122.41039468697599 | (37.776949608681, -122.410394686976) | |||
| 147620 | 147620 | 123462 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 620 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995351.08305 | 2111296.01241 | 37.776949048100796 | -122.459618879478 | (37.7769490481008, -122.459618879478) | |||
| 107556 | 107556 | 109136 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 635 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773405 | 5984096.474359999 | 2111505.41074 | 37.7768703987748 | -122.49856689090299 | (37.7768703987748, -122.498566890903) |
| 95133 | 95133 | 105013 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
| 96133 | 96133 | 105012 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
| 111186 | 111186 | 105014 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
| 43893 | 43893 | 117895 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 635 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5984097.32613 | 2111483.29523 | 37.7768097259285 | -122.498562310404 | (37.7768097259285, -122.498562310404) | |||
| 85971 | 85971 | 119072 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 635 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2016 12:00:00 AM | 3 | Width 4ft | Permit Number 778557 | 5981931.092119999 | 2111414.85236 | 37.776494524695295 | -122.50605075913401 | (37.7764945246953, -122.506050759134) | |
| 36328 | 36328 | 119240 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981455.34518 | 2111336.83463 | 37.776252294734 | -122.507690683983 | (37.776252294734, -122.507690683983) | |||
| 48201 | 48201 | 119241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.50776079209999 | (37.776245435782, -122.5077607921) | |||
| 68212 | 68212 | 119242 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981417.66127 | 2111333.86508 | 37.7762419210818 | -122.507820820241 | (37.7762419210818, -122.507820820241) | |||
| 158101 | 158101 | 119243 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981398.37029 | 2111333.4256599997 | 37.7762395779827 | -122.507887519226 | (37.7762395779827, -122.507887519226) | |||
| 107504 | 107504 | 90238 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2900X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986478.45159 | 2111179.35168 | 37.7761145368708 | -122.49030303077299 | (37.7761145368708, -122.490303030773) | ||
| 81686 | 81686 | 90243 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2900X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2015 07:19:00 AM | 3 | 3x3 | 5986256.13943 | 2111172.66934 | 37.7760832028982 | -122.491071565578 | (37.7760832028982, -122.491071565578) | ||
| 104102 | 104102 | 90248 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3040 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986089.18026 | 2111167.85377 | 37.7760602246469 | -122.491648759198 | (37.7760602246469, -122.491648759198) | ||
| 59456 | 59456 | 106431 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 747 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008848.75367 | 2110684.34026 | 37.7760364460542 | -122.412882870049 | (37.7760364460542, -122.412882870049) | |||
| 56157 | 56157 | 95935 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767632 | 5987262.82019 | 2111075.2653 | 37.7758745231149 | -122.48758207690001 | (37.7758745231149, -122.4875820769) |
| 124146 | 124146 | 83176 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3301 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 6 | 3x3 | 5985317.61354 | 2111082.30707 | 37.77578021552279 | -122.494311467187 | (37.7757802155228, -122.494311467187) | |
| 3788 | 3788 | 118108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3585 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 5984519.42575 | 2111051.46948 | 37.7756488017479 | -122.497070281467 | (37.7756488017479, -122.497070281467) | ||
| 102031 | 102031 | 90939 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4144 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982653.54392 | 2111040.34267 | 37.7755087308719 | -122.50352389434201 | (37.7755087308719, -122.503523894342) | ||
| 125110 | 125110 | 90275 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4300X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982191.02218 | 2111027.01163 | 37.775444924896 | -122.50512285244801 | (37.775444924896, -122.505122852448) | ||
| 84962 | 84962 | 90278 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4332 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982097.18566 | 2111025.0008400003 | 37.7754338822902 | -122.50544730055 | (37.7754338822902, -122.50544730055) | ||
| 92563 | 92563 | 90277 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4326 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982116.47387 | 2111024.58745 | 37.7754338822795 | -122.505380548569 | (37.7754338822795, -122.505380548569) | ||
| 92744 | 92744 | 90280 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4344 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982056.98615 | 2111023.40443 | 37.775427133307204 | -122.505586239401 | (37.7754271333072, -122.505586239401) | ||
| 104405 | 104405 | 90971 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4101 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982789.9497 | 2110989.59501 | 37.775377411022205 | -122.503048284011 | (37.7753774110222, -122.503048284011) | ||
| 96869 | 96869 | 90309 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4115 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982775.05183 | 2110989.27027 | 37.7753756437209 | -122.503099794321 | (37.7753756437209, -122.503099794321) | ||
| 118655 | 118655 | 90283 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981566.01243 | 2111001.7560900003 | 37.7753387866897 | -122.507282997083 | (37.7753387866897, -122.507282997083) | ||
| 90243 | 90243 | 90305 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4201X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982481.013259999 | 2110978.58794 | 37.775329025693104 | -122.504116133843 | (37.7753290256931, -122.504116133843) | ||
| 114363 | 114363 | 90966 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4245 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982369.3768 | 2110976.86332 | 37.775317724630604 | -122.50450217585501 | (37.7753177246306, -122.504502175855) | ||
| 54143 | 54143 | 88190 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1118 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631.0 | 2110372.0 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | |||
| 179306 | 179306 | 95828 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 174 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767563 | 6010564.55165 | 2110346.83579 | 37.775205897855 | -122.40692364921301 | (37.775205897855, -122.406923649213) |
| 132512 | 132512 | 68546 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 707 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 767769 | 5982568.02637 | 2110928.64305 | 37.775197008277296 | -122.503811440592 | (37.7751970082773, -122.503811440592) |
| 133327 | 133327 | 43975 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2000 12:00:00 AM | 2 | Permit Number 43537 | 5981491.7088 | 2110943.54345 | 37.7751745750496 | -122.50753570575 | (37.7751745750496, -122.50753570575) | ||
| 165309 | 165309 | 118692 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4549 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5981428.283009999 | 2110941.30275 | 37.7751646862289 | -122.507754939589 | (37.7751646862289, -122.507754939589) | |||
| 74076 | 74076 | 120009 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5986962.570590001 | 2110820.51914 | 37.775157546008 | -122.48860197556101 | (37.775157546008, -122.488601975561) | |||
| 162744 | 162744 | 37654 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1108 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51611 | 5992123.06102 | 2110701.1817099997 | 37.775129656063 | -122.47074215707899 | (37.775129656063, -122.470742157079) | |
| 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) |
| 166221 | 166221 | 120804 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 689 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989715.19561 | 2110680.27165 | 37.774932704327 | -122.47906987573299 | (37.774932704327, -122.479069875733) | |||
| 56440 | 56440 | 117883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5982620.39521 | 2110769.29715 | 37.7747625699566 | -122.503618485147 | (37.7747625699566, -122.503618485147) | |||
| 162634 | 162634 | 95938 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 770 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767634 | 5986967.37973 | 2110670.26469 | 37.774745270265605 | -122.48857429400101 | (37.7747452702656, -122.488574294001) |
| 177664 | 177664 | 118188 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 762 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985415.78787 | 2110692.34221 | 37.7747152280145 | -122.49394311659901 | (37.7747152280145, -122.493943116599) | |||
| 56847 | 56847 | 71337 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 4 | 5982620.59121 | 2110750.54443 | 37.7747110919712 | -122.503616418137 | (37.7747110919712, -122.503616418137) | ||
| 95419 | 95419 | 117055 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 762 34th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2016 12:00:00 AM | 3 | Permit Number 778404 | 5985439.6 | 2110687.7 | 37.7747038750392 | -122.49386040463101 | (37.7747038750392, -122.493860404631) | |||
| 70932 | 70932 | 119542 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 791 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986618.95807 | 2110548.82595 | 37.7743914964818 | -122.48977060648899 | (37.7743914964818, -122.489770606489) | |||
| 151807 | 151807 | 64570 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1624 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51014 | 6000044.7870000005 | 2110256.6597 | 37.7743640319269 | -122.44330729771099 | (37.7743640319269, -122.443307297711) | |
| 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) | |
| 136775 | 136775 | 88187 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51193 | 6008740.44285 | 2109989.37217 | 37.774122147347796 | -122.413208392271 | (37.7741221473478, -122.413208392271) | |
| 110202 | 110202 | 84332 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51851 | 5986981.94009984 | 2110441.32651783 | 37.7741175201244 | -122.488507097746 | (37.7741175201244, -122.488507097746) | ||
| 159581 | 159581 | 52456 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 757 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2013 12:00:00 AM | 1 | Permit Number 770898 | 5992550.20906 | 2110320.92766 | 37.774110273254706 | -122.46923688790599 | (37.7741102732547, -122.469236887906) | |
| 153309 | 153309 | 88186 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51193 | 6008751.52799 | 2109978.60624 | 37.774093208961204 | -122.41316928526001 | (37.7740932089612, -122.41316928526) | |
| 130069 | 130069 | 84554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 4 | 5986976.65331 | 2110412.96099 | 37.7740393278808 | -122.488523300237 | (37.7740393278808, -122.488523300237) | ||
| 79452 | 79452 | 54871 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778523 | 6005357.45103895 | 2109955.71553685 | 37.773839229349704 | -122.424908369576 | (37.7738392293497, -122.424908369576) | |
| 164734 | 164734 | 120000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 818 30th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5986676.70436 | 2110336.5469299997 | 37.7738120096448 | -122.489555240793 | (37.7738120096448, -122.489555240793) | |||
| 144924 | 144924 | 114895 | Private 5 | Lagunaria patersonii :: Primrose Tree 48 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | |||
| 117673 | 117673 | 140302 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997780.8586 | 2110053.3207 | 37.773676357183 | -122.45112394331899 | (37.773676357183, -122.451123943319) | |||
| 120493 | 120493 | 90705 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4320 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982162.77985 | 2110342.56704 | 37.773563978190495 | -122.505169810987 | (37.7735639781905, -122.505169810987) | ||
| 72208 | 72208 | 90706 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4332 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982115.667719999 | 2110342.56784 | 37.773561208242704 | -122.505332776144 | (37.7735612082427, -122.505332776144) | ||
| 47267 | 47267 | 47826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4350 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 2 | Permit Number 45588 | 5982100.44481 | 2110341.3807200002 | 37.773557052971704 | -122.50538534555099 | (37.7735570529717, -122.505385345551) | |
| 75601 | 75601 | 47840 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4400 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 4 | Permit Number 45601 | 5981916.04684 | 2110333.3944099997 | 37.7735242722092 | -122.506022602317 | (37.7735242722092, -122.506022602317) | |
| 89101 | 89101 | 90714 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981557.47501 | 2110321.74662 | 37.7734711772765 | -122.50726206903 | (37.7734711772765, -122.50726206903) | ||
| 88283 | 88283 | 90713 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4512 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981576.37852 | 2110321.34111 | 37.773471177271105 | -122.507196650108 | (37.7734711772711, -122.507196650108) | ||
| 85355 | 85355 | 90715 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4530 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981529.23414 | 2110319.83024 | 37.773464252019004 | -122.507359614365 | (37.773464252019, -122.507359614365) | ||
| 116902 | 116902 | 90719 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4616 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981255.7970900005 | 2110310.22456 | 37.7734217675099 | -122.50830474267099 | (37.7734217675099, -122.508304742671) | ||
| 91576 | 91576 | 90720 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4634 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981186.20352 | 2110308.00833 | 37.7734115809285 | -122.508545307898 | (37.7734115809285, -122.508545307898) | ||
| 187437 | 187437 | 119231 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4327 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5982159.48772 | 2110285.61161 | 37.7734074014784 | -122.505176976845 | (37.7734074014784, -122.505176976845) | |||
| 144716 | 144716 | 90746 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4345 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982095.14058 | 2110285.66939 | 37.7734037737787 | -122.50539956320499 | (37.7734037737787, -122.505399563205) | ||
| 160731 | 160731 | 140699 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 224 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998816.4363 | 2109919.7991 | 37.773368976906205 | -122.447532121663 | (37.7733689769062, -122.447532121663) | |||
| 98955 | 98955 | 90723 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4750X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980837.13634 | 2110295.92473 | 37.773357823394605 | -122.50975186123199 | (37.7733578233946, -122.509751861232) | ||
| 115634 | 115634 | 90743 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4429 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981841.9267 | 2110274.36208 | 37.773357823390896 | -122.50627461209801 | (37.7733578233909, -122.506274612098) | ||
| 140064 | 140064 | 90742 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4435 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981815.15401 | 2110273.6149 | 37.773354195669704 | -122.506367165545 | (37.7733541956697, -122.506367165545) | ||
| 142042 | 142042 | 90740 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4451X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981760.6962 | 2110270.81896 | 37.77334331252779 | -122.506555332031 | (37.7733433125278, -122.506555332031) | ||
| 126331 | 126331 | 90735 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4519 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981584.56948 | 2110265.78848 | 37.7733191284439 | -122.507164194881 | (37.7733191284439, -122.507164194881) | ||
| 87024 | 87024 | 90734 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4519 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981558.45056 | 2110264.5871200003 | 37.773314291486294 | -122.507254453094 | (37.7733142914863, -122.507254453094) | ||
| 77789 | 77789 | 88712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51654 | 6004166.0 | 2109783.0 | 37.773297624540895 | -122.429017475211 | (37.7732976245409, -122.429017475211) | ||
| 34972 | 34972 | 244513 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 500 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004128.882 | 2109777.8057 | 37.7732812611379 | -122.429145501014 | (37.7732812611379, -122.429145501014) | |||
| 48320 | 48320 | 140696 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 162 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997358.0622 | 2109907.9029 | 37.7732528619693 | -122.452575957146 | (37.7732528619693, -122.452575957146) | |||
| 80905 | 80905 | 90725 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4701X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980935.002069999 | 2110229.7439200003 | 37.773181881349004 | -122.509408420019 | (37.773181881349, -122.509408420019) | ||
| 131222 | 131222 | 247385 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 355 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002203.8017 | 2109776.7723 | 37.7731692596784 | -122.435804531936 | (37.7731692596784, -122.435804531936) | |||
| 174335 | 174335 | 48448 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 238 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2002 12:00:00 AM | 7 | Permit Number 45820 | 5997868.1487 | 2109737.2703 | 37.7728135614974 | -122.45079920226999 | (37.7728135614974, -122.45079920227) | ||
| 157288 | 157288 | 227587 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 77 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006751.41341 | 2109490.52204 | 37.7726405574578 | -122.42005339854201 | (37.7726405574578, -122.420053398542) | |||
| 113043 | 113043 | 115237 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.772367765473795 | -122.502584200594 | (37.7723677654738, -122.502584200594) | |||
| 175819 | 175819 | 117934 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982916.92515 | 2109877.9656700003 | 37.7723326617078 | -122.502526759002 | (37.7723326617078, -122.502526759002) | |||
| 113001 | 113001 | 115239 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775147 | 5981970.6 | 2109880.3 | 37.7722834181785 | -122.505800301349 | (37.7722834181785, -122.505800301349) | |||
| 47498 | 47498 | 119083 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) |
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");