Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3788 | 3788 | 118108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3585 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 5984519.42575 | 2111051.46948 | 37.7756488017479 | -122.497070281467 | (37.7756488017479, -122.497070281467) | ||
| 4007 | 4007 | 216655 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 161 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:49:00 PM | 3 | Width 3ft | 5995318.74701 | 2090961.5845400002 | 37.7211139601174 | -122.45825861266 | (37.7211139601174, -122.45825861266) | ||
| 4127 | 4127 | 207021 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 400 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 07:38:00 AM | 3 | Width 3ft | 5995575.229619999 | 2090581.47857 | 37.720085014301894 | -122.457344548018 | (37.7200850143019, -122.457344548018) | ||
| 4130 | 4130 | 216848 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | ||
| 4192 | 4192 | 216845 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.714105005620205 | -122.458764825742 | (37.7141050056202, -122.458764825742) | ||
| 4451 | 4451 | 216718 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.45912417326299 | (37.7196152839906, -122.459124173263) | ||
| 5012 | 5012 | 189150 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 351 Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:46:00 AM | 3 | Width 3ft | 6017356.8528 | 2098625.87133 | 37.7434003277556 | -122.382611554189 | (37.7434003277556, -122.382611554189) | ||
| 5071 | 5071 | 203010 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 351 Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:48:00 AM | 3 | Width 3ft | 6017339.6558 | 2098641.75454 | 37.743442989794005 | -122.38267212263399 | (37.743442989794, -122.382672122634) | ||
| 22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
| 22862 | 22862 | 176910 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009561.38521 | 2094361.93193 | 37.7312587382014 | -122.409265579153 | (37.7312587382014, -122.409265579153) | |||
| 22870 | 22870 | 176911 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009574.07755 | 2094366.6897 | 37.731272513113296 | -122.409222034865 | (37.7312725131133, -122.409222034865) | |||
| 22875 | 22875 | 176912 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009589.47798 | 2094371.19963 | 37.7312857592085 | -122.409169110679 | (37.7312857592085, -122.409169110679) | |||
| 22876 | 22876 | 176913 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009673.25426 | 2094402.8730900001 | 37.7313774208194 | -122.40888171341999 | (37.7313774208194, -122.40888171342) | |||
| 24647 | 24647 | 227111 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.745052125166296 | -122.414033173096 | (37.7450521251663, -122.414033173096) | |||
| 25321 | 25321 | 227575 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001460.70601 | 2108045.90078 | 37.7683744785129 | -122.43825097062 | (37.7683744785129, -122.43825097062) | |||
| 25454 | 25454 | 227130 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999573.3022300005 | 2100550.7346900003 | 37.747687072210105 | -122.44424063169599 | (37.7476870722101, -122.444240631696) | |||
| 25567 | 25567 | 227123 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002011.92527 | 2100876.5046200003 | 37.748720385135705 | -122.43583132576201 | (37.7487203851357, -122.435831325762) | |||
| 25668 | 25668 | 118581 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 104 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982478.43556 | 2112606.9372400003 | 37.7797998443253 | -122.504245701476 | (37.7797998443253, -122.504245701476) | |||
| 26337 | 26337 | 227551 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.75989588789739 | -122.432585790315 | (37.7598958878974, -122.432585790315) | |||
| 26381 | 26381 | 251002 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5981992.43445 | 2112670.6708 | 37.7799462432625 | -122.50593169049299 | (37.7799462432625, -122.505931690493) | |||
| 27138 | 27138 | 206991 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1383 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992691.10596 | 2106043.8640900003 | 37.7623747360262 | -122.468438266429 | (37.7623747360262, -122.468438266429) | |||
| 27360 | 27360 | 191232 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.39882697638201 | (37.7363832218132, -122.398826976382) | |||
| 28609 | 28609 | 227574 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 11 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002707.53405 | 2106779.67068 | 37.764968555288 | -122.43384779545299 | (37.764968555288, -122.433847795453) | |||
| 29103 | 29103 | 227140 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997729.62744 | 2105927.06337 | 37.7623437750648 | -122.45100355509399 | (37.7623437750648, -122.451003555094) | |||
| 29460 | 29460 | 191230 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014739.49892 | 2096121.8776900002 | 37.7363799383901 | -122.391486752132 | (37.7363799383901, -122.391486752132) | |||
| 29931 | 29931 | 129373 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2133 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000002.55629 | 2120892.7221 | 37.8035654727314 | -122.444217840184 | (37.8035654727314, -122.444217840184) | |||
| 31111 | 31111 | 207007 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 127 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993382.1086800005 | 2093854.3174299998 | 37.7289452232334 | -122.465162955333 | (37.7289452232334, -122.465162955333) | |||
| 31319 | 31319 | 176877 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.709910397621705 | -122.396487432357 | (37.7099103976217, -122.396487432357) | |||
| 31459 | 31459 | 227146 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997461.46496 | 2105891.36034 | 37.7622303876487 | -122.45192844846599 | (37.7622303876487, -122.451928448466) | |||
| 32789 | 32789 | 227562 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000777.25512 | 2104640.3736 | 37.7589848458951 | -122.440370692454 | (37.7589848458951, -122.440370692454) | |||
| 33294 | 33294 | 206990 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1383 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992691.68575 | 2106051.40057 | 37.7623954627053 | -122.46843680950501 | (37.7623954627053, -122.468436809505) | |||
| 33440 | 33440 | 176906 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 769 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006512.6379 | 2093630.87617 | 37.7290801395131 | -122.419753817278 | (37.7290801395131, -122.419753817278) | |||
| 34085 | 34085 | 207020 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996253.66444 | 2091441.06295 | 37.722484173480204 | -122.45506152367201 | (37.7224841734802, -122.455061523672) | |||
| 34279 | 34279 | 227550 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003307.61262 | 2104748.70742 | 37.7594260532954 | -122.431627264983 | (37.7594260532954, -122.431627264983) | |||
| 35674 | 35674 | 227569 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 287 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002739.75043 | 2104260.6213 | 37.7580536824469 | -122.43355632787201 | (37.7580536824469, -122.433556327872) | |||
| 35827 | 35827 | 227133 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5999502.6369199995 | 2100390.28597 | 37.7472424869628 | -122.44447345808999 | (37.7472424869628, -122.44447345809) | |||
| 35906 | 35906 | 227555 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4611 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000604.66017 | 2104640.67953 | 37.7589758571809 | -122.440967627376 | (37.7589758571809, -122.440967627376) | |||
| 35959 | 35959 | 118588 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 150 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982305.68238 | 2112631.11012 | 37.779856054488604 | -122.50484511221701 | (37.7798560544886, -122.504845112217) | |||
| 36351 | 36351 | 119164 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981372.52859 | 2109725.62562 | 37.7718235084184 | -122.507857566702 | (37.7718235084184, -122.507857566702) | |||
| 36867 | 36867 | 227143 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997579.79251 | 2105906.80731 | 37.762279577867496 | -122.45152031451 | (37.7622795778675, -122.45152031451) | |||
| 37145 | 37145 | 176886 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 119 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002169.33644 | 2093633.7193099998 | 37.7288423165165 | -122.434769138285 | (37.7288423165165, -122.434769138285) | |||
| 37420 | 37420 | 207024 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997067.34432 | 2090557.5942799998 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | |||
| 38046 | 38046 | 227115 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007890.87999 | 2104550.47449 | 37.75914047177721 | -122.415761992927 | (37.7591404717772, -122.415761992927) | |||
| 38084 | 38084 | 207023 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997061.0236599995 | 2090546.31892 | 37.7200737008175 | -122.452206152789 | (37.7200737008175, -122.452206152789) | |||
| 38228 | 38228 | 227149 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 530 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007719.361409999 | 2095678.5372900001 | 37.734770477458795 | -122.41572699582301 | (37.7347704774588, -122.415726995823) | |||
| 38388 | 38388 | 227552 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002586.755890001 | 2105341.84005 | 37.7610137667981 | -122.43416274071998 | (37.7610137667981, -122.43416274072) | |||
| 38391 | 38391 | 251001 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 232 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5982033.34511 | 2112665.09757 | 37.7799333487875 | -122.505789751407 | (37.7799333487875, -122.505789751407) | |||
| 38399 | 38399 | 129386 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 929 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009490.7484 | 2116033.66261 | 37.7907604245028 | -122.411039958651 | (37.7907604245028, -122.411039958651) | |||
| 39635 | 39635 | 207026 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 229 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994724.722630001 | 2088692.2453700001 | 37.71484874224021 | -122.460147642199 | (37.7148487422402, -122.460147642199) | |||
| 40644 | 40644 | 227097 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009272.782269999 | 2099754.5666099996 | 37.7460495695343 | -122.41064401410601 | (37.7460495695343, -122.410644014106) | |||
| 40740 | 40740 | 129388 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006666.99925 | 2119949.9372900003 | 37.8013547799481 | -122.421088199869 | (37.8013547799481, -122.421088199869) | |||
| 42710 | 42710 | 227127 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000615.36032 | 2102512.03507 | 37.7531317270504 | -122.44077792887501 | (37.7531317270504, -122.440777928875) | |||
| 43893 | 43893 | 117895 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 635 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5984097.32613 | 2111483.29523 | 37.7768097259285 | -122.498562310404 | (37.7768097259285, -122.498562310404) | |||
| 44275 | 44275 | 227553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4445 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001135.34377 | 2105211.25899 | 37.760572740148 | -122.439173173223 | (37.760572740148, -122.439173173223) | |||
| 44951 | 44951 | 227560 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.758750228049294 | -122.44050372379101 | (37.7587502280493, -122.440503723791) | |||
| 45140 | 45140 | 191227 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 201 Texas St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013759.687999999 | 2106121.42545 | 37.763782132758706 | -122.39557476618201 | (37.7637821327587, -122.395574766182) | |||
| 47223 | 47223 | 207040 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996029.169869999 | 2093727.8612799998 | 37.728750294270604 | -122.456002788314 | (37.7287502942706, -122.456002788314) | |||
| 47498 | 47498 | 119083 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | |||
| 48057 | 48057 | 227570 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 287 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002738.3349 | 2104276.75984 | 37.7580979146911 | -122.43356237671101 | (37.7580979146911, -122.433562376711) | |||
| 48273 | 48273 | 227563 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4565 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000806.394180001 | 2104634.53115 | 37.7589704630323 | -122.440269497142 | (37.7589704630323, -122.440269497142) | |||
| 48322 | 48322 | 251000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 226 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5982074.747269999 | 2112660.45291 | 37.7799230326473 | -122.505646180935 | (37.7799230326473, -122.505646180935) | |||
| 48842 | 48842 | 207037 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2642 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990833.84583 | 2097410.6031 | 37.738562605571104 | -122.47423178898501 | (37.7385626055711, -122.474231788985) | |||
| 49701 | 49701 | 191228 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 901 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015254.00871 | 2096807.9147599998 | 37.7382922001146 | -122.38975576401 | (37.7382922001146, -122.38975576401) | |||
| 49815 | 49815 | 191231 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014752.47592 | 2096139.2766099998 | 37.7364284325307 | -122.391443100815 | (37.7364284325307, -122.391443100815) | |||
| 50608 | 50608 | 227132 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999561.91472 | 2100471.96222 | 37.747470132350394 | -122.444274349099 | (37.7474701323504, -122.444274349099) | |||
| 51918 | 51918 | 176909 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1038 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007759.6380900005 | 2093605.48677 | 37.729080594582896 | -122.41544102937401 | (37.7290805945829, -122.415441029374) | |||
| 52110 | 52110 | 227151 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 48 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006822.59734 | 2099508.6280900002 | 37.7452366012942 | -122.419099008325 | (37.7452366012942, -122.419099008325) | |||
| 52735 | 52735 | 176874 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | |||
| 52877 | 52877 | 118595 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | |||
| 53500 | 53500 | 227128 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 248 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004363.9622599995 | 2096949.7405400001 | 37.7380717187222 | -122.427418297528 | (37.7380717187222, -122.427418297528) | |||
| 54346 | 54346 | 227582 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 288 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000368.64642 | 2106819.9498400004 | 37.7649461504603 | -122.44194028911501 | (37.7649461504603, -122.441940289115) | |||
| 55458 | 55458 | 207027 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 43 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997356.5626300005 | 2089224.02458 | 37.716459913666704 | -122.451089274853 | (37.7164599136667, -122.451089274853) | |||
| 55628 | 55628 | 227559 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000741.2761699995 | 2104538.3206 | 37.758702584674204 | -122.44048780488001 | (37.7587025846742, -122.44048780488) | |||
| 55786 | 55786 | 129372 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999985.518069999 | 2120890.75849 | 37.80355910913379 | -122.444276660352 | (37.8035591091338, -122.444276660352) | |||
| 56110 | 56110 | 227546 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4281 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001381.6755099995 | 2101715.76186 | 37.7509889636801 | -122.43807083010401 | (37.7509889636801, -122.438070830104) | |||
| 56440 | 56440 | 117883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5982620.39521 | 2110769.29715 | 37.7747625699566 | -122.503618485147 | (37.7747625699566, -122.503618485147) | |||
| 56558 | 56558 | 207005 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 171 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992787.45104 | 2098017.3287299997 | 37.7403415032629 | -122.467521326669 | (37.7403415032629, -122.467521326669) | |||
| 56726 | 56726 | 227158 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3318 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008087.45284 | 2104471.6208599997 | 37.7589350063619 | -122.415076566546 | (37.7589350063619, -122.415076566546) | |||
| 57061 | 57061 | 227584 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 660 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002549.44678 | 2108867.98451 | 37.7706935809695 | -122.434543909369 | (37.7706935809695, -122.434543909369) | |||
| 57165 | 57165 | 176885 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 191 Rey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008580.05361 | 2087004.5673599998 | 37.7110019335603 | -122.412138452652 | (37.7110019335603, -122.412138452652) | |||
| 57528 | 57528 | 227572 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 841 Church St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004362.062530001 | 2104151.54801 | 37.7578461063327 | -122.42793790601499 | (37.7578461063327, -122.427937906015) | |||
| 58124 | 58124 | 206995 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1584 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993720.55073 | 2104714.02617 | 37.7587827556425 | -122.464781251568 | (37.7587827556425, -122.464781251568) | |||
| 58241 | 58241 | 227081 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 71 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006508.23754 | 2108096.29045 | 37.76879862578671 | -122.420795571254 | (37.7687986257867, -122.420795571254) | |||
| 58669 | 58669 | 118593 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982449.24993 | 2112557.22359 | 37.7796616287576 | -122.504342981812 | (37.7796616287576, -122.504342981812) | |||
| 58837 | 58837 | 227567 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001758.47595 | 2103911.51009 | 37.7570393829676 | -122.43692499579299 | (37.7570393829676, -122.436924995793) | |||
| 58875 | 58875 | 191246 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 22 Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009574.51886 | 2111002.08454 | 37.776949608681 | -122.41039468697599 | (37.776949608681, -122.410394686976) | |||
| 60440 | 60440 | 227159 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 156 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005558.07312 | 2099948.5227 | 37.746373159994505 | -122.423502792335 | (37.7463731599945, -122.423502792335) | |||
| 60679 | 60679 | 207022 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.720036506659206 | -122.452230901246 | (37.7200365066592, -122.452230901246) | |||
| 61434 | 61434 | 227118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005870.45988 | 2099040.93392 | 37.743898754514106 | -122.42235811905701 | (37.7438987545141, -122.422358119057) | |||
| 62607 | 62607 | 207043 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 73 Keystone Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994097.83418 | 2093287.06293 | 37.7274289275879 | -122.46264752636999 | (37.7274289275879, -122.46264752637) | |||
| 62998 | 62998 | 176882 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | |||
| 63496 | 63496 | 227556 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Seward St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | |||
| 64011 | 64011 | 176891 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 128 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004014.42285 | 2094241.1944400002 | 37.730614887467205 | -122.428433829062 | (37.7306148874672, -122.428433829062) | |||
| 65132 | 65132 | 191233 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012545.7197199995 | 2096123.8065400003 | 37.7362632270542 | -122.399071750278 | (37.7362632270542, -122.399071750278) | |||
| 68691 | 68691 | 176904 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 Cambridge St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6006443.50632 | 2094472.10137 | 37.7313860651023 | -122.42005248574499 | (37.7313860651023, -122.420052485745) | |||
| 68947 | 68947 | 176905 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 Cambridge St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6006453.00873 | 2094472.53688 | 37.731387796298705 | -122.420019664972 | (37.7313877962987, -122.420019664972) | |||
| 70354 | 70354 | 207004 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 171 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992803.19794 | 2098037.0989599996 | 37.7403966964551 | -122.46746831791 | (37.7403966964551, -122.46746831791) | |||
| 70932 | 70932 | 119542 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 791 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986618.95807 | 2110548.82595 | 37.7743914964818 | -122.48977060648899 | (37.7743914964818, -122.489770606489) | |||
| 71244 | 71244 | 227084 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1217 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010060.56336 | 2102014.9446799997 | 37.7523002058063 | -122.408079341009 | (37.7523002058063, -122.408079341009) | |||
| 72063 | 72063 | 176879 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 140 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010956.3364 | 2092967.7781599998 | 37.7275087379234 | -122.404344863032 | (37.7275087379234, -122.404344863032) |
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");