trees
8,758 rows where qSpecies_id = 16 sorted by Longitude
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 | |||||||||||||
20792 | 194005 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6019962.69863 | 2093253.82353 | 37.7287933376393 | -122.373229233067 | (37.7287933376393, -122.373229233067) | 10 | 3 | 8 | 58 | 1 | |||
116139 | 194006 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6019953.97455 | 2093259.97649 | 37.7288097529433 | -122.373259818991 | (37.7288097529433, -122.373259818991) | 10 | 3 | 8 | 58 | 1 | |||
109278 | 3570 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
9540 | 83049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11 | 6018864.16071 | 2097578.25634 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | 10 | 3 | 8 | 58 | 1 | ||||
28438 | 3556 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018742.23536 | 2097565.89761 | 37.7405662870104 | -122.377747650939 | (37.7405662870104, -122.377747650939) | 10 | 3 | 8 | 58 | 1 | |||
169971 | 3547 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 57 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6018659.18869 | 2097627.86643 | 37.7407318647912 | -122.378039097821 | (37.7407318647912, -122.378039097821) | 10 | 3 | 8 | 58 | 1 | |||
173078 | 3546 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 56 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018623.4169 | 2097653.50817 | 37.7408003004867 | -122.378164564055 | (37.7408003004867, -122.378164564055) | 10 | 3 | 8 | 58 | 1 | ||
155193 | 3544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 54 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6018582.49326 | 2097682.52078 | 37.740877707832 | -122.378308077855 | (37.740877707832, -122.378308077855) | 10 | 3 | 8 | 58 | 1 | |||
55609 | 3587 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 23 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018440.39842 | 2097892.70026 | 37.7414469858874 | -122.378813986102 | (37.7414469858874, -122.378813986102) | 10 | 3 | 8 | 58 | 1 | ||
84345 | 38450 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
119493 | 38452 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
176250 | 38449 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
176907 | 38451 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
146365 | 3532 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018368.40332 | 2097843.5336 | 37.7413080145474 | -122.379059509092 | (37.7413080145474, -122.379059509092) | 10 | 3 | 8 | 58 | 1 | ||
36780 | 3526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018266.26649 | 2097919.38603 | 37.741510657882 | -122.379417933909 | (37.741510657882, -122.379417933909) | 10 | 3 | 8 | 58 | 1 | ||
69792 | 38453 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
142162 | 38456 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
142867 | 38454 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
17391 | 3602 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.44706 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | 10 | 3 | 8 | 58 | 1 | ||
10170 | 199967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1235 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6018075.9658 | 2092814.3198 | 37.7274826544925 | -122.379721339986 | (37.7274826544925, -122.379721339986) | 10 | 3 | 8 | 58 | 1 | |||
118133 | 199965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1235 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6018058.1422 | 2092787.5843 | 37.7274082608424 | -122.379781100173 | (37.7274082608424, -122.379781100173) | 10 | 3 | 8 | 58 | 1 | |||
88781 | 3519 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018155.45243 | 2098002.80807 | 37.7417336061107 | -122.37980688978 | (37.7417336061107, -122.37980688978) | 10 | 3 | 8 | 58 | 1 | |||
186834 | 3518 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/1990 12:00:00 AM | 12 | 3X3 | 6018140.3962 | 2098014.05812 | 37.7417636659639 | -122.37985973126 | (37.7417636659639, -122.37985973126) | 10 | 3 | 8 | 58 | 1 | ||
100618 | 199944 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1210 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6018023.9999 | 2092821.7636 | 37.7275002272087 | -122.379901505266 | (37.7275002272087, -122.379901505266) | 10 | 3 | 8 | 58 | 1 | |||
67952 | 10843 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6018044.17001 | 2094607.03401 | 37.732403344492 | -122.379955772489 | (37.732403344492, -122.379955772489) | 10 | 3 | 8 | 58 | 1 | ||
45986 | 199961 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1275 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6017978.5725 | 2092678.0965 | 37.7271032391242 | -122.38004857081 | (37.7271032391242, -122.38004857081) | 10 | 3 | 8 | 58 | 1 | |||
23485 | 3487 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X Cargo Way | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | |||
72676 | 3484 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/1999 12:00:00 AM | 12 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
120930 | 3485 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X Cargo Way | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | |||
33643 | 3514 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/1996 12:00:00 AM | 6 | 3X3 | 6018078.86698 | 2098059.01516 | 37.7418837146726 | -122.380075604504 | (37.7418837146726, -122.380075604504) | 10 | 3 | 8 | 58 | 1 | ||
153667 | 199957 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1250 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017969.9869 | 2092748.306 | 37.7272955471499 | -122.380083128148 | (37.7272955471499, -122.380083128148) | 10 | 3 | 8 | 58 | 1 | |||
146676 | 199958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1250 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6017956.5437 | 2092731.9821 | 37.727249983221 | -122.380128467853 | (37.727249983221, -122.380128467853) | 10 | 3 | 8 | 58 | 1 | |||
1994 | 10838 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X4 | 6017982.97201 | 2094620.05501 | 37.7324357213845 | -122.380168255061 | (37.7324357213845, -122.380168255061) | 10 | 3 | 8 | 58 | 1 | |||
13261 | 10837 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6017972.55601 | 2094607.03401 | 37.7323993935967 | -122.380203361451 | (37.7323993935967, -122.380203361451) | 10 | 3 | 8 | 58 | 1 | ||
131891 | 10835 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017959.53501 | 2094605.73201 | 37.7323951001445 | -122.380248288115 | (37.7323951001445, -122.380248288115) | 10 | 3 | 8 | 58 | 1 | |||
193455 | 193951 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1333 Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017949.6573 | 2094593.78019 | 37.7323617377914 | -122.380281607712 | (37.7323617377914, -122.380281607712) | 10 | 3 | 8 | 58 | 1 | |||
13760 | 74588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6017904.0953 | 2092578.1569 | 37.7268247152753 | -122.380299097717 | (37.7268247152753, -122.380299097717) | 10 | 3 | 8 | 58 | 1 | |||
105510 | 193950 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1333 Hudson Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6017943.23791 | 2094595.88908 | 37.732367174196 | -122.380303947776 | (37.732367174196, -122.380303947776) | 10 | 3 | 8 | 58 | 1 | |||
147530 | 10833 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 40 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X4 | 6017942.60801 | 2094605.73201 | 37.7323941661952 | -122.380306809323 | (37.7323941661952, -122.380306809323) | 10 | 3 | 8 | 58 | 1 | |||
33186 | 3613 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 49 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018003.94992 | 2098219.94993 | 37.7423214758653 | -122.380345828295 | (37.7423214758653, -122.380345828295) | 10 | 3 | 8 | 58 | 1 |
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) );