trees
430 rows where qSpecies_id = 99 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1712 | 105883 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5997608.20664 | 2115530.35123 | 37.7887049601136 | -122.452116422945 | (37.7887049601136, -122.452116422945) | 11 | 6 | 1 | 54 | 31 | ||||
| 4126 | 115471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | ||||||||||||||
| 4371 | 45657 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1330 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | 18 | Permit Number 44353 | 6006599 | 2119096 | 37.7990062508654 | -122.421262834262 | (37.7990062508654, -122.421262834262) | 13 | 9 | 1 | 28858 | 32 | ||
| 8385 | 83273 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6008750.42598 | 2118601.99703 | 37.7977708970553 | -122.413783193943 | (37.7977708970553, -122.413783193943) | 5 | 1 | 10 | 308 | 21 | |||
| 15951 | 39175 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 750 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2002 12:00:00 AM | 10 | Permit Number 40836 | 6007492.94598473 | 2105289.21429212 | 37.7611465023321 | -122.417190590059 | (37.7611465023321, -122.417190590059) | 2 | 4 | 7 | 28859 | 19 | |
| 20560 | 82168 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5995525.66671462 | 2115618.09435692 | 37.7888263661678 | -122.45932801632 | (37.7888263661678, -122.45932801632) | 11 | 6 | 1 | 54 | 31 | |||||
| 21352 | 106884 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 6 | Median : Cutout | Tree | Private 2 | DPW | 4 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
| 26096 | 123479 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 5995657.67406 | 2112077.16899 | 37.7791115222078 | -122.458614856747 | (37.7791115222078, -122.458614856747) | 11 | 6 | 2 | 54 | 16 | ||||
| 30210 | 29915 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
| 31067 | 123486 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5995665.69022 | 2111872.76649 | 37.7785507478592 | -122.458572325088 | (37.7785507478592, -122.458572325088) | 11 | 6 | 2 | 54 | 16 | ||||
| 33148 | 106883 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 4 | Median : Cutout | Tree | Private 2 | DPW | 4 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
| 38772 | 58907 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 354 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1980 12:00:00 AM | 29 | Permit Number 18182 | 6012260.63611 | 2086890.34143 | 37.7108941228427 | -122.399409385456 | (37.7108941228427, -122.399409385456) | 10 | 3 | 8 | 309 | 1 | ||
| 44810 | 123491 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5995674.45752 | 2111730.9534 | 37.7781618705542 | -122.458531727532 | (37.7781618705542, -122.458531727532) | 11 | 6 | 2 | 54 | 16 | ||||
| 48000 | 105881 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5997617.52659 | 2115483.20836 | 37.7885760521994 | -122.452080774722 | (37.7885760521994, -122.452080774722) | 11 | 6 | 1 | 54 | 31 | ||||
| 51308 | 242791 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1001 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 6005175.70924 | 2096892.88162 | 37.7379614744454 | -122.424607638258 | (37.7379614744454, -122.424607638258) | 2 | 7 | 5 | 28859 | 2 | ||||
| 53519 | 123480 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995658.30802 | 2112054.06112 | 37.7790481105637 | -122.458610990374 | (37.7790481105637, -122.458610990374) | 11 | 6 | 2 | 54 | 16 | ||||
| 55643 | 123482 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | 5995660.39644 | 2111993.63742 | 37.7788823231397 | -122.458599390427 | (37.7788823231397, -122.458599390427) | 11 | 6 | 2 | 54 | 16 | ||||
| 57689 | 117255 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 58765 | 242794 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 4 | Median : Yard | Tree | DPW 1 | 30 | 6007112.52178 | 2099889.35747 | 37.746298321115 | -122.418123483128 | (37.746298321115, -122.418123483128) | 2 | 7 | 7 | 28859 | 2 | ||||
| 69092 | 885 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | ||||
| 71394 | 123487 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 5995668.73883 | 2111844.87781 | 37.7784743481439 | -122.458559759476 | (37.7784743481439, -122.458559759476) | 11 | 6 | 2 | 54 | 16 | ||||
| 74694 | 51907 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
| 77624 | 29916 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
| 80156 | 39243 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3934 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1998 12:00:00 AM | Permit Number 40874 | 5995936.27284071 | 2115227.33652665 | 37.7877770492494 | -122.457879097389 | (37.7877770492494, -122.457879097389) | 11 | 6 | 1 | 54 | 31 | |||
| 81017 | 117256 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 88692 | 106880 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 3 | Median : Cutout | Tree | Private 2 | DPW | 5 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
| 89935 | 123488 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5995672.61976 | 2111816.69318 | 37.7783971836602 | -122.458544293173 | (37.7783971836602, -122.458544293173) | 11 | 6 | 2 | 54 | 16 | ||||
| 91388 | 105784 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||
| 96850 | 87591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3840 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5990782.62319 | 2090250.31161 | 37.7188992769151 | -122.473886649335 | (37.7188992769151, -122.473886649335) | 9 | 8 | 4 | 64 | 40 | ||||
| 101438 | 108311 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 439x ARLINGTON ST | 1 | Back Yard : Yard | Tree | Private 2 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329169 | (37.7354814316621, -122.42878329169) | 2 | 7 | 5 | 63 | 7 | |||||
| 113992 | 51906 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
| 115270 | 123484 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | 5995663.25844 | 2111930.13675 | 37.7787081316253 | -122.458584891633 | (37.7787081316253, -122.458584891633) | 11 | 6 | 2 | 54 | 16 | ||||
| 123890 | 253385 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100 Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004275 | 2112509 | 37.7807887188922 | -122.428834805692 | (37.7807887188922, -122.428834805692) | 7 | 9 | 11 | 29490 | 41 | |||||
| 149942 | 123483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995662.44998 | 2111958.25695 | 37.7787852957742 | -122.458589724568 | (37.7787852957742, -122.458589724568) | 11 | 6 | 2 | 54 | 16 | ||||
| 150449 | 116138 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.392388573996 | (37.7262356791342, -122.392388573996) | 10 | 3 | 8 | 58 | 1 | ||||
| 159593 | 107483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 6 | Median : Cutout | Tree | DPW 1 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | 3 | 1 | 10 | 308 | 23 | ||||
| 160951 | 93024 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
| 164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
| 183540 | 29914 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
| 186153 | 105882 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 5997612.13513 | 2115509.12693 | 37.7886469088657 | -122.45210129905 | (37.7886469088657, -122.45210129905) | 11 | 6 | 1 | 54 | 31 | ||||
| 190541 | 93023 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
| 191957 | 123481 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995659.66948 | 2112025.6512 | 37.7789701827075 | -122.458604223385 | (37.7789701827075, -122.458604223385) | 11 | 6 | 2 | 54 | 16 | ||||
| 193226 | 242792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 37 | 6003987.76148 | 2095934.32271 | 37.7352623274905 | -122.428646648224 | (37.7352623274905, -122.428646648224) | 2 | 7 | 5 | 28861 | 7 | ||||
| 176801 | 22540 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1441X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 12X6 | 6002335.85354 | 2093628.68187 | 37.728837937275 | -122.434193118021 | (37.728837937275, -122.434193118021) | 9 | 7 | 6 | 28861 | 25 | |||
| 131642 | 1257 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3801 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 1X3 | 5992919.7951 | 2087516.70947 | 37.7115170200575 | -122.466300791391 | (37.7115170200575, -122.466300791391) | 9 | 8 | 4 | 64 | 24 | |||
| 21545 | 392 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 2 | 5990516.36157 | 2090620.36486 | 37.7198999256056 | -122.474833997279 | (37.7198999256056, -122.474833997279) | 9 | 8 | 4 | 64 | 40 | |||
| 26511 | 11792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | |||
| 36233 | 398 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2 | 5990471.16794 | 2090846.61881 | 37.7205185437854 | -122.475006721555 | (37.7205185437854, -122.475006721555) | 9 | 8 | 4 | 64 | 40 | |||
| 60921 | 239 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.7323143965058 | -122.474793962374 | (37.7323143965058, -122.474793962374) | 1 | 8 | 4 | 64 | 40 | |||
| 66200 | 395 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 2 | 5990486.24663 | 2090696.51982 | 37.7201072830556 | -122.474943649084 | (37.7201072830556, -122.474943649084) | 9 | 8 | 4 | 64 | 40 | |||
| 69680 | 397 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990474.69146 | 2090771.67661 | 37.720312975301 | -122.474989074306 | (37.720312975301, -122.474989074306) | 9 | 8 | 4 | 64 | 40 | |||
| 71766 | 391 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | 2 | 5990530.65648 | 2090591.3498 | 37.7198210858115 | -122.474782468587 | (37.7198210858115, -122.474782468587) | 9 | 8 | 4 | 64 | 40 | |||
| 75663 | 401 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2 | 5990481.9086 | 2090947.80374 | 37.7207969949539 | -122.474976977183 | (37.7207969949539, -122.474976977183) | 9 | 8 | 4 | 64 | 40 | |||
| 136153 | 400 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 2 | 5990476.72602 | 2090904.23897 | 37.7206770765591 | -122.474991713144 | (37.7206770765591, -122.474991713144) | 9 | 8 | 4 | 64 | 40 | |||
| 139750 | 394 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990492.73788 | 2090676.25296 | 37.7200520114659 | -122.474919732673 | (37.7200520114659, -122.474919732673) | 9 | 8 | 4 | 64 | 40 | |||
| 140418 | 393 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 2 | 5990507.18031 | 2090652.75966 | 37.7199883416446 | -122.474868096697 | (37.7199883416446, -122.474868096697) | 9 | 8 | 4 | 64 | 40 | |||
| 11607 | 11613 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 36993 | 11614 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 55859 | 11620 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 73537 | 19097 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 276 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X2 | 5994245.51556 | 2087475.81103 | 37.711481126537 | -122.461715823343 | (37.711481126537, -122.461715823343) | 9 | 8 | 6 | 28861 | 24 | |||
| 120650 | 11619 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 158218 | 227 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 2X3 | 5990630.67566 | 2095430.16477 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | 1 | 8 | 4 | 64 | 40 | |||
| 384 | 415 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2X6 | 5990878.96388 | 2090116.60552 | 37.7185377326944 | -122.473543893183 | (37.7185377326944, -122.473543893183) | 9 | 8 | 4 | 64 | 40 | |||
| 85876 | 11616 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 151976 | 11615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 159991 | 11737 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x2 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
| 18185 | 11652 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 699X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
| 22831 | 11871 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
| 49919 | 11696 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 65090 | 11694 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 68463 | 11849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1401X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3 | 5991539.129622 | 2088082.4465587 | 37.7129906371476 | -122.471113878415 | (37.7129906371476, -122.471113878415) | 9 | 8 | 6 | 64 | 24 | |||
| 91152 | 11692 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 99292 | 11656 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 699X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
| 114230 | 11633 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
| 119413 | 11722 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 899X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
| 119872 | 11873 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
| 141266 | 11695 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 144238 | 11689 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 166529 | 11718 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 899X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
| 179933 | 11874 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
| 3714 | 19086 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 235 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994700.7848896 | 2087405.1340273 | 37.7113132610353 | -122.460137187577 | (37.7113132610353, -122.460137187577) | 9 | 8 | 6 | 28861 | 24 | |||
| 6823 | 11708 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991296.5308 | 2092759.13423 | 37.7258176365683 | -122.472293077282 | (37.7258176365683, -122.472293077282) | 9 | 8 | 4 | 64 | 40 | ||
| 9727 | 25337 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2000 12:00:00 AM | 15 | 3X3 | 5994336.66394 | 2087473.55865 | 37.7114801885417 | -122.461400629858 | (37.7114801885417, -122.461400629858) | 9 | 8 | 6 | 28861 | 24 | ||
| 9808 | 262587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 5994963 | 2087365 | 37.7112181411096 | -122.459228007495 | (37.7112181411096, -122.459228007495) | 9 | 8 | 6 | 28861 | 24 | ||||
| 12178 | 1048 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | 9 | 7 | 6 | 28861 | 25 | ||||
| 21872 | 7486 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2679X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008312.8272 | 2102836.8814 | 37.754459046451 | -122.414181457232 | (37.754459046451, -122.414181457232) | 2 | 4 | 7 | 28859 | 19 | |||
| 23482 | 19082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 227 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994691.47902 | 2087389.19966 | 37.7112689737437 | -122.460168197108 | (37.7112689737437, -122.460168197108) | 9 | 8 | 6 | 28861 | 24 | |||
| 26642 | 1061 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2061X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6000441.22371 | 2090128.46046 | 37.7191194136535 | -122.440492025318 | (37.7191194136535, -122.440492025318) | 9 | 7 | 6 | 28861 | 25 | |||
| 28708 | 1010 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1840X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6001180.26428 | 2091487.57144 | 37.7228932804007 | -122.438034753125 | (37.7228932804007, -122.438034753125) | 9 | 7 | 6 | 28861 | 25 | |||
| 32835 | 1054 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2045X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000521.13381 | 2090206.39855 | 37.7193379639287 | -122.440221393554 | (37.7193379639287, -122.440221393554) | 9 | 7 | 6 | 28861 | 25 | |||
| 32871 | 26823 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994408.88806 | 2087459.5005113 | 37.7114457448338 | -122.461149987895 | (37.7114457448338, -122.461149987895) | 9 | 8 | 6 | 28861 | 24 | |||
| 35213 | 1085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2156 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999963.70084 | 2089791.48987 | 37.7181669663093 | -122.442118458302 | (37.7181669663093, -122.442118458302) | 9 | 7 | 6 | 28861 | 25 | |||
| 35862 | 1540 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
| 35965 | 19053 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 141 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5995501.70307 | 2087378.49279 | 37.7112861454175 | -122.457367103015 | (37.7112861454175, -122.457367103015) | 9 | 8 | 6 | 28861 | 24 | |||
| 45289 | 19085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 231 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994662.28634 | 2087388.84238 | 37.7112663135508 | -122.460269067765 | (37.7112663135508, -122.460269067765) | 9 | 8 | 6 | 28861 | 24 | |||
| 46026 | 1477 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 245 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995501.26357 | 2114653.66128 | 37.7861768902412 | -122.459342576538 | (37.7861768902412, -122.459342576538) | 11 | 6 | 1 | 54 | 11 | |||
| 46257 | 1259 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3821 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5992830.40302 | 2087513.47902 | 37.7115029917542 | -122.466609516636 | (37.7115029917542, -122.466609516636) | 9 | 8 | 4 | 64 | 24 | |||
| 57509 | 1260 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3827 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5992804.99866 | 2087505.24822 | 37.7114789258702 | -122.466696722103 | (37.7114789258702, -122.466696722103) | 9 | 8 | 4 | 64 | 24 | |||
| 60286 | 19057 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 155 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995437.65535 | 2087381.53973 | 37.7112908326789 | -122.457588686968 | (37.7112908326789, -122.457588686968) | 9 | 8 | 6 | 28861 | 24 | |||
| 60777 | 1617 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 764 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 135 | 3X3 | 5995701.56639 | 2110898.08045 | 37.7758765794073 | -122.458377647589 | (37.7758765794073, -122.458377647589) | 11 | 6 | 2 | 54 | 16 |
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) );