trees
6,344 rows where qSpecies_id = 19 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4650 | 229335 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2125 Bryant St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009610.4756 | 2104742.50445 | 37.7597642613296 | -122.409828339817 | (37.7597642613296, -122.409828339817) | 2 | 4 | 8 | 28859 | 19 | |||
4673 | 60356 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 4 | Permit Number 19934 | 6016682.1383 | 2093866.4324 | 37.7302945678233 | -122.384613110545 | (37.7302945678233, -122.384613110545) | 10 | 3 | 8 | 58 | 1 | ||
4718 | 181925 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2351 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5986069.5587 | 2099239.0051 | 37.7433057547251 | -122.490838681113 | (37.7433057547251, -122.490838681113) | 1 | 8 | 3 | 29491 | 35 | |||
4810 | 262420 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4860 | 168126 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999733.55538 | 2116947.29263 | 37.7927170246219 | -122.444864946464 | (37.7927170246219, -122.444864946464) | 13 | 6 | 1 | 29490 | 27 | |||
4882 | 193004 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013457.05978 | 2097724.05261 | 37.7407079131502 | -122.396032957252 | (37.7407079131502, -122.396032957252) | 10 | 3 | 8 | 58 | 1 | |||
4883 | 264808 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
4959 | 47411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45322 | |||||||||||||
4969 | 36620 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
5002 | 138596 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1997 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001444.315 | 2115232.308 | 37.788105604547 | -122.438822708512 | (37.788105604547, -122.438822708512) | 13 | 6 | 1 | 29490 | 27 | |||
5051 | 192939 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1559 Howard St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6007881.70364 | 2109409.76028 | 37.7724824224706 | -122.416137872687 | (37.7724824224706, -122.416137872687) | 8 | 2 | 9 | 28853 | 19 | |||
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 | ||
5221 | 46411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52278 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
5299 | 262438 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 540 San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000352.85514 | 2092916.82872 | 37.7267706040626 | -122.440997412 | (37.7267706040626, -122.440997412) | 9 | 7 | 6 | 28861 | 25 | ||
5301 | 230460 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 295 Precita Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008273.9062 | 2100232.70469 | 37.7473063765964 | -122.414131828735 | (37.7473063765964, -122.414131828735) | 2 | 7 | 7 | 28859 | 2 | |||
5325 | 230238 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 30 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003399.42304 | 2108502.79044 | 37.7697390612459 | -122.431577753704 | (37.7697390612459, -122.431577753704) | 15 | 9 | 5 | 29492 | 10 | |||
5462 | 230622 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1191 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6003231.87176 | 2101368.34583 | 37.7501400891166 | -122.431647872075 | (37.7501400891166, -122.431647872075) | 2 | 4 | 5 | 28862 | 22 | |||
5470 | 137605 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1241 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002263.8485 | 2112857.1338 | 37.7816305713373 | -122.435817261163 | (37.7816305713373, -122.435817261163) | 15 | 5 | 11 | 29490 | 41 | |||
5545 | 130743 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2505 Divisadero St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6000699.35516 | 2116964.23908 | 37.7928186255236 | -122.441524465083 | (37.7928186255236, -122.441524465083) | 13 | 6 | 1 | 29490 | 27 | |||
5556 | 208569 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1226 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990812.99154 | 2107022.03649 | 37.7649518737544 | -122.475005306654 | (37.7649518737544, -122.475005306654) | 11 | 8 | 11 | 56 | 12 | |||
5706 | 230617 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301 Jersey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003140.93999 | 2101524.62009 | 37.7505640268286 | -122.431973477016 | (37.7505640268286, -122.431973477016) | 2 | 4 | 5 | 28862 | 22 | |||
5791 | 171860 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 909 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009090.60075 | 2091384.92035 | 37.7230581082272 | -122.410683014136 | (37.7230581082272, -122.410683014136) | 9 | 3 | 7 | 309 | 28 | |||
5807 | 2413 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2773 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2013 12:00:00 AM | 3 | 5x5 | 6009870 | 2101176 | 37.7499859781013 | -122.408679163531 | (37.7499859781013, -122.408679163531) | 2 | 4 | 7 | 28859 | 19 | ||
5873 | 168127 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999736.35511 | 2116932.30675 | 37.7926760371256 | -122.444854181598 | (37.7926760371256, -122.444854181598) | 13 | 6 | 1 | 29490 | 27 | |||
5892 | 261243 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 840 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||||
5958 | 102480 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.91154 | 37.8020306879258 | -122.427302455863 | (37.8020306879258, -122.427302455863) | 13 | 9 | 1 | 57 | 17 | |
6103 | 192898 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6012445.53716 | 2112672.64368 | 37.7816971054735 | -122.400580271289 | (37.7816971054735, -122.400580271289) | 6 | 2 | 9 | 28856 | 34 | |||
6126 | 142586 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2310 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008494.0857 | 2120777.934 | 37.803731078252 | -122.414824283354 | (37.803731078252, -122.414824283354) | 5 | 1 | 10 | 308 | 23 | |||
6195 | 208636 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 469 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993711.10983 | 2101824.71737 | 37.7508489131681 | -122.464604102194 | (37.7508489131681, -122.464604102194) | 1 | 8 | 4 | 29491 | 40 | |||
6196 | 33080 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
6248 | 21612 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005218.1717 | 2114795.8159 | 37.7871210866889 | -122.4257347292 | (37.7871210866889, -122.4257347292) | 13 | 9 | 11 | 28858 | 27 | |||
6342 | 264855 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
6389 | 138549 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2130 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002048.753 | 2114005.8939 | 37.7847725542056 | -122.436643640876 | (37.7847725542056, -122.436643640876) | 13 | 6 | 11 | 29490 | 13 | |||
6397 | 200027 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1572 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015191.8647 | 2094356.6865 | 37.7315581787012 | -122.389799462726 | (37.7315581787012, -122.389799462726) | 10 | 3 | 8 | 58 | 1 | |||
6474 | 230184 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1911 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004756.02326 | 2107181.25678 | 37.7661872463737 | -122.426791183172 | (37.7661872463737, -122.426791183172) | 8 | 4 | 5 | 28862 | 3 | |||
6531 | 192922 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6009195.26787 | 2109094.7407 | 37.7716912222994 | -122.411571845561 | (37.7716912222994, -122.411571845561) | 8 | 2 | 9 | 28853 | 34 | |||
6538 | 230207 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 26 Temple St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999930.02308 | 2105801.10604 | 37.7621236543094 | -122.443384183955 | (37.7621236543094, -122.443384183955) | 15 | 5 | 5 | 28862 | 3 | |||
6588 | 46352 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 13 | Permit Number 44595 | 6000732.4975 | 2116220.35681 | 37.7907780071577 | -122.441356390798 | (37.7907780071577, -122.441356390798) | 13 | 6 | 1 | 29490 | 27 | ||
6642 | 114245 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 54 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5996571 | 2114184 | 37.7849487713586 | -122.455607632252 | (37.7849487713586, -122.455607632252) | 11 | 6 | 1 | 54 | 31 | |||
6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
6949 | 230168 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 279 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6003584.36382 | 2106666.87413 | 37.764708561268 | -122.430807012236 | (37.764708561268, -122.430807012236) | 8 | 4 | 5 | 28862 | 3 | |||
6970 | 230089 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 160 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007184.87556 | 2098217.41585 | 37.741711615892 | -122.417754802436 | (37.741711615892, -122.417754802436) | 2 | 7 | 7 | 28859 | 2 | |||
7077 | 208685 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Margaret Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997050.0175 | 2089737.60379 | 37.7178525273547 | -122.452185875792 | (37.7178525273547, -122.452185875792) | 9 | 8 | 6 | 28861 | 24 | |||
7123 | 99440 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 990X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2012 12:00:00 AM | 3 | 3x10 | Permit Number 768748 | 6014145.42414 | 2089521.2651 | 37.7182229956809 | -122.393079032245 | (37.7182229956809, -122.393079032245) | 10 | 3 | 8 | 58 | 1 | |
7133 | 229642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 97 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007320.40243 | 2098793.80149 | 37.7433018681988 | -122.417327030917 | (37.7433018681988, -122.417327030917) | 2 | 7 | 7 | 28859 | 2 | |||
7141 | 264858 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
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 | |||
7224 | 230106 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 47 Montezuma St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007653.59945 | 2099775.01516 | 37.7460148026546 | -122.416244399181 | (37.7460148026546, -122.416244399181) | 2 | 7 | 7 | 28859 | 2 | |||
7297 | 130697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2311 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999746.50713 | 2116862.80854 | 37.7924857927226 | -122.444814057435 | (37.7924857927226, -122.444814057435) | 13 | 6 | 1 | 29490 | 27 | |||
7326 | 98693 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 48713 | 6009268 | 2109041 | 37.7715477423488 | -122.411316462549 | (37.7715477423488, -122.411316462549) | 8 | 2 | 9 | 28853 | 34 | ||
7439 | 193102 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1298 Fairfax Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6017232.41157 | 2097031.5064 | 37.7390156480633 | -122.382930908836 | (37.7390156480633, -122.382930908836) | 10 | 3 | 8 | 58 | 1 | |||
7498 | 138017 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1798 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005043.9346 | 2115067.7403 | 37.7878578757703 | -122.426356919881 | (37.7878578757703, -122.426356919881) | 13 | 9 | 11 | 28858 | 27 | |||
7592 | 229319 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3423 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006759.7758 | 2104940.35562 | 37.7601473437483 | -122.419701563095 | (37.7601473437483, -122.419701563095) | 2 | 4 | 7 | 28859 | 19 | |||
7596 | 137880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2148 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003654.0545 | 2115274.6949 | 37.7883474575543 | -122.431180423335 | (37.7883474575543, -122.431180423335) | 13 | 9 | 1 | 29490 | 27 | |||
7602 | 5107 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2680 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6002305.28224 | 2096351.99681 | 37.736313802225 | -122.434493443022 | (37.736313802225, -122.434493443022) | 2 | 7 | 5 | 63 | 7 | ||
7649 | 39891 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
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 | ||
7709 | 177350 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500x San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000388.06795 | 2092890.63875 | 37.7267006979702 | -122.440873804687 | (37.7267006979702, -122.440873804687) | 9 | 7 | 6 | 28861 | 25 | |||
7714 | 101793 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012464.9097 | 2112928.8888 | 37.7824017756076 | -122.400531256447 | (37.7824017756076, -122.400531256447) | 6 | 2 | 9 | 28856 | 34 | |||
7727 | 259597 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | ||||
7764 | 251735 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 338 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 02:05:00 PM | 3 | 3x3 | 6002437 | 2086534 | 37.7093632573177 | -122.433336687258 | (37.7093632573177, -122.433336687258) | 9 | 7 | 6 | 28861 | 5 | ||
7798 | 52068 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2005 12:00:00 AM | Permit Number 48263 | 6002387.64911421 | 2104013.98805982 | 37.7573565030376 | -122.434756406645 | (37.7573565030376, -122.434756406645) | 2 | 4 | 5 | 28862 | 3 | |||
7812 | 177349 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500x San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000408.55271 | 2092877.8532 | 37.726666758438 | -122.440802072953 | (37.726666758438, -122.440802072953) | 9 | 7 | 6 | 28861 | 25 | |||
7937 | 47337 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779205 | 5992952.66327787 | 2090462.04360939 | 37.7196060953775 | -122.466401119038 | (37.7196060953775, -122.466401119038) | 9 | 8 | 6 | 64 | 24 | |
7952 | 262419 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
7986 | 180642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 56 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6001992.8038 | 2087466.28016 | 37.7118978840556 | -122.4349385283 | (37.7118978840556, -122.4349385283) | 9 | 7 | 6 | 28861 | 5 | |||
8008 | 260640 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3936 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776281 | 6004258 | 2100777 | 37.7485745007292 | -122.428057323873 | (37.7485745007292, -122.428057323873) | 2 | 4 | 5 | 28862 | 22 | |
8021 | 130909 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1268 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008550.55684 | 2117302.71746 | 37.7941921699808 | -122.414382817833 | (37.7941921699808, -122.414382817833) | 5 | 1 | 10 | 28857 | 21 | |||
8047 | 229934 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 602 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002630.53663 | 2098906.06974 | 37.7433451534675 | -122.433551376193 | (37.7433451534675, -122.433551376193) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
8091 | 84430 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3500 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50590 | 6006171.77574756 | 2102614.8499471 | 37.7537289046252 | -122.421570013482 | (37.7537289046252, -122.421570013482) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
8164 | 192896 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | |||
8285 | 36624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
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 | ||||||||||||
8353 | 246952 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6003390.88605 | 2107111.412 | 37.7659181907902 | -122.43150793845 | (37.7659181907902, -122.43150793845) | 15 | 5 | 5 | 28862 | 3 | |||
8382 | 2324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2298X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1996 12:00:00 AM | 6 | 3X3 | 6009641.4422065 | 2103972.2905262 | 37.7576511632266 | -122.409666876922 | (37.7576511632266, -122.409666876922) | 2 | 4 | 7 | 28859 | 19 | ||
8392 | 230069 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800X Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007643.30066 | 2097725.00947 | 37.74038536408 | -122.416134851864 | (37.74038536408, -122.416134851864) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
8426 | 177304 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Ruth St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001647.41554 | 2091598.69121 | 37.723224945954 | -122.436427860461 | (37.723224945954, -122.436427860461) | 9 | 7 | 6 | 28861 | 25 | |||
8471 | 230647 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004129.21796 | 2101814.78019 | 37.7514167163076 | -122.428576614423 | (37.7514167163076, -122.428576614423) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
8620 | 230618 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 293 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003249.58488 | 2101526.98547 | 37.7505766802717 | -122.431597943511 | (37.7505766802717, -122.431597943511) | 2 | 4 | 5 | 28862 | 22 | |||
8647 | 146616 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | Permit Number 783073 | 6005474.41066 | 2120313.40732 | 37.8022854748664 | -122.425240967805 | (37.8022854748664, -122.425240967805) | 13 | 9 | 1 | 57 | 17 | ||
8654 | 142867 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1020 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006956.6744 | 2114391.9796 | 37.786110337763 | -122.41969121449 | (37.786110337763, -122.41969121449) | 13 | 9 | 9 | 28858 | 36 | |||
8813 | 229976 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1983 12:00:00 AM | 13 | Width 2ft | Permit Number 20257 | 6003460.20133 | 2096023.86311 | 37.7354783140686 | -122.430477003328 | (37.7354783140686, -122.430477003328) | 2 | 7 | 5 | 63 | 7 | |
8825 | 36621 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8865 | 248498 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998302.5369 | 2107853.4873 | 37.7676660307619 | -122.449160873661 | (37.7676660307619, -122.449160873661) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
8963 | 36618 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8967 | 18314 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 180 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782360 | 6010236.79256 | 2107510.48621 | 37.7673995909374 | -122.407857396411 | (37.7673995909374, -122.407857396411) | 8 | 4 | 8 | 28853 | 19 | |
8990 | 229341 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2384 Bryant St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 6009657.14519 | 2103466.25311 | 37.7562625782597 | -122.409576854282 | (37.7562625782597, -122.409576854282) | 2 | 4 | 7 | 28859 | 19 | |||
9118 | 120468 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988384.0014 | 2115083.94801 | 37.7869465618324 | -122.483997692017 | (37.7869465618324, -122.483997692017) | 11 | 6 | 1 | 55 | 33 | |||
9123 | 46414 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
9133 | 229721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3345 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 768018 | 6007953.43646 | 2104421.40603 | 37.7587895958797 | -122.415536504129 | (37.7587895958797, -122.415536504129) | 2 | 4 | 7 | 28859 | 19 | ||
9142 | 28298 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 637 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2003 12:00:00 AM | 3 | 3X3 | 6010087.47543 | 2115987.95406 | 37.7906683645059 | -122.408972077304 | (37.7906683645059, -122.408972077304) | 5 | 1 | 10 | 28857 | 21 | ||
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 | |||
9273 | 28375 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3014 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | 3 | 3x3 | Permit Number 54020 | 6000248.59092 | 2115494.6796 | 37.7887579085949 | -122.442978542939 | (37.7887579085949, -122.442978542939) | 13 | 6 | 1 | 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 |
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) );