Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109418 | 109418 | 119124 | Undocumented 2 | :: 54 | 601 46th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 5ft | 5981605.53063 | 2111566.74083 | 37.7768923962204 | -122.50718822030198 | (37.7768923962204, -122.507188220302) | ||||
| 74538 | 74538 | 199648 | Undocumented 2 | :: 54 | 420 05th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6012151.63129 | 2111560.33 | 37.7786265538123 | -122.401518854125 | (37.7786265538123, -122.401518854125) | |||
| 95413 | 95413 | 118419 | Undocumented 2 | :: 54 | 5507 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5981562.4785 | 2111629.449 | 37.7770620385939 | -122.507341801673 | (37.7770620385939, -122.507341801673) | ||||
| 47019 | 47019 | 244022 | Undocumented 2 | :: 54 | 420 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 1ft | 6004861.89835 | 2105875.95275 | 37.762609178502004 | -122.42633203700599 | (37.762609178502, -122.426332037006) | |||
| 72618 | 72618 | 199649 | Undocumented 2 | :: 54 | 1601 Evans Ave | 22 | : 4 | Tree 1 | Private 1 | 0 | Width 1ft | 6015107.35337 | 2098882.19142 | 37.7439796026678 | -122.390407721252 | (37.7439796026678, -122.390407721252) | |||
| 161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
| 1410 | 1410 | 139164 | Undocumented 2 | :: 54 | 1975 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002726.0596 | 2114048.1262 | 37.784926980365206 | -122.43430340574699 | (37.7849269803652, -122.434303405747) | ||||
| 2526 | 2526 | 141913 | Undocumented 2 | :: 54 | 900 MCALLISTER ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004416.1749 | 2111910.2001 | 37.779152551854104 | -122.42830372330299 | (37.7791525518541, -122.428303723303) | |||
| 3620 | 3620 | 139511 | Undocumented 2 | :: 54 | 1400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001017.0 | 2111110.0 | 37.776762480662704 | -122.440005440059 | (37.7767624806627, -122.440005440059) | |||
| 6373 | 6373 | 138089 | Undocumented 2 | :: 54 | 1600 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004809.7961 | 2114741.3813 | 37.7869485378128 | -122.427143741054 | (37.7869485378128, -122.427143741054) | ||||
| 7654 | 7654 | 139157 | Undocumented 2 | :: 54 | 1699 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6003069.5459 | 2114034.3612 | 37.7849086753549 | -122.433114070807 | (37.7849086753549, -122.433114070807) | ||||
| 18412 | 18412 | 247322 | Undocumented 2 | :: 54 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002795.6845 | 2109344.9924 | 37.7720173021936 | -122.433726268045 | (37.7720173021936, -122.433726268045) | ||||
| 22368 | 22368 | 183808 | Undocumented 2 | :: 54 | 1823 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987517.377 | 2100286.1656 | 37.7462654526109 | -122.48590940972 | (37.7462654526109, -122.48590940972) | |||
| 22811 | 22811 | 185829 | Undocumented 2 | :: 54 | 2061 34th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985695.3610000005 | 2101217.9835 | 37.7487176270346 | -122.49227823369301 | (37.7487176270346, -122.492278233693) | |||
| 22852 | 22852 | 138173 | Undocumented 2 | :: 54 | 1953 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6000211.2401 | 2111613.6154 | 37.7780993776744 | -122.44282896766 | (37.7780993776744, -122.44282896766) | |||
| 23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
| 23724 | 23724 | 181665 | Undocumented 2 | :: 54 | 1275 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985511.3315 | 2106531.7973 | 37.7632971348656 | -122.49330603001499 | (37.7632971348656, -122.493306030015) | |||
| 23777 | 23777 | 183752 | Undocumented 2 | :: 54 | 2287 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987917.4443 | 2099749.9687 | 37.7448165037016 | -122.484486720736 | (37.7448165037016, -122.484486720736) | |||
| 23835 | 23835 | 182329 | Undocumented 2 | :: 54 | 1501 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985565.7361 | 2104954.3084 | 37.75896897093661 | -122.493001657059 | (37.7589689709366, -122.493001657059) | |||
| 23845 | 23845 | 142111 | Undocumented 2 | :: 54 | 36 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998636.7696 | 2110968.1942 | 37.7762373313333 | -122.448229118378 | (37.7762373313333, -122.448229118378) | |||
| 23926 | 23926 | 181820 | Undocumented 2 | :: 54 | 2299 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985846.0311 | 2099546.7997 | 37.7441378151504 | -122.491634223287 | (37.7441378151504, -122.491634223287) | |||
| 24053 | 24053 | 181971 | Undocumented 2 | :: 54 | 2467 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985787.1457 | 2098434.4072 | 37.7410800425161 | -122.49175595946801 | (37.7410800425161, -122.491755959468) | |||
| 24081 | 24081 | 183742 | Undocumented 2 | :: 54 | 2278 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988578.8889999995 | 2099828.4885 | 37.745070593746796 | -122.482205348546 | (37.7450705937468, -122.482205348546) | |||
| 24104 | 24104 | 248307 | Undocumented 2 | :: 54 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.44550750940901 | (37.7691713129844, -122.445507509409) | |||
| 24148 | 24148 | 182529 | Undocumented 2 | :: 54 | 1583 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986203.973999999 | 2104470.5925 | 37.7576781250927 | -122.490758769583 | (37.7576781250927, -122.490758769583) | |||
| 24206 | 24206 | 181982 | Undocumented 2 | :: 54 | 2479 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986720.0054 | 2098392.2737 | 37.7410188327151 | -122.488527415956 | (37.7410188327151, -122.488527415956) | |||
| 24275 | 24275 | 184454 | Undocumented 2 | :: 54 | 2153 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981374.6331 | 2100381.1786 | 37.7461664541179 | -122.507156946857 | (37.7461664541179, -122.507156946857) | |||
| 24313 | 24313 | 184893 | Undocumented 2 | :: 54 | 1786 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981952.8719 | 2102926.7078 | 37.753189803786896 | -122.505346142178 | (37.7531898037869, -122.505346142178) | |||
| 24402 | 24402 | 182453 | Undocumented 2 | :: 54 | 1500 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986555.3586 | 2104541.3333 | 37.7578928802813 | -122.489548755928 | (37.7578928802813, -122.489548755928) | |||
| 24496 | 24496 | 184100 | Undocumented 2 | :: 54 | 1614 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985016.0366 | 2104172.5195 | 37.756790232687 | -122.494845106619 | (37.756790232687, -122.494845106619) | |||
| 24523 | 24523 | 141857 | Undocumented 2 | :: 54 | 1100 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004651.3626 | 2112630.8889 | 37.781144690344895 | -122.42754147050199 | (37.7811446903449, -122.427541470502) | |||
| 24606 | 24606 | 181614 | Undocumented 2 | :: 54 | 1246 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984927.2833 | 2106710.1633 | 37.7637526989564 | -122.49533918573601 | (37.7637526989564, -122.495339185736) | |||
| 24683 | 24683 | 183508 | Undocumented 2 | :: 54 | 2547 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988598.1694 | 2097978.5588 | 37.7399922937625 | -122.482003188533 | (37.7399922937625, -122.482003188533) | |||
| 24723 | 24723 | 181788 | Undocumented 2 | :: 54 | 3131 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986265.505 | 2098198.358 | 37.740459860841 | -122.49008463083 | (37.740459860841, -122.49008463083) | |||
| 24732 | 24732 | 141579 | Undocumented 2 | :: 54 | 500 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000650.2876 | 2110740.0178 | 37.7757257205697 | -122.44124745176501 | (37.7757257205697, -122.441247451765) | |||
| 24890 | 24890 | 183769 | Undocumented 2 | :: 54 | 2295 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987606.9921 | 2099681.9039 | 37.7446115325485 | -122.48555519813499 | (37.7446115325485, -122.485555198135) | |||
| 25062 | 25062 | 247418 | Undocumented 2 | :: 54 | 1001 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002608.194 | 2110213.5869 | 37.7743916070028 | -122.43443692499599 | (37.7743916070028, -122.434436924996) | |||
| 25160 | 25160 | 244247 | Undocumented 2 | :: 54 | 200 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005673.0642 | 2110022.6890000002 | 37.7740409443959 | -122.423821374378 | (37.7740409443959, -122.423821374378) | |||
| 25293 | 25293 | 182679 | Undocumented 2 | :: 54 | 2631 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986083.8267 | 2103639.2241 | 37.7553883964845 | -122.49111310108299 | (37.7553883964845, -122.491113101083) | |||
| 25460 | 25460 | 181596 | Undocumented 2 | :: 54 | 1683 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984674.4393 | 2103735.9717 | 37.7555715918184 | -122.495994253801 | (37.7555715918184, -122.495994253801) | |||
| 25506 | 25506 | 137920 | Undocumented 2 | :: 54 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.788390961736795 | -122.433650548643 | (37.7883909617368, -122.433650548643) | |||
| 25583 | 25583 | 139608 | Undocumented 2 | :: 54 | 1724 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001827.9162 | 2112238.3787 | 37.7799068540457 | -122.437281058847 | (37.7799068540457, -122.437281058847) | |||
| 25649 | 25649 | 182532 | Undocumented 2 | :: 54 | 1581 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985581.6988 | 2104465.1884 | 37.7576269162189 | -122.492910423341 | (37.7576269162189, -122.492910423341) | |||
| 25748 | 25748 | 182187 | Undocumented 2 | :: 54 | 1622 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989666.9072 | 2104289.3052 | 37.757382042273996 | -122.47876940221 | (37.757382042274, -122.47876940221) | |||
| 25969 | 25969 | 183335 | Undocumented 2 | :: 54 | 1211 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.9565 | 2106839.0545 | 37.7639763455704 | -122.503028028557 | (37.7639763455704, -122.503028028557) | |||
| 25978 | 25978 | 182524 | Undocumented 2 | :: 54 | 1579 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985892.4217 | 2104503.3998 | 37.757750000215005 | -122.491838645138 | (37.757750000215, -122.491838645138) | |||
| 26076 | 26076 | 181698 | Undocumented 2 | :: 54 | 1809 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5990006.9617 | 2107176.8497 | 37.7653302032624 | -122.47780444851401 | (37.7653302032624, -122.477804448514) | |||
| 26178 | 26178 | 186047 | Undocumented 2 | :: 54 | 1900 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984778.2299 | 2102058.2647 | 37.7509711496958 | -122.495511585412 | (37.7509711496958, -122.495511585412) | |||
| 26182 | 26182 | 142482 | Undocumented 2 | :: 54 | 1501 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010536.0572 | 2119686.9897 | 37.800850136387204 | -122.407680928456 | (37.8008501363872, -122.407680928456) | |||
| 26491 | 26491 | 184713 | Undocumented 2 | :: 54 | 1626 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984397.6244 | 2104083.8858 | 37.756510650266705 | -122.496977229466 | (37.7565106502667, -122.496977229466) | |||
| 26507 | 26507 | 184509 | Undocumented 2 | :: 54 | 1886 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981125.5546 | 2102268.3878 | 37.751333525850896 | -122.50815826243401 | (37.7513335258509, -122.508158262434) | |||
| 26576 | 26576 | 184709 | Undocumented 2 | :: 54 | 1618 40th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983775.4227 | 2104111.6852 | 37.7565504997112 | -122.499131044219 | (37.7565504997112, -122.499131044219) | |||
| 26632 | 26632 | 182608 | Undocumented 2 | :: 54 | 1839 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985333.4224 | 2102688.337 | 37.7527336497539 | -122.493638125681 | (37.7527336497539, -122.493638125681) | |||
| 26700 | 26700 | 183825 | Undocumented 2 | :: 54 | 2233 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987596.9637 | 2100067.0354 | 37.745668416958 | -122.48561813299 | (37.745668416958, -122.48561813299) | |||
| 26723 | 26723 | 183174 | Undocumented 2 | :: 54 | 2400 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984903.1916 | 2098438.8046 | 37.7410404135541 | -122.494812631239 | (37.7410404135541, -122.494812631239) | |||
| 26774 | 26774 | 183705 | Undocumented 2 | :: 54 | 3628 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983226.2116 | 2105643.5823 | 37.760724424253205 | -122.50114368176399 | (37.7607244242532, -122.501143681764) | |||
| 26822 | 26822 | 183837 | Undocumented 2 | :: 54 | 2206 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985462.2045 | 2100160.7045 | 37.745800992601 | -122.4930066047 | (37.745800992601, -122.4930066047) | |||
| 26862 | 26862 | 245988 | Undocumented 2 | :: 54 | 1250 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999884.6674 | 2108495.9392 | 37.76952040656629 | -122.44373466044901 | (37.7695204065663, -122.443734660449) | |||
| 26866 | 26866 | 182267 | Undocumented 2 | :: 54 | 1474 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986846.9486 | 2105227.058 | 37.7597927113016 | -122.48859072822201 | (37.7597927113016, -122.488590728222) | |||
| 26920 | 26920 | 182657 | Undocumented 2 | :: 54 | 2630 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985816.7659 | 2102326.4814 | 37.75176835729211 | -122.491940021962 | (37.7517683572921, -122.491940021962) | |||
| 27047 | 27047 | 181865 | Undocumented 2 | :: 54 | 2331 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986993.7887 | 2099395.3559 | 37.743789001507004 | -122.487654458992 | (37.743789001507, -122.487654458992) | |||
| 27065 | 27065 | 183718 | Undocumented 2 | :: 54 | 2254 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987333.4527 | 2099922.5844 | 37.745256435851495 | -122.486518698932 | (37.7452564358515, -122.486518698932) | |||
| 27133 | 27133 | 183989 | Undocumented 2 | :: 54 | 1678 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985337.681 | 2103783.3365 | 37.755740466247296 | -122.493704080582 | (37.7557404662473, -122.493704080582) | |||
| 27251 | 27251 | 184688 | Undocumented 2 | :: 54 | 1611 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984657.9281 | 2104207.7196 | 37.7568659135367 | -122.496086155975 | (37.7568659135367, -122.496086155975) | |||
| 27362 | 27362 | 137901 | Undocumented 2 | :: 54 | 402 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005281.3807 | 2115310.0743 | 37.7885366835693 | -122.425552653183 | (37.7885366835693, -122.425552653183) | |||
| 27363 | 27363 | 141421 | Undocumented 2 | :: 54 | 550 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004561.2684 | 2111044.0972 | 37.7767826552211 | -122.42774005835501 | (37.7767826552211, -122.427740058355) | |||
| 27390 | 27390 | 183785 | Undocumented 2 | :: 54 | 2146 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986125.7828 | 2099614.0525 | 37.744338818609 | -122.490671864125 | (37.744338818609, -122.490671864125) | |||
| 27474 | 27474 | 183607 | Undocumented 2 | :: 54 | 1 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989903.61 | 2101103.2452 | 37.748647706091596 | -122.477717911497 | (37.7486477060916, -122.477717911497) | |||
| 27534 | 27534 | 142574 | Undocumented 2 | :: 54 | 2251 MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008922.4097 | 2120888.3705 | 37.804058366605894 | -122.413349854276 | (37.8040583666059, -122.413349854276) | |||
| 27597 | 27597 | 184102 | Undocumented 2 | :: 54 | 1623 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985904.0693 | 2104173.8569 | 37.7568458469392 | -122.491774103994 | (37.7568458469392, -122.491774103994) | |||
| 27770 | 27770 | 181987 | Undocumented 2 | :: 54 | 2832 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987195.8265 | 2098292.1009 | 37.7407715379119 | -122.486874867312 | (37.7407715379119, -122.486874867312) | |||
| 27966 | 27966 | 184450 | Undocumented 2 | :: 54 | 2127 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982917.6673 | 2100633.8105 | 37.7469508716588 | -122.501840104956 | (37.7469508716588, -122.501840104956) | |||
| 28027 | 28027 | 140087 | Undocumented 2 | :: 54 | 1210 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001853.1286 | 2112643.6389 | 37.781021029267706 | -122.43722286326 | (37.7810210292677, -122.43722286326) | |||
| 28131 | 28131 | 200245 | Undocumented 2 | :: 54 | 1075 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013768.3263 | 2090118.3656 | 37.71984155975311 | -122.394424294358 | (37.7198415597531, -122.394424294358) | |||
| 28244 | 28244 | 184686 | Undocumented 2 | :: 54 | 1606 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984083.9121 | 2104208.225 | 37.7568336628482 | -122.498071323375 | (37.7568336628482, -122.498071323375) | |||
| 28310 | 28310 | 185781 | Undocumented 2 | :: 54 | 2419 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986496.7508 | 2102292.5013 | 37.7517147795652 | -122.489586075955 | (37.7517147795652, -122.489586075955) | |||
| 28315 | 28315 | 182384 | Undocumented 2 | :: 54 | 1539 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985884.4808 | 2104746.0177 | 37.7584156979157 | -122.49188396911 | (37.7584156979157, -122.49188396911) | |||
| 28318 | 28318 | 182661 | Undocumented 2 | :: 54 | 2500 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986241.1388 | 2102339.3676 | 37.7518285352163 | -122.490473451437 | (37.7518285352163, -122.490473451437) | |||
| 28319 | 28319 | 139084 | Undocumented 2 | :: 54 | 2512 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000122.7854 | 2113741.6890000002 | 37.7839374779531 | -122.443287851631 | (37.7839374779531, -122.443287851631) | |||
| 28402 | 28402 | 137551 | Undocumented 2 | :: 54 | 1526 Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002668.0924 | 2113464.7267 | 37.7833218226195 | -122.434462226416 | (37.7833218226195, -122.434462226416) | |||
| 28513 | 28513 | 200177 | Undocumented 2 | :: 54 | 1041 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876001 | (37.7190489123065, -122.39135410876) | |||
| 28564 | 28564 | 139551 | Undocumented 2 | :: 54 | 230 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000668.9907 | 2112886.9641 | 37.7816217540269 | -122.441336837605 | (37.7816217540269, -122.441336837605) | |||
| 28625 | 28625 | 217557 | Undocumented 2 | :: 54 | 111 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5995778.3452 | 2088036.9975 | 37.7131101315221 | -122.456458551068 | (37.7131101315221, -122.456458551068) | |||
| 28730 | 28730 | 140456 | Undocumented 2 | :: 54 | 1459 Eddy St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003479.0697 | 2112771.1641 | 37.7814634747388 | -122.431607035931 | (37.7814634747388, -122.431607035931) | |||
| 28842 | 28842 | 244343 | Undocumented 2 | :: 54 | 462 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003204.9743 | 2109911.1218 | 37.7735949699184 | -122.432350944562 | (37.7735949699184, -122.432350944562) | |||
| 28871 | 28871 | 182685 | Undocumented 2 | :: 54 | 1709 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985611.9744 | 2103558.0646 | 37.7551379747053 | -122.492738908785 | (37.7551379747053, -122.492738908785) | |||
| 28907 | 28907 | 182325 | Undocumented 2 | :: 54 | 1500 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985611.7191 | 2104963.9168 | 37.758998042021105 | -122.492843336234 | (37.7589980420211, -122.492843336234) | |||
| 28948 | 28948 | 141597 | Undocumented 2 | :: 54 | 529 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999089.4212 | 2110974.3283 | 37.7762800409646 | -122.44666372012199 | (37.7762800409646, -122.446663720122) | |||
| 29089 | 29089 | 183590 | Undocumented 2 | :: 54 | 2630 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989282.842 | 2097424.4506 | 37.7385106529577 | -122.47959536842899 | (37.7385106529577, -122.479595368429) | |||
| 29214 | 29214 | 182945 | Undocumented 2 | :: 54 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | |||
| 29215 | 29215 | 182387 | Undocumented 2 | :: 54 | 1534 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984999.5267 | 2104736.7468 | 37.7583384778479 | -122.494943804575 | (37.7583384778479, -122.494943804575) | |||
| 29414 | 29414 | 182531 | Undocumented 2 | :: 54 | 1583 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985892.5986 | 2104472.9119 | 37.7576662991842 | -122.491835788899 | (37.7576662991842, -122.491835788899) | |||
| 29522 | 29522 | 184704 | Undocumented 2 | :: 54 | 1615 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984659.276000001 | 2104181.7734 | 37.756794751430995 | -122.496079580355 | (37.756794751431, -122.496079580355) | |||
| 29647 | 29647 | 200249 | Undocumented 2 | :: 54 | 1067 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | |||
| 29653 | 29653 | 138301 | Undocumented 2 | :: 54 | 2201 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002887.8567 | 2114766.9673 | 37.786909917993 | -122.433795036923 | (37.786909917993, -122.433795036923) | |||
| 29665 | 29665 | 138192 | Undocumented 2 | :: 54 | 747 LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000012.96 | 2111513.4792 | 37.7778131233274 | -122.44350769286301 | (37.7778131233274, -122.443507692863) | |||
| 29815 | 29815 | 181758 | Undocumented 2 | :: 54 | 1230 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984924.8270000005 | 2106814.5562 | 37.764039188732205 | -122.495355380579 | (37.7640391887322, -122.495355380579) | |||
| 29863 | 29863 | 200176 | Undocumented 2 | :: 54 | 1047 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | |||
| 29939 | 29939 | 184629 | Undocumented 2 | :: 54 | 1646 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983471.6508 | 2103927.0296 | 37.7560256626113 | -122.500167928609 | (37.7560256626113, -122.500167928609) | |||
| 29958 | 29958 | 182143 | Undocumented 2 | :: 54 | 1417 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988335.378 | 2105652.5628 | 37.7610477734155 | -122.483474239769 | (37.7610477734155, -122.483474239769) |
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");