Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21543 | 21543 | 126 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1034 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6001930.03147 | 2107660.22402 | 37.7673421872283 | -122.43660001049801 | (37.7673421872283, -122.436600010498) | |||
21520 | 21520 | 128 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1037 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001838.59138 | 2107604.25584 | 37.767183315676796 | -122.436912281202 | (37.7671833156768, -122.436912281202) | |||
20220 | 20220 | 172 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002270.84899 | 2107104.55604 | 37.7658358209965 | -122.43538141922899 | (37.7658358209965, -122.435381419229) | |||
19286 | 19286 | 173 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002266.35161 | 2107126.41813 | 37.7658955935305 | -122.43539853871201 | (37.7658955935305, -122.435398538712) | |||
20544 | 20544 | 174 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002266.37223 | 2107147.365 | 37.7659531096791 | -122.435399965935 | (37.7659531096791, -122.435399965935) | |||
129463 | 129463 | 429 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1930X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 5989341.92233 | 2114728.26194 | 37.7860256698028 | -122.480657493479 | (37.7860256698028, -122.480657493479) | |||
78912 | 78912 | 430 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1930X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5989321.78022 | 2114730.4517099997 | 37.7860305116184 | -122.480727339299 | (37.7860305116184, -122.480727339299) | |||
93669 | 93669 | 466 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2490 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009704.8170941 | 2102845.1135009998 | 37.7545597392567 | -122.409368154592 | (37.7545597392567, -122.409368154592) | |||
17948 | 17948 | 472 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2790 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2005 12:00:00 AM | 6 | 3x3 | 6008923.39958 | 2102238.9424099997 | 37.7528515171836 | -122.412027677747 | (37.7528515171836, -122.412027677747) | ||
110785 | 110785 | 473 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2790 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6008872.67231 | 2102220.8769099996 | 37.752799067118396 | -122.412201825987 | (37.7527990671184, -122.412201825987) | |||
79260 | 79260 | 479 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1219X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2000 12:00:00 AM | 12 | 3X3 | 6010599.5229546 | 2102167.6420071 | 37.7527496408999 | -122.406226280889 | (37.7527496408999, -122.406226280889) | ||
89350 | 89350 | 684 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2340X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 6 | 4X4 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | ||
91483 | 91483 | 686 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1289X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3X3 | 6010615.826236401 | 2101854.9677848998 | 37.751892018433104 | -122.40614787408998 | (37.7518920184331, -122.40614787409) | ||
144425 | 144425 | 844 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
115269 | 115269 | 845 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
92141 | 92141 | 846 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
100887 | 100887 | 847 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 24 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
77578 | 77578 | 848 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2006 12:00:00 AM | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | ||
50077 | 50077 | 849 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 36 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
128424 | 128424 | 1398 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 47 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/2004 12:00:00 AM | 3 | 3X4 | 6017352.5573683 | 2095370.3956040002 | 37.734461206815794 | -122.382399955055 | (37.7344612068158, -122.382399955055) | ||
106667 | 106667 | 1399 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 54 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017410.5516844 | 2095373.0690166 | 37.7344717507601 | -122.382199633479 | (37.7344717507601, -122.382199633479) | ||
116984 | 116984 | 1405 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 63 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017388.835420901 | 2095314.9218022998 | 37.7343108905935 | -122.382270670557 | (37.7343108905935, -122.382270670557) | ||
106298 | 106298 | 1615 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 761 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5995633.04405 | 2111046.18679 | 37.776279302382605 | -122.45862540654 | (37.7762793023826, -122.45862540654) | |||
75159 | 75159 | 1819 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2108 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6011992.2021463 | 2087865.1033243 | 37.7135556595937 | -122.40040558497401 | (37.7135556595937, -122.400405584974) | |||
11706 | 11706 | 1824 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2108 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6011980.13832 | 2087849.66723 | 37.71351260240579 | -122.40044619853201 | (37.7135126024058, -122.400446198532) | |||
11351 | 11351 | 1825 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2122 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 3x3 | 6011914.69441 | 2087767.06521 | 37.7132821439374 | -122.400666598098 | (37.7132821439374, -122.400666598098) | ||
79622 | 79622 | 1827 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2142 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011820.2937054 | 2087653.754231 | 37.712965749133 | -122.400984924928 | (37.712965749133, -122.400984924928) | |||
12384 | 12384 | 1828 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2144 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011802.738969999 | 2087632.59723 | 37.7129066769684 | -122.40104411460199 | (37.7129066769684, -122.401044114602) | |||
11453 | 11453 | 1831 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2155 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011874.06348 | 2087549.91911 | 37.71268363791079 | -122.40079178733299 | (37.7126836379108, -122.400791787333) | |||
88374 | 88374 | 1836 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2190X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011449.2894285 | 2087454.5820611 | 37.7123981596303 | -122.402253250732 | (37.7123981596303, -122.402253250732) | |||
11397 | 11397 | 1847 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2401 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/23/1992 12:00:00 AM | 6 | 3X3 | 6011018.94328 | 2086899.6940900001 | 37.710850517399294 | -122.403701647223 | (37.7108505173993, -122.403701647223) | ||
10526 | 10526 | 1853 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1991 12:00:00 AM | 6 | 3X3 | 6011002.0813 | 2086868.5454799999 | 37.710764047595895 | -122.40375773612499 | (37.7107640475959, -122.403757736125) | ||
11791 | 11791 | 1865 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2555 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6010708.42536 | 2086342.04995 | 37.709301987375206 | -122.404735641836 | (37.7093019873752, -122.404735641836) | |||
11526 | 11526 | 1872 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1997 12:00:00 AM | 3 | 3X3 | 6010689.185380001 | 2086549.45702 | 37.709870410169 | -122.40481673101101 | (37.709870410169, -122.404816731011) | ||
1853 | 1853 | 1906 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 27 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001522.4059 | 2113011.2495 | 37.782011588916795 | -122.43839333989901 | (37.7820115889168, -122.438393339899) | |||
5502 | 5502 | 1908 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001516.9911 | 2113051.8602 | 37.782122787571 | -122.438414983045 | (37.782122787571, -122.438414983045) | |||
20709 | 20709 | 1924 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 84 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6001143.28865 | 2097360.19763 | 37.7390160563367 | -122.438583145994 | (37.7390160563367, -122.438583145994) | |||
20937 | 20937 | 2313 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2241 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2000 12:00:00 AM | 3 | 3X3 | 6009680.40097 | 2104279.4827900003 | 37.7584968269853 | -122.409553821766 | (37.7584968269853, -122.409553821766) | ||
9383 | 9383 | 2322 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2290 BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1996 12:00:00 AM | 9 | 3X3 | 6009654.0 | 2104017.0 | 37.7577746290621 | -122.40962660234301 | (37.7577746290621, -122.409626602343) | ||
9065 | 9065 | 2324 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2298X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1996 12:00:00 AM | 6 | 3X3 | 6009641.4422065 | 2103972.2905262 | 37.7576511632266 | -122.409666876922 | (37.7576511632266, -122.409666876922) | ||
19633 | 19633 | 2342 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2376 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1992 12:00:00 AM | 12 | 3X3 | 6009653.724780001 | 2103509.09006 | 37.756380007238995 | -122.40959170659599 | (37.756380007239, -122.409591706596) | ||
22066 | 22066 | 2346 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2388 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/1993 12:00:00 AM | 12 | 4X4 | 6009660.38351 | 2103440.794 | 37.7561928547191 | -122.409563858204 | (37.7561928547191, -122.409563858204) | ||
9362 | 9362 | 2360 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2450 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1999 12:00:00 AM | 8 | 3X3 | 6009684.705885201 | 2103070.313359 | 37.755176960826795 | -122.409453597226 | (37.7551769608268, -122.409453597226) | ||
23361 | 23361 | 2382 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2600 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 6009734.663319999 | 2102078.76769 | 37.7524571968444 | -122.40921086350401 | (37.7524571968444, -122.409210863504) | ||||
9452 | 9452 | 2383 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2600 BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1992 12:00:00 AM | 8 | 3X3 | 6009707.0 | 2102117.0 | 37.752560624409 | -122.409309226081 | (37.752560624409, -122.409309226081) | ||
20110 | 20110 | 2386 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2632 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/18/1996 12:00:00 AM | 12 | 3X3 | 6009740.44854 | 2102010.36147 | 37.7522696926973 | -122.409186030517 | (37.7522696926973, -122.409186030517) | ||
18422 | 18422 | 2388 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2640 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 6 | 3X3 | 6009741.35877 | 2101954.4215599997 | 37.7521161451436 | -122.409178935769 | (37.7521161451436, -122.409178935769) | ||
22109 | 22109 | 2407 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2733 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009838.8691 | 2101396.66523 | 37.7505901323408 | -122.408802382446 | (37.7505901323408, -122.408802382446) | |||
21300 | 21300 | 2408 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2733 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6009836.697000001 | 2101416.76676 | 37.7506452050256 | -122.408811311795 | (37.7506452050256, -122.408811311795) | |||
20671 | 20671 | 2413 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2771 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2013 12:00:00 AM | 3 | 5x5 | 6009848.400830001 | 2101205.66879 | 37.7500662322799 | -122.408755947755 | (37.7500662322799, -122.408755947755) | ||
78089 | 78089 | 2475 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2045X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004156.9376513 | 2115288.8800494997 | 37.7884148909791 | -122.42944154132401 | (37.7884148909791, -122.429441541324) | |||
120855 | 120855 | 2476 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2045X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004156.9376513 | 2115288.8800494997 | 37.7884148909791 | -122.42944154132401 | (37.7884148909791, -122.429441541324) | |||
128414 | 128414 | 2600 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1755 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6005137.6807699995 | 2115060.19605 | 37.787842459846395 | -122.426032037994 | (37.7878424598464, -122.426032037994) | |||
6117 | 6117 | 2621 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004737.1436 | 2115078.0261 | 37.78786877138371 | -122.427419093403 | (37.7878687713837, -122.427419093403) | |||
7897 | 7897 | 2622 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004719.8929 | 2115076.5886 | 37.787863848693796 | -122.427478675215 | (37.7878638486938, -122.427478675215) | |||
7600 | 7600 | 2716 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2178 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003083.0342 | 2114847.1509 | 37.7871411551889 | -122.433125499331 | (37.7871411551889, -122.433125499331) | |||
126253 | 126253 | 2717 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2180 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003066.40627 | 2114845.23442 | 37.7871349497853 | -122.433182891298 | (37.7871349497853, -122.433182891298) | |||
104714 | 104714 | 2720 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2186 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6003054.49759 | 2114843.32934 | 37.78712904337029 | -122.433223956514 | (37.7871290433703, -122.433223956514) | |||
82177 | 82177 | 2721 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2186 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6003044.070069999 | 2114841.38469 | 37.7871231123168 | -122.43325989441001 | (37.7871231123168, -122.43325989441) | |||
8052 | 8052 | 3037 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2611 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X2 | 6001770.5365 | 2115308.215 | 37.7883325797422 | -122.437699479333 | (37.7883325797422, -122.437699479333) | |||
23061 | 23061 | 3903 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 86 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6002177.2282 | 2107781.12662 | 37.767688200474 | -122.435753644126 | (37.767688200474, -122.435753644126) | ||||
90904 | 90904 | 3930 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100X Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/2014 07:47:00 AM | 3 | 2x2 | 6002187.455626401 | 2107639.0884213 | 37.767298779420706 | -122.43570810548201 | (37.7672987794207, -122.435708105482) | ||
104393 | 104393 | 3931 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100X Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/2014 07:50:00 AM | 3 | 2x2 | 6002187.455626401 | 2107639.0884213 | 37.767298779420706 | -122.43570810548201 | (37.7672987794207, -122.435708105482) | ||
141982 | 141982 | 3932 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100X Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/2014 07:51:00 AM | 3 | 2x2 | 6002187.455626401 | 2107639.0884213 | 37.767298779420706 | -122.43570810548201 | (37.7672987794207, -122.435708105482) | ||
21326 | 21326 | 3933 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100X Castro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/2014 07:53:00 AM | 3 | 2x2 | 6002195.042780001 | 2107524.92983 | 37.766985758915204 | -122.435673694403 | (37.7669857589152, -122.435673694403) | ||
81962 | 81962 | 3934 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100X Castro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/2014 07:55:00 AM | 3 | 2x2 | 6002187.455626401 | 2107639.0884213 | 37.767298779420706 | -122.43570810548201 | (37.7672987794207, -122.435708105482) | ||
18645 | 18645 | 3935 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100X Castro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6002196.19129 | 2107478.22623 | 37.7668575875273 | -122.435666380201 | (37.7668575875273, -122.435666380201) | |||
20669 | 20669 | 3936 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100X Castro St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6002196.30076 | 2107449.44375 | 37.7667785641176 | -122.435663942152 | (37.7667785641176, -122.435663942152) | |||
18138 | 18138 | 3937 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100X Castro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2x2 | 6002197.8017 | 2107402.73286 | 37.76665039272579 | -122.435655408473 | (37.7666503927258, -122.435655408473) | |||
139571 | 139571 | 3938 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 101 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2016 12:00:00 AM | 12 | 3X3 | 6002237.381114401 | 2107641.8170937 | 37.767309107382395 | -122.435535615805 | (37.7673091073824, -122.435535615805) | ||
9222 | 9222 | 3940 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 101 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002266.5 | 2107605.5 | 37.767211043352 | -122.435432299631 | (37.767211043352, -122.435432299631) | |||
21626 | 21626 | 3941 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 111 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002248.677999999 | 2107548.19396 | 37.7670526828487 | -122.435489843284 | (37.7670526828487, -122.435489843284) | |||
18109 | 18109 | 3942 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 117 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002250.18751 | 2107521.46562 | 37.7669793791172 | -122.435482709867 | (37.7669793791172, -122.435482709867) | |||
21701 | 21701 | 3943 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 125 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002250.29399 | 2107506.67699 | 37.7669387792148 | -122.435481283529 | (37.7669387792148, -122.435481283529) | |||
21911 | 21911 | 3946 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 135 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6002249.64494 | 2107455.34948 | 37.7667978095999 | -122.43547985630501 | (37.7667978095999, -122.435479856305) | ||
96696 | 96696 | 3947 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 150 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002203.4006055 | 2107347.3684149 | 37.766498693551 | -122.435632081557 | (37.766498693551, -122.435632081557) | |||
21446 | 21446 | 3948 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 158 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002203.37543 | 2107297.32394 | 37.7663612822622 | -122.435628587992 | (37.7663612822622, -122.435628587992) | |||
21700 | 21700 | 3949 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 160 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002203.19056 | 2107271.35548 | 37.7662899687359 | -122.43562736940399 | (37.7662899687359, -122.435627369404) | |||
20686 | 20686 | 3950 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 161-167 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002261.28176 | 2107280.13736 | 37.766317380964104 | -122.435427071498 | (37.7663173809641, -122.435427071498) | |||
17275 | 17275 | 3952 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 171 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002262.974219999 | 2107242.31501 | 37.7662136261755 | -122.43541851174801 | (37.7662136261755, -122.435418511748) | |||
97583 | 97583 | 3953 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 169 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002264.95993 | 2107256.91569 | 37.76625382884 | -122.435412688116 | (37.76625382884, -122.435412688116) | |||
16965 | 16965 | 3954 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 175 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002262.86841 | 2107217.26233 | 37.7661448316428 | -122.435417085427 | (37.7661448316428, -122.435417085427) | |||
21402 | 21402 | 3955 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 179 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002264.530809999 | 2107197.92355 | 37.7660918265006 | -122.435409952008 | (37.7660918265006, -122.435409952008) | |||
18265 | 18265 | 3956 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 176 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002211.14254 | 2107195.73028 | 37.7660827721266 | -122.43559445424 | (37.7660827721266, -122.43559445424) | |||
20581 | 20581 | 3957 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 182 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002210.99422 | 2107171.51565 | 37.76601627626 | -122.435593234753 | (37.76601627626, -122.435593234753) | |||
17495 | 17495 | 3958 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 190 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002214.96457 | 2107141.9514 | 37.7659353255765 | -122.43557738690599 | (37.7659353255765, -122.435577386906) | |||
18955 | 18955 | 3959 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 191 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002263.834480001 | 2107164.25786 | 37.765999349212606 | -122.435409952004 | (37.7659993492126, -122.435409952004) | |||
20460 | 20460 | 3960 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 191 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002263.77044 | 2107181.09923 | 37.7660455878542 | -122.435411378349 | (37.7660455878542, -122.435411378349) | |||
17303 | 17303 | 3961 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 198 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002213.95175 | 2107110.03309 | 37.7658476281879 | -122.435578606383 | (37.7658476281879, -122.435578606383) | |||
19479 | 19479 | 3962 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 203 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002276.7897 | 2106972.99762 | 37.7654749311385 | -122.435351460124 | (37.7654749311385, -122.435351460124) | |||
18319 | 18319 | 3963 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 203 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002275.94345 | 2106991.90912 | 37.765526809433496 | -122.43535574 | (37.7655268094335, -122.43535574) | |||
19095 | 19095 | 3964 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 203 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002275.05475 | 2107008.7678799997 | 37.7655730489951 | -122.435360019857 | (37.7655730489951, -122.435360019857) | |||
18352 | 18352 | 3965 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 203 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002274.64617 | 2107028.90217 | 37.7656283096268 | -122.435362873418 | (37.7656283096268, -122.435362873418) | |||
19918 | 19918 | 3966 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 205 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002279.722709999 | 2106955.27547 | 37.76542643701521 | -122.43534004772499 | (37.7654264370152, -122.435340047725) | |||
18867 | 18867 | 3967 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 207 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002280.19073 | 2106938.01469 | 37.7653790697126 | -122.435337194162 | (37.7653790697126, -122.435337194162) | |||
92720 | 92720 | 3968 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 214 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002223.7776392 | 2106975.355701 | 37.765478395118706 | -122.43553498523599 | (37.7654783951187, -122.435534985236) | |||
17652 | 17652 | 3969 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 218 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002227.2995 | 2106937.42452 | 37.7653744454015 | -122.435520090181 | (37.7653744454015, -122.435520090181) | |||
21995 | 21995 | 3970 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 222 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002226.261080001 | 2106921.30065 | 37.7653301142204 | -122.43552252826099 | (37.7653301142204, -122.435522528261) | |||
18463 | 18463 | 3971 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 225 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002281.70881 | 2106911.69625 | 37.7653068919223 | -122.435330060738 | (37.7653068919223, -122.435330060738) | |||
20956 | 20956 | 3972 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 230 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002228.7207 | 2106886.85337 | 37.765235670109 | -122.43551155653601 | (37.765235670109, -122.435511556536) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");