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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24033 | 24033 | 189426 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 553 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6013011.23422 | 2104452.4501799997 | 37.759157834075204 | -122.398046364864 | (37.7591578340752, -122.398046364864) | |||
24717 | 24717 | 189454 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 110 Mendell St | 6 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6016981.3442400005 | 2098379.09321 | 37.742701973620704 | -122.38389280032801 | (37.7427019736207, -122.383892800328) | |||
25906 | 25906 | 249410 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 698 Polk St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6007114.554409999 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | |||
25927 | 25927 | 189435 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Mendell St | 4 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6016869.31993 | 2097857.6531700003 | 37.741264011617496 | -122.384243845296 | (37.7412640116175, -122.384243845296) | |||
26081 | 26081 | 249738 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 22 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000189.3449800005 | 2117178.8516 | 37.7933788258243 | -122.443304539972 | (37.7933788258243, -122.443304539972) | |||
26897 | 26897 | 249733 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 17 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6000186.12585 | 2117239.7585400003 | 37.7935458766883 | -122.4433200551 | (37.7935458766883, -122.4433200551) | |||
29429 | 29429 | 176035 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991271.23185 | 2089055.1505099998 | 37.7156459462668 | -122.472110669573 | (37.7156459462668, -122.472110669573) | |||
31686 | 31686 | 189484 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 Garlington Ct | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 8ft | 6016756.63544 | 2094656.7103 | 37.732468633912795 | -122.38441058228399 | (37.7324686339128, -122.384410582284) | |||
31706 | 31706 | 206311 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 145 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 5996946.82319 | 2089129.1768599998 | 37.7161760165962 | -122.45249868787201 | (37.7161760165962, -122.452498687872) | |||
34656 | 34656 | 189434 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Mendell St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6016859.570230001 | 2097844.0874799998 | 37.7412262239015 | -122.384276612087 | (37.7412262239015, -122.384276612087) | |||
37013 | 37013 | 245824 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 35 | Width 5ft | 6006487.65936 | 2109176.30964 | 37.7717629414288 | -122.42094344050899 | (37.7717629414288, -122.420943440509) | |||
37956 | 37956 | 189424 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 630 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6012971.73851 | 2104103.46612 | 37.758197400418 | -122.39815847703998 | (37.758197400418, -122.39815847704) | |||
38069 | 38069 | 206319 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Junipero Serra Blvd | 45 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5991343.42057 | 2093507.86668 | 37.7278761829176 | -122.472185537258 | (37.7278761829176, -122.472185537258) | |||
38225 | 38225 | 189444 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Mendell St | 7 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6017009.92172 | 2098163.28563 | 37.7421109895326 | -122.383778964147 | (37.7421109895326, -122.383778964147) | |||
38521 | 38521 | 247794 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 30th St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6003904.95936 | 2098390.4407200003 | 37.7420015807231 | -122.429107993255 | (37.7420015807231, -122.429107993255) | |||
39654 | 39654 | 189416 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1106 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 23 | Width 6ft | 6012793.60681 | 2102247.59908 | 37.753091670356206 | -122.3986443034 | (37.7530916703562, -122.3986443034) | |||
42228 | 42228 | 176037 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991282.94152 | 2088997.4789 | 37.7154882717346 | -122.472065994874 | (37.7154882717346, -122.472065994874) | |||
42771 | 42771 | 206312 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 137 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5996974.1215 | 2089165.00897 | 37.7162759672427 | -122.452406916553 | (37.7162759672427, -122.452406916553) | |||
44823 | 44823 | 189415 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 611 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6012725.3071 | 2104566.72513 | 37.7594556787682 | -122.39904326513799 | (37.7594556787682, -122.399043265138) | |||
45004 | 45004 | 189443 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Mendell St | 6 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6017001.713769999 | 2098118.43003 | 37.7419873714259 | -122.383804222493 | (37.7419873714259, -122.383804222493) | |||
45014 | 45014 | 189429 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 23rd St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6012179.482000001 | 2102842.19969 | 37.7546900794894 | -122.40080985110001 | (37.7546900794894, -122.4008098511) | |||
47336 | 47336 | 206320 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 700 Junipero Serra Blvd | 102 | : 4 | Tree 1 | Private 1 | 17 | Width 0ft | 5991249.508230001 | 2092024.39965 | 37.7237975164261 | -122.47240209038601 | (37.7237975164261, -122.472402090386) | |||
48672 | 48672 | 250325 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 165 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5987394.93306 | 2114848.62147 | 37.7862427917124 | -122.487402306398 | (37.7862427917124, -122.487402306398) | |||
49797 | 49797 | 189440 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Mendell St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6016970.91119 | 2098020.16133 | 37.741715842721 | -122.383903888062 | (37.741715842721, -122.383903888062) | |||
50895 | 50895 | 189459 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 Keith St | 5 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6017678.6985 | 2096804.16511 | 37.7384160628385 | -122.381372033003 | (37.7384160628385, -122.381372033003) | |||
52497 | 52497 | 189438 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Mendell St | 10 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6016944.89383 | 2097963.47475 | 37.7415587545458 | -122.383989901933 | (37.7415587545458, -122.383989901933) | |||
53044 | 53044 | 189423 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 401 Texas St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 6ft | 6013814.74653 | 2105139.2952099997 | 37.7610884806725 | -122.395315529383 | (37.7610884806725, -122.395315529383) | |||
54878 | 54878 | 189445 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 175 Mendell St | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6017048.162690001 | 2098355.48866 | 37.7426408538865 | -122.383660116015 | (37.7426408538865, -122.383660116015) | |||
57752 | 57752 | 176039 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 10 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991303.11629 | 2088916.85693 | 37.715268070939395 | -122.471990389765 | (37.7152680709394, -122.471990389765) | |||
57860 | 57860 | 189448 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 5 | : 4 | Tree 1 | Private 1 | 27 | Width 4ft | 6017089.46767 | 2098534.02953 | 37.7431333739056 | -122.383529720639 | (37.7431333739056, -122.383529720639) | |||
58604 | 58604 | 247793 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 30th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6003950.6507 | 2098393.2335900003 | 37.7420118356795 | -122.42895020628401 | (37.7420118356795, -122.428950206284) | |||
58779 | 58779 | 189417 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1106 Wisconsin St | 7 | : 4 | Tree 1 | Private 1 | 16 | Width 5ft | 6012797.40104 | 2102195.19485 | 37.7529479910798 | -122.39862750496799 | (37.7529479910798, -122.398627504968) | |||
60969 | 60969 | 247764 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 47 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6001642.78328 | 2108514.72427 | 37.769672105812 | -122.43765476325501 | (37.769672105812, -122.437654763255) | |||
62250 | 62250 | 206313 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 Lakeview Ave | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5996540.854309999 | 2089794.0816099998 | 37.7179784216475 | -122.45394989416701 | (37.7179784216475, -122.453949894167) | |||
68085 | 68085 | 189451 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 110 Mendell St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6016996.37271 | 2098457.91162 | 37.742919223749 | -122.383846322475 | (37.742919223749, -122.383846322475) | |||
69226 | 69226 | 189412 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1088 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6011892.64219 | 2103317.4691 | 37.755979061610105 | -122.401835232927 | (37.7559790616101, -122.401835232927) | |||
69339 | 69339 | 189427 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 535 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 7ft | 6013008.4924 | 2104530.05608 | 37.759370770158604 | -122.39806129180401 | (37.7593707701586, -122.398061291804) | |||
75074 | 75074 | 245825 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6006460.60937 | 2109175.25024 | 37.7717585077816 | -122.421036933125 | (37.7717585077816, -122.421036933125) | |||
75086 | 75086 | 189437 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Mendell St | 9 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6016936.32054 | 2097949.4923099997 | 37.7415198876289 | -122.384018572307 | (37.7415198876289, -122.384018572307) | |||
76993 | 76993 | 189460 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 Keith St | 6 | : 4 | Tree 1 | Private 1 | 23 | Width 3ft | 6017666.55512 | 2096787.33958 | 37.7383691928822 | -122.38141284963999 | (37.7383691928822, -122.38141284964) | |||
114253 | 114253 | 189422 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 499 Texas St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6013831.21065 | 2104873.82242 | 37.7603604659706 | -122.395239989945 | (37.7603604659706, -122.395239989945) | |||
119308 | 119308 | 176036 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991277.56282 | 2089025.3145400002 | 37.715564390347794 | -122.47208661362 | (37.7155643903478, -122.47208661362) | |||
130443 | 130443 | 176033 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991250.41814 | 2089152.61686 | 37.7159123605459 | -122.472189711002 | (37.7159123605459, -122.472189711002) | |||
131898 | 131898 | 189410 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6011803.92975 | 2106016.10898 | 37.7633839768015 | -122.40233176930401 | (37.7633839768015, -122.402331769304) | |||
132878 | 132878 | 246776 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 926 Esmeralda Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6009551.14862 | 2098756.05448 | 37.743323477111794 | -122.40961099258001 | (37.7433234771118, -122.40961099258) | |||
132927 | 132927 | 189455 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 401 Mendell St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6016647.4197 | 2097560.59638 | 37.740436082250206 | -122.384990413878 | (37.7404360822502, -122.384990413878) | |||
133231 | 133231 | 189436 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Mendell St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016883.040519999 | 2097872.31866 | 37.7413050387037 | -122.384197424971 | (37.7413050387037, -122.384197424971) | |||
136241 | 136241 | 249736 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 20 | : 4 | Tree 1 | Private 1 | 27 | Width 3ft | 6000189.43372 | 2117210.1069799997 | 37.793464649935004 | -122.443306478906 | (37.793464649935, -122.443306478906) | |||
137706 | 137706 | 189461 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 Keith St | 8 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6017639.17726 | 2096752.78415 | 37.7382727990439 | -122.381505107496 | (37.7382727990439, -122.381505107496) | |||
149625 | 149625 | 189411 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 632 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6011774.848730001 | 2105417.13705 | 37.7617377102479 | -122.40239023331699 | (37.7617377102479, -122.402390233317) | |||
149788 | 149788 | 189441 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Mendell St | 4 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6016991.418880001 | 2098078.56472 | 37.7418773402717 | -122.38383704416799 | (37.7418773402717, -122.383837044168) | |||
150758 | 150758 | 249737 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 21 | : 4 | Tree 1 | Private 1 | 31 | Width 3ft | 6000190.59568 | 2117194.0821599998 | 37.79342071625479 | -122.443301306923 | (37.7934207162548, -122.443301306923) | |||
151750 | 151750 | 176038 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 9 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991295.02694 | 2088957.62103 | 37.7153795311078 | -122.472021319244 | (37.7153795311078, -122.472021319244) | |||
151898 | 151898 | 245826 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 McCoppin St | 3 | : 4 | Tree 1 | Private 1 | 33 | Width 4ft | 6006425.97269 | 2109173.2697 | 37.7717511171398 | -122.421156603211 | (37.7717511171398, -122.421156603211) | |||
153871 | 153871 | 248805 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Portola Dr | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 0ft | 5999637.979040001 | 2100901.5310400003 | 37.748653963923104 | -122.444042185502 | (37.7486539639231, -122.444042185502) | |||
154539 | 154539 | 249734 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 18 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6000189.35752 | 2117224.43489 | 37.7935039862606 | -122.44330777215299 | (37.7935039862606, -122.443307772153) | |||
155518 | 155518 | 245827 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 McCoppin St | 4 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6006397.79792 | 2109170.0802700003 | 37.77174077135871 | -122.421253835213 | (37.7717407713587, -122.421253835213) | |||
156059 | 156059 | 189442 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Mendell St | 5 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6016996.79512 | 2098099.65565 | 37.741935548886104 | -122.38381992286502 | (37.7419355488861, -122.383819922865) | |||
159585 | 159585 | 176034 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991251.90527 | 2089128.8237400001 | 37.715847116515704 | -122.472182837493 | (37.7158471165157, -122.472182837493) | |||
160909 | 160909 | 206318 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Junipero Serra Blvd | 15 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5991393.593280001 | 2094516.04404 | 37.7306472891369 | -122.47208554522301 | (37.7306472891369, -122.472085545223) | |||
165022 | 165022 | 189447 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6017073.308540001 | 2098474.3541900003 | 37.7429686244012 | -122.38358144152299 | (37.7429686244012, -122.383581441523) | |||
166739 | 166739 | 189439 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Mendell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6016963.00829 | 2098000.2672900003 | 37.741660780830706 | -122.383929828997 | (37.7416607808307, -122.383929828997) | |||
167391 | 167391 | 189450 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 110 Mendell St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6017000.35659 | 2098477.7601099997 | 37.7429739438981 | -122.38383392889601 | (37.7429739438981, -122.383833928896) | |||
170188 | 170188 | 189446 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 175 Mendell St | 3 | : 4 | Tree 1 | Private 1 | 28 | Width 4ft | 6017051.6761 | 2098373.0405099997 | 37.7426892419063 | -122.383649189252 | (37.7426892419063, -122.383649189252) | |||
170601 | 170601 | 189456 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 401 Mendell St | 6 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016666.75535 | 2097590.67014 | 37.740519728201704 | -122.384925652813 | (37.7405197282017, -122.384925652813) | |||
172011 | 172011 | 250333 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 135 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5987387.37303 | 2115049.79038 | 37.786794702950395 | -122.487443244435 | (37.7867947029504, -122.487443244435) | |||
174859 | 174859 | 189453 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 110 Mendell St | 5 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016986.81524 | 2098398.61469 | 37.7427558780826 | -122.383875241966 | (37.7427558780826, -122.383875241966) | |||
176767 | 176767 | 249732 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 16 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6000181.11943 | 2117259.58432 | 37.793600027574 | -122.443338802346 | (37.793600027574, -122.443338802346) | |||
177688 | 177688 | 189413 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 735 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 5ft | 6012747.844930001 | 2104071.66199 | 37.758097599940704 | -122.39893057110399 | (37.7580975999407, -122.398930571104) | |||
177711 | 177711 | 189414 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 735 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6012747.75808 | 2104089.69061 | 37.758147097740796 | -122.39893213680901 | (37.7581470977408, -122.398932136809) | |||
178768 | 178768 | 176032 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991243.83692 | 2089170.5769 | 37.7159612935557 | -122.472213766971 | (37.7159612935557, -122.472213766971) |
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");