trees
8,659 rows where qSpecies_id = 11 sorted by DBH descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115934 | 12526 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 45 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5995287.93021 | 2114888.84585 | 37.7868103758205 | -122.460097693179 | (37.7868103758205, -122.460097693179) | 11 | 6 | 1 | 54 | 11 | |||
| 254 | 130309 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013009.60555 | 2119229.44522 | 37.7997319839043 | -122.399089221411 | (37.7997319839043, -122.399089221411) | 3 | 1 | 10 | 28860 | 6 | |||
| 2281 | 202367 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6015662.52454 | 2115317.40495 | 37.7891379072269 | -122.389635690147 | (37.7891379072269, -122.389635690147) | 6 | 2 | 9 | 28855 | 6 | |||
| 2995 | 202498 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 85 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015682.27104 | 2112499.834 | 37.7814025909853 | -122.389370531319 | (37.7814025909853, -122.389370531319) | 6 | 2 | 9 | 28856 | 20 | |||
| 3644 | 123178 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 755 10th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 5992851.1981 | 2110319.16368 | 37.7741228178256 | -122.46819559495 | (37.7741228178256, -122.46819559495) | 11 | 6 | 2 | 54 | 11 | |||
| 5911 | 228080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 890 Clipper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999913.84424 | 2100703.76258 | 37.7481266725268 | -122.443074048252 | (37.7481266725268, -122.443074048252) | 2 | 4 | 5 | 63 | 22 | |||
| 7434 | 201009 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2200 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015701.77252 | 2105218.85803 | 37.7614117114021 | -122.388794618095 | (37.7614117114021, -122.388794618095) | 10 | 3 | 8 | 28856 | 29 | |||
| 7718 | 129913 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 514 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004072.23496 | 2110659.68324 | 37.7756994736965 | -122.429404351323 | (37.7756994736965, -122.429404351323) | 7 | 9 | 11 | 28852 | 10 | |||
| 8428 | 228137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 266 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997698.72333 | 2105921.93859 | 37.762327934407 | -122.451110070772 | (37.762327934407, -122.451110070772) | 15 | 5 | 11 | 29492 | 9 | |||
| 8442 | 43966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.7819892007742 | -122.419834861512 | (37.7819892007742, -122.419834861512) | 7 | 9 | 9 | 28852 | 36 | |
| 10343 | 11383 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1427X Innes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X4 | 6016450.87108 | 2096464.39171 | 37.7374152523015 | -122.385593629655 | (37.7374152523015, -122.385593629655) | 10 | 3 | 8 | 58 | 1 | |||
| 11499 | 201065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1521 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013096.76712 | 2105645.47776 | 37.7624383891432 | -122.397834234559 | (37.7624383891432, -122.397834234559) | 10 | 3 | 8 | 28856 | 29 | |||
| 11779 | 44518 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 100X TOWNSEND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2001 12:00:00 AM | 9 | 3x3 | Permit Number 43820 | 6015218.7 | 2112179.2 | 37.7804964903429 | -122.390951859139 | (37.7804964903429, -122.390951859139) | 6 | 2 | 9 | 28856 | 6 | |
| 12748 | 75994 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007959.81163 | 2114150.16473 | 37.7855028295219 | -122.416203484529 | (37.7855028295219, -122.416203484529) | 13 | 10 | 9 | 28858 | 36 | |||
| 12965 | 87494 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2101X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015776.11419 | 2105772.8424 | 37.7629369535127 | -122.388576170051 | (37.7629369535127, -122.388576170051) | 10 | 3 | 8 | 28856 | 29 | |||
| 13227 | 70595 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 330 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 9 | 6004399.02118 | 2091228.09004 | 37.7223633261893 | -122.426889705722 | (37.7223633261893, -122.426889705722) | 9 | 7 | 6 | 28861 | 5 | ||
| 13320 | 130154 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 155 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006852.76549 | 2111067.6012 | 37.7769765487554 | -122.419814736462 | (37.7769765487554, -122.419814736462) | 7 | 9 | 11 | 28852 | 10 | |||
| 14013 | 200426 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2833 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015966.04609 | 2102385.20565 | 37.7536457471676 | -122.387682886976 | (37.7536457471676, -122.387682886976) | 10 | 3 | 8 | 28856 | 29 | |||
| 14829 | 76313 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015835.10862 | 2112662.38098 | 37.7818573808501 | -122.388853134261 | (37.7818573808501, -122.388853134261) | 6 | 2 | 9 | 28856 | 6 | |||
| 15175 | 228185 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006350.04834 | 2102712.73442 | 37.7540077233873 | -122.420960454787 | (37.7540077233873, -122.420960454787) | 2 | 4 | 5 | 28859 | 19 | |||
| 15953 | 201070 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1251 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6013524.95 | 2106139.60488 | 37.7638189896873 | -122.39638793316 | (37.7638189896873, -122.39638793316) | 14 | 3 | 8 | 28856 | 29 | |||
| 16268 | 3823 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2001 12:00:00 AM | 9 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | ||
| 17231 | 228659 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4411 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001356.52331 | 2104641.23246 | 37.7590201694651 | -122.438367376148 | (37.7590201694651, -122.438367376148) | 2 | 4 | 5 | 28862 | 3 | |||
| 18099 | 103406 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011568.485 | 2113577.7367 | 37.7841333266454 | -122.403678177607 | (37.7841333266454, -122.403678177607) | 12 | 2 | 9 | 28853 | 6 | |||
| 18357 | 130279 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 580 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007522.60247 | 2121991.88932 | 37.8070096576235 | -122.418272284063 | (37.8070096576235, -122.418272284063) | 5 | 1 | 10 | 308 | 23 | |||
| 19352 | 229029 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004118.1154 | 2108504.17178 | 37.7697835632819 | -122.429091916071 | (37.7697835632819, -122.429091916071) | 7 | 9 | 5 | 29492 | 10 | |||
| 19825 | 46978 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1310 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 9 | Permit Number 44998 | 6015319.0594 | 2102452.12471 | 37.7537936334853 | -122.389925003839 | (37.7537936334853, -122.389925003839) | 10 | 3 | 8 | 28856 | 29 | ||
| 20464 | 208353 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990626.63647 | 2093347.44726 | 37.727394203873 | -122.474651748098 | (37.727394203873, -122.474651748098) | 9 | 8 | 4 | 64 | 40 | |||
| 20473 | 208314 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 931 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001504.4065 | 2095542.47222 | 37.7340455402682 | -122.437204453845 | (37.7340455402682, -122.437204453845) | 9 | 7 | 5 | 63 | 40 | |||
| 22710 | 229085 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Putnam St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6009095.80428 | 2096224.9104 | 37.736347980961 | -122.411006719696 | (37.736347980961, -122.411006719696) | 10 | 7 | 7 | 28859 | 2 | |||
| 23146 | 201033 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015782.11594 | 2105288.83961 | 37.7616083184908 | -122.388521626165 | (37.7616083184908, -122.388521626165) | 10 | 3 | 8 | 28856 | 29 | |||
| 23743 | 191626 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 55 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011384.80755 | 2113783.51074 | 37.78468807163 | -122.404328127538 | (37.78468807163, -122.404328127538) | 12 | 2 | 9 | 28853 | 6 | |||
| 24235 | 48729 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1208 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 9 | Permit Number 47066 | 6009116.40936 | 2110693.34908 | 37.7760762023912 | -122.411957611548 | (37.7760762023912, -122.411957611548) | 8 | 2 | 9 | 28853 | 34 | |
| 25219 | 129908 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001694.14605 | 2120844.10453 | 37.8035283424228 | -122.438360541313 | (37.8035283424228, -122.438360541313) | 13 | 9 | 1 | 57 | 17 | |||
| 27791 | 202356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 80 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6015882.91814 | 2115414.83263 | 37.7894176395637 | -122.38887995385 | (37.7894176395637, -122.38887995385) | 6 | 2 | 9 | 28855 | 6 | |||
| 31500 | 46438 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 801 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2002 12:00:00 AM | 9 | Permit Number 44657 | 6008994.83708 | 2120066.08449 | 37.8018046406429 | -122.41304103653 | (37.8018046406429, -122.41304103653) | 3 | 1 | 10 | 308 | 32 | ||
| 31942 | 130278 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007607.17064 | 2122005.04934 | 37.8070505515945 | -122.417980551172 | (37.8070505515945, -122.417980551172) | 5 | 1 | 10 | 308 | 23 | |||
| 33105 | 229102 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2355 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008210.80852 | 2104740.89325 | 37.7596812979599 | -122.414668999194 | (37.7596812979599, -122.414668999194) | 2 | 4 | 7 | 28859 | 19 | |||
| 33494 | 228610 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008738.30789 | 2106670.03017 | 37.7650078880392 | -122.412981035564 | (37.7650078880392, -122.412981035564) | 8 | 4 | 7 | 28859 | 19 | |||
| 34161 | 17749 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005944.2845 | 2115534.71048 | 37.7891909123744 | -122.423275079495 | (37.7891909123744, -122.423275079495) | 13 | 9 | 1 | 28858 | 41 | |||
| 34843 | 130217 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1625 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007864.11541 | 2117971.81072 | 37.7959907493387 | -122.416805412445 | (37.7959907493387, -122.416805412445) | 5 | 1 | 10 | 28858 | 32 | |||
| 35671 | 99 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6002314.25424 | 2107678.41928 | 37.7674139737948 | -122.435272341345 | (37.7674139737948, -122.435272341345) | 15 | 5 | 5 | 28862 | 3 | |||
| 35988 | 17646 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 36416 | 25202 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 185 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1996 12:00:00 AM | 9 | 3X3 | 6006442.96091 | 2110721.59059 | 37.7760033923708 | -122.42120780342 | (37.7760033923708, -122.42120780342) | 7 | 9 | 11 | 28852 | 10 | ||
| 37328 | 129924 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3195 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998986.03075 | 2116580.385 | 37.79166690426 | -122.447424980874 | (37.79166690426, -122.447424980874) | 13 | 6 | 1 | 29490 | 31 | |||
| 37525 | 130208 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009388.81251 | 2117500.36973 | 37.7947819282951 | -122.411496320518 | (37.7947819282951, -122.411496320518) | 3 | 1 | 10 | 28857 | 21 | |||
| 38801 | 229005 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005562.97361 | 2103996.01958 | 37.7574869278932 | -122.423773590776 | (37.7574869278932, -122.423773590776) | 2 | 4 | 5 | 28859 | 19 | |||
| 39262 | 228882 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 325 Buchanan St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6004636.24006 | 2109767.89618 | 37.773282759734 | -122.427389773718 | (37.773282759734, -122.427389773718) | 7 | 9 | 11 | 28852 | 10 | |||
| 40303 | 192656 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Cashmere St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6016666.45643 | 2095945.35214 | 37.7360020000976 | -122.384812095401 | (37.7360020000976, -122.384812095401) | 10 | 3 | 8 | 58 | 1 | |||
| 41177 | 228594 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2130 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008725.50116 | 2105826.99878 | 37.7626923990652 | -122.412965720111 | (37.7626923990652, -122.412965720111) | 8 | 4 | 7 | 28859 | 19 | |||
| 41794 | 202457 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6015279.90066 | 2113895.71742 | 37.7852130544834 | -122.390860133284 | (37.7852130544834, -122.390860133284) | 6 | 2 | 9 | 28856 | 6 | |||
| 41812 | 115588 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2574 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5987741.7 | 2097778.5 | 37.7393931357191 | -122.484949795247 | (37.7393931357191, -122.484949795247) | 1 | 8 | 3 | 29491 | 35 | |||
| 41964 | 228923 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009159.94253 | 2107892.60935 | 37.7683884674727 | -122.411609088284 | (37.7683884674727, -122.411609088284) | 8 | 4 | 7 | 28853 | 19 | |||
| 42179 | 228879 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 319 Buchanan St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6004642.9134 | 2109713.8516 | 37.7731347438955 | -122.42736283903 | (37.7731347438955, -122.42736283903) | 7 | 9 | 11 | 28852 | 10 | |||
| 42331 | 76087 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 9 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
| 43179 | 201139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1101 Cesar Chavez St | 11 | : | Tree | Private 2 | 9 | Width 3ft | 6015600.46531 | 2101064.45563 | 37.7499989881596 | -122.38885495811 | (37.7499989881596, -122.38885495811) | 10 | 3 | 8 | 58 | 1 | |||
| 43238 | 130213 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 24 Priest St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6008335.34786 | 2117068.60071 | 37.7935372512871 | -122.415110887372 | (37.7935372512871, -122.415110887372) | 5 | 1 | 10 | 28858 | 21 | |||
| 43420 | 130061 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 820 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007325.91197 | 2114044.21716 | 37.7851762596074 | -122.41838908081 | (37.7851762596074, -122.41838908081) | 13 | 9 | 9 | 28858 | 36 | |||
| 44790 | 3854 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 201X Cashmere St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2000 12:00:00 AM | 9 | 3X3 | 6016272.1162427 | 2096165.2075517 | 37.7365838606598 | -122.386190822782 | (37.7365838606598, -122.386190822782) | 10 | 3 | 8 | 58 | 1 | ||
| 45452 | 228889 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 111 Rose St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6005969.72731 | 2109827.64618 | 37.7735221466577 | -122.422781300437 | (37.7735221466577, -122.422781300437) | 7 | 9 | 11 | 28852 | 10 | |||
| 45453 | 228736 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003754.40351 | 2105987.78559 | 37.7628535800617 | -122.430170439739 | (37.7628535800617, -122.430170439739) | 8 | 4 | 5 | 28862 | 3 | |||
| 45540 | 3561 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1990 12:00:00 AM | 9 | 3X3 | 6018825.45661 | 2097503.92555 | 37.7404007092258 | -122.377455601495 | (37.7404007092258, -122.377455601495) | 10 | 3 | 8 | 58 | 1 | ||
| 47733 | 200379 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 199x Shipley St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6011845.86017 | 2112058.58583 | 37.7799775828272 | -122.402611687797 | (37.7799775828272, -122.402611687797) | 6 | 2 | 9 | 28856 | 34 | |||
| 48189 | 129891 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996747.37477 | 2114962.34995 | 37.7870960324911 | -122.455053698681 | (37.7870960324911, -122.455053698681) | 11 | 6 | 1 | 54 | 31 | |||
| 48505 | 191647 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 151 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012350.85941 | 2114083.24662 | 37.7855650122485 | -122.401006956427 | (37.7855650122485, -122.401006956427) | 12 | 2 | 9 | 28855 | 6 | |||
| 48831 | 202516 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 320 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014290.11017 | 2114586.26954 | 37.7870541834434 | -122.394332895973 | (37.7870541834434, -122.394332895973) | 6 | 2 | 9 | 28855 | 6 | |||
| 48991 | 202489 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 87 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015438.24984 | 2112261.01161 | 37.7807333065347 | -122.390198043414 | (37.7807333065347, -122.390198043414) | 6 | 2 | 9 | 28856 | 20 | |||
| 49182 | 9893 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6005337.6793 | 2115599.88016 | 37.7893355988943 | -122.425378500212 | (37.7893355988943, -122.425378500212) | 13 | 9 | 1 | 28858 | 41 | |||
| 49768 | 3810 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/1996 12:00:00 AM | 9 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | ||
| 51025 | 228059 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2091 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008737.60848 | 2106648.18118 | 37.7649478564946 | -122.412981909698 | (37.7649478564946, -122.412981909698) | 8 | 4 | 7 | 28859 | 19 | |||
| 51223 | 43964 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006944.53413 | 2112900.54785 | 37.7820145463837 | -122.419627360011 | (37.7820145463837, -122.419627360011) | 7 | 9 | 9 | 28852 | 36 | ||
| 51330 | 52933 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 121 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48919 | 6002130.00279 | 2093663.59008 | 37.7289221016565 | -122.434907252564 | (37.7289221016565, -122.434907252564) | 9 | 7 | 6 | 28861 | 25 | |
| 51528 | 228038 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3131 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007401.69326 | 2103806.80552 | 37.7570710157207 | -122.417401135976 | (37.7570710157207, -122.417401135976) | 2 | 4 | 7 | 28859 | 19 | |||
| 52319 | 76025 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 9 | 3x4 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
| 53309 | 103396 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011787.04234 | 2113349.22231 | 37.7835180860448 | -122.402905965761 | (37.7835180860448, -122.402905965761) | 12 | 2 | 9 | 28853 | 6 | |||
| 54542 | 201133 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1301 Cesar Chavez St | 7 | : | Tree | Private 2 | 9 | Width 3ft | 6015048.67702 | 2101059.96024 | 37.7499560455565 | -122.390762772693 | (37.7499560455565, -122.390762772693) | 10 | 3 | 8 | 58 | 1 | |||
| 55013 | 61498 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 143 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1984 12:00:00 AM | 9 | Permit Number 21449 | 5989578.4132 | 2114401.34874 | 37.7851418001746 | -122.479815377723 | (37.7851418001746, -122.479815377723) | 11 | 6 | 2 | 55 | 26 | |
| 55295 | 229119 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007613.86357 | 2104139.81261 | 37.7579973120563 | -122.41669095844 | (37.7579973120563, -122.41669095844) | 2 | 4 | 7 | 28859 | 19 | |||
| 55435 | 200406 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 327 09th St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6009265.31403 | 2109822.61396 | 37.7736937211222 | -122.411380980648 | (37.7736937211222, -122.411380980648) | 8 | 2 | 9 | 28853 | 34 | |||
| 55624 | 246843 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 5 | : | Tree | DPW for City Agency 14 | 9 | Width 3ft | 6001198.91277 | 2109877.26909 | 37.7733880658265 | -122.439287771129 | (37.7733880658265, -122.439287771129) | 15 | 5 | 11 | 29492 | 10 | |||
| 56012 | 202496 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 87 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015593.65119 | 2112426.98973 | 37.7811976633865 | -122.38967202635 | (37.7811976633865, -122.38967202635) | 6 | 2 | 9 | 28856 | 20 | |||
| 56683 | 228960 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007934.08624 | 2107362.27958 | 37.766863466401 | -122.415811667897 | (37.766863466401, -122.415811667897) | 8 | 4 | 7 | 28853 | 19 | |||
| 57439 | 228749 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 12 Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000594.4407 | 2105548.49667 | 37.7614679181278 | -122.441068100511 | (37.7614679181278, -122.441068100511) | 15 | 5 | 5 | 28862 | 3 | |||
| 58019 | 130363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6011809.34098 | 2121067.49936 | 37.804711873607 | -122.40337198005 | (37.804711873607, -122.40337198005) | 3 | 1 | 10 | 28860 | 6 | |||
| 58190 | 43414 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 246 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | 9 | Permit Number 43159 | 6013391.0866 | 2114213.64892 | 37.7859810386389 | -122.397417197364 | (37.7859810386389, -122.397417197364) | 6 | 2 | 9 | 28855 | 6 | ||
| 59557 | 202491 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 87 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015462.64565 | 2112286.54201 | 37.7808047603743 | -122.39011542988 | (37.7808047603743, -122.39011542988) | 6 | 2 | 9 | 28856 | 20 | |||
| 60518 | 208348 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3586 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990586.58923 | 2092794.78382 | 37.725874408051 | -122.474749869538 | (37.725874408051, -122.474749869538) | 9 | 8 | 4 | 64 | 40 | |||
| 60959 | 130400 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 634 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011433.74707 | 2117200.73697 | 37.7940736977875 | -122.404399426685 | (37.7940736977875, -122.404399426685) | 3 | 1 | 10 | 28860 | 4 | |||
| 60977 | 208193 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 338 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992887.48324 | 2102568.44628 | 37.752843485341 | -122.467506332278 | (37.752843485341, -122.467506332278) | 1 | 8 | 4 | 56 | 12 | |||
| 61329 | 228876 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 315 Buchanan St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6004653.7435 | 2109627.59843 | 37.7728985261808 | -122.427319230894 | (37.7728985261808, -122.427319230894) | 7 | 9 | 11 | 28852 | 10 | |||
| 61385 | 249391 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 280 Turk St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6008635.33064 | 2113188.06913 | 37.7828991069454 | -122.413798301662 | (37.7828991069454, -122.413798301662) | 7 | 10 | 9 | 28852 | 36 | |||
| 61812 | 61257 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1845 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 9 | Permit Number 30068 | 6007758.72791 | 2118741.72508 | 37.7980988141591 | -122.417224659311 | (37.7980988141591, -122.417224659311) | 5 | 1 | 10 | 28858 | 32 | |
| 62106 | 11421 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1491 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X4 | 6016096.72349 | 2096745.31207 | 37.7381670009985 | -122.386837679833 | (37.7381670009985, -122.386837679833) | 10 | 3 | 8 | 58 | 1 | |||
| 62394 | 39464 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 9 | Permit Number 40935 | 6013007.13144 | 2117612.41259 | 37.7952918600786 | -122.398984224639 | (37.7952918600786, -122.398984224639) | 3 | 1 | 10 | 28860 | 6 | ||
| 63001 | 85312 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 1366 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6003535.85294 | 2112477.60862 | 37.7806606630436 | -122.431389631549 | (37.7806606630436, -122.431389631549) | 15 | 9 | 11 | 29490 | 41 | |||
| 63367 | 201002 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 901 24th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015554.77648 | 2102512.25334 | 37.753971803572 | -122.389114031191 | (37.753971803572, -122.389114031191) | 10 | 3 | 8 | 28856 | 29 | |||
| 64371 | 228740 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003676.37328 | 2105981.98947 | 37.7628332454699 | -122.430439905384 | (37.7628332454699, -122.430439905384) | 8 | 4 | 5 | 28862 | 3 | |||
| 65637 | 202589 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6012146.02673 | 2108653.71558 | 37.7706453422429 | -122.401333927439 | (37.7706453422429, -122.401333927439) | 14 | 2 | 8 | 28856 | 20 | |||
| 66890 | 228552 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 910 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006271.0444 | 2104254.3251 | 37.75823612072 | -122.421343136988 | (37.75823612072, -122.421343136988) | 2 | 4 | 5 | 28859 | 19 | |||
| 67004 | 201102 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 199 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010597.07336 | 2107530.66905 | 37.7674751717804 | -122.406612651066 | (37.7674751717804, -122.406612651066) | 8 | 4 | 8 | 28853 | 19 |
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) );