Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 692 | 692 | 176334 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6012223.87562 | 2087782.5469900002 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | ||||
| 701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
| 24579 | 24579 | 247929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6010384.7561099995 | 2098766.60945 | 37.743399135274295 | -122.40672932282301 | (37.7433991352743, -122.406729322823) | ||||
| 25962 | 25962 | 209036 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 427 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6000750.14831 | 2095370.65935 | 37.7335308771479 | -122.439799837889 | (37.7335308771479, -122.439799837889) | ||||
| 25982 | 25982 | 247919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010242.48982 | 2098715.3752200003 | 37.743250496220895 | -122.40721763491001 | (37.7432504962209, -122.40721763491) | ||||
| 26944 | 26944 | 224225 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004862.254919999 | 2096710.90423 | 37.737444098063 | -122.42567845649201 | (37.737444098063, -122.425678456492) | ||||
| 27200 | 27200 | 209021 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6000790.06178 | 2095561.6998400001 | 37.7340577017886 | -122.43967553722 | (37.7340577017886, -122.43967553722) | ||||
| 28853 | 28853 | 209017 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 25 | 6000774.79116 | 2095519.5815700002 | 37.7339411856303 | -122.43972531378401 | (37.7339411856303, -122.439725313784) | ||||
| 30032 | 30032 | 247924 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010297.695230001 | 2098727.78354 | 37.7432876562154 | -122.40702762254499 | (37.7432876562154, -122.407027622545) | ||||
| 30144 | 30144 | 209022 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 6000785.93499 | 2095562.5681900003 | 37.7340598511869 | -122.43968986701401 | (37.7340598511869, -122.439689867014) | ||||
| 31541 | 31541 | 247930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | ||||
| 32543 | 32543 | 176345 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | 6008420.88631 | 2088405.51015 | 37.7148397004654 | -122.412787554496 | (37.7148397004654, -122.412787554496) | ||||
| 34595 | 34595 | 209040 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000753.71672 | 2095344.13435 | 37.7334582487793 | -122.43978559983 | (37.7334582487793, -122.43978559983) | ||||
| 35228 | 35228 | 209038 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6000746.779019999 | 2095349.3205099998 | 37.7334720938659 | -122.439809957065 | (37.7334720938659, -122.439809957065) | ||||
| 35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
| 36668 | 36668 | 209041 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000751.4342 | 2095340.2355900002 | 37.7334474137664 | -122.43979321169901 | (37.7334474137664, -122.439793211699) | ||||
| 37470 | 37470 | 176346 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | ||||
| 39683 | 39683 | 191728 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013472.8835 | 2102915.30193 | 37.754962860065 | -122.39634201017999 | (37.754962860065, -122.39634201018) | ||||
| 41213 | 41213 | 224227 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004843.36157 | 2096707.31423 | 37.7374331731056 | -122.425743524245 | (37.7374331731056, -122.425743524245) | ||||
| 41325 | 41325 | 224244 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004777.47133 | 2096641.4622900002 | 37.73724863492671 | -122.425966651467 | (37.7372486349267, -122.425966651467) | ||||
| 42046 | 42046 | 209030 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6000755.13076 | 2095576.9220900002 | 37.7340975102859 | -122.439797395328 | (37.7340975102859, -122.439797395328) | ||||
| 42995 | 42995 | 52091 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 300 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2005 12:00:00 AM | Permit Number 48287 | 5993176.51233561 | 2099718.04340733 | 37.745033690620396 | -122.46629968747601 | (37.7450336906204, -122.466299687476) | |||
| 43077 | 43077 | 191722 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6014479.640380001 | 2101959.5389 | 37.752394509601494 | -122.392793471535 | (37.7523945096015, -122.392793471535) | ||||
| 43267 | 43267 | 121204 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 52 | 6008473.20212 | 2119153.5676 | 37.799269800719294 | -122.41478152415002 | (37.7992698007193, -122.41478152415) | ||||
| 43329 | 43329 | 111546 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 24 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 15 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 43564 | 43564 | 207757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5994806.26925 | 2105291.62903 | 37.760431240817795 | -122.46106822873399 | (37.7604312408178, -122.461068228734) | ||||
| 45082 | 45082 | 209042 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6000746.1619 | 2095340.78312 | 37.7334486170489 | -122.439811478728 | (37.7334486170489, -122.439811478728) | ||||
| 45967 | 45967 | 209014 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6000787.79858 | 2095464.06576 | 37.733789492485 | -122.43967636459601 | (37.733789492485, -122.439676364596) | ||||
| 46194 | 46194 | 247925 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010304.27631 | 2098731.76841 | 37.743298966077795 | -122.407005147582 | (37.7432989660778, -122.407005147582) | ||||
| 48059 | 48059 | 43994 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | ||
| 48153 | 48153 | 209013 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6000780.48794 | 2095392.50815 | 37.7335925958074 | -122.439696511209 | (37.7335925958074, -122.439696511209) | ||||
| 48548 | 48548 | 65198 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 371 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 34 | Permit Number 27183 | 6003158.74485 | 2091706.4873099998 | 37.7236066919673 | -122.431211180179 | (37.7236066919673, -122.431211180179) | |
| 48572 | 48572 | 224238 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004809.6017 | 2096680.0059200001 | 37.737356282853 | -122.425858304718 | (37.737356282853, -122.425858304718) | ||||
| 50757 | 50757 | 191735 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010009.096969999 | 2107534.42743 | 37.7674525780981 | -122.408646656734 | (37.7674525780981, -122.408646656734) | ||||
| 50832 | 50832 | 224239 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6004801.05123 | 2096666.83115 | 37.7373196246961 | -122.425886930149 | (37.7373196246961, -122.425886930149) | ||||
| 51062 | 51062 | 224245 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 160 Coso Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 6007485.6356 | 2099587.10163 | 37.7454893881214 | -122.41681188667201 | (37.7454893881214, -122.416811886672) | ||||
| 54108 | 54108 | 176348 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5989603.79735 | 2090546.09261 | 37.7196430676648 | -122.47798295295799 | (37.7196430676648, -122.477982952958) | ||||
| 55507 | 55507 | 191724 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 6011608.5229400005 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | ||||
| 56581 | 56581 | 209009 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6000785.2821 | 2095342.6683900002 | 37.7334560202787 | -122.439676364582 | (37.7334560202787, -122.439676364582) | ||||
| 56692 | 56692 | 247937 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1149 Esmeralda Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010236.06133 | 2098747.86868 | 37.7433393564296 | -122.40724215312599 | (37.7433393564296, -122.407242153126) | ||||
| 57024 | 57024 | 209025 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6000769.58789 | 2095570.4874200001 | 37.7340806650885 | -122.43974695145599 | (37.7340806650885, -122.439746951456) | ||||
| 59219 | 59219 | 247999 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 346 Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6009771.618319999 | 2099231.70155 | 37.744641851750295 | -122.40888221345101 | (37.7446418517503, -122.408882213451) | ||||
| 59867 | 59867 | 247926 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010312.05046 | 2098736.31721 | 37.743311891127604 | -122.406978587005 | (37.7433118911276, -122.406978587005) | ||||
| 61204 | 61204 | 224222 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004869.898159999 | 2096730.73115 | 37.7374989702074 | -122.42565344095199 | (37.7374989702074, -122.425653440952) | ||||
| 61471 | 61471 | 224223 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6004855.412690001 | 2096718.43509 | 37.7374643894683 | -122.425702649156 | (37.7374643894683, -122.425702649156) | ||||
| 61748 | 61748 | 224243 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004771.77471 | 2096643.7523700001 | 37.737254601020005 | -122.425986510284 | (37.73725460102, -122.425986510284) | ||||
| 62115 | 62115 | 247923 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.40705826963699 | (37.7432925026595, -122.407058269637) | ||||
| 63043 | 63043 | 209019 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000764.3171 | 2095528.5679900001 | 37.7339652640682 | -122.43976216978201 | (37.7339652640682, -122.439762169782) | ||||
| 63465 | 63465 | 224224 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004854.036780001 | 2096713.3958700001 | 37.737450475157296 | -122.42570704776199 | (37.7374504751573, -122.425707047762) | ||||
| 63720 | 63720 | 224229 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004833.29966 | 2096702.67223 | 37.7374198586269 | -122.425777982686 | (37.7374198586269, -122.425777982686) | ||||
| 63741 | 63741 | 246757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6009117.20748 | 2098899.99025 | 37.7436943673943 | -122.41112161978998 | (37.7436943673943, -122.41112161979) | ||||
| 63892 | 63892 | 224237 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004814.56562 | 2096681.78705 | 37.7373614539559 | -122.425841268876 | (37.7373614539559, -122.425841268876) | ||||
| 66266 | 66266 | 191737 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 200 Helena St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010885.73151 | 2096220.33708 | 37.736435634280895 | -122.40481783988199 | (37.7364356342809, -122.404817839882) | ||||
| 68974 | 68974 | 224228 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004840.27089 | 2096702.3446900002 | 37.7374193532181 | -122.425753856564 | (37.7374193532181, -122.425753856564) | ||||
| 70101 | 70101 | 247851 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 152 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 79 | 6009070.86749 | 2098234.59559 | 37.7418647407582 | -122.411234858803 | (37.7418647407582, -122.411234858803) | ||||
| 70209 | 70209 | 191734 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009976.801940001 | 2107534.39117 | 37.767450669731105 | -122.40875835881201 | (37.7674506697311, -122.408758358812) | ||||
| 70884 | 70884 | 247927 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6010318.55961 | 2098736.7728 | 37.7433135063186 | -122.40695611204501 | (37.7433135063186, -122.406956112045) | ||||
| 71482 | 71482 | 176344 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008453.924319999 | 2088393.6006200002 | 37.714808853708604 | -122.41267251952299 | (37.7148088537086, -122.412672519523) | ||||
| 71541 | 71541 | 224269 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6011241.96431 | 2103719.95233 | 37.7570478572995 | -122.404113828986 | (37.7570478572995, -122.404113828986) | ||||
| 72350 | 72350 | 209029 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6000758.12976 | 2095576.10922 | 37.7340954490409 | -122.43978696861299 | (37.7340954490409, -122.439786968613) | ||||
| 72359 | 72359 | 209033 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 38 Martha Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6000746.954419999 | 2095582.5977 | 37.7341126287783 | -122.439826070211 | (37.7341126287783, -122.439826070211) | ||||
| 73320 | 73320 | 224268 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6011248.24436 | 2103720.25065 | 37.757049027311204 | -122.40409213106001 | (37.7570490273112, -122.40409213106) | ||||
| 73493 | 73493 | 224246 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 483 Valley St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 55 | 6002830.24391 | 2099168.61142 | 37.744077360782796 | -122.432879592517 | (37.7440773607828, -122.432879592517) | ||||
| 74012 | 74012 | 247935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6010295.56922 | 2098768.42696 | 37.743399135252204 | -122.407037837932 | (37.7433991352522, -122.407037837932) | ||||
| 75518 | 75518 | 191738 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 920 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6011311.04969 | 2104026.1978700003 | 37.757892599481 | -122.40389645386699 | (37.757892599481, -122.403896453867) | ||||
| 76551 | 76551 | 224247 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 527 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 46 | 6008745.222630001 | 2098103.60695 | 37.74148680607821 | -122.412351580256 | (37.7414868060782, -122.412351580256) | ||||
| 77296 | 77296 | 209024 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6000772.29534 | 2095570.30388 | 37.7340803152378 | -122.43973757782601 | (37.7340803152378, -122.439737577826) | ||||
| 79476 | 79476 | 116530 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 745X SANCHEZ ST | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
| 88008 | 88008 | 111551 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 29 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 27 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 89080 | 89080 | 106004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 695X CAMPBELL AVE | unknown : Yard 19 | Tree 1 | Rec/Park 3 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.41034847162202 | (37.716271678506, -122.410348471622) | ||||||
| 92343 | 92343 | 113367 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 6X Christopher Dr | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 25 | 5996701.11551 | 2103988.82524 | 37.7569629284433 | -122.454420756361 | (37.7569629284433, -122.454420756361) | ||||
| 92772 | 92772 | 114075 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 24 HIGUERA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 92885 | 92885 | 111536 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 14 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 94946 | 94946 | 95436 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2675 25th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 16 | 5988610.0 | 2097126.3 | 37.7376529013161 | -122.48189987005101 | (37.7376529013161, -122.481899870051) | ||||
| 100681 | 100681 | 111529 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 102874 | 102874 | 111513 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 800x BOSWORTH ST | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 16 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 103018 | 103018 | 104402 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6000011.7 | 2094912.1 | 37.7322297190532 | -122.44231994912901 | (37.7322297190532, -122.442319949129) | |||||
| 103214 | 103214 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 267 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | ||||
| 105251 | 105251 | 92899 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 105598 | 105598 | 106227 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 38 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997884.0 | 2095808.5 | 37.7345695210024 | -122.44974042873999 | (37.7345695210024, -122.44974042874) | |||||
| 106180 | 106180 | 106794 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
| 106936 | 106936 | 105441 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 425 WAWONA ST | unknown : Yard 19 | Tree 1 | Private 1 | 5991587.6 | 2097036.5 | 37.737579050883106 | -122.471598439568 | (37.7375790508831, -122.471598439568) | ||||||
| 108603 | 108603 | 114396 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 35 HIGUERA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||||
| 109383 | 109383 | 106792 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
| 111260 | 111260 | 111511 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 800x BOSWORTH ST | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 112606 | 112606 | 105901 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 112663 | 112663 | 114044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 549X ARLINGTON ST | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 6003400.0 | 2095634.0 | 37.734404428182295 | -122.430657330781 | (37.7344044281823, -122.430657330781) | |||||
| 113760 | 113760 | 106810 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 3500X MISSION ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 113956 | 113956 | 114069 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2 HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | 5988091.0 | 2090188.0 | 37.7185719141165 | -122.483185851801 | (37.7185719141165, -122.483185851801) | ||||
| 114512 | 114512 | 108201 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Reuel Ct | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774102 | 6017404.09127 | 2096025.6169900002 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | ||||
| 114729 | 114729 | 96803 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300X Melrose Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 48 | 5998134.5 | 2095546.7 | 37.733865009274204 | -122.448855518806 | (37.7338650092742, -122.448855518806) | ||||
| 115179 | 115179 | 106275 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 42 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | |||||
| 117576 | 117576 | 111525 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 26 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 119166 | 119166 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 119476 | 119476 | 108200 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Reuel Ct | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774102 | 6017404.09127 | 2096025.6169900002 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | ||||
| 120548 | 120548 | 111538 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 16 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 28 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 122260 | 122260 | 66251 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 35 HIGUERA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1990 12:00:00 AM | Permit Number 29352 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
| 122561 | 122561 | 105900 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 124116 | 124116 | 224234 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004836.880530001 | 2096694.1378 | 37.7373966273622 | -122.425764994654 | (37.7373966273622, -122.425764994654) | ||||
| 127427 | 127427 | 106795 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) |
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");