trees
8,758 rows where qSpecies_id = 16 sorted by Longitude
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152833 | 193949 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1333 Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017926.41427 | 2094599.69205 | 37.7323766881315 | -122.380362375828 | (37.7323766881315, -122.380362375828) | 10 | 3 | 8 | 58 | 1 | |||
| 18071 | 74888 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6017884.362 | 2092550.785 | 37.7267484685203 | -122.380365414433 | (37.7267484685203, -122.380365414433) | 10 | 3 | 8 | 58 | 1 | |||
| 180533 | 10831 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017923.07701 | 2094607.03401 | 37.7323966635702 | -122.380374423717 | (37.7323966635702, -122.380374423717) | 10 | 3 | 8 | 58 | 1 | |||
| 72051 | 10759 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120X Hudson Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
| 173831 | 10750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120X Hudson Ave | 19 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
| 107143 | 3615 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 51 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017970.88261 | 2098244.46459 | 37.7423869635862 | -122.380461869644 | (37.7423869635862, -122.380461869644) | 10 | 3 | 8 | 58 | 1 | ||
| 14564 | 75201 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6017848.7148 | 2092502.4066 | 37.7266136638108 | -122.380485286019 | (37.7266136638108, -122.380485286019) | 10 | 3 | 8 | 58 | 1 | |||
| 175039 | 87011 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Navy Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49945 | 6017870 | 2093666 | 37.7298098395768 | -122.380492542678 | (37.7298098395768, -122.380492542678) | 10 | 3 | 8 | 58 | 1 | |||
| 110167 | 3506 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/1990 12:00:00 AM | 7 | 3X3 | 6017950.95507 | 2098155.67272 | 37.7421420593141 | -122.380524603638 | (37.7421420593141, -122.380524603638) | 10 | 3 | 8 | 58 | 1 | ||
| 6302 | 38481 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1116 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.380564773574 | (37.727253198437, -122.380564773574) | 10 | 3 | 8 | 58 | 1 | |||
| 132335 | 38482 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1116 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.380564773574 | (37.727253198437, -122.380564773574) | 10 | 3 | 8 | 58 | 1 | |||
| 20648 | 38458 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1115 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | 10 | 3 | 8 | 58 | 1 | ||
| 57760 | 38460 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1115 Quesada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | 10 | 3 | 8 | 58 | 1 | ||
| 188956 | 38459 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1115 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | 10 | 3 | 8 | 58 | 1 | ||
| 146418 | 3617 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.7424540206388 | -122.380579893948 | (37.7424540206388, -122.380579893948) | 10 | 3 | 8 | 58 | 1 | ||
| 67926 | 199938 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1390 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6017794.9257 | 2092510.3636 | 37.7266325438927 | -122.380671787837 | (37.7266325438927, -122.380671787837) | 10 | 3 | 8 | 58 | 1 | |||
| 179399 | 199939 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1390 Griffith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6017768.8268 | 2092474.0798 | 37.7265314752647 | -122.380759490632 | (37.7265314752647, -122.380759490632) | 10 | 3 | 8 | 58 | 1 | |||
| 63507 | 38445 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | 10 | 3 | 8 | 58 | 1 | ||
| 103740 | 38447 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | 10 | 3 | 8 | 58 | 1 | ||
| 193146 | 38444 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | 10 | 3 | 8 | 58 | 1 | ||
| 23549 | 38468 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.380809935654 | (37.7264471943371, -122.380809935654) | 10 | 3 | 8 | 58 | 1 | ||
| 57824 | 38467 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.380809935654 | (37.7264471943371, -122.380809935654) | 10 | 3 | 8 | 58 | 1 | ||
| 116408 | 38466 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.380809935654 | (37.7264471943371, -122.380809935654) | 10 | 3 | 8 | 58 | 1 | ||
| 118631 | 200013 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6017733.4979 | 2092339.4479 | 37.7261598523232 | -122.380872267216 | (37.7261598523232, -122.380872267216) | 10 | 3 | 8 | 58 | 1 | |||
| 137769 | 200011 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1435 Griffith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6017713.1281 | 2092312.7125 | 37.7260853178116 | -122.380940827347 | (37.7260853178116, -122.380940827347) | 10 | 3 | 8 | 58 | 1 | |||
| 9371 | 199999 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017702.3066 | 2092388.4628 | 37.7262927161578 | -122.380983501033 | (37.7262927161578, -122.380983501033) | 10 | 3 | 8 | 58 | 1 | |||
| 120228 | 200010 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1435 Griffith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017699.7604 | 2092295.5254 | 37.726037387531 | -122.380985844801 | (37.726037387531, -122.380985844801) | 10 | 3 | 8 | 58 | 1 | |||
| 140989 | 3623 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.75553 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | 10 | 3 | 8 | 58 | 1 | ||
| 69880 | 200008 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1435 Griffith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017666.6594 | 2092252.2395 | 37.7259167057416 | -122.381097265893 | (37.7259167057416, -122.381097265893) | 10 | 3 | 8 | 58 | 1 | |||
| 85289 | 193948 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1333 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017699.87199 | 2094704.47789 | 37.7326519067642 | -122.381152876327 | (37.7326519067642, -122.381152876327) | 10 | 3 | 8 | 58 | 1 | |||
| 103801 | 200006 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1435 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6017639.2874 | 2092216.5923 | 37.7258173144878 | -122.381189412568 | (37.7258173144878, -122.381189412568) | 10 | 3 | 8 | 58 | 1 | |||
| 88298 | 200003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Griffith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6017637.3777 | 2092299.9813 | 37.7260461790978 | -122.38120180983 | (37.7260461790978, -122.38120180983) | 10 | 3 | 8 | 58 | 1 | |||
| 42551 | 10817 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6017674.37901 | 2094694.27401 | 37.7326224816527 | -122.381240303482 | (37.7326224816527, -122.381240303482) | 10 | 3 | 8 | 58 | 1 | ||
| 84937 | 193947 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Hudson Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6017663.60688 | 2094730.20311 | 37.7327205412225 | -122.381280043139 | (37.7327205412225, -122.381280043139) | 10 | 3 | 8 | 58 | 1 | |||
| 53364 | 193952 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1322 Hudson Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017662.71124 | 2094787.23325 | 37.7328770853097 | -122.381287103739 | (37.7328770853097, -122.381287103739) | 10 | 3 | 8 | 58 | 1 | |||
| 60689 | 10815 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/1993 12:00:00 AM | 6 | 3X4 | 6017647.03501 | 2094719.01301 | 37.7326889005557 | -122.38133655897 | (37.7326889005557, -122.38133655897) | 10 | 3 | 8 | 58 | 1 | ||
| 170124 | 200005 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Griffith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6017596.0015 | 2092245.8739 | 37.7258953265232 | -122.381341085541 | (37.7258953265232, -122.381341085541) | 10 | 3 | 8 | 58 | 1 | |||
| 33883 | 3629 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017712.66324 | 2098437.04484 | 37.7429014981049 | -122.381368111942 | (37.7429014981049, -122.381368111942) | 10 | 3 | 8 | 58 | 1 | |||
| 133556 | 193946 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017632.63816 | 2094759.78168 | 37.7328000484856 | -122.3813891669 | (37.7328000484856, -122.3813891669) | 10 | 3 | 8 | 58 | 1 | |||
| 146542 | 10811 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/1993 12:00:00 AM | 8 | 3X4 | 6017631.41001 | 2094765.88801 | 37.7328167474611 | -122.381393837439 | (37.7328167474611, -122.381393837439) | 10 | 3 | 8 | 58 | 1 | ||
| 39247 | 38462 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1160 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1998 12:00:00 AM | Permit Number 40473 | 6017581.82042544 | 2092920.99873262 | 37.7277483051936 | -122.381437035842 | (37.7277483051936, -122.381437035842) | 10 | 3 | 8 | 58 | 1 | |||
| 111881 | 38474 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101 Shafter Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | 10 | 3 | 8 | 58 | 1 | ||
| 142677 | 38470 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101 Shafter Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | 10 | 3 | 8 | 58 | 1 | ||
| 114483 | 193953 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1322 Hudson Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017567.44108 | 2094871.56193 | 37.7331033754053 | -122.381622343114 | (37.7331033754053, -122.381622343114) | 10 | 3 | 8 | 58 | 1 | |||
| 97568 | 10765 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120X Hudson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | 3X4 | 6017565.89701 | 2094869.68831 | 37.7330981455592 | -122.381627551172 | (37.7330981455592, -122.381627551172) | 10 | 3 | 8 | 58 | 1 | ||
| 187265 | 193977 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6017598.84707 | 2096624.78326 | 37.7379191073919 | -122.381635651288 | (37.7379191073919, -122.381635651288) | 10 | 3 | 8 | 58 | 1 | |||
| 169011 | 193971 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6017590.46047 | 2096414.34656 | 37.7373408271039 | -122.38165001705 | (37.7373408271039, -122.38165001705) | 10 | 3 | 8 | 58 | 1 | |||
| 66146 | 193970 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6017589.13074 | 2096389.54746 | 37.7372726602948 | -122.381652890383 | (37.7372726602948, -122.381652890383) | 10 | 3 | 8 | 58 | 1 | |||
| 97088 | 193976 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6017588.17241 | 2096600.1724 | 37.7378509414743 | -122.381670848052 | (37.7378509414743, -122.381670848052) | 10 | 3 | 8 | 58 | 1 | |||
| 88969 | 193972 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6017579.15602 | 2096461.74325 | 37.7374703447825 | -122.381692397593 | (37.7374703447825, -122.381692397593) | 10 | 3 | 8 | 58 | 1 | |||
| 96418 | 193975 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017579.15887 | 2096575.52781 | 37.7377827746515 | -122.381700299052 | (37.7377827746515, -122.381700299052) | 10 | 3 | 8 | 58 | 1 | |||
| 13488 | 200023 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6017489.0598 | 2092100.1023 | 37.7254891615497 | -122.381700645666 | (37.7254891615497, -122.381700645666) | 10 | 3 | 8 | 58 | 1 | |||
| 138282 | 193969 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017573.06418 | 2096344.77018 | 37.7371488236697 | -122.381705327132 | (37.7371488236697, -122.381705327132) | 10 | 3 | 8 | 58 | 1 | |||
| 175562 | 193974 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6017573.72994 | 2096553.50079 | 37.7377219930789 | -122.381717538149 | (37.7377219930789, -122.381717538149) | 10 | 3 | 8 | 58 | 1 | |||
| 103658 | 193973 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017569.87833 | 2096506.6162 | 37.7375930446693 | -122.381727595263 | (37.7375930446693, -122.381727595263) | 10 | 3 | 8 | 58 | 1 | |||
| 187744 | 193978 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 590 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6017570.57793 | 2096665.84545 | 37.738030295051 | -122.38173624765 | (37.738030295051, -122.38173624765) | 10 | 3 | 8 | 58 | 1 | |||
| 37835 | 193968 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6017552.11933 | 2096323.51274 | 37.7370892984411 | -122.381776265682 | (37.7370892984411, -122.381776265682) | 10 | 3 | 8 | 58 | 1 | |||
| 67185 | 3491 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017586.27572 | 2098422.43142 | 37.7428543943144 | -122.381804113164 | (37.7428543943144, -122.381804113164) | 10 | 3 | 8 | 58 | 1 | |||
| 38765 | 193979 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6017524.43136 | 2096521.3698 | 37.7376310455329 | -122.381885754546 | (37.7376310455329, -122.381885754546) | 10 | 3 | 8 | 58 | 1 | |||
| 37649 | 193980 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6017523.18435 | 2096506.10562 | 37.7375890642774 | -122.381889004688 | (37.7375890642774, -122.381889004688) | 10 | 3 | 8 | 58 | 1 | |||
| 163867 | 193967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6017494.4463 | 2096301.95703 | 37.7370269259389 | -122.381974170481 | (37.7370269259389, -122.381974170481) | 10 | 3 | 8 | 58 | 1 | |||
| 89535 | 59851 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1119 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1981 12:00:00 AM | Permit Number 19307 | 6017428.44424481 | 2093319.71178593 | 37.7288346243781 | -122.381994988143 | (37.7288346243781, -122.381994988143) | 10 | 3 | 8 | 58 | 1 | ||
| 38499 | 193832 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 351 Cargo Way | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017529.09376 | 2098471.17206 | 37.742985068522 | -122.382005224063 | (37.742985068522, -122.382005224063) | 10 | 3 | 8 | 58 | 1 | |||
| 9199 | 59852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1123 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | 4x4 | Permit Number 19308 | 6017402.1303 | 2093334.4078 | 37.7288735235199 | -122.382086980049 | (37.7288735235199, -122.382086980049) | 10 | 3 | 8 | 58 | 1 |
| 129606 | 193981 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6017456.57186 | 2096356.73609 | 37.7371752466304 | -122.382108930285 | (37.7371752466304, -122.382108930285) | 10 | 3 | 8 | 58 | 1 | |||
| 158752 | 193831 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 351 Cargo Way | 17 | : | Tree | Private 2 | 8 | Width 3ft | 6017496.31387 | 2098500.41004 | 37.7430635397576 | -122.382120602585 | (37.7430635397576, -122.382120602585) | 10 | 3 | 8 | 58 | 1 | |||
| 56654 | 193982 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6017413.08546 | 2096375.70861 | 37.7372249395861 | -122.38226060364 | (37.7372249395861, -122.38226060364) | 10 | 3 | 8 | 58 | 1 | |||
| 118345 | 11884 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017395.5575924 | 2096373.0107113 | 37.7372165635579 | -122.382321018478 | (37.7372165635579, -122.382321018478) | 10 | 3 | 8 | 58 | 1 | |||
| 124489 | 11885 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/1998 12:00:00 AM | 6 | 4X4 | 6017395.5575924 | 2096373.0107113 | 37.7372165635579 | -122.382321018478 | (37.7372165635579, -122.382321018478) | 10 | 3 | 8 | 58 | 1 | ||
| 107712 | 193983 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6017392.53863 | 2096382.36228 | 37.7372420743459 | -122.382332106939 | (37.7372420743459, -122.382332106939) | 10 | 3 | 8 | 58 | 1 | |||
| 171696 | 193966 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 603 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6017384.08087 | 2096328.02614 | 37.7370924109796 | -122.382357570353 | (37.7370924109796, -122.382357570353) | 10 | 3 | 8 | 58 | 1 | |||
| 5831 | 11910 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 20694 | 11897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 36616 | 11906 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 38781 | 11911 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 62677 | 11903 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 102729 | 11904 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 112932 | 11912 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 118406 | 11908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 138222 | 11900 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 172664 | 11913 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 184007 | 11901 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 51477 | 11891 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:46:00 PM | 3 | 3X4 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | ||
| 133473 | 11890 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | |||
| 135913 | 11892 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | |||
| 148595 | 11894 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | |||
| 151081 | 11893 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | |||
| 51676 | 193984 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6017366.37274 | 2096390.06542 | 37.7372617803131 | -122.382423111136 | (37.7372617803131, -122.382423111136) | 10 | 3 | 8 | 58 | 1 | |||
| 144264 | 11914 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 611 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017360.2148981 | 2096331.9361692 | 37.737101828847 | -122.382440358603 | (37.737101828847, -122.382440358603) | 10 | 3 | 8 | 58 | 1 | |||
| 125895 | 11915 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 615 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017349.9174697 | 2096335.2897942 | 37.7371104684115 | -122.382476195099 | (37.7371104684115, -122.382476195099) | 10 | 3 | 8 | 58 | 1 | |||
| 9136 | 11920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 46481 | 11921 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1993 12:00:00 AM | 12 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | ||
| 107946 | 11924 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 110103 | 11919 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 124074 | 11925 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 128011 | 11917 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 149343 | 11923 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 184963 | 11918 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 87934 | 193985 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6017346.74675 | 2096395.76454 | 37.7372763448378 | -122.382491364312 | (37.7372763448378, -122.382491364312) | 10 | 3 | 8 | 58 | 1 | |||
| 64547 | 11916 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 619 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017340.3555719 | 2096338.4038747 | 37.7371184908548 | -122.382509471853 | (37.7371184908548, -122.382509471853) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );