Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33188 | 33188 | 247526 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1101 Waller St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6000042.11565 | 2108480.23517 | 37.76948626629979 | -122.44318892675 | (37.7694862662998, -122.44318892675) | ||||
| 35978 | 35978 | 175198 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6005048.079 | 2092617.03467 | 37.726213742054604 | -122.424744822616 | (37.7262137420546, -122.424744822616) | ||||
| 73789 | 73789 | 175201 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6005063.1365 | 2092591.26253 | 37.7261438278596 | -122.42469093704099 | (37.7261438278596, -122.424690937041) | ||||
| 75996 | 75996 | 175203 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 655 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 52 | 6005189.8347 | 2092537.12043 | 37.7260023204239 | -122.424249099221 | (37.7260023204239, -122.424249099221) | ||||
| 133850 | 133850 | 175204 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 653 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6005107.433759999 | 2092594.0364400002 | 37.72615394614 | -122.424538001034 | (37.72615394614, -122.424538001034) | ||||
| 143122 | 143122 | 175202 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 654 Peru Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6005192.08696 | 2092525.09672 | 37.725969433130395 | -122.42424045853399 | (37.7259694331304, -122.424240458534) | ||||
| 150678 | 150678 | 175205 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 653 Peru Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6005071.6263 | 2092637.8609799999 | 37.7262722564417 | -122.42466490166201 | (37.7262722564417, -122.424664901662) | ||||
| 154464 | 154464 | 175199 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6005054.924 | 2092614.9205099999 | 37.7262083236385 | -122.42472100946699 | (37.7262083236385, -122.424721009467) | ||||
| 163416 | 163416 | 175200 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005058.70512 | 2092602.03865 | 37.726173166437704 | -122.42470702233801 | (37.7261731664377, -122.424707022338) | ||||
| 177427 | 177427 | 175206 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 653 Peru Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6005071.100819999 | 2092642.6936700002 | 37.72628549626779 | -122.42466706185199 | (37.7262854962678, -122.424667061852) | ||||
| 180394 | 180394 | 203576 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 404 Baden St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6000769.77181 | 2095296.00897 | 37.7333270215234 | -122.439726643888 | (37.7333270215234, -122.439726643888) | ||||
| 184006 | 184006 | 248223 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 70 Fair Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | ||||
| 117426 | 117426 | 106344 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2428 14th Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2014 12:00:00 AM | 3x3 | 5992079.0 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | |||
| 144189 | 144189 | 106345 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2428 14th Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2014 12:00:00 AM | 3x3 | 5992079.0 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | |||
| 31166 | 31166 | 125541 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.45294375606501 | (37.7848046777406, -122.452943756065) | ||||
| 33683 | 33683 | 221802 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 325 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 3ft | 6003816.248819999 | 2098634.77002 | 37.7426674306639 | -122.42943214577 | (37.7426674306639, -122.42943214577) | |||
| 34188 | 34188 | 221823 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 588 Ogden Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 6007760.27568 | 2096148.55485 | 37.7360633428545 | -122.41561880828199 | (37.7360633428545, -122.415618808282) | |||
| 59894 | 59894 | 221824 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 588 Ogden Ave | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6007730.82531 | 2096150.2700599998 | 37.736066396937204 | -122.415720751814 | (37.7360663969372, -122.415720751814) | |||
| 130119 | 130119 | 203536 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 347 Hearst Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 5999101.320719999 | 2094349.11818 | 37.730631973677795 | -122.445426858158 | (37.7306319736778, -122.445426858158) | |||
| 36231 | 36231 | 203575 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 60 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6001009.56246 | 2095231.0134 | 37.7331622045591 | -122.438892966938 | (37.7331622045591, -122.438892966938) | |||
| 55917 | 55917 | 221939 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 21 Harry St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6003408.10773 | 2097774.81236 | 37.740283068906 | -122.43078202367201 | (37.740283068906, -122.430782023672) | |||
| 60499 | 60499 | 124074 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 701 Funston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5991915.64045 | 2110472.3398700003 | 37.7744893213305 | -122.47144298584699 | (37.7744893213305, -122.471442985847) | ||||
| 65220 | 65220 | 125542 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Heather Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997338.84626 | 2114106.78779 | 37.78478079984 | -122.45294556907601 | (37.78478079984, -122.452945569076) | |||
| 70944 | 70944 | 175175 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 231 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 5998599.64276 | 2088795.69735 | 37.71535491666071 | -122.446761792925 | (37.7153549166607, -122.446761792925) | |||
| 71604 | 71604 | 185945 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2001 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984839.2608 | 2101514.9951 | 37.749483053902296 | -122.495260478283 | (37.7494830539023, -122.495260478283) | |||
| 76159 | 76159 | 187082 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2600 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5985191.6703 | 2096995.0278 | 37.737093071648005 | -122.49370882770701 | (37.737093071648, -122.493708827707) | |||
| 131594 | 131594 | 185641 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2100 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985060.0587 | 2100441.1859 | 37.7465475916098 | -122.494417818871 | (37.7465475916098, -122.494417818871) | |||
| 158686 | 158686 | 175176 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 226 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5998630.92665 | 2088821.6560099998 | 37.715427980281795 | -122.44665552904699 | (37.7154279802818, -122.446655529047) | |||
| 162280 | 162280 | 189220 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1652 La Salle Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 6015291.93207 | 2096384.83865 | 37.737132622377 | -122.389595102843 | (37.737132622377, -122.389595102843) | |||
| 163204 | 163204 | 185946 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2001 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984833.7396 | 2101513.2963 | 37.7494780662031 | -122.49527944520099 | (37.7494780662031, -122.495279445201) | |||
| 164086 | 164086 | 189216 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1660 La Salle Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 9ft | 6015290.992769999 | 2096384.2824799998 | 37.737131043164794 | -122.38959831162501 | (37.7371310431648, -122.389598311625) | |||
| 168569 | 168569 | 203579 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 312 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5999939.25303 | 2094981.39881 | 37.7324158679899 | -122.44257538767 | (37.7324158679899, -122.44257538767) | |||
| 184844 | 184844 | 185947 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2001 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984831.6161 | 2101506.0763 | 37.7494581177315 | -122.495286255832 | (37.7494581177315, -122.495286255832) | |||
| 186592 | 186592 | 175215 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 857 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 8ft | 6010301.67863 | 2094727.3315700002 | 37.7323034959049 | -122.406731980322 | (37.7323034959049, -122.406731980322) | |||
| 188327 | 188327 | 185942 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2001 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984826.9443 | 2101536.2304 | 37.7495406390981 | -122.495304634302 | (37.7495406390981, -122.495304634302) | |||
| 46828 | 46828 | 84740 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 143 Alhambra St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | |
| 48052 | 48052 | 124270 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2 03rd Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5994893.51688 | 2115041.88961 | 37.78720789934 | -122.461473360648 | (37.78720789934, -122.461473360648) | ||||
| 61216 | 61216 | 124272 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5994894.056609999 | 2114999.9706 | 37.787092832167 | -122.46146845316002 | (37.787092832167, -122.46146845316) | ||||
| 1165 | 1165 | 249373 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 649 Jones St | 1 | : 4 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.1661400003 | 37.78713740130579 | -122.4133182966 | (37.7871374013058, -122.4133182966) | |
| 28549 | 28549 | 189215 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1400 20th St | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013696.2967300005 | 2104791.67795 | 37.7601274111746 | -122.39570084212299 | (37.7601274111746, -122.395700842123) | |||
| 29547 | 29547 | 218232 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 371 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 2ft | 5991901.5455 | 2097060.86466 | 37.7376641082099 | -122.47051476505 | (37.7376641082099, -122.47051476505) | |||
| 39285 | 39285 | 221786 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Scott St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 2ft | 6002363.3837 | 2108638.99661 | 37.7700542727214 | -122.435171122647 | (37.7700542727214, -122.435171122647) | |||
| 73518 | 73518 | 221788 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 67 Richland Ave | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005032.772530001 | 2096203.58298 | 37.7360607419969 | -122.42505281075199 | (37.7360607419969, -122.425052810752) | |||
| 75047 | 75047 | 203560 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997153.12879 | 2089368.29033 | 37.716844384649704 | -122.45180284012599 | (37.7168443846497, -122.451802840126) | |||
| 135599 | 135599 | 221784 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 201 Buchanan St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004701.97389 | 2109293.6735099996 | 37.7719843770185 | -122.427128606994 | (37.7719843770185, -122.427128606994) | |||
| 139878 | 139878 | 125543 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 511 Webster St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6004027.82216 | 2110630.44547 | 37.7756166793921 | -122.429555900592 | (37.7756166793921, -122.429555900592) | |||
| 153707 | 153707 | 202091 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 82 Carr St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012965.80047 | 2090628.9418799998 | 37.7211988543156 | -122.39723414844102 | (37.7211988543156, -122.397234148441) | |||
| 154545 | 154545 | 203558 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 179 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997048.33435 | 2088809.5415700001 | 37.7153041877202 | -122.45212476956002 | (37.7153041877202, -122.45212476956) | |||
| 161174 | 161174 | 250774 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 261 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 30 | Width 3ft | 5985867.52173 | 2114167.09587 | 37.7842823263074 | -122.49263646501998 | (37.7842823263074, -122.49263646502) | |||
| 164237 | 164237 | 250978 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 16 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5981781.21701 | 2113006.5772 | 37.7808561080562 | -122.506687293694 | (37.7808561080562, -122.506687293694) | |||
| 170193 | 170193 | 203559 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997146.51683 | 2089373.33367 | 37.7168578537955 | -122.45182605793998 | (37.7168578537955, -122.45182605794) | |||
| 173271 | 173271 | 221785 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 69 Scott St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 3ft | 6002359.55948 | 2108655.6822200003 | 37.7700998701305 | -122.43518554417801 | (37.7700998701305, -122.435185544178) | |||
| 22945 | 22945 | 104992 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.74123331264771 | -122.505795454359 | (37.7412333126477, -122.505795454359) | |
| 46056 | 46056 | 203567 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 209 Colon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5996068.02094 | 2094221.27645 | 37.7301073235953 | -122.455904133578 | (37.7301073235953, -122.455904133578) | |||
| 47557 | 47557 | 203564 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 202 Elmwood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5994856.42725 | 2092686.28381 | 37.7258229929193 | -122.459981583277 | (37.7258229929193, -122.459981583277) | |||
| 53079 | 53079 | 221837 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 109 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6006703.42014 | 2103074.3868400003 | 37.755020650507795 | -122.41976406777599 | (37.7550206505078, -122.419764067776) | |||
| 60383 | 60383 | 189217 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1634 Jerrold Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6015116.50224 | 2097212.0883 | 37.7393943516633 | -122.390259427548 | (37.7393943516633, -122.390259427548) | |||
| 130435 | 130435 | 203529 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 24 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5992569.96638 | 2096706.9370900001 | 37.7367309392805 | -122.46817799541799 | (37.7367309392805, -122.468177995418) | |||
| 149776 | 149776 | 203528 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 24 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5992568.777980001 | 2096730.41145 | 37.7367953253409 | -122.46818381133001 | (37.7367953253409, -122.46818381133) | |||
| 153630 | 153630 | 203566 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 209 Colon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5996063.41122 | 2094232.8960099998 | 37.7301389635391 | -122.455920909543 | (37.7301389635391, -122.455920909543) | |||
| 158703 | 158703 | 221787 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 124 27th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 8ft | 6005680.59891 | 2100245.5882599996 | 37.747195749186794 | -122.42310022339399 | (37.7471957491868, -122.423100223394) | |||
| 166313 | 166313 | 183416 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2685 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5989557.6977 | 2097079.8204 | 37.7375803497092 | -122.478619864368 | (37.7375803497092, -122.478619864368) | |||
| 166331 | 166331 | 183265 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1249 46th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5981784.0294 | 2106586.8909 | 37.7632296873576 | -122.50620140465901 | (37.7632296873576, -122.506201404659) | |||
| 169865 | 169865 | 251005 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 342 Point Lobos Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5981698.04635 | 2112709.85802 | 37.7800365073085 | -122.506953000187 | (37.7800365073085, -122.506953000187) | |||
| 9 | 9 | 203507 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5991972.62617 | 2105259.8491700003 | 37.76018051163321 | -122.470866084321 | (37.7601805116332, -122.470866084321) | |||
| 22 | 22 | 203506 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 910 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5992059.0 | 2105289.0 | 37.760265546982495 | -122.470569484113 | (37.7602655469825, -122.470569484113) | |||
| 2135 | 2135 | 57208 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2238 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | Permit Number 775007 | 6000879.71894 | 2116143.1485 | 37.7905743988346 | -122.440841472269 | (37.7905743988346, -122.440841472269) | ||
| 2378 | 2378 | 221860 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 516 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1998 12:00:00 AM | 15 | Width 3ft | Permit Number 39568 | 6001163.03933 | 2103237.69221 | 37.7551553815387 | -122.438935950032 | (37.7551553815387, -122.438935950032) | |
| 3745 | 3745 | 221791 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | |
| 4318 | 4318 | 160894 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 642 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:21:00 AM | 3 | Width 0ft | 6002380.66916 | 2090044.6321900003 | 37.7189994849067 | -122.43378212606702 | (37.7189994849067, -122.433782126067) | |
| 4402 | 4402 | 160893 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 634 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:15:00 AM | 3 | Width 0ft | 6002406.55833 | 2090085.42086 | 37.719112950580296 | -122.433695551007 | (37.7191129505803, -122.433695551007) | |
| 4866 | 4866 | 253703 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1221 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998953.0 | 2105574.0 | 37.7614443133046 | -122.44674697738199 | (37.7614443133046, -122.446746977382) | ||||
| 5123 | 5123 | 175078 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1584 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001809.644719999 | 2092991.8257799998 | 37.7270593952569 | -122.435966703417 | (37.7270593952569, -122.435966703417) | |||
| 5762 | 5762 | 107230 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1445 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005960.15833 | 2119639.59713 | 37.8004627936866 | -122.423512110213 | (37.8004627936866, -122.423512110213) | |||
| 8499 | 8499 | 41209 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.44286834991101 | (37.7996299225355, -122.442868349911) | |
| 9773 | 9773 | 114349 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1240 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x15 | Permit Number 777354 | 5981849.8 | 2106648.5 | 37.7634027199113 | -122.50597849798001 | (37.7634027199113, -122.50597849798) | ||
| 10544 | 10544 | 52929 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.727471916095205 | -122.433397195531 | (37.7274719160952, -122.433397195531) |
| 10710 | 10710 | 108565 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.9401900002 | 37.7253828953025 | -122.40588377841401 | (37.7253828953025, -122.405883778414) |
| 10987 | 10987 | 35857 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.43458140929899 | (37.7261135989609, -122.434581409299) |
| 11084 | 11084 | 121328 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2455 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5986403.9195 | 2098529.3345 | 37.7413767161187 | -122.48963038732401 | (37.7413767161187, -122.489630387324) | |||
| 11329 | 11329 | 1275 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5992427.65168 | 2087335.5500599998 | 37.710991191174 | -122.467988584733 | (37.710991191174, -122.467988584733) | |||
| 11336 | 11336 | 97263 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 220 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773740 | 6009330.61336 | 2094994.9708200002 | 37.732983995812795 | -122.41010807752599 | (37.7329839958128, -122.410108077526) | |
| 11377 | 11377 | 108847 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 970 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001586.13513 | 2086816.33243 | 37.7100901720951 | -122.43629760175101 | (37.7100901720951, -122.436297601751) | |
| 11746 | 11746 | 1274 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3X3 | Permit Number 778829 | 5992454.25389 | 2087344.9239400001 | 37.71101846581121 | -122.467897323323 | (37.7110184658112, -122.467897323323) | |
| 11911 | 11911 | 1278 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/1990 12:00:00 AM | 12 | 3X3 | 5992545.036040001 | 2087392.68167 | 37.711154838998 | -122.467587032028 | (37.711154838998, -122.467587032028) | ||
| 12043 | 12043 | 108683 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.208459999 | 2086863.37515 | 37.7101463059777 | -122.44073846482401 | (37.7101463059777, -122.440738464824) |
| 12058 | 12058 | 108846 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 970 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001611.41863 | 2086816.80035 | 37.7100928934503 | -122.436210250619 | (37.7100928934503, -122.436210250619) | |
| 12345 | 12345 | 96872 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 620 Palmetto Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x3 | 5991838.49017 | 2087239.3222700001 | 37.7106929318927 | -122.470017846453 | (37.7106929318927, -122.470017846453) | |||
| 12394 | 12394 | 1269 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992328.07158 | 2087287.97745 | 37.7108548170665 | -122.468329295555 | (37.7108548170665, -122.468329295555) | |||
| 12505 | 12505 | 1266 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5992143.8312800005 | 2087204.7899900002 | 37.7106157610663 | -122.46896001711 | (37.7106157610663, -122.46896001711) | |||
| 12571 | 12571 | 1265 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5992172.84146 | 2087217.03484 | 37.710651058571294 | -122.468860642897 | (37.7106510585713, -122.468860642897) | ||
| 12826 | 12826 | 117427 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 690 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | 6002940.91679 | 2089412.4481900001 | 37.7172954225231 | -122.431800455543 | (37.7172954225231, -122.431800455543) | ||
| 12996 | 12996 | 35840 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 621 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 18 | 6x7 | Permit Number 39067 | 6002271.78016 | 2090299.1440400002 | 37.7196921382746 | -122.43417669731501 | (37.7196921382746, -122.434176697315) |
| 13215 | 13215 | 96870 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 620 Palmetto Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x3 | 5991859.908319999 | 2087240.59875 | 37.710697674923104 | -122.469943914081 | (37.7106976749231, -122.469943914081) | |||
| 16903 | 16903 | 203213 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 626 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 10x4 | Permit Number 779632 | 6001387.0 | 2090021.0 | 37.7188781603148 | -122.437215155763 | (37.7188781603148, -122.437215155763) | ||
| 17027 | 17027 | 4845 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 202 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 24 | 3X3 | 6006694.31051 | 2097440.2331 | 37.7395500270059 | -122.41939589431999 | (37.7395500270059, -122.41939589432) | ||
| 17413 | 17413 | 225 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2962 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/17/1991 12:00:00 AM | 40 | 3X4 | 5990608.66265 | 2095460.33335 | 37.7331946143326 | -122.47486804133301 | (37.7331946143326, -122.474868041333) | ||
| 18080 | 18080 | 112764 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908001 | (37.7167707693614, -122.45190370908) | ||
| 18159 | 18159 | 64301 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 151 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1988 12:00:00 AM | Permit Number 25112 | 6004932.609957799 | 2099277.06478887 | 37.74449416747979 | -122.42561779186899 | (37.7444941674798, -122.425617791869) | ||
| 18491 | 18491 | 90669 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3722 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984088.982472 | 2110402.934687 | 37.7738428780038 | -122.498511352333 | (37.7738428780038, -122.498511352333) |
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");