Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63703 | 63703 | 126423 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 The Embarcadero | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6010525.17738 | 2122242.65614 | 37.8078667556044 | -122.40789889741899 | (37.8078667556044, -122.407898897419) | ||||
| 157404 | 157404 | 126412 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6000088.69563 | 2121303.7240299997 | 37.804698887418105 | -122.443949299933 | (37.8046988874181, -122.443949299933) | |||
| 130214 | 130214 | 249786 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 161 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6010943.97363 | 2121044.47732 | 37.8046002902368 | -122.406365062323 | (37.8046002902368, -122.406365062323) | |||
| 135517 | 135517 | 249787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 173 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6010924.52484 | 2121034.4207099997 | 37.8045715892836 | -122.40643165799 | (37.8045715892836, -122.40643165799) | |||
| 184674 | 184674 | 126416 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6006501.512069999 | 2121012.26216 | 37.804262323204895 | -122.421736358356 | (37.8042623232049, -122.421736358356) | ||||
| 59780 | 59780 | 126415 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 48 | 6006502.51226 | 2121001.4648 | 37.804232732814704 | -122.421732129727 | (37.8042327328147, -122.421732129727) | ||||
| 35115 | 35115 | 126414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006501.05561 | 2120998.5397099997 | 37.804224619123296 | -122.421736962694 | (37.8042246191233, -122.421736962694) | ||||
| 180433 | 180433 | 126428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 North Point St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002587.87385 | 2120898.67704 | 37.803728977572604 | -122.43527166598 | (37.8037289775726, -122.43527166598) | |||
| 171449 | 171449 | 249865 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 0ft | 6011350.601919999 | 2120707.91777 | 37.8036989186248 | -122.404934168095 | (37.8036989186248, -122.404934168095) | |||
| 38454 | 38454 | 249866 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011357.005059999 | 2120690.5710400003 | 37.8036516466761 | -122.404910787509 | (37.8036516466761, -122.404910787509) | |||
| 7419 | 7419 | 97731 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.803388983478605 | -122.42421815984501 | (37.8033889834786, -122.424218159845) | |
| 53440 | 53440 | 126417 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2745 Larkin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6006522.5634 | 2120685.74713 | 37.8033669833519 | -122.42164030356301 | (37.8033669833519, -122.421640303563) | ||||
| 179841 | 179841 | 249924 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6011171.36702 | 2120411.09017 | 37.802873882370896 | -122.405533505089 | (37.8028738823709, -122.405533505089) | |||
| 46680 | 46680 | 249916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011201.85513 | 2120410.11068 | 37.8028728976405 | -122.40542793096901 | (37.8028728976405, -122.405427930969) | |||
| 132547 | 132547 | 249917 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011197.83082 | 2120409.77535 | 37.802871751897 | -122.405441833595 | (37.802871751897, -122.405441833595) | |||
| 176394 | 176394 | 249925 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011155.36985 | 2120409.86411 | 37.802869621408796 | -122.40558877741002 | (37.8028696214088, -122.40558877741) | |||
| 176393 | 176393 | 249926 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011142.49576 | 2120408.96257 | 37.8028664261111 | -122.405633265077 | (37.8028664261111, -122.405633265077) | |||
| 46521 | 46521 | 249857 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 241 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6011495.8307 | 2120401.68392 | 37.8028661922948 | -122.404410025227 | (37.8028661922948, -122.404410025227) | |||
| 76467 | 76467 | 249921 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011183.71747 | 2120405.40754 | 37.8028589698347 | -122.40549036550101 | (37.8028589698347, -122.405490365501) | |||
| 156630 | 156630 | 249923 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 33 | Width 0ft | 6011163.06331 | 2120405.05222 | 37.8028568393309 | -122.40556181483801 | (37.8028568393309, -122.405561814838) | |||
| 170870 | 170870 | 249922 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011172.25119 | 2120397.10621 | 37.802835535282604 | -122.405529459923 | (37.8028355352826, -122.405529459923) | |||
| 74458 | 74458 | 249919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011190.2403 | 2120395.87946 | 37.8028331727783 | -122.405467121607 | (37.8028331727783, -122.405467121607) | |||
| 51446 | 51446 | 249918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011195.29362 | 2120394.33345 | 37.8028292103611 | -122.405449525493 | (37.8028292103611, -122.405449525493) | |||
| 24155 | 24155 | 249927 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011132.35015 | 2120388.99651 | 37.8028110368738 | -122.40566696715099 | (37.8028110368738, -122.405666967151) | |||
| 67041 | 67041 | 249828 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | Width 0ft | 6011201.53996 | 2120373.03951 | 37.802771091668205 | -122.405426409314 | (37.8027710916682, -122.405426409314) | |||
| 188593 | 188593 | 249830 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 0ft | 6011191.13425 | 2120368.12029 | 37.8027570028825 | -122.405462071912 | (37.8027570028825, -122.405462071912) | |||
| 181873 | 181873 | 250227 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 312 Filbert St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011220.88869 | 2120048.61475 | 37.8018813824768 | -122.40533659221902 | (37.8018813824768, -122.405336592219) | |||
| 25946 | 25946 | 126425 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6011438.821769999 | 2120037.4711599997 | 37.8018629670555 | -122.40458165273701 | (37.8018629670555, -122.404581652737) | |||
| 39759 | 39759 | 126424 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011439.456040001 | 2120033.94187 | 37.801853311934096 | -122.404579209268 | (37.8018533119341, -122.404579209268) | |||
| 182295 | 182295 | 249826 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 391 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | Width 0ft | 6011015.83097 | 2120024.81975 | 37.8018045803872 | -122.406044514263 | (37.8018045803872, -122.406044514263) | |||
| 140619 | 140619 | 95331 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 390X Filbert St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 60877 | 60877 | 250194 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 0ft | 6011773.11718 | 2119954.14642 | 37.8016528548612 | -122.403418962409 | (37.8016528548612, -122.403418962409) | |||
| 150704 | 150704 | 126418 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2237 Hyde St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6007090.48557 | 2119992.12642 | 37.8014944842289 | -122.41962574124099 | (37.8014944842289, -122.419625741241) | ||||
| 72912 | 72912 | 126411 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3398 Pierce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 6001324.1548 | 2120088.88928 | 37.8014336702784 | -122.439586737243 | (37.8014336702784, -122.439586737243) | |||
| 168070 | 168070 | 250204 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 206 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011843.5346800005 | 2119802.5611900003 | 37.8012405714539 | -122.403164615272 | (37.8012405714539, -122.403164615272) | |||
| 46935 | 46935 | 250205 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 212 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011817.68969 | 2119792.01106 | 37.8012101599872 | -122.4032533082 | (37.8012101599872, -122.4032533082) | |||
| 156317 | 156317 | 250196 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011857.70339 | 2119785.90004 | 37.801195615236395 | -122.403114412425 | (37.8011956152364, -122.403114412425) | |||
| 186554 | 186554 | 250195 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011875.28376 | 2119779.56963 | 37.8011792152183 | -122.40305313080401 | (37.8011792152183, -122.403053130804) | |||
| 60552 | 60552 | 250197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011839.72623 | 2119769.92251 | 37.8011507408769 | -122.403175497057 | (37.8011507408769, -122.403175497057) | |||
| 46469 | 46469 | 250199 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011821.07725 | 2119768.34547 | 37.8011453692141 | -122.403239919993 | (37.8011453692141, -122.403239919993) | |||
| 139657 | 139657 | 117644 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1111X SANSOME ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x30 | 6011937.0 | 2119613.0 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | ||||
| 52668 | 52668 | 126427 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3130 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5999056.00761 | 2119563.15995 | 37.799860807300895 | -122.447397647786 | (37.7998608073009, -122.447397647786) | |||
| 39035 | 39035 | 126426 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3130 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5999057.94156 | 2119543.59601 | 37.7998072004939 | -122.44738954670099 | (37.7998072004939, -122.447389546701) | |||
| 25143 | 25143 | 126422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 71 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 6008381.99212 | 2119124.63634 | 37.7991852374601 | -122.415095094385 | (37.7991852374601, -122.415095094385) | ||||
| 144625 | 144625 | 13284 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2576 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6000068.810330001 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | ||
| 84088 | 84088 | 103516 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 980 Green St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6008298.0 | 2118971.0 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | |||||
| 70384 | 70384 | 126420 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 957 Green St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6008389.07771 | 2118963.83905 | 37.798744126289 | -122.415059188055 | (37.798744126289, -122.415059188055) | ||||
| 28068 | 28068 | 126421 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 957 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 6008400.762999999 | 2118955.03362 | 37.7987206054154 | -122.415018129477 | (37.7987206054154, -122.415018129477) | ||||
| 157577 | 157577 | 126419 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 956 Vallejo St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6008811.64334 | 2118703.9569599996 | 37.7980542914263 | -122.413578579305 | (37.7980542914263, -122.413578579305) | ||||
| 124625 | 124625 | 111763 | Landmark tree 9 | Cupressus macrocarpa :: Monterey Cypress 47 | 2626 Vallejo St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001000.6 | 2117623.4 | 37.7946456667745 | -122.440529445268 | (37.7946456667745, -122.440529445268) | |||||
| 105567 | 105567 | 126413 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Vallejo St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001029.975 | 2117557.6331599997 | 37.7944667608931 | -122.440423085162 | (37.7944667608931, -122.440423085162) | |||
| 7193 | 7193 | 110906 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 2891 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775210 | 5999784.0596900005 | 2117390.4095799997 | 37.7939365889551 | -122.44472206489799 | (37.7939365889551, -122.444722064898) | |
| 42862 | 42862 | 249675 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Baker St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 49 | 5999731.49147 | 2117154.85585 | 37.7932868206735 | -122.444887014927 | (37.7932868206735, -122.444887014927) | ||||
| 137161 | 137161 | 249710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2901 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999603.39885 | 2116998.0274799997 | 37.7928489002955 | -122.44531894132099 | (37.7928489002955, -122.445318941321) | ||||
| 35815 | 35815 | 249711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2901 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5999592.84448 | 2116997.53125 | 37.7928469352999 | -122.44535542411501 | (37.7928469352999, -122.445355424115) | ||||
| 187617 | 187617 | 249716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2975 Broadway | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5999444.23089 | 2116975.8695799997 | 37.7927789735145 | -122.44586807365 | (37.7927789735145, -122.44586807365) | ||||
| 3981 | 3981 | 18927 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2691 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001960.28459 | 2115686.06098 | 37.7893808348161 | -122.437070045665 | (37.7893808348161, -122.437070045665) | |||
| 8584 | 8584 | 2988 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2266X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003528.90719 | 2115622.95537 | 37.7892965998021 | -122.431638286196 | (37.7892965998021, -122.431638286196) | |||
| 135127 | 135127 | 122185 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 14th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 67 | 5991491.733030001 | 2115080.7655 | 37.787118258390606 | -122.473245521028 | (37.7871182583906, -122.473245521028) | ||||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 180025 | 180025 | 250698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 877 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5985618.29441 | 2114950.69693 | 37.78641929175679 | -122.49355644897601 | (37.7864192917568, -122.493556448976) | |||
| 176606 | 176606 | 250697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 877 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5985607.20317 | 2114948.81702 | 37.7864134812469 | -122.493594682746 | (37.7864134812469, -122.493594682746) | |||
| 53358 | 53358 | 250696 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 877 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5985597.38635 | 2114946.90963 | 37.786407669826495 | -122.493628505377 | (37.7864076698265, -122.493628505377) | |||
| 3112 | 3112 | 253318 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3113 | 3113 | 253332 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3115 | 3115 | 253329 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3116 | 3116 | 253328 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3119 | 3119 | 253313 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3120 | 3120 | 253308 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3121 | 3121 | 253303 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3122 | 3122 | 253323 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3123 | 3123 | 253306 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3125 | 3125 | 253309 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3127 | 3127 | 253316 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3128 | 3128 | 253330 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3129 | 3129 | 253317 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3130 | 3130 | 253319 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3131 | 3131 | 253310 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3133 | 3133 | 253333 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3135 | 3135 | 253335 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3136 | 3136 | 253320 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3139 | 3139 | 253322 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3140 | 3140 | 253334 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3141 | 3141 | 253311 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3143 | 3143 | 253336 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3145 | 3145 | 253304 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3146 | 3146 | 253314 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3148 | 3148 | 253327 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3150 | 3150 | 253331 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3151 | 3151 | 253312 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3152 | 3152 | 253307 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3153 | 3153 | 253315 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3155 | 3155 | 253305 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3156 | 3156 | 253321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 38782 | 38782 | 139327 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6005396.3086 | 2114138.3218 | 37.785325835852795 | -122.425071614426 | (37.7853258358528, -122.425071614426) | |||
| 54250 | 54250 | 139328 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6005318.1985 | 2114131.1202 | 37.7853016493854 | -122.42534133927 | (37.7853016493854, -122.42534133927) | |||
| 72905 | 72905 | 139357 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6005019.8844 | 2114088.1873 | 37.785166908017004 | -122.426370358064 | (37.785166908017, -122.426370358064) | |||
| 110409 | 110409 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070@ 32nd Ave California St | 4 | Front Yard : 25 | Tree 1 | Private 1 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 6794 | 6794 | 8396 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004125.3824 | 2113965.9717 | 37.7847807304874 | -122.429456338379 | (37.7847807304874, -122.429456338379) |
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");