trees
2,365 rows where qSpecies_id = 31 sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72945 | 104450 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
74389 | 104447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
2130 | 83476 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 674-680 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015406.08252 | 2105913.749 | 37.763303339101 | -122.389865835643 | (37.763303339101, -122.389865835643) | 14 | 3 | 8 | 28856 | 29 | |||
2748 | 51918 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.92432 | 2091688.24542 | 37.7233599872689 | -122.443166369055 | (37.7233599872689, -122.443166369055) | 9 | 7 | 6 | 28861 | 25 | |
4054 | 61321 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1493 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 2 | Permit Number 21224 | 6011782.72959 | 2101393.64443 | 37.750690525464 | -122.40208010572 | (37.750690525464, -122.40208010572) | 10 | 3 | 8 | 28856 | 29 | |
4061 | 46914 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
4643 | 76181 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6009574.6956 | 2110252.7468 | 37.7748921128949 | -122.410341153951 | (37.7748921128949, -122.410341153951) | 8 | 2 | 9 | 28853 | 34 | |||
5574 | 259351 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 443 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010386.58434 | 2092559.48475 | 37.7263557946777 | -122.406285753959 | (37.7263557946777, -122.406285753959) | 10 | 3 | 7 | 309 | 28 | ||
5917 | 66634 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 963 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | 5 | 3x3 | Permit Number 29842 | 6010240.69544356 | 2103618.46143652 | 37.7567131899968 | -122.407569458435 | (37.7567131899968, -122.407569458435) | 10 | 4 | 7 | 28859 | 19 |
6695 | 260396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
7235 | 74494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010764.33667 | 2106446.7054 | 37.7645082103165 | -122.405957737757 | (37.7645082103165, -122.405957737757) | 8 | 4 | 8 | 28859 | 19 | |||
8224 | 254835 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 250 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2019 12:00:00 AM | 3 | 4x3 | Permit Number 784635 | 5989365 | 2113673 | 37.7831295589045 | -122.480500378386 | (37.7831295589045, -122.480500378386) | 11 | 6 | 2 | 55 | 26 |
8503 | 80188 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1435 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008710.7243 | 2109332.6568 | 37.7723172927739 | -122.413264744885 | (37.7723172927739, -122.413264744885) | 8 | 2 | 9 | 28853 | 34 | |||
9031 | 74649 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010746.42629 | 2106444.22464 | 37.7645003969982 | -122.406019510419 | (37.7645003969982, -122.406019510419) | 8 | 4 | 8 | 28859 | 19 | |||
10535 | 258146 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1048 Folsom St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010642.12041 | 2111257.36423 | 37.7777103373451 | -122.406719502289 | (37.7777103373451, -122.406719502289) | 14 | 2 | 9 | 28853 | 34 | ||||
10797 | 49734 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2940REVISED Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.7502358181357 | -122.413951255275 | (37.7502358181357, -122.413951255275) | 2 | 4 | 7 | 28859 | 19 | ||
12480 | 47528 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 277 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.426412322279 | (37.7468583456276, -122.426412322279) | 2 | 7 | 5 | 63 | 22 | ||
12738 | 72412 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3485 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997617.1015 | 2116066.53919 | 37.7901776988858 | -122.452124350462 | (37.7901776988858, -122.452124350462) | 11 | 6 | 1 | 54 | 31 | |||
13803 | 74944 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010701.03805 | 2106443.01503 | 37.7644945370101 | -122.406176411522 | (37.7644945370101, -122.406176411522) | 8 | 4 | 8 | 28859 | 19 | |||
15262 | 73760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3485 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997597.70095 | 2116065.74811 | 37.7901744154595 | -122.452191417426 | (37.7901744154595, -122.452191417426) | 11 | 6 | 1 | 54 | 31 | |||
15550 | 32997 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013196.81609 | 2113721.08426 | 37.784617751847 | -122.398054757315 | (37.784617751847, -122.398054757315) | 6 | 2 | 9 | 28853 | 6 | |
16163 | 32994 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.84928 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | 6 | 2 | 9 | 28853 | 6 | |
17144 | 48943 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1344 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 46130 | 6010846.48741491 | 2102064.8294817 | 37.7524811515419 | -122.40536498901 | (37.7524811515419, -122.40536498901) | 10 | 4 | 8 | 28859 | 19 | ||
17960 | 81238 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008758.1555 | 2109381.0971 | 37.7724529612773 | -122.41310410127 | (37.7724529612773, -122.41310410127) | 8 | 2 | 9 | 28853 | 34 | |||
18373 | 259350 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
21744 | 44267 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 315 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | 2 | 7 | 7 | 28859 | 2 | ||
22908 | 32995 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.26593 | 37.7844388182424 | -122.398280299215 | (37.7844388182424, -122.398280299215) | 6 | 2 | 9 | 28853 | 6 | |
23232 | 32533 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
23291 | 41906 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 60 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42269 | 6003134.36765804 | 2107953.23072837 | 37.7682150777502 | -122.432455314129 | (37.7682150777502, -122.432455314129) | 15 | 5 | 5 | 28862 | 3 | ||
26544 | 50045 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3928 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3x3 | Permit Number 46776 | 6003593.46976323 | 2102471.5753466 | 37.753189787602 | -122.430476153053 | (37.753189787602, -122.430476153053) | 2 | 4 | 5 | 28862 | 22 | |
28789 | 31076 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6006020.69113 | 2107294.38947 | 37.7665693044606 | -122.422424975532 | (37.7665693044606, -122.422424975532) | 8 | 4 | 5 | 28853 | 19 | |
37815 | 36939 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.7864999276851 | -122.461372345087 | (37.7864999276851, -122.461372345087) | 11 | 6 | 1 | 54 | 11 | |
38280 | 66565 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 195 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1994 12:00:00 AM | Permit Number 29754 | 6004459.66256991 | 2092267.48419115 | 37.725220702439 | -122.426754065425 | (37.725220702439, -122.426754065425) | 9 | 7 | 6 | 28861 | 5 | ||
39987 | 33125 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2380 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 13 | 6x7 | Permit Number 37358 | 6001538.52427 | 2119069.35252 | 37.7986464896046 | -122.438771824677 | (37.7986464896046, -122.438771824677) | 13 | 9 | 1 | 57 | 17 |
40654 | 31073 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | 8 | 4 | 5 | 28853 | 19 | ||
41592 | 33124 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2380 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 12 | 6x6 | Permit Number 37358 | 6001499.40758 | 2119065.90574 | 37.7986348002003 | -122.438906933417 | (37.7986348002003, -122.438906933417) | 13 | 9 | 1 | 57 | 17 |
42463 | 30575 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 262 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 9 | Permit Number 43817 | 6004015.93268 | 2108728.78356 | 37.7703945078227 | -122.429461383638 | (37.7703945078227, -122.429461383638) | 7 | 9 | 11 | 29492 | 10 | |
44866 | 50808 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 499 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2006 12:00:00 AM | Permit Number 47332 | 6008981.38895406 | 2105919.05287132 | 37.7629595191577 | -122.412087198232 | (37.7629595191577, -122.412087198232) | 8 | 4 | 7 | 28859 | 19 | ||
48921 | 36885 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2914 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39542 | 6000200.34388 | 2116470.40485 | 37.79143424424 | -122.443215577236 | (37.79143424424, -122.443215577236) | 13 | 6 | 1 | 29490 | 27 | |
49721 | 30802 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.83021 | 37.733802178321 | -122.43669510479 | (37.733802178321, -122.43669510479) | 9 | 7 | 5 | 63 | 40 |
51115 | 41185 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3440 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 2 | Permit Number 41903 | 6001280.22409 | 2120345.11349 | 37.8021346936235 | -122.439757137177 | (37.8021346936235, -122.439757137177) | 13 | 9 | 1 | 57 | 17 | |
56170 | 46874 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1360 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44937 | 6008040.39641169 | 2117081.79459414 | 37.7935568987708 | -122.416132380604 | (37.7935568987708, -122.416132380604) | 5 | 1 | 10 | 28858 | 21 | ||
58093 | 48676 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4930 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2006 12:00:00 AM | Permit Number 48856 | 5997717.95296797 | 2105658.6000715 | 37.7616059742438 | -122.451024572529 | (37.7616059742438, -122.451024572529) | 15 | 5 | 11 | 29492 | 9 | ||
58417 | 31777 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2126 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35251 | 5989451.98537783 | 2098364.25532499 | 37.7411009369348 | -122.479079284327 | (37.7411009369348, -122.479079284327) | 1 | 8 | 3 | 29491 | 35 | ||
58932 | 31077 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6005999.97732 | 2107292.75552 | 37.7665636495047 | -122.422496504935 | (37.7665636495047, -122.422496504935) | 8 | 4 | 5 | 28853 | 19 | |
59964 | 93910 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2690 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 3x3 | 6001101.2138 | 2114914.769 | 37.7872141986511 | -122.439986998855 | (37.7872141986511, -122.439986998855) | 13 | 6 | 1 | 29490 | 27 | ||
62676 | 32534 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
63920 | 32998 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.7846540898483 | -122.398013908317 | (37.7846540898483, -122.398013908317) | 6 | 2 | 9 | 28853 | 6 | |
66630 | 72449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3687 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1996 12:00:00 AM | 11 | 5997241.71464 | 2115032.69529 | 37.7873175292136 | -122.453348481559 | (37.7873175292136, -122.453348481559) | 11 | 6 | 1 | 54 | 31 | ||
67520 | 40174 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 801 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2006 12:00:00 AM | 8 | Permit Number 48884 | 6002465.36284573 | 2103545.36770604 | 37.7560741956992 | -122.434454137261 | (37.7560741956992, -122.434454137261) | 2 | 4 | 5 | 28862 | 22 | |
69043 | 74234 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3695 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1996 12:00:00 AM | 13 | 5997222.04614 | 2115031.53176 | 37.7873132070818 | -122.45341644603 | (37.7873132070818, -122.45341644603) | 11 | 6 | 1 | 54 | 31 | ||
70956 | 41880 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 126 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42256 | 6004087.67177215 | 2108230.12497736 | 37.7690293739028 | -122.429177676408 | (37.7690293739028, -122.429177676408) | 7 | 9 | 5 | 28862 | 3 | |
75248 | 49733 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2940REVISED Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.7502358181357 | -122.413951255275 | (37.7502358181357, -122.413951255275) | 2 | 4 | 7 | 28859 | 19 | ||
79111 | 50430 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 53REVISED Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2004 12:00:00 AM | Permit Number 47083 | 5998656.22086914 | 2105364.79387751 | 37.7608529276064 | -122.447758347691 | (37.7608529276064, -122.447758347691) | 15 | 5 | 11 | 29492 | 12 | ||
79347 | 32996 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.02247 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | 6 | 2 | 9 | 28853 | 6 | |
84509 | 33151 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2434 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 7 | Permit Number 37374 | 5987066.8878 | 2098694.8228 | 37.7418697871522 | -122.487350256926 | (37.7418697871522, -122.487350256926) | 1 | 8 | 3 | 29491 | 35 | |
85066 | 47527 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 277 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.426412322279 | (37.7468583456276, -122.426412322279) | 2 | 7 | 5 | 63 | 22 | ||
86066 | 69124 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 471 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 2 | Permit Number 33294 | 6005151.1076 | 2110757.242 | 37.7760283687547 | -122.425679204983 | (37.7760283687547, -122.425679204983) | 7 | 9 | 11 | 28852 | 10 | |
89564 | 63582 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1370 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 7 | 3x3 | Permit Number 24205 | 6006460.0817 | 2118715.02595 | 37.797952359573 | -122.42171646447 | (37.797952359573, -122.42171646447) | 13 | 9 | 10 | 28858 | 32 |
90759 | 32989 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.33259 | 37.7843240827368 | -122.398422883105 | (37.7843240827368, -122.398422883105) | 6 | 2 | 9 | 28853 | 6 | |
92189 | 36145 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2201 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | 8 | 4 | 8 | 28859 | 19 | ||
98386 | 46780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 60 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 6 | Permit Number 44871 | 6002511.8819 | 2093449.26082 | 37.7283552769641 | -122.433571759353 | (37.7283552769641, -122.433571759353) | 9 | 7 | 6 | 28861 | 25 | |
98651 | 33318 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2604 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37462 | 6004913.93801 | 2118560.00816 | 37.7974394114518 | -122.427055518194 | (37.7974394114518, -122.427055518194) | 13 | 9 | 1 | 57 | 17 | |
103111 | 46632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.7285785323655 | -122.389527911332 | (37.7285785323655, -122.389527911332) | 10 | 3 | 8 | 58 | 1 |
105246 | 36930 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | Permit Number 45859 | 6001519.66406839 | 2103540.62826183 | 37.7560074548941 | -122.437724334797 | (37.7560074548941, -122.437724334797) | 2 | 4 | 5 | 28862 | 3 | ||
106747 | 115732 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 99 ORD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 22 | 3x3 | 6000874 | 2105811 | 37.7622046070719 | -122.440120047168 | (37.7622046070719, -122.440120047168) | 15 | 5 | 5 | 28862 | 3 | ||
107535 | 68693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 12 | 3x3 | Permit Number 32603 | 5993650.82821 | 2113525.78591 | 37.7829734883164 | -122.46566257132 | (37.7829734883164, -122.46566257132) | 11 | 6 | 2 | 54 | 11 |
118194 | 98271 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
120906 | 41342 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 965 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | 4 | 3x3 | Permit Number 45442 | 6011232.3538 | 2111749.1886 | 37.7790937789608 | -122.404712304921 | (37.7790937789608, -122.404712304921) | 14 | 2 | 9 | 28856 | 34 |
125652 | 117152 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.7285509455903 | -122.389513905896 | (37.7285509455903, -122.389513905896) | 10 | 3 | 8 | 58 | 1 | |||
128168 | 98270 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
128458 | 36148 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | 7 | Permit Number 39234 | 6010838.36126 | 2106450.88886 | 37.7645238369413 | -122.405702000241 | (37.7645238369413, -122.405702000241) | 8 | 4 | 8 | 28859 | 19 | |
131533 | 47022 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 340 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769670 | 6004925.00265887 | 2109895.52879881 | 37.7736495352098 | -122.426399993288 | (37.7736495352098, -122.426399993288) | 7 | 9 | 11 | 28852 | 10 |
132072 | 84446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000457.5617 | 2112125.7689 | 37.7795196602627 | -122.442013625663 | (37.7795196602627, -122.442013625663) | 15 | 5 | 1 | 29490 | 16 | |||
137883 | 31072 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | 8 | 4 | 5 | 28853 | 19 | ||
140296 | 43563 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 511 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43224 | 6003260.27136522 | 2098892.12079733 | 37.7433425627255 | -122.431372921103 | (37.7433425627255, -122.431372921103) | 2 | 7 | 5 | 63 | 22 | ||
140749 | 48645 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45938 | 5993372.07519062 | 2104329.12614097 | 37.7577058229285 | -122.465958462939 | (37.7577058229285, -122.465958462939) | 1 | 8 | 4 | 56 | 12 | ||
143782 | 43394 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 625 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43137 | 6002354.2327444 | 2102058.9743147 | 37.7519866054834 | -122.434732175811 | (37.7519866054834, -122.434732175811) | 2 | 4 | 5 | 28862 | 22 | ||
143872 | 34293 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2868 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/2002 12:00:00 AM | 7 | Permit Number 45961 | 6010202.37211243 | 2101668.36098933 | 37.7513565026505 | -122.407564507802 | (37.7513565026505, -122.407564507802) | 2 | 4 | 7 | 28859 | 19 | |
148761 | 44268 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 315 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | 2 | 7 | 7 | 28859 | 2 | ||
151150 | 32451 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4444 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 14 | Permit Number 36969 | 5999681.89649 | 2105763.67379 | 37.7620067217593 | -122.444239665821 | (37.7620067217593, -122.444239665821) | 15 | 5 | 5 | 28862 | 3 | |
151881 | 47711 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.7369794845402 | -122.435360375218 | (37.7369794845402, -122.435360375218) | 2 | 7 | 5 | 63 | 7 | ||
155936 | 102761 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.408218187711 | (37.7785759102049, -122.408218187711) | 14 | 2 | 9 | 28853 | 34 |
158775 | 32532 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
159935 | 43393 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 621 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43136 | 6002378.82516016 | 2102060.30692007 | 37.7519916606466 | -122.434647227061 | (37.7519916606466, -122.434647227061) | 2 | 4 | 5 | 28862 | 22 | ||
160961 | 35492 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3711 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44720 | 6005570.32724281 | 2104283.24490329 | 37.7582759965632 | -122.423768581299 | (37.7582759965632, -122.423768581299) | 2 | 4 | 5 | 28859 | 19 | ||
163070 | 36147 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2201 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | 8 | 4 | 8 | 28859 | 19 | ||
164216 | 98273 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
165534 | 72448 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3681 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1996 12:00:00 AM | 11 | 5997285.67318 | 2115040.09705 | 37.7873403720155 | -122.453196929609 | (37.7873403720155, -122.453196929609) | 11 | 6 | 1 | 54 | 31 | ||
168239 | 46913 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
168818 | 48429 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2460 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 10 | Permit Number 45807 | 6001230.18864 | 2118334.23878 | 37.7966105144187 | -122.439786028808 | (37.7966105144187, -122.439786028808) | 13 | 9 | 1 | 57 | 17 | |
176570 | 68218 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 233 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/2010 12:00:00 AM | 4 | Permit Number 53885 | 5990842.3093 | 2113821.79414 | 37.7836238495535 | -122.475400406913 | (37.7836238495535, -122.475400406913) | 11 | 6 | 2 | 54 | 26 | |
177447 | 31075 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 7 | Permit Number 34816 | 6005979.98097 | 2107292.47987 | 37.7665617645507 | -122.422565649286 | (37.7665617645507, -122.422565649286) | 8 | 4 | 5 | 28853 | 19 | |
177464 | 37290 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 799 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 12 | 3x3 | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.7561221336837 | -122.434458693674 | (37.7561221336837, -122.434458693674) | 2 | 4 | 5 | 28862 | 3 |
177900 | 63730 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | 3x3 | Permit Number 24397 | 6003608.14995212 | 2110143.86487572 | 37.7742568780009 | -122.430972913922 | (37.7742568780009, -122.430972913922) | 15 | 9 | 11 | 29492 | 10 | |
180006 | 32993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013060.48706 | 2113590.00605 | 37.7842502474912 | -122.398517212115 | (37.7842502474912, -122.398517212115) | 6 | 2 | 9 | 28853 | 6 | |
180406 | 43363 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4147 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43113 | 6002235.09605777 | 2101760.99319187 | 37.7511616557639 | -122.435122856595 | (37.7511616557639, -122.435122856595) | 2 | 4 | 5 | 28862 | 22 | ||
184925 | 46912 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
185130 | 30619 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1645 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 4 | Permit Number 34580 | 6008146.3215 | 2108637.1249 | 37.7703758225592 | -122.415167828975 | (37.7703758225592, -122.415167828975) | 8 | 2 | 9 | 28853 | 19 | |
185186 | 46875 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) | 3 | 1 | 10 | 308 | 21 |
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) );