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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188170 | 188170 | 181697 | Undocumented 2 | :: 54 | 1360 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982163.8853 | 2105835.7898 | 37.761189733060704 | -122.50483197223 | (37.7611897330607, -122.50483197223) | |||
| 161554 | 161554 | 183621 | Undocumented 2 | :: 54 | 1434 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982180.4079 | 2105318.1983 | 37.7597695463285 | -122.504736476063 | (37.7597695463285, -122.504736476063) | |||
| 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) | |||
| 163149 | 163149 | 184728 | Undocumented 2 | :: 54 | 1622 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982226.4788 | 2104040.1069 | 37.7562629800448 | -122.504482451968 | (37.7562629800448, -122.504482451968) | |||
| 187448 | 187448 | 184439 | Undocumented 2 | :: 54 | 2131 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982299.7091 | 2100588.462 | 37.7467900380649 | -122.503973554813 | (37.7467900380649, -122.503973554813) | |||
| 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) | |||
| 134863 | 134863 | 184462 | Undocumented 2 | :: 54 | 2155 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982305.1238 | 2100432.4495 | 37.7463619895169 | -122.50394327821199 | (37.7463619895169, -122.503943278212) | |||
| 102427 | 102427 | 184466 | Undocumented 2 | :: 54 | 2183 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982310.877 | 2100256.4702 | 37.745879137546204 | -122.503910352906 | (37.7458791375462, -122.503910352906) | |||
| 170209 | 170209 | 184473 | Undocumented 2 | :: 54 | 2191 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982313.2459 | 2100207.399 | 37.7457445409505 | -122.503898527906 | (37.7457445409505, -122.503898527906) | |||
| 67598 | 67598 | 183656 | Undocumented 2 | :: 54 | 4000 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982355.2044 | 2104927.0637 | 37.758705882923 | -122.50410297872801 | (37.758705882923, -122.504102978728) | |||
| 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) | |||
| 168190 | 168190 | 183164 | Undocumented 2 | :: 54 | 2410 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982410.373 | 2098682.978 | 37.7415646129837 | -122.50344982148899 | (37.7415646129837, -122.503449821489) | |||
| 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) | |||
| 147560 | 147560 | 183654 | Undocumented 2 | :: 54 | 4000 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982417.4167 | 2104930.2746 | 37.7587183575205 | -122.503888061559 | (37.7587183575205, -122.503888061559) | |||
| 135388 | 135388 | 183142 | Undocumented 2 | :: 54 | 3341 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982435.8047 | 2099431.6296 | 37.743621698860295 | -122.503417311271 | (37.7436216988603, -122.503417311271) | |||
| 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) | |||
| 37539 | 37539 | 184416 | Undocumented 2 | :: 54 | 3535 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982452.1681 | 2100793.038 | 37.7473607109551 | -122.50346152129801 | (37.7473607109551, -122.503461521298) | |||
| 50143 | 50143 | 183305 | Undocumented 2 | :: 54 | 1270 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982452.2839 | 2106459.7636 | 37.7629199491975 | -122.50388075683901 | (37.7629199491975, -122.503880756839) | |||
| 137163 | 137163 | 184290 | Undocumented 2 | :: 54 | 1535 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982472.3445 | 2104651.9336 | 37.757957341688396 | -122.503677486302 | (37.7579573416884, -122.503677486302) | |||
| 170384 | 170384 | 184150 | Undocumented 2 | :: 54 | 1585 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982480.9001 | 2104357.3743 | 37.75714906821929 | -122.503626084685 | (37.7571490682193, -122.503626084685) | |||
| 36620 | 36620 | 184152 | Undocumented 2 | :: 54 | 1585 44th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982483.9557 | 2104316.7349 | 37.7570376635662 | -122.503612507973 | (37.7570376635662, -122.503612507973) | |||
| 172398 | 172398 | 184642 | Undocumented 2 | :: 54 | 1650 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982542.5956 | 2103869.9019 | 37.7558142337398 | -122.50337662716001 | (37.7558142337398, -122.50337662716) | |||
| 84556 | 84556 | 115963 | Undocumented 2 | :: 54 | 847 43RD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585.0 | 2109998.0 | 37.7726427311472 | -122.50368379034599 | (37.7726427311472, -122.503683790346) | ||
| 93014 | 93014 | 115931 | Undocumented 2 | :: 54 | 847 43RD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585.0 | 2109998.0 | 37.7726427311472 | -122.50368379034599 | (37.7726427311472, -122.503683790346) | ||
| 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) | |||
| 64935 | 64935 | 184387 | Undocumented 2 | :: 54 | 2027 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982586.1831 | 2101310.4849 | 37.7487893539542 | -122.503036416733 | (37.7487893539542, -122.503036416733) | |||
| 161086 | 161086 | 184460 | Undocumented 2 | :: 54 | 2179 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982619.5177 | 2100295.7271 | 37.7460050700863 | -122.502846039592 | (37.7460050700863, -122.502846039592) | |||
| 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) | |||
| 184360 | 184360 | 183098 | Undocumented 2 | :: 54 | 2243 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982634.3107 | 2099839.8811 | 37.744754312497896 | -122.502761151096 | (37.7447543124979, -122.502761151096) | |||
| 73668 | 73668 | 184458 | Undocumented 2 | :: 54 | 2154 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982659.113 | 2100453.0933 | 37.7464394810524 | -122.502720773022 | (37.7464394810524, -122.502720773022) | |||
| 164529 | 164529 | 183341 | Undocumented 2 | :: 54 | 4211 Lincoln Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982665.5566 | 2106923.9454 | 37.7642069983045 | -122.50317750172199 | (37.7642069983045, -122.503177501722) | |||
| 160327 | 160327 | 183333 | Undocumented 2 | :: 54 | 1211 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.5384 | 2106850.7636 | 37.764008470840295 | -122.503030341532 | (37.7640084708403, -122.503030341532) | |||
| 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) | |||
| 162629 | 162629 | 183334 | Undocumented 2 | :: 54 | 1211 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.9565 | 2106844.4908 | 37.7639912720976 | -122.503028431048 | (37.7639912720976, -122.503028431048) | |||
| 74940 | 74940 | 183620 | Undocumented 2 | :: 54 | 1435 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982754.5672 | 2105435.1976 | 37.7601245522633 | -122.502759435641 | (37.7601245522633, -122.502759435641) | |||
| 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) | |||
| 171314 | 171314 | 184277 | Undocumented 2 | :: 54 | 1527 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982780.1956 | 2104700.8231 | 37.758109673863395 | -122.502616443283 | (37.7581096738634, -122.502616443283) | |||
| 36394 | 36394 | 184614 | DPW Maintained 3 | :: 54 | 3600x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5982812.7565 | 2102876.5318 | 37.7531025964328 | -122.502368824356 | (37.7531025964328, -122.502368824356) | |||
| 74529 | 74529 | 184571 | Undocumented 2 | :: 54 | 1711 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982821.5555 | 2103464.0321 | 37.7547162245081 | -122.50238187295099 | (37.7547162245081, -122.502381872951) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 114902 | 114902 | 183304 | Undocumented 2 | :: 54 | 1263 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983031.5884 | 2106472.5871 | 37.762989205720295 | -122.5018781248 | (37.7629892057203, -122.5018781248) | |||
| 64588 | 64588 | 183617 | Undocumented 2 | :: 54 | 1411 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983064.0231 | 2105493.3962 | 37.7603025305329 | -122.50169349836099 | (37.7603025305329, -122.501693498361) | |||
| 51211 | 51211 | 183619 | Undocumented 2 | :: 54 | 1415 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983065.6286 | 2105470.5181 | 37.760239808047295 | -122.501686253156 | (37.7602398080473, -122.501686253156) | |||
| 153683 | 153683 | 183615 | Undocumented 2 | :: 54 | 1407 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983066.03 | 2105519.8865 | 37.7603753832784 | -122.501688517419 | (37.7603753832784, -122.501688517419) | |||
| 187636 | 187636 | 183293 | Undocumented 2 | :: 54 | 1286 42nd Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983075.6533 | 2106421.6609 | 37.76285196523921 | -122.50172195396401 | (37.7628519652392, -122.501721953964) | |||
| 59478 | 59478 | 183717 | Undocumented 2 | :: 54 | 1335 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983090.7026 | 2106024.057 | 37.7617611417836 | -122.501640487706 | (37.7617611417836, -122.501640487706) | |||
| 187627 | 187627 | 184329 | Undocumented 2 | :: 54 | 1571 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983101.4912 | 2104441.3261 | 37.757416043664996 | -122.501486086821 | (37.757416043665, -122.501486086821) | |||
| 39530 | 39530 | 184555 | Undocumented 2 | :: 54 | 3601 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983107.8094 | 2103539.071 | 37.754939075681705 | -122.50139749571501 | (37.7549390756817, -122.501397495715) | |||
| 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) | |||
| 49049 | 49049 | 184689 | Undocumented 2 | :: 54 | 1604 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983149.1774 | 2104191.5453 | 37.756733016388395 | -122.501302696027 | (37.7567330163884, -122.501302696027) | |||
| 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) | |||
| 162421 | 162421 | 184690 | Undocumented 2 | :: 54 | 3545 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983184.2215 | 2104221.535 | 37.75681741760479 | -122.501183720782 | (37.7568174176048, -122.501183720782) | |||
| 58153 | 58153 | 184163 | Undocumented 2 | :: 54 | 3544 Lawton St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983184.3019 | 2104274.4825 | 37.756962801278206 | -122.501187358865 | (37.7569628012782, -122.501187358865) | |||
| 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) | |||
| 57408 | 57408 | 184691 | Undocumented 2 | :: 54 | 3545 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983203.0915 | 2104221.1981 | 37.7568176006429 | -122.501118437486 | (37.7568176006429, -122.501118437486) | |||
| 33271 | 33271 | 184161 | Undocumented 2 | :: 54 | 3540 Lawton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983209.359 | 2104274.4825 | 37.7569642726582 | -122.501100703383 | (37.7569642726582, -122.501100703383) | |||
| 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) | |||
| 182702 | 182702 | 184160 | Undocumented 2 | :: 54 | 3538 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983222.1931 | 2104276.0104 | 37.75696922144979 | -122.50105643194999 | (37.7569692214498, -122.50105643195) | |||
| 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) | |||
| 165614 | 165614 | 184687 | Undocumented 2 | :: 54 | 3525 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983292.0496 | 2104225.2416 | 37.756833926206 | -122.50081109145799 | (37.756833926206, -122.500811091458) | |||
| 171383 | 171383 | 183348 | Undocumented 2 | :: 54 | 1222 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983373.4277 | 2106798.2891 | 37.76390356553 | -122.500719925068 | (37.76390356553, -122.500719925068) | |||
| 39908 | 39908 | 183623 | Undocumented 2 | :: 54 | 1443 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983380.9044 | 2105304.9531 | 37.7598037265775 | -122.50058363770201 | (37.7598037265775, -122.500583637702) | |||
| 40193 | 40193 | 183285 | Undocumented 2 | :: 54 | 1266 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983382.4298 | 2106528.4997 | 37.763163328933295 | -122.50066883897 | (37.7631633289333, -122.50066883897) | |||
| 92619 | 92619 | 115024 | Permitted Site 1 | :: 54 | 2500 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 5983385.7 | 2098079.0 | 37.739963544351504 | -122.500032889381 | (37.7399635443515, -122.500032889381) | ||||
| 108695 | 108695 | 183326 | Undocumented 2 | :: 54 | 3955 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983391.4319 | 2106949.9604 | 37.764321068800605 | -122.500668871108 | (37.7643210688006, -122.500668871108) | |||
| 60397 | 60397 | 184231 | Undocumented 2 | :: 54 | 1523 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983398.5095 | 2104764.9295 | 37.758322007374204 | -122.500482822231 | (37.7583220073742, -122.500482822231) | |||
| 168394 | 168394 | 184302 | Undocumented 2 | :: 54 | 1555 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983405.8433 | 2104564.4726 | 37.7577720395933 | -122.50044263805 | (37.7577720395933, -122.50044263805) | |||
| 74645 | 74645 | 184293 | Undocumented 2 | :: 54 | 1547 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983406.1489 | 2104611.5311 | 37.757901266946504 | -122.500445060495 | (37.7579012669465, -122.500445060495) | |||
| 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) | |||
| 35894 | 35894 | 183324 | Undocumented 2 | :: 54 | 3945 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983417.0741 | 2106949.5512 | 37.7643214505987 | -122.50058015311001 | (37.7643214505987, -122.50058015311) | |||
| 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) | |||
| 40829 | 40829 | 184609 | DPW Maintained 3 | :: 54 | 3400x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5983436.8063 | 2102896.8371 | 37.7531949966988 | -122.500212272852 | (37.7531949966988, -122.500212272852) | |||
| 135081 | 135081 | 183325 | Undocumented 2 | :: 54 | 3945 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983437.8062 | 2106951.4607 | 37.764327910588 | -122.50050858895 | (37.764327910588, -122.50050858895) | |||
| 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) | |||
| 163297 | 163297 | 184262 | Undocumented 2 | :: 54 | 1526 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983444.9569 | 2104728.5661 | 37.7582248901335 | -122.50031950085199 | (37.7582248901335, -122.500319500852) | |||
| 147093 | 147093 | 184276 | Undocumented 2 | :: 54 | 1534 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983446.4847 | 2104680.2853 | 37.7580924143073 | -122.500310647666 | (37.7580924143073, -122.500310647666) | |||
| 127201 | 127201 | 184591 | Undocumented 2 | :: 54 | 1751 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983451.02 | 2103228.4905 | 37.754106458672794 | -122.500187636281 | (37.7541064586728, -122.500187636281) | |||
| 150325 | 150325 | 184602 | Undocumented 2 | :: 54 | 1763 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983454.4042 | 2103150.315 | 37.7538920091964 | -122.500170154172 | (37.7538920091964, -122.500170154172) | |||
| 157623 | 157623 | 184139 | Undocumented 2 | :: 54 | 1582 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983456.1103 | 2104379.7529 | 37.757267801737 | -122.500255140579 | (37.757267801737, -122.500255140579) | |||
| 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) | |||
| 153222 | 153222 | 184710 | Undocumented 2 | :: 54 | 1622 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983465.9224 | 2104108.6525 | 37.7565240119929 | -122.50020116553301 | (37.7565240119929, -122.500201165533) | |||
| 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) | |||
| 130835 | 130835 | 184724 | Undocumented 2 | :: 54 | 1638 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983469.292 | 2103986.335 | 37.756188360185 | -122.50018047011801 | (37.756188360185, -122.500180470118) | |||
| 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) | |||
| 59566 | 59566 | 184641 | Undocumented 2 | :: 54 | 1654 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983473.6725 | 2103876.1482 | 37.7558860751921 | -122.500157175669 | (37.7558860751921, -122.500157175669) | |||
| 165021 | 165021 | 184664 | Undocumented 2 | :: 54 | 1666 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983476.0313 | 2103802.0164 | 37.7556826684626 | -122.50014353825199 | (37.7556826684626, -122.500143538252) | |||
| 147052 | 147052 | 184672 | Undocumented 2 | :: 54 | 1674 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983477.8846 | 2103750.9666 | 37.75554260877011 | -122.500133355329 | (37.7555426087701, -122.500133355329) | |||
| 156926 | 156926 | 184568 | Undocumented 2 | :: 54 | 1710 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983487.5696 | 2103476.8921 | 37.7547906452428 | -122.50007960245199 | (37.7547906452428, -122.500079602452) | |||
| 45638 | 45638 | 183321 | Undocumented 2 | :: 54 | 3927 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983491.8186 | 2106952.5519 | 37.7643340772207 | -122.50032185889098 | (37.7643340772207, -122.500321858891) | |||
| 39826 | 39826 | 183322 | Undocumented 2 | :: 54 | 3927 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983510.9139 | 2106953.643 | 37.764338193887504 | -122.50025589533001 | (37.7643381938875, -122.50025589533) | |||
| 132958 | 132958 | 184627 | DPW Maintained 3 | :: 54 | 3300x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5983533.5949 | 2102898.8676 | 37.7532062522999 | -122.499877713808 | (37.7532062522999, -122.499877713808) | |||
| 76975 | 76975 | 184546 | Undocumented 2 | :: 54 | 3445 Moraga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983564.2693 | 2103555.7588 | 37.7550116923713 | -122.499820187022 | (37.7550116923713, -122.499820187022) | |||
| 65019 | 65019 | 184544 | Undocumented 2 | :: 54 | 3425 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983632.4928 | 2103556.7404 | 37.755018390843894 | -122.499584326949 | (37.7550183908439, -122.499584326949) | |||
| 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) | |||
| 86957 | 86957 | 109262 | Permitted Site 1 | :: 54 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
| 113500 | 113500 | 109261 | Permitted Site 1 | :: 54 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) |
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");