Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
30182 | 30182 | 184584 | Undocumented 2 | :: 54 | 1750 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984424.998 | 2103256.5795 | 37.7542407008981 | -122.496821507327 | (37.7542407008981, -122.496821507327) | |||
30188 | 30188 | 182737 | Undocumented 2 | :: 54 | 1751 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985623.647000001 | 2103292.6533 | 37.7544099107452 | -122.492678995508 | (37.7544099107452, -122.492678995508) | |||
30846 | 30846 | 182211 | Undocumented 2 | :: 54 | 1591 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985585.3014 | 2104403.0433 | 37.75745649361671 | -122.49289338685 | (37.7574564936167, -122.49289338685) | |||
31109 | 31109 | 184715 | Undocumented 2 | :: 54 | 1631 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984663.3195 | 2104077.315 | 37.7565081745164 | -122.496057890447 | (37.7565081745164, -122.496057890447) | |||
31121 | 31121 | 185816 | Undocumented 2 | :: 54 | 2519 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987136.8132 | 2101635.9994 | 37.7499495497007 | -122.487324467521 | (37.7499495497007, -122.487324467521) | |||
31188 | 31188 | 181929 | Undocumented 2 | :: 54 | 2427 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985466.1527 | 2098683.3165 | 37.7417447146597 | -122.492884150676 | (37.7417447146597, -122.492884150676) | |||
31203 | 31203 | 182476 | Undocumented 2 | :: 54 | 1559 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985886.8002 | 2104622.5113 | 37.7580767189836 | -122.491866855206 | (37.7580767189836, -122.491866855206) | |||
31225 | 31225 | 184643 | Undocumented 2 | :: 54 | 3324 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983935.3115 | 2103621.2359 | 37.7552132408568 | -122.49854187345801 | (37.7552132408568, -122.498541873458) | |||
31404 | 31404 | 181902 | Undocumented 2 | :: 54 | 2370 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986740.6492 | 2099140.1859 | 37.7430736050662 | -122.488510993633 | (37.7430736050662, -122.488510993633) | |||
31766 | 31766 | 184717 | Undocumented 2 | :: 54 | 1630 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984088.6295 | 2104052.5482 | 37.756406494372705 | -122.498043512944 | (37.7564064943727, -122.498043512944) | |||
31770 | 31770 | 183463 | Undocumented 2 | :: 54 | 2530 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988329.4378 | 2098069.925 | 37.740227528416796 | -122.482939034698 | (37.7402275284168, -122.482939034698) | |||
31862 | 31862 | 183821 | Undocumented 2 | :: 54 | 2226 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986398.8954 | 2100073.2231 | 37.745615527653996 | -122.48976127310301 | (37.745615527654, -122.489761273103) | |||
32086 | 32086 | 182494 | Undocumented 2 | :: 54 | 1589 20th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989920.8647 | 2104571.2003 | 37.758170793630704 | -122.47791173356899 | (37.7581707936307, -122.477911733569) | |||
32307 | 32307 | 181866 | Undocumented 2 | :: 54 | 2333 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987926.6484 | 2099416.8457 | 37.7439023721205 | -122.484430466696 | (37.7439023721205, -122.484430466696) | |||
32375 | 32375 | 183437 | Undocumented 2 | :: 54 | 2509 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988899.1764 | 2098219.7887 | 37.7406721500335 | -122.480980100642 | (37.7406721500335, -122.480980100642) | |||
32428 | 32428 | 182575 | Undocumented 2 | :: 54 | 2444 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989239.9887 | 2098703.075 | 37.742018933713105 | -122.479837071242 | (37.7420189337131, -122.479837071242) | |||
33122 | 33122 | 185071 | Undocumented 2 | :: 54 | 2800 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984981.8139 | 2096034.5991 | 37.7344437114318 | -122.49436361071899 | (37.7344437114318, -122.494363610719) | |||
33144 | 33144 | 182431 | Undocumented 2 | :: 54 | 1550 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985622.7002 | 2104651.6438 | 37.7581412688876 | -122.492782358773 | (37.7581412688876, -122.492782358773) | |||
33203 | 33203 | 181890 | Undocumented 2 | :: 54 | 2342 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986735.2344 | 2099299.921 | 37.74351187906971 | -122.488541453894 | (37.7435118790697, -122.488541453894) | |||
33211 | 33211 | 200211 | Undocumented 2 | :: 54 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014078.3317 | 2089599.8969999999 | 37.7184351760665 | -122.39331644356001 | (37.7184351760665, -122.39331644356) | |||
33310 | 33310 | 185231 | Undocumented 2 | :: 54 | 2526 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986157.8975 | 2098028.4291 | 37.7399869968702 | -122.49044419216101 | (37.7399869968702, -122.490444192161) | |||
33516 | 33516 | 181822 | Undocumented 2 | :: 54 | 2325 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985695.095 | 2099543.4155 | 37.7441197008564 | -122.492155870544 | (37.7441197008564, -122.492155870544) | |||
33521 | 33521 | 182182 | Undocumented 2 | :: 54 | 1643 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989628.9520000005 | 2104174.9651 | 37.7570658909994 | -122.478892302116 | (37.7570658909994, -122.478892302116) | |||
33564 | 33564 | 182573 | Undocumented 2 | :: 54 | 2185 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989329.4471 | 2098306.2746 | 37.740934619914796 | -122.479498731562 | (37.7409346199148, -122.479498731562) | |||
33583 | 33583 | 182803 | Undocumented 2 | :: 54 | 1782 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987536.9059 | 2103168.9213 | 37.7541818639362 | -122.486053455677 | (37.7541818639362, -122.486053455677) | |||
33709 | 33709 | 185819 | Undocumented 2 | :: 54 | 2039 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986926.728999999 | 2101375.0645 | 37.7492208393265 | -122.488031768826 | (37.7492208393265, -122.488031768826) | |||
33783 | 33783 | 184628 | Undocumented 2 | :: 54 | 1796 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984434.1354 | 2102998.0252 | 37.7535313177823 | -122.49677082792499 | (37.7535313177823, -122.496770827925) | |||
33871 | 33871 | 183766 | Undocumented 2 | :: 54 | 2282 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986098.8983 | 2099716.8964 | 37.744619629849794 | -122.49077238951 | (37.7446196298498, -122.49077238951) | |||
34204 | 34204 | 183601 | Undocumented 2 | :: 54 | 2647 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989550.5846 | 2097326.397 | 37.7382569723881 | -122.47866248497401 | (37.7382569723881, -122.478662484974) | |||
34425 | 34425 | 184635 | Undocumented 2 | :: 54 | 1646 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983160.6342 | 2103926.3557 | 37.7560055530367 | -122.50124346024299 | (37.7560055530367, -122.501243460243) | |||
34454 | 34454 | 182862 | Undocumented 2 | :: 54 | 1832 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987236.1292 | 2102771.2926 | 37.7530725498124 | -122.487064401227 | (37.7530725498124, -122.487064401227) | |||
34474 | 34474 | 183741 | Undocumented 2 | :: 54 | 2274 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986719.376 | 2099760.8505 | 37.74477654290771 | -122.48863015911199 | (37.7447765429077, -122.488630159112) | |||
34580 | 34580 | 184144 | Undocumented 2 | :: 54 | 1651 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985908.7501 | 2103985.2837 | 37.7563283503706 | -122.49174403472799 | (37.7563283503706, -122.491744034728) | |||
34821 | 34821 | 184604 | Undocumented 2 | :: 54 | 1771 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984386.4179 | 2103133.394 | 37.753900207001294 | -122.496945833428 | (37.7539002070013, -122.496945833428) | |||
34873 | 34873 | 184590 | Undocumented 2 | :: 54 | 1727 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982826.6318 | 2103356.0755 | 37.7544201042603 | -122.502356328834 | (37.7544201042603, -122.502356328834) | |||
34953 | 34953 | 184142 | Undocumented 2 | :: 54 | 1642 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985022.0549 | 2104003.3385 | 37.7563260608013 | -122.494811820237 | (37.7563260608013, -122.494811820237) | |||
35054 | 35054 | 183614 | Undocumented 2 | :: 54 | 1675 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987775.1316 | 2103912.4276 | 37.756237211758105 | -122.48528417545201 | (37.7562372117581, -122.485284175452) | |||
35383 | 35383 | 182496 | Undocumented 2 | :: 54 | 1567 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985890.2792 | 2104567.4262 | 37.7579256738328 | -122.491850768207 | (37.7579256738328, -122.491850768207) | |||
35618 | 35618 | 182710 | Undocumented 2 | :: 54 | 1707 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989018.9578 | 2103687.0641 | 37.755690805560896 | -122.48096614821199 | (37.7556908055609, -122.480966148212) | |||
35754 | 35754 | 182933 | Undocumented 2 | :: 54 | 2646 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981845.0394 | 2097064.8142 | 37.7370883295038 | -122.505284615423 | (37.7370883295038, -122.505284615423) | |||
36129 | 36129 | 184472 | Undocumented 2 | :: 54 | 2191 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982622.5635 | 2100219.2438 | 37.7457952471339 | -122.50282984708001 | (37.7457952471339, -122.50282984708) | |||
36154 | 36154 | 184467 | Undocumented 2 | :: 54 | 2182 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981733.5294 | 2100249.3634 | 37.7458256579494 | -122.50590617914699 | (37.7458256579494, -122.505906179147) | |||
36680 | 36680 | 200762 | Undocumented 2 | :: 54 | 1999 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014632.1803 | 2093750.8421 | 37.7298635995705 | -122.39169207228201 | (37.7298635995705, -122.391692072282) | |||
36998 | 36998 | 184372 | Undocumented 2 | :: 54 | 2263 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981709.435 | 2099687.8805 | 37.7442825640676 | -122.50594787141 | (37.7442825640676, -122.50594787141) | |||
37419 | 37419 | 141003 | Undocumented 2 | :: 54 | 166 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996581.6168 | 2113251.3598 | 37.7823885984174 | -122.45550347026399 | (37.7823885984174, -122.455503470264) | |||
37520 | 37520 | 182712 | Undocumented 2 | :: 54 | 1719 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985923.1814 | 2103513.3913 | 37.7550335068364 | -122.49165939101002 | (37.7550335068364, -122.49165939101) | |||
37651 | 37651 | 184147 | Undocumented 2 | :: 54 | 1591 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984655.1204 | 2104363.1652 | 37.757292559487 | -122.496107333876 | (37.757292559487, -122.496107333876) | |||
37937 | 37937 | 182392 | Undocumented 2 | :: 54 | 1542 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985927.969 | 2104719.9248 | 37.7583465957731 | -122.491731648895 | (37.7583465957731, -122.491731648895) | |||
37938 | 37938 | 181831 | Undocumented 2 | :: 54 | 2312 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986419.3177 | 2099473.0237 | 37.743968733475704 | -122.489646527203 | (37.7439687334757, -122.489646527203) | |||
38295 | 38295 | 182332 | Undocumented 2 | :: 54 | 1494 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985606.7756 | 2105058.9207 | 37.759258607335795 | -122.49286743066601 | (37.7592586073358, -122.492867430666) | |||
38706 | 38706 | 182449 | Undocumented 2 | :: 54 | 1566 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988104.5754 | 2104637.7922 | 37.7582480531421 | -122.48419805393999 | (37.7582480531421, -122.48419805394) | |||
39023 | 39023 | 184457 | Undocumented 2 | :: 54 | 2151 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982303.7701 | 2100458.8464 | 37.746434388466 | -122.503949913871 | (37.746434388466, -122.503949913871) | |||
39214 | 39214 | 184146 | Undocumented 2 | :: 54 | 1583 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983412.2604 | 2104390.9064 | 37.757295852249 | -122.500407612857 | (37.757295852249, -122.500407612857) | |||
39413 | 39413 | 182439 | Undocumented 2 | :: 54 | 1524 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984994.4728 | 2104793.4765 | 37.758493945986 | -122.494965465844 | (37.758493945986, -122.494965465844) | |||
39591 | 39591 | 181680 | Undocumented 2 | :: 54 | 1290 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985868.4858 | 2106459.7761 | 37.7631202685599 | -122.492065465074 | (37.7631202685599, -122.492065465074) | |||
39779 | 39779 | 183215 | Undocumented 2 | :: 54 | 3318 Rivera St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982838.8142 | 2100183.1408 | 37.7457088250993 | -122.50207942434601 | (37.7457088250993, -122.502079424346) | |||
39782 | 39782 | 184722 | Undocumented 2 | :: 54 | 1643 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984666.6891 | 2104002.5093 | 37.7563029761962 | -122.49604071877899 | (37.7563029761962, -122.496040718779) | |||
40047 | 40047 | 182426 | Undocumented 2 | :: 54 | 1527 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985880.4219 | 2104826.6158 | 37.758636760808294 | -122.49190394010901 | (37.7586367608083, -122.491903940109) | |||
40078 | 40078 | 182086 | Undocumented 2 | :: 54 | 2425 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988468.6309 | 2098276.195 | 37.7408019901024 | -122.482472876934 | (37.7408019901024, -122.482472876934) | |||
40140 | 40140 | 182694 | Undocumented 2 | :: 54 | 1715 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985923.1814 | 2103540.9984 | 37.7551093083613 | -122.491661423134 | (37.7551093083613, -122.491661423134) | |||
40189 | 40189 | 183398 | Undocumented 2 | :: 54 | 2676 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989291.1458 | 2097146.7716 | 37.7377487006662 | -122.479546347444 | (37.7377487006662, -122.479546347444) | |||
40856 | 40856 | 183228 | Undocumented 2 | :: 54 | 2000 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984812.3217 | 2101129.9369 | 37.7484242121957 | -122.495325239408 | (37.7484242121957, -122.495325239408) |
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");