Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCareAssistant
| 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 | ||||||||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 171840 | 171840 | 177646 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5870 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5996947.52419 | 2086525.1457 | 37.7090259881292 | -122.45230847045299 | (37.7090259881292, -122.452308470453) | |||
| 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) | ||
| 11962 | 11962 | 15960 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5870 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5996972.39546 | 2086534.8395 | 37.7090540298949 | -122.45222321112699 | (37.7090540298949, -122.452223211127) | |||
| 11016 | 11016 | 15957 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5858 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5996992.22779 | 2086542.15413 | 37.7090752502926 | -122.452155195428 | (37.7090752502926, -122.452155195428) | |||
| 12662 | 12662 | 15956 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5853 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5997148.28101 | 2086539.1713900003 | 37.7090759985243 | -122.451615639949 | (37.7090759985243, -122.451615639949) | |||
| 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) | |||
| 11824 | 11824 | 15955 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5851 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5997169.58385 | 2086548.66205 | 37.70910327766239 | -122.45154269863 | (37.7091032776624, -122.45154269863) | |||
| 68231 | 68231 | 177711 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 5994431.51774 | 2086616.4840900002 | 37.7091323221755 | -122.461010711685 | (37.7091323221755, -122.461010711685) | |||
| 11731 | 11731 | 15952 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5845 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2016 12:00:00 AM | 15 | 4x6 | 5997201.68184 | 2086560.6022 | 37.7091379006634 | -122.451432624323 | (37.7091379006634, -122.451432624323) | ||
| 140838 | 140838 | 15951 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5840 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x5 | 5997069.49341 | 2086569.25103 | 37.709154077974894 | -122.451890108828 | (37.7091540779749, -122.451890108828) | |||
| 172180 | 172180 | 177710 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5994442.40126 | 2086628.41328 | 37.709165703209294 | -122.460973960888 | (37.7091657032093, -122.460973960888) | |||
| 13178 | 13178 | 15953 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5845 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2013 12:00:00 AM | 14 | 4x4 | 5997237.66299 | 2086574.7541200002 | 37.7091788189244 | -122.451309288592 | (37.7091788189244, -122.451309288592) |
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");