Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9887 | 9887 | 51349 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2004 12:00:00 AM | Permit Number 47697 | ||||||||
| 11322 | 11322 | 19745 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 130867 | 130867 | 179477 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5994326.32135 | 2086634.18047 | 37.709174858293295 | -122.461375565754 | (37.7091748582933, -122.461375565754) | ||||
| 56147 | 56147 | 179476 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5994306.081069999 | 2086649.9682200002 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | ||||
| 177290 | 177290 | 179475 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5994292.07601 | 2086663.3492700001 | 37.7092529779255 | -122.46149603531401 | (37.7092529779255, -122.461496035314) | ||||
| 154089 | 154089 | 179456 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 39 Melra Ct | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6008986.48136 | 2086460.78308 | 37.7095316094729 | -122.41069535821501 | (37.7095316094729, -122.410695358215) | |||
| 51527 | 51527 | 179437 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006551.53826 | 2086713.5575599999 | 37.71008885278471 | -122.419128872099 | (37.7100888527847, -122.419128872099) | |||
| 132286 | 132286 | 179436 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006488.6944 | 2086721.59328 | 37.7101073779209 | -122.419346642943 | (37.7101073779209, -122.419346642943) | |||
| 158631 | 158631 | 179435 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006500.6084199995 | 2086740.91409 | 37.710161099825 | -122.41930683535 | (37.710161099825, -122.41930683535) | |||
| 46358 | 46358 | 179434 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006514.55403 | 2086760.1932299999 | 37.710214821715496 | -122.419260003144 | (37.7102148217155, -122.419260003144) | |||
| 51699 | 51699 | 179433 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006535.42412 | 2086786.7518099998 | 37.7102889213719 | -122.419189754426 | (37.7102889213719, -122.419189754426) | |||
| 48306 | 48306 | 179432 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006549.425009999 | 2086808.7283400001 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | |||
| 64098 | 64098 | 44448 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | Permit Number 43777 | 6002641.71413 | 2086935.0699 | 37.710476119736704 | -122.432657792736 | (37.7104761197367, -122.432657792736) | |
| 157586 | 157586 | 179441 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007125.21698 | 2086870.4635 | 37.7105519739575 | -122.417157231746 | (37.7105519739575, -122.417157231746) | |||
| 161232 | 161232 | 179438 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 163 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006665.75653 | 2086898.09687 | 37.7106019906608 | -122.41874718904499 | (37.7106019906608, -122.418747189045) | |||
| 40375 | 40375 | 179440 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | |||
| 163435 | 163435 | 179431 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006605.70519 | 2086910.12298 | 37.7106316305231 | -122.418955592547 | (37.7106316305231, -122.418955592547) | |||
| 54669 | 54669 | 179439 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006794.78813 | 2086912.99237 | 37.7106501547416 | -122.418302281839 | (37.7106501547416, -122.418302281839) | |||
| 73421 | 73421 | 179490 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 117 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002435.0144 | 2087009.1097400002 | 37.7106676924198 | -122.43337747790501 | (37.7106676924198, -122.433377477905) | |||
| 137656 | 137656 | 179491 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 117 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002422.8219800005 | 2087024.8993 | 37.7107103553801 | -122.43342074518101 | (37.7107103553801, -122.433420745181) | |||
| 147404 | 147404 | 69407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 795 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 12 | Permit Number 33511 | 6002413.58939 | 2087078.56796 | 37.7108571939861 | -122.43345648782 | (37.7108571939861, -122.43345648782) | |
| 179328 | 179328 | 179430 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006173.52059 | 2087002.57891 | 37.7108611491941 | -122.42045587934099 | (37.7108611491941, -122.420455879341) | |||
| 26696 | 26696 | 69405 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 11 | Permit Number 33509 | 6002439.0824 | 2087100.62464 | 37.7109192031396 | -122.43336995327 | (37.7109192031396, -122.43336995327) | |
| 173561 | 173561 | 179492 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002448.847080001 | 2087107.83027 | 37.7109395422009 | -122.433336718839 | (37.7109395422009, -122.433336718839) | |||
| 130153 | 130153 | 179493 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6002457.74986 | 2087117.22162 | 37.710965833866 | -122.43330661939899 | (37.710965833866, -122.433306619399) | |||
| 48668 | 48668 | 179445 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006641.641 | 2087043.6428599998 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | |||
| 187434 | 187434 | 179444 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006641.4754 | 2087068.60877 | 37.711068813438395 | -122.418843195273 | (37.7110688134384, -122.418843195273) | |||
| 51882 | 51882 | 179443 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006639.5983 | 2087274.4168099998 | 37.711633813430204 | -122.418864269997 | (37.7116338134302, -122.418864269997) | |||
| 185597 | 185597 | 179442 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006642.58468 | 2087353.9641 | 37.711852401735705 | -122.418859586325 | (37.7118524017357, -122.418859586325) | |||
| 170161 | 170161 | 179449 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006550.96819 | 2087379.45579 | 37.711917237452 | -122.419178046153 | (37.711917237452, -122.419178046153) | |||
| 44932 | 44932 | 179450 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006580.779159999 | 2087379.51909 | 37.7119190900695 | -122.41907501532499 | (37.7119190900695, -122.419075015325) | |||
| 34284 | 34284 | 179448 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006504.268209999 | 2087381.76307 | 37.7119209426602 | -122.419339618327 | (37.7119209426602, -122.419339618327) | |||
| 62271 | 62271 | 179447 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 154 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006213.66342 | 2087416.73528 | 37.712000597419795 | -122.420346512779 | (37.7120005974198, -122.420346512779) | |||
| 167377 | 167377 | 179427 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006362.446930001 | 2087442.7546 | 37.7120804239565 | -122.419834118658 | (37.7120804239565, -122.419834118658) | |||
| 154490 | 154490 | 179428 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006287.8718 | 2087448.27209 | 37.7120913722811 | -122.420092263655 | (37.7120913722811, -122.420092263655) | |||
| 37203 | 37203 | 179446 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006032.90525 | 2087456.2020599998 | 37.712098777304 | -122.42097406600901 | (37.712098777304, -122.420974066009) | |||
| 27661 | 27661 | 179429 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6006237.48001 | 2087456.42565 | 37.712110920858706 | -122.420267010915 | (37.7121109208587, -122.420267010915) | |||
| 187470 | 187470 | 179426 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 6006719.22339 | 2087474.4297099998 | 37.7121874900245 | -122.41860323816401 | (37.7121874900245, -122.418603238164) | |||
| 33568 | 33568 | 179425 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006737.87137 | 2087492.2529799999 | 37.712237478839796 | -122.418540048182 | (37.7122374788398, -122.418540048182) | |||
| 37944 | 37944 | 179455 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1651 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006947.074519999 | 2087492.6533099997 | 37.7122503535477 | -122.417817006765 | (37.7122503535477, -122.417817006765) | |||
| 169589 | 169589 | 179454 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1657 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6006909.47125 | 2087494.6948400002 | 37.71225384290071 | -122.417947119763 | (37.7122538429007, -122.417947119763) | |||
| 184632 | 184632 | 179453 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1657 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6006878.87058 | 2087495.9574900002 | 37.7122555876031 | -122.418052974468 | (37.7122555876031, -122.418052974468) | |||
| 172689 | 172689 | 179451 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1848 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006175.92265 | 2087836.6399400001 | 37.713151440055796 | -122.420506743187 | (37.7131514400558, -122.420506743187) | |||
| 185054 | 185054 | 179452 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1851 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6006040.88882 | 2087844.33942 | 37.71316497035539 | -122.420974012957 | (37.7131649703554, -122.420974012957) | |||
| 143137 | 143137 | 76749 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 158818 | 158818 | 179457 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 949 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 1ft | 6002045.648159999 | 2088406.8974 | 37.714483612097 | -122.434823106621 | (37.714483612097, -122.434823106621) | |||
| 76303 | 76303 | 179474 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 279 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009762.57781 | 2088424.36617 | 37.7149666919301 | -122.408151417155 | (37.7149666919301, -122.408151417155) | |||
| 170220 | 170220 | 179470 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 755 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002483.16702 | 2089112.03412 | 37.716444592826704 | -122.43336122533998 | (37.7164445928267, -122.43336122534) | |||
| 159825 | 159825 | 179469 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 750 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002474.00901 | 2089177.3596700002 | 37.716623442792795 | -122.433397545354 | (37.7166234427928, -122.433397545354) | |||
| 187901 | 187901 | 81053 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 735 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 17 | 6002545.69492 | 2089214.07107 | 37.7167283109449 | -122.43315238479401 | (37.7167283109449, -122.433152384794) | ||
| 37529 | 37529 | 114872 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 735 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6002556.26502 | 2089229.80958 | 37.7167721250182 | -122.43311697309099 | (37.7167721250182, -122.433116973091) | ||||
| 67361 | 67361 | 35126 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.717479145922496 | -122.43602056561001 | (37.7174791459225, -122.43602056561) | |
| 148495 | 148495 | 35125 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 766 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 5 | Permit Number 38660 | 6001731.36417 | 2089519.53162 | 37.7175208097275 | -122.43598896344 | (37.7175208097275, -122.43598896344) | |
| 172386 | 172386 | 35120 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 679 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 11 | Permit Number 38655 | 6001477.30735 | 2089545.09865 | 37.7175765748797 | -122.436868949145 | (37.7175765748797, -122.436868949145) | |
| 154848 | 154848 | 35123 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 752 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 9 | Permit Number 38658 | 6001767.50485 | 2089578.0778 | 37.7176836175692 | -122.435868228557 | (37.7176836175692, -122.435868228557) | |
| 158626 | 158626 | 179458 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6001021.22839 | 2089673.6831200002 | 37.7179037068739 | -122.438454610411 | (37.7179037068739, -122.438454610411) | |||
| 167077 | 167077 | 179459 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001007.64891 | 2089683.17948 | 37.7179290093058 | -122.43850222861201 | (37.7179290093058, -122.438502228612) | |||
| 51841 | 51841 | 179460 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.43853839394698 | (37.7179436214658, -122.438538393947) | |||
| 67398 | 67398 | 179461 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000982.149259999 | 2089697.7577900002 | 37.7179675875255 | -122.43859141348999 | (37.7179675875255, -122.43859141349) | |||
| 158081 | 158081 | 179462 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 90 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000856.84082 | 2089774.2647900002 | 37.7181705294179 | -122.43903002902 | (37.7181705294179, -122.43903002902) | |||
| 65100 | 65100 | 179463 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 90 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000843.6616 | 2089782.45527 | 37.7181922687385 | -122.439076170523 | (37.7181922687385, -122.439076170523) | |||
| 94478 | 94478 | 69541 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 643 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38636 | 6002429.0315791 | 2090033.16165602 | 37.7189707335787 | -122.43361413687 | (37.7189707335787, -122.43361413687) | ||
| 69816 | 69816 | 179464 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001719.613030001 | 2090058.3778400002 | 37.7189996935499 | -122.43606811904199 | (37.7189996935499, -122.436068119042) | |||
| 34575 | 34575 | 179465 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001702.1853 | 2090068.84403 | 37.719027441244705 | -122.43612910838101 | (37.7190274412447, -122.436129108381) | |||
| 78221 | 78221 | 35112 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 91197 | 91197 | 38649 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 117303 | 117303 | 35113 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 119641 | 119641 | 35111 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 127463 | 127463 | 35110 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 54855 | 54855 | 179483 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5988918.9165199995 | 2090347.02209 | 37.7190566943955 | -122.48033574940399 | (37.7190566943955, -122.480335749404) | ||||
| 177442 | 177442 | 179466 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001678.49541 | 2090085.4444 | 37.7190716762026 | -122.43621218234301 | (37.7190716762026, -122.436212182343) | |||
| 50273 | 50273 | 179467 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001663.653519999 | 2090093.9083 | 37.7190940729046 | -122.436264090339 | (37.7190940729046, -122.436264090339) | |||
| 180579 | 180579 | 179484 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5988536.49014 | 2090373.27915 | 37.719106559100396 | -122.48165955597099 | (37.7191065591004, -122.481659555971) | ||||
| 46825 | 46825 | 179482 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5988878.80429 | 2090370.98469 | 37.719120158641296 | -122.48047615337 | (37.7191201586413, -122.48047615337) | ||||
| 30303 | 30303 | 179468 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001647.16213 | 2090105.1251700001 | 37.719123934899294 | -122.436321896962 | (37.7191239348993, -122.436321896962) | |||
| 153866 | 153866 | 179481 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988902.49405 | 2090393.59661 | 37.7191836220039 | -122.480395922129 | (37.7191836220039, -122.480395922129) | ||||
| 167753 | 167753 | 215005 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995603.15885 | 2090386.73113 | 37.7195518880809 | -122.457233926015 | (37.7195518880809, -122.457233926015) | |||
| 158014 | 158014 | 105255 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 162 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004396.67956 | 2090207.02373 | 37.7195595692124 | -122.42682511908801 | (37.7195595692124, -122.426825119088) | |||
| 71861 | 71861 | 179471 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 553 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003207.64888 | 2090265.05426 | 37.7196516076204 | -122.430939303405 | (37.7196516076204, -122.430939303405) | |||
| 176080 | 176080 | 103464 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 543 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x9 | 6003223.19269 | 2090290.89193 | 37.7197234328838 | -122.43088741703698 | (37.7197234328838, -122.430887417037) | |||
| 112904 | 112904 | 114382 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 402X SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 67706 | 67706 | 197576 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1121 Jamestown Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6013293.0543 | 2090118.55817 | 37.7198156565414 | -122.39606716838101 | (37.7198156565414, -122.396067168381) | ||||
| 171132 | 171132 | 197575 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6013269.3073 | 2090137.6242 | 37.719866686770395 | -122.396150589498 | (37.7198666867704, -122.396150589498) | ||||
| 185162 | 185162 | 215003 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 240 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996037.07731 | 2090573.06283 | 37.7200884227106 | -122.45574749866002 | (37.7200884227106, -122.45574749866) | |||
| 161622 | 161622 | 215004 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 240 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996022.14356 | 2090574.2023099998 | 37.7200906944015 | -122.45579920159099 | (37.7200906944015, -122.455799201591) | |||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 187686 | 187686 | 179478 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | ||||
| 100932 | 100932 | 66607 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | ||
| 171956 | 171956 | 179479 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989502.72531 | 2090743.3416900001 | 37.7201787974032 | -122.478346734135 | (37.7201787974032, -122.478346734135) | ||||
| 119916 | 119916 | 114214 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 230 SERRANO DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988981.0 | 2090766.0 | 37.720210710128896 | -122.48015180069099 | (37.7202107101289, -122.480151800691) | ||||
| 168 | 168 | 179480 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5989599.0 | 2090767.0 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | ||||
| 53238 | 53238 | 50628 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.720375661427205 | -122.39176255443 | (37.7203756614272, -122.39176255443) | |||
| 120812 | 120812 | 50629 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.720375661427205 | -122.39176255443 | (37.7203756614272, -122.39176255443) | |||
| 104206 | 104206 | 66239 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548004 | -122.45622531376301 | (37.720469900548, -122.456225313763) | ||
| 131726 | 131726 | 215001 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995907.45606 | 2090967.9456200001 | 37.72116523766171 | -122.45622408896999 | (37.7211652376617, -122.45622408897) | |||
| 82175 | 82175 | 67999 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31724 | 5995906.21686349 | 2090968.00525531 | 37.721165330271795 | -122.456228376798 | (37.7211653302718, -122.456228376798) | ||
| 39386 | 39386 | 215002 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995954.159990001 | 2091115.9744900002 | 37.7215743707347 | -122.45607334462099 | (37.7215743707347, -122.456073344621) | |||
| 187260 | 187260 | 179473 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 890 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011506.9921 | 2090808.93918 | 37.7216117663527 | -122.402289508352 | (37.7216117663527, -122.402289508352) | |||
| 145957 | 145957 | 50422 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 549 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778616 | 5995097.0 | 2091149.0 | 37.721615813455 | -122.459038685652 | (37.721615813455, -122.459038685652) | |
| 52898 | 52898 | 47230 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.5709799998 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) |
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");