trees
7,322 rows where qSpecies_id = 1 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62277 | 116746 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 62339 | 83435 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Romain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50457 | 6001140.563596 | 2103517.35500336 | 37.7559219890729 | -122.439033719301 | (37.7559219890729, -122.439033719301) | 2 | 4 | 5 | 28862 | 38 | ||
| 62561 | 34985 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 352 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38563 | 6011683.65196768 | 2119096.70399263 | 37.7992935287718 | -122.403668189675 | (37.7992935287718, -122.403668189675) | 3 | 1 | 10 | 308 | 23 | |||
| 62610 | 254203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5999444.20582 | 2094083.26469 | 37.7299215702866 | -122.444222359655 | (37.7299215702866, -122.444222359655) | 9 | 7 | 4 | 63 | 40 | |||
| 62674 | 31764 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1018 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35248 | 5990072.01927063 | 2099066.23490799 | 37.7430643792619 | -122.476986735886 | (37.7430643792619, -122.476986735886) | 1 | 8 | 3 | 29491 | 35 | ||
| 62840 | 83905 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 770 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50513 | 6001304.51407721 | 2092522.48406996 | 37.7257419809175 | -122.437679330441 | (37.7257419809175, -122.437679330441) | 9 | 7 | 6 | 28861 | 25 | ||
| 63077 | 68857 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 251 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | 3x3 | Permit Number 32820 | 5999751.54816623 | 2094339.78804149 | 37.7306434531378 | -122.443178260697 | (37.7306434531378, -122.443178260697) | 9 | 7 | 4 | 63 | 40 | |
| 63119 | 32363 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 121 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36915 | 6005672.05257059 | 2099026.50977114 | 37.7438479549883 | -122.423043141482 | (37.7438479549883, -122.423043141482) | 2 | 7 | 5 | 28859 | 22 | |||
| 63217 | 36215 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 63372 | 107270 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 63399 | 36211 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 63709 | 109830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||||
| 64091 | 82716 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 185 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50242 | 6009847.52117083 | 2099994.28340502 | 37.7467399857689 | -122.408673541755 | (37.7467399857689, -122.408673541755) | 2 | 7 | 7 | 28859 | 2 | ||
| 64114 | 89345 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | 2 | 4 | 5 | 28862 | 22 | ||||
| 64485 | 32164 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
| 64791 | 38763 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | 9 | 7 | 4 | 28861 | 25 | ||||
| 64840 | 42225 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 72 Lansing St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42484 | 6014273.6310011 | 2114148.09578812 | 37.7858501431349 | -122.394359219532 | (37.7858501431349, -122.394359219532) | 6 | 2 | 9 | 28855 | 6 | ||
| 65019 | 88089 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1870 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51092 | 5984476.8 | 2102440.2 | 37.7520021836437 | -122.496582125316 | (37.7520021836437, -122.496582125316) | 1 | 8 | 3 | 56 | 35 | |||
| 65272 | 39411 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
| 65430 | 88200 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 480 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51207 | 6010751.4 | 2112033.7 | 37.7798480877104 | -122.406396180597 | (37.7798480877104, -122.406396180597) | 14 | 2 | 9 | 28853 | 34 | ||
| 65639 | 101210 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 65733 | 36265 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Elmhurst Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1998 12:00:00 AM | Permit Number 39274 | 5991040.15921142 | 2094553.62712809 | 37.7307300237066 | -122.473310148521 | (37.7307300237066, -122.473310148521) | 9 | 8 | 4 | 64 | 40 | |||
| 65921 | 38327 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1321 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40382 | 6007185.31462295 | 2107795.24197408 | 37.7680101568657 | -122.418432256219 | (37.7680101568657, -122.418432256219) | 8 | 4 | 7 | 28853 | 19 | |||
| 65977 | 38324 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1359 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40380 | 6007003.46454574 | 2107571.83147582 | 37.7673864855168 | -122.419045408904 | (37.7673864855168, -122.419045408904) | 8 | 4 | 7 | 28853 | 19 | ||
| 66155 | 106179 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.421653930851 | (37.7898405898041, -122.421653930851) | 13 | 9 | 10 | 28858 | 21 | ||||
| 66562 | 36105 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1247 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | Permit Number 39202 | 5992660.90558351 | 2106977.61989132 | 37.7649368384766 | -122.468610661322 | (37.7649368384766, -122.468610661322) | 11 | 8 | 11 | 56 | 12 | ||
| 66921 | 87135 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Mars St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2008 12:00:00 AM | 3x3 | Permit Number 50103 | 5999603 | 2105413 | 37.7610393570971 | -122.444487333455 | (37.7610393570971, -122.444487333455) | 15 | 5 | 5 | 28862 | 3 | ||
| 67068 | 81323 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2131 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52793 | 5986016.84556981 | 2100726.30379714 | 37.7473863967358 | -122.491130378653 | (37.7473863967358, -122.491130378653) | 1 | 8 | 3 | 29491 | 35 | |
| 67712 | 88194 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 415 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51198 | 6011246 | 2112365 | 37.7807854162198 | -122.404708461336 | (37.7807854162198, -122.404708461336) | 14 | 2 | 9 | 28853 | 34 | |||
| 67807 | 51974 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2005 12:00:00 AM | Permit Number 48194 | 5997805.51500265 | 2086863.40763228 | 37.7100038942899 | -122.449367497034 | (37.7100038942899, -122.449367497034) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | ||||
| 68229 | 38767 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | 9 | 7 | 4 | 28861 | 25 | ||||
| 68267 | 34547 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3655 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38256 | 6008502.33868449 | 2097865.32728114 | 37.7408189097798 | -122.413174547063 | (37.7408189097798, -122.413174547063) | 10 | 7 | 7 | 28859 | 2 | ||
| 68278 | 256637 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Laguna Honda Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995221 | 2100899 | 37.7483940544242 | -122.459315767742 | (37.7483940544242, -122.459315767742) | 1 | 8 | 4 | 29491 | 40 | ||||
| 68305 | 253131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 277 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003684.78158 | 2092034.78148 | 37.7245379111933 | -122.429416163945 | (37.7245379111933, -122.429416163945) | 9 | 7 | 6 | 28861 | 5 | ||||
| 68854 | 68821 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 770629 | 5999450.20473491 | 2094083.18160524 | 37.7299216843992 | -122.444201614798 | (37.7299216843992, -122.444201614798) | 9 | 7 | 4 | 63 | 40 | ||
| 68891 | 253688 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | 8 | 2 | 9 | 28853 | 34 | ||||
| 68910 | 96805 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 471 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 3x3 | Permit Number 771933 | 6011260.5 | 2118966.4 | 37.7989120989831 | -122.405123270049 | (37.7989120989831, -122.405123270049) | 3 | 1 | 10 | 308 | 23 | ||
| 69011 | 35767 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3505 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1998 12:00:00 AM | Permit Number 39028 | 6005508.36746385 | 2106036.7640518 | 37.7630872494654 | -122.424107567979 | (37.7630872494654, -122.424107567979) | 8 | 4 | 5 | 28859 | 19 | ||
| 69031 | 60636 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1991 12:00:00 AM | 3x3 | Permit Number 29895 | 6004821.44439287 | 2097233.75118826 | 37.7388774114731 | -122.425856763586 | (37.7388774114731, -122.425856763586) | 2 | 7 | 5 | 63 | 7 | |
| 69051 | 45039 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2303 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43927 | 5988847.11690672 | 2099646.08528379 | 37.744585360466 | -122.48126452014 | (37.744585360466, -122.48126452014) | 1 | 8 | 3 | 29491 | 35 | |||
| 69690 | 32551 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | 8 | 2 | 9 | 28853 | 19 | |||
| 70028 | 95248 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 483@ Anza 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989019.4 | 2112018.5 | 37.778566675209 | -122.4815747855 | (37.778566675209, -122.4815747855) | 11 | 6 | 2 | 55 | 26 | ||||
| 70777 | 34554 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3687 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38263 | 6008491.31340319 | 2097732.91374155 | 37.7404547123015 | -122.413203307386 | (37.7404547123015, -122.413203307386) | 10 | 7 | 7 | 28859 | 2 | ||
| 70833 | 34260 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3857 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39814 | 6002750.01172962 | 2102959.12084046 | 37.7544806554781 | -122.433427835072 | (37.7544806554781, -122.433427835072) | 2 | 4 | 5 | 28862 | 22 | ||
| 70852 | 32600 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37067 | 5985231.92181857 | 2107024.54943344 | 37.764633747264 | -122.494308725231 | (37.764633747264, -122.494308725231) | 1 | 8 | 3 | 56 | 35 | ||
| 70896 | 88198 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 468 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51202 | 6010823.8 | 2112095.6 | 37.7800221004896 | -122.406150077984 | (37.7800221004896, -122.406150077984) | 14 | 2 | 9 | 28853 | 34 | |||
| 71342 | 44034 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1147 Sanchez St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2000 12:00:00 AM | Permit Number 43570 | 6003860.00449326 | 2101604.35206058 | 37.75082369093 | -122.429492581147 | (37.75082369093, -122.429492581147) | 2 | 4 | 5 | 28862 | 22 | |||
| 71362 | 49099 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | Permit Number 46246 | 6012933.18722113 | 2110757.22353588 | 37.7764649850887 | -122.398758756879 | (37.7764649850887, -122.398758756879) | 14 | 2 | 9 | 28856 | 20 | |||
| 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 | |||
| 71529 | 255511 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 638 Head St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 6x15 | 5993525.36191 | 2090091.06114 | 37.7186204962068 | -122.464394601529 | (37.7186204962068, -122.464394601529) | 9 | 8 | 6 | 64 | 24 | |||
| 71539 | 35145 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 948 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38675 | 6001756.74289531 | 2088542.87267944 | 37.7148405630694 | -122.435831400514 | (37.7148405630694, -122.435831400514) | 9 | 7 | 6 | 28861 | 5 | ||
| 71843 | 251584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2679 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1997 12:00:00 AM | 3x3 | 5997280 | 2088608 | 37.7147640690056 | -122.45130950851 | (37.7147640690056, -122.45130950851) | 9 | 8 | 6 | 28861 | 24 | |||
| 71946 | 95424 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767292 | 5989311.3 | 2103832.7 | 37.7561076720523 | -122.479965804871 | (37.7561076720523, -122.479965804871) | 1 | 8 | 3 | 56 | 35 | |
| 72006 | 32165 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
| 72114 | 36225 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1485 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39263 | 6015221.12155905 | 2092170.90026948 | 37.7255580692538 | -122.389545718534 | (37.7255580692538, -122.389545718534) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 72342 | 88680 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 72372 | 37242 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2550 Ortega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39799 | 5986139.92202069 | 2102333.01410506 | 37.7518051778529 | -122.490823000677 | (37.7518051778529, -122.490823000677) | 1 | 8 | 3 | 56 | 35 | ||
| 72480 | 32166 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
| 72485 | 35230 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2559 40th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1998 12:00:00 AM | Permit Number 38723 | 5983945.81332692 | 2097751.53443122 | 37.7390972690525 | -122.49807210272 | (37.7390972690525, -122.49807210272) | 1 | 8 | 3 | 29491 | 35 | ||
| 72829 | 91469 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 278 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2009 12:00:00 AM | 3x3 | Permit Number 52110 | 5995698.8 | 2091839.4 | 37.7235460643163 | -122.45700835021 | (37.7235460643163, -122.45700835021) | 9 | 8 | 4 | 28861 | 24 | ||
| 72944 | 88128 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 814 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51153 | 6001284 | 2099705 | 37.7454623352517 | -122.438264566721 | (37.7454623352517, -122.438264566721) | 2 | 4 | 5 | 63 | 22 | |||
| 72968 | 38254 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2525 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40363 | 6009112.31361331 | 2106827.53675456 | 37.7654613523347 | -122.41169856795 | (37.7654613523347, -122.41169856795) | 8 | 4 | 7 | 28859 | 19 | |||
| 72999 | 97794 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 825X Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
| 73022 | 255221 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 193 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6008612.03309 | 2093228.89125 | 37.7280944173375 | -122.412467612373 | (37.7280944173375, -122.412467612373) | 9 | 3 | 7 | 309 | 28 | ||||
| 73247 | 88674 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 73270 | 41110 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 625 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53737 | 5998473.53555018 | 2108533.76074895 | 37.7695436677127 | -122.448618413706 | (37.7695436677127, -122.448618413706) | 15 | 5 | 11 | 29492 | 9 | |
| 73542 | 117587 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X NIDO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999045 | 2111933 | 37.778909769135 | -122.44688638485 | (37.778909769135, -122.44688638485) | 15 | 5 | 1 | 54 | 16 | ||||
| 74353 | 104519 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 295-299 Lee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2013 12:00:00 AM | 3x3 | Permit Number 770416 | 5996485.8 | 2091712.7 | 37.723243339338 | -122.454278699409 | (37.723243339338, -122.454278699409) | 9 | 8 | 4 | 28861 | 24 | ||
| 74406 | 104517 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 295-299 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2013 12:00:00 AM | 3x3 | Permit Number 770416 | 5996485.8 | 2091712.7 | 37.723243339338 | -122.454278699409 | (37.723243339338, -122.454278699409) | 9 | 8 | 4 | 28861 | 24 | ||
| 74447 | 104019 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3700X Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 6x9 | Permit Number 770321 | 5996887.9623 | 2115333.50627 | 37.7881231929119 | -122.454594123111 | (37.7881231929119, -122.454594123111) | 11 | 6 | 1 | 54 | 31 | ||
| 74520 | 96247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
| 74639 | 44038 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1147 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2000 12:00:00 AM | Permit Number 43570 | 6003860.00449326 | 2101604.35206058 | 37.75082369093 | -122.429492581147 | (37.75082369093, -122.429492581147) | 2 | 4 | 5 | 28862 | 22 | |||
| 74851 | 95717 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 950 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 75049 | 39414 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
| 75220 | 40989 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | 3x3 | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | ||
| 75360 | 256062 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1405 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015439 | 2092721 | 37.7270806122312 | -122.388830911201 | (37.7270806122312, -122.388830911201) | 10 | 3 | 8 | 58 | 1 | ||||
| 75429 | 95834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767566 | 6009695.5 | 2111491.7 | 37.778300758866 | -122.410010747212 | (37.778300758866, -122.410010747212) | 8 | 2 | 9 | 28853 | 34 | |
| 75677 | 103450 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2201X Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999486.1 | 2111876.5 | 37.778779824377 | -122.445356386272 | (37.778779824377, -122.445356386272) | 15 | 5 | 11 | 54 | 16 | |||||
| 75763 | 111787 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55X SHERMAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
| 75893 | 95836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767566 | 6009695.5 | 2111491.7 | 37.778300758866 | -122.410010747212 | (37.778300758866, -122.410010747212) | 8 | 2 | 9 | 28853 | 34 | |
| 76017 | 102529 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200X 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2013 12:00:00 AM | 3x3 | Permit Number 768962 | 6013046 | 2116920 | 37.7933928248556 | -122.398801114306 | (37.7933928248556, -122.398801114306) | 4 | 1 | 10 | 28860 | 6 | ||
| 76093 | 88682 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 76107 | 87069 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2268 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 3x3 | Permit Number 50010 | 6001029.8 | 2119730 | 37.8004314980305 | -122.440579577974 | (37.8004314980305, -122.440579577974) | 13 | 9 | 1 | 57 | 17 | ||
| 76117 | 35827 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 717 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | Permit Number 39060 | 6002165.9902466 | 2089613.39970947 | 37.7178032321132 | -122.434493369978 | (37.7178032321132, -122.434493369978) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 76761 | 36309 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.7288745967493 | -122.455513542245 | (37.7288745967493, -122.455513542245) | 9 | 7 | 4 | 28861 | 40 | ||
| 77417 | 103451 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2201X Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999486.1 | 2111876.5 | 37.778779824377 | -122.445356386272 | (37.778779824377, -122.445356386272) | 15 | 5 | 11 | 54 | 16 | |||||
| 77474 | 37170 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1547 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39745 | 6005934.22844342 | 2099952.93765994 | 37.7464065067115 | -122.422202402672 | (37.7464065067115, -122.422202402672) | 2 | 7 | 5 | 28859 | 22 | |||
| 77476 | 34105 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Montecito Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37976 | 5995805.03129436 | 2094004.60627496 | 37.7294973019846 | -122.456797652126 | (37.7294973019846, -122.456797652126) | 9 | 7 | 4 | 28861 | 40 | ||
| 77582 | 82889 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1423 Francisco St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52339 | 6004509.13864627 | 2120473.3950975 | 37.8026701808582 | -122.42859269053 | (37.8026701808582, -122.42859269053) | 13 | 9 | 1 | 57 | 17 | ||
| 77641 | 258477 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1941 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989674 | 2106461 | 37.7633453443244 | -122.478903709704 | (37.7633453443244, -122.478903709704) | 1 | 8 | 3 | 56 | 35 | ||||
| 77668 | 31781 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1106 Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35254 | 5989534.846924 | 2097688.46988301 | 37.7392502171048 | -122.478743370392 | (37.7392502171048, -122.478743370392) | 1 | 8 | 3 | 29491 | 35 | |||
| 77754 | 251748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002576.6751 | 2087720.05109 | 37.7126278178947 | -122.43293862582 | (37.7126278178947, -122.43293862582) | 9 | 7 | 6 | 28861 | 5 | ||||
| 77800 | 39407 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
| 77971 | 258108 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 885 Franklin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4X4 | 6006124.86369 | 2113018.24445 | 37.7822915069765 | -122.422471414725 | (37.7822915069765, -122.422471414725) | 7 | 9 | 11 | 28852 | 41 | ||||
| 77976 | 31071 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1564 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34815 | 6007017.39244883 | 2107356.54022528 | 37.7667961307302 | -122.418981962466 | (37.7667961307302, -122.418981962466) | 8 | 4 | 7 | 28853 | 19 | ||
| 78010 | 88707 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2020 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51653 | 6004475.4 | 2108255.2 | 37.769120165328 | -122.427838335035 | (37.769120165328, -122.427838335035) | 7 | 9 | 5 | 28862 | 3 | ||
| 78241 | 36295 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | 9 | 8 | 4 | 64 | 40 |
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) );