Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19695 | 19695 | 162 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5119X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1994 12:00:00 AM | 3 | 3X3 | 5991169.13123 | 2112654.48309 | 37.780437675056206 | -122.47418453611401 | (37.7804376750562, -122.474184536114) | ||
| 88096 | 88096 | 201 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1800X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X6 | 5989853.087040001 | 2114748.48442 | 37.7861108905335 | -122.478890501056 | (37.7861108905335, -122.478890501056) | |||
| 21279 | 21279 | 209 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2924 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 5990600.52986 | 2095750.0689299998 | 37.7339896833587 | -122.474917299886 | (37.7339896833587, -122.474917299886) | |||
| 12021 | 12021 | 219 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2949 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 5X8 | 5990525.93487 | 2095591.0616 | 37.7335487664486 | -122.475163590944 | (37.7335487664486, -122.475163590944) | |||
| 20431 | 20431 | 235 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2994 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1994 12:00:00 AM | 14 | 3X3 | 5990616.42942 | 2095306.68002 | 37.7327731713422 | -122.474829978418 | (37.7327731713422, -122.474829978418) | ||
| 17522 | 17522 | 236 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2996X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X5 | 5990618.96661 | 2095242.77985 | 37.732597864700395 | -122.47481654436599 | (37.7325978647004, -122.474816544366) | |||
| 98100 | 98100 | 240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3010X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 5x5 | 5990623.3177 | 2095139.449 | 37.73231439650579 | -122.474793962374 | (37.7323143965058, -122.474793962374) | |||
| 19039 | 19039 | 250 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3060 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 2x10 | 5990631.19828 | 2094871.0468099997 | 37.7315778886877 | -122.474747134678 | (37.7315778886877, -122.474747134678) | |||
| 12253 | 12253 | 252 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3063 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2003 12:00:00 AM | 6 | 2 | 5990549.27758 | 2094856.00777 | 37.731531847902495 | -122.47502925021601 | (37.7315318479025, -122.475029250216) | ||
| 20002 | 20002 | 277 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2 | 5990658.58913 | 2094051.40062 | 37.7293289342608 | -122.47459264285801 | (37.7293289342608, -122.474592642858) | |||
| 20176 | 20176 | 278 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/18/1995 12:00:00 AM | 4 | 2 | 5990657.14807 | 2094136.56397 | 37.7295626878705 | -122.47460383762 | (37.7295626878705, -122.47460383762) | ||
| 20604 | 20604 | 279 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/18/1995 12:00:00 AM | 6 | 2 | 5990654.48819 | 2094194.6647700001 | 37.729722063906294 | -122.47461727168199 | (37.7297220639063, -122.474617271682) | ||
| 85313 | 85313 | 280 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.47453510192301 | (37.7294662695904, -122.474535101923) | |||
| 115765 | 115765 | 281 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.47453510192301 | (37.7294662695904, -122.474535101923) | |||
| 141544 | 141544 | 282 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.47453510192301 | (37.7294662695904, -122.474535101923) | |||
| 19064 | 19064 | 296 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3451X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | |||
| 89956 | 89956 | 298 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3451X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | |||
| 106214 | 106214 | 318 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3498X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/1994 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 91919 | 91919 | 320 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3486X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 51513 | 51513 | 386 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3721X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | |||
| 113273 | 113273 | 441 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 700x 23rd Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8x100 | 5988813.91417 | 2110455.50375 | 37.7742631725206 | -122.482171092771 | (37.7742631725206, -122.482171092771) | |||
| 82164 | 82164 | 455 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 740X 23rd Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2015 08:09:00 AM | 3 | 8x100 | 5988822.12971 | 2110252.37193 | 37.773705906735 | -122.482127789493 | (37.773705906735, -122.482127789493) | ||
| 84653 | 84653 | 811 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X 39th Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 11458 | 11458 | 816 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1407 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5982441.9002 | 2105512.2605 | 37.7603177651627 | -122.503846491262 | (37.7603177651627, -122.503846491262) | |||
| 10626 | 10626 | 817 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1411 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5982444.3085 | 2105474.5318 | 37.760214314489204 | -122.503835367885 | (37.7602143144892, -122.503835367885) | |||
| 275 | 275 | 818 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1385 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 5982124.8821 | 2105687.3873 | 37.7607799675436 | -122.504955867812 | (37.7607799675436, -122.504955867812) | |||
| 11425 | 11425 | 824 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1388 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5981860.7062 | 2105619.4684 | 37.7605779358873 | -122.505864483221 | (37.7605779358873, -122.505864483221) | |||
| 12184 | 12184 | 828 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1412 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5981866.7376 | 2105450.851 | 37.7601153156753 | -122.50583112277701 | (37.7601153156753, -122.505831122777) | |||
| 11686 | 11686 | 829 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1417 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5981822.9883 | 2105447.64 | 37.760103924068396 | -122.50598219005501 | (37.7601039240684, -122.505982190055) | |||
| 11697 | 11697 | 834 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5981553.6693 | 2105499.8181 | 37.760231333592294 | -122.50691749005101 | (37.7602313335923, -122.506917490051) | |||
| 9393 | 9393 | 841 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1187X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 3X6 | 6003324.20608 | 2094228.6177400001 | 37.7305412725046 | -122.43081911418001 | (37.7305412725046, -122.43081911418) | |||
| 9319 | 9319 | 842 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1187X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3X6 | 6003324.20608 | 2094228.6177400001 | 37.7305412725046 | -122.43081911418001 | (37.7305412725046, -122.43081911418) | |||
| 9329 | 9329 | 891 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1156X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x6 | 6003446.0 | 2094341.0 | 37.730856748712895 | -122.43040607010401 | (37.7308567487129, -122.430406070104) | |||
| 11020 | 11020 | 892 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1158X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 8 | 3X6 | 6003460.07065 | 2094370.0687099998 | 37.730937361871796 | -122.430359498792 | (37.7309373618718, -122.430359498792) | ||
| 11467 | 11467 | 908 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1210 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3x3 | 6003130.076330001 | 2094257.46245 | 37.730609472638704 | -122.431492307321 | (37.7306094726387, -122.431492307321) | |||
| 11250 | 11250 | 913 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1230 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003036.55588 | 2094226.0548 | 37.73051793336 | -122.431813379687 | (37.73051793336, -122.431813379687) | |||
| 12557 | 12557 | 922 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1253 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002943.78693 | 2094101.1406 | 37.7301696879821 | -122.432125178253 | (37.7301696879821, -122.432125178253) | |||
| 11882 | 11882 | 923 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1265 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6002880.78677 | 2094080.3061 | 37.7301089090793 | -122.43234149039 | (37.7301089090793, -122.43234149039) | |||
| 12517 | 12517 | 927 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1280X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x6 | 6002786.5672 | 2094139.2156 | 37.7302653182672 | -122.432671425572 | (37.7302653182672, -122.432671425572) | |||
| 11456 | 11456 | 930 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1289 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4X4 | 6002711.921 | 2094006.11465 | 37.7298956195772 | -122.432919981978 | (37.7298956195772, -122.432919981978) | |||
| 11015 | 11015 | 942 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1374 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6002482.20048 | 2093944.6701900002 | 37.7297138746866 | -122.4337097621 | (37.7297138746866, -122.4337097621) | |||
| 78602 | 78602 | 943 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1384 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002443.94534 | 2093925.38038 | 37.7296587384674 | -122.433840635919 | (37.7296587384674, -122.433840635919) | |||
| 11112 | 11112 | 944 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1392 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002408.411309999 | 2093871.1827 | 37.7295079074404 | -122.43395960815701 | (37.7295079074404, -122.433959608157) | |||
| 12656 | 12656 | 947 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1434 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6002275.68767 | 2093694.59125 | 37.7290154944498 | -122.434405825665 | (37.7290154944498, -122.434405825665) | |||
| 12165 | 12165 | 948 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1449 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6002315.01229 | 2093609.5485099999 | 37.728784218499605 | -122.43426380023399 | (37.7287842184996, -122.434263800234) | |||
| 12230 | 12230 | 950 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1478 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 6x12 | 6002141.00147 | 2093513.5892299998 | 37.7285108578791 | -122.43485850664 | (37.7285108578791, -122.43485850664) | |||
| 10484 | 10484 | 953 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1515 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6002086.14446 | 2093294.4445200001 | 37.727906021522706 | -122.43503248316999 | (37.7279060215227, -122.43503248317) | |||
| 12501 | 12501 | 954 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1514 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x4 | 6002009.6783300005 | 2093329.08448 | 37.7279967928139 | -122.43529930484199 | (37.7279967928139, -122.435299304842) | |||
| 12280 | 12280 | 956 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1525 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002060.364709999 | 2093260.71871 | 37.727811954252 | -122.435119193111 | (37.727811954252, -122.435119193111) | |||
| 9102 | 9102 | 957 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1528 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3X3 | 6001955.00111 | 2093277.90628 | 37.7278531638615 | -122.43548466570299 | (37.7278531638615, -122.435484665703) | |||
| 11771 | 11771 | 959 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6001939.26614 | 2093234.51245 | 37.7277331205838 | -122.43553595873199 | (37.7277331205838, -122.435535958732) | |||
| 11356 | 11356 | 960 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1542 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6001911.33287 | 2093192.76 | 37.7276168912919 | -122.435629538568 | (37.7276168912919, -122.435629538568) | |||
| 12765 | 12765 | 961 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1545 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6002019.178280001 | 2093203.17786 | 37.727651621314 | -122.435257461163 | (37.727651621314, -122.435257461163) | |||
| 12007 | 12007 | 962 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1546 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6001900.02269 | 2093175.0227400002 | 37.7275675463899 | -122.435667369479 | (37.7275675463899, -122.435667369479) | |||
| 12180 | 12180 | 964 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1558 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6001863.50379 | 2093108.0987900002 | 37.7273817140762 | -122.435788829205 | (37.7273817140762, -122.435788829205) | |||
| 10874 | 10874 | 965 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1570 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6001836.4971900005 | 2093055.5082900003 | 37.7272357783944 | -122.43587842956998 | (37.7272357783944, -122.43587842957) | |||
| 13099 | 13099 | 991 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1664 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x4 | 6001564.02343 | 2092454.84645 | 37.7255710154858 | -122.43677738826901 | (37.7255710154858, -122.436777388269) | |||
| 12354 | 12354 | 992 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1674 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6001533.42725 | 2092387.6215099997 | 37.7253846921419 | -122.43687834616199 | (37.7253846921419, -122.436878346162) | |||
| 11040 | 11040 | 1000 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1726 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X5PL | 6001385.76767 | 2092068.0675700002 | 37.724498876108 | -122.43736591900499 | (37.724498876108, -122.437365919005) | |||
| 11683 | 11683 | 1009 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1833 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6001322.10095 | 2091567.1902700001 | 37.723119960895794 | -122.437550153242 | (37.7231199608958, -122.437550153242) | |||
| 63420 | 63420 | 1015 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1854X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6001128.27711 | 2091386.71553 | 37.7226133962853 | -122.43820724002899 | (37.7226133962853, -122.438207240029) | |||
| 12805 | 12805 | 1024 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1936 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000869.85642 | 2090880.51088 | 37.721208772055 | -122.439064279706 | (37.721208772055, -122.439064279706) | |||
| 10457 | 10457 | 1031 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1984 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000748.31196 | 2090644.16977 | 37.7205529162678 | -122.439467489832 | (37.7205529162678, -122.439467489832) | |||
| 12238 | 12238 | 1033 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1986 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6000734.4092 | 2090618.0584 | 37.7204804291149 | -122.43951367630899 | (37.7204804291149, -122.439513676309) | |||
| 12170 | 12170 | 1034 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1988 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6000717.70682 | 2090589.8934799999 | 37.7204021440199 | -122.43956939291401 | (37.7204021440199, -122.439569392914) | |||
| 10661 | 10661 | 1037 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1995 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000781.27408 | 2090531.4026900001 | 37.7202451592572 | -122.439345471618 | (37.7202451592572, -122.439345471618) | |||
| 139481 | 139481 | 1038 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1998 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6000639.40978 | 2090456.1794200002 | 37.720030538913 | -122.439830457778 | (37.720030538913, -122.439830457778) | |||
| 118954 | 118954 | 1039 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1999X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1992 12:00:00 AM | 40 | 4X4 | 6000719.678169999 | 2090412.71158 | 37.7199157548074 | -122.439549883589 | (37.7199157548074, -122.439549883589) | ||
| 105871 | 105871 | 1041 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1999X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6000719.678169999 | 2090412.71158 | 37.7199157548074 | -122.439549883589 | (37.7199157548074, -122.439549883589) | |||
| 12981 | 12981 | 1044 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2006 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6000601.62098 | 2090401.54806 | 37.7198783824605 | -122.439957165309 | (37.7198783824605, -122.439957165309) | |||
| 11021 | 11021 | 1057 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2050 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000403.71469 | 2090207.6886900002 | 37.7193348205218 | -122.440627358991 | (37.7193348205218, -122.440627358991) | |||
| 10460 | 10460 | 1059 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2058 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6000366.95559 | 2090175.28019 | 37.719243740775205 | -122.440752097656 | (37.7192437407752, -122.440752097656) | |||
| 101092 | 101092 | 1062 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2063X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 24 | 3X3 | 6000425.073480001 | 2090112.17888 | 37.719073788482 | -122.440546683168 | (37.719073788482, -122.440546683168) | ||
| 11732 | 11732 | 1074 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2118 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000073.74803 | 2089898.48202 | 37.71846701343029 | -122.441745747777 | (37.7184670134303, -122.441745747777) | |||
| 12796 | 12796 | 1078 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2130 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000037.95609 | 2089861.3905200001 | 37.7183631291423 | -122.441866804631 | (37.7183631291423, -122.441866804631) | |||
| 120195 | 120195 | 1089 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2265X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999640.80888 | 2089363.2505 | 37.7169727115576 | -122.443203813906 | (37.7169727115576, -122.443203813906) | |||
| 12713 | 12713 | 1091 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2251X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5999737.13954 | 2089459.43604 | 37.7172423076744 | -122.44287774961701 | (37.7172423076744, -122.442877749617) | |||
| 103954 | 103954 | 1092 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2255X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999742.85997 | 2089459.4611400003 | 37.7172427027246 | -122.442857978648 | (37.7172427027246, -122.442857978648) | |||
| 12658 | 12658 | 1094 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2284 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5999623.230219999 | 2089468.7932099998 | 37.7172615054862 | -122.443272150897 | (37.7172615054862, -122.443272150897) | |||
| 12385 | 12385 | 1095 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2290 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999600.8344 | 2089448.5273400003 | 37.717204582898795 | -122.44334810764 | (37.7172045828988, -122.44334810764) | |||
| 12588 | 12588 | 1097 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2316 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5999455.44663 | 2089307.19768 | 37.7168082318808 | -122.443840494542 | (37.7168082318808, -122.443840494542) | |||
| 11671 | 11671 | 1099 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2322 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999433.62842 | 2089286.91962 | 37.7167513084001 | -122.443914453006 | (37.7167513084001, -122.443914453006) | |||
| 12026 | 12026 | 1101 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2335 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999481.131569999 | 2089218.0401599999 | 37.7165648906342 | -122.443745313006 | (37.7165648906342, -122.443745313006) | |||
| 11324 | 11324 | 1102 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2337 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999464.66551 | 2089201.27894 | 37.716517928937606 | -122.443801024204 | (37.7165179289376, -122.443801024204) | |||
| 11044 | 11044 | 1103 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2338 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999382.2943 | 2089237.6939299998 | 37.7166132174991 | -122.44408835401501 | (37.7166132174991, -122.444088354015) | |||
| 10995 | 10995 | 1105 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2350 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5999349.79224 | 2089204.2013299998 | 37.7165194002245 | -122.444198291627 | (37.7165194002245, -122.444198291627) | |||
| 12176 | 12176 | 1107 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2356 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999332.0602 | 2089185.7581 | 37.7164677476693 | -122.444258257539 | (37.7164677476693, -122.444258257539) | |||
| 11527 | 11527 | 1108 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2361 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5999379.82751 | 2089124.2738299998 | 37.7163016509691 | -122.444088735333 | (37.7163016509691, -122.444088735333) | |||
| 11669 | 11669 | 1110 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999256.41959 | 2089119.22107 | 37.7162807363552 | -122.444514928547 | (37.7162807363552, -122.444514928547) | |||
| 10836 | 10836 | 1111 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2375 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5999361.19435 | 2089104.49923 | 37.716246291420205 | -122.444151720228 | (37.7162462914202, -122.444151720228) | |||
| 98323 | 98323 | 1116 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2418 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999119.96085 | 2089004.98208 | 37.715959274829295 | -122.44497838668501 | (37.7159592748293, -122.444978386685) | |||
| 11306 | 11306 | 1117 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2421 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5999164.76525 | 2088914.5447099998 | 37.715713511436704 | -122.44481702519501 | (37.7157135114367, -122.444817025195) | |||
| 12576 | 12576 | 1118 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2433 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999115.09869 | 2088867.74297 | 37.7155821699698 | -122.44498533243099 | (37.7155821699698, -122.444985332431) | |||
| 93166 | 93166 | 1119 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2436 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999061.60827 | 2088955.1741099998 | 37.715819182925 | -122.445176500985 | (37.715819182925, -122.445176500985) | |||
| 118037 | 118037 | 1123 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2460 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 9x5 | 5998978.66323 | 2088894.9055299999 | 37.7156489643361 | -122.445458865248 | (37.7156489643361, -122.445458865248) | |||
| 58960 | 58960 | 1125 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2466 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5998958.39293 | 2088881.75103 | 37.7156116878713 | -122.445527983003 | (37.7156116878713, -122.445527983003) | |||
| 10453 | 10453 | 1134 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2571 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 5998552.04947 | 2088553.0790900001 | 37.714686023424 | -122.446908847388 | (37.714686023424, -122.446908847388) | |||
| 11550 | 11550 | 1135 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2572 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5998530.85202 | 2088632.33495 | 37.7149024308741 | -122.44698781416099 | (37.7149024308741, -122.446987814161) | |||
| 105717 | 105717 | 1136 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2579 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5998552.80286 | 2088529.1670900001 | 37.7146204095726 | -122.44690452372299 | (37.7146204095726, -122.446904523723) | |||
| 11972 | 11972 | 1137 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2614 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5998316.29466 | 2088516.5463 | 37.7145722411917 | -122.447721080858 | (37.7145722411917, -122.447721080858) |
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");