trees
8,758 rows where qSpecies_id = 16 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1303 | 35175 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
1340 | 87020 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49949 | |||||||||||||
1492 | 20444 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
2323 | 35205 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
2511 | 20282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
2538 | 20304 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3339 | 19580 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 | |||||||||||||
3634 | 20382 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
3913 | 35208 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
3997 | 20436 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
4295 | 20447 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
4531 | 20442 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
4587 | 35197 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
5218 | 19581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 | |||||||||||||
5272 | 20437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
5362 | 109193 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | ||||||||||
5850 | 20445 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
6596 | 20449 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
6911 | 20443 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
6998 | 20438 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
7474 | 35177 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
8283 | 19872 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY33 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
8676 | 34246 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38056 | |||||||||||||||
9631 | 35176 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
9856 | 35210 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10004 | 20406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 51 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
10031 | 35174 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10526 | 20383 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
10547 | 20439 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
10551 | 35179 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10979 | 35203 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
11384 | 258014 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4222 Moraga Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | |||||||||||||||
11690 | 35212 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
11860 | 20441 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 15 | |||||||||||||
11862 | 260530 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790x 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
12844 | 35183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
13065 | 20384 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
13515 | 35181 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
13897 | 20448 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
14056 | 20375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
14273 | 20403 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 48 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
14818 | 20309 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
14889 | 35207 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
14939 | 20281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
15355 | 20450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
15456 | 20376 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
15754 | 35209 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
15758 | 260531 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790x 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
16160 | 20446 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15 | |||||||||||||
16270 | 35178 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
16636 | 35198 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
17105 | 20440 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
17110 | 35180 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
17377 | 260517 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4711x Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
17847 | 20000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY46 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
18187 | 35206 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18230 | 35204 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18875 | 46976 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44996 | |||||||||||||
19559 | 19579 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | |||||||||||||
122192 | 28359 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5976 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5996267.60238 | 2086264.77857 | 37.708272104693 | -122.454639569129 | (37.708272104693, -122.454639569129) | 9 | 7 | 6 | 28861 | 25 | |||
103874 | 15976 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5937 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1994 12:00:00 AM | 6 | 3X3 | 5996505.50776 | 2086284.06053 | 37.7083386912237 | -122.453818737586 | (37.7083386912237, -122.453818737586) | 9 | 7 | 6 | 28861 | 5 | ||
63811 | 15975 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5935 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | 6 | 3X3 | 5996543.37676 | 2086292.72232 | 37.7083646455815 | -122.453688483731 | (37.7083646455815, -122.453688483731) | 9 | 7 | 6 | 28861 | 5 | ||
76055 | 49385 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005164.37085 | 2086125.02291 | 37.7083946451788 | -122.423881378145 | (37.7083946451788, -122.423881378145) | 9 | 7 | 8 | 309 | 5 | |||
43278 | 49384 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005168.64487 | 2086139.94661 | 37.7084358637884 | -122.423867667076 | (37.7084358637884, -122.423867667076) | 9 | 7 | 8 | 309 | 5 | |||
54650 | 49382 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 46344 | 6005177.03839 | 2086162.29158 | 37.7084976921939 | -122.423840245826 | (37.7084976921939, -122.423840245826) | 9 | 7 | 8 | 309 | 5 | |||
131778 | 49380 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005184.20185 | 2086182.68651 | 37.7085540967551 | -122.423816937211 | (37.7085540967551, -122.423816937211) | 9 | 7 | 8 | 309 | 5 | |||
179223 | 177639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5900 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 5996554.50989 | 2086363.60809 | 37.7085599198679 | -122.453655121598 | (37.7085599198679, -122.453655121598) | 9 | 7 | 6 | 28861 | 25 | |||
30895 | 39979 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2145 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/1999 12:00:00 AM | Permit Number 41237 | 6006144.69846015 | 2086166.07297413 | 37.7085626554063 | -122.420496156449 | (37.7085626554063, -122.420496156449) | 9 | 7 | 8 | 309 | 39 | |||
143221 | 39978 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2145 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/1999 12:00:00 AM | Permit Number 41237 | 6006144.69846015 | 2086166.07297413 | 37.7085626554063 | -122.420496156449 | (37.7085626554063, -122.420496156449) | 9 | 7 | 8 | 309 | 39 | |||
80473 | 177640 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5900 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 5996580.5488 | 2086374.81131 | 37.7085921740666 | -122.453565936738 | (37.7085921740666, -122.453565936738) | 9 | 7 | 6 | 28861 | 25 | |||
150073 | 49379 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 46344 | 6005199.53958 | 2086214.76466 | 37.7086430424119 | -122.423766207367 | (37.7086430424119, -122.423766207367) | 9 | 7 | 8 | 309 | 5 | |||
22471 | 177641 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5900 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5996637.80016 | 2086397.84413 | 37.7086586987048 | -122.453369731652 | (37.7086586987048, -122.453369731652) | 9 | 7 | 6 | 28861 | 25 | |||
70666 | 49377 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 46344 | 6005205.53768 | 2086236.36888 | 37.7087027016261 | -122.423747012218 | (37.7087027016261, -122.423747012218) | 9 | 7 | 8 | 309 | 5 | |||
76727 | 15968 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5900 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5996658.61538 | 2086422.78154 | 37.70872836421 | -122.453299591079 | (37.70872836421, -122.453299591079) | 9 | 7 | 6 | 28861 | 25 | |||
29550 | 49376 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 46344 | 6005209.85199 | 2086253.26676 | 37.7087493431729 | -122.423733302044 | (37.7087493431729, -122.423733302044) | 9 | 7 | 8 | 309 | 5 | |||
76071 | 15980 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5960 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5996636.17677 | 2086435.9239 | 37.7087631639544 | -122.453378089686 | (37.7087631639544, -122.453378089686) | 9 | 7 | 6 | 28861 | 25 | |||
130379 | 15979 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5960 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5996636.17677 | 2086435.9239 | 37.7087631639544 | -122.453378089686 | (37.7087631639544, -122.453378089686) | 9 | 7 | 6 | 28861 | 25 | |||
175501 | 49374 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005218.2051 | 2086273.63725 | 37.7088057477588 | -122.423705879936 | (37.7088057477588, -122.423705879936) | 9 | 7 | 8 | 309 | 5 | |||
157880 | 49373 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 522Walbridge Carter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Permit Number 46344 | 6005224.91503 | 2086291.2762 | 37.7088545593518 | -122.423683942767 | (37.7088545593518, -122.423683942767) | 9 | 7 | 8 | 309 | 5 | |||
170946 | 15966 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5894 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 5996871.49621 | 2086494.71439 | 37.7089380748908 | -122.452569038239 | (37.7089380748908, -122.452569038239) | 9 | 7 | 6 | 28861 | 25 | |||
130461 | 15965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5894 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 5996894.16825 | 2086505.28201 | 37.7089683901523 | -122.452491442944 | (37.7089683901523, -122.452491442944) | 9 | 7 | 6 | 28861 | 25 | |||
26253 | 92760 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
29317 | 92765 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
33508 | 92764 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
38873 | 92763 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
51017 | 92762 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
66938 | 92761 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
87570 | 92759 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
134204 | 92767 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
149511 | 92766 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
164064 | 177646 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5870 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 5996947.52419 | 2086525.1457 | 37.7090259881292 | -122.452308470453 | (37.7090259881292, -122.452308470453) | 9 | 7 | 6 | 28861 | 25 | |||
114781 | 44058 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Santos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43585 | 6006388.24435487 | 2086330.04561534 | 37.7090266120769 | -122.419666055943 | (37.7090266120769, -122.419666055943) | 9 | 7 | 8 | 309 | 39 | |||
19855 | 44060 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 261 Santos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | 8 | Permit Number 43587 | 6006383.26807 | 2086331.02129 | 37.7090290107549 | -122.419683323929 | (37.7090290107549, -122.419683323929) | 9 | 7 | 8 | 309 | 39 | ||
113926 | 15960 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5870 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5996972.39546 | 2086534.8395 | 37.7090540298949 | -122.452223211127 | (37.7090540298949, -122.452223211127) | 9 | 7 | 6 | 28861 | 25 | |||
50101 | 15957 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5858 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5996992.22779 | 2086542.15413 | 37.7090752502926 | -122.452155195428 | (37.7090752502926, -122.452155195428) | 9 | 7 | 6 | 28861 | 25 | |||
156481 | 15956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5853 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5997148.28101 | 2086539.17139 | 37.7090759985243 | -122.451615639949 | (37.7090759985243, -122.451615639949) | 9 | 7 | 6 | 28861 | 5 | |||
159771 | 46206 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 251 Santos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | Permit Number 44522 | 6006396.87193811 | 2086352.72360654 | 37.7090893670899 | -122.419637845634 | (37.7090893670899, -122.419637845634) | 9 | 7 | 8 | 309 | 39 | |||
29071 | 15955 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5851 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5997169.58385 | 2086548.66205 | 37.7091032776624 | -122.45154269863 | (37.7091032776624, -122.45154269863) | 9 | 7 | 6 | 28861 | 5 | |||
98747 | 177711 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 5994431.51774 | 2086616.48409 | 37.7091323221755 | -122.461010711685 | (37.7091323221755, -122.461010711685) | 9 | 8 | 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) );