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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
73263 | 73263 | 129389 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006655.24817 | 2120043.6921200003 | 37.801611544485205 | -122.421135524881 | (37.8016115444852, -122.421135524881) | |||
74076 | 74076 | 120009 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5986962.570590001 | 2110820.51914 | 37.775157546008 | -122.48860197556101 | (37.775157546008, -122.488601975561) | |||
74889 | 74889 | 227564 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4547 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000867.43951 | 2104613.62235 | 37.7589165280041 | -122.440056874944 | (37.7589165280041, -122.440056874944) | |||
75835 | 75835 | 176894 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 La Grande Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005238.00808 | 2092009.9005900002 | 37.724557410279296 | -122.42404509073201 | (37.7245574102793, -122.424045090732) | |||
104217 | 104217 | 191223 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1112 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012178.19052 | 2103217.19746 | 37.7557196692435 | -122.400840661869 | (37.7557196692435, -122.400840661869) | |||
116434 | 116434 | 227156 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3458 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007201.92693 | 2104423.1326599997 | 37.758752066271704 | -122.41813569949801 | (37.7587520662717, -122.418135699498) | |||
123811 | 123811 | 191221 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014015.897890001 | 2106592.9178299997 | 37.7650909952748 | -122.39472162882099 | (37.7650909952748, -122.394721628821) | |||
129699 | 129699 | 227161 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005575.79788 | 2096114.93647 | 37.73584799837779 | -122.423169051236 | (37.7358479983778, -122.423169051236) | |||
130789 | 130789 | 176890 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 18 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003663.21456 | 2093989.9827 | 37.7299052360341 | -122.429630099158 | (37.7299052360341, -122.429630099158) | |||
131491 | 131491 | 227124 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002026.8924 | 2100876.99711 | 37.74872258759179 | -122.435779604843 | (37.7487225875918, -122.435779604843) | |||
131908 | 131908 | 227583 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002133.89525 | 2108814.30402 | 37.7705225892763 | -122.435977464701 | (37.7705225892763, -122.435977464701) | |||
132341 | 132341 | 227139 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 280 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997445.297590001 | 2106455.57152 | 37.763778642484205 | -122.452025073424 | (37.7637786424842, -122.452025073424) | |||
133135 | 133135 | 227087 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009571.148469999 | 2096096.9094 | 37.736023162027294 | -122.409354219042 | (37.7360231620273, -122.409354219042) | |||
133333 | 133333 | 227144 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997515.89511 | 2105898.72706 | 37.7622537322474 | -122.451740727559 | (37.7622537322474, -122.451740727559) | |||
133488 | 133488 | 118589 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 150 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982275.325019999 | 2112634.79146 | 37.779864376411 | -122.50495040283998 | (37.779864376411, -122.50495040284) | |||
133679 | 133679 | 207045 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 607 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998977.59415 | 2096753.4397599997 | 37.737226608721706 | -122.446027465895 | (37.7372266087217, -122.446027465895) | |||
133925 | 133925 | 227125 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002044.61682 | 2100877.8681799998 | 37.7487259861351 | -122.435718376327 | (37.7487259861351, -122.435718376327) | |||
134344 | 134344 | 206998 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 223 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994252.21923 | 2105280.12164 | 37.7603677459862 | -122.462983582339 | (37.7603677459862, -122.462983582339) | |||
134386 | 134386 | 206992 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 633 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992553.594409999 | 2105897.35752 | 37.761964523762 | -122.468903201544 | (37.761964523762, -122.468903201544) | |||
134651 | 134651 | 207001 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 404 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991538.30054 | 2099790.96979 | 37.7451392685705 | -122.47196959112301 | (37.7451392685705, -122.471969591123) |
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");