trees
56 rows where PlotSize = "" and qSpecies_id = 68 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9951 | 40088 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1999 12:00:00 AM | Permit Number 41311 | ||||||||||||||
76705 | 196372 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1700 Armstrong Ave | 7 | Side Yard : Yard | Tree | Private 2 | 1 | 6013890.96771 | 2092887.97335 | 37.7274531643304 | -122.394194162931 | (37.7274531643304, -122.394194162931) | 10 | 3 | 8 | 58 | 1 | ||||
166835 | 196065 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 602 Arthur Ave | 28 | Front Yard : Yard | Tree | Private 2 | 3 | 6015745.27894 | 2099859.59173 | 37.7466987082831 | -122.388270101098 | (37.7466987082831, -122.388270101098) | 3 | 8 | 58 | 1 | |||||
173631 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 68 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | |||||
191781 | 196068 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1700 Armstrong Ave | 9 | Side Yard : Yard | Tree | Private 2 | 3 | 6013885.20395 | 2092887.61216 | 37.7274518522042 | -122.394214063144 | (37.7274518522042, -122.394214063144) | 10 | 3 | 8 | 58 | 1 | ||||
191979 | 196066 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 602 Arthur Ave | 29 | Front Yard : Yard | Tree | Private 2 | 3 | 6015729.65904 | 2099863.28866 | 37.7467079937826 | -122.38832437159 | (37.7467079937826, -122.38832437159) | 3 | 8 | 58 | 1 | |||||
133845 | 49367 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1328@ 4th & 5t Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47977 | 5994585.78557071 | 2112147.74022661 | 37.7792436288989 | -122.462328048371 | (37.7792436288989, -122.462328048371) | 11 | 6 | 2 | 54 | 11 | |||
75737 | 50440 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1539 Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320979 | (37.7593865436509, -122.47037320979) | 1 | 8 | 4 | 56 | 12 | |||
174316 | 50441 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1539 Funston Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320979 | (37.7593865436509, -122.47037320979) | 1 | 8 | 4 | 56 | 12 | |||
174947 | 50443 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1539 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320979 | (37.7593865436509, -122.47037320979) | 1 | 8 | 4 | 56 | 12 | |||
193278 | 50442 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1539 Funston Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320979 | (37.7593865436509, -122.47037320979) | 1 | 8 | 4 | 56 | 12 | |||
88402 | 96987 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
70311 | 50019 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1363 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46753 | 6009308.17778689 | 2101227.80950502 | 37.7500967527825 | -122.410625639874 | (37.7500967527825, -122.410625639874) | 2 | 4 | 7 | 28859 | 19 | ||
84619 | 51065 | Permitted Site 7 | Prunus spp :: Cherry 68 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
89476 | 49741 | Permitted Site 7 | Prunus spp :: Cherry 68 | 646@ 18th Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | Permit Number 46540 | 6010086.91434322 | 2105281.03537103 | 37.7612696346383 | -122.408218548113 | (37.7612696346383, -122.408218548113) | 2 | 4 | 8 | 28859 | 19 | |||
121716 | 51062 | Permitted Site 7 | Prunus spp :: Cherry 68 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
133197 | 51064 | Permitted Site 7 | Prunus spp :: Cherry 68 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
151000 | 51061 | Permitted Site 7 | Prunus spp :: Cherry 68 | 10 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
172948 | 51060 | Permitted Site 7 | Prunus spp :: Cherry 68 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
173341 | 51063 | Permitted Site 7 | Prunus spp :: Cherry 68 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
4637 | 247987 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 124 Mullen Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6009857.2555 | 2099808.73815 | 37.7462310644209 | -122.408626794296 | (37.7462310644209, -122.408626794296) | 2 | 7 | 7 | 28859 | 2 | ||||
57739 | 247592 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 800 Tompkins Ave | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 6008994.80779 | 2096446.35961 | 37.7369503684581 | -122.411371547678 | (37.7369503684581, -122.411371547678) | 10 | 7 | 7 | 28859 | 2 | ||||
85722 | 237945 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 99 Aztec St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 6007968.29609 | 2099608.22097 | 37.7455745134701 | -122.415144412305 | (37.7455745134701, -122.415144412305) | 2 | 7 | 7 | 28859 | 2 | ||||
138611 | 237972 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 400 Prospect Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6006214.1673 | 2097605.70169 | 37.7399773120135 | -122.421067769962 | (37.7399773120135, -122.421067769962) | 2 | 7 | 7 | 28859 | 2 | ||||
41171 | 40117 | Permitted Site 7 | Prunus spp :: Cherry 68 | 51 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | Permit Number 41332 | 6004835.9770779 | 2101026.68937802 | 37.7492927732201 | -122.42607645855 | (37.7492927732201, -122.42607645855) | 2 | 4 | 5 | 28862 | 22 | ||
125827 | 56999 | Permitted Site 7 | Prunus spp :: Cherry 68 | 4206 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | Permit Number 14257 | 6001838.61131344 | 2101787.92307498 | 37.7512130767933 | -122.436495868054 | (37.7512130767933, -122.436495868054) | 2 | 4 | 5 | 28862 | 22 | |||
160 | 107490 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1306x Montgomery St | 19 | Median : Cutout | Tree | DPW 1 | 12 | 6011447.18476 | 2119974.76336 | 37.8016912541172 | -122.404548295963 | (37.8016912541172, -122.404548295963) | 3 | 1 | 10 | 308 | 23 | ||||
43718 | 45454 | Permitted Site 7 | Prunus spp :: Cherry 68 | 219 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2001 12:00:00 AM | Permit Number 44239 | 5994709.07342911 | 2090056.25354598 | 37.7185930847656 | -122.460300500781 | (37.7185930847656, -122.460300500781) | 9 | 8 | 6 | 28861 | 24 | |||
65616 | 86757 | Permitted Site 7 | Prunus spp :: Cherry 68 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
139368 | 50308 | Permitted Site 7 | Prunus spp :: Cherry 68 | 701 (REVISED) Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47019 | 5994734.51143453 | 2090549.74162157 | 37.7199495485694 | -122.460248307265 | (37.7199495485694, -122.460248307265) | 9 | 8 | 6 | 28861 | 24 | |||
118419 | 43986 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2200 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2000 12:00:00 AM | Permit Number 43550 | 6005547.87197183 | 2117529.65351428 | 37.7946461451301 | -122.424788600108 | (37.7946461451301, -122.424788600108) | 13 | 9 | 1 | 28858 | 27 | |||
127650 | 43350 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 651 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2000 12:00:00 AM | 8 | Permit Number 43102 | 6007249.15746 | 2091540.31674 | 37.7233813767346 | -122.417059535679 | (37.7233813767346, -122.417059535679) | 9 | 3 | 7 | 309 | 28 | ||
191512 | 40428 | Permitted Site 7 | Prunus spp :: Cherry 68 | 29 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1999 12:00:00 AM | Permit Number 41523 | 6007969.10251409 | 2094049.49213596 | 37.7303115087504 | -122.414748301777 | (37.7303115087504, -122.414748301777) | 9 | 3 | 7 | 309 | 28 | |||
58981 | 196335 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1900 19th St | 10 | Front Yard : Yard | Tree | Private 2 | 1 | 6012008.47004 | 2105145.92381 | 37.761006057794 | -122.401563163706 | (37.761006057794, -122.401563163706) | 10 | 3 | 8 | 28856 | 29 | ||||
190691 | 196373 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1900 19th St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6012066.64129 | 2105141.25616 | 37.760996487211 | -122.401361645431 | (37.760996487211, -122.401361645431) | 10 | 3 | 8 | 28856 | 29 | ||||
15177 | 72435 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 339 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5999048.26208 | 2115432.14991 | 37.7885177095774 | -122.447126990534 | (37.7885177095774, -122.447126990534) | 13 | 6 | 1 | 54 | 31 | |||
91325 | 84725 | Permitted Site 7 | Prunus spp :: Cherry 68 | 20 Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49296 | 5996092 | 2115960 | 37.7897976912986 | -122.457393340224 | (37.7897976912986, -122.457393340224) | 11 | 6 | 1 | 54 | 31 | |||
24447 | 136025 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 80 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6008316.37067 | 2119137.06676 | 37.7992156804143 | -122.415323048225 | (37.7992156804143, -122.415323048225) | 5 | 1 | 10 | 308 | 32 | ||||
59358 | 103517 | Permitted Site 7 | Prunus spp :: Cherry 68 | 55X MacOndray Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 770452 | 6008432 | 2119159 | 37.7992824016355 | -122.414924482909 | (37.7992824016355, -122.414924482909) | 5 | 1 | 10 | 308 | 32 | ||||
93588 | 136021 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1010 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6007482.49892 | 2120248.47345 | 37.8022204224067 | -122.418287380977 | (37.8022204224067, -122.418287380977) | 5 | 1 | 1 | 28858 | 32 | ||||
122322 | 136024 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 66 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6008379.74874 | 2119143.46885 | 37.7992368207748 | -122.415104191024 | (37.7992368207748, -122.415104191024) | 5 | 1 | 10 | 308 | 32 | ||||
163037 | 136022 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 60 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6008402.81482 | 2119144.69077 | 37.7992414720639 | -122.415024460715 | (37.7992414720639, -122.415024460715) | 5 | 1 | 10 | 308 | 32 | ||||
190293 | 136023 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 60 MacOndray Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008389.23117 | 2119145.89275 | 37.7992440090735 | -122.415071550105 | (37.7992440090735, -122.415071550105) | 5 | 1 | 10 | 308 | 32 | ||||
100372 | 40636 | Permitted Site 7 | Prunus spp :: Cherry 68 | 142 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41636 | 6010372.94752615 | 2111469.26002805 | 37.7782770896065 | -122.407665612051 | (37.7782770896065, -122.407665612051) | 14 | 2 | 9 | 28853 | 34 | |||
99909 | 96676 | Property Tree 8 | Prunus spp :: Cherry 68 | 1701 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | 1 | 8 | 3 | 56 | 35 | ||||
139351 | 96677 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1701 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767971 | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | 1 | 8 | 3 | 56 | 35 | ||||
26135 | 41411 | Permitted Site 7 | Prunus spp :: Cherry 68 | 531 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | Permit Number 42023 | 6007932.96070428 | 2088253.06472002 | 37.7143937182098 | -122.414463253601 | (37.7143937182098, -122.414463253601) | 9 | 7 | 8 | 309 | 39 | |||
208 | 107457 | Undocumented 4 | Prunus spp :: Cherry 68 | 2682 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991487.4 | 2097177.7 | 37.7379609526954 | -122.471955163509 | (37.7379609526954, -122.471955163509) | 1 | 8 | 4 | 29491 | 40 | |||||
12108 | 213702 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 714 Detroit St | 6 | Side Yard : Yard | Tree | Private 2 | 2 | 5999450.30082 | 2095402.17977 | 37.7335433498509 | -122.444296031758 | (37.7335433498509, -122.444296031758) | 9 | 7 | 4 | 63 | 40 | ||||
41546 | 213705 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 175 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998918.04752 | 2093764.63915 | 37.7290166671659 | -122.4460184358 | (37.7290166671659, -122.4460184358) | 9 | 7 | 4 | 28861 | 40 | ||||
154500 | 213704 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 635 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5997206.92035 | 2095245.84356 | 37.7329858403205 | -122.452040726125 | (37.7329858403205, -122.452040726125) | 9 | 7 | 4 | 59 | 40 | ||||
174186 | 105781 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1631 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2014 12:00:00 AM | Permit Number 772613 | 6001347.6 | 2111440.1 | 37.7776876665107 | -122.43888545994 | (37.7776876665107, -122.43888545994) | 15 | 5 | 11 | 29492 | 41 | |||
172665 | 179165 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 671 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6001067.99101 | 2089902.67343 | 37.7185351226768 | -122.438309369006 | (37.7185351226768, -122.438309369006) | 9 | 7 | 6 | 28861 | 5 | ||||
18248 | 51214 | Permitted Site 7 | Prunus spp :: Cherry 68 | 111 Mission St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47578 | 6014394.74626942 | 2116530.73461445 | 37.7923990500381 | -122.394107054187 | (37.7923990500381, -122.394107054187) | 12 | 2 | 9 | 28855 | 6 | |||
85355 | 58408 | Permitted Site 7 | Prunus spp :: Cherry 68 | 755 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1979 12:00:00 AM | 5 | Permit Number 17543 | 5999798.5 | 2108081.7 | 37.7683780948237 | -122.444002941237 | (37.7683780948237, -122.444002941237) | 15 | 5 | 11 | 29492 | 9 | ||
154514 | 109243 | Permitted Site 7 | Prunus spp :: Cherry 68 | 755 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5999798.5 | 2108081.7 | 37.7683780948237 | -122.444002941237 | (37.7683780948237, -122.444002941237) | 15 | 5 | 11 | 29492 | 9 |
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) );