trees
252 rows where qSpecies_id = 195 sorted by DBH
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10791 | 34213 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 137 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38029 | 6010403.59737914 | 2099053.11250995 | 37.7441868646564 | -122.406684360495 | (37.7441868646564, -122.406684360495) | 2 | 7 | 7 | 28859 | 2 | ||
| 11256 | 42750 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 12410 | 261246 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 17 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007045 | 2095545 | 37.7343658809731 | -122.418049036994 | (37.7343658809731, -122.418049036994) | 2 | 7 | 7 | 28859 | 2 | ||||
| 24863 | 32759 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 | ||
| 30154 | 41098 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.7416006455553 | -122.41705911631 | (37.7416006455553, -122.41705911631) | 2 | 7 | 7 | 28859 | 2 | |||
| 31208 | 41097 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.7416006455553 | -122.41705911631 | (37.7416006455553, -122.41705911631) | 2 | 7 | 7 | 28859 | 2 | ||
| 33201 | 45808 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 151 Charles St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44436 | 6004877.73984335 | 2097041.07807041 | 37.7383515558837 | -122.42564841052 | (37.7383515558837, -122.42564841052) | 2 | 7 | 5 | 63 | 7 | |||
| 36130 | 91470 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 40511 | 52377 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 8TA MARINA Gladeview Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2005 12:00:00 AM | Permit Number 48506 | 5997748.93752219 | 2101838.53853326 | 37.751118812629 | -122.450641986228 | (37.751118812629, -122.450641986228) | 1 | 5 | 4 | 63 | 38 | |||
| 44361 | 91472 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 49024 | 121763 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
| 49359 | 34810 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 101 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38445 | 5999074.40253363 | 2089202.20922089 | 37.7164982153246 | -122.445150028238 | (37.7164982153246, -122.445150028238) | 9 | 7 | 6 | 28861 | 25 | ||
| 51050 | 34215 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 123 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38031 | 6010471.85076762 | 2099030.12086895 | 37.7441275531286 | -122.40644673425 | (37.7441275531286, -122.40644673425) | 2 | 7 | 7 | 28859 | 2 | ||
| 51608 | 91481 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 53985 | 91478 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 56851 | 32527 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 6 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37029 | 6007006.64286664 | 2095736.82242552 | 37.7348904242515 | -122.418195245649 | (37.7348904242515, -122.418195245649) | 2 | 7 | 7 | 28859 | 2 | ||
| 63957 | 91477 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 68791 | 41099 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.7416006455553 | -122.41705911631 | (37.7416006455553, -122.41705911631) | 2 | 7 | 7 | 28859 | 2 | |||
| 71101 | 46711 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 1337 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44841 | 5996760.70858802 | 2106869.35577873 | 37.7648755513325 | -122.454422736012 | (37.7648755513325, -122.454422736012) | 15 | 5 | 11 | 29492 | 12 | ||
| 82959 | 84195 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 455 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2008 12:00:00 AM | 3x3 | Permit Number 50117 | 5999074.87038552 | 2094946.18270708 | 37.7322698626103 | -122.445561218581 | (37.7322698626103, -122.445561218581) | 9 | 7 | 4 | 59 | 40 | ||
| 83135 | 52379 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 8TA MARINA Gladeview Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2005 12:00:00 AM | Permit Number 48506 | 5997748.93752219 | 2101838.53853326 | 37.751118812629 | -122.450641986228 | (37.751118812629, -122.450641986228) | 1 | 5 | 4 | 63 | 38 | |||
| 85318 | 34306 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38094 | 6010824.33318422 | 2102458.44647529 | 37.7535606982702 | -122.405469321452 | (37.7535606982702, -122.405469321452) | 10 | 4 | 8 | 28859 | 19 | ||
| 86996 | 38002 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 2468 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40214 | 5992067.43945644 | 2098644.28132388 | 37.7420213596051 | -122.470056457736 | (37.7420213596051, -122.470056457736) | 1 | 8 | 4 | 29491 | 40 | ||
| 90186 | 34210 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38026 | 6010548.9850675 | 2099059.00866257 | 37.7442111875512 | -122.406182054391 | (37.7442111875512, -122.406182054391) | 2 | 7 | 7 | 28859 | 2 | ||
| 90758 | 63833 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 91 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24521 | 6009354.9233329 | 2096920.48394154 | 37.7382724026701 | -122.410159926388 | (37.7382724026701, -122.410159926388) | 10 | 7 | 7 | 28859 | 2 | ||
| 95116 | 42745 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 96188 | 33814 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 543 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37829 | 5988747.93564593 | 2111618.41829501 | 37.7774523741972 | -122.482484550136 | (37.7774523741972, -122.482484550136) | 11 | 6 | 2 | 55 | 26 | |||
| 97383 | 45564 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 3500 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | Permit Number 44308 | 5998062.56908828 | 2115523.19421657 | 37.788711325308 | -122.450543886298 | (37.788711325308, -122.450543886298) | 11 | 6 | 1 | 54 | 31 | ||
| 104716 | 251395 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2101 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012226 | 2101445 | 37.7508562677445 | -122.400550836744 | (37.7508562677445, -122.400550836744) | 10 | 3 | 8 | 28856 | 29 | |||||
| 108845 | 52378 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 8TA MARINA Gladeview Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2005 12:00:00 AM | Permit Number 48506 | 5997748.93752219 | 2101838.53853326 | 37.751118812629 | -122.450641986228 | (37.751118812629, -122.450641986228) | 1 | 5 | 4 | 63 | 38 | |||
| 111346 | 32757 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 | ||
| 112444 | 51444 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 336 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2004 12:00:00 AM | Permit Number 47763 | 6008602.30832967 | 2097174.95707039 | 37.7389289161491 | -122.412780092695 | (37.7389289161491, -122.412780092695) | 10 | 7 | 7 | 28859 | 2 | ||
| 116129 | 34214 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 135 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38030 | 6010413.34787543 | 2099049.82798569 | 37.7441783915997 | -122.406650413823 | (37.7441783915997, -122.406650413823) | 2 | 7 | 7 | 28859 | 2 | ||
| 116901 | 91479 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 117650 | 91480 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 117841 | 34211 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 132 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38027 | 6010446.19872622 | 2099093.63297516 | 37.7443005084973 | -122.406539908391 | (37.7443005084973, -122.406539908391) | 2 | 7 | 7 | 28859 | 2 | ||
| 118849 | 42746 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 119429 | 121764 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
| 126447 | 67504 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 477 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31033 | 5997603.60235184 | 2094078.4650037 | 37.729803210873 | -122.450585167202 | (37.729803210873, -122.450585167202) | 9 | 7 | 4 | 28861 | 40 | ||
| 127542 | 91474 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 132014 | 42748 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 132829 | 52142 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/2005 12:00:00 AM | Permit Number 48323 | 6005795.19032335 | 2097640.79736733 | 37.7400500494445 | -122.422518914141 | (37.7400500494445, -122.422518914141) | 2 | 7 | 7 | 28859 | 2 | ||
| 134751 | 121762 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
| 148638 | 45419 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 3690 Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | Permit Number 44217 | 5997130.30152423 | 2115717.50370466 | 37.7891914436893 | -122.453783416263 | (37.7891914436893, -122.453783416263) | 11 | 6 | 1 | 54 | 31 | |||
| 152219 | 42752 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 155490 | 32528 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 17 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37030 | 6007054.5480271 | 2095691.64868794 | 37.7347690834472 | -122.418026418979 | (37.7347690834472, -122.418026418979) | 2 | 7 | 7 | 28859 | 2 | ||
| 155813 | 34212 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 146 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38028 | 6010380.78922037 | 2099115.666634 | 37.7443573485467 | -122.406767634166 | (37.7443573485467, -122.406767634166) | 2 | 7 | 7 | 28859 | 2 | ||
| 156541 | 42751 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 160001 | 45418 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 3690 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | Permit Number 44217 | 5997130.30152423 | 2115717.50370466 | 37.7891914436893 | -122.453783416263 | (37.7891914436893, -122.453783416263) | 11 | 6 | 1 | 54 | 31 | |||
| 160820 | 256315 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006234 | 2121009 | 37.8042382772915 | -122.422661874451 | (37.8042382772915, -122.422661874451) | 5 | 9 | 1 | 28858 | 32 | ||||
| 162398 | 42048 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 214 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42365 | 6005128.75403076 | 2099926.75275442 | 37.746289143211 | -122.424985780451 | (37.746289143211, -122.424985780451) | 2 | 7 | 5 | 63 | 22 | |||
| 162782 | 42753 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 163805 | 33431 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 127 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37535 | 5999930.67607914 | 2095733.95298446 | 37.7344817167018 | -122.442659055518 | (37.7344817167018, -122.442659055518) | 9 | 7 | 4 | 63 | 40 | ||
| 168660 | 35259 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38745 | 6006261.16028369 | 2120974.78404058 | 37.8041458613164 | -122.422565451189 | (37.8041458613164, -122.422565451189) | 5 | 9 | 1 | 28858 | 32 | ||
| 173705 | 91475 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 174568 | 91473 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 183379 | 42747 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 183731 | 42749 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 184288 | 46131 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 137 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44481 | 5997450.10216271 | 2107762.76782376 | 37.7673681457069 | -122.452102777266 | (37.7673681457069, -122.452102777266) | 15 | 5 | 11 | 29492 | 9 | ||
| 184805 | 91471 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 185012 | 258221 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 6 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006999 | 2095654 | 37.73466258188 | -122.418215799693 | (37.73466258188, -122.418215799693) | 2 | 7 | 7 | 28859 | 2 | ||||
| 188770 | 42744 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
| 192687 | 33995 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38457 | 6010502.26399862 | 2099074.74698805 | 37.7442517881202 | -122.40634471521 | (37.7442517881202, -122.40634471521) | 2 | 7 | 7 | 28859 | 2 | ||
| 193080 | 32758 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 | ||
| 193244 | 91476 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 193423 | 108885 | Private 9 | Cupaniopsis anacardioides :: Carrotwood 195 | 707 NOE ST | 5 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003152.4 | 2104071.5 | 37.7575578048507 | -122.432115704961 | (37.7575578048507, -122.432115704961) | 2 | 4 | 5 | 28862 | 3 | ||||
| 33144 | 190953 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 28 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6013222.07397 | 2116219.26645 | 37.7914785844106 | -122.398142697526 | (37.7914785844106, -122.398142697526) | 12 | 2 | 9 | 28855 | 6 | |||
| 47841 | 39518 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 3964 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 10 | Permit Number 40967 | 6004074 | 2101323 | 37.7500632777197 | -122.428732510654 | (37.7500632777197, -122.428732510654) | 2 | 4 | 5 | 28862 | 22 | |
| 57218 | 248032 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 123 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010451.01277 | 2099046.16811 | 37.7441704496095 | -122.40651991836 | (37.7441704496095, -122.40651991836) | 2 | 7 | 7 | 28859 | 2 | |||
| 80038 | 126407 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2610 Clay St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6001526.97686 | 2116002.32801 | 37.7902245832452 | -122.438591908114 | (37.7902245832452, -122.438591908114) | 13 | 6 | 1 | 29490 | 27 | |||
| 85414 | 223278 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 674 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002236.28563 | 2098883.15145 | 37.7432598482747 | -122.434912954272 | (37.7432598482747, -122.434912954272) | 2 | 7 | 5 | 63 | 22 | |||
| 98887 | 206801 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 258 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000353.90895 | 2094705.09032 | 37.7316808170083 | -122.441122012192 | (37.7316808170083, -122.441122012192) | 9 | 7 | 4 | 63 | 40 | |||
| 106454 | 223274 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 91 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009343.02898 | 2096929.97476 | 37.738297795694 | -122.410201721249 | (37.738297795694, -122.410201721249) | 10 | 7 | 7 | 28859 | 2 | |||
| 155057 | 248033 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010558.59528 | 2099039.59827 | 37.7441584283672 | -122.406147456957 | (37.7441584283672, -122.406147456957) | 2 | 7 | 7 | 28859 | 2 | |||
| 166095 | 223269 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010823.03156 | 2102440.75531 | 37.7535120494589 | -122.405472576922 | (37.7535120494589, -122.405472576922) | 10 | 4 | 8 | 28859 | 19 | |||
| 166680 | 14638 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 600X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 4x4 | 6006218.48413 | 2112159.25458 | 37.7799382114304 | -122.422086486016 | (37.7799382114304, -122.422086486016) | 7 | 9 | 11 | 28852 | 41 | |||
| 2741 | 202190 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1900 Armstrong Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6013173.69096 | 2093416.62895 | 37.7288648499236 | -122.396710853637 | (37.7288648499236, -122.396710853637) | 10 | 3 | 8 | 58 | 1 | ||||
| 4675 | 40136 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2760 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1999 12:00:00 AM | 11 | Permit Number 41340 | 6000331.47905 | 2117521.66329 | 37.7943282005485 | -122.442837375469 | (37.7943282005485, -122.442837375469) | 13 | 9 | 1 | 57 | 27 | ||
| 74452 | 202143 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1999 Armstrong Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012908.83816 | 2093533.00853 | 37.7291696598447 | -122.397634633656 | (37.7291696598447, -122.397634633656) | 10 | 3 | 8 | 58 | 1 | |||
| 115156 | 190954 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6015962.97968 | 2113739.68127 | 37.7848224915123 | -122.388485974355 | (37.7848224915123, -122.388485974355) | 6 | 2 | 9 | 28856 | 6 | |||
| 155793 | 223673 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003155.02499 | 2100979.47197 | 37.7490679767212 | -122.431885848858 | (37.7490679767212, -122.431885848858) | 2 | 4 | 5 | 28862 | 22 | |||
| 29487 | 16090 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 282 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000233.37509 | 2094706.46269 | 37.7316777188345 | -122.441538819154 | (37.7316777188345, -122.441538819154) | 9 | 7 | 4 | 63 | 40 | |||
| 33360 | 16066 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 236 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000441.13466 | 2094703.95832 | 37.7316826768166 | -122.440820375074 | (37.7316826768166, -122.440820375074) | 9 | 7 | 4 | 63 | 40 | |||
| 41463 | 223677 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002838.68018 | 2100959.36112 | 37.7489948186629 | -122.432978334495 | (37.7489948186629, -122.432978334495) | 2 | 4 | 5 | 28862 | 22 | |||
| 59485 | 16062 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 234 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000489.61078 | 2094702.95289 | 37.7316826768056 | -122.440652711764 | (37.7316826768056, -122.440652711764) | 9 | 7 | 4 | 63 | 40 | |||
| 62184 | 16082 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 271 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000311.38839 | 2094627.29606 | 37.7314647899717 | -122.441263434174 | (37.7314647899717, -122.441263434174) | 9 | 7 | 4 | 63 | 40 | |||
| 67252 | 16080 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 266 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000320.86003 | 2094706.9046 | 37.7316839160675 | -122.441236398737 | (37.7316839160675, -122.441236398737) | 9 | 7 | 4 | 63 | 40 | |||
| 74418 | 16081 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 270 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000295.71125 | 2094707.20068 | 37.7316832964356 | -122.441323364105 | (37.7316832964356, -122.441323364105) | 9 | 7 | 4 | 63 | 40 | |||
| 79403 | 206800 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 282 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000214.83756 | 2094708.65301 | 37.7316826767962 | -122.441603064049 | (37.7316826767962, -122.441603064049) | 9 | 7 | 4 | 63 | 40 | |||
| 80606 | 16063 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 235 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000510.81653 | 2094624.74104 | 37.7314691327784 | -122.440573791767 | (37.7314691327784, -122.440573791767) | 9 | 7 | 4 | 63 | 40 | |||
| 82061 | 16065 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 236 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000470.32804 | 2094701.99848 | 37.7316789581131 | -122.440719307449 | (37.7316789581131, -122.440719307449) | 9 | 7 | 4 | 63 | 40 | |||
| 84705 | 16057 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 223 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000584.1346 | 2094621.95536 | 37.7314656587147 | -122.440320118183 | (37.7314656587147, -122.440320118183) | 9 | 7 | 4 | 63 | 40 | |||
| 96872 | 126408 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2610 Clay St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6001492.92943 | 2115998.71456 | 37.7902127247824 | -122.438709450393 | (37.7902127247824, -122.438709450393) | 13 | 6 | 1 | 29490 | 27 | |||
| 116147 | 16072 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 258 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000364.9354737 | 2094709.7194476 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | 9 | 7 | 4 | 63 | 40 | |||
| 121035 | 16061 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 234 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000514.97584 | 2094701.72166 | 37.7316807405534 | -122.440564931622 | (37.7316807405534, -122.440564931622) | 9 | 7 | 4 | 63 | 40 | |||
| 125537 | 16086 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 279 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000243.09762 | 2094627.44767 | 37.7314613158742 | -122.441499538567 | (37.7314613158742, -122.441499538567) | 9 | 7 | 4 | 63 | 40 | |||
| 141393 | 16089 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 281 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000204.67262 | 2094627.92858 | 37.7314604471408 | -122.441632415216 | (37.7314604471408, -122.441632415216) | 9 | 7 | 4 | 63 | 40 | |||
| 141847 | 16064 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 239 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000482.86247 | 2094624.68801 | 37.7314673953084 | -122.440670430219 | (37.7314673953084, -122.440670430219) | 9 | 7 | 4 | 63 | 40 | |||
| 161978 | 16091 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 284 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000198.5480309 | 2094712.9146898 | 37.7316934502774 | -122.44165968578 | (37.7316934502774, -122.44165968578) | 9 | 7 | 4 | 63 | 40 | |||
| 164982 | 16070 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 251 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000403.76361 | 2094624.43092 | 37.731462184634 | -122.440943870862 | (37.731462184634, -122.440943870862) | 9 | 7 | 4 | 63 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );