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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89600 | 89600 | 103266 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2365 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001713.0 | 2118319.0 | 37.796596142729896 | -122.43811430510799 | (37.7965961427299, -122.438114305108) | ||||
| 90341 | 90341 | 52736 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 90642 | 90642 | 108476 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 90877 | 90877 | 109386 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300X BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000704.0 | 2110147.0 | 37.7741005029649 | -122.441019094263 | (37.7741005029649, -122.441019094263) | ||||
| 90890 | 90890 | 44755 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | |||
| 90930 | 90930 | 121191 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 91286 | 91286 | 94498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1600X Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | 7x7 | 5998899.3 | 2109049.0 | 37.770982719767794 | -122.44718280302601 | (37.7709827197678, -122.447182803026) | |||
| 91357 | 91357 | 49091 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 91506 | 91506 | 121193 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 91613 | 91613 | 88453 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 91621 | 91621 | 110056 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 Jamestown Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6016119.9 | 2086810.2 | 37.7108884169699 | -122.38606516043899 | (37.7108884169699, -122.386065160439) | |||||
| 91684 | 91684 | 32012 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Casitas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35406 | 5994862.5482333 | 2097095.53050341 | 37.7379300603176 | -122.460279744028 | (37.7379300603176, -122.460279744028) | ||||
| 91834 | 91834 | 117602 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3749 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5983838.0 | 2113090.0 | 37.781206058559704 | -122.499578155566 | (37.7812060585597, -122.499578155566) | ||||
| 92083 | 92083 | 38475 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 162 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40476 | 5999822.84916102 | 2087316.82231241 | 37.7113640595721 | -122.44242775396002 | (37.7113640595721, -122.44242775396) | ||
| 92138 | 92138 | 101902 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1100 Ocean Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 92220 | 92220 | 116215 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 SACRAMENTO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996623.0 | 2114922.0 | 37.7869781063352 | -122.45548108802099 | (37.7869781063352, -122.455481088021) | ||||
| 92242 | 92242 | 33912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 665 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 37882 | 6002076.88418057 | 2102621.6953038997 | 37.753515953271496 | -122.435731542402 | (37.7535159532715, -122.435731542402) | ||
| 92497 | 92497 | 99770 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1025x Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 595 Clipper St is true property address | 6001337.9 | 2100792.7 | 37.7484519666196 | -122.438156093062 | (37.7484519666196, -122.438156093062) | |||
| 93052 | 93052 | 107928 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 495 09th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |||
| 93067 | 93067 | 122490 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 69x Bonview St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
| 93201 | 93201 | 113412 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1672 16TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991218.0 | 2103997.0 | 37.7566693908752 | -122.47338384272499 | (37.7566693908752, -122.473383842725) | ||||
| 93352 | 93352 | 112398 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 246 CRESCENT AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6006552.0 | 2095759.0 | 37.7349257177289 | -122.419768681192 | (37.7349257177289, -122.419768681192) | |||||
| 93516 | 93516 | 121154 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50X Trumbull St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778630 | 6003754.0 | 2094198.0 | 37.730481544978794 | -122.429331070998 | (37.7304815449788, -122.429331070998) | |||
| 93562 | 93562 | 110425 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011518.0 | 2097294.0 | 37.7394190054764 | -122.402707291584 | (37.7394190054764, -122.402707291584) | ||||
| 93687 | 93687 | 112450 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 254 CENTRAL AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999892.0 | 2109423.0 | 37.772066299939205 | -122.443775909671 | (37.7720662999392, -122.443775909671) | ||||
| 94216 | 94216 | 100680 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7' wide public RoW | 6002378.0 | 2098199.0 | 37.7413893731095 | -122.434374040118 | (37.7413893731095, -122.434374040118) | |||||
| 94344 | 94344 | 114062 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 3x3 | Permit Number 777118 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | ||
| 94621 | 94621 | 118324 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x TARAVAL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992604.0 | 2099181.0 | 37.7435260562612 | -122.4682402545 | (37.7435260562612, -122.4682402545) | ||||
| 94966 | 94966 | 113130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 95231 | 95231 | 113127 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 95270 | 95270 | 121186 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 95589 | 95589 | 119627 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 El Sereno Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999504.0 | 2097253.0 | 37.738628328633396 | -122.44424333392901 | (37.7386283286334, -122.444243333929) | ||||
| 95654 | 95654 | 112156 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 501 SANCHEZ ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003633.0 | 2105226.0 | 37.7607550226872 | -122.43053597282899 | (37.7607550226872, -122.430535972829) | |||||
| 95751 | 95751 | 110523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775559 | 6001085.0 | 2106026.0 | 37.762806954373104 | -122.439405692132 | (37.7628069543731, -122.439405692132) | |||
| 95894 | 95894 | 107924 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 495 09th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |||
| 95978 | 95978 | 38435 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 950 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40462 | 6003103.32448359 | 2102701.71275072 | 37.7537939125694 | -122.43218760661101 | (37.7537939125694, -122.432187606611) | |||
| 96239 | 96239 | 115665 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 96471 | 96471 | 56770 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 249 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 777118 | 6000646.04543173 | 2102139.76865728 | 37.752111320918495 | -122.440645114373 | (37.7521113209185, -122.440645114373) | |||
| 96661 | 96661 | 110424 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011494.0 | 2097294.0 | 37.739417665451604 | -122.402790273501 | (37.7394176654516, -122.402790273501) | ||||
| 96875 | 96875 | 113665 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1435 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013045.0 | 2106578.0 | 37.7649960058226 | -122.39807870262501 | (37.7649960058226, -122.398078702625) | ||||
| 96955 | 96955 | 41426 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 42033 | 6003639.60917921 | 2104762.31302618 | 37.759482223502395 | -122.430480029002 | (37.7594822235024, -122.430480029002) | ||
| 97056 | 97056 | 89006 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2200 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51758 | 6003287.9 | 2116231.2 | 37.7909530209385 | -122.432515604779 | (37.7909530209385, -122.432515604779) | |||
| 97479 | 97479 | 111154 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 98353 | 98353 | 106558 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1606 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5992507.7 | 2104492.6 | 37.7581047767682 | -122.468959697438 | (37.7581047767682, -122.468959697438) | ||||
| 98436 | 98436 | 110381 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2235 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011689.0 | 2097713.0 | 37.740579036374 | -122.402145495204 | (37.740579036374, -122.402145495204) | ||||
| 98529 | 98529 | 99778 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 492x Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 492-494x Jersey corner property at 845-849 Diamond St | 6001966.3 | 2101499.0 | 37.7504270178067 | -122.43603363507799 | (37.7504270178067, -122.436033635078) | |||
| 98601 | 98601 | 101269 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2240 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988822.0 | 2106507.0 | 37.763422136616 | -122.48185383449301 | (37.763422136616, -122.481853834493) | ||||
| 98813 | 98813 | 106448 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 999 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002658.0 | 2110219.0 | 37.7744092970816 | -122.43426502395701 | (37.7744092970816, -122.434265023957) | |||||
| 98878 | 98878 | 121566 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 740 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004294.0 | 2104553.0 | 37.7589445476691 | -122.42820190474801 | (37.7589445476691, -122.428201904748) | ||||
| 99055 | 99055 | 98374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 100025 | 100025 | 121675 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||||
| 100041 | 100041 | 113128 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 100068 | 100068 | 111158 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 5 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 100581 | 100581 | 108317 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 100877 | 100877 | 34518 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
| 100978 | 100978 | 121192 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 101670 | 101670 | 121384 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 101700 | 101700 | 86749 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 102210 | 102210 | 100310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3899 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996194.7 | 2115482.8 | 37.7884933268854 | -122.457003479054 | (37.7884933268854, -122.457003479054) | |||||
| 102326 | 102326 | 104898 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 310 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 102337 | 102337 | 122407 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 801X Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999408.0 | 2095548.0 | 37.7339413243955 | -122.444452753551 | (37.7339413243955, -122.444452753551) | ||||
| 102571 | 102571 | 101276 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2350 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988480.0 | 2106495.0 | 37.763369292926996 | -122.483035808211 | (37.763369292927, -122.483035808211) | ||||
| 102605 | 102605 | 121181 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 102722 | 102722 | 95195 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 254 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | Permit Number 767109 | 5986864.6 | 2114238.7 | 37.7845371806063 | -122.489192237355 | (37.7845371806063, -122.489192237355) | |||
| 102848 | 102848 | 115367 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 103613 | 103613 | 34289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38080 | 5987074.67438797 | 2114433.79174181 | 37.7850851064396 | -122.488479804204 | (37.7850851064396, -122.488479804204) | ||
| 103706 | 103706 | 34223 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4353 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1997 12:00:00 AM | Permit Number 38036 | 6001597.05586573 | 2101140.27274833 | 37.7494210542971 | -122.43728482259199 | (37.7494210542971, -122.437284822592) | |||
| 104063 | 104063 | 110422 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011337.0 | 2097400.0 | 37.739699951422 | -122.403340568471 | (37.739699951422, -122.403340568471) | ||||
| 104139 | 104139 | 87677 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 651 Upland Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50398 | 5992947.0 | 2094378.0 | 37.7303580257382 | -122.46670519643499 | (37.7303580257382, -122.466705196435) | ||
| 104451 | 104451 | 44044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 15 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2000 12:00:00 AM | 3x3 | Permit Number 52166 | 6007300.39530105 | 2099500.4637239 | 37.7452410789231 | -122.417446281159 | (37.7452410789231, -122.417446281159) | ||
| 104528 | 104528 | 39968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 20 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41229 | 5994642.74946915 | 2095844.31987513 | 37.7344818986137 | -122.460949031683 | (37.7344818986137, -122.460949031683) | |||
| 104617 | 104617 | 121185 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 104770 | 104770 | 108475 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 104788 | 104788 | 121183 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 105114 | 105114 | 113094 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 5725 DIAMOND HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 3x3 | Permit Number 776952 | 6000738.0 | 2097078.0 | 37.7382181444182 | -122.43996421610001 | (37.7382181444182, -122.4399642161) | ||
| 105330 | 105330 | 118323 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992604.0 | 2099181.0 | 37.7435260562612 | -122.4682402545 | (37.7435260562612, -122.4682402545) | ||||
| 105502 | 105502 | 98375 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 105777 | 105777 | 101272 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988629.58103 | 2106495.44667 | 37.763379222306106 | -122.482518495008 | (37.7633792223061, -122.482518495008) | ||||
| 105906 | 105906 | 121628 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 371 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997638.0 | 2093763.0 | 37.7289389875261 | -122.450443518449 | (37.7289389875261, -122.450443518449) | ||||
| 106252 | 106252 | 121596 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 998X Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000144.0 | 2102038.0 | 37.7518032865281 | -122.44237395255101 | (37.7518032865281, -122.442373952551) | ||||
| 106407 | 106407 | 88454 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 106527 | 106527 | 93736 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999812.1 | 2109210.9 | 37.771479369328205 | -122.44403704657 | (37.7714793693282, -122.44403704657) | |||||
| 106634 | 106634 | 121195 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 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) | |||||
| 106817 | 106817 | 55765 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1932 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1973 12:00:00 AM | Permit Number 11801 | 5989775.56943078 | 2106540.70455177 | 37.7635700889575 | -122.478558247096 | (37.7635700889575, -122.478558247096) | |||
| 107126 | 107126 | 85498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 107866 | 107866 | 112769 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 108027 | 108027 | 54458 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4235 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1972 12:00:00 AM | Permit Number 10249 | 6001672.30868862 | 2101726.83398167 | 37.751035889282 | -122.437066586385 | (37.751035889282, -122.437066586385) | |||
| 108137 | 108137 | 110383 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2280 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011419.0 | 2097963.0 | 37.741250408777205 | -122.40309663685801 | (37.7412504087772, -122.403096636858) | ||||
| 108150 | 108150 | 52738 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 108732 | 108732 | 121383 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 108792 | 108792 | 52088 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 533 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48285 | 6003018.90245389 | 2105154.15611633 | 37.7605229492534 | -122.432654727925 | (37.7605229492534, -122.432654727925) | ||||
| 109051 | 109051 | 33491 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 29 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49655 | 6006996.29665496 | 2099574.0262700003 | 37.7454259501675 | -122.418503020578 | (37.7454259501675, -122.418503020578) | |||
| 109172 | 109172 | 101186 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 333 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994765.0 | 2106657.0 | 37.764177821135995 | -122.46130993803499 | (37.764177821136, -122.461309938035) | ||||
| 109300 | 109300 | 97998 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1450 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012865.0 | 2106120.0 | 37.7637284123596 | -122.39866913856501 | (37.7637284123596, -122.398669138565) | ||||
| 109409 | 109409 | 32427 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1901 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | Permit Number 36954 | 6003387.68416895 | 2115217.90617727 | 37.7881764318356 | -122.432097963893 | (37.7881764318356, -122.432097963893) | |||
| 109527 | 109527 | 41271 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 229 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41954 | 5994679.37055115 | 2091871.07942789 | 37.723574453453494 | -122.460534605902 | (37.7235744534535, -122.460534605902) | |||
| 109657 | 109657 | 98303 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 6 Locksley Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 109788 | 109788 | 113131 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 109839 | 109839 | 113123 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) |
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");