trees
7,322 rows where qSpecies_id = 1 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167558 | 192048 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013251.73009 | 2110171.56166 | 37.7748746334969 | -122.397615732604 | (37.7748746334969, -122.397615732604) | 14 | 2 | 9 | 28856 | 20 | |
| 170498 | 106300 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 28th St | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772857 | 6001494.5 | 2099363.3 | 37.7445360779925 | -122.437512227288 | (37.7445360779925, -122.437512227288) | 2 | 7 | 5 | 63 | 22 | |||||
| 172350 | 198052 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015072.05685 | 2101707.95994 | 37.7517366132545 | -122.390727201795 | (37.7517366132545, -122.390727201795) | 10 | 3 | 8 | 28856 | 1 | |||
| 176214 | 180260 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003350.60066 | 2094725.01399 | 37.7319057599362 | -122.430763274623 | (37.7319057599362, -122.430763274623) | 9 | 7 | 5 | 28861 | 25 | |||
| 176319 | 91158 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 | |
| 178947 | 198045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 7ft | 6015062.9459 | 2101861.12211 | 37.7521566587028 | -122.390769411503 | (37.7521566587028, -122.390769411503) | 10 | 3 | 8 | 28856 | 1 | |||
| 183054 | 218754 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 763 Ulloa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993749.5488 | 2098107.41468 | 37.7406443562632 | -122.46420133903 | (37.7406443562632, -122.46420133903) | 1 | 8 | 4 | 59 | 40 | |||
| 187133 | 192046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013200.03931 | 2110117.49199 | 37.7747232919731 | -122.39779074965 | (37.7747232919731, -122.39779074965) | 14 | 2 | 9 | 28856 | 20 | |
| 188570 | 218442 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 430 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5997478.89638 | 2094887.71723 | 37.7320180861463 | -122.45107462221 | (37.7320180861463, -122.45107462221) | 9 | 7 | 4 | 59 | 40 | ||||
| 188902 | 180254 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003505.97344 | 2094729.60695 | 37.7319271728025 | -122.430226445906 | (37.7319271728025, -122.430226445906) | 9 | 7 | 5 | 28861 | 25 | |||
| 190516 | 136809 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001664.41277 | 2117108.48379 | 37.7932696175395 | -122.438195665917 | (37.7932696175395, -122.438195665917) | 13 | 6 | 1 | 29490 | 27 | |||
| 192456 | 218432 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 451 Hearst Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5998417.78463 | 2094357.34884 | 37.730615528667 | -122.447790528326 | (37.730615528667, -122.447790528326) | 9 | 7 | 4 | 28861 | 40 | |||
| 193574 | 185179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985165.2317 | 2097818.1461 | 37.7393515872788 | -122.493860877527 | (37.7393515872788, -122.493860877527) | 1 | 8 | 3 | 29491 | 35 | |||
| 194067 | 198048 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6015066.15454 | 2101809.56795 | 37.7520152799043 | -122.390754712983 | (37.7520152799043, -122.390754712983) | 10 | 3 | 8 | 28856 | 1 | |||
| 4039 | 101850 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | 10 | 3 | 8 | 28856 | 29 | |
| 7830 | 262278 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
| 9135 | 262279 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
| 9674 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
| 11745 | 260192 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Market St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 4X4 | 6006124.91889 | 2109483.72494 | 37.7725865765291 | -122.422220029928 | (37.7725865765291, -122.422220029928) | 8 | 2 | 9 | 28853 | 19 | ||
| 14929 | 256105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1935 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 09/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778629 | 5985666.45669 | 2102048.38182 | 37.7509959848908 | -122.492439326416 | (37.7509959848908, -122.492439326416) | 1 | 8 | 3 | 29491 | 35 |
| 18138 | 260191 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Market St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 4X4 | 6006124.91889 | 2109483.72494 | 37.7725865765291 | -122.422220029928 | (37.7725865765291, -122.422220029928) | 8 | 2 | 9 | 28853 | 19 | ||
| 24135 | 254150 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2123 30th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778310 | 5986951.71761 | 2100810.65655 | 37.7476725845461 | -122.487903895201 | (37.7476725845461, -122.487903895201) | 1 | 8 | 3 | 29491 | 35 | |
| 25630 | 255709 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2458 40th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 775348 | 5983968.47211 | 2098431.39968 | 37.740965323086 | -122.498043953777 | (37.740965323086, -122.498043953777) | 1 | 8 | 3 | 29491 | 35 | |
| 37102 | 77218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499X Hearst Ave | 22 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 3 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
| 39006 | 253854 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Joost Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 10x9 | Permit Number 776163 | 5997782.66631 | 2095011.71334 | 37.7323759368037 | -122.450033362597 | (37.7323759368037, -122.450033362597) | 9 | 7 | 4 | 59 | 40 | |
| 68057 | 253635 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 830 Oak St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.432999691851 | (37.7737452502421, -122.432999691851) | 15 | 5 | 11 | 29492 | 10 | ||||
| 71525 | 92666 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 791 San Bruno Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 76126 | 106373 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 189 College Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/23/2014 12:00:00 AM | 3X3 | Permit Number 771157 | 6004972.1 | 2095958.7 | 37.7353849208155 | -122.425245160296 | (37.7353849208155, -122.425245160296) | 2 | 7 | 5 | 28861 | 2 | |||
| 81925 | 10776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1120X Hudson Ave | 50 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
| 83568 | 187475 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4399 Mission St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | Width 0ft | Permit Number 781046 | 6003058.899 | 2093390.3112 | 37.7282244365032 | -122.431676490484 | (37.7282244365032, -122.431676490484) | 9 | 7 | 6 | 28861 | 5 | ||
| 83581 | 256032 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1443 Shafter Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x9 | 6015720.3 | 2093514.2 | 37.7292741690965 | -122.387913776951 | (37.7292741690965, -122.387913776951) | 10 | 3 | 8 | 58 | 1 | ||||
| 150582 | 42378 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 Foerster St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42549 | 5998097.42751354 | 2095265.42548706 | 37.7330905762451 | -122.448963434318 | (37.7330905762451, -122.448963434318) | 9 | 7 | 4 | 59 | 40 | |||
| 162331 | 97175 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
| 194408 | 254760 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 170 Arch St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781604 | 5992729.03192 | 2088323.37985 | 37.7137209347968 | -122.467018722529 | (37.7137209347968, -122.467018722529) | 9 | 8 | 6 | 64 | 24 |
| 1916 | 123041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 584 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5991932.61991 | 2111495.58679 | 37.7772998616253 | -122.471458826729 | (37.7772998616253, -122.471458826729) | 11 | 6 | 2 | 54 | 11 | |||
| 2704 | 214942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 40 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993797.90543 | 2095609.88239 | 37.7337895410509 | -122.463852902986 | (37.7337895410509, -122.463852902986) | 9 | 8 | 4 | 59 | 40 | |||
| 3015 | 217584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Randolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5993971.4029 | 2088542.2845 | 37.7143936266554 | -122.462740537778 | (37.7143936266554, -122.462740537778) | 9 | 8 | 6 | 64 | 24 | |||
| 6260 | 215528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994077.87758 | 2097807.84952 | 37.7398407436586 | -122.463044382805 | (37.7398407436586, -122.463044382805) | 1 | 8 | 4 | 59 | 40 | |||
| 6819 | 198078 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501 25th St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014189.20223 | 2101966.89329 | 37.752398567346 | -122.393798376688 | (37.752398567346, -122.393798376688) | 10 | 3 | 8 | 28856 | 1 | ||||
| 6951 | 180943 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 France Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 2ft | 6001409.71279 | 2090208.60686 | 37.719394577768 | -122.437150071831 | (37.719394577768, -122.437150071831) | 9 | 7 | 6 | 28861 | 5 | ||
| 7924 | 200199 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3125 Jennings St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 7 | Width 0ft | 6013712.0206 | 2090295.7773 | 37.7203255667293 | -122.394631341935 | (37.7203255667293, -122.394631341935) | 10 | 3 | 8 | 58 | 1 | ||
| 8591 | 214937 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993802.32185 | 2095722.84394 | 37.7340999600407 | -122.463845830728 | (37.7340999600407, -122.463845830728) | 9 | 8 | 4 | 59 | 40 | |||
| 8851 | 218714 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Linares Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994120.79386 | 2102087.9404 | 37.7515952659274 | -122.463206485604 | (37.7515952659274, -122.463206485604) | 1 | 8 | 4 | 29491 | 40 | |||
| 10623 | 211213 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | Width 3ft | 5994039.80885 | 2100040.77009 | 37.7459695901264 | -122.463337999768 | (37.7459695901264, -122.463337999768) | 1 | 8 | 4 | 29491 | 40 | |||
| 11587 | 184946 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | ||
| 12930 | 180942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 France Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6001400.48989 | 2090213.98554 | 37.7194088221462 | -122.43718233682 | (37.7194088221462, -122.43718233682) | 9 | 7 | 6 | 28861 | 5 | ||
| 15692 | 247491 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 950 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 6001998.5873 | 2109485.4017 | 37.7723575693759 | -122.436493535723 | (37.7723575693759, -122.436493535723) | 15 | 5 | 11 | 29492 | 9 | |||
| 16502 | 180152 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 579 Madrid St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002402.08753 | 2090505.72589 | 37.7202667609917 | -122.433741028842 | (37.7202667609917, -122.433741028842) | 9 | 7 | 6 | 28861 | 5 | |||
| 16607 | 124348 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 850 Balboa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5992952.29182 | 2111414.01558 | 37.7771348243058 | -122.467925547903 | (37.7771348243058, -122.467925547903) | 11 | 6 | 2 | 54 | 11 | |||
| 16665 | 136767 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3520 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999224.40422 | 2120935.42639 | 37.8036383025204 | -122.446913736078 | (37.8036383025204, -122.446913736078) | 13 | 9 | 1 | 57 | 17 | |||
| 17912 | 180944 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 France Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 2ft | 6001417.63829 | 2090203.47089 | 37.7193809260601 | -122.437122308845 | (37.7193809260601, -122.437122308845) | 9 | 7 | 6 | 28861 | 5 | ||
| 20811 | 180153 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 579 Madrid St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002415.21739 | 2090527.18349 | 37.7203264238119 | -122.433697176094 | (37.7203264238119, -122.433697176094) | 9 | 7 | 6 | 28861 | 5 | |||
| 21272 | 218717 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Linares Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994163.39761 | 2102079.16678 | 37.7515736300309 | -122.463058521044 | (37.7515736300309, -122.463058521044) | 1 | 8 | 4 | 29491 | 40 | |||
| 22512 | 182666 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2840 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | FUF | 0 | Width 0ft | 5985172.5458 | 2102302.8402 | 37.7516657686175 | -122.494166047002 | (37.7516657686175, -122.494166047002) | 1 | 8 | 3 | 56 | 35 | ||
| 23902 | 247459 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 985 Oak St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 6002326.2969 | 2109831.4554 | 37.7733263633354 | -122.435384717986 | (37.7733263633354, -122.435384717986) | 15 | 5 | 11 | 29492 | 9 | |||
| 24352 | 124853 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Casa Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781938 | 6001524.844 | 2121579.60518 | 37.8055382003848 | -122.43899915981 | (37.8055382003848, -122.43899915981) | 13 | 9 | 1 | 57 | 17 | |
| 27301 | 218583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3674 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 11/07/2015 01:06:00 PM | 3 | Width 3ft | 5990525.76897 | 2091801.92909 | 37.7231447525118 | -122.47488767982 | (37.7231447525118, -122.47488767982) | 9 | 8 | 4 | 64 | 40 | ||
| 27910 | 241476 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 931 Elizabeth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000400.84573 | 2101957.50792 | 37.7515969107856 | -122.441479972048 | (37.7515969107856, -122.441479972048) | 2 | 4 | 5 | 28862 | 22 | |||
| 28016 | 215527 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994087.51719 | 2097826.08343 | 37.7398913646969 | -122.463012375939 | (37.7398913646969, -122.463012375939) | 1 | 8 | 4 | 59 | 40 | |||
| 29916 | 214947 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 San Andreas Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993789.79612 | 2095483.41789 | 37.7334418334678 | -122.46387176267 | (37.7334418334678, -122.46387176267) | 9 | 8 | 4 | 59 | 40 | |||
| 30740 | 214949 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 60 San Andreas Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993767.69991 | 2095454.00516 | 37.7333597999987 | -122.463946020616 | (37.7333597999987, -122.463946020616) | 9 | 8 | 4 | 59 | 40 | |||
| 31284 | 250826 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Sea View Ter | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5986347.75861 | 2114146.24732 | 37.784253150511 | -122.490973502552 | (37.784253150511, -122.490973502552) | 11 | 6 | 1 | 55 | 33 | |||
| 31971 | 136896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1141 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6007469.2981 | 2119510.08172 | 37.8001922416361 | -122.418280679223 | (37.8001922416361, -122.418280679223) | 5 | 1 | 1 | 28858 | 32 | |||
| 32512 | 242095 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 286 Jersey St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6003308.20413 | 2101575.29219 | 37.750712641572 | -122.431398681623 | (37.750712641572, -122.431398681623) | 2 | 4 | 5 | 28862 | 22 | |||
| 33770 | 218587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3666 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990534.15112 | 2091988.92412 | 37.7236586799887 | -122.474872347276 | (37.7236586799887, -122.474872347276) | 9 | 8 | 4 | 64 | 40 | |||
| 35553 | 141306 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 296 PARKER AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5997058.2839 | 2112514.1079 | 37.7803916394622 | -122.453801164418 | (37.7803916394622, -122.453801164418) | 11 | 6 | 2 | 54 | 16 | |||
| 36479 | 214950 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 60 San Andreas Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993752.76838 | 2095441.07775 | 37.7333234440106 | -122.463996704586 | (37.7333234440106, -122.463996704586) | 9 | 8 | 4 | 59 | 40 | |||
| 38113 | 241475 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 939 Elizabeth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000376.8686 | 2101955.86566 | 37.7515910355155 | -122.441562769933 | (37.7515910355155, -122.441562769933) | 2 | 4 | 5 | 28862 | 22 | |||
| 40916 | 218693 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 180 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994797.85349 | 2099386.67402 | 37.7442172494337 | -122.460669409993 | (37.7442172494337, -122.460669409993) | 1 | 8 | 4 | 59 | 40 | |||
| 42744 | 214935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993803.05703 | 2095767.77574 | 37.7342233740152 | -122.463846549273 | (37.7342233740152, -122.463846549273) | 9 | 8 | 4 | 59 | 40 | |||
| 43924 | 136895 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1141 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6007447.28231 | 2119505.96137 | 37.8001796889091 | -122.418356570305 | (37.8001796889091, -122.418356570305) | 5 | 1 | 1 | 28858 | 32 | |||
| 45098 | 214938 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 San Andreas Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993799.23216 | 2095705.59413 | 37.7340524182789 | -122.46385526101 | (37.7340524182789, -122.46385526101) | 9 | 8 | 4 | 59 | 40 | |||
| 47423 | 241584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 38X Java St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5999751 | 2107467 | 37.7666875731096 | -122.444123063419 | (37.7666875731096, -122.444123063419) | 15 | 5 | 5 | 29492 | 9 | |||
| 48964 | 218588 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3658 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990544.88693 | 2092103.53987 | 37.7239740083808 | -122.474843597777 | (37.7239740083808, -122.474843597777) | 9 | 8 | 4 | 64 | 40 | |||
| 50045 | 214959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 96 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993574.3517 | 2095241.11953 | 37.7327641241706 | -122.464599021031 | (37.7327641241706, -122.464599021031) | 9 | 8 | 4 | 59 | 40 | |||
| 50184 | 218597 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3600 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990573.33305 | 2092525.302 | 37.7251337102413 | -122.474776034402 | (37.7251337102413, -122.474776034402) | 9 | 8 | 4 | 64 | 40 | |||
| 52131 | 218582 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3676 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990520.8643 | 2091753.44483 | 37.7230113425852 | -122.474901096806 | (37.7230113425852, -122.474901096806) | 9 | 8 | 4 | 64 | 40 | |||
| 52420 | 218591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3656 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990546.89703 | 2092172.51309 | 37.7241635081101 | -122.47484168131 | (37.7241635081101, -122.47484168131) | 9 | 8 | 4 | 64 | 40 | |||
| 53477 | 250834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5986538.23433 | 2114014.62016 | 37.7839028663707 | -122.490304846691 | (37.7839028663707, -122.490304846691) | 11 | 6 | 1 | 55 | 33 | |||
| 59931 | 214933 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993794.55323 | 2095807.54269 | 37.7343320741677 | -122.463878834949 | (37.7343320741677, -122.463878834949) | 9 | 8 | 4 | 59 | 40 | |||
| 59955 | 120358 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2350 Lake St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988092.81378 | 2114686.07827 | 37.7858371684386 | -122.484975921426 | (37.7858371684386, -122.484975921426) | 11 | 6 | 1 | 55 | 33 | |||
| 60531 | 182974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 19th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5990445.6911 | 2097993.6128 | 37.7401409062913 | -122.475616387366 | (37.7401409062913, -122.475616387366) | 1 | 8 | 3 | 29491 | 35 | |||
| 61303 | 102959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 62066 | 250835 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986538.16482 | 2114032.73934 | 37.7839526123729 | -122.490306420508 | (37.7839526123729, -122.490306420508) | 11 | 6 | 1 | 55 | 33 | |||
| 62624 | 218580 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3678 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 1 | Width 3ft | 5990518.16488 | 2091704.36213 | 37.7228764172852 | -122.474906847073 | (37.7228764172852, -122.474906847073) | 9 | 8 | 4 | 64 | 40 | ||
| 63158 | 218576 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3696 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 1 | Width 3ft | 5990496.40518 | 2091356.42271 | 37.7219198012285 | -122.474956679412 | (37.7219198012285, -122.474956679412) | 9 | 8 | 4 | 64 | 40 | ||
| 63993 | 123139 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 594 10th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5992865.58494 | 2111448.11432 | 37.777223442848 | -122.468227972924 | (37.777223442848, -122.468227972924) | 11 | 6 | 2 | 54 | 11 | |||
| 64325 | 214954 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 70 San Andreas Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993667.92929 | 2095378.69212 | 37.7331472587303 | -122.464285486783 | (37.7331472587303, -122.464285486783) | 9 | 8 | 4 | 59 | 40 | |||
| 65692 | 214943 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 40 San Andreas Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993799.93465 | 2095592.8648 | 37.7337429318934 | -122.463844652624 | (37.7337429318934, -122.463844652624) | 9 | 8 | 4 | 59 | 40 | |||
| 65998 | 218596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3648 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990560.74644 | 2092329.57586 | 37.7245955658112 | -122.47480526506 | (37.7245955658112, -122.47480526506) | 9 | 8 | 4 | 64 | 40 | |||
| 68399 | 182970 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5990437.2305 | 2098223.4012 | 37.7407713555772 | -122.475662415598 | (37.7407713555772, -122.475662415598) | 1 | 8 | 3 | 29491 | 35 | |||
| 68543 | 180151 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 579 Madrid St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002388.98897 | 2090485.78378 | 37.7202112611287 | -122.433784881588 | (37.7202112611287, -122.433784881588) | 9 | 7 | 6 | 28861 | 5 | |||
| 69944 | 250794 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 295 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5986187.23327 | 2113970.1581 | 37.7837602806675 | -122.491515889957 | (37.7837602806675, -122.491515889957) | 11 | 6 | 1 | 55 | 33 | |||
| 70300 | 182971 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 19th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5990437.5689 | 2098168.9153 | 37.7406217709518 | -122.475657267899 | (37.7406217709518, -122.475657267899) | 1 | 8 | 3 | 29491 | 35 | |||
| 70791 | 250825 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Sea View Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986333.40974 | 2114144.72465 | 37.7842481313918 | -122.4910230318 | (37.7842481313918, -122.4910230318) | 11 | 6 | 1 | 55 | 33 | |||
| 71374 | 241643 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 599 Buchanan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6004545.6184 | 2110424.56888 | 37.7750806969521 | -122.427750043935 | (37.7750806969521, -122.427750043935) | 7 | 9 | 11 | 28852 | 10 | |||
| 71973 | 218692 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994919.74424 | 2099497.0167 | 37.7445272349393 | -122.460255934085 | (37.7445272349393, -122.460255934085) | 1 | 8 | 4 | 59 | 40 | |||
| 72124 | 251752 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | ||||
| 72313 | 214934 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993802.59672 | 2095785.69059 | 37.7342725372347 | -122.463849440612 | (37.7342725372347, -122.463849440612) | 9 | 8 | 4 | 59 | 40 | |||
| 72871 | 180159 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 579 Madrid St | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 2ft | 6002542.18491 | 2090728.5143 | 37.7208864370415 | -122.433272670022 | (37.7208864370415, -122.433272670022) | 9 | 7 | 6 | 28861 | 5 |
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) );