trees
6,344 rows where qSpecies_id = 19 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 6252 | 70020 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5999648.4798 | 2110952.3759 | 37.7762516842269 | -122.444728210696 | (37.7762516842269, -122.444728210696) | 15 | 5 | 11 | 29492 | 16 | |||
| 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 | |||
| 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 | |||
| 6719 | 72384 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 592 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010697.2489 | 2118956.7107 | 37.7988539907437 | -122.407071630807 | (37.7988539907437, -122.407071630807) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 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 | |||
| 7277 | 71773 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1207 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007676.74747 | 2115431.38608 | 37.7890048300542 | -122.417273630072 | (37.7890048300542, -122.417273630072) | 13 | 1 | 10 | 28858 | 21 | |||
| 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 | ||
| 7409 | 79285 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994906.63121 | 2110258.22071 | 37.7740739800962 | -122.46108112387 | (37.7740739800962, -122.46108112387) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 7550 | 71272 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2477 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6000730.11 | 2114120.4408 | 37.785012045879 | -122.441213921365 | (37.785012045879, -122.441213921365) | 15 | 6 | 11 | 29490 | 13 | |||
| 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 | |||
| 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 | ||||
| 7772 | 74841 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6011912.74207 | 2119472.92585 | 37.800339337445 | -122.402901928701 | (37.800339337445, -122.402901928701) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 7815 | 78721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 115 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008722.75942 | 2087395.11673 | 37.7120823080297 | -122.411672802567 | (37.7120823080297, -122.411672802567) | 9 | 7 | 8 | 309 | 39 | |||
| 7871 | 104619 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 7 | 4x4 | Permit Number 770959 | 6012190.226 | 2112753.6665 | 37.7819053332353 | -122.401469228728 | (37.7819053332353, -122.401469228728) | 6 | 2 | 9 | 28853 | 34 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 8191 | 74104 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 189 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6006471.06973 | 2093054.28635 | 37.7274946077702 | -122.419856624186 | (37.7274946077702, -122.419856624186) | 9 | 7 | 7 | 309 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 8615 | 81216 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1490 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5989947.3486 | 2105228.4272 | 37.7599768999261 | -122.477868186468 | (37.7599768999261, -122.477868186468) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 8704 | 79435 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 606 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004044.7014 | 2110862.9754 | 37.7762561050616 | -122.429514097991 | (37.7762561050616, -122.429514097991) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 8989 | 70675 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009740.45587 | 2110875.89947 | 37.7766124348397 | -122.409811748212 | (37.7766124348397, -122.409811748212) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 9373 | 71806 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2567 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988291.4423 | 2097857.1501 | 37.7396410933419 | -122.483054814949 | (37.7396410933419, -122.483054814949) | 1 | 8 | 3 | 29491 | 35 | |||
| 9409 | 76076 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Rausch St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009855.80512 | 2110709.84536 | 37.7761629527799 | -122.409400998174 | (37.7761629527799, -122.409400998174) | 8 | 2 | 9 | 28853 | 34 | |||
| 9422 | 80211 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 340 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008650.63461 | 2108952.54787 | 37.7712702289655 | -122.413445714359 | (37.7712702289655, -122.413445714359) | 8 | 2 | 9 | 28853 | 19 | |||
| 9477 | 193012 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013566.4311 | 2097855.47673 | 37.7410748608127 | -122.395663996006 | (37.7410748608127, -122.395663996006) | 10 | 3 | 8 | 58 | 1 | |||
| 9484 | 71331 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 315 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011757.84173 | 2112077.6198 | 37.7800249312328 | -122.402917523848 | (37.7800249312328, -122.402917523848) | 6 | 2 | 9 | 28856 | 34 | |||
| 9497 | 193189 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 401 Harrison St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014845.7191 | 2114331.63578 | 37.7863858864432 | -122.392392780401 | (37.7863858864432, -122.392392780401) | 6 | 2 | 9 | 28855 | 6 | |||
| 9503 | 109132 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 124 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6008117 | 2098031 | 37.7412521699945 | -122.414518628477 | (37.7412521699945, -122.414518628477) | 2 | 7 | 7 | 28859 | 2 | ||||
| 9593 | 70541 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1830 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6000327.1082 | 2111334.4422 | 37.777339444143 | -122.442408091617 | (37.777339444143, -122.442408091617) | 15 | 5 | 11 | 29490 | 16 | |||
| 9614 | 130665 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3152 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999642.12267 | 2116065.45546 | 37.7902905134552 | -122.445117879904 | (37.7902905134552, -122.445117879904) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | |||
| 9654 | 230071 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007616.48764 | 2097727.27317 | 37.7403900720444 | -122.416227721243 | (37.7403900720444, -122.416227721243) | 2 | 7 | 7 | 28859 | 2 | |||
| 9680 | 230722 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4244 19th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001792.12891 | 2104707.83961 | 37.759227823833 | -122.436865617157 | (37.759227823833, -122.436865617157) | 2 | 4 | 5 | 28862 | 3 | |||
| 9744 | 19850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10ST | |||||||||||||
| 9796 | 72145 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001088.11474 | 2092709.73665 | 37.72624382708 | -122.438440814794 | (37.72624382708, -122.438440814794) | 9 | 7 | 6 | 28861 | 25 | |||
| 9882 | 110280 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2845 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 5999937.93955 | 2117050.91929 | 37.7930132181276 | -122.444165220867 | (37.7930132181276, -122.444165220867) | 13 | 9 | 1 | 29490 | 27 | |||
| 9918 | 74256 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1126X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6009656.55619 | 2111209.09392 | 37.7775226063216 | -122.410125511783 | (37.7775226063216, -122.410125511783) | 8 | 2 | 9 | 28853 | 34 | |||
| 9972 | 71995 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5984088.02561 | 2113084.30818 | 37.7812050975324 | -122.498712783587 | (37.7812050975324, -122.498712783587) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 10060 | 262273 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2470 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 6002133 | 2097220 | 37.738687356955 | -122.435151157914 | (37.738687356955, -122.435151157914) | 2 | 7 | 5 | 63 | 7 | ||||
| 10064 | 229649 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 46 Mirabel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007603.84542 | 2099930.90044 | 37.7464400309007 | -122.416427482269 | (37.7464400309007, -122.416427482269) | 2 | 7 | 7 | 28859 | 2 | |||
| 10130 | 193311 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1433 Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016240.13881 | 2097427.00946 | 37.7400467432612 | -122.386389332697 | (37.7400467432612, -122.386389332697) | 10 | 3 | 8 | 58 | 1 | |||
| 10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
| 10244 | 82748 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1434-1436 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008231.53118 | 2109847.29583 | 37.7737034553791 | -122.414958754439 | (37.7737034553791, -122.414958754439) | 8 | 2 | 9 | 28853 | 34 | |||
| 10254 | 201218 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 687 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6013091.2306 | 2113527.2998 | 37.7840797833092 | -122.398406448239 | (37.7840797833092, -122.398406448239) | 6 | 2 | 9 | 28856 | 6 | |||
| 10262 | 71774 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007619.84868 | 2115422.03298 | 37.7889759474427 | -122.417469829771 | (37.7889759474427, -122.417469829771) | 13 | 1 | 10 | 28858 | 21 | |||
| 10273 | 73717 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1512 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6x6 | 6013119.6515 | 2105226.52414 | 37.7612893091654 | -122.397725698092 | (37.7612893091654, -122.397725698092) | 10 | 3 | 8 | 28856 | 29 | ||
| 10274 | 39974 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
| 10334 | 193296 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018120.52005 | 2093146.99774 | 37.728398581107 | -122.379590415761 | (37.728398581107, -122.379590415761) | 10 | 3 | 8 | 58 | 1 | |||
| 10345 | 177314 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6002705.04854 | 2090582.53455 | 37.7204948470285 | -122.432699277554 | (37.7204948470285, -122.432699277554) | 9 | 7 | 6 | 28861 | 5 | |||
| 10500 | 99636 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2201@Vallejo Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006351.46016 | 2118390.69708 | 37.7970557085202 | -122.422069273873 | (37.7970557085202, -122.422069273873) | 13 | 9 | 10 | 28858 | 32 | |||
| 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 | |||
| 10717 | 73755 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 592 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 4x4 | 6010721.4091 | 2118959.281 | 37.7988624001506 | -122.406988209463 | (37.7988624001506, -122.406988209463) | 3 | 1 | 10 | 308 | 23 | ||
| 10827 | 193103 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1360 Fairfax Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6016766.03407 | 2097379.43395 | 37.7399452071057 | -122.384567672275 | (37.7399452071057, -122.384567672275) | 10 | 3 | 8 | 58 | 1 | |||
| 10868 | 230575 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 584 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 9x20 | 6001828.72646 | 2102434.6991 | 37.752988407514 | -122.436576340331 | (37.752988407514, -122.436576340331) | 2 | 4 | 5 | 28862 | 22 | |||
| 10931 | 193216 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Brannan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6013216.14313 | 2111018.43297 | 37.7771979681544 | -122.397798251806 | (37.7771979681544, -122.397798251806) | 6 | 2 | 9 | 28856 | 34 | |||
| 10952 | 230635 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3936 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003520.29568 | 2102463.05796 | 37.7531622554484 | -122.430728595871 | (37.7531622554484, -122.430728595871) | 2 | 4 | 5 | 28862 | 22 | |||
| 11033 | 70684 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6010365.45358 | 2111155.37964 | 37.7774148279639 | -122.407669399445 | (37.7774148279639, -122.407669399445) | 14 | 2 | 9 | 28853 | 34 | |||
| 11043 | 73644 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007593.08329 | 2115418.15258 | 37.7889637868037 | -122.417562159565 | (37.7889637868037, -122.417562159565) | 13 | 1 | 10 | 28858 | 21 | |||
| 11199 | 73361 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Huntington Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984617.03994 | 2094708.01424 | 37.730779908566 | -122.495526924733 | (37.730779908566, -122.495526924733) | 1 | 8 | 4 | 64 | 35 | |||
| 11316 | 120672 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3819 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004118 | 2105356 | 37.7611394347307 | -122.42886784279 | (37.7611394347307, -122.42886784279) | 2 | 4 | 5 | 28862 | 3 | ||||
| 11348 | 230537 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3050 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008865.82933 | 2104992.65808 | 37.7604093666147 | -122.412421395528 | (37.7604093666147, -122.412421395528) | 2 | 4 | 7 | 28859 | 19 | |||
| 11422 | 229497 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004419.76792 | 2103195.09232 | 37.7552231688176 | -122.427670192252 | (37.7552231688176, -122.427670192252) | 2 | 4 | 5 | 28862 | 22 | |||
| 11507 | 71409 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1510 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015375.9848 | 2094913.1689 | 37.7330963758454 | -122.389201760959 | (37.7330963758454, -122.389201760959) | 10 | 3 | 8 | 58 | 1 | |||
| 11555 | 250317 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3800 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995989.81412 | 2115885.19527 | 37.789586427918 | -122.457741476398 | (37.789586427918, -122.457741476398) | 11 | 6 | 1 | 54 | 31 | |||
| 11668 | 140846 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996563.342 | 2113760.0078 | 37.7837841621477 | -122.455603469395 | (37.7837841621477, -122.455603469395) | 11 | 6 | 1 | 54 | 31 |
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) );