trees
7,322 rows where qSpecies_id = 1 sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
200 | 10663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.7756317694487 | -122.432267067771 | (37.7756317694487, -122.432267067771) | 15 | 9 | 11 | 29492 | 10 | ||
617 | 241734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 161 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004159.0543 | 2107968.96381 | 37.7683163292566 | -122.428912146976 | (37.7683163292566, -122.428912146976) | 7 | 9 | 5 | 28862 | 3 | |||
897 | 136834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2189 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003723.70254 | 2116916.18398 | 37.7928585158644 | -122.43105665684 | (37.7928585158644, -122.43105665684) | 13 | 9 | 1 | 29490 | 27 | |||
1073 | 108979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3298 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2017 12:00:00 AM | 3 | 3x3 | 6001360.79576 | 2119668.58087 | 37.800281699894 | -122.43942979746 | (37.800281699894, -122.43942979746) | 13 | 9 | 1 | 57 | 17 | ||
1080 | 169338 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1029 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2019 12:00:00 AM | 3 | Width 4ft | 6006781.41851 | 2114264.09095 | 37.7857493130165 | -122.420288474132 | (37.7857493130165, -122.420288474132) | 13 | 9 | 9 | 28858 | 36 | ||
1267 | 244161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 441 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004421.3191 | 2109776.7375 | 37.7732948782123 | -122.428133844936 | (37.7732948782123, -122.428133844936) | 7 | 9 | 11 | 28852 | 10 | |||
1551 | 260493 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
1557 | 33639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 440 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 5 | Permit Number 37734 | 6005272.3664 | 2110799.1387 | 37.7761502580876 | -122.425262720434 | (37.7761502580876, -122.425262720434) | 7 | 9 | 11 | 28852 | 10 | |
4362 | 72167 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2157 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5999876.34149 | 2120874.18187 | 37.8035073648317 | -122.444653277524 | (37.8035073648317, -122.444653277524) | 13 | 9 | 1 | 57 | 17 | |||
4368 | 262109 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 340 Oak St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6005374.8248 | 2110307.1287 | 37.7748051060186 | -122.424873276976 | (37.7748051060186, -122.424873276976) | 7 | 9 | 11 | 28852 | 10 | ||||
4712 | 39418 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
4714 | 138839 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 680 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004061.0808 | 2111069.2221 | 37.7768233350725 | -122.429472148942 | (37.7768233350725, -122.429472148942) | 7 | 9 | 11 | 28852 | 10 | |||
4767 | 40166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3031 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | 8 | 6x6 | Permit Number 41359 | 6004240.20521 | 2119600.37832 | 37.8002578795473 | -122.429461041019 | (37.8002578795473, -122.429461041019) | 13 | 9 | 1 | 57 | 17 |
4886 | 141434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 511 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6005350.2266 | 2110949.2548 | 37.7765668387099 | -122.425004063889 | (37.7765668387099, -122.425004063889) | 7 | 9 | 11 | 28852 | 10 | |||
5090 | 72166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2164 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5999887.26115 | 2120921.40259 | 37.8036376433293 | -122.444618885675 | (37.8036376433293, -122.444618885675) | 13 | 9 | 1 | 57 | 17 | |||
5298 | 16892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 311 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2011 12:00:00 AM | 6 | 3X3 | 6005385.8444 | 2110257.3545 | 37.7746690605587 | -122.424831616025 | (37.7746690605587, -122.424831616025) | 7 | 9 | 11 | 28852 | 10 | ||
5520 | 66956 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2253 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1992 12:00:00 AM | 18 | 4x4 | Permit Number 30287 | 6003206.54821 | 2116495.06774 | 37.7916729207242 | -122.432815936723 | (37.7916729207242, -122.432815936723) | 13 | 9 | 1 | 29490 | 27 | |
5649 | 136764 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003765.13271 | 2119380.44822 | 37.7996270995734 | -122.43108927166 | (37.7996270995734, -122.43108927166) | 13 | 9 | 1 | 57 | 17 | |||
5739 | 52729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2015 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/2006 12:00:00 AM | 5 | Permit Number 48785 | 6003207.48866 | 2119256.92944 | 37.7992563342625 | -122.433010091366 | (37.7992563342625, -122.433010091366) | 13 | 9 | 1 | 57 | 17 | |
5918 | 103690 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 147 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 775299 | 6001175.90706 | 2121214.18027 | 37.804514981434 | -122.440180480455 | (37.804514981434, -122.440180480455) | 13 | 9 | 1 | 57 | 17 | ||
6672 | 39412 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
6711 | 62157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2158 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22272 | 5999899.60106 | 2120922.78087 | 37.8036421318499 | -122.444576282063 | (37.8036421318499, -122.444576282063) | 13 | 9 | 1 | 57 | 17 | |
7078 | 62154 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2016 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 12 | Permit Number 22268 | 5999531.33121 | 2121219.56404 | 37.8044359975872 | -122.445872051358 | (37.8044359975872, -122.445872051358) | 13 | 9 | 1 | 57 | 17 | |
7240 | 62150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2033 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 11 | Permit Number 22264 | 5999463.73231 | 2121165.54346 | 37.8042838116209 | -122.446102094357 | (37.8042838116209, -122.446102094357) | 13 | 9 | 1 | 57 | 17 | |
7279 | 12251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 512 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2014 12:00:00 AM | 3 | 3X3 | 6005037.9059 | 2110678.2828 | 37.77580516874 | -122.426065177531 | (37.77580516874, -122.426065177531) | 7 | 9 | 11 | 28852 | 10 | ||
7675 | 260491 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
7867 | 62156 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2165 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 9 | Permit Number 22270 | 5999843.40545 | 2120869.57146 | 37.8034928263957 | -122.444766922157 | (37.8034928263957, -122.444766922157) | 13 | 9 | 1 | 57 | 17 | |
7999 | 62155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2252 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 13 | Permit Number 22269 | 5999444.38711 | 2120859.49312 | 37.8034423753191 | -122.446147011887 | (37.8034423753191, -122.446147011887) | 13 | 9 | 1 | 57 | 17 | |
8300 | 62006 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1985 12:00:00 AM | 7 | Permit Number 22075 | 6004472.06597 | 2120817.82099 | 37.8036137870071 | -122.428745548466 | (37.8036137870071, -122.428745548466) | 13 | 9 | 1 | 28858 | 17 | |
8895 | 260492 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
9383 | 245841 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 340 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6005374.8248 | 2110307.1287 | 37.7748051060186 | -122.424873276976 | (37.7748051060186, -122.424873276976) | 7 | 9 | 11 | 28852 | 10 | |||
10039 | 62160 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2129 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22275 | 6000012.6105 | 2120894.62285 | 37.8035712652717 | -122.444183183902 | (37.8035712652717, -122.444183183902) | 13 | 9 | 1 | 57 | 17 | |
10070 | 7833 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 880 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6006176.68475 | 2113023.80022 | 37.7823096849858 | -122.42229253147 | (37.7823096849858, -122.42229253147) | 7 | 9 | 11 | 28852 | 41 | |||
10487 | 260490 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
11402 | 83501 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1915 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50771 | 6005502.6509 | 2116836.33115 | 37.7927399024791 | -122.424895720767 | (37.7927399024791, -122.424895720767) | 13 | 9 | 1 | 28858 | 27 | |
11724 | 81872 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3132 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003807.91186 | 2119539.89269 | 37.8000673168179 | -122.430952625964 | (37.8000673168179, -122.430952625964) | 13 | 9 | 1 | 57 | 17 | |||
12002 | 140489 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1386 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6003444.7967 | 2112460.3153 | 37.7806080189367 | -122.431703403536 | (37.7806080189367, -122.431703403536) | 15 | 9 | 11 | 29490 | 41 | |||
12024 | 66137 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3248 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/1990 12:00:00 AM | 5 | Permit Number 29200 | 5999873.32355 | 2119767.07624 | 37.8004673775197 | -122.444584102586 | (37.8004673775197, -122.444584102586) | 13 | 9 | 1 | 57 | 17 | |
12230 | 107510 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2141 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001605.27547 | 2119726.96625 | 37.8004559210497 | -122.438587988867 | (37.8004559210497, -122.438587988867) | 13 | 9 | 1 | 57 | 17 | ||
12342 | 25 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 736 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/1995 12:00:00 AM | 0 | 6003903.5250844 | 2107767.6234363 | 37.7677490306877 | -122.429781635515 | (37.7677490306877, -122.429781635515) | 7 | 9 | 5 | 28862 | 3 | |||
12582 | 32159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
12608 | 136833 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2189 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003703.80591 | 2116912.36582 | 37.7928469047218 | -122.431125227456 | (37.7928469047218, -122.431125227456) | 13 | 9 | 1 | 29490 | 27 | |||
13273 | 4537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/1994 12:00:00 AM | 12 | 3X3 | 6004884.4780546 | 2113657.3543136 | 37.7839762927328 | -122.426808129214 | (37.7839762927328, -122.426808129214) | 7 | 9 | 11 | 28858 | 41 | ||
13356 | 248669 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2018 12:00:00 AM | 3 | 2x | 6004700.21888 | 2110347.50884 | 37.7748778530593 | -122.427209756419 | (37.7748778530593, -122.427209756419) | 7 | 9 | 11 | 28852 | 10 | ||
13447 | 6878 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/28/1994 12:00:00 AM | 6 | 3X3 | 6006200.5661 | 2110766.80377 | 37.7761138687045 | -122.422049524766 | (37.7761138687045, -122.422049524766) | 7 | 9 | 11 | 28852 | 10 | ||
14740 | 248670 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 477 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2018 12:00:00 AM | 3 | Width 2ft | 6004723.7133 | 2110351.25176 | 37.7748894588255 | -122.427128750898 | (37.7748894588255, -122.427128750898) | 7 | 9 | 11 | 28852 | 10 | ||
15266 | 62148 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2040 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 11 | Permit Number 22262 | 5999472.96679 | 2121211.62683 | 37.8044108714347 | -122.446073454522 | (37.8044108714347, -122.446073454522) | 13 | 9 | 1 | 57 | 17 | |
15442 | 48410 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2701X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2002 12:00:00 AM | 4 | Permit Number 45790 | 5999879.07462 | 2118793.03652 | 37.7977932524078 | -122.444494158697 | (37.7977932524078, -122.444494158697) | 13 | 9 | 1 | 57 | 17 | |
15925 | 244208 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 417 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004573.463 | 2109795.1498 | 37.7733540408522 | -122.42760887026 | (37.7733540408522, -122.42760887026) | 7 | 9 | 11 | 28852 | 10 | |||
16066 | 260290 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1029 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2019 12:00:00 AM | 3 | Width 4ft | 6006781.41851 | 2114264.09095 | 37.7857493130165 | -122.420288474132 | (37.7857493130165, -122.420288474132) | 13 | 9 | 9 | 28858 | 36 | ||
16665 | 136767 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3520 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999224.40422 | 2120935.42639 | 37.8036383025204 | -122.446913736078 | (37.8036383025204, -122.446913736078) | 13 | 9 | 1 | 57 | 17 | |||
17596 | 62149 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2037 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 10 | Permit Number 22263 | 5999450.73523 | 2121163.30158 | 37.8042769138086 | -122.446146910269 | (37.8042769138086, -122.446146910269) | 13 | 9 | 1 | 57 | 17 | |
17719 | 244155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004291.9483 | 2109759.7787 | 37.7732409929902 | -122.428580147189 | (37.7732409929902, -122.428580147189) | 7 | 9 | 11 | 28852 | 10 | |||
17970 | 62153 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2022 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22267 | 5999519.37482 | 2121217.44002 | 37.8044294828978 | -122.44591327448 | (37.8044294828978, -122.44591327448) | 13 | 9 | 1 | 57 | 17 | |
17975 | 136753 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3104 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003385.31973 | 2119082.57835 | 37.7987876966409 | -122.432382275515 | (37.7987876966409, -122.432382275515) | 13 | 9 | 1 | 57 | 17 | |||
18651 | 74199 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1020 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007263.22393 | 2114733.09636 | 37.7870642243702 | -122.418654831377 | (37.7870642243702, -122.418654831377) | 13 | 9 | 10 | 28858 | 21 | |||
20458 | 42640 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1651 Union St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/25/2015 02:08:00 PM | 3 | 3x3 | Permit Number 42688 | 6005273.82097 | 2118847.7065 | 37.7982497015198 | -122.425830717123 | (37.7982497015198, -122.425830717123) | 13 | 9 | 1 | 57 | 17 |
20618 | 244139 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 441 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004334.8503 | 2109600.9194 | 37.7728072319255 | -122.42842041843 | (37.7728072319255, -122.42842041843) | 7 | 9 | 11 | 28852 | 10 | |||
20970 | 31216 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2302 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | 8 | Permit Number 34907 | 6002328.19974 | 2116193.32144 | 37.7907945474797 | -122.435833412206 | (37.7907945474797, -122.435833412206) | 13 | 9 | 1 | 29490 | 27 | ||
21043 | 140012 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 830 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2018 02:43:00 PM | 3 | Width 0ft | 6004895.2399 | 2111747.232 | 37.7787321771615 | -122.426634832347 | (37.7787321771615, -122.426634832347) | 7 | 9 | 11 | 28852 | 41 | ||
22929 | 136865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 750 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006308.5123 | 2112860.73674 | 37.7818693876916 | -122.42182487954 | (37.7818693876916, -122.42182487954) | 7 | 9 | 11 | 28852 | 41 | |||
22952 | 136779 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2700 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004443.0325 | 2118468.37808 | 37.7971611791972 | -122.428678439257 | (37.7971611791972, -122.428678439257) | 13 | 9 | 1 | 57 | 17 | |||
23210 | 136827 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2792 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002597.11005 | 2117761.57869 | 37.7951158492703 | -122.435015205399 | (37.7951158492703, -122.435015205399) | 13 | 9 | 1 | 29490 | 27 | |||
23214 | 84608 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50841 | 6005059.05085072 | 2120549.16999723 | 37.8029093444786 | -122.426695114755 | (37.8029093444786, -122.426695114755) | 13 | 9 | 1 | 57 | 17 | ||
23839 | 136837 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2189 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003780.76406 | 2116920.29251 | 37.7928730300301 | -122.430859514663 | (37.7928730300301, -122.430859514663) | 13 | 9 | 1 | 29490 | 27 | |||
23994 | 42610 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1778 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42677 | 6004517.51154 | 2118442.44969 | 37.7970942013016 | -122.428418874228 | (37.7970942013016, -122.428418874228) | 13 | 9 | 1 | 57 | 17 | |
24158 | 106174 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.421653930851 | (37.7898405898041, -122.421653930851) | 13 | 9 | 10 | 28858 | 21 | ||||
24352 | 124853 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Casa Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781938 | 6001524.844 | 2121579.60518 | 37.8055382003848 | -122.43899915981 | (37.8055382003848, -122.43899915981) | 13 | 9 | 1 | 57 | 17 | |
24407 | 136791 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 544 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004692.56691 | 2110718.60758 | 37.7758963667591 | -122.42726266626 | (37.7758963667591, -122.42726266626) | 7 | 9 | 11 | 28852 | 10 | |||
24687 | 34671 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2001X Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/2013 12:00:00 AM | 3 | Permit Number 770195 | 6003313.06094 | 2118924.86911 | 37.7983505703751 | -122.432621042824 | (37.7983505703751, -122.432621042824) | 13 | 9 | 1 | 57 | 17 | |
24734 | 136867 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2014 12:00:00 AM | 7 | Width 4ft | Permit Number 773338 | 6006067.02029 | 2112827.44756 | 37.7817643621779 | -122.42265796469 | (37.7817643621779, -122.42265796469) | 7 | 9 | 11 | 28852 | 41 | |
25533 | 242252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 73 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003939.19793 | 2108852.96693 | 37.7707311402553 | -122.429735667866 | (37.7707311402553, -122.429735667866) | 7 | 9 | 11 | 29492 | 10 | |||
25817 | 83357 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3036-3038 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52341 | 6004710.71346 | 2120028.26822 | 37.8014593828022 | -122.427863403488 | (37.8014593828022, -122.427863403488) | 13 | 9 | 1 | 57 | 17 | |
26039 | 138837 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 666 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004066.4292 | 2111036.129 | 37.7767327723898 | -122.42945128666 | (37.7767327723898, -122.42945128666) | 7 | 9 | 11 | 28852 | 10 | |||
26185 | 136818 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6002582.05936 | 2117878.42798 | 37.7954358325571 | -122.435075644328 | (37.7954358325571, -122.435075644328) | 13 | 9 | 1 | 57 | 17 | |||
26818 | 31215 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2302 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | 7 | 3x3 | Permit Number 34907 | 6002337.52901 | 2116143.49667 | 37.7906582714158 | -122.43579756703 | (37.7906582714158, -122.43579756703) | 13 | 9 | 1 | 29490 | 27 | |
27088 | 241742 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 316 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 2ft | 6004696.52365 | 2109682.80087 | 37.7730525179915 | -122.427175182016 | (37.7730525179915, -122.427175182016) | 7 | 9 | 11 | 28852 | 10 | |||
27871 | 16911 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2012 12:00:00 AM | 3 | 3x3 | 6004752.04219 | 2110164.02671 | 37.7743769864453 | -122.427017417525 | (37.7743769864453, -122.427017417525) | 7 | 9 | 11 | 28852 | 10 | ||
28422 | 242199 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003832.05636 | 2107789.07621 | 37.7678038874682 | -122.430030367613 | (37.7678038874682, -122.430030367613) | 7 | 9 | 5 | 28862 | 3 | |||
28990 | 136761 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2280 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002166.00412 | 2118115.69432 | 37.7960636708541 | -122.436532253766 | (37.7960636708541, -122.436532253766) | 13 | 9 | 1 | 57 | 17 | |||
29161 | 24487 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004392.5811 | 2110517.0483 | 37.7753259646513 | -122.428286026192 | (37.7753259646513, -122.428286026192) | 7 | 9 | 11 | 28852 | 10 | ||
29259 | 141763 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1529 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003807.2635 | 2113507.6582 | 37.7835043002804 | -122.430524211421 | (37.7835043002804, -122.430524211421) | 13 | 9 | 11 | 29490 | 41 | |||
30481 | 136759 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1576 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005415.96156 | 2118918.51958 | 37.7984521676846 | -122.425343909611 | (37.7984521676846, -122.425343909611) | 13 | 9 | 1 | 57 | 17 | |||
30872 | 88706 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2020 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51653 | 6004475.4 | 2108255.2 | 37.769120165328 | -122.427838335035 | (37.769120165328, -122.427838335035) | 7 | 9 | 5 | 28862 | 3 | ||
30878 | 136886 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2655 Polk St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6006127.92223 | 2119929.33879 | 37.8012678182029 | -122.422952183303 | (37.8012678182029, -122.422952183303) | 13 | 9 | 1 | 28858 | 32 | |||
30917 | 28 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2011 12:00:00 AM | 3 | 3x3 | 6003863.8671794 | 2107765.4342001 | 37.7677407737782 | -122.429918651186 | (37.7677407737782, -122.429918651186) | 7 | 9 | 5 | 28862 | 3 | ||
30943 | 24488 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 730 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003912.5381 | 2110447.8419 | 37.7751087667975 | -122.42994166795 | (37.7751087667975, -122.42994166795) | 7 | 9 | 11 | 29492 | 10 | ||
31056 | 7830 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 828 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6006192.27553 | 2112919.76373 | 37.7820249056667 | -122.422231200417 | (37.7820249056667, -122.422231200417) | 7 | 9 | 11 | 28852 | 41 | |||
31278 | 41441 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 42042 | 6006154.15968 | 2110763.0848 | 37.7761010398668 | -122.422209792973 | (37.7761010398668, -122.422209792973) | 7 | 9 | 11 | 28852 | 10 | |
31321 | 140459 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2001 12:00:00 AM | 5 | Width 0ft | 6003139.0674 | 2112416.8164 | 37.7804712472963 | -122.432757957966 | (37.7804712472963, -122.432757957966) | 15 | 9 | 11 | 29490 | 41 | ||
31772 | 88704 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2020 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51653 | 6004475.4 | 2108255.2 | 37.769120165328 | -122.427838335035 | (37.769120165328, -122.427838335035) | 7 | 9 | 5 | 28862 | 3 | ||
31789 | 21631 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1615 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004720.5557 | 2114675.0873 | 37.7867614641574 | -122.427447768121 | (37.7867614641574, -122.427447768121) | 13 | 9 | 11 | 28858 | 13 | ||
31856 | 110225 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
31898 | 244158 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 453 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004360.7522 | 2109769.4694 | 37.7732714947927 | -122.428342836041 | (37.7732714947927, -122.428342836041) | 7 | 9 | 11 | 28852 | 10 | |||
32166 | 246604 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6005614.48903 | 2109249.34773 | 37.7719142289884 | -122.423968991887 | (37.7719142289884, -122.423968991887) | 7 | 9 | 5 | 28852 | 10 | |||
32424 | 102772 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1440 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 31199 | 6006025.32539 | 2119349.84654 | 37.7996708902593 | -122.423265997228 | (37.7996708902593, -122.423265997228) | 13 | 9 | 1 | 28858 | 32 | ||
32565 | 106176 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.421653930851 | (37.7898405898041, -122.421653930851) | 13 | 9 | 10 | 28858 | 21 | ||||
33056 | 7315 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2301X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002927.5440245 | 2115118.0633563 | 37.7878761904759 | -122.433682830303 | (37.7878761904759, -122.433682830303) | 13 | 9 | 11 | 29490 | 27 | |||
33611 | 64718 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1151 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | 6 | Permit Number 25672 | 6006650.94354 | 2114593.23793 | 37.7866457167759 | -122.420763256822 | (37.7866457167759, -122.420763256822) | 13 | 9 | 10 | 28858 | 36 | |
33706 | 53037 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1701 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50944 | 6005276 | 2115519 | 37.7891100372749 | -122.425586144928 | (37.7891100372749, -122.425586144928) | 13 | 9 | 1 | 28858 | 27 |
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) );