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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
39979 | 39979 | 185836 | Undocumented 2 | :: 54 | 2000 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985432.8989 | 2101036.5759 | 37.748204183826395 | -122.4931724505 | (37.7482041838264, -122.4931724505) | |||
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) | |||
40717 | 40717 | 184162 | Undocumented 2 | :: 54 | 3542 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983197.136 | 2104275.0936 | 37.7569652328272 | -122.501143019632 | (37.7569652328272, -122.501143019632) | |||
40764 | 40764 | 186526 | Undocumented 2 | :: 54 | 1501 Sunset Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984782.9201 | 2104548.9278 | 37.7578100967767 | -122.495679060793 | (37.7578100967767, -122.495679060793) | |||
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) | |||
41041 | 41041 | 181871 | Undocumented 2 | :: 54 | 2362 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987360.2995 | 2099206.855 | 37.74329279819221 | -122.486373331241 | (37.7432927981922, -122.486373331241) | |||
41142 | 41142 | 182408 | Undocumented 2 | :: 54 | 1523 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985878.6824 | 2104848.6498 | 37.7586971584144 | -122.49191157818301 | (37.7586971584144, -122.491911578183) | |||
41261 | 41261 | 184673 | Undocumented 2 | :: 54 | 1683 38th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984368.1401 | 2103732.6021 | 37.755544395128105 | -122.49705326703999 | (37.7555443951281, -122.49705326704) | |||
41274 | 41274 | 182195 | Undocumented 2 | :: 54 | 1586 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985318.2577 | 2104423.308 | 37.757496514806206 | -122.49381841054199 | (37.7574965148062, -122.493818410542) | |||
41591 | 41591 | 182491 | Undocumented 2 | :: 54 | 1567 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986199.9151 | 2104587.1409 | 37.7579978978388 | -122.490781382224 | (37.7579978978388, -122.490781382224) | |||
41764 | 41764 | 183600 | Undocumented 2 | :: 54 | 2639 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989549.7171 | 2097348.9516 | 37.738318851123 | -122.47866713334 | (37.738318851123, -122.47866713334) | |||
41897 | 41897 | 183464 | Undocumented 2 | :: 54 | 2531 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988282.4359 | 2098065.1404 | 37.7402116561415 | -122.48310119578899 | (37.7402116561415, -122.483101195789) | |||
42045 | 42045 | 182773 | Undocumented 2 | :: 54 | 1 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985975.4571 | 2103368.6441 | 37.754639125693004 | -122.491467955558 | (37.754639125693, -122.491467955558) | |||
42137 | 42137 | 186840 | Undocumented 2 | :: 54 | 1201 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984884.6409 | 2106758.5555 | 37.763883073514 | -122.495490239842 | (37.763883073514, -122.495490239842) | |||
42396 | 42396 | 182857 | Undocumented 2 | :: 54 | 1831 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987811.1769 | 2102813.9565 | 37.7532232065184 | -122.48507892882799 | (37.7532232065184, -122.485078928828) | |||
42428 | 42428 | 182736 | Undocumented 2 | :: 54 | 1774 20th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5990016.9739 | 2103305.1307 | 37.7547000810929 | -122.477486815427 | (37.7547000810929, -122.477486815427) | |||
42457 | 42457 | 184588 | Undocumented 2 | :: 54 | 1723 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982824.9397 | 2103383.4877 | 37.7544952710451 | -122.502364209058 | (37.7544952710451, -122.502364209058) | |||
42573 | 42573 | 182319 | Undocumented 2 | :: 54 | 1501 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985874.6235 | 2104973.8958 | 37.7590408120895 | -122.491934836437 | (37.7590408120895, -122.491934836437) | |||
42757 | 42757 | 182330 | Undocumented 2 | :: 54 | 3120 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985138.9314 | 2105023.6395 | 37.7591343651634 | -122.494482837454 | (37.7591343651634, -122.494482837454) | |||
42791 | 42791 | 182422 | Undocumented 2 | :: 54 | 1534 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987477.4649 | 2104817.3887 | 37.7587046434176 | -122.486380033207 | (37.7587046434176, -122.486380033207) | |||
42813 | 42813 | 182514 | Undocumented 2 | :: 54 | 1575 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985890.3628 | 2104523.9893 | 37.7578064129674 | -122.49184728132799 | (37.7578064129674, -122.491847281328) | |||
43339 | 43339 | 182305 | Undocumented 2 | :: 54 | 2529 Kirkham St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986947.9231 | 2105031.9269 | 37.759262826435105 | -122.488227172206 | (37.7592628264351, -122.488227172206) | |||
43847 | 43847 | 181818 | Undocumented 2 | :: 54 | 2307 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986989.3892 | 2099545.2768 | 37.7442003877225 | -122.48768068299101 | (37.7442003877225, -122.487680682991) | |||
44106 | 44106 | 184328 | Undocumented 2 | :: 54 | 1575 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984652.0721 | 2104463.2019 | 37.7575670538887 | -122.496125256234 | (37.7575670538887, -122.496125256234) | |||
44554 | 44554 | 183800 | Undocumented 2 | :: 54 | 2211 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989761.061000001 | 2100288.9544 | 37.7464036034859 | -122.47815131175 | (37.7464036034859, -122.47815131175) | |||
44627 | 44627 | 183111 | Undocumented 2 | :: 54 | 2300 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984873.2377 | 2099291.2912 | 37.7433793578841 | -122.49497904251899 | (37.7433793578841, -122.494979042519) | |||
44962 | 44962 | 183726 | Undocumented 2 | :: 54 | 2255 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985429.7723 | 2099872.2292 | 37.7450070207391 | -122.493097502027 | (37.7450070207391, -122.493097502027) | |||
44995 | 44995 | 183721 | Undocumented 2 | :: 54 | 2263 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987911.8967 | 2099894.633 | 37.7452133904635 | -122.484516511954 | (37.7452133904635, -122.484516511954) | |||
45116 | 45116 | 185842 | Undocumented 2 | :: 54 | 2000 35th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985421.3197 | 2101412.6246 | 37.7492360339251 | -122.493240190301 | (37.7492360339251, -122.493240190301) | |||
45842 | 45842 | 182435 | Undocumented 2 | :: 54 | 1548 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984999.8767 | 2104643.5178 | 37.7580825174014 | -122.494935720084 | (37.7580825174014, -122.494935720084) | |||
46100 | 46100 | 182867 | Undocumented 2 | :: 54 | 1841 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987504.2554 | 2102741.89 | 37.7530074484719 | -122.486135022058 | (37.7530074484719, -122.486135022058) | |||
46818 | 46818 | 184716 | Undocumented 2 | :: 54 | 1626 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983467.6072 | 2104060.8038 | 37.7563927317594 | -122.500191801751 | (37.7563927317594, -122.500191801751) | |||
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) | |||
48108 | 48108 | 184440 | Undocumented 2 | :: 54 | 2123 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982918.0057 | 2100651.7469 | 37.7470001399255 | -122.50184026169599 | (37.7470001399255, -122.501840261696) | |||
48113 | 48113 | 185273 | Undocumented 2 | :: 54 | 2601 Sunset Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985037.6088 | 2097007.6084 | 37.7371186003252 | -122.494242407159 | (37.7371186003252, -122.494242407159) | |||
48483 | 48483 | 184128 | Undocumented 2 | :: 54 | 1638 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985018.0427 | 2104046.1353 | 37.756443334108894 | -122.494828850894 | (37.7564433341089, -122.494828850894) | |||
49318 | 49318 | 182390 | Undocumented 2 | :: 54 | 1543 32nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986194.4001 | 2104722.3341 | 37.7583687789891 | -122.490810402719 | (37.7583687789891, -122.490810402719) | |||
49494 | 49494 | 182045 | Undocumented 2 | :: 54 | 1334 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987740.8439 | 2106201.6024 | 37.7625206645495 | -122.485570743348 | (37.7625206645495, -122.485570743348) | |||
49516 | 49516 | 182601 | Undocumented 2 | :: 54 | 1963 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985980.7032 | 2101872.2576 | 37.750530763347 | -122.491339684637 | (37.750530763347, -122.491339684637) | |||
49553 | 49553 | 182385 | Undocumented 2 | :: 54 | 1539 33rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985884.186000001 | 2104731.9425 | 37.75837703407 | -122.491883952425 | (37.75837703407, -122.491883952425) | |||
49703 | 49703 | 184647 | Undocumented 2 | :: 54 | 1690 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984101.4341 | 2103682.9001 | 37.75539229440621 | -122.497971934799 | (37.7553922944062, -122.497971934799) | |||
49826 | 49826 | 183146 | Undocumented 2 | :: 54 | 2314 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982075.842999999 | 2099327.1639 | 37.743313697016895 | -122.504654211145 | (37.7433136970169, -122.504654211145) | |||
49859 | 49859 | 184504 | Undocumented 2 | :: 54 | 1878 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981125.892999999 | 2102290.0468 | 37.751393015279 | -122.50815869964501 | (37.751393015279, -122.508158699645) | |||
49876 | 49876 | 183872 | Undocumented 2 | :: 54 | 2242 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986089.9368 | 2099969.9524 | 37.7453139300395 | -122.490821992849 | (37.7453139300395, -122.490821992849) | |||
49997 | 49997 | 182673 | Undocumented 2 | :: 54 | 1922 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985087.0294 | 2102098.149 | 37.7510987382424 | -122.494446682041 | (37.7510987382424, -122.494446682041) | |||
50275 | 50275 | 182418 | Undocumented 2 | :: 54 | 1548 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985307.4498 | 2104670.087 | 37.758173469260704 | -122.493873973925 | (37.7581734692607, -122.493873973925) | |||
50357 | 50357 | 182742 | Undocumented 2 | :: 54 | 1755 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985624.2032 | 2103263.7315 | 37.7543305319461 | -122.49267494208999 | (37.7543305319461, -122.49267494209) | |||
50392 | 50392 | 184096 | Undocumented 2 | :: 54 | 1606 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985012.6931 | 2104238.7207 | 37.756971807119896 | -122.494861550435 | (37.7569718071199, -122.494861550435) | |||
50452 | 50452 | 182564 | Undocumented 2 | :: 54 | 2122 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989402.8067 | 2098365.7306 | 37.741102131537396 | -122.479249432397 | (37.7411021315374, -122.479249432397) | |||
50929 | 50929 | 182727 | Undocumented 2 | :: 54 | 1730 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985973.2061 | 2103431.6741 | 37.7548120572609 | -122.491480379124 | (37.7548120572609, -122.491480379124) | |||
51111 | 51111 | 181786 | Undocumented 2 | :: 54 | 2825 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987226.2844 | 2098233.5539 | 37.7406125590653 | -122.486765258584 | (37.7406125590653, -122.486765258584) | |||
51444 | 51444 | 182242 | Undocumented 2 | :: 54 | 1434 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985282.2615 | 2105425.6988 | 37.760246695704296 | -122.49401677245301 | (37.7602466957043, -122.494016772453) | |||
51477 | 51477 | 183544 | Undocumented 2 | :: 54 | 2575 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987672.5493 | 2097766.1311 | 37.739355145969206 | -122.48518797755 | (37.7393551459692, -122.48518797755) | |||
51535 | 51535 | 183816 | Undocumented 2 | :: 54 | 2135 Rivera St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986457.7853 | 2100251.173 | 37.746107568513104 | -122.48957072678002 | (37.7461075685131, -122.48957072678) | |||
51748 | 51748 | 182738 | Undocumented 2 | :: 54 | 1750 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985355.8425 | 2103299.0495 | 37.754411810046896 | -122.493605590332 | (37.7544118100469, -122.493605590332) | |||
51779 | 51779 | 183592 | Undocumented 2 | :: 54 | 2626 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988353.2202 | 2097405.0036 | 37.738403211903204 | -122.482808088928 | (37.7384032119032, -122.482808088928) | |||
51854 | 51854 | 182375 | Undocumented 2 | :: 54 | 1538 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985927.969 | 2104741.9588 | 37.7584070950586 | -122.49173327092 | (37.7584070950586, -122.49173327092) | |||
51912 | 51912 | 182199 | Undocumented 2 | :: 54 | 1591 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986204.5539 | 2104437.5415 | 37.7575874100084 | -122.490754332257 | (37.7575874100084, -122.490754332257) | |||
52083 | 52083 | 182365 | Undocumented 2 | :: 54 | 1505 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985565.9373 | 2104941.1837 | 37.7589329459117 | -122.492999994431 | (37.7589329459117, -122.492999994431) | |||
52297 | 52297 | 184468 | Undocumented 2 | :: 54 | 2186 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982356.9023 | 2100241.9181 | 37.7458418878069 | -122.50375012897499 | (37.7458418878069, -122.503750128975) | |||
52308 | 52308 | 183503 | Undocumented 2 | :: 54 | 2542 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988332.5337 | 2097995.0598 | 37.7400221483249 | -122.482922844986 | (37.7400221483249, -122.482922844986) | |||
52521 | 52521 | 182484 | Undocumented 2 | :: 54 | 1562 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985312.4034 | 2104586.3263 | 37.757943775407 | -122.49385066992501 | (37.757943775407, -122.493850669925) | |||
52558 | 52558 | 184679 | Undocumented 2 | :: 54 | 1607 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984656.2433 | 2104224.5677 | 37.7569120750539 | -122.496093225509 | (37.7569120750539, -122.496093225509) | |||
52629 | 52629 | 182207 | Undocumented 2 | :: 54 | 1663 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989633.6964 | 2104035.9541 | 37.7566844794288 | -122.478865727381 | (37.7566844794288, -122.478865727381) | |||
52847 | 52847 | 185853 | Undocumented 2 | :: 54 | 2000 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984975.6848 | 2101206.0949 | 37.7486428848898 | -122.49476595568501 | (37.7486428848898, -122.494765955685) | |||
52866 | 52866 | 181852 | Undocumented 2 | :: 54 | 2300 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988276.9149 | 2099616.1762 | 37.74447007115221 | -122.48323394905 | (37.7444700711522, -122.48323394905) | |||
52890 | 52890 | 183830 | Undocumented 2 | :: 54 | 2211 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986661.7663 | 2100185.8819999998 | 37.7459402035788 | -122.48886059753401 | (37.7459402035788, -122.488860597534) | |||
53047 | 53047 | 182489 | Undocumented 2 | :: 54 | 1560 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985001.2277 | 2104569.6642 | 37.7578798150097 | -122.494925602413 | (37.7578798150097, -122.494925602413) | |||
53460 | 53460 | 183102 | Undocumented 2 | :: 54 | 2700 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984470.1676 | 2099559.0382 | 37.744090914234796 | -122.496392487045 | (37.7440909142348, -122.496392487045) | |||
53752 | 53752 | 183103 | Undocumented 2 | :: 54 | 3244 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982756.3936 | 2099499.1864 | 37.7438260327489 | -122.502313810049 | (37.7438260327489, -122.502313810049) | |||
54040 | 54040 | 185592 | Undocumented 2 | :: 54 | 2075 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986932.5999 | 2101154.4132 | 37.74861533272129 | -122.487995256723 | (37.7486153327213, -122.487995256723) | |||
54059 | 54059 | 185599 | Undocumented 2 | :: 54 | 1200 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989708.1577 | 2101099.3093 | 37.7486255543569 | -122.47839348828 | (37.7486255543569, -122.47839348828) | |||
54106 | 54106 | 182574 | Undocumented 2 | :: 54 | 2243 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989005.4575 | 2098295.1152 | 37.740885154470504 | -122.480618138278 | (37.7408851544705, -122.480618138278) | |||
54127 | 54127 | 182227 | Undocumented 2 | :: 54 | 1674 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989678.7682 | 2103960.5181 | 37.7564799694095 | -122.478704337689 | (37.7564799694095, -122.478704337689) | |||
54871 | 54871 | 200168 | Undocumented 2 | :: 54 | 1101 Gilman Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014990.039 | 2089901.3883 | 37.7193136223873 | -122.390186075408 | (37.7193136223873, -122.390186075408) | |||
54992 | 54992 | 184123 | Undocumented 2 | :: 54 | 1566 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981590.4236 | 2104415.5069999998 | 37.7572562892484 | -122.50670995310101 | (37.7572562892484, -122.506709953101) | |||
55350 | 55350 | 183772 | Undocumented 2 | :: 54 | 2287 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986678.1958 | 2099700.8937 | 37.7446095144634 | -122.488768144161 | (37.7446095144634, -122.488768144161) | |||
55399 | 55399 | 183833 | Undocumented 2 | :: 54 | 2230 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986706.5739 | 2100065.9685 | 37.7456135681605 | -122.488696848573 | (37.7456135681605, -122.488696848573) | |||
55449 | 55449 | 183888 | Undocumented 2 | :: 54 | 1390 Quintara St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988941.521000001 | 2101013.106 | 37.7483443270077 | -122.48103816738501 | (37.7483443270077, -122.481038167385) | |||
55459 | 55459 | 183884 | Undocumented 2 | :: 54 | 2130 24th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988848.761 | 2100992.7334 | 37.748282996547104 | -122.48135743371799 | (37.7482829965471, -122.481357433718) | |||
55474 | 55474 | 181819 | Undocumented 2 | :: 54 | 2201 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985981.0614 | 2099553.9065 | 37.7441652190549 | -122.49116784768299 | (37.7441652190549, -122.491167847683) | |||
55660 | 55660 | 183984 | Undocumented 2 | :: 54 | 2420 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986737.6029 | 2103717.4696 | 37.755641413652 | -122.488857926532 | (37.755641413652, -122.488857926532) | |||
55794 | 55794 | 183502 | Undocumented 2 | :: 54 | 2535 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987043.8814 | 2097999.1529 | 37.739958320304495 | -122.48737871628 | (37.7399583203045, -122.48737871628) | |||
55807 | 55807 | 184469 | Undocumented 2 | :: 54 | 2182 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981423.7042 | 2100234.3036 | 37.74576606648579 | -122.506976375045 | (37.7457660664858, -122.506976375045) | |||
55821 | 55821 | 183882 | Undocumented 2 | :: 54 | 2130 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988852.1343 | 2100932.014 | 37.748116473268105 | -122.48134132315599 | (37.7481164732681, -122.481341323156) | |||
56203 | 56203 | 183446 | Undocumented 2 | :: 54 | 2511 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988279.6214 | 2098205.3016 | 37.7405963382743 | -122.483121197886 | (37.7405963382743, -122.483121197886) | |||
56611 | 56611 | 183788 | Undocumented 2 | :: 54 | 2286 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985480.1275 | 2099672.9424 | 37.7444627779419 | -122.492908708843 | (37.7444627779419, -122.492908708843) | |||
56730 | 56730 | 182273 | Undocumented 2 | :: 54 | 1476 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984979.982000001 | 2105177.4437 | 37.759547364784005 | -122.49504389343001 | (37.759547364784, -122.49504389343) |
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");