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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81149 | 81149 | 91472 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 81595 | 81595 | 32527 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 6 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37029 | 6007006.64286664 | 2095736.82242552 | 37.734890424251496 | -122.41819524564899 | (37.7348904242515, -122.418195245649) | ||
| 83132 | 83132 | 34215 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 123 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38031 | 6010471.85076762 | 2099030.12086895 | 37.7441275531286 | -122.40644673425 | (37.7441275531286, -122.40644673425) | ||
| 84214 | 84214 | 121763 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 580 07th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011520.0 | 2109619.0 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | |||||
| 85599 | 85599 | 41099 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | |||
| 85815 | 85815 | 91477 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 86117 | 86117 | 46711 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1337 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44841 | 5996760.70858802 | 2106869.35577873 | 37.7648755513325 | -122.454422736012 | (37.7648755513325, -122.454422736012) | ||
| 91336 | 91336 | 34210 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38026 | 6010548.985067501 | 2099059.00866257 | 37.7442111875512 | -122.406182054391 | (37.7442111875512, -122.406182054391) | ||
| 91947 | 91947 | 63833 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 91 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24521 | 6009354.9233329 | 2096920.48394154 | 37.738272402670106 | -122.41015992638799 | (37.7382724026701, -122.410159926388) | ||
| 92629 | 92629 | 84195 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 455 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2008 12:00:00 AM | 3x3 | Permit Number 50117 | 5999074.87038552 | 2094946.18270708 | 37.732269862610295 | -122.445561218581 | (37.7322698626103, -122.445561218581) | ||
| 93015 | 93015 | 38002 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2468 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40214 | 5992067.43945644 | 2098644.28132388 | 37.742021359605104 | -122.47005645773599 | (37.7420213596051, -122.470056457736) | ||
| 94957 | 94957 | 42745 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 95276 | 95276 | 206793 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 106 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5995874.19015 | 2089646.87055 | 37.7175359677985 | -122.456243608772 | (37.7175359677985, -122.456243608772) | |||
| 95636 | 95636 | 34306 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38094 | 6010824.33318422 | 2102458.44647529 | 37.7535606982702 | -122.405469321452 | (37.7535606982702, -122.405469321452) | ||
| 96045 | 96045 | 52379 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 8TA MARINA Gladeview Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2005 12:00:00 AM | Permit Number 48506 | 5997748.93752219 | 2101838.53853326 | 37.751118812629 | -122.450641986228 | (37.751118812629, -122.450641986228) | |||
| 100833 | 100833 | 32757 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 101511 | 101511 | 51444 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 336 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2004 12:00:00 AM | Permit Number 47763 | 6008602.30832967 | 2097174.95707039 | 37.7389289161491 | -122.412780092695 | (37.7389289161491, -122.412780092695) | ||
| 101822 | 101822 | 110133 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2569x Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006170.473730001 | 2119650.67093 | 37.800505068104 | -122.42278512073901 | (37.800505068104, -122.422785120739) | |||
| 102765 | 102765 | 52378 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 8TA MARINA Gladeview Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2005 12:00:00 AM | Permit Number 48506 | 5997748.93752219 | 2101838.53853326 | 37.751118812629 | -122.450641986228 | (37.751118812629, -122.450641986228) | |||
| 103388 | 103388 | 45564 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3500 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | Permit Number 44308 | 5998062.56908828 | 2115523.19421657 | 37.788711325308 | -122.45054388629801 | (37.788711325308, -122.450543886298) | ||
| 103570 | 103570 | 33814 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 543 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37829 | 5988747.93564593 | 2111618.41829501 | 37.7774523741972 | -122.482484550136 | (37.7774523741972, -122.482484550136) | |||
| 104272 | 104272 | 42748 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 104865 | 104865 | 42746 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 105153 | 105153 | 91474 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 105225 | 105225 | 88672 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016937.47244 | 2102122.1356099998 | 37.7529771731841 | -122.384305125986 | (37.7529771731841, -122.384305125986) | |
| 105580 | 105580 | 121764 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 580 07th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011520.0 | 2109619.0 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | |||||
| 107600 | 107600 | 67504 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 477 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1992 12:00:00 AM | Permit Number 31033 | 5997603.60235184 | 2094078.4650036998 | 37.729803210873 | -122.450585167202 | (37.729803210873, -122.450585167202) | ||
| 107706 | 107706 | 16072 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 258 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
| 107956 | 107956 | 34211 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 132 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38027 | 6010446.19872622 | 2099093.63297516 | 37.7443005084973 | -122.406539908391 | (37.7443005084973, -122.406539908391) | ||
| 108363 | 108363 | 32760 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) |
| 108806 | 108806 | 91480 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 108856 | 108856 | 52142 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2005 12:00:00 AM | Permit Number 48323 | 6005795.19032335 | 2097640.79736733 | 37.7400500494445 | -122.42251891414101 | (37.7400500494445, -122.422518914141) | ||
| 109689 | 109689 | 91479 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 109736 | 109736 | 34214 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 135 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38030 | 6010413.34787543 | 2099049.82798569 | 37.744178391599704 | -122.40665041382299 | (37.7441783915997, -122.406650413823) | ||
| 114050 | 114050 | 45419 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3690 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | Permit Number 44217 | 5997130.30152423 | 2115717.50370466 | 37.7891914436893 | -122.45378341626301 | (37.7891914436893, -122.453783416263) | |||
| 114283 | 114283 | 33419 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 498X KENWOOD WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | 2 | Permit Number 37528 | 5993404.0 | 2093661.0 | 37.7284156834141 | -122.46507324106301 | (37.7284156834141, -122.465073241063) | |
| 115812 | 115812 | 176086 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 301 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011743.1903099995 | 2086704.18251 | 37.710354113216894 | -122.401184737092 | (37.7103541132169, -122.401184737092) | |||
| 116523 | 116523 | 121762 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 580 07th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011520.0 | 2109619.0 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | |||||
| 117521 | 117521 | 42753 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 117542 | 117542 | 45418 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3690 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | Permit Number 44217 | 5997130.30152423 | 2115717.50370466 | 37.7891914436893 | -122.45378341626301 | (37.7891914436893, -122.453783416263) | |||
| 117952 | 117952 | 35259 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38745 | 6006261.16028369 | 2120974.78404058 | 37.8041458613164 | -122.422565451189 | (37.8041458613164, -122.422565451189) | ||
| 118866 | 118866 | 32528 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 17 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37030 | 6007054.5480271 | 2095691.64868794 | 37.734769083447205 | -122.418026418979 | (37.7347690834472, -122.418026418979) | ||
| 120556 | 120556 | 42751 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 121590 | 121590 | 33418 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 498X KENWOOD WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | 2 | Permit Number 37528 | 5993404.0 | 2093661.0 | 37.7284156834141 | -122.46507324106301 | (37.7284156834141, -122.465073241063) | |
| 121918 | 121918 | 42752 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 122324 | 122324 | 42048 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 214 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42365 | 6005128.75403076 | 2099926.75275442 | 37.746289143211 | -122.424985780451 | (37.746289143211, -122.424985780451) | |||
| 122799 | 122799 | 34212 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 146 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38028 | 6010380.78922037 | 2099115.666634 | 37.74435734854671 | -122.40676763416599 | (37.7443573485467, -122.406767634166) | ||
| 122851 | 122851 | 33431 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 127 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37535 | 5999930.67607914 | 2095733.95298446 | 37.7344817167018 | -122.44265905551799 | (37.7344817167018, -122.442659055518) | ||
| 123033 | 123033 | 16091 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 284 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000198.548030901 | 2094712.9146897998 | 37.7316934502774 | -122.44165968578001 | (37.7316934502774, -122.44165968578) | |||
| 123346 | 123346 | 42750 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 123357 | 123357 | 34213 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 137 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38029 | 6010403.59737914 | 2099053.11250995 | 37.7441868646564 | -122.40668436049499 | (37.7441868646564, -122.406684360495) | ||
| 123965 | 123965 | 41097 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | ||
| 124807 | 124807 | 32759 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 125526 | 125526 | 41098 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | |||
| 126803 | 126803 | 45808 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 151 Charles St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2001 12:00:00 AM | Permit Number 44436 | 6004877.73984335 | 2097041.07807041 | 37.7383515558837 | -122.42564841052 | (37.7383515558837, -122.42564841052) | |||
| 128365 | 128365 | 39517 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3964 25TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40967 | 6004074.0 | 2101323.0 | 37.750063277719704 | -122.42873251065399 | (37.7500632777197, -122.428732510654) | |
| 129334 | 129334 | 91470 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 131603 | 131603 | 126404 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2501 Jackson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001524.31807 | 2116606.64238 | 37.7918837227069 | -122.438644426709 | (37.7918837227069, -122.438644426709) | |||
| 131951 | 131951 | 176083 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 120 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011939.3192 | 2086886.00886 | 37.7108643121037 | -122.40051963449899 | (37.7108643121037, -122.400519634499) | |||
| 134346 | 134346 | 223676 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 300 Clipper St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002874.24252 | 2100962.2133 | 37.749004667153 | -122.432855563559 | (37.749004667153, -122.432855563559) | |||
| 135109 | 135109 | 223274 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 91 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009343.02898 | 2096929.97476 | 37.738297795693995 | -122.41020172124901 | (37.738297795694, -122.410201721249) | |||
| 135159 | 135159 | 223673 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 300 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003155.02499 | 2100979.4719700003 | 37.7490679767212 | -122.43188584885799 | (37.7490679767212, -122.431885848858) | |||
| 135209 | 135209 | 202143 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1999 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6012908.83816 | 2093533.00853 | 37.7291696598447 | -122.39763463365601 | (37.7291696598447, -122.397634633656) | |||
| 135441 | 135441 | 36943 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 152 03rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39580 | 5994926.19435 | 2114520.7878400004 | 37.7857789756862 | -122.46132251465099 | (37.7857789756862, -122.461322514651) | |
| 135598 | 135598 | 88666 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016578.93003 | 2102100.6702900003 | 37.7528984024518 | -122.385543550016 | (37.7528984024518, -122.385543550016) | |
| 135878 | 135878 | 223668 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 10 Gladys St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005828.6404800005 | 2097671.05304 | 37.740135011734 | -122.42240540628299 | (37.740135011734, -122.422405406283) | |||
| 137005 | 137005 | 120451 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 5 West Clay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988873.724640001 | 2114983.29043 | 37.7866986830782 | -122.482296003521 | (37.7866986830782, -122.482296003521) | |||
| 138514 | 138514 | 100279 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 3460X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007182.0 | 2104415.0 | 37.7587286142457 | -122.41820403955799 | (37.7587286142457, -122.418204039558) | |||
| 140007 | 140007 | 100278 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 3460X 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007182.0 | 2104415.0 | 37.7587286142457 | -122.41820403955799 | (37.7587286142457, -122.418204039558) | |||
| 141044 | 141044 | 46131 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 137 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44481 | 5997450.10216271 | 2107762.76782376 | 37.7673681457069 | -122.452102777266 | (37.7673681457069, -122.452102777266) | ||
| 141049 | 141049 | 91471 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 141272 | 141272 | 91473 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 141602 | 141602 | 42744 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 144135 | 144135 | 42747 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 144300 | 144300 | 42749 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 144321 | 144321 | 91475 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 145175 | 145175 | 108885 | Private 5 | Cupaniopsis anacardioides :: Carrotwood 118 | 707 NOE ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6003152.4 | 2104071.5 | 37.757557804850705 | -122.43211570496099 | (37.7575578048507, -122.432115704961) | ||||
| 145322 | 145322 | 33995 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38457 | 6010502.26399862 | 2099074.74698805 | 37.7442517881202 | -122.40634471521003 | (37.7442517881202, -122.40634471521) | ||
| 145468 | 145468 | 32758 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 145817 | 145817 | 91476 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 146611 | 146611 | 206798 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 714 Detroit St | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 5999465.474230001 | 2095438.72707 | 37.7336445658277 | -122.444246198512 | (37.7336445658277, -122.444246198512) | ||||
| 147051 | 147051 | 223674 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 300 Clipper St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003026.25386 | 2100972.90795 | 37.7490426526966 | -122.432330671519 | (37.7490426526966, -122.432330671519) | |||
| 147774 | 147774 | 223681 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 300 Clipper St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002667.71298 | 2100952.64567 | 37.7489666806705 | -122.433569059575 | (37.7489666806705, -122.433569059575) | |||
| 148055 | 148055 | 202149 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1967 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6012987.61375 | 2093482.17002 | 37.7290344539678 | -122.39735873424101 | (37.7290344539678, -122.397358734241) | |||
| 150287 | 150287 | 176084 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 301 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011735.35451 | 2086672.5104200002 | 37.710266710803104 | -122.401209595273 | (37.7102667108031, -122.401209595273) | |||
| 151533 | 151533 | 126407 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2610 Clay St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6001526.97686 | 2116002.32801 | 37.7902245832452 | -122.43859190811399 | (37.7902245832452, -122.438591908114) | |||
| 151741 | 151741 | 176091 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 301 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011761.10909 | 2086779.81535 | 37.7105627856051 | -122.401128116692 | (37.7105627856051, -122.401128116692) | |||
| 152240 | 152240 | 202158 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1913 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6013140.94695 | 2093368.78005 | 37.7287316441256 | -122.39682069951701 | (37.7287316441256, -122.396820699517) | |||
| 154499 | 154499 | 88668 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51637 | 6016777.6314900005 | 2102112.60454 | 37.7529421634534 | -122.38485722789 | (37.7529421634534, -122.38485722789) | |
| 155140 | 155140 | 202207 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1968 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6013020.76239 | 2093529.61913 | 37.72916658504629 | -122.397247462005 | (37.7291665850463, -122.397247462005) | |||
| 155539 | 155539 | 190952 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 50 Southern Heights Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6012228.79731 | 2104083.07063 | 37.7580999894276 | -122.400726473151 | (37.7580999894276, -122.400726473151) | |||
| 156099 | 156099 | 88662 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51637 | 6016419.5289900005 | 2102093.1245 | 37.7528688624307 | -122.386094267831 | (37.7528688624307, -122.386094267831) | |
| 158662 | 158662 | 223670 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007488.19675 | 2098176.2850900004 | 37.7416157445795 | -122.416703102889 | (37.7416157445795, -122.416703102889) | |||
| 158962 | 158962 | 202201 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1948 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6013078.4423 | 2093486.02938 | 37.729050107561605 | -122.39704500125099 | (37.7290501075616, -122.397045001251) | |||
| 159166 | 159166 | 202148 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1973 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012979.956230001 | 2093488.41205 | 37.7290511669581 | -122.397385644629 | (37.7290511669581, -122.397385644629) | |||
| 161132 | 161132 | 202144 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1999 Armstrong Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6012917.46969 | 2093534.23595 | 37.7291735107263 | -122.39760487958598 | (37.7291735107263, -122.397604879586) | |||
| 161404 | 161404 | 36946 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 165 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39581 | 5994879.55101 | 2114458.4572900003 | 37.7856051482988 | -122.461479365875 | (37.7856051482988, -122.461479365875) | |
| 161512 | 161512 | 190957 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 580 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011496.47934 | 2109620.41486 | 37.773263416204294 | -122.403648760805 | (37.7732634162043, -122.403648760805) | |||
| 162671 | 162671 | 206797 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 415 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5992912.29675 | 2090464.70197 | 37.7196110652749 | -122.466540843488 | (37.7196110652749, -122.466540843488) | |||
| 163960 | 163960 | 248035 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 132 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6010441.24954 | 2099079.47689 | 37.744261362076294 | -122.40655602435899 | (37.7442613620763, -122.406556024359) |
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");