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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||||
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) | ||||
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) | ||||
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) | |||||
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) | |||||
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) | ||||
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) | ||||
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) | ||||
130011 | 130011 | 209032 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 38 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6000749.17916 | 2095580.7996200002 | 37.7341078183059 | -122.43981824973301 | (37.7341078183059, -122.439818249733) | ||||
130593 | 130593 | 191727 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | ||||
130703 | 130703 | 224266 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6011271.09407 | 2103721.28577 | 37.75705314619071 | -122.404013180481 | (37.7570531461907, -122.404013180481) | ||||
133399 | 133399 | 224230 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004850.154069999 | 2096702.7007099998 | 37.7374208892559 | -122.425719711103 | (37.7374208892559, -122.425719711103) | ||||
134583 | 134583 | 209010 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6000785.06362 | 2095352.2063400003 | 37.7334821968386 | -122.439677803484 | (37.7334821968386, -122.439677803484) | ||||
134672 | 134672 | 207755 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 5994788.04604 | 2105291.71815 | 37.7604304368423 | -122.46113126040702 | (37.7604304368423, -122.461131260407) | ||||
134906 | 134906 | 191730 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009966.3806300005 | 2107638.17528 | 37.767735053365705 | -122.40880172773399 | (37.7677350533657, -122.408801727734) | ||||
135102 | 135102 | 224232 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004847.66693 | 2096700.7431599998 | 37.7374153737207 | -122.425728171024 | (37.7374153737207, -122.425728171024) | ||||
135905 | 135905 | 224240 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6004759.95311 | 2096625.2597 | 37.7372031562031 | -122.426026066958 | (37.7372031562031, -122.426026066958) | ||||
136867 | 136867 | 224241 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004764.42793 | 2096634.9587599998 | 37.7372300405369 | -122.42601128568998 | (37.7372300405369, -122.42601128569) | ||||
138334 | 138334 | 207756 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | 5994800.39892 | 2105292.04488 | 37.7604320448233 | -122.461088561491 | (37.7604320448233, -122.461088561491) | ||||
138466 | 138466 | 114076 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 24 HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
138770 | 138770 | 209034 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 38 Martha Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6000740.95615 | 2095584.22378 | 37.7341167521787 | -122.439846924607 | (37.7341167521787, -122.439846924607) | ||||
139866 | 139866 | 115801 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 9M CAIRE TER | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012720.0 | 2101959.0 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | |||||
141792 | 141792 | 119265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1317 Bosworth St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000208.0 | 2096491.0 | 37.7365761953737 | -122.44175457190599 | (37.7365761953737, -122.441754571906) | |||||
146980 | 146980 | 247819 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009694.17454 | 2096850.5592099999 | 37.738099414264 | -122.408982025597 | (37.738099414264, -122.408982025597) | ||||
147007 | 147007 | 247922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010270.948580001 | 2098720.09099 | 37.7432650373678 | -122.40711956383001 | (37.7432650373678, -122.40711956383) | ||||
148610 | 148610 | 209028 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | 6000760.3597 | 2095574.5612700002 | 37.7340913256606 | -122.439779148088 | (37.7340913256606, -122.439779148088) | ||||
148899 | 148899 | 247820 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009707.559769999 | 2096850.2861400002 | 37.7380994142676 | -122.40893572671699 | (37.7380994142676, -122.408935726717) | ||||
150050 | 150050 | 209031 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6000753.40861 | 2095578.70975 | 37.734102320756996 | -122.43980347745001 | (37.734102320757, -122.43980347745) | ||||
150294 | 150294 | 247917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6010231.88216 | 2098716.76824 | 37.7432537274832 | -122.407254411775 | (37.7432537274832, -122.407254411775) | ||||
153234 | 153234 | 209020 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 4 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000767.68455 | 2095534.49854 | 37.7339817396554 | -122.439750952547 | (37.7339817396554, -122.439750952547) | ||||
153590 | 153590 | 248107 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 138 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6010423.63855 | 2099478.50343 | 37.7453560168793 | -122.406645033853 | (37.7453560168793, -122.406645033853) | ||||
154149 | 154149 | 201514 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 6018663.55815 | 2094844.4948099998 | 37.733089515074795 | -122.377830854436 | (37.7330895150748, -122.377830854436) | ||||
154936 | 154936 | 224219 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004118.53569 | 2095824.9734900002 | 37.734969479450896 | -122.428186723249 | (37.7349694794509, -122.428186723249) | ||||
155920 | 155920 | 224236 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004818.97924 | 2096691.85028 | 37.737389334736 | -122.425826725021 | (37.737389334736, -122.425826725021) | ||||
156854 | 156854 | 209023 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6000780.47253 | 2095565.1582 | 37.7340666518368 | -122.439708938014 | (37.7340666518368, -122.439708938014) | ||||
156972 | 156972 | 224267 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6011260.203430001 | 2103721.90369 | 37.7570542343818 | -122.40405088815001 | (37.7570542343818, -122.40405088815) |
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");