trees
1,069 rows where qSpecies_id = 93 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
175799 | 30947 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
175707 | 41649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 450X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2000 12:00:00 AM | Permit Number 42121 | 6000751.83853912 | 2110650.06591878 | 37.7754845196238 | -122.440889708326 | (37.7754845196238, -122.440889708326) | 15 | 5 | 11 | 29492 | 10 | |||
175362 | 214174 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991436.00676 | 2097903.57199 | 37.7399510383196 | -122.4721857495 | (37.7399510383196, -122.4721857495) | 1 | 8 | 4 | 29491 | 40 | |||
175086 | 9540 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 | ||
175032 | 239717 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 819 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001263.11303 | 2099661.60656 | 37.7453419991489 | -122.438333682174 | (37.7453419991489, -122.438333682174) | 2 | 4 | 5 | 63 | 22 | |||
174971 | 76749 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
174395 | 65162 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | 4x12 | Permit Number 27142 | 6000403.82793053 | 2102538.64719816 | 37.7531927484611 | -122.441511357285 | (37.7531927484611, -122.441511357285) | 2 | 4 | 5 | 28862 | 22 |
174375 | 240548 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4172 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6002753.68148 | 2101252.12814 | 37.7497938663026 | -122.433293177244 | (37.7497938663026, -122.433293177244) | 2 | 4 | 5 | 28862 | 22 | |||
174064 | 138844 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005153.7619 | 2110972.2976 | 37.7766190089592 | -122.425685333039 | (37.7766190089592, -122.425685333039) | 7 | 9 | 11 | 28852 | 10 | |||
174056 | 179446 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006032.90525 | 2087456.20206 | 37.712098777304 | -122.420974066009 | (37.712098777304, -122.420974066009) | 9 | 7 | 8 | 309 | 39 | |||
173907 | 48950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2911 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46135 | 6009399.56446616 | 2102741.17443943 | 37.7542572383471 | -122.410416464523 | (37.7542572383471, -122.410416464523) | 2 | 4 | 7 | 28859 | 19 | ||
173802 | 239715 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 875 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000941.552 | 2099644.41912 | 37.745276511409 | -122.439444352976 | (37.745276511409, -122.439444352976) | 2 | 4 | 5 | 63 | 22 | |||
173622 | 142733 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 425 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009181 | 2121098 | 37.8046484719029 | -122.41246980811 | (37.8046484719029, -122.41246980811) | 3 | 1 | 10 | 308 | 23 | |||
173200 | 40640 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2740 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41638 | 5996456.82543 | 2111294.67201 | 37.7770088886807 | -122.455793702985 | (37.7770088886807, -122.455793702985) | 11 | 6 | 2 | 54 | 16 | ||
173032 | 138285 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2603 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001869.0685 | 2115321.3526 | 37.7883742541874 | -122.437359516387 | (37.7883742541874, -122.437359516387) | 13 | 6 | 1 | 29490 | 27 | |||
172994 | 30951 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
172859 | 200674 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6015639.7987 | 2095348.4618 | 37.7343062239298 | -122.388320048161 | (37.7343062239298, -122.388320048161) | 10 | 3 | 8 | 58 | 1 | |||
172567 | 118220 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5984456.55861 | 2111461.63296 | 37.7767713082661 | -122.497318036821 | (37.7767713082661, -122.497318036821) | 11 | 6 | 2 | 55 | 26 | |||
172287 | 24345 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 95 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6006134.19272 | 2108466.72229 | 37.7697946537198 | -122.422115687012 | (37.7697946537198, -122.422115687012) | 8 | 4 | 7 | 28853 | 19 | |||
172079 | 214190 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 393 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2009 12:00:00 AM | 17 | Width 3ft | Permit Number 53039 | 5992606.38416 | 2093945.56472 | 37.7291510025005 | -122.467851302315 | (37.7291510025005, -122.467851302315) | 9 | 8 | 4 | 59 | 40 | |
172022 | 35126 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.7174791459225 | -122.43602056561 | (37.7174791459225, -122.43602056561) | 9 | 7 | 6 | 28861 | 5 | |
171923 | 49833 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 418@ 19th ST Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 12 | Permit Number 46616 | 6014316.07851 | 2105148.78787 | 37.7611424148166 | -122.393582289386 | (37.7611424148166, -122.393582289386) | 10 | 3 | 8 | 28856 | 29 | |
171544 | 240574 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 676 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003010.11937 | 2104332.09959 | 37.7582652812248 | -122.432626383021 | (37.7582652812248, -122.432626383021) | 2 | 4 | 5 | 28862 | 3 | |||
171268 | 246423 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 406 Duncan St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6003794.9997 | 2099851.12644 | 37.7460060612246 | -122.429592349221 | (37.7460060612246, -122.429592349221) | 2 | 7 | 5 | 63 | 22 | |||
170927 | 197512 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 6009788.18393 | 2109495.5877 | 37.7728250956205 | -122.409549199229 | (37.7728250956205, -122.409549199229) | 14 | 2 | 9 | 28853 | 34 | ||||
170898 | 2772 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5994610.57975 | 2110790.94437 | 37.77551965701 | -122.462143851512 | (37.77551965701, -122.462143851512) | 11 | 6 | 2 | 54 | 11 | |||
170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
170405 | 136402 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007876.49139 | 2115513.01244 | 37.7892401916349 | -122.416588325105 | (37.7892401916349, -122.416588325105) | 13 | 1 | 10 | 28858 | 21 | |||
170254 | 114999 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 460 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009096.1804 | 2121164.206 | 37.8048254966519 | -122.412768019096 | (37.8048254966519, -122.412768019096) | 3 | 1 | 10 | 308 | 23 | |||
170135 | 43696 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1539 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 8 | Permit Number 43340 | 5993847.57781 | 2112069.22957 | 37.7789855246228 | -122.464876090912 | (37.7789855246228, -122.464876090912) | 11 | 6 | 2 | 54 | 11 | |
169793 | 179479 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989502.72531 | 2090743.34169 | 37.7201787974032 | -122.478346734135 | (37.7201787974032, -122.478346734135) | 1 | 8 | 4 | 64 | 14 | ||||
169768 | 187383 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2200 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985095.2656 | 2100101.9401 | 37.7456181752007 | -122.494271077686 | (37.7456181752007, -122.494271077686) | 1 | 8 | 3 | 29491 | 35 | |||
169750 | 140667 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 542 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996918.4239 | 2109564.4189 | 37.7722845447247 | -122.454071904455 | (37.7722845447247, -122.454071904455) | 15 | 5 | 11 | 29492 | 16 | |||
169518 | 246203 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999565.7884 | 2108011.1099 | 37.7681709945121 | -122.444802791675 | (37.7681709945121, -122.444802791675) | 15 | 5 | 11 | 29492 | 9 | |||
169480 | 200672 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015595.8297 | 2095380.8889 | 37.7343928257308 | -122.388474327143 | (37.7343928257308, -122.388474327143) | 10 | 3 | 8 | 58 | 1 | |||
169381 | 197533 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013601.75095 | 2103896.53741 | 37.7576642903943 | -122.395965104316 | (37.7576642903943, -122.395965104316) | 10 | 3 | 8 | 28856 | 29 | ||||
169348 | 48771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 562 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 773432 | 6005160.4427442 | 2110970.099276 | 37.77661335041 | -122.425662065534 | (37.77661335041, -122.425662065534) | 7 | 9 | 11 | 28852 | 10 | |||
169326 | 240582 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 8 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 15 | Width 3ft | Permit Number 9985 | 6003834.4345 | 2107034.98465 | 37.7657334691548 | -122.429968344076 | (37.7657334691548, -122.429968344076) | 8 | 4 | 5 | 28862 | 3 | |
169027 | 239734 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2010 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002635.5596 | 2099661.64118 | 37.7454200611823 | -122.433587994792 | (37.7454200611823, -122.433587994792) | 2 | 7 | 5 | 63 | 22 | |||
169018 | 239738 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4195 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6002653.35337 | 2100620.62293 | 37.7480542096553 | -122.433594989711 | (37.7480542096553, -122.433594989711) | 2 | 4 | 5 | 63 | 22 | |||
168976 | 2775 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5994586.46007 | 2110712.87272 | 37.7753039042477 | -122.462221623284 | (37.7753039042477, -122.462221623284) | 11 | 6 | 2 | 54 | 11 | |||
168629 | 214171 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1337 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994229.27069 | 2106420.50927 | 37.7634976322383 | -122.46314569683 | (37.7634976322383, -122.46314569683) | 1 | 5 | 11 | 56 | 12 | |||
168461 | 47789 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009148.3227 | 2121126.9048 | 37.8047260033811 | -122.412584936044 | (37.8047260033811, -122.412584936044) | 3 | 1 | 10 | 308 | 23 | ||
168390 | 240557 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 983 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003809.26979 | 2102545.95171 | 37.753406229815 | -122.429735177759 | (37.753406229815, -122.429735177759) | 2 | 4 | 5 | 28862 | 22 | |||
168385 | 54720 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 510 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1972 12:00:00 AM | 9 | Permit Number 10556 | 5983806.7051 | 2112297.13716 | 37.7790272518998 | -122.499627803034 | (37.7790272518998, -122.499627803034) | 11 | 6 | 2 | 55 | 26 | ||
167893 | 179468 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001647.16213 | 2090105.12517 | 37.7191239348993 | -122.436321896962 | (37.7191239348993, -122.436321896962) | 9 | 7 | 6 | 28861 | 5 | |||
167833 | 44448 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 6 | Permit Number 43777 | 6002641.71413 | 2086935.0699 | 37.7104761197367 | -122.432657792736 | (37.7104761197367, -122.432657792736) | 9 | 7 | 6 | 28861 | 5 | |
167813 | 5499 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5X5 | 6005058.9801366 | 2103927.2718726 | 37.7572696989713 | -122.42551171102 | (37.7572696989713, -122.42551171102) | 2 | 4 | 5 | 28859 | 19 | |||
167756 | 68408 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32243 | 5994001.22714578 | 2093857.38366654 | 37.7289893248225 | -122.463022856253 | (37.7289893248225, -122.463022856253) | 9 | 8 | 4 | 59 | 40 | ||
167679 | 7137 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 336X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5994611.62343 | 2110790.08992 | 37.775517371009 | -122.462140179219 | (37.775517371009, -122.462140179219) | 11 | 6 | 2 | 54 | 11 | |||
167640 | 179462 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 90 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000856.84082 | 2089774.26479 | 37.7181705294179 | -122.43903002902 | (37.7181705294179, -122.43903002902) | 9 | 7 | 6 | 28861 | 5 | |||
167487 | 17371 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999379.15193 | 2109268.47217 | 37.7716127406754 | -122.445538771694 | (37.7716127406754, -122.445538771694) | 15 | 5 | 11 | 29492 | 9 | |||
167389 | 102832 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
167002 | 48770 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | 15 | 3x3 | Permit Number 46028 | 6005170.9549 | 2110973.7304 | 37.7766239145875 | -122.425625959395 | (37.7766239145875, -122.425625959395) | 7 | 9 | 11 | 28852 | 10 | |
166898 | 240564 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Hancock St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004144.38287 | 2105130.57099 | 37.7605219536452 | -122.428760524878 | (37.7605219536452, -122.428760524878) | 2 | 4 | 5 | 28862 | 3 | |||
166836 | 117906 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 578 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5983823.18804 | 2111887.66222 | 37.7779039197886 | -122.499540512861 | (37.7779039197886, -122.499540512861) | 11 | 6 | 2 | 55 | 26 | |||
166748 | 31500 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3244 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.419907347924 | (37.7570464414299, -122.419907347924) | 2 | 4 | 7 | 28859 | 19 | ||||
166256 | 239741 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1455 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003319.39316 | 2099769.25377 | 37.7457543167157 | -122.431231089344 | (37.7457543167157, -122.431231089344) | 2 | 7 | 5 | 63 | 22 | |||
166144 | 35111 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
166105 | 136412 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013223.70662 | 2118326.48177 | 37.7972645904406 | -122.398284959481 | (37.7972645904406, -122.398284959481) | 3 | 1 | 10 | 28860 | 6 | |||
165709 | 14777 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 12 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
165637 | 214181 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 355 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992570.46264 | 2094410.68216 | 37.7304260253276 | -122.468009303302 | (37.7304260253276, -122.468009303302) | 9 | 8 | 4 | 59 | 40 | |||
165340 | 215013 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 9 Locksley Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994094.36202 | 2104778.03714 | 37.7589800579143 | -122.463493095026 | (37.7589800579143, -122.463493095026) | 1 | 5 | 4 | 56 | 12 | |||
165324 | 120320 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 640 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5988820.50243 | 2110953.12943 | 37.7756298975626 | -122.482184767826 | (37.7756298975626, -122.482184767826) | 11 | 6 | 2 | 55 | 26 | |||
165237 | 35113 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
164647 | 240536 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3256 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006586.82298 | 2103803.98419 | 37.7570173873698 | -122.420219073467 | (37.7570173873698, -122.420219073467) | 2 | 4 | 7 | 28859 | 19 | |||
164587 | 117839 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600x 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 6ft | 5983810.52385 | 2111649.02031 | 37.7772479352498 | -122.499566680778 | (37.7772479352498, -122.499566680778) | 11 | 6 | 2 | 55 | 26 | |||
164135 | 124456 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 41 Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996112.49349 | 2111554.958 | 37.7777037980862 | -122.457003677962 | (37.7777037980862, -122.457003677962) | 11 | 6 | 2 | 54 | 16 | |||
163960 | 40639 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2740 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41638 | 5996441.36597 | 2111293.50073 | 37.7770047854178 | -122.455847097036 | (37.7770047854178, -122.455847097036) | 11 | 6 | 2 | 54 | 16 | ||
163642 | 200677 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015676.0731 | 2095323.7293 | 37.7342403234109 | -122.388192909274 | (37.7342403234109, -122.388192909274) | 10 | 3 | 8 | 58 | 1 | |||
163557 | 240591 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004224.31251 | 2097557.73547 | 37.7397332350934 | -122.42794444859 | (37.7397332350934, -122.42794444859) | 2 | 7 | 5 | 63 | 7 | |||
163502 | 41628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | 8 | 2 | 9 | 28853 | 19 | |||
163383 | 50263 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 519 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46969 | 6006390.76852581 | 2096193.21285802 | 37.7361088859688 | -122.420356925459 | (37.7361088859688, -122.420356925459) | 2 | 7 | 7 | 28859 | 2 | ||
163290 | 114214 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 SERRANO DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5988981 | 2090766 | 37.7202107101289 | -122.480151800691 | (37.7202107101289, -122.480151800691) | 1 | 8 | 4 | 64 | 14 | ||||
163269 | 239688 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 214 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005063.05276 | 2109561.17817 | 37.7727392922036 | -122.425898651924 | (37.7727392922036, -122.425898651924) | 7 | 9 | 11 | 28852 | 10 | |||
162846 | 179453 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1657 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6006878.87058 | 2087495.95749 | 37.7122555876031 | -122.418052974468 | (37.7122555876031, -122.418052974468) | 9 | 7 | 8 | 309 | 39 | |||
162841 | 179488 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1309 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006965.96518 | 2093139.94616 | 37.7277576792711 | -122.418151834246 | (37.7277576792711, -122.418151834246) | 9 | 3 | 7 | 309 | 5 | |||
162735 | 93166 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2900@ Anza Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x9 | 5989637.90038 | 2111973.07871 | 37.7784779053207 | -122.479431856387 | (37.7784779053207, -122.479431856387) | 11 | 6 | 2 | 55 | 26 | |||
162670 | 239674 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3735 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6005599.10993 | 2100487.66713 | 37.7478558434925 | -122.42339921293 | (37.7478558434925, -122.42339921293) | 2 | 4 | 5 | 28859 | 22 | |||
162517 | 104734 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490x 03RD ST | 1 | Median : Cutout | Tree | DPW 1 | 40 | 9x9 | 6014203 | 2093127 | 37.7281268221954 | -122.393132175736 | (37.7281268221954, -122.393132175736) | 10 | 3 | 8 | 58 | 1 | |||
162504 | 179476 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5994306.08107 | 2086649.96822 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | 9 | 8 | 6 | 28861 | 25 | ||||
162276 | 240567 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 210 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001076.42176 | 2105089.43303 | 37.7602348828493 | -122.439368224458 | (37.7602348828493, -122.439368224458) | 2 | 4 | 5 | 28862 | 3 | |||
162251 | 136397 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3101 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005394.36926 | 2121578.01878 | 37.8057532498833 | -122.425608007222 | (37.8057532498833, -122.425608007222) | 13 | 1 | 1 | 28858 | 17 | |||
162241 | 62350 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22493 | 6005428.10472053 | 2099649.51598417 | 37.7455448191665 | -122.423930949775 | (37.7455448191665, -122.423930949775) | 2 | 7 | 5 | 28859 | 22 | ||
162222 | 179478 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | 1 | 8 | 4 | 64 | 14 | ||||
161956 | 111032 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||||
161596 | 114998 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 460 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6009108.5473 | 2121165.2365 | 37.8048290202645 | -122.412725294876 | (37.8048290202645, -122.412725294876) | 3 | 1 | 10 | 308 | 23 | |||
161176 | 136427 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013551.14952 | 2118058.04 | 37.796545747032 | -122.397133083548 | (37.796545747032, -122.397133083548) | 3 | 1 | 10 | 28860 | 6 | |||
161010 | 141934 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004016.7876 | 2111854.945 | 37.7789782281051 | -122.429681425362 | (37.7789782281051, -122.429681425362) | 7 | 9 | 11 | 29490 | 41 | |||
161000 | 239709 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999261.27725 | 2107669.14595 | 37.7672146651436 | -122.445831464074 | (37.7672146651436, -122.445831464074) | 15 | 5 | 5 | 29492 | 9 | |||
160504 | 114772 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
160392 | 122800 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1223 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6017230.3941 | 2093111.7012 | 37.7282525286375 | -122.382665199331 | (37.7282525286375, -122.382665199331) | 10 | 3 | 8 | 58 | 1 | |||
160176 | 217708 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1125 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5996389.2535 | 2091794.3451 | 37.7234619803781 | -122.454618335706 | (37.7234619803781, -122.454618335706) | 9 | 8 | 4 | 28861 | 24 | |||
159854 | 119671 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
159824 | 30944 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
159807 | 240550 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 437 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003457.73972 | 2103292.10883 | 37.7554350886811 | -122.431004092371 | (37.7554350886811, -122.431004092371) | 2 | 4 | 5 | 28862 | 22 | |||
159680 | 138406 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002021.2907 | 2114957.6084 | 37.7873841584288 | -122.436806803858 | (37.7873841584288, -122.436806803858) | 13 | 6 | 11 | 29490 | 27 | |||
159229 | 141911 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004522.3227 | 2111922.8021 | 37.7791931595072 | -122.427937412735 | (37.7791931595072, -122.427937412735) | 7 | 9 | 11 | 29490 | 41 | |||
159144 | 136425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6013547.46214 | 2118092.2461 | 37.7966394636056 | -122.397148242524 | (37.7966394636056, -122.397148242524) | 3 | 1 | 10 | 28860 | 6 | |||
159024 | 121236 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3512 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004884 | 2103735 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | 2 | 4 | 5 | 28862 | 3 |
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) );