trees
6,344 rows where qSpecies_id = 19 sorted by qSiteInfo
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3340 | 192835 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 5 | : | Tree | Private 2 | 1 | Width 2ft | 6013082.87743 | 2113319.47205 | 37.7835086710412 | -122.398420759824 | (37.7835086710412, -122.398420759824) | 6 | 2 | 9 | 28856 | 6 | |||
4277 | 192886 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Rizal St | 7 | : | Tree | Private 2 | 9 | Width 3ft | 6012771.99776 | 2112717.29257 | 37.7818379024256 | -122.399453999917 | (37.7818379024256, -122.399453999917) | 6 | 2 | 9 | 28856 | 34 | |||
5051 | 192939 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1559 Howard St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6007881.70364 | 2109409.76028 | 37.7724824224706 | -122.416137872687 | (37.7724824224706, -122.416137872687) | 8 | 2 | 9 | 28853 | 19 | |||
6531 | 192922 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6009195.26787 | 2109094.7407 | 37.7716912222994 | -122.411571845561 | (37.7716912222994, -122.411571845561) | 8 | 2 | 9 | 28853 | 34 | |||
6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
7077 | 208685 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Margaret Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997050.0175 | 2089737.60379 | 37.7178525273547 | -122.452185875792 | (37.7178525273547, -122.452185875792) | 9 | 8 | 6 | 28861 | 24 | |||
7439 | 193102 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1298 Fairfax Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6017232.41157 | 2097031.5064 | 37.7390156480633 | -122.382930908836 | (37.7390156480633, -122.382930908836) | 10 | 3 | 8 | 58 | 1 | |||
8353 | 246952 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6003390.88605 | 2107111.412 | 37.7659181907902 | -122.43150793845 | (37.7659181907902, -122.43150793845) | 15 | 5 | 5 | 28862 | 3 | |||
10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
10827 | 193103 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1360 Fairfax Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6016766.03407 | 2097379.43395 | 37.7399452071057 | -122.384567672275 | (37.7399452071057, -122.384567672275) | 10 | 3 | 8 | 58 | 1 | |||
13283 | 192880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Rizal St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012900.3156 | 2112837.75427 | 37.7821758137123 | -122.399018534684 | (37.7821758137123, -122.399018534684) | 6 | 2 | 9 | 28856 | 34 | |||
13928 | 193037 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 Evans Ave | 5 | : | Tree | Private 2 | 6 | Width 4ft | 6013937.10901 | 2099755.21268 | 37.7463117498036 | -122.394515309055 | (37.7463117498036, -122.394515309055) | 10 | 3 | 8 | 58 | 1 | |||
14160 | 192815 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 666 Harrison St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013604.81597 | 2113227.29521 | 37.7832846364215 | -122.396608578241 | (37.7832846364215, -122.396608578241) | 6 | 2 | 9 | 28856 | 6 | |||
14782 | 193113 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1918 Palou Ave | 1 | : | Tree | Private 2 | 18 | Width 6ft | 6013201.37448 | 2096537.6402 | 37.7374360437463 | -122.396833869195 | (37.7374360437463, -122.396833869195) | 10 | 3 | 8 | 58 | 1 | |||
17654 | 192866 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Bonifacio St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012577.4953 | 2112746.88061 | 37.7819083013788 | -122.400128970773 | (37.7819083013788, -122.400128970773) | 6 | 2 | 9 | 28856 | 34 | |||
17737 | 192824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 362 03rd St | 2 | : | Tree | Private 2 | 8 | Width 4ft | 6013311.51298 | 2113082.94966 | 37.7828719690123 | -122.397613169532 | (37.7828719690123, -122.397613169532) | 6 | 2 | 9 | 28856 | 6 | |||
19497 | 193116 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1771 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014627.24242 | 2096799.70603 | 37.7382348845319 | -122.391922256922 | (37.7382348845319, -122.391922256922) | 10 | 3 | 8 | 58 | 1 | |||
20528 | 192852 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Harrison St | 3 | : | Tree | Private 2 | 11 | Width 4ft | 6013259.76509 | 2112901.11062 | 37.7823697992588 | -122.397779437985 | (37.7823697992588, -122.397779437985) | 6 | 2 | 9 | 28856 | 34 | |||
21151 | 192843 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 360 03rd St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6013195.7856 | 2113103.52845 | 37.782922028866 | -122.398014984804 | (37.782922028866, -122.398014984804) | 6 | 2 | 9 | 28856 | 34 | |||
21434 | 192883 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Rizal St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6012844.29072 | 2112783.62554 | 37.7820240665994 | -122.399208556033 | (37.7820240665994, -122.399208556033) | 6 | 2 | 9 | 28856 | 34 | |||
22735 | 193066 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 25 | : | Tree | Private 2 | 4 | Width 4ft | 6015154.4129 | 2098847.09569 | 37.7438858474558 | -122.390242547283 | (37.7438858474558, -122.390242547283) | 10 | 3 | 8 | 58 | 1 | |||
23333 | 193069 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 28 | : | Tree | Private 2 | 2 | Width 4ft | 6015210.26637 | 2098805.13987 | 37.7437737433553 | -122.390046486977 | (37.7437737433553, -122.390046486977) | 10 | 3 | 8 | 58 | 1 | |||
23658 | 250652 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 El Camino Del Mar | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5986706.54079 | 2115175.99151 | 37.7871014859956 | -122.489808017137 | (37.7871014859956, -122.489808017137) | 11 | 6 | 1 | 55 | 33 | |||
23756 | 192946 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 251 11th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008468.79915 | 2109228.50432 | 37.7720177292585 | -122.414094219087 | (37.7720177292585, -122.414094219087) | 8 | 2 | 9 | 28853 | 34 | |||
24358 | 192926 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 355 11th St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6008735.42255 | 2108959.44166 | 37.7712939180009 | -122.4131529158 | (37.7712939180009, -122.4131529158) | 8 | 2 | 9 | 28853 | 34 | |||
25725 | 192834 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 4 | : | Tree | Private 2 | 10 | Width 2ft | 6013085.07263 | 2113314.8696 | 37.7834961560649 | -122.398412842187 | (37.7834961560649, -122.398412842187) | 6 | 2 | 9 | 28856 | 6 | |||
26060 | 192839 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 9 | : | Tree | Private 2 | 13 | Width 2ft | 6013010.639 | 2113396.71282 | 37.7837167318802 | -122.398676100719 | (37.7837167318802, -122.398676100719) | 6 | 2 | 9 | 28856 | 6 | |||
28618 | 208686 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 207 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997054.66762 | 2089435.45045 | 37.7170231509855 | -122.452148013432 | (37.7170231509855, -122.452148013432) | 9 | 8 | 6 | 28861 | 24 | |||
29094 | 250763 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 234 32nd Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5985904.69407 | 2114338.51574 | 37.7847551691681 | -122.492520492032 | (37.7847551691681, -122.492520492032) | 11 | 6 | 1 | 55 | 33 | |||
29180 | 193062 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 12 | : | Tree | Private 2 | 1 | Width 4ft | 6014912.02528 | 2099027.76176 | 37.7443684713257 | -122.391093299634 | (37.7443684713257, -122.391093299634) | 10 | 3 | 8 | 58 | 1 | |||
29603 | 250656 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 El Camino Del Mar | 5 | : | Tree | Private 2 | 5 | Width 3ft | 5986684.51912 | 2115099.84858 | 37.7868911336549 | -122.489878604042 | (37.7868911336549, -122.489878604042) | 11 | 6 | 1 | 55 | 33 | |||
29628 | 246954 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6003427.52152 | 2107112.99896 | 37.7659246245513 | -122.431381337294 | (37.7659246245513, -122.431381337294) | 15 | 5 | 5 | 28862 | 3 | |||
29638 | 192912 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1140 Harrison St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6010461.05328 | 2110227.87987 | 37.7748734805741 | -122.407273287627 | (37.7748734805741, -122.407273287627) | 8 | 2 | 9 | 28853 | 34 | |||
29674 | 193022 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1675 Bay Shore Blvd | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6012164.65845 | 2090962.85285 | 37.7220710717127 | -122.400026921111 | (37.7220710717127, -122.400026921111) | 10 | 3 | 8 | 58 | 1 | |||
30796 | 193064 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 23 | : | Tree | Private 2 | 3 | Width 4ft | 6015121.07948 | 2098872.18165 | 37.7439528793244 | -122.390359559858 | (37.7439528793244, -122.390359559858) | 10 | 3 | 8 | 58 | 1 | |||
31334 | 201664 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1525 Howard St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6007823.01458 | 2109336.46365 | 37.7722778671731 | -122.416335692048 | (37.7722778671731, -122.416335692048) | 8 | 2 | 9 | 28853 | 19 | |||
32396 | 192908 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 320 04th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012351.36508 | 2112670.90236 | 37.7816870717535 | -122.400905941866 | (37.7816870717535, -122.400905941866) | 6 | 2 | 9 | 28856 | 34 | |||
32471 | 250764 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 240 32nd Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5985906.39488 | 2114315.3934 | 37.78469178135 | -122.492512904459 | (37.78469178135, -122.492512904459) | 11 | 6 | 1 | 55 | 33 | |||
33282 | 192989 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1800 22nd St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012647.29831 | 2103801.45456 | 37.7573500663676 | -122.399259338965 | (37.7573500663676, -122.399259338965) | 10 | 3 | 8 | 28856 | 29 | |||
35615 | 229284 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 995 Potrero Ave | 13 | : | Tree | Private 2 | 12 | Width 4ft | 6010501.02754 | 2104377.47084 | 37.758811828913 | -122.406722619264 | (37.758811828913, -122.406722619264) | 10 | 4 | 8 | 28859 | 19 | |||
36099 | 192830 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 335 03rd St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6013155.18585 | 2113245.64816 | 37.7833099955036 | -122.398165418018 | (37.7833099955036, -122.398165418018) | 6 | 2 | 9 | 28856 | 6 | |||
36934 | 192895 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6012493.15526 | 2112622.67802 | 37.7815625668946 | -122.400412023417 | (37.7815625668946, -122.400412023417) | 6 | 2 | 9 | 28856 | 34 | |||
37013 | 193088 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1445 Fairfax Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016353.82584 | 2097602.79871 | 37.7405357172446 | -122.386008496795 | (37.7405357172446, -122.386008496795) | 10 | 3 | 8 | 58 | 1 | |||
37553 | 193086 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 53 | : | Tree | Private 2 | 3 | Width 4ft | 6015572.85588 | 2098535.43446 | 37.7430532910692 | -122.388773903118 | (37.7430532910692, -122.388773903118) | 10 | 3 | 8 | 58 | 1 | |||
37663 | 192817 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 666 Harrison St | 3 | : | Tree | Private 2 | 6 | Width 2ft | 6013574.47554 | 2113201.19226 | 37.7832112751171 | -122.396711714281 | (37.7832112751171, -122.396711714281) | 6 | 2 | 9 | 28856 | 6 | |||
37984 | 229266 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 38 Dolores St | 6 | : | Tree | Private 2 | 5 | Width 4ft | 6004742.17766 | 2107969.73857 | 37.7683514450924 | -122.426895232935 | (37.7683514450924, -122.426895232935) | 8 | 4 | 5 | 28862 | 3 | |||
38497 | 192818 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 666 Harrison St | 4 | : | Tree | Private 2 | 9 | Width 2ft | 6013551.18814 | 2113179.89404 | 37.7831514989732 | -122.39679078627 | (37.7831514989732, -122.39679078627) | 6 | 2 | 9 | 28856 | 6 | |||
38579 | 192872 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Bonifacio St | 7 | : | Tree | Private 2 | 11 | Width 3ft | 6012734.45034 | 2112896.95633 | 37.7823291247251 | -122.399596515494 | (37.7823291247251, -122.399596515494) | 6 | 2 | 9 | 28856 | 34 | |||
39169 | 192879 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 728 Lapu-lapu St | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6012902.0489 | 2112866.77625 | 37.7822555979573 | -122.399014575862 | (37.7822555979573, -122.399014575862) | 6 | 2 | 9 | 28856 | 34 | |||
39797 | 193106 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 70 Reddy St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6013577.9178 | 2093886.35961 | 37.7301771244662 | -122.395346296097 | (37.7301771244662, -122.395346296097) | 10 | 3 | 8 | 58 | 1 | |||
39928 | 192945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 238 11th St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6008246.27864 | 2109382.40713 | 37.7724278093356 | -122.414874831504 | (37.7724278093356, -122.414874831504) | 8 | 2 | 9 | 28853 | 19 | |||
40209 | 193100 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1224 Fairfax Ave | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6017433.94384 | 2096880.5876 | 37.7386123884484 | -122.382223599248 | (37.7386123884484, -122.382223599248) | 10 | 3 | 8 | 58 | 1 | |||
40435 | 192833 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 3 | : | Tree | Private 2 | 9 | Width 2ft | 6013092.9638 | 2113309.01212 | 37.7834805123665 | -122.398385130489 | (37.7834805123665, -122.398385130489) | 6 | 2 | 9 | 28856 | 6 | |||
40782 | 250331 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 149 27th Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5987389.174 | 2114970.73519 | 37.7865777451115 | -122.487431204304 | (37.7865777451115, -122.487431204304) | 11 | 6 | 1 | 55 | 33 | |||
41327 | 193049 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 10 | : | Tree | Private 2 | 5 | Width 4ft | 6013830.70731 | 2099917.50727 | 37.7467514607167 | -122.394894600811 | (37.7467514607167, -122.394894600811) | 10 | 3 | 8 | 58 | 1 | |||
41960 | 193087 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 54 | : | Tree | Private 2 | 4 | Width 4ft | 6015589.76226 | 2098523.56065 | 37.7430216250434 | -122.38871461621 | (37.7430216250434, -122.38871461621) | 10 | 3 | 8 | 58 | 1 | |||
43271 | 193072 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 37 | : | Tree | Private 2 | 3 | Width 4ft | 6015318.00876 | 2098725.46335 | 37.7435609430974 | -122.389668372422 | (37.7435609430974, -122.389668372422) | 10 | 3 | 8 | 58 | 1 | |||
44338 | 218303 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 26 Ardenwood Way | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5991253.24799 | 2096255.67247 | 37.7354157473276 | -122.472697526668 | (37.7354157473276, -122.472697526668) | 1 | 8 | 4 | 29491 | 40 | |||
44438 | 192893 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012513.76951 | 2112597.17547 | 37.781493692331 | -122.400338915735 | (37.781493692331, -122.400338915735) | 6 | 2 | 9 | 28856 | 34 | |||
45044 | 229264 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 38 Dolores St | 3 | : | Tree | Private 2 | 4 | Width 4ft | 6004739.88387 | 2108012.00754 | 37.7684673758072 | -122.426906177704 | (37.7684673758072, -122.426906177704) | 8 | 4 | 5 | 28862 | 3 | |||
45080 | 192837 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 7 | : | Tree | Private 2 | 10 | Width 2ft | 6013024.05275 | 2113381.05786 | 37.7836744943121 | -122.398628594958 | (37.7836744943121, -122.398628594958) | 6 | 2 | 9 | 28856 | 6 | |||
45709 | 193052 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1998 Evans Ave | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6013779.11033 | 2099954.16592 | 37.7468492484883 | -122.395075586663 | (37.7468492484883, -122.395075586663) | 10 | 3 | 8 | 58 | 1 | |||
46222 | 192861 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Tandang Sora St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6012660.44398 | 2112633.52461 | 37.7816016766273 | -122.399834042619 | (37.7816016766273, -122.399834042619) | 6 | 2 | 9 | 28856 | 34 | |||
48390 | 193098 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1301 Fairfax Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6017070.0677 | 2097067.7936 | 37.7391063141074 | -122.383494750497 | (37.7391063141074, -122.383494750497) | 10 | 3 | 8 | 58 | 1 | |||
48812 | 193038 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 Evans Ave | 6 | : | Tree | Private 2 | 3 | Width 4ft | 6013953.00674 | 2099743.1247 | 37.7462794425459 | -122.394459489924 | (37.7462794425459, -122.394459489924) | 10 | 3 | 8 | 58 | 1 | |||
50419 | 193058 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 6 | : | Tree | Private 2 | 3 | Width 4ft | 6014802.29213 | 2099111.00932 | 37.7445909618204 | -122.391478555688 | (37.7445909618204, -122.391478555688) | 10 | 3 | 8 | 58 | 1 | |||
50884 | 192849 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 360 03rd St | 7 | : | Tree | Private 2 | 20 | Width 4ft | 6013299.00683 | 2113002.29943 | 37.7826498256627 | -122.397650777387 | (37.7826498256627, -122.397650777387) | 6 | 2 | 9 | 28856 | 34 | |||
51181 | 192902 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 6012374.35004 | 2112745.30883 | 37.7818926567515 | -122.400831653372 | (37.7818926567515, -122.400831653372) | 6 | 2 | 9 | 28856 | 34 | |||
51976 | 192850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Harrison St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6013292.46207 | 2112933.49299 | 37.7824605345748 | -122.397668592052 | (37.7824605345748, -122.397668592052) | 6 | 2 | 9 | 28856 | 34 | |||
52567 | 193041 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6013966.95235 | 2099815.66783 | 37.7464794059188 | -122.394416345849 | (37.7464794059188, -122.394416345849) | 10 | 3 | 8 | 58 | 1 | |||
53069 | 192870 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Bonifacio St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6012683.76908 | 2112852.4055 | 37.7822039732728 | -122.399768722152 | (37.7822039732728, -122.399768722152) | 6 | 2 | 9 | 28856 | 34 | |||
53469 | 89163 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 370 03rd St | 2 | : | Tree | Private 2 | 16 | 6013087.00779 | 2113212.84696 | 37.7832161332673 | -122.398398986344 | (37.7832161332673, -122.398398986344) | 6 | 2 | 9 | 28856 | 34 | ||||
53764 | 192899 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012418.61732 | 2112699.39911 | 37.7817690683228 | -122.400675281958 | (37.7817690683228, -122.400675281958) | 6 | 2 | 9 | 28856 | 34 | |||
53983 | 193042 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6013950.14435 | 2099829.5265 | 37.7465165245336 | -122.394475436714 | (37.7465165245336, -122.394475436714) | 10 | 3 | 8 | 58 | 1 | |||
54632 | 192875 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 728 Lapu-lapu St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012822.51355 | 2112951.00409 | 37.7824824357628 | -122.39929564908 | (37.7824824357628, -122.39929564908) | 6 | 2 | 9 | 28856 | 34 | |||
55182 | 192900 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012408.05161 | 2112714.42759 | 37.7818097437594 | -122.400712890689 | (37.7818097437594, -122.400712890689) | 6 | 2 | 9 | 28856 | 34 | |||
57238 | 193050 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 11 | : | Tree | Private 2 | 5 | Width 4ft | 6013815.46024 | 2099929.58477 | 37.7467837751701 | -122.394948169817 | (37.7467837751701, -122.394948169817) | 10 | 3 | 8 | 58 | 1 | |||
57581 | 192877 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 728 Lapu-lapu St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6012854.99086 | 2112916.15992 | 37.7823885717151 | -122.399180844332 | (37.7823885717151, -122.399180844332) | 6 | 2 | 9 | 28856 | 34 | |||
58677 | 193077 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 42 | : | Tree | Private 2 | 4 | Width 4ft | 6015396.678 | 2098666.74648 | 37.7434040806449 | -122.389392251751 | (37.7434040806449, -122.389392251751) | 10 | 3 | 8 | 58 | 1 | |||
59199 | 193071 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 36 | : | Tree | Private 2 | 2 | Width 4ft | 6015306.71167 | 2098734.27336 | 37.743584507126 | -122.389708050508 | (37.743584507126, -122.389708050508) | 10 | 3 | 8 | 58 | 1 | |||
59481 | 229269 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 38 Dolores St | 12 | : | Tree | Private 2 | 7 | Width 8ft | 6004746.92065 | 2107892.75948 | 37.7681403472227 | -122.426873344349 | (37.7681403472227, -122.426873344349) | 8 | 4 | 5 | 28862 | 3 | |||
59899 | 192987 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1138 Rhode Island St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011904.54265 | 2103105.19492 | 37.7553968674749 | -122.401779156588 | (37.7553968674749, -122.401779156588) | 10 | 3 | 8 | 28856 | 29 | |||
59970 | 192993 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 330 Texas St | 1 | : | Tree | Private 2 | 8 | Width 5ft | 6013734.90002 | 2105525.98972 | 37.7621458181058 | -122.395618779909 | (37.7621458181058, -122.395618779909) | 10 | 3 | 8 | 28856 | 29 | |||
61076 | 250549 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 El Camino Del Mar | 4 | : | Tree | Private 2 | 5 | Width 4ft | 5988226.07592 | 2115370.2073 | 37.7877233528047 | -122.484565076625 | (37.7877233528047, -122.484565076625) | 11 | 6 | 1 | 55 | 33 | |||
63403 | 193081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 46 | : | Tree | Private 2 | 2 | Width 4ft | 6015460.55021 | 2098619.62663 | 37.7432782402895 | -122.389168106536 | (37.7432782402895, -122.389168106536) | 10 | 3 | 8 | 58 | 1 | |||
64247 | 250657 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 El Camino Del Mar | 6 | : | Tree | Private 2 | 5 | Width 3ft | 5986677.32576 | 2115081.37781 | 37.7868399982255 | -122.489902132082 | (37.7868399982255, -122.489902132082) | 11 | 6 | 1 | 55 | 33 | |||
65332 | 192943 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1533 Howard St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6008003.15875 | 2109539.87326 | 37.7728465102806 | -122.415726960735 | (37.7728465102806, -122.415726960735) | 8 | 2 | 9 | 28853 | 19 | |||
65677 | 192911 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301 05th St | 3 | : | Tree | Private 2 | 12 | Width 3ft | 6011692.64733 | 2112143.38335 | 37.7802018620657 | -122.403147689129 | (37.7802018620657, -122.403147689129) | 6 | 2 | 9 | 28856 | 34 | |||
65952 | 192855 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Harrison St | 6 | : | Tree | Private 2 | 15 | Width 3ft | 6013228.24652 | 2112870.41378 | 37.7822837575417 | -122.397886325118 | (37.7822837575417, -122.397886325118) | 6 | 2 | 9 | 28856 | 34 | |||
66138 | 193068 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 27 | : | Tree | Private 2 | 3 | Width 4ft | 6015191.89273 | 2098818.78077 | 37.7438101793908 | -122.390110971958 | (37.7438101793908, -122.390110971958) | 10 | 3 | 8 | 58 | 1 | |||
66638 | 229283 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 995 Potrero Ave | 12 | : | Tree | Private 2 | 11 | Width 4ft | 6010503.18066 | 2104324.48808 | 37.7586664705949 | -122.406711438881 | (37.7586664705949, -122.406711438881) | 10 | 4 | 8 | 28859 | 19 | |||
67031 | 193065 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 24 | : | Tree | Private 2 | 3 | Width 4ft | 6015136.33147 | 2098860.3413 | 37.7439212142076 | -122.390305994442 | (37.7439212142076, -122.390305994442) | 10 | 3 | 8 | 58 | 1 | |||
67525 | 192950 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 141 11th St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6007810.98495 | 2109926.25105 | 37.7738966072661 | -122.416419087064 | (37.7738966072661, -122.416419087064) | 8 | 2 | 9 | 28853 | 34 | |||
69331 | 193101 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1224 Fairfax Ave | 5 | : | Tree | Private 2 | 2 | Width 4ft | 6017385.96084 | 2096915.0483 | 37.7387043603066 | -122.382391900165 | (37.7387043603066, -122.382391900165) | 10 | 3 | 8 | 58 | 1 | |||
69953 | 192942 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1533 Howard St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6007987.06108 | 2109523.80239 | 37.7728014785278 | -122.415781506437 | (37.7728014785278, -122.415781506437) | 8 | 2 | 9 | 28853 | 19 | |||
70423 | 192823 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 362 03rd St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6013325.53363 | 2113068.99128 | 37.782834423221 | -122.39756368431 | (37.782834423221, -122.39756368431) | 6 | 2 | 9 | 28856 | 6 | |||
72253 | 192820 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 674 Harrison St | 2 | : | Tree | Private 2 | 9 | Width 4ft | 6013445.43171 | 2113084.79207 | 37.782884483969 | -122.397149992603 | (37.782884483969, -122.397149992603) | 6 | 2 | 9 | 28856 | 6 | |||
72903 | 192827 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 341 03rd St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6013185.42154 | 2113213.12947 | 37.7832223907512 | -122.398058531772 | (37.7832223907512, -122.398058531772) | 6 | 2 | 9 | 28856 | 6 | |||
73947 | 192829 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 335 03rd St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6013168.06225 | 2113231.71323 | 37.7832724506027 | -122.398119892546 | (37.7832724506027, -122.398119892546) | 6 | 2 | 9 | 28856 | 6 | |||
74161 | 193112 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1820 Palou Ave | 8 | : | Tree | Private 2 | 9 | Width 3ft | 6013561.21677 | 2096268.15006 | 37.7367161022686 | -122.395570841543 | (37.7367161022686, -122.395570841543) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );