trees
6,344 rows where qSpecies_id = 19 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
5418 | 70426 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1590 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6006596.62742 | 2117360.41575 | 37.7942406389433 | -122.42114773947 | (37.7942406389433, -122.42114773947) | 13 | 9 | 10 | 28858 | 32 | ||
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 | ||||
5932 | 70322 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997855.1178 | 2109822.7379 | 37.7730474875653 | -122.45085044117 | (37.7730474875653, -122.45085044117) | 15 | 5 | 11 | 29492 | 16 | |||
6085 | 82927 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1140 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6010031.8585 | 2110690.2274 | 37.7761189490017 | -122.40879059487 | (37.7761189490017, -122.40879059487) | 8 | 2 | 9 | 28853 | 34 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
7708 | 76081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
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 | ||
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 | |||
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 | |||
8087 | 188688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 02:16:00 PM | 3 | Width 4ft | 6017441.41972 | 2097257.16832 | 37.739646816544 | -122.382223941884 | (37.739646816544, -122.382223941884) | 10 | 3 | 8 | 58 | 1 | ||
8140 | 26662 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2001 12:00:00 AM | 8 | 3x3 | 6017216.3972 | 2096959.142 | 37.7388160650952 | -122.382981244792 | (37.7388160650952, -122.382981244792) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
9417 | 203065 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 01:10:00 PM | 3 | Width 3ft | 6017458.84969 | 2097245.24162 | 37.7396150308979 | -122.382162846439 | (37.7396150308979, -122.382162846439) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
9630 | 248945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500x Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:00:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
9640 | 17196 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2235X Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6004629.78741 | 2116932.39582 | 37.792954330542 | -122.427922714666 | (37.792954330542, -122.427922714666) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
9683 | 13057 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2014 12:00:00 AM | 3 | 2x2 | 6009630.8999 | 2120542.6321 | 37.8031488074681 | -122.410873631329 | (37.8031488074681, -122.410873631329) | 3 | 1 | 10 | 308 | 23 | ||
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 | |||
9869 | 5383 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 325X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/06/2009 12:00:00 AM | 3 | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | ||
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 |
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) );