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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5657 | 5657 | 26166 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005131.2215 | 2119837.4845 | 37.8009593191179 | -122.426394664407 | (37.8009593191179, -122.426394664407) | |||
| 5904 | 5904 | 24490 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 852 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003356.8582 | 2110371.9538 | 37.7748689119653 | -122.431858466675 | (37.7748689119653, -122.431858466675) | ||
| 5946 | 5946 | 18013 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000963.2953 | 2114846.642 | 37.7870192873225 | -122.440459278057 | (37.7870192873225, -122.440459278057) | |||
| 6264 | 6264 | 18011 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000900.4249 | 2114838.7005 | 37.786993901953394 | -122.440676225149 | (37.7869939019534, -122.440676225149) | |||
| 6530 | 6530 | 8195 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1301 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001448.9604 | 2111096.3198 | 37.776749499067705 | -122.438510182933 | (37.7767494990677, -122.438510182933) | |||
| 6870 | 6870 | 9637 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002620.3308 | 2112001.9911 | 37.7793028076481 | -122.43452284095801 | (37.7793028076481, -122.434522840958) | |||
| 6933 | 6933 | 18012 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000934.1764 | 2114843.3331 | 37.787008543855 | -122.44055978525299 | (37.787008543855, -122.440559785253) | |||
| 7192 | 7192 | 21587 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005314.2609 | 2114809.1294 | 37.787163071612795 | -122.42540322917601 | (37.7871630716128, -122.425403229176) | |||
| 7706 | 7706 | 21589 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005274.899 | 2114802.7621 | 37.7871433646236 | -122.425538959573 | (37.7871433646236, -122.425538959573) | |||
| 8267 | 8267 | 13269 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2495 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 6 | 3X3 | 6000559.8762 | 2119201.7827 | 37.798954383190896 | -122.442167759467 | (37.7989543831909, -122.442167759467) | ||
| 8536 | 8536 | 21588 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005294.0011 | 2114805.6563 | 37.7871523906748 | -122.42547307647301 | (37.7871523906748, -122.425473076473) | |||
| 8583 | 8583 | 21586 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005346.0976 | 2114810.866 | 37.7871696385608 | -122.425293204645 | (37.7871696385608, -122.425293204645) | |||
| 8774 | 8774 | 9636 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002640.9745 | 2112004.0216 | 37.7793095547354 | -122.434451571103 | (37.7793095547354, -122.434451571103) | |||
| 8894 | 8894 | 21590 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005256.9547 | 2114799.289 | 37.78713281444121 | -122.425600795702 | (37.7871328144412, -122.425600795702) | |||
| 9434 | 9434 | 18037 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/1993 12:00:00 AM | 6 | 3X3 | 6000386.5591 | 2114760.4621 | 37.7867498032378 | -122.442448460651 | (37.7867498032378, -122.442448460651) | ||
| 12618 | 12618 | 15750 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 4625 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6002067.6674 | 2091962.7327 | 37.7242483928285 | -122.43500115616301 | (37.7242483928285, -122.435001156163) | |||
| 17214 | 17214 | 17082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1565 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999524.2661 | 2109435.6263 | 37.7720799869694 | -122.445048833846 | (37.7720799869694, -122.445048833846) | |||
| 17957 | 17957 | 15626 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.42330974756901 | (37.7404679423018, -122.423309747569) | |||
| 18594 | 18594 | 17117 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1907 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5997844.0536 | 2109200.8214 | 37.771339231452 | -122.45084386213101 | (37.771339231452, -122.450843862131) | |||
| 18981 | 18981 | 15282 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1600 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6007118.1667 | 2109554.742 | 37.7728375468829 | -122.418789312367 | (37.7728375468829, -122.418789312367) | |||
| 20461 | 20461 | 15627 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005560.95 | 2097781.3943 | 37.7404228796109 | -122.423338814191 | (37.7404228796109, -122.423338814191) | |||
| 21132 | 21132 | 15628 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005530.9833 | 2097730.2012 | 37.74028062358521 | -122.423438788897 | (37.7402806235852, -122.423438788897) | |||
| 21900 | 21900 | 14558 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1599X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999395.6349 | 2109419.0073 | 37.772027012932895 | -122.445492582637 | (37.7720270129329, -122.445492582637) | |||
| 26537 | 26537 | 199734 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | |||
| 31071 | 31071 | 247300 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 815 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002551.3233 | 2109517.7945 | 37.772477905220796 | -122.434583889381 | (37.7724779052208, -122.434583889381) | |||
| 31784 | 31784 | 98024 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1639 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988098.058999999 | 2098940.517 | 37.742604479099 | -122.483802857352 | (37.742604479099, -122.483802857352) | |||
| 34969 | 34969 | 140050 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 501 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005278.6254 | 2111629.2967 | 37.778430022863496 | -122.425300156764 | (37.7784300228635, -122.425300156764) | |||
| 37094 | 37094 | 38611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | |
| 41163 | 41163 | 181854 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2318 32nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5986419.9945 | 2099457.4563 | 37.7439260290789 | -122.48964304245001 | (37.7439260290789, -122.48964304245) | |||
| 47412 | 47412 | 141681 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998731.3741 | 2111830.7737 | 37.77861116004 | -122.447963975147 | (37.77861116004, -122.447963975147) | |||
| 47603 | 47603 | 142594 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008329.6499 | 2120808.0026 | 37.8038043983711 | -122.41539545409401 | (37.8038043983711, -122.415395454094) | |||
| 50203 | 50203 | 247450 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 917 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002601.5894 | 2109867.0536 | 37.773439737619704 | -122.43443498999599 | (37.7734397376197, -122.434434989996) | |||
| 59398 | 59398 | 141694 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998733.647999999 | 2112339.0414 | 37.780006861514 | -122.44799271326 | (37.780006861514, -122.44799271326) | |||
| 61042 | 61042 | 38609 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015273.2073 | 2094293.4811 | 37.7313891398709 | -122.38951383063 | (37.7313891398709, -122.38951383063) | |
| 63167 | 63167 | 142150 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 Stanyan Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996389.5624 | 2112799.0591 | 37.7811356783284 | -122.456135178495 | (37.7811356783284, -122.456135178495) | |||
| 63234 | 63234 | 142593 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008314.0969 | 2120822.0003 | 37.8038419583694 | -122.415450267897 | (37.8038419583694, -122.415450267897) | |||
| 65445 | 65445 | 199741 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2396 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014513.885 | 2092478.0086 | 37.7263620876399 | -122.392012061617 | (37.7263620876399, -122.392012061617) | |||
| 71272 | 71272 | 199749 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1555 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014744.6664 | 2092522.7122 | 37.7264976449454 | -122.39121737809799 | (37.7264976449454, -122.391217378098) | |||
| 72787 | 72787 | 141678 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998817.5652 | 2111841.8183 | 37.7786464120147 | -122.44766660351101 | (37.7786464120147, -122.447666603511) | |||
| 73758 | 73758 | 199726 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015013.7839 | 2092118.9829 | 37.725404016033295 | -122.390258847729 | (37.7254040160333, -122.390258847729) | |||
| 75917 | 75917 | 68430 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 501 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32281 | 6005253.5217 | 2111626.0919 | 37.7784198049854 | -122.425386771844 | (37.7784198049854, -122.425386771844) | ||
| 76520 | 76520 | 141343 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 462 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001184.3335 | 2110341.7185 | 37.7746624976237 | -122.43937150108499 | (37.7746624976237, -122.439371501085) | |||
| 130403 | 130403 | 143498 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6011217.723999999 | 2117930.0991 | 37.796064276257205 | -122.40519827705499 | (37.7960642762572, -122.405198277055) | |||
| 130431 | 130431 | 142597 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008368.5325 | 2120773.0083 | 37.8037104981311 | -122.41525841948 | (37.8037104981311, -122.41525841948) | |||
| 132110 | 132110 | 119622 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 77 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6000135.3841 | 2112812.4267 | 37.781386681539395 | -122.44317750199 | (37.7813866815394, -122.44317750199) | ||||
| 137944 | 137944 | 141075 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 189 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996533.8993 | 2113075.3805 | 37.7819026676704 | -122.45565582670099 | (37.7819026676704, -122.455655826701) | |||
| 152688 | 152688 | 141696 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998768.2977 | 2112343.8058 | 37.7800219238864 | -122.447873187985 | (37.7800219238864, -122.447873187985) | |||
| 153096 | 153096 | 199728 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014985.6871 | 2092077.3996 | 37.725288278052 | -122.390353072543 | (37.725288278052, -122.390353072543) | |||
| 156337 | 156337 | 143497 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.796088566637394 | -122.40520051378999 | (37.7960885666374, -122.40520051379) | |||
| 156752 | 156752 | 142993 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008349.8689 | 2120789.339 | 37.803754289201606 | -122.415324162836 | (37.8037542892016, -122.415324162836) | |||
| 163560 | 163560 | 199757 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1555 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015056.6652 | 2092285.8367 | 37.7258645418149 | -122.39012226093901 | (37.7258645418149, -122.390122260939) | |||
| 163737 | 163737 | 143168 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 189 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009887.869 | 2121571.9902 | 37.8059895743176 | -122.410057091761 | (37.8059895743176, -122.410057091761) | |||
| 163956 | 163956 | 108011 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6005290.828 | 2111124.4075 | 37.7770444098803 | -122.42522200735 | (37.7770444098803, -122.42522200735) | ||||
| 164164 | 164164 | 142598 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008376.308999999 | 2120765.2318 | 37.8036895828586 | -122.415230957587 | (37.8036895828586, -122.415230957587) | |||
| 167035 | 167035 | 142595 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008339.7594 | 2120798.6708 | 37.803779343791795 | -122.415359808453 | (37.8037793437918, -122.415359808453) | |||
| 167676 | 167676 | 142591 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008291.5451 | 2120841.4416 | 37.8038940717069 | -122.41552968724 | (37.8038940717069, -122.41552968724) | |||
| 168080 | 168080 | 141679 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998783.9983 | 2111836.4043 | 37.778629628102 | -122.44778233403 | (37.778629628102, -122.44778233403) | |||
| 168944 | 168944 | 140051 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 501 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005299.4561 | 2111632.5014 | 37.7784399990073 | -122.42522832358 | (37.7784399990073, -122.42522832358) | |||
| 170427 | 170427 | 199732 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014820.4695 | 2092191.1459 | 37.7255914365754 | -122.390932164611 | (37.7255914365754, -122.390932164611) | |||
| 170986 | 170986 | 141341 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 448 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001191.7822 | 2110294.5435 | 37.7745333908239 | -122.43934235241699 | (37.7745333908239, -122.439342352417) | |||
| 173501 | 173501 | 142596 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008359.2007 | 2120780.7848 | 37.8037313259866 | -122.415291263605 | (37.8037313259866, -122.415291263605) | |||
| 176490 | 176490 | 38608 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.38947335260099 | (37.7313671428977, -122.389473352601) | |
| 180418 | 180418 | 143162 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009943.6415 | 2121579.1756 | 37.8060124294215 | -122.409864588833 | (37.8060124294215, -122.409864588833) | |||
| 185077 | 185077 | 244147 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 405 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004529.1957 | 2109628.6007 | 37.772894233589795 | -122.42775012801701 | (37.7728942335898, -122.427750128017) | |||
| 185441 | 185441 | 38610 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015263.8639 | 2094301.7253 | 37.7314112587254 | -122.38954670833701 | (37.7314112587254, -122.389546708337) | |
| 23414 | 23414 | 64062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | |
| 26624 | 26624 | 141693 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998717.1894 | 2112334.7102 | 37.7799940283513 | -122.448049338774 | (37.7799940283513, -122.448049338774) | |||
| 29172 | 29172 | 138854 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 519 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004884.6976 | 2111071.1642 | 37.776875264769295 | -122.42662314727501 | (37.7768752647693, -122.426623147275) | |||
| 34800 | 34800 | 140777 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000158.3968 | 2112814.4573 | 37.7813935692054 | -122.44309803536699 | (37.7813935692054, -122.443098035367) | |||
| 36187 | 36187 | 143482 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010529.9358 | 2116279.9602 | 37.7914949183295 | -122.407461776619 | (37.7914949183295, -122.407461776619) | |||
| 36681 | 36681 | 199730 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014897.5638 | 2092133.7733 | 37.725438180339 | -122.390661646389 | (37.725438180339, -122.390661646389) | |||
| 39267 | 39267 | 141082 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 188 Commonwealth Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996586.3547 | 2113042.2151 | 37.7818146143415 | -122.455471958556 | (37.7818146143415, -122.455471958556) | |||
| 39425 | 39425 | 142599 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008384.0855 | 2120756.6777 | 37.8036665324855 | -122.415203440632 | (37.8036665324855, -122.415203440632) | |||
| 43832 | 43832 | 138987 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003459.8516 | 2110684.9037 | 37.7757340330654 | -122.43152453742701 | (37.7757340330654, -122.431524537427) | |||
| 44212 | 44212 | 184648 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1691 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983748.1287 | 2103659.9866 | 37.755308660398505 | -122.49919205978998 | (37.7553086603985, -122.49919205979) | |||
| 47388 | 47388 | 199743 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2392 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014556.9144 | 2092538.9669 | 37.7265318557922 | -122.391867570434 | (37.7265318557922, -122.391867570434) | |||
| 51389 | 51389 | 141496 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997041.2335 | 2111532.8232 | 37.77769631160189 | -122.45378926737101 | (37.7776963116019, -122.453789267371) | |||
| 54416 | 54416 | 143548 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2237 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002268.9185 | 2118432.4796 | 37.7969393283412 | -122.4361988317 | (37.7969393283412, -122.4361988317) | |||
| 56825 | 56825 | 108010 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6005279.8436 | 2111122.0196 | 37.777037232737705 | -122.42525983588001 | (37.7770372327377, -122.42525983588) | ||||
| 59370 | 59370 | 141680 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998758.0111 | 2111834.2387 | 37.7786221965848 | -122.447872077437 | (37.7786221965848, -122.447872077437) | |||
| 62193 | 62193 | 141692 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998708.9601 | 2112320.4172 | 37.7799543130642 | -122.44807677808001 | (37.7799543130642, -122.44807677808) | |||
| 67728 | 67728 | 141494 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996978.1424 | 2111525.1425 | 37.7776716051006 | -122.45400696498899 | (37.7776716051006, -122.454006964989) | |||
| 74885 | 74885 | 97311 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 7 | 3x3 | 5990303.3847 | 2099082.1466 | 37.7431214880079 | -122.47618790715099 | (37.7431214880079, -122.476187907151) | ||
| 130998 | 130998 | 141652 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1444 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000879.6247 | 2110722.6324 | 37.7756910458411 | -122.440452872246 | (37.7756910458411, -122.440452872246) | |||
| 134348 | 134348 | 97114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.47821424615101 | (37.7540855022306, -122.478214246151) | |||
| 135005 | 135005 | 247389 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 219 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002278.4252 | 2109251.0163 | 37.771729902717794 | -122.43550878138001 | (37.7717299027178, -122.43550878138) | |||
| 137260 | 137260 | 143170 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 179 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009922.0853 | 2121576.7805 | 37.8060046449874 | -122.409939018662 | (37.8060046449874, -122.409939018662) | |||
| 146529 | 146529 | 247337 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 719 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003076.0904 | 2109591.4739 | 37.7727099867472 | -122.43277393402501 | (37.7727099867472, -122.432773934025) | |||
| 171478 | 171478 | 61148 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2237 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1983 12:00:00 AM | 7 | Permit Number 21005 | 5997050.2982 | 2110479.7459 | 37.7748053558267 | -122.453681848705 | (37.7748053558267, -122.453681848705) | ||
| 177466 | 177466 | 32291 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36872 | 6014236.59 | 2091225.7906 | 37.722908348540294 | -122.39288309530001 | (37.7229083485403, -122.3928830953) | ||
| 178657 | 178657 | 142600 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008394.1949 | 2120748.9012 | 37.803645748305 | -122.415167905628 | (37.803645748305, -122.415167905628) | |||
| 179842 | 179842 | 143496 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | |||
| 182280 | 182280 | 141531 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996721.1149 | 2111488.1108 | 37.777555184997894 | -122.45489342919399 | (37.7775551849979, -122.454893429194) | |||
| 9575 | 9575 | 23736 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2005 12:00:00 AM | 8 | 4X4 | 6003952.5765 | 2110750.7086 | 37.775942631605204 | -122.429824773698 | (37.7759426316052, -122.429824773698) | ||
| 25536 | 25536 | 59622 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | |
| 30976 | 30976 | 31653 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1708 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35163 | 6004466.8826 | 2114789.0769 | 37.787060100362794 | -122.428333544653 | (37.7870601003628, -122.428333544653) | ||
| 35602 | 35602 | 217547 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 102 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5995842.2441 | 2088093.8487 | 37.713269899907104 | -122.45624180431801 | (37.7132698999071, -122.456241804318) | |||
| 41838 | 41838 | 108009 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6005268.3816 | 2111120.1092 | 37.7770313396992 | -122.42529935055799 | (37.7770313396992, -122.425299350558) | ||||
| 44534 | 44534 | 138691 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2844 BUSH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999863.2879 | 2114398.2903 | 37.7857255339984 | -122.44423281375099 | (37.7857255339984, -122.444232813751) | |||
| 45616 | 45616 | 247452 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 913 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002642.725 | 2109874.1732 | 37.773461621200795 | -122.434293205315 | (37.7734616212008, -122.434293205315) |
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");