94 rows where qSpecies_id = 246

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)
2830 83442 DPW Maintained 1 Morus alba :: White Mulberry 246 1234 Indiana St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015021.96112 2102736.57451 37.7545581912273 -122.390972325512 (37.7545581912273, -122.390972325512) 10 3 8 28856 29
4212 194023 DPW Maintained 1 Morus alba :: White Mulberry 246 2101x Carroll Ave 3 Median : Yard Tree DPW 1     7 Width 10ft   6011438 2093954 37.730243602254 -122.40274906803 (37.730243602254, -122.40274906803) 10 3 8 58 1
6221 194026 DPW Maintained 1 Morus alba :: White Mulberry 246 2600x Quint St 2 Median : Yard Tree DPW 1     12 Width 10ft   6011404 2093896 37.7300824479221 -122.402862533607 (37.7300824479221, -122.402862533607) 10 3 8 58 1
8059 10110 DPW Maintained 1 Morus alba :: White Mulberry 246 808 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 2X2   6005630.36176 2104174.06161 37.7579795935988 -122.423553193031 (37.7579795935988, -122.423553193031) 2 4 5 28859 19
8693 67277 DPW Maintained 1 Morus alba :: White Mulberry 246 38 Ina Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1992 12:00:00 AM 8   Permit Number 30751 6004996.43401 2091681.03501 37.7236407753743 -122.424856795417 (37.7236407753743, -122.424856795417) 9 7 6 28861 5
9606 83471 DPW Maintained 1 Morus alba :: White Mulberry 246 1234 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015019.97978 2102790.27149 37.7547055217667 -122.390982930335 (37.7547055217667, -122.390982930335) 10 3 8 28856 29
9970 232278 DPW Maintained 1 Morus alba :: White Mulberry 246 1200 Florida St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009479.82714 2101963.48982 37.7521263893307 -122.410083995494 (37.7521263893307, -122.410083995494) 2 4 7 28859 19
9984 194027 DPW Maintained 1 Morus alba :: White Mulberry 246 2600x Quint St 1 Median : Yard Tree DPW 1     14     6011404 2093896 37.7300824479221 -122.402862533607 (37.7300824479221, -122.402862533607) 10 3 8 58 1
12999 38424 DPW Maintained 1 Morus alba :: White Mulberry 246 1451 Jackson St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/24/2005 12:00:00 AM 12 3x3 Permit Number 48015 6007280.79709 2117415.82487 37.7944313239892 -122.418784361633 (37.7944313239892, -122.418784361633) 5 1 10 28858 32
13214 210460 DPW Maintained 1 Morus alba :: White Mulberry 246 561 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5993762.16547 2090903.72978 37.720865535901 -122.463635023349 (37.720865535901, -122.463635023349) 9 8 6 64 24
13243 194024 DPW Maintained 1 Morus alba :: White Mulberry 246 2101x Carroll Ave 2 Median : Yard Tree DPW 1     8 Width 10ft   6011438 2093954 37.730243602254 -122.40274906803 (37.730243602254, -122.40274906803) 10 3 8 58 1
15583 232270 DPW Maintained 1 Morus alba :: White Mulberry 246 81 Aztec St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6007869.14872 2099607.83193 37.7455678728707 -122.415487222165 (37.7455678728707, -122.415487222165) 2 7 7 28859 2
16203 87742 Permitted Site 7 Morus alba :: White Mulberry 246 1725 Mason St   Sidewalk: Curb side : Cutout Tree Private 2   05/27/2008 12:00:00 AM   3x3 Permit Number 50405 6009154 2119215 37.7994767072274 -122.412430063534 (37.7994767072274, -122.412430063534) 3 1 10 308 32
17441 194025 DPW Maintained 1 Morus alba :: White Mulberry 246 2101x Carroll Ave 1 Median : Yard Tree DPW 1     12 Width 10ft   6011438 2093954 37.730243602254 -122.40274906803 (37.730243602254, -122.40274906803) 10 3 8 58 1
17908 83469 DPW Maintained 1 Morus alba :: White Mulberry 246 1234 Indiana St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015022.26073 2102751.40023 37.7545989161252 -122.390972325505 (37.7545989161252, -122.390972325505) 10 3 8 28856 29
18126 177793 DPW Maintained 1 Morus alba :: White Mulberry 246 163 Sears St 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 4ft   5996220.07429 2086479.78244 37.7088597295732 -122.454819354255 (37.7088597295732, -122.454819354255) 9 7 6 28861 25
18650 83470 DPW Maintained 1 Morus alba :: White Mulberry 246 1234 Indiana St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015020.56031 2102775.64578 37.7546653948924 -122.390979900528 (37.7546653948924, -122.390979900528) 10 3 8 28856 29
20898 107670 DPW Maintained 1 Morus alba :: White Mulberry 246 1900 Noriega St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5987961.4849 2103092.5821 37.7539969916819 -122.484579575666 (37.7539969916819, -122.484579575666) 1 8 3 56 35
21684 232280 DPW Maintained 1 Morus alba :: White Mulberry 246 1148 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008039.65102 2101246.56607 37.7500770520288 -122.415013618501 (37.7500770520288, -122.415013618501) 2 4 7 28859 19
21794 194020 DPW Maintained 1 Morus alba :: White Mulberry 246 1100x Bay Shore Blvd 1 Median : Yard Tree DPW 1     6     6011361.40113 2093925.29225 37.7301604996095 -122.403011863611 (37.7301604996095, -122.403011863611) 10 3 8 58 1
22334 210461 DPW Maintained 1 Morus alba :: White Mulberry 246 454 Vernon St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   5992502.66992 2090868.80614 37.7206969903517 -122.467986141245 (37.7206969903517, -122.467986141245) 9 8 6 64 24
27718 138326 DPW Maintained 1 Morus alba :: White Mulberry 246 2351 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6002239.8975 2114676.642 37.7866251181614 -122.43603035801 (37.7866251181614, -122.43603035801) 13 6 1 29490 27
28241 18566 DPW Maintained 1 Morus alba :: White Mulberry 246 2601 Quint St 2 Median : Cutout Tree DPW 1     12 30   6011470.1242736 2093943.2690186 37.7302159308055 -122.402637255155 (37.7302159308055, -122.402637255155) 10 3 8 58 1
29388 18569 DPW Maintained 1 Morus alba :: White Mulberry 246 2601 Quint St 5 Median : Cutout Tree DPW 1     12 30   6011470.1242736 2093943.2690186 37.7302159308055 -122.402637255155 (37.7302159308055, -122.402637255155) 10 3 8 58 1
29596 18565 DPW Maintained 1 Morus alba :: White Mulberry 246 2601 Quint St 1 Median : Cutout Tree DPW 1     12 30   6011470.1242736 2093943.2690186 37.7302159308055 -122.402637255155 (37.7302159308055, -122.402637255155) 10 3 8 58 1
30004 18568 DPW Maintained 1 Morus alba :: White Mulberry 246 2601 Quint St 4 Median : Cutout Tree DPW 1     12 30   6011470.1242736 2093943.2690186 37.7302159308055 -122.402637255155 (37.7302159308055, -122.402637255155) 10 3 8 58 1
30019 62457 DPW Maintained 1 Morus alba :: White Mulberry 246 2315 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/1985 12:00:00 AM 11   Permit Number 22624 6002391.1262 2114697.6684 37.7866914414939 -122.435508648849 (37.7866914414939, -122.435508648849) 13 6 1 29490 27
31264 210458 DPW Maintained 1 Morus alba :: White Mulberry 246 424 Lansdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5995940.75095 2096379.78487 37.736026759335 -122.456500147565 (37.736026759335, -122.456500147565) 9 7 4 59 40
32200 232283 DPW Maintained 1 Morus alba :: White Mulberry 246 4100 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003137.9122 2101273.37817 37.7498740039775 -122.431966009045 (37.7498740039775, -122.431966009045) 2 4 5 28862 22
33366 131686 DPW Maintained 1 Morus alba :: White Mulberry 246 1 Lech Walesa St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6007270.00039 2111396.78961 37.7779039170718 -122.418394735756 (37.7779039170718, -122.418394735756) 7 9 9 28852 36
34541 210459 DPW Maintained 1 Morus alba :: White Mulberry 246 424 Lansdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5995967.85458 2096379.90991 37.7360286586861 -122.456406449023 (37.7360286586861, -122.456406449023) 9 7 4 59 40
39229 87765 Permitted Site 7 Morus alba :: White Mulberry 246 1190 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50452 6003184 2101303 37.7499579512392 -122.43180875015 (37.7499579512392, -122.43180875015) 2 4 5 28862 22
42349 131688 DPW Maintained 1 Morus alba :: White Mulberry 246 1 Lech Walesa St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6007293.63847 2111399.0461 37.7779114434823 -122.418313123168 (37.7779114434823, -122.418313123168) 7 9 9 28852 36
42820 45793 DPW Maintained 1 Morus alba :: White Mulberry 246 692 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2001 12:00:00 AM 5   Permit Number 44429 5988193.54068 2111311.44505 37.7765772450507 -122.484379841651 (37.7765772450507, -122.484379841651) 11 6 2 55 26
43464 21558 DPW Maintained 1 Morus alba :: White Mulberry 246 1412 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6005799.92368 2114876.18513 37.7873746172933 -122.423727709161 (37.7873746172933, -122.423727709161) 13 9 1 28858 41
47241 20143 DPW Maintained 1 Morus alba :: White Mulberry 246 1001 Steiner St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002909.699 2111732.2561 37.7785786048512 -122.433502515354 (37.7785786048512, -122.433502515354) 15 9 11 29490 41
50110 232277 DPW Maintained 1 Morus alba :: White Mulberry 246 403 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008961.56494 2106269.82598 37.7639215492745 -122.412180555288 (37.7639215492745, -122.412180555288) 8 4 7 28859 19
52052 131687 DPW Maintained 1 Morus alba :: White Mulberry 246 1 Lech Walesa St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6007281.82357 2111398.11347 37.7779082176289 -122.418353929016 (37.7779082176289, -122.418353929016) 7 9 9 28852 36
53020 244484 DPW Maintained 1 Morus alba :: White Mulberry 246 1132 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6001132.987 2109365.8265 37.7719800208097 -122.439479147653 (37.7719800208097, -122.439479147653) 15 5 11 29492 9
53521 232271 DPW Maintained 1 Morus alba :: White Mulberry 246 280 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006686.77202 2104506.42191 37.7589517499387 -122.419923255877 (37.7589517499387, -122.419923255877) 2 4 7 28859 19
55492 177795 DPW Maintained 1 Morus alba :: White Mulberry 246 1750 Silliman St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   6005632.62776 2092784.64911 37.7267069725232 -122.422735972795 (37.7267069725232, -122.422735972795) 9 7 7 309 5
58022 107669 DPW Maintained 1 Morus alba :: White Mulberry 246 1900 Noriega St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5987990.3757 2103092.5821 37.7539986740988 -122.48447966563 (37.7539986740988, -122.48447966563) 1 8 3 56 35
58085 110681 DPW Maintained 1 Morus alba :: White Mulberry 246 629-629 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009862.5018 2120183.9316 37.8021768884293 -122.410046825162 (37.8021768884293, -122.410046825162) 3 1 10 308 23
58775 131685 DPW Maintained 1 Morus alba :: White Mulberry 246 1 Lech Walesa St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6007255.4261 2111395.52249 37.7778996174228 -122.418445063593 (37.7778996174228, -122.418445063593) 7 9 9 28852 36
59209 232272 DPW Maintained 1 Morus alba :: White Mulberry 246 839 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5998014.51464 2107314.70557 37.7661701952309 -122.450118263368 (37.7661701952309, -122.450118263368) 15 5 11 29492 9
59659 194019 DPW Maintained 1 Morus alba :: White Mulberry 246 518 Missouri St 2 Front Yard : Yard Tree Private 2     12     6013511.70466 2104505.67729 37.7593318457093 -122.396319216854 (37.7593318457093, -122.396319216854) 10 3 8 28856 29
59908 107667 DPW Maintained 1 Morus alba :: White Mulberry 246 1795X 26th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5988112.0464 2103109.2392 37.7540514944142 -122.484060125922 (37.7540514944142, -122.484060125922) 1 8 3 56 35
68214 131689 DPW Maintained 1 Morus alba :: White Mulberry 246 1725 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009149.40571 2119207.06431 37.7994546599641 -122.412445400231 (37.7994546599641, -122.412445400231) 3 1 10 308 32
70169 24473 DPW Maintained 1 Morus alba :: White Mulberry 246 2601 Quint St 7 Median : Cutout Tree DPW 1     6 30   6011470.1242736 2093943.2690186 37.7302159308055 -122.402637255155 (37.7302159308055, -122.402637255155) 10 3 8 58 1
72408 232285 DPW Maintained 1 Morus alba :: White Mulberry 246 176 Caselli Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000119.84362 2104895.57648 37.7596481165895 -122.442662647959 (37.7596481165895, -122.442662647959) 2 4 5 28862 3
72699 250008 DPW Maintained 1 Morus alba :: White Mulberry 246 1400 Sutter St 1 : Tree Private 2     8 Width 4ft   6005838.32743 2114881.30266 37.7873908365554 -122.423595203977 (37.7873908365554, -122.423595203977) 13 9 1 28858 41
73256 210466 DPW Maintained 1 Morus alba :: White Mulberry 246 280 Joost Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 7ft   6000199.29519 2094972.3823 37.7324059304931 -122.441675716677 (37.7324059304931, -122.441675716677) 9 7 5 63 40
78608 232284 DPW Maintained 1 Morus alba :: White Mulberry 246 10 Hancock St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004159.16327 2105131.45822 37.7605252262879 -122.428709469487 (37.7605252262879, -122.428709469487) 2 4 5 28862 3
79851 94940 Significant Tree 6 Morus alba :: White Mulberry 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
83414 112857 Undocumented 4 Morus alba :: White Mulberry 246 325 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004103 2109906 37.7736317861426 -122.429244173156 (37.7736317861426, -122.429244173156) 7 9 11 29492 10
84679 194028 DPW Maintained 1 Morus alba :: White Mulberry 246 100 Thornton Ave 3 : Tree Private 2     6 Width 3ft   6014251.11098 2094105.28371 37.7308156638043 -122.393034273107 (37.7308156638043, -122.393034273107) 10 3 8 58 1
87259 232268 DPW Maintained 1 Morus alba :: White Mulberry 246 325 Webster St 1 : Tree Private 2     11 Width 4ft   6004132.28551 2109906.84113 37.7736357535302 -122.429142930101 (37.7736357535302, -122.429142930101) 7 9 11 29492 10
89558 37425 Permitted Site 7 Morus alba :: White Mulberry 246 1220 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/2004 12:00:00 AM 3   Permit Number 46209 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
90784 24472 DPW Maintained 1 Morus alba :: White Mulberry 246 2601 Quint St 6 Median : Cutout Tree DPW 1     12 30   6011470.1242736 2093943.2690186 37.7302159308055 -122.402637255155 (37.7302159308055, -122.402637255155) 10 3 8 58 1
92077 63954 Permitted Site 7 Morus alba :: White Mulberry 246 1190 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50452 6003180.68182674 2101306.86326954 37.7499683707717 -122.431820500362 (37.7499683707717, -122.431820500362) 2 4 5 28862 22
94296 57552 DPW Maintained 1 Morus alba :: White Mulberry 246 2331 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1976 12:00:00 AM 10   Permit Number 16415 6002327.7772 2114689.5813 37.7866656382657 -122.435727242093 (37.7866656382657, -122.435727242093) 13 6 1 29490 27
98521 194022 DPW Maintained 1 Morus alba :: White Mulberry 246 1100x Bay Shore Blvd 3 Median : Yard Tree DPW 1     15 Width 8ft   6011349.26404 2093964.05992 37.7302662697704 -122.403056549132 (37.7302662697704, -122.403056549132) 10 3 8 58 1
100748 232273 DPW Maintained 1 Morus alba :: White Mulberry 246 75 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 1ft   6007246.69075 2099036.46617 37.7439640237173 -122.417599102825 (37.7439640237173, -122.417599102825) 2 7 7 28859 2
102254 131684 DPW Maintained 1 Morus alba :: White Mulberry 246 1 Lech Walesa St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6007238.05252 2111391.96305 37.7778888660035 -122.418504912586 (37.7778888660035, -122.418504912586) 7 9 9 28852 36
102747 210463 DPW Maintained 1 Morus alba :: White Mulberry 246 2129 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5990978.21419 2100912.5324 37.7481863632097 -122.473988066409 (37.7481863632097, -122.473988066409) 1 8 4 29491 40
103526 232281 DPW Maintained 1 Morus alba :: White Mulberry 246 1220 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003187.58809 2101154.07276 37.7495492354259 -122.431785710257 (37.7495492354259, -122.431785710257) 2 4 5 28862 22
104036 210465 DPW Maintained 1 Morus alba :: White Mulberry 246 100 Burlwood Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5996976.62234 2096022.80941 37.7351060073224 -122.452892983942 (37.7351060073224, -122.452892983942) 9 7 4 59 40
104074 97028 Property Tree 8 Morus alba :: White Mulberry 246 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
105168 138589 DPW Maintained 1 Morus alba :: White Mulberry 246 1755 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999515.9722 2114977.7895 37.7872968667368 -122.445476107363 (37.7872968667368, -122.445476107363) 15 6 1 29490 31
108883 177794 DPW Maintained 1 Morus alba :: White Mulberry 246 215 Hanover St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5999988.36852 2086659.05798 37.7095674186707 -122.441808500678 (37.7095674186707, -122.441808500678) 9 7 6 28861 5
109082 131682 DPW Maintained 1 Morus alba :: White Mulberry 246 711 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006185.50869 2112590.36227 37.7811200680844 -122.422231200431 (37.7811200680844, -122.422231200431) 7 9 11 28852 41
109685 232269 DPW Maintained 1 Morus alba :: White Mulberry 246 205 Webster St 1 : Tree Private 2     8 Width 3ft   6004179.30553 2109564.57422 37.7726986338574 -122.428955873814 (37.7726986338574, -122.428955873814) 7 9 11 29492 10
110711 24474 DPW Maintained 1 Morus alba :: White Mulberry 246 2601 Quint St 8 Median : Cutout Tree DPW 1     6 30   6011470.1242736 2093943.2690186 37.7302159308055 -122.402637255155 (37.7302159308055, -122.402637255155) 10 3 8 58 1
118502 98120 DPW Maintained 1 Morus alba :: White Mulberry 246 2315 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2     10   Permit Number 22624 6002407.3003 2114699.2858 37.7866968010579 -122.435452806157 (37.7866968010579, -122.435452806157) 13 6 1 29490 27
122821 210464 DPW Maintained 1 Morus alba :: White Mulberry 246 2129 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5990979.86513 2100893.52159 37.7481342600987 -122.473980970755 (37.7481342600987, -122.473980970755) 1 8 4 29491 40
127541 32319 DPW Maintained 1 Morus alba :: White Mulberry 246 3337 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1996 12:00:00 AM 4   Permit Number 36887 6009058.28296 2099264.2906 37.7446913513286 -122.411351097987 (37.7446913513286, -122.411351097987) 2 7 7 28859 2
128006 232275 DPW Maintained 1 Morus alba :: White Mulberry 246 1245 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009261.78031 2101912.44906 37.7519740189863 -122.410834432979 (37.7519740189863, -122.410834432979) 2 4 7 28859 19
131890 27103 DPW Maintained 1 Morus alba :: White Mulberry 246 639 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 2X3   6005568.41512 2093570.66729 37.728861582695 -122.42301379677 (37.728861582695, -122.42301379677) 9 7 6 28861 5
132057 7819 DPW Maintained 1 Morus alba :: White Mulberry 246 725X Franklin St 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6006180.4164359 2112609.8884573 37.7811733949931 -122.422250204818 (37.7811733949931, -122.422250204818) 7 9 11 28852 41
133191 94939 Significant Tree 6 Morus alba :: White Mulberry 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
136655 232282 DPW Maintained 1 Morus alba :: White Mulberry 246 4100 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003160.19824 2101276.91196 37.749884970338 -122.431889195226 (37.749884970338, -122.431889195226) 2 4 5 28862 22
142511 18567 DPW Maintained 1 Morus alba :: White Mulberry 246 2601 Quint St 3 Median : Cutout Tree DPW 1     6 30   6011470.1242736 2093943.2690186 37.7302159308055 -122.402637255155 (37.7302159308055, -122.402637255155) 10 3 8 58 1
143133 131683 DPW Maintained 1 Morus alba :: White Mulberry 246 711 Franklin St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6006192.513 2112535.78491 37.7809706070586 -122.422203090327 (37.7809706070586, -122.422203090327) 7 9 11 28852 41
144050 94941 Significant Tree 6 Morus alba :: White Mulberry 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
150827 194029 DPW Maintained 1 Morus alba :: White Mulberry 246 800 19th St 11 Sidewalk: Property side : Yard Tree Private 2     1 Width 10ft   6015046.68674 2105336.26967 37.7616977686576 -122.39106851251 (37.7616977686576, -122.39106851251) 10 3 8 28856 29
153630 232274 DPW Maintained 1 Morus alba :: White Mulberry 246 69 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 1ft   6007265.90809 2099069.65818 37.7440562428938 -122.417535005439 (37.7440562428938, -122.417535005439) 2 7 7 28859 2
154424 232276 DPW Maintained 1 Morus alba :: White Mulberry 246 610 Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008600.72188 2096457.71779 37.7369594444245 -122.41273488572 (37.7369594444245, -122.41273488572) 10 7 7 28859 2
154789 194021 DPW Maintained 1 Morus alba :: White Mulberry 246 1100x Bay Shore Blvd 2 Median : Yard Tree DPW 1     11     6011358.20125 2093944.86355 37.730214059626 -122.403024302127 (37.730214059626, -122.403024302127) 10 3 8 58 1
162702 21563 DPW Maintained 1 Morus alba :: White Mulberry 246 1450 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6005662.55853 2114856.43275 37.7873126270251 -122.424201559266 (37.7873126270251, -122.424201559266) 13 9 1 28858 41
170829 248133 DPW Maintained 1 Morus alba :: White Mulberry 246 145 Rutledge St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6010276.17076 2099483.26291 37.7453608336496 -122.407155291201 (37.7453608336496, -122.407155291201) 2 7 7 28859 2
172406 7817 DPW Maintained 1 Morus alba :: White Mulberry 246 725X Franklin St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6006180.4164359 2112609.8884573 37.7811733949931 -122.422250204818 (37.7811733949931, -122.422250204818) 7 9 11 28852 41
174981 210462 DPW Maintained 1 Morus alba :: White Mulberry 246 454 Vernon St 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   5992502.3983 2090855.89171 37.7206615147909 -122.46798614126 (37.7206615147909, -122.46798614126) 9 8 6 64 24
178769 210467 DPW Maintained 1 Morus alba :: White Mulberry 246 280 Joost Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 7ft   6000153.13143 2094974.30877 37.732408589771 -122.441835453352 (37.732408589771, -122.441835453352) 9 7 5 63 40
191934 248134 DPW Maintained 1 Morus alba :: White Mulberry 246 145 Rutledge St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6010298.29704 2099474.19696 37.7453371787691 -122.407078142862 (37.7453371787691, -122.407078142862) 2 7 7 28859 2

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