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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41498 | 41498 | 214201 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 145 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994272.70142 | 2095629.8656 | 37.733871759758394 | -122.462212852568 | (37.7338717597584, -122.462212852568) | |||
41692 | 41692 | 107848 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 407 09th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009766.34192 | 2109306.87193 | 37.7723057020722 | -122.40961143144101 | (37.7723057020722, -122.409611431441) | |||
42737 | 42737 | 239675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 689 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 9ft | 6005030.3991 | 2104342.90235 | 37.7584093076526 | -122.425640136401 | (37.7584093076526, -122.425640136401) | |||
42807 | 42807 | 43677 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 656 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 8 | Permit Number 43320 | 5995359.11762 | 2111077.33678 | 37.776349084718596 | -122.45957524379101 | (37.7763490847186, -122.459575243791) | |
42864 | 42864 | 197567 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011782.82118 | 2107497.01248 | 37.767449026680495 | -122.402508917767 | (37.7674490266805, -122.402508917767) | |||
42873 | 42873 | 46597 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 170St. 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/2004 12:00:00 AM | 11 | Permit Number 44725 | 5993070.73118 | 2114361.72785 | 37.7852352793736 | -122.46773026674101 | (37.7852352793736, -122.467730266741) | |
42918 | 42918 | 138403 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002027.5911 | 2114900.905 | 37.7872288234819 | -122.436780945176 | (37.7872288234819, -122.436780945176) | |||
43291 | 43291 | 197532 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6013605.01625 | 2103874.9640900004 | 37.757605236406995 | -122.39595229975299 | (37.757605236407, -122.395952299753) | ||||
43292 | 43292 | 113589 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6013618.317290001 | 2118086.59987 | 37.796627904610204 | -122.39690267003799 | (37.7966279046102, -122.396902670038) | |||
43437 | 43437 | 197539 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 33 Guy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014318.065 | 2114410.62146 | 37.7865734481466 | -122.394223875652 | (37.7865734481466, -122.394223875652) | |||
43559 | 43559 | 31153 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34856 | 5999668.77928 | 2093756.1386900002 | 37.729036168077705 | -122.443422496853 | (37.7290361680777, -122.443422496853) | |
44138 | 44138 | 239690 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1521 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003983.46456 | 2099388.15936 | 37.744745530090796 | -122.428907662057 | (37.7447455300908, -122.428907662057) | |||
44139 | 44139 | 200675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015661.7831 | 2095333.6223 | 37.7342666958117 | -122.388243005014 | (37.7342666958117, -122.388243005014) | |||
44389 | 44389 | 59288 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2067 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1980 12:00:00 AM | 17 | Permit Number 18625 | 6003010.51633 | 2119230.45541 | 37.7991724689015 | -122.433689789967 | (37.7991724689015, -122.433689789967) | ||
44413 | 44413 | 200830 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1550 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6011811.2987 | 2107032.5363 | 37.766175269536205 | -122.402377754798 | (37.7661752695362, -122.402377754798) | |||
44525 | 44525 | 21850 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5995144.904080001 | 2110755.8457 | 37.775454035467796 | -122.46029296446699 | (37.7754540354678, -122.460292964467) | |||
44607 | 44607 | 197563 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011871.68658 | 2107504.14213 | 37.767473563784996 | -122.40220204389799 | (37.767473563785, -122.402202043898) | |||
44660 | 44660 | 140664 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 536 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5996926.8557 | 2109499.2642 | 37.7721061302796 | -122.4540380318 | (37.7721061302796, -122.4540380318) | |||
44932 | 44932 | 179450 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006580.779159999 | 2087379.51909 | 37.7119190900695 | -122.41907501532499 | (37.7119190900695, -122.419075015325) | |||
45066 | 45066 | 70152 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 231 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 7 | 5993349.447480001 | 2113931.04039 | 37.78406881848979 | -122.46673468365299 | (37.7840688184898, -122.466734683653) | ||
45132 | 45132 | 179472 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 416 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003621.62429 | 2091003.33187 | 37.7217022030671 | -122.42956096376999 | (37.7217022030671, -122.42956096377) | |||
45178 | 45178 | 239695 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004807.135419999 | 2101616.24717 | 37.7509099321629 | -122.426218161243 | (37.7509099321629, -122.426218161243) | |||
45376 | 45376 | 32233 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1588 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 16 | Permit Number 35549 | 6008740.58515 | 2099494.1022900003 | 37.7453045396752 | -122.412465880499 | (37.7453045396752, -122.412465880499) | |
45696 | 45696 | 40608 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2756 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1999 12:00:00 AM | 12 | Permit Number 41618 | 5996415.12538 | 2111289.35266 | 37.7769918898751 | -122.45593757087 | (37.7769918898751, -122.45593757087) | ||
45807 | 45807 | 240555 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004136.97088 | 2102299.45232 | 37.752747951271 | -122.428584348611 | (37.752747951271, -122.428584348611) | |||
45870 | 45870 | 214171 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1337 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994229.270690001 | 2106420.5092700003 | 37.7634976322383 | -122.46314569683001 | (37.7634976322383, -122.46314569683) | |||
46150 | 46150 | 239714 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 872 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000978.62192 | 2099691.67862 | 37.745408384388 | -122.43931955855 | (37.745408384388, -122.43931955855) | |||
46348 | 46348 | 197519 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1055 Natoma St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6007591.229180001 | 2109427.92338 | 37.772515957284206 | -122.417143942455 | (37.7725159572842, -122.417143942455) | |||
46358 | 46358 | 179434 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006514.55403 | 2086760.1932299999 | 37.710214821715496 | -122.419260003144 | (37.7102148217155, -122.419260003144) | |||
46443 | 46443 | 200679 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6015689.2638 | 2095313.8362 | 37.7342138898064 | -122.388146614226 | (37.7342138898064, -122.388146614226) | |||
46462 | 46462 | 200672 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015595.8297 | 2095380.8889 | 37.734392825730794 | -122.388474327143 | (37.7343928257308, -122.388474327143) | |||
46825 | 46825 | 179482 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5988878.80429 | 2090370.98469 | 37.719120158641296 | -122.48047615337 | (37.7191201586413, -122.48047615337) | ||||
47230 | 47230 | 240537 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 21 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005750.77925 | 2099620.18871 | 37.7454825047108 | -122.422813105861 | (37.7454825047108, -122.422813105861) | |||
47246 | 47246 | 64355 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 230 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 8 | Permit Number 770960 | 6011932.302 | 2113111.4722700003 | 37.782873389928795 | -122.40238669808399 | (37.7828733899288, -122.402386698084) | ||
47632 | 47632 | 62229 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.728835505929396 | -122.43714804475701 | (37.7288355059294, -122.437148044757) | |
48114 | 48114 | 240565 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000404.48259 | 2104877.48466 | 37.7596146626978 | -122.441676928051 | (37.7596146626978, -122.441676928051) | |||
48286 | 48286 | 215017 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 832 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999463.89862 | 2095685.88724 | 37.734323119609606 | -122.44426940102801 | (37.7343231196096, -122.444269401028) | |||
48306 | 48306 | 179432 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006549.425009999 | 2086808.7283400001 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | |||
48654 | 48654 | 124458 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 41 Willard St North | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5996118.46825 | 2111510.19918 | 37.7775812452699 | -122.45697977108601 | (37.7775812452699, -122.456979771086) | |||
48668 | 48668 | 179445 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006641.641 | 2087043.6428599998 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | |||
48810 | 48810 | 183900 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989432.8197 | 2100761.3499 | 37.7476816186189 | -122.479320872687 | (37.7476816186189, -122.479320872687) | |||
48874 | 48874 | 215006 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1315 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5995155.473540001 | 2106606.4972900003 | 37.764061618685005 | -122.45995575296101 | (37.764061618685, -122.459955752961) | |||
48880 | 48880 | 197526 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010646.79925 | 2106595.9922 | 37.764911543656794 | -122.40637478936002 | (37.7649115436568, -122.40637478936) | |||
49033 | 49033 | 118221 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5984455.23409 | 2111482.2118900004 | 37.776827734448105 | -122.49732413820101 | (37.7768277344481, -122.497324138201) | |||
49154 | 49154 | 118227 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5984452.03524 | 2111621.56677 | 37.77721017528479 | -122.497345493843 | (37.7772101752848, -122.497345493843) | |||
49441 | 49441 | 239733 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2002 Castro St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002632.00291 | 2099712.5863900003 | 37.745559743 | -122.433603933486 | (37.745559743, -122.433603933486) | |||
49719 | 49719 | 136405 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008967.16736 | 2119019.94772 | 37.7989306555735 | -122.413062774033 | (37.7989306555735, -122.413062774033) | |||
49766 | 49766 | 214997 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995789.64183 | 2091235.7059799999 | 37.721893680423 | -122.45665069048799 | (37.721893680423, -122.456650690488) | |||
49879 | 49879 | 200844 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1919 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010817.914 | 2106923.6397 | 37.7658207601783 | -122.40580602510201 | (37.7658207601783, -122.405806025102) | |||
50273 | 50273 | 179467 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001663.653519999 | 2090093.9083 | 37.7190940729046 | -122.436264090339 | (37.7190940729046, -122.436264090339) | |||
50278 | 50278 | 240579 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3560 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004617.41249 | 2103694.30226 | 37.756605059890006 | -122.42702223251601 | (37.75660505989, -122.427022232516) | |||
50574 | 50574 | 240562 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3818 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004117.0123 | 2105424.98126 | 37.761328784908 | -122.428876176805 | (37.761328784908, -122.428876176805) | |||
50694 | 50694 | 118217 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984459.3393 | 2111410.10949 | 37.776630002637 | -122.497304613296 | (37.776630002637, -122.497304613296) | |||
50722 | 50722 | 240572 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 210 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002036.98136 | 2104624.07975 | 37.7590117527075 | -122.436012807155 | (37.7590117527075, -122.436012807155) | |||
50851 | 50851 | 200842 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010705.6887 | 2106916.0312 | 37.7657935922594 | -122.40619365455 | (37.7657935922594, -122.40619365455) | |||
50939 | 50939 | 200829 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1550 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6011839.8305 | 2107032.5363 | 37.7661768622321 | -122.402279068281 | (37.7661768622321, -122.402279068281) | |||
51097 | 51097 | 47786 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 8 | Permit Number 45558 | 6009129.7041 | 2121124.5774 | 37.804718567986704 | -122.41264920318999 | (37.8047185679867, -122.41264920319) | ||
51181 | 51181 | 136415 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 640 Davis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013156.852000001 | 2118810.40691 | 37.7985896092893 | -122.398550270302 | (37.7985896092893, -122.398550270302) | |||
51448 | 51448 | 92261 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4545 Anza St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52708 | 5984639.1399 | 2111735.34775 | 37.7775335493935 | -122.49670664793301 | (37.7775335493935, -122.496706647933) | |
51527 | 51527 | 179437 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006551.53826 | 2086713.5575599999 | 37.71008885278471 | -122.419128872099 | (37.7100888527847, -122.419128872099) | |||
51699 | 51699 | 179433 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006535.42412 | 2086786.7518099998 | 37.7102889213719 | -122.419189754426 | (37.7102889213719, -122.419189754426) | |||
51758 | 51758 | 197569 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011744.637069999 | 2113111.42965 | 37.7828627950365 | -122.403035941152 | (37.7828627950365, -122.403035941152) | |||
51841 | 51841 | 179460 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.43853839394698 | (37.7179436214658, -122.438538393947) | |||
51874 | 51874 | 183899 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989428.0919 | 2100803.1123 | 37.747796012582704 | -122.479340275734 | (37.7477960125827, -122.479340275734) | |||
51882 | 51882 | 179443 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006639.5983 | 2087274.4168099998 | 37.711633813430204 | -122.418864269997 | (37.7116338134302, -122.418864269997) | |||
52120 | 52120 | 118224 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984451.82255 | 2111562.02768 | 37.7770466856492 | -122.49734183318701 | (37.7770466856492, -122.497341833187) | |||
52151 | 52151 | 239712 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 88 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006164.570119999 | 2097549.79113 | 37.7398209981319 | -122.421235287575 | (37.7398209981319, -122.421235287575) | |||
52358 | 52358 | 43759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.981790001 | 2113705.55195 | 37.783286919680705 | -122.476451677439 | (37.7832869196807, -122.476451677439) | ||
52385 | 52385 | 239682 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3685 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 7ft | 6005238.007069999 | 2101931.5191900004 | 37.751799940838204 | -122.424750590868 | (37.7517999408382, -122.424750590868) | |||
52817 | 52817 | 197564 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011853.28866 | 2107502.0789900003 | 37.7674668719146 | -122.402265535131 | (37.7674668719146, -122.402265535131) | |||
52898 | 52898 | 47230 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.5709799998 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) | |
53158 | 53158 | 197573 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011805.47785 | 2113169.35516 | 37.7830252422689 | -122.402829531459 | (37.7830252422689, -122.402829531459) | |||
53204 | 53204 | 240563 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004179.51855 | 2105131.83325 | 37.7605274080343 | -122.42863909661999 | (37.7605274080343, -122.42863909662) | |||
53232 | 53232 | 123753 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5995463.5723 | 2110766.04178 | 37.7755003566036 | -122.459191361341 | (37.7755003566036, -122.459191361341) | |||
53238 | 53238 | 50628 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.720375661427205 | -122.39176255443 | (37.7203756614272, -122.39176255443) | |||
53284 | 53284 | 197543 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011744.4821 | 2107062.59215 | 37.7662540659871 | -122.40261097552799 | (37.7662540659871, -122.402610975528) | |||
53313 | 53313 | 197550 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011736.4606800005 | 2107238.9435 | 37.766737839213796 | -122.402651123063 | (37.7667378392138, -122.402651123063) | |||
53981 | 53981 | 118228 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984449.813999999 | 2111641.4618599997 | 37.7772646712772 | -122.49735464678001 | (37.7772646712772, -122.49735464678) | |||
54130 | 54130 | 200066 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6015094.0337 | 2094004.9347 | 37.730586913455205 | -122.39011312209601 | (37.7305869134552, -122.390113122096) | |||
54299 | 54299 | 118236 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5984154.15255 | 2111259.59719 | 37.7761988481286 | -122.49834920754101 | (37.7761988481286, -122.498349207541) | |||
54306 | 54306 | 240575 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3971 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003902.14198 | 2104194.35497 | 37.7579376141555 | -122.429531555935 | (37.7579376141555, -122.429531555935) | |||
54514 | 54514 | 200831 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1550 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6011784.6689 | 2107029.6831 | 37.766165948693796 | -122.40246966197901 | (37.7661659486938, -122.402469661979) | |||
54642 | 54642 | 214183 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992610.48002 | 2094547.7964400002 | 37.730804817991704 | -122.467880927762 | (37.7308048179917, -122.467880927762) | |||
54669 | 54669 | 179439 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006794.78813 | 2086912.99237 | 37.7106501547416 | -122.418302281839 | (37.7106501547416, -122.418302281839) | |||
54777 | 54777 | 114770 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
54855 | 54855 | 179483 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5988918.9165199995 | 2090347.02209 | 37.7190566943955 | -122.48033574940399 | (37.7190566943955, -122.480335749404) | ||||
54975 | 54975 | 113592 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013608.47765 | 2118139.1354900002 | 37.7967716072789 | -122.39694040288799 | (37.7967716072789, -122.396940402888) | |||
55322 | 55322 | 239696 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 112 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5997951.3916 | 2106835.98646 | 37.7648521416436 | -122.450302081196 | (37.7648521416436, -122.450302081196) | |||
55379 | 55379 | 179487 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6001448.45649 | 2093575.59463 | 37.728641765884106 | -122.437257104634 | (37.7286417658841, -122.437257104634) | |||
55609 | 55609 | 136404 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008943.49637 | 2119016.81507 | 37.7989207252599 | -122.413144462145 | (37.7989207252599, -122.413144462145) | |||
55960 | 55960 | 197531 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2006 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6012046.11634 | 2103763.76948 | 37.7572130681337 | -122.40133582769501 | (37.7572130681337, -122.401335827695) | |||
56016 | 56016 | 124457 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 41 Willard St North | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996114.41784 | 2111533.6822599997 | 37.7776454910208 | -122.456995481723 | (37.7776454910208, -122.456995481723) | |||
56147 | 56147 | 179476 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5994306.081069999 | 2086649.9682200002 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | ||||
56526 | 56526 | 214173 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2252 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991053.76562 | 2100086.62004 | 37.7459229980593 | -122.47366657496401 | (37.7459229980593, -122.473666574964) | |||
56796 | 56796 | 215019 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 113 Stillings Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 10ft | 6000031.68078 | 2095690.19732 | 37.7343673311927 | -122.44230670979601 | (37.7343673311927, -122.442306709796) | |||
56840 | 56840 | 248529 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Beulah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997709.9004 | 2107802.0064 | 37.7674907631986 | -122.451207005854 | (37.7674907631986, -122.451207005854) | |||
56877 | 56877 | 239719 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4818 25th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 10ft | 5999936.15376 | 2101092.9328900003 | 37.7491965123129 | -122.44302484724199 | (37.7491965123129, -122.443024847242) | |||
56961 | 56961 | 117877 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 734 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5983242.29307 | 2110782.48705 | 37.774835329522794 | -122.501468223794 | (37.7748353295228, -122.501468223794) | |||
57171 | 57171 | 197523 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010718.525880001 | 2106914.57132 | 37.7657903018022 | -122.40614915038799 | (37.7657903018022, -122.406149150388) | |||
57225 | 57225 | 239741 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1455 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003319.3931599995 | 2099769.2537700003 | 37.745754316715704 | -122.43123108934401 | (37.7457543167157, -122.431231089344) |
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");