trees
39,840 rows where qLegalStatus_id = 7 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43839 | 247801 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 462 30th St | 1 | : | Tree | Private 2 | 12/05/1987 12:00:00 AM | 8 | Width 3ft | Permit Number 24911 | 6003630.84189 | 2098375.23957 | 37.7419443208891 | -122.430054719445 | (37.7419443208891, -122.430054719445) | 2 | 7 | 5 | 63 | 22 | |
44015 | 39896 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41178 | 5997800.90036334 | 2106153.01397284 | 37.7629682584611 | -122.450773341977 | (37.7629682584611, -122.450773341977) | 15 | 5 | 11 | 29492 | 9 | |||
44061 | 98652 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801@Jones Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49829 | 6008750 | 2115238 | 37.7885341615981 | -122.413546621934 | (37.7885341615981, -122.413546621934) | 5 | 1 | 10 | 28858 | 21 | |||
44215 | 34207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 615 Edinburg St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | Permit Number 38025 | 6002522.9923571 | 2090183.36055345 | 37.719388477306 | -122.433300078328 | (37.719388477306, -122.433300078328) | 9 | 7 | 6 | 28861 | 5 | |||
44294 | 95824 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 521 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767559 | 6011277 | 2109901 | 37.7740215758453 | -122.404427727506 | (37.7740215758453, -122.404427727506) | 14 | 2 | 9 | 28853 | 34 |
44480 | 38262 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3049 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40365 | 6009221.80428817 | 2104486.03920004 | 37.7590382764454 | -122.411154451212 | (37.7590382764454, -122.411154451212) | 2 | 4 | 7 | 28859 | 19 | ||
44538 | 53076 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 371 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51458 | 6006420.16268351 | 2097021.21744278 | 37.7383840588887 | -122.420314048095 | (37.7383840588887, -122.420314048095) | 2 | 7 | 7 | 28859 | 2 | ||
44770 | 30652 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Lafayette St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | Permit Number 34589 | 6007404.25014155 | 2109701.49866568 | 37.7732566094999 | -122.417810118831 | (37.7732566094999, -122.417810118831) | 8 | 2 | 9 | 28853 | 19 | |||
45000 | 26304 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
45088 | 36294 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 2 | 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 | |||
45117 | 36201 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 15 | 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 | ||
45150 | 241902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1960 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1998 12:00:00 AM | 6 | Width 2ft | Permit Number 37964 | 6008022.15169 | 2107061.82989 | 37.7660434519785 | -122.415485789563 | (37.7660434519785, -122.415485789563) | 8 | 4 | 7 | 28853 | 19 | |
45817 | 37161 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 88 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | 2 | 7 | 5 | 28859 | 2 | |||
46108 | 38840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 321 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1998 12:00:00 AM | Permit Number 40669 | 6001805.99344402 | 2103972.25385855 | 37.7572088713247 | -122.436765010689 | (37.7572088713247, -122.436765010689) | 2 | 4 | 5 | 28862 | 3 | |||
46300 | 17063 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1331 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/1992 12:00:00 AM | 6 | 3X3 | 6000629.7741 | 2109513.39251 | 37.7723565484264 | -122.441230383956 | (37.7723565484264, -122.441230383956) | 15 | 5 | 11 | 29492 | 9 | ||
46365 | 12564 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 6 | 3X3 | 5994519.02156 | 2114835.96421 | 37.7866209222593 | -122.462754079731 | (37.7866209222593, -122.462754079731) | 11 | 6 | 1 | 54 | 11 | ||
46403 | 256899 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
46571 | 17077 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1477 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1994 12:00:00 AM | 8 | 3X3 | 5999940.2113496 | 2109499.0138817 | 37.7722777645931 | -122.443614604892 | (37.7722777645931, -122.443614604892) | 15 | 5 | 11 | 29492 | 9 | ||
46605 | 93026 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3865 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2010 12:00:00 AM | 3x3 | Permit Number 53142 | 6002696 | 2102965 | 37.7544937337812 | -122.433615041679 | (37.7544937337812, -122.433615041679) | 2 | 4 | 5 | 28862 | 22 | ||
46636 | 94470 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 468 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997654.5 | 2094143 | 37.7299833218121 | -122.450413859523 | (37.7299833218121, -122.450413859523) | 9 | 7 | 4 | 28861 | 40 | ||||
46655 | 35782 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | 6 | 3x3 | Permit Number 39035 | 6004935.16103629 | 2106049.50977672 | 37.763089865827 | -122.426091003679 | (37.763089865827, -122.426091003679) | 8 | 4 | 5 | 28859 | 19 | |
46977 | 36208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 24 | 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 | ||
47294 | 254847 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Corbett Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779287 | 6000581.14651 | 2105634.12075 | 37.7617022635467 | -122.441120222786 | (37.7617022635467, -122.441120222786) | 15 | 5 | 5 | 28862 | 3 | |
47484 | 39205 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2188 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996320.5 | 2087005.2 | 37.7103081651051 | -122.454510201448 | (37.7103081651051, -122.454510201448) | 9 | 7 | 6 | 28861 | 25 | |
47931 | 41412 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | Permit Number 42025 | 6002180.68587279 | 2119283.13380429 | 37.7992699891282 | -122.436565055121 | (37.7992699891282, -122.436565055121) | 13 | 9 | 1 | 57 | 17 | |||
47937 | 26369 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2667 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1997 12:00:00 AM | 3 | 3X3 | 5997330.2024528 | 2088747.3342852 | 37.7151495231957 | -122.451146031102 | (37.7151495231957, -122.451146031102) | 9 | 8 | 6 | 28861 | 24 | ||
48465 | 115783 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 112X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776402 | 6006834.59164 | 2098690.08898 | 37.7429897522087 | -122.418999487845 | (37.7429897522087, -122.418999487845) | 2 | 7 | 7 | 28859 | 2 | ||
48586 | 16880 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
48937 | 108550 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
48950 | 49347 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2801X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2013 12:00:00 AM | Permit Number 769394 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | 13 | 6 | 1 | 29490 | 27 | |||
48993 | 52138 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 599X BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 2 | 4x24 | Permit Number 48318 | 6004543 | 2110488 | 37.7752547151739 | -122.427763622088 | (37.7752547151739, -122.427763622088) | 7 | 9 | 11 | 28852 | 10 | |
49202 | 26306 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
49367 | 26222 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 765X San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.7428448194479 | -122.422918945318 | (37.7428448194479, -122.422918945318) | 2 | 7 | 7 | 28859 | 2 | |||
49576 | 34937 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 294 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1997 12:00:00 AM | Permit Number 38532 | 5997056.12539173 | 2112496.77058091 | 37.7803439119926 | -122.453807379312 | (37.7803439119926, -122.453807379312) | 11 | 6 | 2 | 54 | 16 | |||
49731 | 117348 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1149 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778484 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | 2 | 4 | 5 | 28862 | 22 | ||
49763 | 108796 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 501-599 University St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |
49786 | 38256 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2525 16th St | 4 | 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 | |||
50227 | 89042 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Taylor St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51781 | 6009231 | 2115470 | 37.7891981742353 | -122.411898830301 | (37.7891981742353, -122.411898830301) | 5 | 1 | 10 | 28857 | 21 | |||
50351 | 99836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
50394 | 116204 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
50906 | 97793 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 825X Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
51135 | 34550 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3661 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38259 | 6008500.27144352 | 2097840.49973377 | 37.7407506227309 | -122.413179939647 | (37.7407506227309, -122.413179939647) | 10 | 7 | 7 | 28859 | 2 | ||
51389 | 15713 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4357X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/1995 12:00:00 AM | 6 | 3x3 | 6002851.16985 | 2093165.53011 | 37.7275954613369 | -122.432378570152 | (37.7275954613369, -122.432378570152) | 9 | 7 | 6 | 28861 | 5 | ||
51399 | 254270 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 399 Melrose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781229 | 5997471.20201 | 2095517.43055 | 37.7337466879114 | -122.451146618749 | (37.7337466879114, -122.451146618749) | 9 | 7 | 4 | 59 | 40 |
51584 | 100335 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Gorham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x9 | 6002317.2 | 2094130.8 | 37.7302155808393 | -122.43429348768 | (37.7302155808393, -122.43429348768) | 9 | 7 | 5 | 28861 | 25 | ||||
51919 | 43398 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 66 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51138 | 6000329.57684873 | 2101296.06622138 | 37.7497766910669 | -122.441678964169 | (37.7497766910669, -122.441678964169) | 2 | 4 | 5 | 28862 | 22 | ||
52064 | 37159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 88 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | 2 | 7 | 5 | 28859 | 2 | |||
52170 | 117347 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1149 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | 2 | 4 | 5 | 28862 | 22 | ||||||
52291 | 38261 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3049 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40365 | 6009221.80428817 | 2104486.03920004 | 37.7590382764454 | -122.411154451212 | (37.7590382764454, -122.411154451212) | 2 | 4 | 7 | 28859 | 19 | ||
52492 | 15728 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4400 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 04/20/1995 12:00:00 AM | 4 | 3X3 | 6002668.6888386 | 2093023.5286977 | 37.7271952084184 | -122.432999267314 | (37.7271952084184, -122.432999267314) | 9 | 7 | 6 | 28861 | 25 | ||
52570 | 92725 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 148 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52960 | 6010020.7 | 2100130.7 | 37.7471242537146 | -122.408084322885 | (37.7471242537146, -122.408084322885) | 2 | 7 | 7 | 28859 | 2 | |
52729 | 37486 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1353 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39955 | 5990795.20359731 | 2106190.41144038 | 37.7626674234032 | -122.475006118896 | (37.7626674234032, -122.475006118896) | 1 | 8 | 3 | 56 | 12 | ||
52829 | 51759 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | Permit Number 48027 | 6002355.39807577 | 2099140.67128625 | 37.7439736997976 | -122.434519504077 | (37.7439736997976, -122.434519504077) | 2 | 7 | 5 | 63 | 22 | |||
53038 | 86909 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4447 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 50004 | 6001254 | 2105221 | 37.7606062377454 | -122.438763494294 | (37.7606062377454, -122.438763494294) | 2 | 4 | 5 | 28862 | 3 | ||
53126 | 265 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
53132 | 88406 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1716 Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51383 | 6007055 | 2117126 | 37.7936228211286 | -122.419545076389 | (37.7936228211286, -122.419545076389) | 5 | 9 | 10 | 28858 | 32 | |||
53135 | 32162 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 6 | 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 | |||
53148 | 26874 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 129 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2000 12:00:00 AM | 6 | 3x3 | 6006373 | 2110396 | 37.7751054547407 | -122.4214266892 | (37.7751054547407, -122.4214266892) | 7 | 9 | 11 | 28852 | 10 | ||
53285 | 35859 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 827 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44931 | 6002288.79188076 | 2088794.75109809 | 37.7155623744331 | -122.434010413526 | (37.7155623744331, -122.434010413526) | 9 | 7 | 6 | 28861 | 5 | |||
53339 | 87985 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51024 | 5999495.7 | 2111498.4 | 37.7777422068729 | -122.445295983887 | (37.7777422068729, -122.445295983887) | 15 | 5 | 11 | 54 | 16 | ||
53350 | 38329 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1334 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1998 12:00:00 AM | Permit Number 40383 | 6007137.73543764 | 2107714.01420189 | 37.7677844459894 | -122.418591067048 | (37.7677844459894, -122.418591067048) | 8 | 4 | 7 | 28853 | 19 | ||
53480 | 79186 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 264 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50973 | 6000535.29432741 | 2106716.16265048 | 37.7646706714185 | -122.441356449855 | (37.7646706714185, -122.441356449855) | 15 | 5 | 5 | 28862 | 3 | ||
53643 | 36897 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4053 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39550 | 6001673.15981371 | 2102898.88024815 | 37.7542540959721 | -122.437147550415 | (37.7542540959721, -122.437147550415) | 2 | 4 | 5 | 28862 | 22 | ||
53880 | 116202 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
53899 | 36400 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996171.38037302 | 2093732.38222171 | 37.7287708691135 | -122.455511487051 | (37.7287708691135, -122.455511487051) | 9 | 7 | 4 | 28861 | 40 | ||
54128 | 106175 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 2 | 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 | ||||
54239 | 36231 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1485 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/2001 12:00:00 AM | Permit Number 39263 | 6015221.12155905 | 2092170.90026948 | 37.7255580692538 | -122.389545718534 | (37.7255580692538, -122.389545718534) | 10 | 3 | 8 | 58 | 1 | ||
54603 | 31586 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1894 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35121 | 5988494.35729684 | 2102435.66161223 | 37.7522242814151 | -122.482688661372 | (37.7522242814151, -122.482688661372) | 1 | 8 | 3 | 56 | 35 | ||
55319 | 65076 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 330 Ritch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53742 | 6014209.97274141 | 2111734.63120879 | 37.7792197815791 | -122.394410412216 | (37.7792197815791, -122.394410412216) | 6 | 2 | 9 | 28856 | 34 | |
55392 | 119621 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2298X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003320 | 2116507 | 37.7917121175407 | -122.432424247263 | (37.7917121175407, -122.432424247263) | 13 | 9 | 1 | 29490 | 27 | ||||
55405 | 47246 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1060 Key Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.396767210117 | (37.7194581178311, -122.396767210117) | 10 | 3 | 8 | 58 | 1 | ||
55555 | 29088 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2240 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009623.3077784 | 2104292.1140535 | 37.7585283102663 | -122.409752168005 | (37.7585283102663, -122.409752168005) | 2 | 4 | 7 | 28859 | 19 | ||
55601 | 26299 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
55699 | 38765 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | 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 | ||||
55837 | 94871 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1578 Innes Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53941 | 6015653.4 | 2097175.2 | 37.7393228299093 | -122.388400481487 | (37.7393228299093, -122.388400481487) | 10 | 3 | 8 | 58 | 1 | ||
56409 | 26824 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
56445 | 101209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 5 | 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 | |||
56506 | 83990 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 549 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50485 | 6003149.67149919 | 2096039.38573025 | 37.7355033398719 | -122.431551729165 | (37.7355033398719, -122.431551729165) | 2 | 7 | 5 | 63 | 7 | ||
56750 | 28393 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1800 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | ||
56845 | 217618 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1830 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 5 | Width 0ft | 5994376.3626 | 2092464.7235 | 37.7251870199691 | -122.461625063462 | (37.7251870199691, -122.461625063462) | 9 | 8 | 4 | 28861 | 40 | ||
56962 | 95428 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1701 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767293 | 5989315.6 | 2103729.9 | 37.7558256605685 | -122.479943411619 | (37.7558256605685, -122.479943411619) | 1 | 8 | 3 | 56 | 35 | |
57171 | 87956 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3250 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50982 | 5999898.4 | 2119763 | 37.800457616115 | -122.44449703515 | (37.800457616115, -122.44449703515) | 13 | 9 | 1 | 57 | 17 | ||
57775 | 87098 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1158 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50054 | 6007039 | 2115043 | 37.7879025171415 | -122.419452592213 | (37.7879025171415, -122.419452592213) | 13 | 9 | 10 | 28858 | 21 | ||
58053 | 62858 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399x EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | 3x3 | Permit Number 23226 | 6008618 | 2097694 | 37.7403549752059 | -122.412762522808 | (37.7403549752059, -122.412762522808) | 10 | 7 | 7 | 28859 | 2 | |
58067 | 95593 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 22nd Ave | 2 | 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 | |
58324 | 22418 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5990X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/1995 12:00:00 AM | 6 | 3X3 | 6013655.74915 | 2091748.39087 | 37.7243110239312 | -122.394927540326 | (37.7243110239312, -122.394927540326) | 10 | 3 | 8 | 58 | 1 | ||
58535 | 49033 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51460 | 6003769.51621429 | 2102291.73865454 | 37.7527059694214 | -122.429854522688 | (37.7527059694214, -122.429854522688) | 2 | 4 | 5 | 28862 | 22 | ||
58598 | 82275 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49900 | 6007963.19465099 | 2107409.01654638 | 37.7669934315585 | -122.415714295955 | (37.7669934315585, -122.415714295955) | 8 | 4 | 7 | 28853 | 19 | ||
58637 | 51277 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50924 | 6008254.72294648 | 2097673.72494943 | 37.7402789076073 | -122.414017161022 | (37.7402789076073, -122.414017161022) | 2 | 7 | 7 | 28859 | 2 | ||
58679 | 78960 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50072 | 6007769.24409179 | 2106089.05083821 | 37.7633582084166 | -122.416291642676 | (37.7633582084166, -122.416291642676) | 8 | 4 | 7 | 28859 | 19 | |
58938 | 102792 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 700X Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011271.9 | 2091582.1 | 37.7237215812631 | -122.403156521576 | (37.7237215812631, -122.403156521576) | 10 | 3 | 7 | 309 | 28 | |||
59023 | 87636 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5030 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991377.09346 | 2112789.45059 | 37.7808203036899 | -122.473474951717 | (37.7808203036899, -122.473474951717) | 11 | 6 | 2 | 54 | 26 | ||||
59055 | 32544 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Valencia St | 11 | 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 | |||
59080 | 91155 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 3 | 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 | |
59229 | 99839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
59232 | 28475 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2159X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5992961.40248 | 2093155.66385 | 37.7270026232687 | -122.466566593855 | (37.7270026232687, -122.466566593855) | 9 | 8 | 4 | 59 | 40 | ||
59351 | 32445 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4196 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36966 | 6001076.48069144 | 2105842.48573811 | 37.7623025844503 | -122.439422001985 | (37.7623025844503, -122.439422001985) | 15 | 5 | 5 | 28862 | 3 | ||
59376 | 66221 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 62 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773565 | 6005153.4538325 | 2105770.21177479 | 37.7623353150233 | -122.42531612596 | (37.7623353150233, -122.42531612596) | 8 | 4 | 5 | 28859 | 19 | ||
59563 | 28427 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2396X Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5991985.60436 | 2094402.81531 | 37.7303706324832 | -122.470030650205 | (37.7303706324832, -122.470030650205) | 9 | 8 | 4 | 59 | 40 | ||
59636 | 15729 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4400 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 04/20/1995 12:00:00 AM | 6 | 3X3 | 6002668.6888386 | 2093023.5286977 | 37.7271952084184 | -122.432999267314 | (37.7271952084184, -122.432999267314) | 9 | 7 | 6 | 28861 | 25 |
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) );