Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55574 | 55574 | 194005 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6019962.69863 | 2093253.82353 | 37.728793337639296 | -122.373229233067 | (37.7287933376393, -122.373229233067) | |||
| 157235 | 157235 | 194006 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6019953.97455 | 2093259.9764900003 | 37.7288097529433 | -122.37325981899099 | (37.7288097529433, -122.373259818991) | |||
| 101112 | 101112 | 3570 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 134600 | 134600 | 83049 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 11 | 6018864.1607099995 | 2097578.2563400003 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | |||
| 13840 | 13840 | 3556 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018742.23536 | 2097565.89761 | 37.740566287010395 | -122.377747650939 | (37.7405662870104, -122.377747650939) | |||
| 16233 | 16233 | 3547 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6018659.18869 | 2097627.86643 | 37.7407318647912 | -122.378039097821 | (37.7407318647912, -122.378039097821) | |||
| 16604 | 16604 | 3546 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018623.4169 | 2097653.5081700003 | 37.740800300486704 | -122.378164564055 | (37.7408003004867, -122.378164564055) | ||
| 16434 | 16434 | 3544 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6018582.49326 | 2097682.52078 | 37.740877707832 | -122.378308077855 | (37.740877707832, -122.378308077855) | |||
| 159024 | 159024 | 3587 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018440.3984199995 | 2097892.70026 | 37.7414469858874 | -122.378813986102 | (37.7414469858874, -122.378813986102) | ||
| 93206 | 93206 | 38450 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | ||
| 108500 | 108500 | 38452 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | ||
| 142817 | 142817 | 38449 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | ||
| 143689 | 143689 | 38451 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | ||
| 15884 | 15884 | 3532 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018368.40332 | 2097843.5336 | 37.7413080145474 | -122.379059509092 | (37.7413080145474, -122.379059509092) | ||
| 13736 | 13736 | 3526 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018266.26649 | 2097919.3860299997 | 37.741510657881996 | -122.379417933909 | (37.741510657882, -122.379417933909) | ||
| 86329 | 86329 | 38453 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 110769 | 110769 | 38456 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 116083 | 116083 | 38454 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 22313 | 22313 | 3602 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.4470599997 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | ||
| 155683 | 155683 | 199967 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1235 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6018075.9658 | 2092814.3198 | 37.727482654492505 | -122.379721339986 | (37.7274826544925, -122.379721339986) | |||
| 31943 | 31943 | 199965 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1235 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6018058.1422 | 2092787.5843 | 37.7274082608424 | -122.37978110017299 | (37.7274082608424, -122.379781100173) | |||
| 14959 | 14959 | 3519 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018155.4524300005 | 2098002.8080700003 | 37.7417336061107 | -122.37980688978 | (37.7417336061107, -122.37980688978) | |||
| 16763 | 16763 | 3518 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 12 | 3X3 | 6018140.3962 | 2098014.05812 | 37.741763665963894 | -122.37985973126001 | (37.7417636659639, -122.37985973126) | ||
| 27880 | 27880 | 199944 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1210 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6018023.9999 | 2092821.7636 | 37.72750022720871 | -122.379901505266 | (37.7275002272087, -122.379901505266) | |||
| 87844 | 87844 | 10843 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6018044.17001 | 2094607.0340099998 | 37.732403344492 | -122.379955772489 | (37.732403344492, -122.379955772489) | ||
| 164764 | 164764 | 199961 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1275 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017978.5725 | 2092678.0965 | 37.727103239124204 | -122.38004857081002 | (37.7271032391242, -122.38004857081) | |||
| 85090 | 85090 | 3484 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 301X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1999 12:00:00 AM | 12 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 109078 | 109078 | 3485 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 301X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | |||
| 128653 | 128653 | 3487 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 301X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | |||
| 13771 | 13771 | 3514 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 6 | 3X3 | 6018078.86698 | 2098059.01516 | 37.7418837146726 | -122.380075604504 | (37.7418837146726, -122.380075604504) | ||
| 162024 | 162024 | 199957 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1250 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017969.9869 | 2092748.3059999999 | 37.72729554714989 | -122.380083128148 | (37.7272955471499, -122.380083128148) | |||
| 178417 | 178417 | 199958 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1250 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017956.5437 | 2092731.9821 | 37.727249983221 | -122.380128467853 | (37.727249983221, -122.380128467853) | |||
| 123512 | 123512 | 10838 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X4 | 6017982.97201 | 2094620.0550099998 | 37.732435721384505 | -122.380168255061 | (37.7324357213845, -122.380168255061) | |||
| 124058 | 124058 | 10837 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6017972.5560099995 | 2094607.0340099998 | 37.7323993935967 | -122.380203361451 | (37.7323993935967, -122.380203361451) | ||
| 107602 | 107602 | 10835 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017959.53501 | 2094605.73201 | 37.7323951001445 | -122.380248288115 | (37.7323951001445, -122.380248288115) | |||
| 188279 | 188279 | 193951 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1333 Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017949.6573 | 2094593.78019 | 37.7323617377914 | -122.380281607712 | (37.7323617377914, -122.380281607712) | |||
| 42951 | 42951 | 74588 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 7 | 6017904.0953 | 2092578.1569 | 37.7268247152753 | -122.380299097717 | (37.7268247152753, -122.380299097717) | ||
| 169136 | 169136 | 193950 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1333 Hudson Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6017943.23791 | 2094595.8890799999 | 37.732367174196 | -122.380303947776 | (37.732367174196, -122.380303947776) | |||
| 115621 | 115621 | 10833 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X4 | 6017942.60801 | 2094605.73201 | 37.7323941661952 | -122.380306809323 | (37.7323941661952, -122.380306809323) | |||
| 16754 | 16754 | 3613 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018003.94992 | 2098219.94993 | 37.742321475865296 | -122.380345828295 | (37.7423214758653, -122.380345828295) | |||
| 64969 | 64969 | 193949 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1333 Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017926.41427 | 2094599.69205 | 37.7323766881315 | -122.380362375828 | (37.7323766881315, -122.380362375828) | |||
| 47363 | 47363 | 74888 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 7 | 6017884.362000001 | 2092550.785 | 37.7267484685203 | -122.380365414433 | (37.7267484685203, -122.380365414433) | ||
| 143191 | 143191 | 10831 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017923.07701 | 2094607.0340099998 | 37.732396663570206 | -122.380374423717 | (37.7323966635702, -122.380374423717) | |||
| 86967 | 86967 | 10759 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120X Hudson Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 144479 | 144479 | 10750 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120X Hudson Ave | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 13427 | 13427 | 3615 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017970.88261 | 2098244.46459 | 37.7423869635862 | -122.380461869644 | (37.7423869635862, -122.380461869644) | ||
| 33254 | 33254 | 75201 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 3 | 6017848.7148 | 2092502.4066 | 37.726613663810795 | -122.380485286019 | (37.7266136638108, -122.380485286019) | ||
| 140288 | 140288 | 87011 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 Navy Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49945 | 6017870.0 | 2093666.0 | 37.729809839576795 | -122.380492542678 | (37.7298098395768, -122.380492542678) | |||
| 23151 | 23151 | 3506 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 7 | 3X3 | 6017950.95507 | 2098155.67272 | 37.742142059314105 | -122.380524603638 | (37.7421420593141, -122.380524603638) | ||
| 70836 | 70836 | 38481 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1116 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.38056477357401 | (37.727253198437, -122.380564773574) | |||
| 105325 | 105325 | 38482 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1116 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.38056477357401 | (37.727253198437, -122.380564773574) | |||
| 88302 | 88302 | 38460 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1115 Quesada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 126202 | 126202 | 38458 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1115 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 138638 | 138638 | 38459 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1115 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 1081 | 1081 | 3617 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.742454020638796 | -122.380579893948 | (37.7424540206388, -122.380579893948) | ||
| 61851 | 61851 | 199938 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1390 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017794.9257 | 2092510.3636 | 37.726632543892705 | -122.38067178783702 | (37.7266325438927, -122.380671787837) | |||
| 58615 | 58615 | 199939 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1390 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6017768.8268 | 2092474.0798 | 37.7265314752647 | -122.380759490632 | (37.7265314752647, -122.380759490632) | |||
| 88152 | 88152 | 38445 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1401 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 100560 | 100560 | 38447 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1401 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 144938 | 144938 | 38444 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1401 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 85656 | 85656 | 38467 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 109695 | 109695 | 38466 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 126797 | 126797 | 38468 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 188239 | 188239 | 200013 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1401 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017733.4979 | 2092339.4479 | 37.7261598523232 | -122.38087226721599 | (37.7261598523232, -122.380872267216) | |||
| 157204 | 157204 | 200011 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1435 Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6017713.1281 | 2092312.7125 | 37.7260853178116 | -122.38094082734699 | (37.7260853178116, -122.380940827347) | |||
| 33269 | 33269 | 199999 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1450 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017702.3066 | 2092388.4628 | 37.7262927161578 | -122.380983501033 | (37.7262927161578, -122.380983501033) | |||
| 77054 | 77054 | 200010 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1435 Griffith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017699.7604 | 2092295.5254 | 37.726037387531 | -122.380985844801 | (37.726037387531, -122.380985844801) | |||
| 22348 | 22348 | 3623 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.7555299997 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | ||
| 58652 | 58652 | 200008 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1435 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017666.6594 | 2092252.2395 | 37.725916705741604 | -122.381097265893 | (37.7259167057416, -122.381097265893) | |||
| 130219 | 130219 | 193948 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1333 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017699.87199 | 2094704.4778900002 | 37.732651906764204 | -122.381152876327 | (37.7326519067642, -122.381152876327) | |||
| 51464 | 51464 | 200006 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1435 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6017639.2874 | 2092216.5923 | 37.7258173144878 | -122.38118941256799 | (37.7258173144878, -122.381189412568) | |||
| 167464 | 167464 | 200003 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1450 Griffith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6017637.3777 | 2092299.9813 | 37.72604617909779 | -122.38120180983 | (37.7260461790978, -122.38120180983) | |||
| 83187 | 83187 | 10817 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6017674.37901 | 2094694.2740099998 | 37.732622481652704 | -122.381240303482 | (37.7326224816527, -122.381240303482) | ||
| 162888 | 162888 | 193947 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Hudson Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6017663.60688 | 2094730.20311 | 37.7327205412225 | -122.381280043139 | (37.7327205412225, -122.381280043139) | |||
| 36516 | 36516 | 193952 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1322 Hudson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017662.71124 | 2094787.23325 | 37.7328770853097 | -122.381287103739 | (37.7328770853097, -122.381287103739) | |||
| 90275 | 90275 | 10815 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/1993 12:00:00 AM | 6 | 3X4 | 6017647.03501 | 2094719.0130099999 | 37.7326889005557 | -122.38133655896999 | (37.7326889005557, -122.38133655897) | ||
| 38996 | 38996 | 200005 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1450 Griffith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6017596.0015 | 2092245.8739 | 37.7258953265232 | -122.381341085541 | (37.7258953265232, -122.381341085541) | |||
| 22341 | 22341 | 3629 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017712.663240001 | 2098437.04484 | 37.7429014981049 | -122.38136811194201 | (37.7429014981049, -122.381368111942) | |||
| 161727 | 161727 | 193946 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017632.63816 | 2094759.78168 | 37.7328000484856 | -122.38138916690001 | (37.7328000484856, -122.3813891669) | |||
| 112427 | 112427 | 10811 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/1993 12:00:00 AM | 8 | 3X4 | 6017631.41001 | 2094765.8880099999 | 37.7328167474611 | -122.381393837439 | (37.7328167474611, -122.381393837439) | ||
| 80422 | 80422 | 38462 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1160 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1998 12:00:00 AM | Permit Number 40473 | 6017581.82042544 | 2092920.99873262 | 37.7277483051936 | -122.381437035842 | (37.7277483051936, -122.381437035842) | |||
| 98938 | 98938 | 38474 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 116469 | 116469 | 38470 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101 Shafter Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 181371 | 181371 | 193953 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1322 Hudson Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017567.44108 | 2094871.5619299999 | 37.7331033754053 | -122.38162234311399 | (37.7331033754053, -122.381622343114) | |||
| 100631 | 100631 | 10765 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120X Hudson Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | 3X4 | 6017565.8970099995 | 2094869.6883099999 | 37.733098145559204 | -122.381627551172 | (37.7330981455592, -122.381627551172) | ||
| 30235 | 30235 | 193977 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6017598.84707 | 2096624.78326 | 37.737919107391896 | -122.381635651288 | (37.7379191073919, -122.381635651288) | |||
| 170482 | 170482 | 193971 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6017590.460469999 | 2096414.3465599997 | 37.73734082710389 | -122.38165001705 | (37.7373408271039, -122.38165001705) | |||
| 51711 | 51711 | 193970 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6017589.13074 | 2096389.5474599998 | 37.73727266029479 | -122.381652890383 | (37.7372726602948, -122.381652890383) | |||
| 153951 | 153951 | 193976 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6017588.17241 | 2096600.1724 | 37.73785094147429 | -122.38167084805201 | (37.7378509414743, -122.381670848052) | |||
| 160492 | 160492 | 193972 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6017579.15602 | 2096461.74325 | 37.7374703447825 | -122.381692397593 | (37.7374703447825, -122.381692397593) | |||
| 34882 | 34882 | 193975 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017579.158869999 | 2096575.5278099999 | 37.7377827746515 | -122.38170029905199 | (37.7377827746515, -122.381700299052) | |||
| 45597 | 45597 | 200023 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1550 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6017489.0598 | 2092100.1023 | 37.7254891615497 | -122.381700645666 | (37.7254891615497, -122.381700645666) | |||
| 49058 | 49058 | 193969 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017573.064180001 | 2096344.77018 | 37.737148823669706 | -122.381705327132 | (37.7371488236697, -122.381705327132) | |||
| 50344 | 50344 | 193974 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6017573.72994 | 2096553.5007900002 | 37.7377219930789 | -122.38171753814899 | (37.7377219930789, -122.381717538149) | |||
| 63840 | 63840 | 193973 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017569.878330001 | 2096506.6162 | 37.737593044669296 | -122.381727595263 | (37.7375930446693, -122.381727595263) | |||
| 64927 | 64927 | 193978 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 590 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6017570.577930001 | 2096665.84545 | 37.738030295051 | -122.38173624765 | (37.738030295051, -122.38173624765) | |||
| 183450 | 183450 | 193968 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6017552.11933 | 2096323.5127400002 | 37.7370892984411 | -122.38177626568199 | (37.7370892984411, -122.381776265682) | |||
| 14377 | 14377 | 3491 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017586.275719999 | 2098422.4314200003 | 37.7428543943144 | -122.38180411316401 | (37.7428543943144, -122.381804113164) | |||
| 47124 | 47124 | 193979 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6017524.43136 | 2096521.3698 | 37.7376310455329 | -122.38188575454599 | (37.7376310455329, -122.381885754546) | |||
| 134280 | 134280 | 193980 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6017523.18435 | 2096506.10562 | 37.737589064277394 | -122.38188900468799 | (37.7375890642774, -122.381889004688) |
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");