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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181911 | 181911 | 186516 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980905.2686 | 2104991.5894 | 37.758797677676704 | -122.509122221366 | (37.7587976776767, -122.509122221366) | |||
| 178803 | 178803 | 186506 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980906.3041 | 2105016.4405 | 37.7588659727132 | -122.50912048557801 | (37.7588659727132, -122.509120485578) | |||
| 118624 | 118624 | 109510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7200X FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5980935.0 | 2109588.0 | 37.7714198408482 | -122.509360757847 | (37.7714198408482, -122.509360757847) | ||||
| 63003 | 63003 | 118456 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 490 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5981010.56733 | 2112424.984 | 37.7792138173967 | -122.50931009492099 | (37.7792138173967, -122.509310094921) | |||
| 182740 | 182740 | 118457 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 490 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5981011.746169999 | 2112476.4222 | 37.779355120923 | -122.509309837992 | (37.779355120923, -122.509309837992) | |||
| 179327 | 179327 | 109508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7200X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5981051.27607 | 2109621.18503 | 37.771517812403296 | -122.508961024865 | (37.7715178124033, -122.508961024865) | |||
| 189107 | 189107 | 119207 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5981051.50114 | 2110011.96585 | 37.7725907952116 | -122.50898926789499 | (37.7725907952116, -122.508989267895) | |||
| 175562 | 175562 | 119205 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5981054.80305 | 2109899.79176 | 37.772282992725394 | -122.508969515743 | (37.7722829927254, -122.508969515743) | |||
| 50372 | 50372 | 119204 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5981054.81855 | 2109824.51434 | 37.772076303922205 | -122.50896387162399 | (37.7720763039222, -122.508963871624) | |||
| 158957 | 158957 | 119203 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981056.2955 | 2109791.98887 | 37.7719870855851 | -122.508956347328 | (37.7719870855851, -122.508956347328) | |||
| 180494 | 180494 | 119201 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981058.88623 | 2109735.33972 | 37.771831696349395 | -122.508943178948 | (37.7718316963494, -122.508943178948) | |||
| 31050 | 31050 | 119202 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981058.93539 | 2109762.95865 | 37.7719075327332 | -122.508945060001 | (37.7719075327332, -122.508945060001) | |||
| 166903 | 166903 | 119200 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5981060.97068 | 2109705.7798200003 | 37.7717506564051 | -122.508933773591 | (37.7717506564051, -122.508933773591) | |||
| 153440 | 153440 | 83675 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4229 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50208 | 5981109.0607 | 2103468.6155 | 37.7546280386671 | -122.508304380172 | (37.7546280386671, -122.508304380172) | |
| 65099 | 65099 | 62101 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4224 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1985 12:00:00 AM | 4 | Permit Number 22194 | 5981140.9456 | 2104205.2821 | 37.756652594222004 | -122.508248791959 | (37.756652594222, -122.508248791959) | ||
| 148040 | 148040 | 118385 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 5630 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5981150.00923 | 2111669.7447 | 37.7771483744843 | -122.50877162854799 | (37.7771483744843, -122.508771628548) | |||
| 187698 | 187698 | 183262 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1227 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5981160.7547 | 2106692.5355 | 37.7634830454186 | -122.508364908995 | (37.7634830454186, -122.508364908995) | |||
| 134856 | 134856 | 184359 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4222 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981191.4982 | 2103531.0199 | 37.7548042411988 | -122.50802392550399 | (37.7548042411988, -122.508023925504) | |||
| 37863 | 37863 | 183313 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1266 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981212.7931 | 2106442.2 | 37.7627987629793 | -122.508166346352 | (37.7627987629793, -122.508166346352) | |||
| 161967 | 161967 | 186844 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2034 Lower Great Hwy | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5981219.1453 | 2101186.094 | 37.7483673667876 | -122.507754314909 | (37.7483673667876, -122.507754314909) | |||
| 13014 | 13014 | 24510 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1400 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5981246.2202 | 2105482.1578 | 37.7601647328681 | -122.507979481979 | (37.7601647328681, -122.507979481979) | |||
| 47505 | 47505 | 119234 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4625 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981247.37399 | 2110256.72872 | 37.7732743872469 | -122.50832990716101 | (37.7732743872469, -122.508329907161) | |||
| 1095 | 1095 | 54070 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1649 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 1 | Permit Number 9793 | 5981260.4052 | 2103836.5943 | 37.7556473215408 | -122.50780830550801 | (37.7556473215408, -122.507808305508) | ||
| 58922 | 58922 | 185743 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2120 Lower Great Hwy | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5981266.2638 | 2100624.5993 | 37.7468284358609 | -122.507549726279 | (37.7468284358609, -122.507549726279) | |||
| 77363 | 77363 | 185742 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2120 Lower Great Hwy | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5981267.7362 | 2100613.3105 | 37.7467975267188 | -122.507543797463 | (37.7467975267188, -122.507543797463) | |||
| 164684 | 164684 | 119233 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4625 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5981276.54512 | 2110255.8823 | 37.7732737822881 | -122.50822893921999 | (37.7732737822881, -122.50822893922) | |||
| 49556 | 49556 | 185768 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2100 Lower Great Hwy | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5981299.1485 | 2100269.7385 | 37.7458560246461 | -122.507409691662 | (37.7458560246461, -122.507409691662) | |||
| 66758 | 66758 | 54071 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1650 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 17 | Permit Number 9794 | 5981301.6578 | 2103844.8448 | 37.7556724054432 | -122.50766625573 | (37.7556724054432, -122.50766625573) | ||
| 161736 | 161736 | 181598 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1402 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5981310.4394 | 2105514.4681 | 37.760257231374105 | -122.507759779879 | (37.7602572313741, -122.507759779879) | |||
| 60123 | 60123 | 54383 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 651 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1972 12:00:00 AM | 15 | Permit Number 10149 | 5981319.187940001 | 2111228.52141 | 37.7759468761842 | -122.508153639765 | (37.7759468761842, -122.508153639765) | ||
| 56451 | 56451 | 184388 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2029 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5981345.698 | 2101255.1529 | 37.7485644381752 | -122.507321829204 | (37.7485644381752, -122.507321829204) | |||
| 66359 | 66359 | 184389 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2029 48th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5981347.0517 | 2101245.0003 | 37.7485366417249 | -122.507316395084 | (37.7485366417249, -122.507316395084) | |||
| 80150 | 80150 | 838 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 4255X Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 30 | 3x3 | 5981362.6566223 | 2105522.5911084 | 37.7602826110734 | -122.50757979099501 | (37.7602826110734, -122.507579790995) | ||
| 72164 | 72164 | 184447 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2121 48th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5981369.0491 | 2100531.2687 | 37.746578230630796 | -122.50718738801201 | (37.7465782306308, -122.507187388012) | |||
| 149908 | 149908 | 184441 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2121 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5981369.0491 | 2100580.0015 | 37.746712037251 | -122.507191002727 | (37.746712037251, -122.507191002727) | |||
| 43158 | 43158 | 184443 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2121 48th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5981369.3875 | 2100557.6656 | 37.746650729056896 | -122.50718817584699 | (37.7466507290569, -122.507188175847) | |||
| 135937 | 135937 | 184446 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2121 48th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981369.7259 | 2100546.1593 | 37.7466191559108 | -122.50718615224599 | (37.7466191559108, -122.507186152246) | |||
| 154645 | 154645 | 184442 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2121 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5981370.0644 | 2100570.5256 | 37.7466860788835 | -122.50718678911699 | (37.7466860788835, -122.507186789117) | |||
| 185011 | 185011 | 184464 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2149 48th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5981372.6025 | 2100411.6366 | 37.746249963664496 | -122.50716622744899 | (37.7462499636645, -122.507166227449) | |||
| 117971 | 117971 | 112810 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 666 47TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2015 12:00:00 AM | 3x3 | Permit Number 776751 | 5981389.0 | 2111175.0 | 37.7758040356864 | -122.507908173068 | (37.7758040356864, -122.507908173068) | ||
| 118854 | 118854 | 112809 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 666 47TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2015 12:00:00 AM | 3x3 | Permit Number 776751 | 5981389.0 | 2111175.0 | 37.7758040356864 | -122.507908173068 | (37.7758040356864, -122.507908173068) | ||
| 122548 | 122548 | 184411 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2086 48th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5981402.2144 | 2100888.6421 | 37.747561431181005 | -122.507099214622 | (37.747561431181, -122.507099214622) | |||
| 178017 | 178017 | 118671 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4550 Balboa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981403.18631 | 2110994.97114 | 37.775310565245206 | -122.50784573679199 | (37.7753105652452, -122.507845736792) | |||
| 162773 | 162773 | 184410 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2086 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5981403.9065 | 2100879.8432 | 37.747537371526704 | -122.507092710919 | (37.7475373715267, -122.507092710919) | |||
| 77025 | 77025 | 118670 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4550 Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981416.90109 | 2110996.24087 | 37.7753148595816 | -122.507798389291 | (37.7753148595816, -122.507798389291) | |||
| 11276 | 11276 | 110108 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4130 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 3x3 | 5981417.4705 | 2103534.0756 | 37.75482594364829 | -122.507242691355 | (37.7548259436483, -122.507242691355) | ||
| 51930 | 51930 | 97088 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4550 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x4.5 | 5981440.73275 | 2110998.41096 | 37.7753222220509 | -122.507716112605 | (37.7753222220509, -122.507716112605) | |||
| 44329 | 44329 | 97086 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4550 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5981457.56361 | 2110998.49669 | 37.7753234489943 | -122.50765789816201 | (37.7753234489943, -122.507657898162) | |||
| 166159 | 166159 | 184283 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4305 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5981502.2697 | 2104846.193 | 37.7584336388865 | -122.50704676639799 | (37.7584336388865, -122.507046766398) | |||
| 12649 | 12649 | 24533 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1395 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5981505.7764 | 2105644.9273 | 37.7606269413357 | -122.507093890918 | (37.7606269413357, -122.507093890918) | |||
| 69046 | 69046 | 184284 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4303 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 5981511.742000001 | 2104845.8874 | 37.758433357655605 | -122.507013984876 | (37.7584333576556, -122.507013984876) | |||
| 52566 | 52566 | 183270 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1238 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5981515.7658 | 2106625.9909 | 37.76332124853511 | -122.507132123913 | (37.7633212485351, -122.507132123913) | |||
| 143633 | 143633 | 121087 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1443 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778784 | 5981521.320719999 | 2105258.5458 | 37.7595669638281 | -122.507011468719 | (37.7595669638281, -122.507011468719) | |||
| 66259 | 66259 | 183628 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1443 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5981521.3591 | 2105256.7888 | 37.7595621418689 | -122.507011205649 | (37.7595621418689, -122.507011205649) | |||
| 50909 | 50909 | 183294 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1276 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5981523.7113 | 2106403.5182 | 37.7627108704687 | -122.507088138914 | (37.7627108704687, -122.507088138914) | |||
| 171240 | 171240 | 183301 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1280 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5981524.5476 | 2106378.4273 | 37.7626420273261 | -122.5070833851 | (37.7626420273261, -122.5070833851) | |||
| 76036 | 76036 | 37096 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1467 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39696 | 5981524.9714 | 2105106.2752 | 37.759149087294794 | -122.506987547698 | (37.7591490872948, -122.506987547698) | |
| 85675 | 85675 | 108214 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1611 47th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 15 | 3x3 | 5981530.432709999 | 2104091.45519 | 37.756363002508294 | -122.50689338520701 | (37.7563630025083, -122.506893385207) | |||
| 172219 | 172219 | 184286 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5981535.2701 | 2104809.8314 | 37.7583357437892 | -122.506929941161 | (37.7583357437892, -122.506929941161) | |||
| 167873 | 167873 | 184285 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5981535.8812 | 2104826.6372 | 37.7583819237079 | -122.506929074336 | (37.7583819237079, -122.506929074336) | |||
| 158901 | 158901 | 51084 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1358 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 5 | Permit Number 47542 | 5981543.7588 | 2105841.1993 | 37.7611680849155 | -122.50697708881701 | (37.7611680849155, -122.506977088817) | ||
| 188004 | 188004 | 181605 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1352 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5981543.7588 | 2105882.1849 | 37.7612806196192 | -122.506980129167 | (37.7612806196192, -122.506980129167) | |||
| 10779 | 10779 | 831 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1388 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5.5x6.5 | 5981551.002 | 2105650.5805 | 37.7606451268888 | -122.506937898142 | (37.7606451268888, -122.506937898142) | |||
| 144084 | 144084 | 833 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1400 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5981556.8759975 | 2105533.8452968 | 37.760324951376504 | -122.50690892383801 | (37.7603249513765, -122.506908923838) | |||
| 11284 | 11284 | 105132 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1619 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 777355 | 5981562.16 | 2104041.1764 | 37.756226819608 | -122.50677993398399 | (37.756226819608, -122.506779933984) | ||
| 147622 | 147622 | 184181 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1627 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5981562.7711 | 2104004.5075 | 37.756126173217794 | -122.506775100953 | (37.7561261732178, -122.506775100953) | |||
| 54700 | 54700 | 186973 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2900x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 5981564.792 | 2096478.003 | 37.7354606126333 | -122.50621004103701 | (37.7354606126333, -122.506210041037) | |||
| 41918 | 41918 | 184186 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1651 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5981569.4938 | 2103830.3301 | 37.7556483274352 | -122.50673893378 | (37.7556483274352, -122.50673893378) | |||
| 26460 | 26460 | 182920 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2738 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5981601.7141 | 2096643.1406 | 37.735916208709504 | -122.506094630091 | (37.7359162087095, -122.506094630091) | |||
| 138126 | 138126 | 182921 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2768 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5981605.4367 | 2096608.6216 | 37.735821648144295 | -122.506079201175 | (37.7358216481443, -122.506079201175) | |||
| 49498 | 49498 | 184432 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3812 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981616.2662 | 2100821.8038 | 37.7473905163679 | -122.506354093766 | (37.7473905163679, -122.506354093766) | |||
| 166304 | 166304 | 182908 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2998 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981619.6504 | 2096562.2578 | 37.735695182563795 | -122.506026623179 | (37.7356951825638, -122.506026623179) | |||
| 36718 | 36718 | 182918 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3675 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5981624.3883 | 2096682.5668 | 37.7360257969604 | -122.50601916001301 | (37.7360257969604, -122.506019160013) | |||
| 188122 | 188122 | 184539 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1939 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5981627.7505 | 2101868.0843 | 37.7502639852004 | -122.50639195948 | (37.7502639852004, -122.50639195948) | |||
| 129899 | 129899 | 97406 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1642 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2011 12:00:00 AM | 0 | 3x3 | Permit Number 768387 | 5981634.3 | 2103894.4 | 37.755828061107394 | -122.506519568736 | (37.7558280611074, -122.506519568736) | |
| 121287 | 121287 | 105189 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981634.44946 | 2111075.87113 | 37.7755463155962 | -122.50705176084101 | (37.7755463155962, -122.507051760841) | |
| 77895 | 77895 | 105191 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981635.0538800005 | 2111041.25056 | 37.77545129327579 | -122.507047101274 | (37.7754512932758, -122.507047101274) | |
| 127652 | 127652 | 105190 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981635.135559999 | 2111057.61363 | 37.7754962262709 | -122.50704803283101 | (37.7754962262709, -122.507048032831) | |
| 77606 | 77606 | 106897 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2768 GREAT HWY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981642.5 | 2096616.3 | 37.735844912626 | -122.505951630112 | (37.735844912626, -122.505951630112) | |||||
| 68487 | 68487 | 182919 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3675 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5981644.6937 | 2096683.2436 | 37.7360288505101 | -122.505949007455 | (37.7360288505101, -122.505949007455) | |||
| 111870 | 111870 | 105192 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3 | 5981653.0 | 2111144.0 | 37.7757344699637 | -122.50699264603901 | (37.7757344699637, -122.506992646039) | |||
| 141230 | 141230 | 116745 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2998x SLOAT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981657.0 | 2096559.0 | 37.7356884360348 | -122.505897251941 | (37.7356884360348, -122.505897251941) | ||||
| 121667 | 121667 | 107862 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2788 GREAT HWY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981657.8 | 2096559.0 | 37.7356884831234 | -122.50589448608 | (37.7356884831234, -122.50589448608) | ||||
| 186787 | 186787 | 182907 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2988 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981661.6147 | 2096543.3062 | 37.735645616787 | -122.505880134271 | (37.735645616787, -122.505880134271) | |||
| 179465 | 179465 | 118837 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 600 46th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5981666.867000001 | 2111590.99028 | 37.776962590483606 | -122.506977842076 | (37.7769625904836, -122.506977842076) | |||
| 26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
| 154803 | 154803 | 184534 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1906 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5981676.8437 | 2102069.7342 | 37.7508205493518 | -122.506237145813 | (37.7508205493518, -122.506237145813) | |||
| 131111 | 131111 | 116744 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2968 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5981677.1821 | 2096538.9067 | 37.7356344532549 | -122.50582598665301 | (37.7356344532549, -122.505825986653) | |||
| 152167 | 152167 | 184536 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1918 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5981680.2279 | 2102012.5409 | 37.7506637118715 | -122.50622120268801 | (37.7506637118715, -122.506221202688) | |||
| 34434 | 34434 | 83787 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1926 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 9 | 5981682.722 | 2101945.6334 | 37.750480149523796 | -122.506207617383 | (37.7504801495238, -122.506207617383) | ||
| 11510 | 11510 | 107860 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3667 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 777933 | 5981683.9506 | 2096685.2741 | 37.7360367363779 | -122.505813433386 | (37.7360367363779, -122.505813433386) | |||
| 31460 | 31460 | 182904 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2958 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5981700.1948 | 2096535.1841 | 37.7356255864855 | -122.50574614840299 | (37.7356255864855, -122.505746148403) | |||
| 123856 | 123856 | 106896 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2958 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981703.3 | 2096579.8 | 37.7357482722765 | -122.505738719186 | (37.7357482722765, -122.505738719186) | ||||||
| 106681 | 106681 | 97654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2331 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981707.8 | 2099208.6 | 37.7429664967596 | -122.505917998204 | (37.7429664967596, -122.505917998204) | |||||
| 180704 | 180704 | 115482 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4508 IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5981714.0 | 2106294.0 | 37.7624213702268 | -122.506421887419 | (37.7624213702268, -122.506421887419) | |||
| 77575 | 77575 | 107856 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | |||||
| 80788 | 80788 | 107855 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | |||||
| 44375 | 44375 | 182903 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5981728.9607 | 2096534.1688 | 37.7356244917628 | -122.505646620125 | (37.7356244917628, -122.505646620125) | |||
| 65685 | 65685 | 107861 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3637 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5981729.2991 | 2096685.951 | 37.736041263990394 | -122.50565669822201 | (37.7360412639904, -122.505656698222) | |||
| 71094 | 71094 | 183157 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2355 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5981731.4988 | 2099055.242 | 37.742546813149296 | -122.50582468877501 | (37.7425468131493, -122.505824688775) |
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");