6,344 rows where qSpecies_id = 19 sorted by qSiteInfo

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);