Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38989 | 38989 | 120722 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5989381.54871 | 2112550.53538 | 37.780048547094104 | -122.48036094165 | (37.7800485470941, -122.48036094165) | |||
| 166107 | 166107 | 120721 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 21st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5989381.94268 | 2112569.1505299998 | 37.7800996819916 | -122.480360941669 | (37.7800996819916, -122.480360941669) | |||
| 26444 | 26444 | 120723 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5989382.65393 | 2112535.36051 | 37.7800069453638 | -122.48035600720101 | (37.7800069453638, -122.480356007201) | |||
| 147851 | 147851 | 120725 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5989383.55295 | 2112495.67022 | 37.779898019151396 | -122.480349991184 | (37.7798980191514, -122.480349991184) | |||
| 79617 | 79617 | 67433 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 773 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/1992 12:00:00 AM | 12 | 3x3 | Permit Number 30935 | 5989424.8968400005 | 2110087.73427 | 37.7732888974355 | -122.48003069671002 | (37.7732888974355, -122.48003069671) | |
| 28490 | 28490 | 65126 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 222 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 16 | Permit Number 27096 | 5989645.84476 | 2113859.10793 | 37.783656876429205 | -122.479542401246 | (37.7836568764292, -122.479542401246) | |
| 170356 | 170356 | 120748 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5989653.18762 | 2113687.18081 | 37.7831852392841 | -122.47950441508199 | (37.7831852392841, -122.479504415082) | |||
| 156548 | 156548 | 120806 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 447 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5989655.6717 | 2112300.70253 | 37.7793785014336 | -122.479394354392 | (37.7793785014336, -122.479394354392) | |||
| 154433 | 154433 | 120743 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5989700.72166 | 2112353.32994 | 37.7795256181794 | -122.479242360349 | (37.7795256181794, -122.479242360349) | |||
| 60220 | 60220 | 120742 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 446 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5989702.74766 | 2112309.29538 | 37.7794048291969 | -122.479232129463 | (37.7794048291969, -122.479232129463) | |||
| 42796 | 42796 | 61126 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 163 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/1983 12:00:00 AM | 17 | Permit Number 20977 | 5989893.69249 | 2114276.00757 | 37.784815959613105 | -122.478715451716 | (37.7848159596131, -122.478715451716) | ||
| 171719 | 171719 | 120841 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 163 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5989894.17074 | 2114256.47042 | 37.784762343849 | -122.47871236781602 | (37.784762343849, -122.478712367816) | |||
| 156196 | 156196 | 72075 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 177 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 16 | 5989896.15607 | 2114192.3004400004 | 37.784586266356605 | -122.47870080468799 | (37.7845862663566, -122.478700804688) | ||
| 43583 | 43583 | 61507 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 195 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1984 12:00:00 AM | 16 | Permit Number 21462 | 5989900.42739 | 2114099.23547 | 37.784330984044 | -122.478679219068 | (37.784330984044, -122.478679219068) | |
| 183243 | 183243 | 38442 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 637 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | 11 | Permit Number 40467 | 5990011.82124 | 2111018.42717 | 37.7758784077598 | -122.47806852368299 | (37.7758784077598, -122.478068523683) | ||
| 173565 | 173565 | 67437 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2745 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1992 12:00:00 AM | 10 | Permit Number 30939 | 5990089.80693 | 2111937.4768 | 37.7784063904389 | -122.477865954496 | (37.7784063904389, -122.477865954496) | |
| 44364 | 44364 | 56410 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 18 | Permit Number 12570 | 5990190.56265 | 2114683.73374 | 37.78595269404529 | -122.477718203176 | (37.7859526940453, -122.477718203176) | ||
| 188379 | 188379 | 122058 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5990191.66474 | 2114668.45777 | 37.785910814474704 | -122.477713273252 | (37.7859108144747, -122.477713273252) | |||
| 133499 | 133499 | 122057 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5990191.690830001 | 2114652.84953 | 37.785867960139605 | -122.47771204165701 | (37.7858679601396, -122.477712041657) | |||
| 166450 | 166450 | 56411 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 118 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 14 | Permit Number 12571 | 5990241.585519999 | 2114569.27523 | 37.785641383965704 | -122.47753331104799 | (37.7856413839657, -122.477533311048) | ||
| 48123 | 48123 | 56413 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 138 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 16 | Permit Number 12573 | 5990244.30778 | 2114440.0519 | 37.785286730870794 | -122.47751444461001 | (37.7852867308708, -122.47751444461) | ||
| 172343 | 172343 | 121877 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 154 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990249.428180001 | 2114351.7508400003 | 37.785044578006 | -122.47749027366001 | (37.785044578006, -122.47749027366) | |||
| 58136 | 58136 | 121878 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 154 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990249.59574 | 2114331.80171 | 37.784989813002 | -122.47748823539 | (37.784989813002, -122.47748823539) | |||
| 38203 | 38203 | 122071 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 149 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5990509.59374 | 2114406.22448 | 37.7852092405425 | -122.476594173599 | (37.7852092405425, -122.476594173599) | |||
| 135060 | 135060 | 114783 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400x 17th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5990623.70792 | 2112609.74161 | 37.780283215935995 | -122.47606812287901 | (37.780283215936, -122.476068122879) | |||
| 37722 | 37722 | 114782 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400x 17th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5990625.810959999 | 2112587.7910599997 | 37.780223067743705 | -122.47605924392599 | (37.7802230677437, -122.476059243926) | |||
| 62533 | 62533 | 114781 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400x 17th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5990626.196880001 | 2112571.35329 | 37.78017795655229 | -122.476056707974 | (37.7801779565523, -122.476056707974) | |||
| 42514 | 42514 | 114780 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400x 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5990626.48286 | 2112550.17107 | 37.7801198126181 | -122.476054171145 | (37.7801198126181, -122.476054171145) | |||
| 102321 | 102321 | 114779 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400x 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5990628.601319999 | 2112528.95038 | 37.7800616693108 | -122.476045292199 | (37.7800616693108, -122.476045292199) | |||
| 162985 | 162985 | 37621 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 652 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 9 | Permit Number 40045 | 5990684.25041 | 2110944.9996700003 | 37.775715803431204 | -122.47573707933998 | (37.7757158034312, -122.47573707934) | |
| 33745 | 33745 | 218939 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990690.45077 | 2102431.07242 | 37.752339204007896 | -122.475093970812 | (37.7523392040079, -122.475093970812) | |||
| 52435 | 52435 | 218938 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990704.08635 | 2102431.91459 | 37.7523423066512 | -122.47504687873399 | (37.7523423066512, -122.475046878734) | |||
| 160593 | 160593 | 218937 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990714.31106 | 2102432.45211 | 37.752344375112294 | -122.475011559633 | (37.7523443751123, -122.475011559633) | |||
| 130441 | 130441 | 218936 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990723.76369 | 2102432.25259 | 37.752344375099895 | -122.474978856684 | (37.7523443750999, -122.474978856684) | |||
| 159443 | 159443 | 218935 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990744.94543 | 2102432.18219 | 37.7523454093323 | -122.474905602418 | (37.7523454093323, -122.474905602418) | |||
| 147770 | 147770 | 218934 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990760.83366 | 2102432.22352 | 37.7523464435445 | -122.47485066193 | (37.7523464435445, -122.47485066193) | |||
| 71918 | 71918 | 218849 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1239 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5990770.51831 | 2106948.92525 | 37.764748668340204 | -122.47514687163401 | (37.7647486683402, -122.475146871634) | |||
| 49799 | 49799 | 218848 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1235 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5990773.02896 | 2106968.67991 | 37.7648030548431 | -122.475139630284 | (37.7648030548431, -122.475139630284) | |||
| 51387 | 51387 | 218933 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990778.98274 | 2102431.84048 | 37.7523464435342 | -122.474787872164 | (37.7523464435342, -122.474787872164) | |||
| 147375 | 147375 | 122122 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 119 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990813.76688 | 2114604.18262 | 37.785770415878 | -122.47555629875099 | (37.785770415878, -122.475556298751) | |||
| 136848 | 136848 | 122121 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 123 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990815.8435 | 2114575.11804 | 37.785690733033704 | -122.47554699132799 | (37.7856907330337, -122.475546991328) | |||
| 166580 | 166580 | 122119 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 135 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990817.9680699995 | 2114505.86962 | 37.7855007193525 | -122.475534582891 | (37.7855007193525, -122.475534582891) | |||
| 186636 | 186636 | 122118 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 135 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5990818.11008 | 2114491.3562 | 37.7854608777817 | -122.47553303148399 | (37.7854608777817, -122.475533031484) | |||
| 59044 | 59044 | 122113 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 217 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5990837.78184 | 2113925.92062 | 37.7839094894818 | -122.475423675099 | (37.7839094894818, -122.475423675099) | |||
| 186243 | 186243 | 121955 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 108 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990858.4057599995 | 2114664.86399 | 37.7859396176051 | -122.475406294483 | (37.7859396176051, -122.475406294483) | |||
| 157534 | 157534 | 218847 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1701 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5990882.44412 | 2103778.75741 | 37.7560507177693 | -122.474528378177 | (37.7560507177693, -122.474528378177) | |||
| 42451 | 42451 | 121943 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990883.68748 | 2113923.66953 | 37.7839059694824 | -122.475264695755 | (37.7839059694824, -122.475264695755) | |||
| 56345 | 56345 | 121941 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 226 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5990887.38464 | 2113875.80217 | 37.7837747533085 | -122.475248409295 | (37.7837747533085, -122.475248409295) | |||
| 179686 | 179686 | 218845 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5990904.30374 | 2104377.4654200003 | 37.757695878174296 | -122.474496472061 | (37.7576958781743, -122.474496472061) | |||
| 153511 | 153511 | 218846 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1754 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5990933.5114 | 2103467.66725 | 37.7551995049594 | -122.474329072232 | (37.7551995049594, -122.474329072232) | |||
| 104015 | 104015 | 12704 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1424 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5991031.65731 | 2114791.36704 | 37.786297000827496 | -122.47481613459 | (37.7862970008275, -122.47481613459) | |||
| 188186 | 188186 | 218852 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1346 16th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 5991155.44082 | 2106257.8165599997 | 37.7628733705378 | -122.473765117276 | (37.7628733705378, -122.473765117276) | |||
| 166518 | 166518 | 122150 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991162.36931 | 2113951.28198 | 37.7839979344917 | -122.47430258478701 | (37.7839979344917, -122.474302584787) | |||
| 151889 | 151889 | 121973 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 122 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991186.3211 | 2114588.93026 | 37.7857501270876 | -122.474266265916 | (37.7857501270876, -122.474266265916) | |||
| 159370 | 159370 | 121975 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 150 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 5991193.7248599995 | 2114419.2361 | 37.785284623037 | -122.47422826448499 | (37.785284623037, -122.474228264485) | |||
| 160646 | 160646 | 61531 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 351 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | 13 | Permit Number 21488 | 5991194.2011400005 | 2113043.41955 | 37.781507039562605 | -122.474126195206 | (37.7815070395626, -122.474126195206) | |
| 152217 | 152217 | 61530 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 355 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | 15 | Permit Number 21487 | 5991196.23981 | 2113018.95221 | 37.7814399770979 | -122.474117356675 | (37.7814399770979, -122.474117356675) | |
| 53467 | 53467 | 122156 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 395 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 5991202.90026 | 2112793.73505 | 37.7808219787339 | -122.47407787751601 | (37.7808219787339, -122.474077877516) | |||
| 164368 | 164368 | 122155 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 395 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5991203.74154 | 2112817.46331 | 37.7808871787256 | -122.474076698938 | (37.7808871787256, -122.474076698938) | |||
| 43313 | 43313 | 218850 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1885 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5991230.38459 | 2102597.67883 | 37.7528279396825 | -122.473238960832 | (37.7528279396825, -122.473238960832) | |||
| 119087 | 119087 | 61529 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 362 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | 16 | 4x4 | Permit Number 21486 | 5991243.47116 | 2112971.47126 | 37.7813123434093 | -122.473950495525 | (37.7813123434093, -122.473950495525) |
| 153115 | 153115 | 61528 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 366 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | 11 | Permit Number 21485 | 5991243.78847 | 2112949.32705 | 37.78125155989721 | -122.473947781715 | (37.7812515598972, -122.473947781715) | |
| 143578 | 143578 | 12694 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1343 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X4 | 5991268.23747 | 2114744.30152 | 37.786181478596795 | -122.473994201246 | (37.7861814785968, -122.473994201246) | |||
| 113105 | 113105 | 12695 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1343 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X4 | 5991281.0782699995 | 2114745.58253 | 37.7861857396788 | -122.47394986939501 | (37.7861857396788, -122.473949869395) | |||
| 117921 | 117921 | 12688 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4x4 | 5991295.09423 | 2114745.11465 | 37.7861852668459 | -122.473901344195 | (37.7861852668459, -122.473901344195) | |||
| 137085 | 137085 | 218942 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 50 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5991391.23591 | 2104668.18352 | 37.7585223137837 | -122.47283367503401 | (37.7585223137837, -122.472833675034) | |||
| 49048 | 49048 | 218943 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5991395.44345 | 2104661.60275 | 37.7585044883033 | -122.472818643771 | (37.7585044883033, -122.472818643771) | |||
| 96029 | 96029 | 122025 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1325 Cabrillo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991485.32082 | 2110624.5167900003 | 37.7748822545895 | -122.47294262886801 | (37.7748822545895, -122.472942628868) | |||
| 149902 | 149902 | 116808 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Cabrillo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 21 | 5991501.56814 | 2110682.77742 | 37.775043163026 | -122.472890675729 | (37.775043163026, -122.472890675729) | |||
| 158775 | 158775 | 116807 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 18 | 5991517.51239 | 2110683.05155 | 37.7750448387434 | -122.472835541621 | (37.7750448387434, -122.472835541621) | |||
| 154152 | 154152 | 59172 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 363 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1980 12:00:00 AM | 21 | Permit Number 18485 | 5991523.87505 | 2112998.2366400003 | 37.781402071615794 | -122.472982397304 | (37.7814020716158, -122.472982397304) | ||
| 177583 | 177583 | 122026 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1305 Cabrillo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991528.421080001 | 2110626.20235 | 37.7748893778088 | -122.472793660371 | (37.7748893778088, -122.472793660371) | |||
| 28159 | 28159 | 116806 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 5991537.4363400005 | 2110683.08947 | 37.7750460962456 | -122.472766623766 | (37.7750460962456, -122.472766623766) | |||
| 160791 | 160791 | 122206 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 473 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5991553.631569999 | 2112231.7293700003 | 37.7792991759369 | -122.472823547301 | (37.7792991759369, -122.472823547301) | |||
| 179747 | 179747 | 122207 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 473 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5991555.73025 | 2112210.97571 | 37.7792423135691 | -122.47281477347299 | (37.7792423135691, -122.472814773473) | |||
| 58854 | 58854 | 122027 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1305 Cabrillo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5991558.6277 | 2110626.93895 | 37.7748931489004 | -122.47268922403299 | (37.7748931489004, -122.472689224033) | |||
| 96487 | 96487 | 116805 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/2016 12:00:00 AM | 3 | Permit Number 778212 | 5991565.06136 | 2110684.94877 | 37.7750528005049 | -122.472671199313 | (37.7750528005049, -122.472671199313) | |
| 68135 | 68135 | 67423 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 13 | Permit Number 30925 | 5991580.37693 | 2110684.47332 | 37.7750523815864 | -122.47261818525 | (37.7750523815864, -122.47261818525) | |
| 65507 | 65507 | 67424 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1305 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 8 | Permit Number 30926 | 5991581.6444 | 2110628.2851299997 | 37.774898177463605 | -122.47260970334801 | (37.7748981774636, -122.472609703348) | |
| 135588 | 135588 | 122222 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 705 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5991614.67987 | 2110611.24768 | 37.7748533094179 | -122.47249418541 | (37.7748533094179, -122.47249418541) | |||
| 53448 | 53448 | 122223 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 705 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991615.01805 | 2110596.2582 | 37.7748121719541 | -122.47249192255501 | (37.7748121719541, -122.472491922555) | |||
| 178045 | 178045 | 218941 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1577 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991703.50942 | 2104618.1334 | 37.7584029620513 | -122.471750055828 | (37.7584029620513, -122.471750055828) | |||
| 168509 | 168509 | 218940 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1577 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991705.10597 | 2104613.0079099997 | 37.758388981180296 | -122.47174416077699 | (37.7583889811803, -122.471744160777) | |||
| 157026 | 157026 | 218857 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1250 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5991792.482469999 | 2106755.85942 | 37.7642777392596 | -122.471598127965 | (37.7642777392596, -122.471598127965) | |||
| 166748 | 166748 | 218858 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1250 14th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5991793.25678 | 2106772.55456 | 37.7643236244672 | -122.471596666553 | (37.7643236244672, -122.471596666553) | |||
| 170484 | 170484 | 124250 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1154 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5991881.2682300005 | 2113461.40144 | 37.782694479479204 | -122.47177976693001 | (37.7826944794792, -122.47177976693) | |||
| 185407 | 185407 | 124248 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1146 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5991941.716569999 | 2113466.13724 | 37.7827109799958 | -122.471570988584 | (37.7827109799958, -122.471570988584) | |||
| 132262 | 132262 | 124247 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1136 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5991950.96997 | 2113462.66432 | 37.782701979646895 | -122.471538722904 | (37.7827019796469, -122.471538722904) | |||
| 155304 | 155304 | 124246 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1136 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5991965.86819 | 2113466.72111 | 37.7827139803602 | -122.471487477584 | (37.7827139803602, -122.471487477584) | |||
| 163505 | 163505 | 124245 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1130 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 7ft | 5991975.1446 | 2113464.3401900004 | 37.7827079796513 | -122.47145521190399 | (37.7827079796513, -122.471455211904) | |||
| 188358 | 188358 | 124244 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1130 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 7ft | 5991991.6420599995 | 2113466.17808 | 37.7827139803523 | -122.47139827219802 | (37.7827139803523, -122.471398272198) | |||
| 23441 | 23441 | 218859 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1251 Funston Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5992039.2755 | 2106763.98784 | 37.7643143326521 | -122.470745140778 | (37.7643143326521, -122.470745140778) | |||
| 181140 | 181140 | 218860 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1251 Funston Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5992040.08055 | 2106742.72997 | 37.764256010743296 | -122.470740807837 | (37.7642560107433, -122.470740807837) | |||
| 178693 | 178693 | 66542 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 119 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1991 12:00:00 AM | 12 | Permit Number 29719 | 5992085.10344 | 2114622.06369 | 37.7858931297771 | -122.471159177486 | (37.7858931297771, -122.471159177486) | ||
| 160663 | 160663 | 122915 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 206 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992152.05135 | 2114065.8903200002 | 37.7843699032584 | -122.47088702929199 | (37.7843699032584, -122.470887029292) | |||
| 53436 | 53436 | 122916 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 206 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992152.69759 | 2114024.4917200003 | 37.784256271481105 | -122.47088177684499 | (37.7842562714811, -122.470881776845) | |||
| 60609 | 60609 | 122917 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 206 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992154.25615 | 2114008.3963099997 | 37.7842121680544 | -122.470875211967 | (37.7842121680544, -122.470875211967) | |||
| 145273 | 145273 | 107194 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5992162.38995 | 2113763.8826599997 | 37.783541271265605 | -122.470829255057 | (37.7835412712656, -122.470829255057) | |||
| 22985 | 22985 | 59157 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 543 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1980 12:00:00 AM | 16 | Permit Number 18466 | 5992190.16655 | 2111724.33982 | 37.7779428509149 | -122.470584562939 | (37.7779428509149, -122.470584562939) | ||
| 180690 | 180690 | 123082 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 751 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5992235.94824 | 2110331.44477 | 37.7741209858965 | -122.470324727057 | (37.7741209858965, -122.470324727057) |
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");