trees
6,714 rows where qSpecies_id = 7 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
152 | 235666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6006462.25734 | 2109005.38337 | 37.7712921868165 | -122.421019169707 | (37.7712921868165, -122.421019169707) | 8 | 2 | 9 | 28853 | 19 | |||
211 | 196303 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011469.59111 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | 14 | 2 | 9 | 28856 | 34 | |||
1775 | 196240 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 477 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010588.30864 | 2112340.27099 | 37.7806807348789 | -122.406982002622 | (37.7806807348789, -122.406982002622) | 14 | 2 | 9 | 28853 | 34 | |||
2505 | 196318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 323 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008553.79261 | 2109149.29537 | 37.7718050135221 | -122.413794615322 | (37.7718050135221, -122.413794615322) | 8 | 2 | 9 | 28853 | 34 | |||
2662 | 51421 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2004 12:00:00 AM | 3 | Permit Number 47745 | 6013248.9695 | 2110513.26704 | 37.7758127253049 | -122.397649253932 | (37.7758127253049, -122.397649253932) | 6 | 2 | 9 | 28856 | 34 | |
3685 | 42239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 526 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42488 | 6010182.46318 | 2111990.4424 | 37.7796974691974 | -122.408361341411 | (37.7796974691974, -122.408361341411) | 14 | 2 | 9 | 28853 | 34 | |
5125 | 38779 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.7790327294989 | -122.397541189965 | (37.7790327294989, -122.397541189965) | 6 | 2 | 9 | 28856 | 34 | ||
5585 | 100886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013501.81999 | 2111894.49362 | 37.7796193360911 | -122.396871432992 | (37.7796193360911, -122.396871432992) | 6 | 2 | 9 | 28856 | 34 | |||
5877 | 51423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2004 12:00:00 AM | 2 | 3x3 | Permit Number 52282 | 6013263.01553 | 2110499.58328 | 37.7757759349387 | -122.397599704863 | (37.7757759349387, -122.397599704863) | 6 | 2 | 9 | 28856 | 34 | |
6903 | 38781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 7 | Permit Number 40639 | 6013329.04635 | 2111645.89395 | 37.7789271198304 | -122.397451696238 | (37.7789271198304, -122.397451696238) | 6 | 2 | 9 | 28856 | 34 | |
8287 | 196310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.7789092071182 | -122.402997684908 | (37.7789092071182, -122.402997684908) | 14 | 2 | 9 | 28856 | 34 | |||
9114 | 72295 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 142 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013238.89024 | 2111406.12615 | 37.7782637520155 | -122.397746762019 | (37.7782637520155, -122.397746762019) | 6 | 2 | 9 | 28856 | 34 | |||
10532 | 79204 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 175 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010493.03003 | 2110416.65916 | 37.7753936142481 | -122.407175982785 | (37.7753936142481, -122.407175982785) | 8 | 2 | 9 | 28853 | 34 | |||
10828 | 196319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 83 Lafayette St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007736.57644 | 2109492.64153 | 37.7727018336483 | -122.416645755806 | (37.7727018336483, -122.416645755806) | 8 | 2 | 9 | 28853 | 19 | |||
11344 | 196242 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 463 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010684.26644 | 2112432.48387 | 37.7809392989608 | -122.406656537094 | (37.7809392989608, -122.406656537094) | 14 | 2 | 9 | 28853 | 34 | |||
11418 | 84345 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 925 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010983.26021 | 2109758.62597 | 37.773614230057 | -122.405433799926 | (37.773614230057, -122.405433799926) | 14 | 2 | 9 | 28853 | 34 | |||
12301 | 81771 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 118 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50018 | 6009093.57763 | 2112998.11082 | 37.7824032504549 | -122.41219952199 | (37.7824032504549, -122.41219952199) | 14 | 10 | 9 | 28852 | 36 | |
13125 | 196236 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 457 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010494.60827 | 2112515.413 | 37.7811563899075 | -122.407318509161 | (37.7811563899075, -122.407318509161) | 14 | 2 | 9 | 28853 | 34 | |||
13144 | 72296 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 146 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6013222.13416 | 2111389.89822 | 37.7782182607083 | -122.397803589275 | (37.7782182607083, -122.397803589275) | 6 | 2 | 9 | 28856 | 34 | |||
14381 | 59534 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1117 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1981 12:00:00 AM | 11 | Permit Number 18916 | 6009775.37323 | 2111231.47163 | 37.7775907092861 | -122.409716062169 | (37.7775907092861, -122.409716062169) | 8 | 2 | 9 | 28853 | 34 | |
14420 | 235664 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6006467.28289 | 2108921.03594 | 37.7710608721893 | -122.42099579632 | (37.7710608721893, -122.42099579632) | 8 | 2 | 9 | 28853 | 19 | |||
15163 | 31818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 195 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 5 | Permit Number 35284 | 6009861.68421 | 2111431.68624 | 37.7781452879246 | -122.409431615589 | (37.7781452879246, -122.409431615589) | 14 | 2 | 9 | 28853 | 34 | |
16236 | 41079 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 314 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41836 | 6008273.99883854 | 2108752.45095329 | 37.7706996552947 | -122.414734354421 | (37.7706996552947, -122.414734354421) | 8 | 2 | 9 | 28853 | 19 | ||
17379 | 196308 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011682.43832 | 2111628.83367 | 37.7787884578701 | -122.403146802398 | (37.7787884578701, -122.403146802398) | 14 | 2 | 9 | 28856 | 34 | |||
18272 | 70670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 52 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6009955.96597 | 2110945.62551 | 37.7768159613156 | -122.40907115382 | (37.7768159613156, -122.40907115382) | 8 | 2 | 9 | 28853 | 34 | |||
18985 | 73738 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 142 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6013247.88073 | 2111413.28408 | 37.7782839067098 | -122.397716162585 | (37.7782839067098, -122.397716162585) | 6 | 2 | 9 | 28856 | 34 | |||
19009 | 196230 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 945 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010940.27995 | 2109717.00714 | 37.7734975511022 | -122.405579544073 | (37.7734975511022, -122.405579544073) | 14 | 2 | 9 | 28853 | 34 | |||
19706 | 42174 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 468 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42462 | 6009925.08941952 | 2109046.40040251 | 37.7715994018396 | -122.409043924996 | (37.7715994018396, -122.409043924996) | 8 | 2 | 9 | 28853 | 34 | ||
19962 | 41358 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100X Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | 6 | 2 | 9 | 28856 | 34 | |
20132 | 235665 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6006464.5058 | 2108970.07849 | 37.7711953747872 | -122.421008885051 | (37.7711953747872, -122.421008885051) | 8 | 2 | 9 | 28853 | 19 | |||
21552 | 249411 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Olive St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6007136.98967 | 2113833.35507 | 37.7845866470086 | -122.419027733462 | (37.7845866470086, -122.419027733462) | 7 | 9 | 9 | 28858 | 36 | |||
21594 | 196222 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Lucerne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012123.02143 | 2109681.25094 | 37.7734654372126 | -122.40148573028 | (37.7734654372126, -122.40148573028) | 14 | 2 | 9 | 28853 | 34 | |||
22110 | 40823 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 695 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 2 | Permit Number 41762 | 6013302.11222 | 2110458.37723 | 37.7756649694092 | -122.397461568121 | (37.7756649694092, -122.397461568121) | 6 | 2 | 9 | 28856 | 34 | ||
23047 | 256727 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
25713 | 196215 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Welsh St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013205.74921 | 2111612.02913 | 37.778827268993 | -122.397875857005 | (37.778827268993, -122.397875857005) | 6 | 2 | 9 | 28856 | 34 | |||
25875 | 41063 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 220 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | 8 | 2 | 9 | 28853 | 34 | ||
29056 | 100887 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013527.06662 | 2111917.77164 | 37.7796846574549 | -122.396785725789 | (37.7796846574549, -122.396785725789) | 6 | 2 | 9 | 28856 | 34 | |||
29267 | 98663 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 388 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769043 | 6013484.27433 | 2110492.11239 | 37.7757677394235 | -122.396833785577 | (37.7757677394235, -122.396833785577) | 6 | 2 | 9 | 28856 | 34 | |
29623 | 51394 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/2007 12:00:00 AM | 3 | Permit No. 49275 | 6008714.91218 | 2108979.76276 | 37.7713485635267 | -122.413225299535 | (37.7713485635267, -122.413225299535) | 8 | 2 | 9 | 28853 | 34 | |
29944 | 117196 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 7 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2x4 | 6009842.81565 | 2111098.19643 | 37.7772285460054 | -122.409473346818 | (37.7772285460054, -122.409473346818) | 8 | 2 | 9 | 28853 | 34 | |||
30039 | 196194 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 87 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015403.39344 | 2112238.08548 | 37.7806684231409 | -122.390317027303 | (37.7806684231409, -122.390317027303) | 6 | 2 | 9 | 28856 | 20 | |||
30442 | 42176 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 468 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 5 | Permit Number 42462 | 6009902.16567 | 2109063.79671 | 37.7716458838827 | -122.409124447652 | (37.7716458838827, -122.409124447652) | 8 | 2 | 9 | 28853 | 34 | |
30985 | 196197 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 36 Zoe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6013719.47537 | 2111992.2902 | 37.7798999758408 | -122.396125319442 | (37.7798999758408, -122.396125319442) | 6 | 2 | 9 | 28856 | 34 | |||
31071 | 38783 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 6 | Permit Number 40639 | 6013309.72565 | 2111669.35465 | 37.7789904617876 | -122.397520180536 | (37.7789904617876, -122.397520180536) | 6 | 2 | 9 | 28856 | 34 | |
31912 | 196237 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 457 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010508.54972 | 2112529.99118 | 37.781197198426 | -122.407271306426 | (37.781197198426, -122.407271306426) | 14 | 2 | 9 | 28853 | 34 | |||
31914 | 196233 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 615 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013115.78594 | 2111800.11069 | 37.7793386873661 | -122.398200276632 | (37.7793386873661, -122.398200276632) | 6 | 2 | 9 | 28856 | 34 | |||
32331 | 196301 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 246 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011446.6125 | 2111705.38284 | 37.7789854714477 | -122.403968009318 | (37.7789854714477, -122.403968009318) | 14 | 2 | 9 | 28856 | 34 | |||
32945 | 135785 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Willow St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006841.78708 | 2113423.0519 | 37.7834434270041 | -122.420019909605 | (37.7834434270041, -122.420019909605) | 7 | 9 | 9 | 28858 | 36 | |||
33634 | 65438 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 155 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28312 | 6009256.14047234 | 2113222.54142077 | 37.7830286035896 | -122.411652986137 | (37.7830286035896, -122.411652986137) | 14 | 10 | 9 | 28852 | 36 | ||
34899 | 135778 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 151 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006696.30515 | 2113402.79123 | 37.7833795985299 | -122.420521782549 | (37.7833795985299, -122.420521782549) | 7 | 9 | 9 | 28858 | 36 | |||
35204 | 196232 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 615 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013100.84916 | 2111783.99463 | 37.7792936043573 | -122.398250818526 | (37.7792936043573, -122.398250818526) | 6 | 2 | 9 | 28856 | 34 | |||
35298 | 31819 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 195 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 5 | Permit Number 35284 | 6009854.1227 | 2111441.50203 | 37.7781718161017 | -122.409458466633 | (37.7781718161017, -122.409458466633) | 14 | 2 | 9 | 28853 | 34 | |
35933 | 49539 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 270 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/2003 12:00:00 AM | Permit Number 46434 | 6008335.40255887 | 2109294.70940542 | 37.7721920194728 | -122.414560335389 | (37.7721920194728, -122.414560335389) | 8 | 2 | 9 | 28853 | 19 | ||
36223 | 196256 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1121 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009758.61663 | 2111214.79415 | 37.7775439778172 | -122.409772851638 | (37.7775439778172, -122.409772851638) | 8 | 2 | 9 | 28853 | 34 | |||
37209 | 196245 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 470 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010984.27375 | 2111888.95888 | 37.7794636868281 | -122.405580366041 | (37.7794636868281, -122.405580366041) | 14 | 2 | 9 | 28853 | 34 | |||
37427 | 39264 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 540 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015215.52427 | 2113624.42786 | 37.7844645829043 | -122.391063889106 | (37.7844645829043, -122.391063889106) | 6 | 2 | 9 | 28856 | 6 |
37496 | 41052 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 220 10th St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | 8 | 2 | 9 | 28853 | 34 | ||
37935 | 135776 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 102 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006971.50878 | 2113460.79408 | 37.7835543655835 | -122.419573800897 | (37.7835543655835, -122.419573800897) | 7 | 9 | 9 | 28858 | 36 | |||
37998 | 196234 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 474 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010454.20364 | 2112512.23943 | 37.7811454145803 | -122.40745806595 | (37.7811454145803, -122.40745806595) | 14 | 2 | 9 | 28853 | 34 | |||
38262 | 49545 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2003 12:00:00 AM | 1 | Permit Number 46436 | 6008707.29026 | 2108986.47445 | 37.7713665643481 | -122.413252138896 | (37.7713665643481, -122.413252138896) | 8 | 2 | 9 | 28853 | 34 | ||
38589 | 42175 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 468 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42462 | 6009925.08941952 | 2109046.40040251 | 37.7715994018396 | -122.409043924996 | (37.7715994018396, -122.409043924996) | 8 | 2 | 9 | 28853 | 34 | ||
40766 | 42068 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100X Ripley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
41082 | 196311 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 960 Harrison St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011645.79902 | 2111357.16189 | 37.7780404638396 | -122.403254436838 | (37.7780404638396, -122.403254436838) | 14 | 2 | 9 | 28856 | 34 | |||
41348 | 196316 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 11th St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6008680.78872 | 2109012.77169 | 37.7714372825214 | -122.413345669294 | (37.7714372825214, -122.413345669294) | 8 | 2 | 9 | 28853 | 34 | |||
45017 | 50678 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 320 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53102 | 6011917.0823 | 2112771.09085 | 37.7819379322194 | -122.402415410739 | (37.7819379322194, -122.402415410739) | 6 | 2 | 9 | 28853 | 34 | |
45045 | 196253 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 18 Langton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009815.72248 | 2111092.9268 | 37.7772125587353 | -122.409566699146 | (37.7772125587353, -122.409566699146) | 8 | 2 | 9 | 28853 | 34 | |||
47097 | 196258 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 238 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008464.21369 | 2109852.77128 | 37.773731561887 | -122.414154254216 | (37.773731561887, -122.414154254216) | 8 | 2 | 9 | 28853 | 34 | |||
48305 | 196223 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Lucerne St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012131.37322 | 2109670.95761 | 37.7734376400765 | -122.401456116509 | (37.7734376400765, -122.401456116509) | 14 | 2 | 9 | 28853 | 34 | |||
50075 | 196300 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Stillman St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014184.73952 | 2113142.03031 | 37.7830827763816 | -122.3945962858 | (37.7830827763816, -122.3945962858) | 6 | 2 | 9 | 28856 | 6 | |||
50262 | 135783 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006794.92567 | 2113414.60417 | 37.7834175912848 | -122.420181432353 | (37.7834175912848, -122.420181432353) | 7 | 9 | 9 | 28858 | 36 | |||
51685 | 32656 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 567 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 6 | Permit Number 37088 | 6011442.78568 | 2109776.31298 | 37.7736884771754 | -122.403845467717 | (37.7736884771754, -122.403845467717) | 14 | 2 | 9 | 28853 | 34 | |
51796 | 38782 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 6 | Permit Number 40639 | 6013318.98615 | 2111658.68099 | 37.77896166998 | -122.397487395751 | (37.77896166998, -122.397487395751) | 6 | 2 | 9 | 28856 | 34 | |
52381 | 196213 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Welsh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013176.67946 | 2111584.08305 | 37.778748916477 | -122.397974460465 | (37.778748916477, -122.397974460465) | 6 | 2 | 9 | 28856 | 34 | |||
52795 | 196229 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 945 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010924.60129 | 2109703.072 | 37.7734584117023 | -122.405632797436 | (37.7734584117023, -122.405632797436) | 14 | 2 | 9 | 28853 | 34 | |||
52945 | 117454 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 236 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776408 | 6011519 | 2111785 | 37.7792081256956 | -122.403723194086 | (37.7792081256956, -122.403723194086) | 14 | 2 | 9 | 28856 | 34 | |
53047 | 35708 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 110 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1998 12:00:00 AM | 7 | Permit Number 38995 | 6013339.85206 | 2111503.69559 | 37.7785372772193 | -122.397404339759 | (37.7785372772193, -122.397404339759) | 6 | 2 | 9 | 28856 | 34 | ||
53779 | 114494 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 322 Ritch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014223.46606 | 2111741.73077 | 37.7792400254408 | -122.394364230131 | (37.7792400254408, -122.394364230131) | 6 | 2 | 9 | 28856 | 34 | |||
53796 | 196198 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013719.80665 | 2111866.72594 | 37.7795552234296 | -122.39611537115 | (37.7795552234296, -122.39611537115) | 6 | 2 | 9 | 28856 | 34 | |||
56369 | 196204 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013601.37493 | 2111753.26044 | 37.7792370828557 | -122.396517124359 | (37.7792370828557, -122.396517124359) | 6 | 2 | 9 | 28856 | 34 | |||
56502 | 196255 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 65 Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009949.80584 | 2110985.38828 | 37.7769247954791 | -122.409095270046 | (37.7769247954791, -122.409095270046) | 8 | 2 | 9 | 28853 | 34 | |||
57229 | 196304 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 2 | : | Tree | Private 2 | 1 | Width 5ft | 6011481.85957 | 2111700.79426 | 37.7789748414544 | -122.403845751896 | (37.7789748414544, -122.403845751896) | 14 | 2 | 9 | 28856 | 34 | |||
57284 | 254326 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 550 Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009683 | 2112475 | 37.7809999678285 | -122.410123427963 | (37.7809999678285, -122.410123427963) | 14 | 2 | 9 | 28853 | 34 | |||||
57340 | 196306 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 218 Clara St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011621.39145 | 2111749.7942 | 37.779117178052 | -122.40336650048 | (37.779117178052, -122.40336650048) | 14 | 2 | 9 | 28856 | 34 | |||
57423 | 256728 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
59193 | 41064 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 220 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | 8 | 2 | 9 | 28853 | 34 | ||
60401 | 196201 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Width 2ft | 6013661.85599 | 2111812.39055 | 37.7794028063227 | -122.396312039369 | (37.7794028063227, -122.396312039369) | 6 | 2 | 9 | 28856 | 34 | ||
60661 | 30774 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 548 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 4 | 4.5x12 | Permit Number 34652 | 6014028.90307 | 2112230.33243 | 37.7805707972354 | -122.395071541515 | (37.7805707972354, -122.395071541515) | 6 | 2 | 9 | 28856 | 34 |
61625 | 43971 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 460 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | 1 | Permit Number 43535 | 6010572.18427 | 2112360.20788 | 37.7807345745927 | -122.407039190509 | (37.7807345745927, -122.407039190509) | 14 | 2 | 9 | 28853 | 34 | ||
61755 | 100883 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013382.01151 | 2111778.63358 | 37.7792945414358 | -122.397277778167 | (37.7792945414358, -122.397277778167) | 6 | 2 | 9 | 28856 | 34 | |||
62093 | 253900 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 65 Langton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6009949.80584 | 2110985.38828 | 37.7769247954791 | -122.409095270046 | (37.7769247954791, -122.409095270046) | 8 | 2 | 9 | 28853 | 34 | ||||
63200 | 196202 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6013641.30182 | 2111791.44038 | 37.7793441381689 | -122.396381676574 | (37.7793441381689, -122.396381676574) | 6 | 2 | 9 | 28856 | 34 | |||
63244 | 38784 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.7790327294989 | -122.397541189965 | (37.7790327294989, -122.397541189965) | 6 | 2 | 9 | 28856 | 34 | ||
64286 | 196212 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Welsh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013163.72067 | 2111572.83716 | 37.7787173160989 | -122.398018501155 | (37.7787173160989, -122.398018501155) | 6 | 2 | 9 | 28856 | 34 | |||
65857 | 41065 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 220 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | 8 | 2 | 9 | 28853 | 34 | ||
66459 | 33179 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1996 12:00:00 AM | 4 | Permit Number 37391 | 6010843.6562 | 2111975.32482 | 37.7796929635883 | -122.406072910354 | (37.7796929635883, -122.406072910354) | 14 | 2 | 9 | 28853 | 34 | ||
69054 | 196228 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 945 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010909.18194 | 2109688.59379 | 37.7734177956336 | -122.40568511549 | (37.7734177956336, -122.40568511549) | 14 | 2 | 9 | 28853 | 34 | |||
69186 | 196305 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 218 Clara St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.31972 | 2111713.41774 | 37.7790231566266 | -122.40300094945 | (37.7790231566266, -122.40300094945) | 14 | 2 | 9 | 28856 | 34 | |||
70894 | 41054 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 220 10th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | 8 | 2 | 9 | 28853 | 34 | ||
71149 | 255637 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 260 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2018 12:00:00 AM | 3 | 6008654.91085 | 2109676.79705 | 37.7732590874052 | -122.413482152541 | (37.7732590874052, -122.413482152541) | 8 | 2 | 9 | 28853 | 34 | |||
71217 | 51891 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 475 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 4 | Permit Number 48103 | 6010879.22134 | 2112013.50576 | 37.7797997886722 | -122.405952564869 | (37.7797997886722, -122.405952564869) | 14 | 2 | 9 | 28853 | 34 |
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) );