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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181267 | 181267 | 182396 | Undocumented 2 | :: 54 | 1522 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985925.6496 | 2104840.5319999997 | 37.7586776143061 | -122.491748548818 | (37.7586776143061, -122.491748548818) | |||
| 181084 | 181084 | 182237 | Undocumented 2 | :: 54 | 1435 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986169.2544 | 2105448.3009 | 37.760360614583995 | -122.490950787293 | (37.760360614584, -122.490950787293) | |||
| 181014 | 181014 | 182208 | Undocumented 2 | :: 54 | 1666 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989675.9216 | 2104008.911 | 37.7566126781149 | -122.47871772119301 | (37.7566126781149, -122.478717721193) | |||
| 180963 | 180963 | 182617 | Undocumented 2 | :: 54 | 1870 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986004.9641 | 2102510.2071 | 37.7522838165719 | -122.491302737104 | (37.7522838165719, -122.491302737104) | |||
| 180883 | 180883 | 184731 | Undocumented 2 | :: 54 | 1531 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981237.2508 | 2104496.4966 | 37.7574578608752 | -122.507937351177 | (37.7574578608752, -122.507937351177) | |||
| 180812 | 180812 | 182781 | Undocumented 2 | :: 54 | 1742 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985353.0616 | 2103349.1064 | 37.7545490898351 | -122.49361889547701 | (37.7545490898351, -122.493618895477) | |||
| 180796 | 180796 | 183719 | Undocumented 2 | :: 54 | 2262 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987954.1438 | 2099907.4352 | 37.7452510020103 | -122.484371369268 | (37.7452510020103, -122.484371369268) | |||
| 180769 | 180769 | 182537 | Undocumented 2 | :: 54 | 1586 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985941.1501 | 2104457.4168 | 37.7576265915257 | -122.491666739682 | (37.7576265915257, -122.491666739682) | |||
| 180718 | 180718 | 182713 | Undocumented 2 | :: 54 | 1718 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985659.6593 | 2103506.866 | 37.75500018565621 | -122.49257023245899 | (37.7550001856562, -122.492570232459) | |||
| 180716 | 180716 | 182582 | Undocumented 2 | :: 54 | 2274 20th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5990131.8885 | 2099913.0313 | 37.7453929349849 | -122.47684158440201 | (37.7453929349849, -122.476841584402) | |||
| 180436 | 180436 | 184397 | Undocumented 2 | :: 54 | 2048 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981217.0977 | 2101115.7232 | 37.748174027722996 | -122.50775617404601 | (37.748174027723, -122.507756174046) | |||
| 180411 | 180411 | 139043 | Undocumented 2 | :: 54 | 1434 BAKER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000190.2907 | 2114006.1429 | 37.7846674491742 | -122.443073307519 | (37.7846674491742, -122.443073307519) | |||
| 180171 | 180171 | 183754 | Undocumented 2 | :: 54 | 2275 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985433.1862 | 2099734.3927 | 37.7446287586395 | -122.49307554574 | (37.7446287586395, -122.49307554574) | |||
| 180164 | 180164 | 183139 | Undocumented 2 | :: 54 | 3539 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981846.5394 | 2099413.7013 | 37.7435378134359 | -122.505453483048 | (37.7435378134359, -122.505453483048) | |||
| 180034 | 180034 | 185789 | Undocumented 2 | :: 54 | 1915 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986592.7596 | 2102199.5729 | 37.751465228095796 | -122.489247237561 | (37.7514652280958, -122.489247237561) | |||
| 180018 | 180018 | 184711 | Undocumented 2 | :: 54 | 1619 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983422.7912 | 2104108.9895 | 37.756522405688294 | -122.500350351105 | (37.7565224056883, -122.500350351105) | |||
| 179934 | 179934 | 185601 | Undocumented 2 | :: 54 | 1200 Quintara St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989640.5487 | 2101098.6399 | 37.7486197911777 | -122.478627227884 | (37.7486197911777, -122.478627227884) | |||
| 179798 | 179798 | 184537 | Undocumented 2 | :: 54 | 1920 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981149.921 | 2101972.2688 | 37.750521902570604 | -122.50805202692601 | (37.7505219025706, -122.508052026926) | |||
| 179718 | 179718 | 182600 | Undocumented 2 | :: 54 | 1959 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985980.7032 | 2101896.5884 | 37.7505975691069 | -122.4913414752 | (37.7505975691069, -122.4913414752) | |||
| 179646 | 179646 | 140210 | Undocumented 2 | :: 54 | 890 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003670.0896 | 2110760.6625 | 37.7759539617211 | -122.43080267947701 | (37.7759539617211, -122.430802679477) | |||
| 179549 | 179549 | 183170 | Undocumented 2 | :: 54 | 2382 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981781.9237 | 2098892.7996 | 37.74210375914 | -122.505638298262 | (37.74210375914, -122.505638298262) | |||
| 179440 | 179440 | 184117 | Undocumented 2 | :: 54 | 1631 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985595.1302 | 2104113.6739 | 37.7566625398685 | -122.49283808202401 | (37.7566625398685, -122.492838082024) | |||
| 179274 | 179274 | 137729 | Undocumented 2 | :: 54 | 618 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000125.9929 | 2110987.9102 | 37.7763764904093 | -122.443078919527 | (37.7763764904093, -122.443078919527) | |||
| 179241 | 179241 | 143066 | Undocumented 2 | :: 54 | 454 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010650.2813 | 2120338.1214 | 37.802644377560505 | -122.407331591384 | (37.8026443775605, -122.407331591384) | |||
| 179207 | 179207 | 200191 | Undocumented 2 | :: 54 | 981 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.39271586587799 | (37.7188778046353, -122.392715865878) | |||
| 179192 | 179192 | 182994 | Undocumented 2 | :: 54 | 2085 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989637.5208 | 2098316.5193 | 37.7409806392129 | -122.478434287218 | (37.7409806392129, -122.478434287218) | |||
| 179186 | 179186 | 181830 | Undocumented 2 | :: 54 | 2319 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987925.2947 | 2099497.0517 | 37.7441225177456 | -122.484441029001 | (37.7441225177456, -122.484441029001) | |||
| 179181 | 179181 | 181694 | Undocumented 2 | :: 54 | 1356 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982161.9827 | 2105857.6697 | 37.7612496970921 | -122.504840173741 | (37.7612496970921, -122.504840173741) | |||
| 179131 | 179131 | 184543 | Undocumented 2 | :: 54 | 3419 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983659.9786 | 2103558.2129 | 37.7550240466182 | -122.499489383511 | (37.7550240466182, -122.499489383511) | |||
| 179075 | 179075 | 200190 | Undocumented 2 | :: 54 | 1027 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014706.6607 | 2089771.6044 | 37.7189415394071 | -122.391156549139 | (37.7189415394071, -122.391156549139) | |||
| 179050 | 179050 | 186412 | Undocumented 2 | :: 54 | 1601 Sunset Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984810.0324 | 2103749.2702 | 37.7556160465723 | -122.49552631838101 | (37.7556160465723, -122.495526318381) | |||
| 179024 | 179024 | 183804 | Undocumented 2 | :: 54 | 2222 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986395.9083 | 2100109.0691 | 37.745713776729204 | -122.489774237646 | (37.7457137767292, -122.489774237646) | |||
| 178952 | 178952 | 183207 | Undocumented 2 | :: 54 | 2487 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981762.9721 | 2098176.699 | 37.7401364295663 | -122.505650753582 | (37.7401364295663, -122.505650753582) | |||
| 178904 | 178904 | 183885 | Undocumented 2 | :: 54 | 1390 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988878.4835 | 2101013.894 | 37.7483428259954 | -122.481256204658 | (37.7483428259954, -122.481256204658) | |||
| 178886 | 178886 | 183351 | Undocumented 2 | :: 54 | 1214 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981199.8295 | 2106780.9272 | 37.7637280462203 | -122.508236325462 | (37.7637280462203, -122.508236325462) | |||
| 178876 | 178876 | 200201 | Undocumented 2 | :: 54 | 1090 Ingerson Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6013694.5474 | 2090234.3998 | 37.7201560648851 | -122.394687445541 | (37.7201560648851, -122.394687445541) | |||
| 178857 | 178857 | 184230 | Undocumented 2 | :: 54 | 1523 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983710.501 | 2104758.2068 | 37.758321858209705 | -122.499403338684 | (37.7583218582097, -122.499403338684) | |||
| 178846 | 178846 | 184127 | Undocumented 2 | :: 54 | 1638 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985330.3253 | 2104050.8162 | 37.7564744613327 | -122.493749228243 | (37.7564744613327, -122.493749228243) | |||
| 178812 | 178812 | 182798 | Undocumented 2 | :: 54 | 1806 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988376.3537 | 2103110.8519 | 37.7540713068505 | -122.48314621685199 | (37.7540713068505, -122.483146216852) | |||
| 178783 | 178783 | 182395 | Undocumented 2 | :: 54 | 1523 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986191.7973 | 2104845.1708 | 37.758705902690004 | -122.490828442707 | (37.75870590269, -122.490828442707) | |||
| 178767 | 178767 | 184707 | Undocumented 2 | :: 54 | 1619 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984661.2977 | 2104146.0554 | 37.756696798141704 | -122.496069953638 | (37.7566967981417, -122.496069953638) | |||
| 178736 | 178736 | 182521 | Undocumented 2 | :: 54 | 2330 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5986994.5572 | 2104405.9226 | 37.7575467105125 | -122.4880198933 | (37.7575467105125, -122.4880198933) | |||
| 178713 | 178713 | 183855 | Undocumented 2 | :: 54 | 2241 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987598.6707 | 2100013.2663 | 37.7455208807753 | -122.48560828516199 | (37.7455208807753, -122.485608285162) | |||
| 178406 | 178406 | 181590 | Undocumented 2 | :: 54 | 1651 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984667.3631 | 2103944.5517 | 37.7561438801895 | -122.496034112265 | (37.7561438801895, -122.496034112265) | |||
| 178394 | 178394 | 182815 | Undocumented 2 | :: 54 | 2111 Noriega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987460.7639 | 2102999.1421 | 37.753711258436496 | -122.486304306666 | (37.7537112584365, -122.486304306666) | |||
| 178356 | 178356 | 184488 | Undocumented 2 | :: 54 | 1850 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981108.2951 | 2102469.7488 | 37.7518853891009 | -122.508232891189 | (37.7518853891009, -122.508232891189) | |||
| 178348 | 178348 | 183841 | Undocumented 2 | :: 54 | 2222 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987945.6091 | 2100141.7146 | 37.745893774112794 | -122.48441806049802 | (37.7458937741128, -122.484418060498) | |||
| 178220 | 178220 | 199651 | Undocumented 2 | :: 54 | 0 | 37 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.37930996579901 | (37.7414476037323, -122.379309965799) | |||
| 178187 | 178187 | 183735 | Undocumented 2 | :: 54 | 2267 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5986977.5528 | 2099855.5864 | 37.745051724667704 | -122.487744403411 | (37.7450517246677, -122.487744403411) | |||
| 178183 | 178183 | 184327 | Undocumented 2 | :: 54 | 1566 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983143.5077 | 2104481.5092 | 37.7575288427339 | -122.50134375171899 | (37.7575288427339, -122.501343751719) | |||
| 178156 | 178156 | 184730 | Undocumented 2 | :: 54 | 1526 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981274.3167 | 2104688.5654 | 37.7579874108033 | -122.507823417876 | (37.7579874108033, -122.507823417876) | |||
| 178152 | 178152 | 183323 | Undocumented 2 | :: 54 | 3939 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983462.9029 | 2106952.2791 | 37.7643316308855 | -122.50042184841499 | (37.7643316308855, -122.500421848415) | |||
| 178140 | 178140 | 184288 | Undocumented 2 | :: 54 | 1514 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983440.9844 | 2104806.182 | 37.7584377683924 | -122.500338977609 | (37.7584377683924, -122.500338977609) | |||
| 178130 | 178130 | 182483 | Undocumented 2 | :: 54 | 1555 32nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986198.1756 | 2104640.4864 | 37.75814426828779 | -122.49079132320699 | (37.7581442682878, -122.490791323207) | |||
| 178124 | 178124 | 140889 | Undocumented 2 | :: 54 | 145 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996520.3624 | 2113408.7259 | 37.7828171689042 | -122.455726761043 | (37.7828171689042, -122.455726761043) | |||
| 177991 | 177991 | 182247 | Undocumented 2 | :: 54 | 1454 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985597.5878 | 2105309.9322 | 37.759947278047 | -122.49291769541 | (37.759947278047, -122.49291769541) | |||
| 177981 | 177981 | 183947 | Undocumented 2 | :: 54 | 2120 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988542.4631 | 2100855.2119 | 37.7478875858683 | -122.482406515958 | (37.7478875858683, -122.482406515958) | |||
| 177963 | 177963 | 182288 | Undocumented 2 | :: 54 | 3030 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985434.4119 | 2105030.9897 | 37.7591718355254 | -122.49346148109801 | (37.7591718355254, -122.493461481098) | |||
| 177950 | 177950 | 181597 | Undocumented 2 | :: 54 | 1402 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981283.949 | 2105512.8626 | 37.7602512624102 | -122.507851276945 | (37.7602512624102, -122.507851276945) | |||
| 177939 | 177939 | 200226 | Undocumented 2 | :: 54 | 1131 Fitzgerald Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6015013.4132 | 2090222.9153 | 37.720197768832605 | -122.390127728915 | (37.7201977688326, -122.390127728915) | |||
| 177846 | 177846 | 200172 | Undocumented 2 | :: 54 | 1053 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014576.5414 | 2089866.8464 | 37.7191958334242 | -122.391612979464 | (37.7191958334242, -122.391612979464) | |||
| 177826 | 177826 | 140999 | Undocumented 2 | :: 54 | 2425 GEARY BLVD | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000127.896000001 | 2113280.4932 | 37.7826714447065 | -122.44323703523399 | (37.7826714447065, -122.443237035234) | |||
| 177805 | 177805 | 200235 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014534.9569 | 2089547.5847 | 37.7183168953073 | -122.39173441165 | (37.7183168953073, -122.39173441165) | |||
| 177647 | 177647 | 142121 | Undocumented 2 | :: 54 | 21 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998615.422 | 2110898.4587 | 37.7760446351818 | -122.448297942425 | (37.7760446351818, -122.448297942425) | |||
| 177524 | 177524 | 182415 | Undocumented 2 | :: 54 | 1547 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985885.6405 | 2104698.4706 | 37.7582852144834 | -122.49187645799 | (37.7582852144834, -122.49187645799) | |||
| 177438 | 177438 | 141428 | Undocumented 2 | :: 54 | 321 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005839.6607 | 2110854.2085 | 37.7763334991213 | -122.423304209584 | (37.7763334991213, -122.423304209584) | |||
| 177358 | 177358 | 200205 | Undocumented 2 | :: 54 | 1003 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014813.9755 | 2089679.7161 | 37.71869518696921 | -122.39077918277701 | (37.7186951869692, -122.390779182777) | |||
| 177239 | 177239 | 143326 | Undocumented 2 | :: 54 | 771 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009948.2831 | 2118449.9038 | 37.7974204821659 | -122.40962751849399 | (37.7974204821659, -122.409627518494) | |||
| 177066 | 177066 | 245469 | Undocumented 2 | :: 54 | 3290 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6006288.2664 | 2099127.398 | 37.744159724830105 | -122.42091957583901 | (37.7441597248301, -122.420919575839) | |||
| 177054 | 177054 | 183851 | Undocumented 2 | :: 54 | 2235 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986665.607000001 | 2100041.6444 | 37.7455443899531 | -122.48883671629999 | (37.7455443899531, -122.4888367163) | |||
| 176960 | 176960 | 182283 | Undocumented 2 | :: 54 | 1480 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984982.9221 | 2105136.6498 | 37.759435528213295 | -122.49503071720501 | (37.7594355282133, -122.495030717205) | |||
| 176910 | 176910 | 200204 | Undocumented 2 | :: 54 | 2 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014372.6432 | 2089670.326 | 37.71864490712711 | -122.392304046142 | (37.7186449071271, -122.392304046142) | |||
| 176831 | 176831 | 184891 | Undocumented 2 | :: 54 | 1201 Sunset Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984723.2958 | 2106746.9726 | 37.7638418212229 | -122.49604742094299 | (37.7638418212229, -122.496047420943) | |||
| 176810 | 176810 | 182055 | Undocumented 2 | :: 54 | 1358 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987435.6115 | 2106037.3813 | 37.76205196967079 | -122.486614358562 | (37.7620519696708, -122.486614358562) | |||
| 176664 | 176664 | 181595 | Undocumented 2 | :: 54 | 1683 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984673.7654 | 2103756.5264 | 37.7556279898559 | -122.49599810063299 | (37.7556279898559, -122.495998100633) | |||
| 176648 | 176648 | 183781 | Undocumented 2 | :: 54 | 2295 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986367.3168 | 2099685.7445 | 37.744549771612704 | -122.489841973477 | (37.7445497716127, -122.489841973477) | |||
| 176607 | 176607 | 181872 | Undocumented 2 | :: 54 | 2330 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985803.3054 | 2099347.2154 | 37.7435873132981 | -122.491767267489 | (37.7435873132981, -122.491767267489) | |||
| 176590 | 176590 | 182501 | Undocumented 2 | :: 54 | 1571 32nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986201.2632 | 2104545.9513 | 37.757884881279104 | -122.490773689302 | (37.7578848812791, -122.490773689302) | |||
| 176500 | 176500 | 182653 | Undocumented 2 | :: 54 | 1867 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986887.7244 | 2102551.4802 | 37.752448683587204 | -122.488253085126 | (37.7524486835872, -122.488253085126) | |||
| 176452 | 176452 | 200497 | Undocumented 2 | :: 54 | 1110 Gilman Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014977.2953 | 2089975.1673 | 37.7195154981888 | -122.39023527774799 | (37.7195154981888, -122.390235277748) | |||
| 176431 | 176431 | 183053 | Undocumented 2 | :: 54 | 2601 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5990456.6898 | 2097547.4037 | 37.738916368412106 | -122.47554578609 | (37.7389163684121, -122.47554578609) | |||
| 176424 | 176424 | 184124 | Undocumented 2 | :: 54 | 1639 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985907.4128 | 2104065.5276 | 37.7565485998964 | -122.491754566542 | (37.7565485998964, -122.491754566542) | |||
| 176249 | 176249 | 184692 | Undocumented 2 | :: 54 | 3545 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983219.9396 | 2104221.872 | 37.7568204402945 | -122.50106022131 | (37.7568204402945, -122.50106022131) | |||
| 176078 | 176078 | 182726 | Undocumented 2 | :: 54 | 1738 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987522.687999999 | 2103443.5293 | 37.754935034598205 | -122.48612278117399 | (37.7549350345982, -122.486122781174) | |||
| 175934 | 175934 | 140091 | Undocumented 2 | :: 54 | 1250 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001831.6388 | 2112795.421 | 37.781436562836106 | -122.43730807844801 | (37.7814365628361, -122.437308078448) | |||
| 175484 | 175484 | 184095 | Undocumented 2 | :: 54 | 1611 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985901.3945 | 2104240.0581 | 37.757027460882 | -122.49178822773099 | (37.757027460882, -122.491788227731) | |||
| 175461 | 175461 | 182445 | Undocumented 2 | :: 54 | 1530 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985616.5233 | 2104773.8077 | 37.7584763359765 | -122.492812718757 | (37.7584763359765, -122.492812718757) | |||
| 175373 | 175373 | 182291 | Undocumented 2 | :: 54 | 1506 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988088.5469 | 2105026.3614 | 37.759314025449 | -122.484281984165 | (37.759314025449, -122.484281984165) | |||
| 175149 | 175149 | 139288 | Undocumented 2 | :: 54 | 850 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6003023.9373 | 2111228.5503 | 37.7772020350349 | -122.433071323703 | (37.7772020350349, -122.433071323703) | |||
| 175087 | 175087 | 181959 | Undocumented 2 | :: 54 | 2463 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987337.2868 | 2098513.0903 | 37.7413865628432 | -122.48640197789301 | (37.7413865628432, -122.486401977893) | |||
| 175076 | 175076 | 183866 | Undocumented 2 | :: 54 | 2246 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987024.9208 | 2099969.9524 | 37.7453685059232 | -122.487589015437 | (37.7453685059232, -122.487589015437) | |||
| 174998 | 174998 | 184611 | DPW Maintained 3 | :: 54 | 3800x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5982199.0286 | 2102854.3652 | 37.753005653234204 | -122.504489538097 | (37.7530056532342, -122.504489538097) | |||
| 174948 | 174948 | 200699 | Undocumented 2 | :: 54 | 1501 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6015860.7307 | 2095472.4329 | 37.734658863200295 | -122.38756485421699 | (37.7346588632003, -122.387564854217) | |||
| 174834 | 174834 | 217555 | Undocumented 2 | :: 54 | 240 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5994537.6064 | 2088112.0778 | 37.713244974869 | -122.46075236939899 | (37.713244974869, -122.460752369399) | |||
| 174563 | 174563 | 182322 | Undocumented 2 | :: 54 | 2935 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985680.9561 | 2104986.6523 | 37.759064515977705 | -122.49260555988998 | (37.7590645159777, -122.49260555989) | |||
| 174502 | 174502 | 183986 | Undocumented 2 | :: 54 | 1678 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985651.3009 | 2103798.7166 | 37.7558010384249 | -122.49262063086799 | (37.7558010384249, -122.492620630868) | |||
| 174451 | 174451 | 184706 | Undocumented 2 | :: 54 | 1614 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984085.5969 | 2104145.8869 | 37.7566625986032 | -122.49806089331999 | (37.7566625986032, -122.49806089332) | |||
| 174225 | 174225 | 184482 | Undocumented 2 | :: 54 | 2019 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982585.5063 | 2101354.8182 | 37.748911041069796 | -122.503042038753 | (37.7489110410698, -122.503042038753) | |||
| 174113 | 174113 | 183653 | Undocumented 2 | :: 54 | 4000 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982441.0975 | 2104931.8801 | 37.758724158208 | -122.503806282784 | (37.758724158208, -122.503806282784) | |||
| 174104 | 174104 | 184725 | Undocumented 2 | :: 54 | 1647 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984666.3522 | 2103976.5631 | 37.7562317154001 | -122.49603996978 | (37.7562317154001, -122.49603996978) |
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");