Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
124 | 124 | 20281 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
738 | 738 | 20446 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15 | ||||||||
1497 | 1497 | 20382 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
2559 | 2559 | 19580 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 8 | ||||||||
3177 | 3177 | 46976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44996 | ||||||||
5603 | 5603 | 34246 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38056 | ||||||||||
5617 | 5617 | 35204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
5800 | 5800 | 20309 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
5832 | 5832 | 20376 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
5867 | 5867 | 19581 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 8 | ||||||||
6514 | 6514 | 20450 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
6778 | 6778 | 20443 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
6825 | 6825 | 35207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
6835 | 6835 | 35197 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
7167 | 7167 | 35203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
7953 | 7953 | 20384 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
8093 | 8093 | 20375 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
8280 | 8280 | 109193 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | |||||
8347 | 8347 | 20438 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
8840 | 8840 | 20436 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15 | ||||||||
9617 | 9617 | 35183 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
10310 | 10310 | 35176 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
10572 | 10572 | 20406 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
10924 | 10924 | 20441 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 15 | ||||||||
11091 | 11091 | 20440 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
11317 | 11317 | 35209 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
11577 | 11577 | 20282 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
11758 | 11758 | 19579 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | ||||||||
11935 | 11935 | 20304 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
11988 | 11988 | 35180 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
12161 | 12161 | 20448 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
12435 | 12435 | 35178 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
12458 | 12458 | 35205 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
12489 | 12489 | 35198 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
12584 | 12584 | 20383 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
12698 | 12698 | 20444 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
12872 | 12872 | 35210 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
14186 | 14186 | 20442 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
14195 | 14195 | 35181 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
14347 | 14347 | 87020 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
14540 | 14540 | 20403 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
14575 | 14575 | 35206 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
14588 | 14588 | 35174 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
14986 | 14986 | 20437 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15 | ||||||||
15382 | 15382 | 20449 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
15571 | 15571 | 20439 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15 | ||||||||
16081 | 16081 | 35175 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16133 | 16133 | 35179 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16225 | 16225 | 35208 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16281 | 16281 | 20445 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
16353 | 16353 | 20447 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
16452 | 16452 | 35177 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16540 | 16540 | 19872 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY33 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
16638 | 16638 | 35212 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16789 | 16789 | 20000 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY46 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
52238 | 52238 | 49385 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005164.37085 | 2086125.0229099998 | 37.70839464517879 | -122.42388137814501 | (37.7083946451788, -122.423881378145) | |||
175737 | 175737 | 49384 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005168.64487 | 2086139.9466099998 | 37.7084358637884 | -122.423867667076 | (37.7084358637884, -122.423867667076) | |||
166715 | 166715 | 49382 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005177.03839 | 2086162.29158 | 37.7084976921939 | -122.423840245826 | (37.7084976921939, -122.423840245826) | |||
114400 | 114400 | 39978 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2145 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1999 12:00:00 AM | Permit Number 41237 | 6006144.69846015 | 2086166.07297413 | 37.7085626554063 | -122.42049615644899 | (37.7085626554063, -122.420496156449) | |||
127716 | 127716 | 39979 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2145 Geneva Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1999 12:00:00 AM | Permit Number 41237 | 6006144.69846015 | 2086166.07297413 | 37.7085626554063 | -122.42049615644899 | (37.7085626554063, -122.420496156449) | |||
68280 | 68280 | 49380 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005184.20185 | 2086182.68651 | 37.7085540967551 | -122.423816937211 | (37.7085540967551, -122.423816937211) | |||
168826 | 168826 | 49379 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Permit Number 46344 | 6005199.539580001 | 2086214.7646599999 | 37.7086430424119 | -122.423766207367 | (37.7086430424119, -122.423766207367) | |||
25795 | 25795 | 49377 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005205.53768 | 2086236.36888 | 37.7087027016261 | -122.423747012218 | (37.7087027016261, -122.423747012218) | |||
130279 | 130279 | 49376 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Permit Number 46344 | 6005209.85199 | 2086253.2667599998 | 37.7087493431729 | -122.42373330204398 | (37.7087493431729, -122.423733302044) | |||
104989 | 104989 | 28359 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5976 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5996267.60238 | 2086264.77857 | 37.708272104692995 | -122.45463956912901 | (37.708272104693, -122.454639569129) | |||
154349 | 154349 | 49374 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005218.2051 | 2086273.63725 | 37.708805747758795 | -122.42370587993601 | (37.7088057477588, -122.423705879936) | |||
97543 | 97543 | 15976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5937 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1994 12:00:00 AM | 6 | 3X3 | 5996505.5077599995 | 2086284.06053 | 37.7083386912237 | -122.453818737586 | (37.7083386912237, -122.453818737586) | ||
77192 | 77192 | 49373 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Permit Number 46344 | 6005224.915030001 | 2086291.2762 | 37.7088545593518 | -122.42368394276698 | (37.7088545593518, -122.423683942767) | |||
11376 | 11376 | 15975 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5935 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1995 12:00:00 AM | 6 | 3X3 | 5996543.376759999 | 2086292.7223200002 | 37.7083646455815 | -122.453688483731 | (37.7083646455815, -122.453688483731) | ||
104297 | 104297 | 44058 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 255 Santos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43585 | 6006388.24435487 | 2086330.04561534 | 37.7090266120769 | -122.419666055943 | (37.7090266120769, -122.419666055943) | |||
64699 | 64699 | 44060 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 261 Santos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 8 | Permit Number 43587 | 6006383.268069999 | 2086331.02129 | 37.7090290107549 | -122.41968332392901 | (37.7090290107549, -122.419683323929) | ||
77391 | 77391 | 92760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
78407 | 78407 | 92764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
86127 | 86127 | 92761 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
96352 | 96352 | 92759 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
113684 | 113684 | 92767 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
116515 | 116515 | 92766 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
127045 | 127045 | 92765 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
119617 | 119617 | 46206 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 251 Santos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 44522 | 6006396.87193811 | 2086352.72360654 | 37.709089367089895 | -122.419637845634 | (37.7090893670899, -122.419637845634) | |||
162639 | 162639 | 177639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5996554.50989 | 2086363.6080900002 | 37.708559919867895 | -122.45365512159799 | (37.7085599198679, -122.453655121598) | |||
60858 | 60858 | 177640 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5996580.5488 | 2086374.8113099998 | 37.7085921740666 | -122.453565936738 | (37.7085921740666, -122.453565936738) | |||
1071 | 1071 | 177641 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 4ft | 5996637.80016 | 2086397.8441299999 | 37.708658698704795 | -122.45336973165199 | (37.7086586987048, -122.453369731652) | |||
46024 | 46024 | 177585 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 5ft | 6008966.99196 | 2086413.05326 | 37.7093994603862 | -122.410759348591 | (37.7093994603862, -122.410759348591) | |||
154599 | 154599 | 177647 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 5ft | 6012423.949469999 | 2086414.60679 | 37.7095969506192 | -122.398811566514 | (37.7095969506192, -122.398811566514) | |||
11528 | 11528 | 1866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2555 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x6 | 6010739.94904 | 2086417.1851299999 | 37.7095100554158 | -122.40463197610599 | (37.7095100554158, -122.404631976106) | |||
35586 | 35586 | 46204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 239 Santos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | 5 | Permit Number 44520 | 6006418.91053 | 2086421.8952799998 | 37.7092805394368 | -122.41956658113001 | (37.7092805394368, -122.41956658113) | ||
93040 | 93040 | 15968 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5996658.61538 | 2086422.78154 | 37.708728364209996 | -122.453299591079 | (37.70872836421, -122.453299591079) | |||
147478 | 147478 | 177648 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6012427.630469999 | 2086427.74351 | 37.7096332265644 | -122.398799765591 | (37.7096332265644, -122.398799765591) | |||
55445 | 55445 | 177587 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 48 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008913.30843 | 2086433.5443799999 | 37.709452714651796 | -122.410946334729 | (37.7094527146518, -122.410946334729) | |||
88805 | 88805 | 15980 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5960 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5996636.17677 | 2086435.9239 | 37.708763163954394 | -122.453378089686 | (37.7087631639544, -122.453378089686) | |||
109550 | 109550 | 15979 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5960 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5996636.17677 | 2086435.9239 | 37.708763163954394 | -122.453378089686 | (37.7087631639544, -122.453378089686) | |||
47525 | 47525 | 177649 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6012431.1901 | 2086436.64385 | 37.709657863481205 | -122.398788087022 | (37.7096578634812, -122.398788087022) | |||
153886 | 153886 | 177650 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6012434.26652 | 2086449.4800599997 | 37.7096932805964 | -122.39877835455201 | (37.7096932805964, -122.398778354552) | |||
30323 | 30323 | 46207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 229 Santos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | 7 | Permit Number 44523 | 6006431.19699 | 2086460.2891900002 | 37.7093866531391 | -122.419526839197 | (37.7093866531391, -122.419526839197) | ||
131159 | 131159 | 177586 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 44 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 6ft | 6008941.6423 | 2086478.6989900002 | 37.709578288772896 | -122.41085159474702 | (37.7095782887729, -122.410851594747) | |||
10842 | 10842 | 15966 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5894 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5996871.49621 | 2086494.71439 | 37.708938074890796 | -122.452569038239 | (37.7089380748908, -122.452569038239) | |||
10344 | 10344 | 15965 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5894 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5996894.16825 | 2086505.2820099997 | 37.7089683901523 | -122.452491442944 | (37.7089683901523, -122.452491442944) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");