trees
6,344 rows where qSpecies_id = 19 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1398 | 20032 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY51 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3ST | |||||||||||||
1682 | 3092 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2980 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000114.43818 | 2115142.33295 | 37.7877828069853 | -122.443417371621 | (37.7877828069853, -122.443417371621) | 13 | 6 | 1 | 29490 | 27 | |||
1749 | 5395 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2014 12:00:00 AM | 3 | 6x6 | 6004924.31069 | 2106310.22613 | 37.7638051176279 | -122.426147093211 | (37.7638051176279, -122.426147093211) | 8 | 4 | 5 | 28859 | 19 | ||
2024 | 190143 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1200 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 10:47:00 AM | 3 | Width 4ft | 6017523.52148 | 2096815.65975 | 37.7384390567147 | -122.381909364434 | (37.7384390567147, -122.381909364434) | 10 | 3 | 8 | 58 | 1 | ||
2590 | 3930 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100X Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/24/2014 07:47:00 AM | 3 | 4x4 | 6002189.24503 | 2107585.41749 | 37.7671515138645 | -122.435698075908 | (37.7671515138645, -122.435698075908) | 15 | 5 | 5 | 28862 | 3 | ||
2609 | 10168 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005769.33975 | 2102766.2906 | 37.7541220254375 | -122.422972492697 | (37.7541220254375, -122.422972492697) | 2 | 4 | 5 | 28859 | 19 | |||
2668 | 85700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010976.81813 | 2112473.48761 | 37.7810682491478 | -122.405647340366 | (37.7810682491478, -122.405647340366) | 14 | 2 | 9 | 28853 | 34 | ||
3248 | 85701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010962.65697 | 2112458.52521 | 37.781026374014 | -122.405695276931 | (37.781026374014, -122.405695276931) | 14 | 2 | 9 | 28853 | 34 | ||
4575 | 29055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008920.1536798 | 2108682.7358637 | 37.7705445174102 | -122.412494357701 | (37.7705445174102, -122.412494357701) | 8 | 2 | 9 | 28853 | 19 | ||
4626 | 5513 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 821 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2002 12:00:00 AM | 18 | 5X5 | 6005073.13796 | 2103547.17923 | 37.7562268536034 | -122.425435698922 | (37.7562268536034, -122.425435698922) | 2 | 4 | 5 | 28859 | 19 | ||
5192 | 4661 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:46:00 PM | 3 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.410431363819 | (37.8005811155969, -122.410431363819) | 3 | 1 | 10 | 308 | 23 | ||
7201 | 5637 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1266 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6005132.21095 | 2100956.30175 | 37.7491162433305 | -122.425047067669 | (37.7491162433305, -122.425047067669) | 2 | 4 | 5 | 28862 | 22 | |||
7659 | 261346 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:42:00 PM | 3 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | 3 | 1 | 10 | 308 | 23 | ||
8087 | 188688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 02:16:00 PM | 3 | Width 4ft | 6017441.41972 | 2097257.16832 | 37.739646816544 | -122.382223941884 | (37.739646816544, -122.382223941884) | 10 | 3 | 8 | 58 | 1 | ||
8140 | 26662 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2001 12:00:00 AM | 8 | 3x3 | 6017216.3972 | 2096959.142 | 37.7388160650952 | -122.382981244792 | (37.7388160650952, -122.382981244792) | 10 | 3 | 8 | 58 | 1 | ||
8292 | 261770 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2020 11:05:00 AM | 3 | 4x4 | ||||||||||||
8419 | 85699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010993.40445 | 2112488.15858 | 37.7811094596721 | -122.405590993329 | (37.7811094596721, -122.405590993329) | 14 | 2 | 9 | 28853 | 34 | ||
8528 | 5525 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 875 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/09/2015 07:32:00 AM | 3 | 8x8 | 6005129 | 2103286 | 37.7555128725534 | -122.425223924554 | (37.7555128725534, -122.425223924554) | 2 | 4 | 5 | 28859 | 19 | ||
8884 | 4658 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:50:00 PM | 3 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | 3 | 1 | 10 | 308 | 23 | ||
8929 | 29875 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6014068.9121897 | 2099730.7814701 | 37.746251993267 | -122.394057835868 | (37.746251993267, -122.394057835868) | 10 | 3 | 8 | 58 | 1 | ||
9233 | 17847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2082 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003983.5737 | 2115317.762 | 37.7884843766402 | -122.430043414021 | (37.7884843766402, -122.430043414021) | 13 | 9 | 11 | 29490 | 27 | |||
9325 | 3933 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100X Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/24/2014 07:53:00 AM | 3 | 4x4 | 6002195.04278 | 2107524.92983 | 37.7669857589152 | -122.435673694403 | (37.7669857589152, -122.435673694403) | 15 | 5 | 5 | 28862 | 3 | ||
9417 | 203065 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 01:10:00 PM | 3 | Width 3ft | 6017458.84969 | 2097245.24162 | 37.7396150308979 | -122.382162846439 | (37.7396150308979, -122.382162846439) | 10 | 3 | 8 | 58 | 1 | ||
9630 | 248945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500x Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:00:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
9640 | 17196 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2235X Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6004629.78741 | 2116932.39582 | 37.792954330542 | -122.427922714666 | (37.792954330542, -122.427922714666) | 13 | 9 | 1 | 28858 | 27 | |||
9744 | 19850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10ST | |||||||||||||
9869 | 5383 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 325X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/06/2009 12:00:00 AM | 3 | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | ||
9977 | 12786 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1926X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5989360.57879 | 2114746.40468 | 37.7860765689348 | -122.480594276512 | (37.7860765689348, -122.480594276512) | 11 | 6 | 1 | 55 | 33 | |||
10226 | 237496 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3927 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2017 12:00:00 AM | 8 | Width 3ft | 6003620.49393 | 2101843.48933 | 37.7514667420033 | -122.430337889878 | (37.7514667420033, -122.430337889878) | 2 | 4 | 5 | 28862 | 22 | ||
10462 | 85563 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1186 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017119.22187 | 2093617.04426 | 37.7296339591237 | -122.383084687511 | (37.7296339591237, -122.383084687511) | 10 | 3 | 8 | 58 | 1 | ||
10670 | 258171 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Dartmouth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008455.21796 | 2093605.41918 | 37.7291194808141 | -122.413036341511 | (37.7291194808141, -122.413036341511) | 9 | 3 | 7 | 309 | 28 | |||
10710 | 10015 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 232 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2019 12:00:00 AM | 3 | 3x3 | 6005430.70254 | 2107623.59079 | 37.7674399129618 | -122.424489062615 | (37.7674399129618, -122.424489062615) | 8 | 4 | 5 | 28853 | 19 | ||
11625 | 28733 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1795X Evans Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2011 12:00:00 AM | 3 | 3x3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
11909 | 29249 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010557.0875047 | 2086190.1499449 | 37.7088764405738 | -122.405248002787 | (37.7088764405738, -122.405248002787) | 9 | 7 | 8 | 309 | 39 | ||
12976 | 260626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1546 Van Dyke Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014701.33267 | 2093312.36998 | 37.7286634818435 | -122.391422361758 | (37.7286634818435, -122.391422361758) | 10 | 3 | 8 | 58 | 1 | |||
13215 | 3932 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100X Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/24/2014 07:51:00 AM | 3 | 3x3 | 6002190.84028 | 2107543.26749 | 37.7670358709246 | -122.435689542265 | (37.7670358709246, -122.435689542265) | 15 | 5 | 5 | 28862 | 3 | ||
14619 | 20886 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1892X Sunset Blvd | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
14765 | 5336 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 155 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2016 02:45:00 PM | 3 | 3X3 | 6004856.93349 | 2107518.43453 | 37.7671187605458 | -122.4264661646 | (37.7671187605458, -122.4264661646) | 8 | 4 | 5 | 28862 | 19 | ||
15435 | 21765 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/1999 12:00:00 AM | 3 | 3X3 | 6008457.4342459 | 2121063.933871 | 37.8045143025639 | -122.414971372963 | (37.8045143025639, -122.414971372963) | 3 | 1 | 10 | 308 | 23 | ||
15923 | 5379 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 299 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6004899.9834 | 2106715.40982 | 37.764916280383 | -122.426260083162 | (37.764916280383, -122.426260083162) | 8 | 4 | 5 | 28853 | 19 | |||
15957 | 4906 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 94 Ardath Ct | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2004 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | 10 | 3 | 8 | 58 | 1 | ||
16471 | 258115 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010889.02957 | 2091945.92933 | 37.724699191929 | -122.404505645081 | (37.724699191929, -122.404505645081) | 10 | 3 | 7 | 309 | 28 | ||
17954 | 5474 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2015 02:01:00 PM | 3 | 9x12 | 6005006.75984 | 2104767.1454 | 37.7595728433192 | -122.425752087612 | (37.7595728433192, -122.425752087612) | 2 | 4 | 5 | 28859 | 19 | ||
17967 | 258162 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 125 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6011373.95167 | 2092087.62826 | 37.7251153564238 | -122.402839281337 | (37.7251153564238, -122.402839281337) | 10 | 3 | 7 | 309 | 28 | |||
18367 | 103786 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1221 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006804.9894 | 2115120.2532 | 37.7881014522033 | -122.420267712778 | (37.7881014522033, -122.420267712778) | 13 | 9 | 10 | 28858 | 21 | ||
18716 | 261769 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2020 11:00:00 AM | 3 | 4x4 | ||||||||||||
19145 | 5565 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1006 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/06/2015 09:17:00 AM | 3 | 8x8 | 6005052.73338 | 2102416.35362 | 37.7531207175703 | -122.42542579288 | (37.7531207175703, -122.42542579288) | 2 | 4 | 5 | 28862 | 22 | ||
20341 | 230158 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 583 Church St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 6x9 | 6004286.27951 | 2105638.39668 | 37.7619243519609 | -122.428305963469 | (37.7619243519609, -122.428305963469) | 8 | 4 | 5 | 28862 | 3 | |||
20419 | 85704 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 938 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010866.4915 | 2112368.00991 | 37.7807724621315 | -122.406021584247 | (37.7807724621315, -122.406021584247) | 14 | 2 | 9 | 28853 | 34 | ||
20645 | 28147 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2008 12:00:00 AM | 3 | 3X3 | 6004886.4359084 | 2107088.7371383 | 37.7659405821883 | -122.426333522982 | (37.7659405821883, -122.426333522982) | 8 | 4 | 5 | 28853 | 19 | ||
20739 | 5558 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 979 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2013 12:00:00 AM | 2 | 3x3 | 6005125.66098 | 2102631.15935 | 37.7537146442352 | -122.42518887816 | (37.7537146442352, -122.42518887816) | 2 | 4 | 5 | 28859 | 19 | ||
21323 | 85705 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 938 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010851.34827 | 2112352.58315 | 37.780729256891 | -122.406072885158 | (37.780729256891, -122.406072885158) | 14 | 2 | 9 | 28853 | 34 | ||
21437 | 29859 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6014017.477 | 2099779.02044 | 37.7463815884414 | -122.394239070574 | (37.7463815884414, -122.394239070574) | 10 | 3 | 8 | 58 | 1 | ||
21891 | 5615 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1175 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5X5 | 6005187.0067 | 2101521.55232 | 37.7506713860921 | -122.424897792814 | (37.7506713860921, -122.424897792814) | 2 | 4 | 5 | 28859 | 19 | |||
22848 | 1398 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 47 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2004 12:00:00 AM | 3 | 3X4 | 6017352.5573683 | 2095370.395604 | 37.7344612068158 | -122.382399955055 | (37.7344612068158, -122.382399955055) | 10 | 3 | 8 | 58 | 1 | ||
23207 | 21622 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 3 | 3X3 | 6004941.8052503 | 2114940.8187044 | 37.7875036072686 | -122.426701226862 | (37.7875036072686, -122.426701226862) | 13 | 9 | 11 | 28858 | 27 | ||
23649 | 85851 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1630X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6007563.871097 | 2108998.262092 | 37.771334669982 | -122.417208125188 | (37.771334669982, -122.417208125188) | 8 | 2 | 9 | 28853 | 19 | ||
24187 | 29860 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014068.9121897 | 2099730.7814701 | 37.746251993267 | -122.394057835868 | (37.746251993267, -122.394057835868) | 10 | 3 | 8 | 58 | 1 | ||
24496 | 28890 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 425 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6012725.8387007 | 2112364.652974 | 37.7808670625803 | -122.399588923331 | (37.7808670625803, -122.399588923331) | 6 | 2 | 9 | 28856 | 34 | ||
25833 | 21756 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2350 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008463.4743 | 2120995.0395 | 37.8043254753522 | -122.414945591572 | (37.8043254753522, -122.414945591572) | 5 | 1 | 10 | 308 | 23 | |||
26200 | 29874 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014068.9121897 | 2099730.7814701 | 37.746251993267 | -122.394057835868 | (37.746251993267, -122.394057835868) | 10 | 3 | 8 | 58 | 1 | ||
26205 | 17850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2100 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003840.3349 | 2115295.8514 | 37.7884161023437 | -122.430537433765 | (37.7884161023437, -122.430537433765) | 13 | 9 | 1 | 29490 | 27 | |||
26237 | 85710 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1076 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010030.29241 | 2111566.1673 | 37.7785239870252 | -122.408857826542 | (37.7785239870252, -122.408857826542) | 14 | 2 | 9 | 28853 | 34 | ||
27566 | 429 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1930X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 5989341.92233 | 2114728.26194 | 37.7860256698028 | -122.480657493479 | (37.7860256698028, -122.480657493479) | 11 | 6 | 1 | 55 | 33 | |||
28506 | 5593 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1099 DOLORES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/2016 05:30:00 AM | 3 | 3x3 | 6005190 | 2101991 | 37.7519605498096 | -122.424920837429 | (37.7519605498096, -122.424920837429) | 2 | 4 | 5 | 28859 | 19 | ||
28523 | 5382 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2016 08:33:00 AM | 3 | 4x4 | 6004836.6977313 | 2106619.7660372 | 37.7646500880397 | -122.426472161657 | (37.7646500880397, -122.426472161657) | 8 | 4 | 5 | 28862 | 3 | ||
28737 | 18523 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1751X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6009567.6842 | 2119779.6829 | 37.8010503933376 | -122.411038470249 | (37.8010503933376, -122.411038470249) | 3 | 1 | 10 | 308 | 23 | |||
29558 | 5562 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 997 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768456 | 6005129.17531 | 2102577.95802 | 37.7535687642998 | -122.425172939503 | (37.7535687642998, -122.425172939503) | 2 | 4 | 5 | 28859 | 19 | |
31712 | 10170 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1029 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005772.3490263 | 2102822.9576897 | 37.7542777899419 | -122.422966113164 | (37.7542777899419, -122.422966113164) | 2 | 4 | 5 | 28859 | 19 | |||
31781 | 3961 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 198 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002213.95175 | 2107110.03309 | 37.7658476281879 | -122.435578606383 | (37.7658476281879, -122.435578606383) | 15 | 5 | 5 | 28862 | 3 | |||
32416 | 5346 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 198 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6004778.3025 | 2107273.25188 | 37.7664411024979 | -122.426720675429 | (37.7664411024979, -122.426720675429) | 8 | 4 | 5 | 28862 | 3 | |||
32879 | 85590 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1570 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015074.2477 | 2095138.5099 | 37.7336983845847 | -122.390260693216 | (37.7336983845847, -122.390260693216) | 10 | 3 | 8 | 58 | 1 | ||
33440 | 85582 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1486 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015517.7847 | 2094813.6891 | 37.7328310842891 | -122.388704574636 | (37.7328310842891, -122.388704574636) | 10 | 3 | 8 | 58 | 1 | ||
33514 | 18312 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 150 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/2001 12:00:00 AM | 3 | 4X4 | 6010232.50216 | 2107573.20919 | 37.7675715736855 | -122.40787665988 | (37.7675715736855, -122.40787665988) | 8 | 4 | 8 | 28853 | 19 | ||
33916 | 29854 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1800X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014413.12367 | 2099481.40364 | 37.7455863790999 | -122.392850141433 | (37.7455863790999, -122.392850141433) | 10 | 3 | 8 | 58 | 1 | ||
33939 | 7330 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2049 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1X1 | 6002872.8198 | 2115392.1403 | 37.7886256306485 | -122.433891763872 | (37.7886256306485, -122.433891763872) | 13 | 9 | 1 | 29490 | 27 | |||
33946 | 1906 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 27 Beideman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001522.4059 | 2113011.2495 | 37.7820115889168 | -122.438393339899 | (37.7820115889168, -122.438393339899) | 15 | 5 | 11 | 29490 | 41 | |||
34133 | 85609 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1551 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015130.3081 | 2095032.4348 | 37.7334102332415 | -122.390059466624 | (37.7334102332415, -122.390059466624) | 10 | 3 | 8 | 58 | 1 | ||
35072 | 5628 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1217 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6005202.88749 | 2101242.53222 | 37.7499061583492 | -122.424823027659 | (37.7499061583492, -122.424823027659) | 2 | 4 | 5 | 28859 | 19 | |||
35159 | 6743 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fairfax Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016859.78768 | 2097310.83297 | 37.7397620268834 | -122.384238731741 | (37.7397620268834, -122.384238731741) | 10 | 3 | 8 | 58 | 1 | |||
35682 | 26609 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1485 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6011735.62232 | 2092555.25526 | 37.7264195519176 | -122.401621868778 | (37.7264195519176, -122.401621868778) | 10 | 3 | 8 | 58 | 1 | ||
36170 | 13060 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 583 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/26/2013 12:00:00 AM | 3 | 2X2 | 6009601.7098 | 2120500.5639 | 37.8030316618488 | -122.410971671797 | (37.8030316618488, -122.410971671797) | 3 | 1 | 10 | 308 | 23 | ||
36243 | 1819 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2108 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6011992.2021463 | 2087865.1033243 | 37.7135556595937 | -122.400405584974 | (37.7135556595937, -122.400405584974) | 10 | 7 | 8 | 309 | 39 | |||
36363 | 21824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2741 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6008240.40798 | 2122263.00335 | 37.8077944465112 | -122.415807371838 | (37.8077944465112, -122.415807371838) | 5 | 1 | 10 | 308 | 23 | |||
37155 | 87649 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2132 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2008 12:00:00 AM | 3 | 6011869.04727 | 2087711.09521 | 37.7131259154971 | -122.400820441523 | (37.7131259154971, -122.400820441523) | 10 | 7 | 8 | 309 | 39 | |||
37314 | 28891 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 525 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/2011 12:00:00 AM | 3 | 3x3 | 6013294.03669 | 2111784.24208 | 37.7793050428391 | -122.397582515238 | (37.7793050428391, -122.397582515238) | 6 | 2 | 9 | 28856 | 34 | ||
37429 | 2475 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2045X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004156.9376513 | 2115288.8800495 | 37.7884148909791 | -122.429441541324 | (37.7884148909791, -122.429441541324) | 13 | 9 | 11 | 29490 | 27 | |||
37762 | 5519 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 856-858 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2013 12:00:00 AM | 3 | 4x3 | 6005001.4543 | 2103370.06443 | 37.7557364874618 | -122.425671000233 | (37.7557364874618, -122.425671000233) | 2 | 4 | 5 | 28862 | 22 | ||
38401 | 5392 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2016 08:36:00 AM | 3 | 3x3 | 6004930.10213 | 2106201.62178 | 37.7635072432739 | -122.42611933027 | (37.7635072432739, -122.42611933027) | 8 | 4 | 5 | 28859 | 19 | ||
39517 | 85585 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1516 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015333.6646 | 2094945.596 | 37.733183067921 | -122.389350338061 | (37.733183067921, -122.389350338061) | 10 | 3 | 8 | 58 | 1 | ||
40038 | 3956 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 176 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002211.14254 | 2107195.73028 | 37.7660827721266 | -122.43559445424 | (37.7660827721266, -122.43559445424) | 15 | 5 | 5 | 28862 | 3 | |||
40448 | 10840 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1139X Hudson Ave | 47 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 3X4 | 6017999.90001 | 2094605.73201 | 37.7323973271712 | -122.380108735409 | (37.7323973271712, -122.380108735409) | 10 | 3 | 8 | 58 | 1 | ||
40678 | 1827 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2142 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011820.2937054 | 2087653.754231 | 37.712965749133 | -122.400984924928 | (37.712965749133, -122.400984924928) | 10 | 7 | 8 | 309 | 39 | |||
40748 | 18360 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 530 Potrero Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2015 08:17:00 AM | 3 | 3X3 | 6010334.09693 | 2105739.38187 | 37.7625419883451 | -122.407395957864 | (37.7625419883451, -122.407395957864) | 8 | 4 | 8 | 28859 | 19 | ||
41122 | 22500 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6400 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013113.36636 | 2090284.89866 | 37.7202623949849 | -122.396699945652 | (37.7202623949849, -122.396699945652) | 10 | 3 | 8 | 58 | 1 | |||
41139 | 29050 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 298 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/2012 12:00:00 AM | 3 | 3x3 | 6008397.48752 | 2109202.74504 | 37.7719429947154 | -122.4143390694 | (37.7719429947154, -122.4143390694) | 8 | 2 | 9 | 28853 | 19 | ||
41367 | 29849 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1800X Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014521.43542 | 2099403.82747 | 37.7453793866416 | -122.392470187744 | (37.7453793866416, -122.392470187744) | 10 | 3 | 8 | 58 | 1 | ||
41716 | 5574 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1040 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005061.06142 | 2102325.10655 | 37.7528706448673 | -122.425390499891 | (37.7528706448673, -122.425390499891) | 2 | 4 | 5 | 28862 | 22 | |||
41833 | 85850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600X Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6007630.558951 | 2109135.973281 | 37.7717165438769 | -122.416987207139 | (37.7717165438769, -122.416987207139) | 8 | 2 | 9 | 28853 | 19 | ||
41992 | 5663 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1362 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/2016 05:24:00 AM | 3 | 10x6 | 6005158.4970374 | 2100409.5544217 | 37.7476164858345 | -122.424917276216 | (37.7476164858345, -122.424917276216) | 2 | 7 | 5 | 63 | 22 |
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) );