Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 2004 | 2004 | 836 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396X 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:52:00 AM | 3 | 3X3 | 5981241.3128 | 2105622.3145 | 37.7605492737866 | -122.50800685617901 | (37.7605492737866, -122.508006856179) | ||
| 13263 | 13263 | 835 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396X 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:55:00 AM | 3 | 3X3 | 5981242.3727 | 2105595.8151 | 37.7604765764936 | -122.5080012238 | (37.7604765764936, -122.5080012238) | ||
| 84495 | 84495 | 840 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2015 01:14:00 PM | 3 | 3x3 | 5981250.420684201 | 2105445.3666042998 | 37.7600639622975 | -122.507962224252 | (37.7600639622975, -122.507962224252) | ||
| 113212 | 113212 | 11603 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4245 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 05:31:00 PM | 3 | 3X3 | 5981392.296520599 | 2105523.6051476 | 37.7602871413722 | -122.507477357537 | (37.7602871413722, -122.507477357537) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 128406 | 128406 | 109744 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4307 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772150 | 5981459.9 | 2104819.9 | 37.758358950394395 | -122.507191346523 | (37.7583589503944, -122.507191346523) |
| 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) | ||
| 150 | 150 | 11606 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.76045094714279 | -122.507135818078 | (37.7604509471428, -122.507135818078) | ||
| 152 | 152 | 24532 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1395 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:21:00 PM | 3 | 3X3 | 5981507.2257 | 2105680.0147 | 37.7607233666377 | -122.50709148147499 | (37.7607233666377, -122.507091481475) | ||
| 141 | 141 | 832 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:18:00 PM | 3 | 3X3 | 5981551.7086 | 2105613.8347 | 37.7605442750604 | -122.50693272862101 | (37.7605442750604, -122.506932728621) | ||
| 162586 | 162586 | 183640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1484 47th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981572.1323 | 2104991.2828 | 37.7588361283195 | -122.506815916291 | (37.7588361283195, -122.506815916291) | |||
| 11460 | 11460 | 11602 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4150 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/2011 12:00:00 AM | 3 | 3X3 | 5981591.6344 | 2105586.8054 | 37.7604724115264 | -122.506792641078 | (37.7604724115264, -122.506792641078) | ||
| 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) | ||
| 144 | 144 | 11598 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.760483446414796 | -122.506543543521 | (37.7604834464148, -122.506543543521) | ||
| 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) | ||
| 156 | 156 | 54712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:58:00 AM | 3 | 3x3 | Permit Number 10547 | 5981730.2931 | 2106265.9364 | 37.762345274891 | -122.506363455406 | (37.762345274891, -122.506363455406) | |
| 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) | ||
| 166285 | 166285 | 251003 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 Point Lobos Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5981957.64195 | 2112675.6435700003 | 37.7799578490271 | -122.506052420011 | (37.7799578490271, -122.506052420011) | |||
| 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) | |
| 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) | |||
| 38391 | 38391 | 251001 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 232 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5982033.34511 | 2112665.09757 | 37.7799333487875 | -122.505789751407 | (37.7799333487875, -122.505789751407) | |||
| 48322 | 48322 | 251000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 226 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5982074.747269999 | 2112660.45291 | 37.7799230326473 | -122.505646180935 | (37.7799230326473, -122.505646180935) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 85269 | 85269 | 11589 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4050X Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2016 11:29:00 AM | 3 | 3X3 | 5981992.356728501 | 2105594.1635633 | 37.760516204039604 | -122.50540729614599 | (37.7605162040396, -122.505407296146) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 119389 | 119389 | 24747 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 200X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/1999 12:00:00 AM | 3 | 3X3 | 5982215.35166 | 2112638.47493 | 37.779870961567894 | -122.505158146759 | (37.7798709615679, -122.505158146759) | ||
| 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) | ||
| 165 | 165 | 11582 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4000 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:49:00 AM | 3 | 3X3 | 5982109.291 | 2105604.0369 | 37.760550193841404 | -122.505003612665 | (37.7605501938414, -122.505003612665) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 87607 | 87607 | 11573 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2015 07:56:00 AM | 3 | 3X3 | 5982438.0 | 2105598.0 | 37.7605529521075 | -122.50386633030199 | (37.7605529521075, -122.503866330302) | ||
| 115109 | 115109 | 87558 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3906 Judah St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 05:19:00 PM | 3 | 5982438.0 | 2105598.0 | 37.7605529521075 | -122.50386633030199 | (37.7605529521075, -122.503866330302) | |||
| 122641 | 122641 | 98557 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/07/2012 12:00:00 AM | 3 | 5982438.0 | 2105598.0 | 37.7605529521075 | -122.50386633030199 | (37.7605529521075, -122.503866330302) | |||
| 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) | ||
| 80627 | 80627 | 24740 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/07/2012 12:00:00 AM | 3 | 3X3 | 5982774.3423 | 2112574.7084 | 37.779728751764104 | -122.503219660118 | (37.7797287517641, -122.503219660118) | ||
| 119386 | 119386 | 24739 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2004 12:00:00 AM | 3 | 3X3 | 5982782.27657 | 2112574.64249 | 37.7797290371816 | -122.503192207591 | (37.7797290371816, -122.503192207591) | ||
| 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) | ||
| 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) | ||
| 78895 | 78895 | 81730 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2346 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774950 | 5982707.54204511 | 2099147.52139682 | 37.7428575871403 | -122.502456702486 | (37.7428575871403, -122.502456702486) | |
| 1430 | 1430 | 183687 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 33196 | 5983043.3769 | 2106010.2341 | 37.7617204082059 | -122.50180314292801 | (37.7617204082059, -122.501803142928) | |
| 1417 | 1417 | 183690 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983045.4855 | 2105953.0685 | 37.7615635715471 | -122.50179162058001 | (37.7615635715471, -122.50179162058) | ||
| 1428 | 1428 | 183691 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.4226 | 2105931.5142 | 37.76150444459871 | -122.50178678479799 | (37.7615044445987, -122.501786784798) | ||
| 1386 | 1386 | 183693 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | ||
| 1390 | 1390 | 183692 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | ||
| 1404 | 1404 | 183694 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983048.5312 | 2105875.9885 | 37.7613521106328 | -122.501775383852 | (37.7613521106328, -122.501775383852) | ||
| 1408 | 1408 | 183696 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983051.3079 | 2105837.6039 | 37.7612468805065 | -122.50176294055599 | (37.7612468805065, -122.501762940556) | ||
| 1419 | 1419 | 183699 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983053.3747 | 2105791.1008 | 37.761119317578505 | -122.501752351825 | (37.7611193175785, -122.501752351825) | ||
| 147 | 147 | 58021 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971656999 | (37.7625717348083, -122.50121971657) | ||
| 95544 | 95544 | 58020 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4020 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2016 11:16:00 AM | 3 | Permit Number 16987 | 5983299.23983496 | 2106318.86318391 | 37.7625828423592 | -122.500941055889 | (37.7625828423592, -122.500941055889) | ||
| 124642 | 124642 | 109265 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1970 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773567 | 5983260.0 | 2101732.7 | 37.7499882212347 | -122.50073761576701 | (37.7499882212347, -122.500737615767) |
| 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) | |
| 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) |
| 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) | |
| 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) | |
| 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) | |
| 153529 | 153529 | 183672 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | |||
| 122176 | 122176 | 109275 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) |
| 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) | ||
| 70054 | 70054 | 184494 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | |||
| 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) | |
| 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) | |
| 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) | |||
| 152382 | 152382 | 250789 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 285 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5985873.63674 | 2113998.18517 | 37.7838189038641 | -122.492602865457 | (37.7838189038641, -122.492602865457) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 12809 | 12809 | 93466 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1649 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:27:00 PM | 3 | 3x3 | 5988055.4179 | 2098939.1633 | 37.7425982798609 | -122.483950196784 | (37.7425982798609, -122.483950196784) | ||
| 11177 | 11177 | 93407 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1414 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/2015 11:09:00 AM | 3 | 3x3 | 5988810.4689 | 2099030.2661 | 37.74289235198079 | -122.48134615155399 | (37.7428923519808, -122.481346151554) | ||
| 10385 | 10385 | 93406 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1408 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/2015 11:15:00 AM | 3 | 3x3 | 5988828.0589 | 2099030.2661 | 37.7428933746541 | -122.48128533094 | (37.7428933746541, -122.48128533094) | ||
| 152533 | 152533 | 51411 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1578 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51340 | 5989038.1128 | 2104597.9638 | 37.7581930050331 | -122.48096659569299 | (37.7581930050331, -122.480966595693) | |
| 179 | 179 | 182083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:33:00 PM | 3 | Width 0ft | 5989775.2775 | 2098997.3719 | 37.742858080169505 | -122.47800774412599 | (37.7428580801695, -122.478007744126) | ||
| 35773 | 35773 | 121884 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 18th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5990230.5783400005 | 2114834.8193200002 | 37.78636985483121 | -122.477590808601 | (37.7863698548312, -122.477590808601) | |||
| 159 | 159 | 97322 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1055 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:42:00 PM | 3 | 3x3 | 5989910.3078 | 2099001.0945 | 37.7428761380219 | -122.477541124233 | (37.7428761380219, -122.477541124233) | ||
| 146 | 146 | 97319 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1038 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:52:00 PM | 3 | 3x3 | 5989945.5882 | 2099070.048 | 37.7430675136338 | -122.477424174253 | (37.7430675136338, -122.477424174253) | ||
| 330 | 330 | 114206 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1030 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2016 01:19:00 PM | 3 | 3x3 | 5989968.0933 | 2099069.2019 | 37.7430664963024 | -122.477346296714 | (37.7430664963024, -122.477346296714) | ||
| 164 | 164 | 97323 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1011 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:25:00 PM | 3 | 3x3 | 5990005.0659 | 2099005.494 | 37.7428937161431 | -122.477213802134 | (37.7428937161431, -122.477213802134) | ||
| 177 | 177 | 97317 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:59:00 PM | 3 | 3x3 | 5990071.4812 | 2099073.5168 | 37.7430843422325 | -122.476989128346 | (37.7430843422325, -122.476989128346) | ||
| 48842 | 48842 | 207037 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2642 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990833.84583 | 2097410.6031 | 37.738562605571104 | -122.47423178898501 | (37.7385626055711, -122.474231788985) | |||
| 77857 | 77857 | 84000 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 440X Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 771053 | 5991504.89622125 | 2099785.75892313 | 37.7451230278663 | -122.47208471659799 | (37.7451230278663, -122.472084716598) | |
| 134651 | 134651 | 207001 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 404 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991538.30054 | 2099790.96979 | 37.7451392685705 | -122.47196959112301 | (37.7451392685705, -122.471969591123) | |||
| 149356 | 149356 | 207000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 404 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991556.482030001 | 2099793.0654 | 37.7451460746357 | -122.471906875997 | (37.7451460746357, -122.471906875997) | |||
| 144399 | 144399 | 104731 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 440X Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.5479200003 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | |
| 145537 | 145537 | 104730 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 440X Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.5479200003 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | |
| 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) | |
| 146673 | 146673 | 207006 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992316.05801 | 2097825.5684599997 | 37.739787751096294 | -122.469137249186 | (37.7397877510963, -122.469137249186) |
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");