trees
7,322 rows where qSpecies_id = 1 sorted by DBH descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 950 | 72251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001865.6588 | 2091176.05062 | 37.7220768687262 | -122.435643214558 | (37.7220768687262, -122.435643214558) | 9 | 7 | 6 | 28861 | 5 | |||
| 1065 | 180355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 San Jose Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999392.39561 | 2091826.25637 | 37.7237213933189 | -122.444239347485 | (37.7237213933189, -122.444239347485) | 9 | 7 | 6 | 28861 | 25 | |||
| 2032 | 71654 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 442 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011342.51966 | 2119044.79856 | 37.7991319472408 | -122.404844976017 | (37.7991319472408, -122.404844976017) | 3 | 1 | 10 | 308 | 23 | |||
| 2642 | 241718 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009951.86526 | 2100053.1098 | 37.7469073537049 | -122.40831687712 | (37.7469073537049, -122.40831687712) | 2 | 7 | 7 | 28859 | 2 | |||
| 2815 | 62472 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 139 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 9 | Permit Number 22643 | 6001469.26063 | 2093519.40721 | 37.7284886706995 | -122.43718116229 | (37.7284886706995, -122.43718116229) | 9 | 7 | 6 | 28861 | 25 | |
| 4362 | 72167 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2157 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5999876.34149 | 2120874.18187 | 37.8035073648317 | -122.444653277524 | (37.8035073648317, -122.444653277524) | 13 | 9 | 1 | 57 | 17 | |||
| 5395 | 214900 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 69 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992595.17834 | 2098673.73573 | 37.7421327279347 | -122.468233863115 | (37.7421327279347, -122.468233863115) | 1 | 8 | 4 | 59 | 40 | |||
| 5951 | 180245 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 202 Theresa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002009.45925 | 2093875.90967 | 37.729498237948 | -122.435339160997 | (37.729498237948, -122.435339160997) | 9 | 7 | 6 | 28861 | 25 | |||
| 6219 | 198125 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6013825.74476 | 2093610.04486 | 37.72943220072 | -122.394470179266 | (37.72943220072, -122.394470179266) | 10 | 3 | 8 | 58 | 1 | |||
| 7867 | 62156 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2165 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 9 | Permit Number 22270 | 5999843.40545 | 2120869.57146 | 37.8034928263957 | -122.444766922157 | (37.8034928263957, -122.444766922157) | 13 | 9 | 1 | 57 | 17 | |
| 8440 | 241789 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 28th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005121.67425 | 2099630.5033 | 37.7454753101483 | -122.424989187318 | (37.7454753101483, -122.424989187318) | 2 | 7 | 5 | 63 | 22 | |||
| 8507 | 241890 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1499X Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008767.73316 | 2097659.36681 | 37.7402682831543 | -122.412242355811 | (37.7402682831543, -122.412242355811) | 10 | 7 | 7 | 28859 | 2 | |||
| 8648 | 241859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 172 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008276.29707 | 2097788.11072 | 37.7405941974677 | -122.413950655794 | (37.7405941974677, -122.413950655794) | 2 | 7 | 7 | 28859 | 2 | |||
| 8729 | 57615 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 443 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/1976 12:00:00 AM | 9 | 6x6 | Permit Number 16506 | 6013261.87766 | 2104993.12434 | 37.7606563636335 | -122.397217427358 | (37.7606563636335, -122.397217427358) | 10 | 3 | 8 | 28856 | 29 |
| 9124 | 241979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4.5x9 | 6007964.49076 | 2096517.14345 | 37.7370868837581 | -122.414938831762 | (37.7370868837581, -122.414938831762) | 2 | 7 | 7 | 28859 | 2 | |||
| 11501 | 72262 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 339 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002453.69682 | 2091602.93785 | 37.7232823883568 | -122.433641008038 | (37.7232823883568, -122.433641008038) | 9 | 7 | 6 | 28861 | 5 | |||
| 14682 | 214885 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1745 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990579.0485 | 2103487.56187 | 37.7552335883705 | -122.475556349142 | (37.7552335883705, -122.475556349142) | 1 | 8 | 4 | 56 | 12 | |||
| 14934 | 66586 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 267 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1991 12:00:00 AM | 9 | Permit Number 29776 | 6004192.59606 | 2091857.6961 | 37.7240804116702 | -122.427648104894 | (37.7240804116702, -122.427648104894) | 9 | 7 | 6 | 28861 | 5 | |
| 14992 | 241795 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1697 Sanchez St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004025.87461 | 2098620.86191 | 37.7426411083917 | -122.428706329046 | (37.7426411083917, -122.428706329046) | 2 | 7 | 5 | 63 | 22 | |||
| 15103 | 70103 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 235 Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6000491.71169 | 2091975.9188 | 37.7241949888819 | -122.440449937109 | (37.7241949888819, -122.440449937109) | 9 | 7 | 6 | 28861 | 25 | |||
| 16821 | 71297 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1943 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000711.2858 | 2112029.2136 | 37.7792689994665 | -122.441128958799 | (37.7792689994665, -122.441128958799) | 15 | 5 | 11 | 29490 | 41 | |||
| 17270 | 241897 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008317.15134 | 2097696.50443 | 37.7403449611468 | -122.413802918794 | (37.7403449611468, -122.413802918794) | 2 | 7 | 7 | 28859 | 2 | |||
| 17443 | 73355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 235 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6000483.29937 | 2091960.66988 | 37.7241526398265 | -122.440477924021 | (37.7241526398265, -122.440477924021) | 9 | 7 | 6 | 28861 | 25 | |||
| 19263 | 70399 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 177 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6006457.49491 | 2093097.99188 | 37.7276138488775 | -122.419906652577 | (37.7276138488775, -122.419906652577) | 9 | 7 | 7 | 309 | 5 | |||
| 19572 | 62125 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 857 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/1985 12:00:00 AM | 9 | Permit Number 22232 | 6001110.80727 | 2092000.14241 | 37.7242967336823 | -122.43831155435 | (37.7242967336823, -122.43831155435) | 9 | 7 | 6 | 28861 | 25 | |
| 19927 | 241670 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1298 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010824.70952 | 2102364.55888 | 37.7533029247096 | -122.405461408244 | (37.7533029247096, -122.405461408244) | 10 | 4 | 8 | 28859 | 19 | |||
| 21572 | 140642 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 51 SHRADER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997261.4759 | 2110269.7179 | 37.7742407776837 | -122.452936181797 | (37.7742407776837, -122.452936181797) | 15 | 5 | 2 | 29492 | 16 | |||
| 22535 | 241765 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 264 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004842.06914 | 2099029.87164 | 37.7438103152004 | -122.425913271275 | (37.7438103152004, -122.425913271275) | 2 | 7 | 5 | 63 | 22 | |||
| 23071 | 139545 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 209 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000636.8406 | 2112831.8014 | 37.7814684598582 | -122.441444101851 | (37.7814684598582, -122.441444101851) | 15 | 5 | 1 | 29490 | 16 | |||
| 24031 | 218644 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 142 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992840.20656 | 2098139.61874 | 37.7406803264494 | -122.467347810566 | (37.7406803264494, -122.467347810566) | 1 | 8 | 4 | 59 | 40 | |||
| 24394 | 242221 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001083.78441 | 2105686.83006 | 37.7618756078054 | -122.439385583197 | (37.7618756078054, -122.439385583197) | 15 | 5 | 5 | 28862 | 3 | |||
| 26476 | 242276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004870.53752 | 2097246.91236 | 37.7389163233193 | -122.425687958752 | (37.7389163233193, -122.425687958752) | 2 | 7 | 5 | 63 | 7 | |||
| 26507 | 241803 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 173 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004765.19039 | 2102640.57911 | 37.7537201381747 | -122.426436138025 | (37.7537201381747, -122.426436138025) | 2 | 4 | 5 | 28862 | 22 | |||
| 27490 | 241814 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 157 Chattanooga St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004747.33248 | 2102924.37853 | 37.7544983755216 | -122.426518101323 | (37.7544983755216, -122.426518101323) | 2 | 4 | 5 | 28862 | 22 | |||
| 28200 | 136898 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009723.43312 | 2119123.66122 | 37.7992578523185 | -122.410453160888 | (37.7992578523185, -122.410453160888) | 3 | 1 | 10 | 308 | 4 | |||
| 30614 | 218482 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 360 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994498.46356 | 2092221.92481 | 37.7245273810263 | -122.461185384302 | (37.7245273810263, -122.461185384302) | 9 | 8 | 4 | 28861 | 24 | |||
| 31140 | 242127 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 386 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003847.75095 | 2103358.03006 | 37.7556381843733 | -122.429660016019 | (37.7556381843733, -122.429660016019) | 2 | 4 | 5 | 28862 | 22 | |||
| 31508 | 241778 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003089.7717 | 2098595.28247 | 37.7425178491116 | -122.431941273191 | (37.7425178491116, -122.431941273191) | 2 | 7 | 5 | 63 | 22 | |||
| 31669 | 241623 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 608 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008684.05676 | 2095969.89932 | 37.7356246778217 | -122.412412288117 | (37.7356246778217, -122.412412288117) | 10 | 7 | 7 | 28859 | 2 | |||
| 35639 | 242020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3154 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007751.06691 | 2106208.47613 | 37.7636851003982 | -122.41636297119 | (37.7636851003982, -122.41636297119) | 8 | 4 | 7 | 28859 | 19 | |||
| 36071 | 67398 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 559 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1992 12:00:00 AM | 9 | Permit Number 30895 | 5990612.18336 | 2111570.33607 | 37.7774286269343 | -122.476032056412 | (37.7774286269343, -122.476032056412) | 11 | 6 | 2 | 55 | 26 | |
| 36082 | 65731 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 244 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1990 12:00:00 AM | 9 | Permit Number 28665 | 6000099.76339 | 2087506.93929 | 37.7119018581587 | -122.44148430406 | (37.7119018581587, -122.44148430406) | 9 | 7 | 6 | 28861 | 5 | |
| 36327 | 19539 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 210X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/1992 12:00:00 AM | 9 | 4x4 | 6000683.4331401 | 2112797.8326942 | 37.7813778447173 | -122.441280476563 | (37.7813778447173, -122.441280476563) | 15 | 5 | 1 | 29490 | 41 | ||
| 36564 | 139546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 209 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000637.5175 | 2112813.5266 | 37.7814183204982 | -122.441440448373 | (37.7814183204982, -122.441440448373) | 15 | 5 | 1 | 29490 | 16 | |||
| 38226 | 218444 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 472 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997631.32736 | 2094121.49444 | 37.7299229463814 | -122.450492420007 | (37.7299229463814, -122.450492420007) | 9 | 7 | 4 | 28861 | 40 | |||
| 40999 | 241471 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 916 Elizabeth St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000552.08669 | 2102005.56575 | 37.751737481116 | -122.440960410306 | (37.751737481116, -122.440960410306) | 2 | 4 | 5 | 28862 | 22 | |||
| 41118 | 119176 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 8ft | 5980756.08521 | 2110656.0073 | 37.7743417237871 | -122.510058979927 | (37.7743417237871, -122.510058979927) | 11 | 6 | 2 | 55 | 26 | |||
| 44630 | 198122 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6013771.43179 | 2093619.46536 | 37.7294550480043 | -122.394658605233 | (37.7294550480043, -122.394658605233) | 10 | 3 | 8 | 58 | 1 | |||
| 45309 | 241762 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 219 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005055.99455 | 2098992.74691 | 37.743720466616 | -122.425170925903 | (37.743720466616, -122.425170925903) | 2 | 7 | 5 | 63 | 22 | |||
| 47122 | 241408 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 Rotteck St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003271.39635 | 2095151.09139 | 37.7330711841867 | -122.431067499989 | (37.7330711841867, -122.431067499989) | 9 | 7 | 5 | 28861 | 25 | |||
| 47710 | 67642 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Del Monte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1992 12:00:00 AM | 9 | Permit Number 31241 | 5999495.97226 | 2088935.41378 | 37.7157897092157 | -122.443673724283 | (37.7157897092157, -122.443673724283) | 9 | 7 | 6 | 28861 | 25 | ||
| 50266 | 198089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Kansas St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011708.13202 | 2102652.15618 | 37.7541419598038 | -122.402426554252 | (37.7541419598038, -122.402426554252) | 10 | 3 | 8 | 28856 | 29 | |||
| 50938 | 180329 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Capistrano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001134.29414 | 2093250.72299 | 37.7277318786024 | -122.438319915332 | (37.7277318786024, -122.438319915332) | 9 | 7 | 6 | 28861 | 25 | |||
| 51403 | 241487 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1257 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003254.8938 | 2100905.25495 | 37.7488698551559 | -122.431535204108 | (37.7488698551559, -122.431535204108) | 2 | 4 | 5 | 28862 | 22 | |||
| 51663 | 241410 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 126 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003749.89661 | 2095067.60089 | 37.732869040874 | -122.429407246247 | (37.732869040874, -122.429407246247) | 9 | 7 | 5 | 28861 | 25 | |||
| 53138 | 241776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 477 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002890.33216 | 2098583.76631 | 37.7424749199955 | -122.43263005315 | (37.7424749199955, -122.43263005315) | 2 | 7 | 5 | 63 | 22 | |||
| 53376 | 241774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 121 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004971.42919 | 2099282.86415 | 37.7445122846149 | -122.425483975415 | (37.7445122846149, -122.425483975415) | 2 | 7 | 5 | 63 | 22 | |||
| 54234 | 136836 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2189 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003758.7521 | 2116916.87038 | 37.7928623865432 | -122.430935432741 | (37.7928623865432, -122.430935432741) | 13 | 9 | 1 | 29490 | 27 | |||
| 56596 | 62077 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 619 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | 9 | Permit Number 22159 | 6013309.21723 | 2104160.9761 | 37.7583741019032 | -122.396995353258 | (37.7583741019032, -122.396995353258) | 10 | 3 | 8 | 28856 | 29 | |
| 56890 | 218647 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2531 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992034.21295 | 2098206.26524 | 37.7408167580911 | -122.470139455474 | (37.7408167580911, -122.470139455474) | 1 | 8 | 4 | 59 | 40 | |||
| 58936 | 67643 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 92 Del Monte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1992 12:00:00 AM | 9 | 3x3 | Permit Number 31242 | 5999452.95797 | 2088894.8093 | 37.7156757650988 | -122.443819485496 | (37.7156757650988, -122.443819485496) | 9 | 7 | 6 | 28861 | 25 | |
| 59914 | 19512 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6000653.0003 | 2112676.212 | 37.7810421717697 | -122.441377029637 | (37.7810421717697, -122.441377029637) | 15 | 5 | 1 | 29490 | 16 | |||
| 62283 | 65735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 381 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1990 12:00:00 AM | 9 | Permit Number 28671 | 6000320.287 | 2086910.79586 | 37.7102775422354 | -122.440679381145 | (37.7102775422354, -122.440679381145) | 9 | 7 | 6 | 28861 | 5 | |
| 63365 | 67323 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 655 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1992 12:00:00 AM | 9 | Permit Number 30805 | 5993766.26481 | 2111040.62571 | 37.7761565661242 | -122.465082654926 | (37.7761565661242, -122.465082654926) | 11 | 6 | 2 | 54 | 11 | |
| 63553 | 241710 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 217 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005456.82551 | 2102361.20711 | 37.752992120789 | -122.424024439577 | (37.752992120789, -122.424024439577) | 2 | 4 | 5 | 28859 | 19 | |||
| 64068 | 41775 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1346 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 9 | Permit Number 42189 | 6007517.3354 | 2115809.02803 | 37.7900327722351 | -122.417851956197 | (37.7900327722351, -122.417851956197) | 13 | 1 | 10 | 28858 | 21 | |
| 64097 | 67664 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 9 | Permit Number 31266 | 6013824.87119 | 2094307.60699 | 37.731347515662 | -122.394522025169 | (37.731347515662, -122.394522025169) | 10 | 3 | 8 | 58 | 1 | |
| 64488 | 245864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005410.1798 | 2109615.9511 | 37.7729092966004 | -122.424701797021 | (37.7729092966004, -122.424701797021) | 7 | 9 | 11 | 28852 | 10 | |||
| 66819 | 67649 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1939 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 9 | Permit Number 31248 | 6013431.94199 | 2095958.61931 | 37.7358590033865 | -122.395996119237 | (37.7358590033865, -122.395996119237) | 10 | 3 | 8 | 58 | 1 | |
| 67174 | 55716 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 21 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1973 12:00:00 AM | 9 | Permit Number 11739 | 6003173.21093574 | 2108192.12720252 | 37.7688732316917 | -122.432338023395 | (37.7688732316917, -122.432338023395) | 15 | 5 | 5 | 28862 | 3 | ||
| 67371 | 68366 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 105 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | 9 | 6x4 | Permit Number 32187 | 6003399.15519 | 2094463.96748 | 37.7311917359892 | -122.43057679119 | (37.7311917359892, -122.43057679119) | 9 | 7 | 5 | 28861 | 25 |
| 71080 | 242148 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 173 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001095.25665 | 2105433.63423 | 37.7611810469764 | -122.439327755895 | (37.7611810469764, -122.439327755895) | 15 | 4 | 5 | 28862 | 3 | |||
| 71562 | 241609 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008278.41085 | 2097482.23225 | 37.7397544411249 | -122.413921714713 | (37.7397544411249, -122.413921714713) | 2 | 7 | 7 | 28859 | 2 | |||
| 71657 | 218637 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 38 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992894.45751 | 2098860.43201 | 37.7426626291715 | -122.467212629873 | (37.7426626291715, -122.467212629873) | 1 | 8 | 4 | 59 | 40 | |||
| 75117 | 124094 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 Funston Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5991885.08534 | 2111292.19604 | 37.7767386560308 | -122.47160843755 | (37.7767386560308, -122.47160843755) | 11 | 6 | 2 | 54 | 11 | ||||
| 75148 | 105367 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 249 BROAD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5994550.4 | 2088030.5 | 37.71302171758 | -122.460702242455 | (37.71302171758, -122.460702242455) | 9 | 8 | 6 | 28861 | 24 | |||
| 75821 | 214917 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993280.28183 | 2093257.87923 | 37.727301678016 | -122.465471664684 | (37.727301678016, -122.465471664684) | 9 | 8 | 4 | 59 | 40 | |||
| 77756 | 31796 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 52 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35266 | 6001430.90319 | 2107832.29839 | 37.7677862841381 | -122.43833875075 | (37.7677862841381, -122.43833875075) | 15 | 5 | 5 | 29492 | 3 | |
| 77799 | 241711 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 171 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005438.53027 | 2102735.54784 | 37.7540189406269 | -122.424114327726 | (37.7540189406269, -122.424114327726) | 2 | 4 | 5 | 28859 | 19 | |||
| 79226 | 242290 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 411 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6003806.71849 | 2098340.54293 | 37.7418590111824 | -122.429444121165 | (37.7418590111824, -122.429444121165) | 2 | 7 | 5 | 63 | 7 | |||
| 79638 | 142280 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 606 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999183.3559 | 2110754.7754 | 37.7756825703071 | -122.44632297764 | (37.7756825703071, -122.44632297764) | 15 | 5 | 11 | 29492 | 16 | |||
| 79784 | 140111 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 909 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001451.2933 | 2111586.4522 | 37.7780954117057 | -122.43853723887 | (37.7780954117057, -122.43853723887) | 15 | 5 | 11 | 29490 | 41 | |||
| 80010 | 218615 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1770 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990630.13801 | 2103349.55995 | 37.7548576330938 | -122.475369593229 | (37.7548576330938, -122.475369593229) | 1 | 8 | 4 | 56 | 12 | |||
| 82487 | 136869 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 870 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005850.85875 | 2112804.67339 | 37.7816896320989 | -122.423404163691 | (37.7816896320989, -122.423404163691) | 7 | 9 | 11 | 28852 | 41 | |||
| 82794 | 218617 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1762 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990630.72227 | 2103403.07978 | 37.7550046182805 | -122.475371480017 | (37.7550046182805, -122.475371480017) | 1 | 8 | 4 | 56 | 12 | |||
| 82866 | 139541 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000652.7465 | 2113001.3507 | 37.7819349049495 | -122.441401245005 | (37.7819349049495, -122.441401245005) | 15 | 5 | 1 | 29490 | 41 | |||
| 84451 | 2233 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1217 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1993 12:00:00 AM | 9 | 4X4 | 6000793.5299 | 2112868.6894 | 37.7815786701027 | -122.440904680944 | (37.7815786701027, -122.440904680944) | 15 | 5 | 1 | 29490 | 41 | ||
| 84465 | 26047 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 112 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1997 12:00:00 AM | 9 | 3X3 | 5995738.4084 | 2088093.8487 | 37.7132639387666 | -122.456600694014 | (37.7132639387666, -122.456600694014) | 9 | 8 | 6 | 28861 | 24 | ||
| 86204 | 180181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5800 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5997274.84313 | 2086656.60213 | 37.709405683693 | -122.451186687614 | (37.709405683693, -122.451186687614) | 9 | 7 | 6 | 28861 | 25 | |||
| 86454 | 218671 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 249 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995986.60782 | 2094415.89853 | 37.7306370359696 | -122.456199653498 | (37.7306370359696, -122.456199653498) | 9 | 7 | 4 | 28861 | 40 | |||
| 87577 | 218705 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 520 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993361.22583 | 2101904.66966 | 37.7510482649635 | -122.465819831823 | (37.7510482649635, -122.465819831823) | 1 | 8 | 4 | 29491 | 12 | |||
| 88082 | 241817 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 157 Chattanooga St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004745.37817 | 2102985.01714 | 37.7546647644731 | -122.426529177396 | (37.7546647644731, -122.426529177396) | 2 | 4 | 5 | 28862 | 22 | |||
| 88740 | 242244 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 718 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002078.95713 | 2108803.76421 | 37.7704905284338 | -122.436166741416 | (37.7704905284338, -122.436166741416) | 15 | 5 | 11 | 29492 | 9 | |||
| 89118 | 242144 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 199 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001103.03625 | 2105300.30775 | 37.7608154078142 | -122.439291292876 | (37.7608154078142, -122.439291292876) | 15 | 4 | 5 | 28862 | 3 | |||
| 92857 | 218608 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1930 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990667.07239 | 2102243.73406 | 37.7518234671033 | -122.475161141169 | (37.7518234671033, -122.475161141169) | 1 | 8 | 4 | 29491 | 12 | |||
| 93172 | 241870 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 585 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008721.53321 | 2096078.49712 | 37.7359249668698 | -122.412290390405 | (37.7359249668698, -122.412290390405) | 10 | 7 | 7 | 28859 | 2 | |||
| 93650 | 218702 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 548 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993283.25052 | 2101901.38217 | 37.7510347400647 | -122.466089237241 | (37.7510347400647, -122.466089237241) | 1 | 8 | 4 | 29491 | 12 | |||
| 95441 | 119180 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 756 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5980766.80768 | 2110581.0869 | 37.7741366468987 | -122.510016322531 | (37.7741366468987, -122.510016322531) | 11 | 6 | 2 | 55 | 26 | |||
| 95998 | 241854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 632 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007778.34026 | 2095962.12452 | 37.7355524613776 | -122.415543156407 | (37.7355524613776, -122.415543156407) | 2 | 7 | 7 | 28859 | 2 | |||
| 98602 | 241876 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 115 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008863.52102 | 2097997.06094 | 37.741200891813 | -122.411935016112 | (37.741200891813, -122.411935016112) | 10 | 7 | 7 | 28859 | 2 |
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) );