trees
1,914 rows where qSpecies_id = 45 sorted by XCoord
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113 | 182915 | DPW Maintained 1 | :: 45 | 2711 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981812.2124 | 2096648.8938 | 37.7359443944789 | -122.505367292654 | (37.7359443944789, -122.505367292654) | 1 | 8 | 3 | 29491 | 35 | |||
| 109735 | 182933 | DPW Maintained 1 | :: 45 | 2646 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981845.0394 | 2097064.8142 | 37.7370883295038 | -122.505284615423 | (37.7370883295038, -122.505284615423) | 1 | 8 | 3 | 29491 | 35 | |||
| 26120 | 183139 | DPW Maintained 1 | :: 45 | 3539 Santiago St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981846.5394 | 2099413.7013 | 37.7435378134359 | -122.505453483048 | (37.7435378134359, -122.505453483048) | 1 | 8 | 3 | 29491 | 35 | |||
| 20028 | 182943 | DPW Maintained 1 | :: 45 | 2674 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981850.1157 | 2096894.2496 | 37.7366203046104 | -122.505254426993 | (37.7366203046104, -122.505254426993) | 1 | 8 | 3 | 29491 | 35 | |||
| 49932 | 182944 | DPW Maintained 1 | :: 45 | 2678 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981851.131 | 2096866.8374 | 37.7365450979685 | -122.505248885687 | (37.7365450979685, -122.505248885687) | 1 | 8 | 3 | 29491 | 35 | |||
| 81792 | 183138 | DPW Maintained 1 | :: 45 | 3521 Santiago St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981925.3562 | 2099416.4074 | 37.7435498815044 | -122.505181159302 | (37.7435498815044, -122.505181159302) | 1 | 8 | 3 | 29491 | 35 | |||
| 92987 | 184727 | DPW Maintained 1 | :: 45 | 3941 Lawton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981943.3641 | 2104178.2266 | 37.7566255609757 | -122.505471780608 | (37.7566255609757, -122.505471780608) | 1 | 8 | 3 | 56 | 35 | |||
| 39134 | 184894 | DPW Maintained 1 | :: 45 | 1784 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981950.5709 | 2102944.1962 | 37.7532376866007 | -122.505355395478 | (37.7532376866007, -122.505355395478) | 1 | 8 | 3 | 56 | 35 | |||
| 180791 | 184893 | DPW Maintained 1 | :: 45 | 1786 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981952.8719 | 2102926.7078 | 37.7531898037869 | -122.505346142178 | (37.7531898037869, -122.505346142178) | 1 | 8 | 3 | 56 | 35 | |||
| 21953 | 184892 | DPW Maintained 1 | :: 45 | 1788 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981953.7924 | 2102910.6002 | 37.753145631025 | -122.505341765185 | (37.753145631025, -122.505341765185) | 1 | 8 | 3 | 56 | 35 | |||
| 168723 | 184470 | DPW Maintained 1 | :: 45 | 2159 46th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981994.4526 | 2100401.9916 | 37.7462600872151 | -122.505015267826 | (37.7462600872151, -122.505015267826) | 1 | 8 | 3 | 29491 | 35 | |||
| 120288 | 182946 | DPW Maintained 1 | :: 45 | 3500 Wawona St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982068.7362 | 2096751.2664 | 37.7362405734928 | -122.504487984804 | (37.7362405734928, -122.504487984804) | 1 | 8 | 3 | 29491 | 35 | |||
| 391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 108799 | 183146 | DPW Maintained 1 | :: 45 | 2314 46th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982075.843 | 2099327.1639 | 37.7433136970169 | -122.504654211145 | (37.7433136970169, -122.504654211145) | 1 | 8 | 3 | 29491 | 35 | |||
| 182707 | 183266 | DPW Maintained 1 | :: 45 | 1235 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982090.5566 | 2106669.6909 | 37.7634750727275 | -122.50514738367 | (37.7634750727275, -122.50514738367) | 1 | 8 | 3 | 56 | 35 | |||
| 169192 | 182936 | DPW Maintained 1 | :: 45 | 2643 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982105.6241 | 2097104.0711 | 37.7372114482758 | -122.50438657909 | (37.7372114482758, -122.50438657909) | 1 | 8 | 3 | 29491 | 35 | |||
| 44848 | 183110 | DPW Maintained 1 | :: 45 | 3474 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982112.0542 | 2099478.6077 | 37.7437316497768 | -122.504540222201 | (37.7437316497768, -122.504540222201) | 1 | 8 | 3 | 29491 | 35 | |||
| 83574 | 183108 | DPW Maintained 1 | :: 45 | 3454 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982137.4358 | 2099478.9461 | 37.7437340718642 | -122.504452485254 | (37.7437340718642, -122.504452485254) | 1 | 8 | 3 | 29491 | 35 | |||
| 105039 | 183271 | DPW Maintained 1 | :: 45 | 1242 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982138.4385 | 2106630.5909 | 37.7633705325139 | -122.504978880674 | (37.7633705325139, -122.504978880674) | 1 | 8 | 3 | 56 | 35 | |||
| 80716 | 183268 | DPW Maintained 1 | :: 45 | 1254 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982139.2748 | 2106566.1909 | 37.763193757767 | -122.504971215621 | (37.763193757767, -122.504971215621) | 1 | 8 | 3 | 56 | 35 | |||
| 184197 | 183631 | DPW Maintained 1 | :: 45 | 1451 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982139.8696 | 2105211.8354 | 37.7594751192783 | -122.50486879402 | (37.7594751192783, -122.50486879402) | 1 | 8 | 3 | 56 | 35 | |||
| 180405 | 183621 | DPW Maintained 1 | :: 45 | 1434 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982180.4079 | 2105318.1983 | 37.7597695463285 | -122.504736476063 | (37.7597695463285, -122.504736476063) | 1 | 8 | 3 | 56 | 35 | |||
| 167367 | 184611 | DPW Maintained 1 | :: 45 | 3800x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5982199.0286 | 2102854.3652 | 37.7530056532342 | -122.504489538097 | (37.7530056532342, -122.504489538097) | 1 | 8 | 3 | 56 | 35 | |||
| 175033 | 184728 | DPW Maintained 1 | :: 45 | 1622 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982226.4788 | 2104040.1069 | 37.7562629800448 | -122.504482451968 | (37.7562629800448, -122.504482451968) | 1 | 8 | 3 | 56 | 35 | |||
| 48493 | 184439 | DPW Maintained 1 | :: 45 | 2131 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982299.7091 | 2100588.462 | 37.7467900380649 | -122.503973554813 | (37.7467900380649, -122.503973554813) | 1 | 8 | 3 | 29491 | 35 | |||
| 134225 | 184457 | DPW Maintained 1 | :: 45 | 2151 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982303.7701 | 2100458.8464 | 37.746434388466 | -122.503949913871 | (37.746434388466, -122.503949913871) | 1 | 8 | 3 | 29491 | 35 | |||
| 62232 | 184462 | DPW Maintained 1 | :: 45 | 2155 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982305.1238 | 2100432.4495 | 37.7463619895169 | -122.503943278212 | (37.7463619895169, -122.503943278212) | 1 | 8 | 3 | 29491 | 35 | |||
| 119248 | 184466 | DPW Maintained 1 | :: 45 | 2183 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982310.877 | 2100256.4702 | 37.7458791375462 | -122.503910352906 | (37.7458791375462, -122.503910352906) | 1 | 8 | 3 | 29491 | 35 | |||
| 131340 | 184473 | DPW Maintained 1 | :: 45 | 2191 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982313.2459 | 2100207.399 | 37.7457445409505 | -122.503898527906 | (37.7457445409505, -122.503898527906) | 1 | 8 | 3 | 29491 | 35 | |||
| 150659 | 183656 | DPW Maintained 1 | :: 45 | 4000 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982355.2044 | 2104927.0637 | 37.758705882923 | -122.504102978728 | (37.758705882923, -122.504102978728) | 1 | 8 | 3 | 56 | 35 | |||
| 52924 | 184468 | DPW Maintained 1 | :: 45 | 2186 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982356.9023 | 2100241.9181 | 37.7458418878069 | -122.503750128975 | (37.7458418878069, -122.503750128975) | 1 | 8 | 3 | 29491 | 35 | |||
| 113244 | 183164 | DPW Maintained 1 | :: 45 | 2410 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982410.373 | 2098682.978 | 37.7415646129837 | -122.503449821489 | (37.7415646129837, -122.503449821489) | 1 | 8 | 3 | 29491 | 35 | |||
| 234 | 183167 | DPW Maintained 1 | :: 45 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.7413295619026 | -122.503441142831 | (37.7413295619026, -122.503441142831) | 1 | 8 | 3 | 29491 | 35 | |||
| 127596 | 183654 | Undocumented 4 | :: 45 | 4000 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982417.4167 | 2104930.2746 | 37.7587183575205 | -122.503888061559 | (37.7587183575205, -122.503888061559) | 1 | 8 | 3 | 56 | 35 | |||
| 98929 | 183142 | DPW Maintained 1 | :: 45 | 3341 Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982435.8047 | 2099431.6296 | 37.7436216988603 | -122.503417311271 | (37.7436216988603, -122.503417311271) | 1 | 8 | 3 | 29491 | 35 | |||
| 30974 | 183653 | DPW Maintained 1 | :: 45 | 4000 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982441.0975 | 2104931.8801 | 37.758724158208 | -122.503806282784 | (37.758724158208, -122.503806282784) | 1 | 8 | 3 | 56 | 35 | |||
| 173169 | 184416 | DPW Maintained 1 | :: 45 | 3535 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982452.1681 | 2100793.038 | 37.7473607109551 | -122.503461521298 | (37.7473607109551, -122.503461521298) | 1 | 8 | 3 | 29491 | 35 | |||
| 151647 | 183305 | DPW Maintained 1 | :: 45 | 1270 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982452.2839 | 2106459.7636 | 37.7629199491975 | -122.503880756839 | (37.7629199491975, -122.503880756839) | 1 | 8 | 3 | 56 | 35 | |||
| 154090 | 184290 | DPW Maintained 1 | :: 45 | 1535 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982472.3445 | 2104651.9336 | 37.7579573416884 | -122.503677486302 | (37.7579573416884, -122.503677486302) | 1 | 8 | 3 | 56 | 35 | |||
| 175 | 184150 | DPW Maintained 1 | :: 45 | 1585 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982480.9001 | 2104357.3743 | 37.7571490682193 | -122.503626084685 | (37.7571490682193, -122.503626084685) | 1 | 8 | 3 | 56 | 35 | |||
| 302 | 184152 | DPW Maintained 1 | :: 45 | 1585 44th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982483.9557 | 2104316.7349 | 37.7570376635662 | -122.503612507973 | (37.7570376635662, -122.503612507973) | 1 | 8 | 3 | 56 | 35 | |||
| 138772 | 184642 | DPW Maintained 1 | :: 45 | 1650 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982542.5956 | 2103869.9019 | 37.7558142337398 | -122.50337662716 | (37.7558142337398, -122.50337662716) | 1 | 8 | 3 | 56 | 35 | |||
| 43484 | 115963 | Undocumented 4 | :: 45 | 847 43RD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585 | 2109998 | 37.7726427311472 | -122.503683790346 | (37.7726427311472, -122.503683790346) | 11 | 6 | 2 | 55 | 26 | ||
| 88587 | 115931 | Undocumented 4 | :: 45 | 847 43RD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585 | 2109998 | 37.7726427311472 | -122.503683790346 | (37.7726427311472, -122.503683790346) | 11 | 6 | 2 | 55 | 26 | ||
| 53028 | 184482 | DPW Maintained 1 | :: 45 | 2019 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982585.5063 | 2101354.8182 | 37.7489110410698 | -122.503042038753 | (37.7489110410698, -122.503042038753) | 1 | 8 | 3 | 29491 | 35 | |||
| 48098 | 184387 | DPW Maintained 1 | :: 45 | 2027 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982586.1831 | 2101310.4849 | 37.7487893539542 | -122.503036416733 | (37.7487893539542, -122.503036416733) | 1 | 8 | 3 | 29491 | 35 | |||
| 49305 | 184460 | DPW Maintained 1 | :: 45 | 2179 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982619.5177 | 2100295.7271 | 37.7460050700863 | -122.502846039592 | (37.7460050700863, -122.502846039592) | 1 | 8 | 3 | 29491 | 35 | |||
| 149151 | 184472 | DPW Maintained 1 | :: 45 | 2191 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982622.5635 | 2100219.2438 | 37.7457952471339 | -122.50282984708 | (37.7457952471339, -122.50282984708) | 1 | 8 | 3 | 29491 | 35 | |||
| 121345 | 184458 | DPW Maintained 1 | :: 45 | 2154 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982659.113 | 2100453.0933 | 37.7464394810524 | -122.502720773022 | (37.7464394810524, -122.502720773022) | 1 | 8 | 3 | 29491 | 35 | |||
| 148868 | 183341 | DPW Maintained 1 | :: 45 | 4211 Lincoln Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982665.5566 | 2106923.9454 | 37.7642069983045 | -122.503177501722 | (37.7642069983045, -122.503177501722) | 1 | 8 | 3 | 56 | 35 | |||
| 187644 | 183620 | DPW Maintained 1 | :: 45 | 1435 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982754.5672 | 2105435.1976 | 37.7601245522633 | -122.502759435641 | (37.7601245522633, -122.502759435641) | 1 | 8 | 3 | 56 | 35 | |||
| 89014 | 183103 | DPW Maintained 1 | :: 45 | 3244 Santiago St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982756.3936 | 2099499.1864 | 37.7438260327489 | -122.502313810049 | (37.7438260327489, -122.502313810049) | 1 | 8 | 3 | 29491 | 35 | |||
| 102045 | 184277 | DPW Maintained 1 | :: 45 | 1527 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982780.1956 | 2104700.8231 | 37.7581096738634 | -122.502616443283 | (37.7581096738634, -122.502616443283) | 1 | 8 | 3 | 56 | 35 | |||
| 34000 | 184614 | DPW Maintained 1 | :: 45 | 3600x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5982812.7565 | 2102876.5318 | 37.7531025964328 | -122.502368824356 | (37.7531025964328, -122.502368824356) | 1 | 8 | 3 | 56 | 35 | |||
| 71994 | 184571 | DPW Maintained 1 | :: 45 | 1711 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982821.5555 | 2103464.0321 | 37.7547162245081 | -122.502381872951 | (37.7547162245081, -122.502381872951) | 1 | 8 | 3 | 56 | 35 | |||
| 34233 | 184588 | DPW Maintained 1 | :: 45 | 1723 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982824.9397 | 2103383.4877 | 37.7544952710451 | -122.502364209058 | (37.7544952710451, -122.502364209058) | 1 | 8 | 3 | 56 | 35 | |||
| 130648 | 184590 | DPW Maintained 1 | :: 45 | 1727 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982826.6318 | 2103356.0755 | 37.7544201042603 | -122.502356328834 | (37.7544201042603, -122.502356328834) | 1 | 8 | 3 | 56 | 35 | |||
| 100027 | 183215 | DPW Maintained 1 | :: 45 | 3318 Rivera St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982838.8142 | 2100183.1408 | 37.7457088250993 | -122.502079424346 | (37.7457088250993, -122.502079424346) | 1 | 8 | 3 | 29491 | 35 | |||
| 67388 | 184440 | DPW Maintained 1 | :: 45 | 2123 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982918.0057 | 2100651.7469 | 37.7470001399255 | -122.501840261696 | (37.7470001399255, -122.501840261696) | 1 | 8 | 3 | 29491 | 35 | |||
| 38248 | 183304 | DPW Maintained 1 | :: 45 | 1263 42nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983031.5884 | 2106472.5871 | 37.7629892057203 | -122.5018781248 | (37.7629892057203, -122.5018781248) | 1 | 8 | 3 | 56 | 35 | |||
| 85654 | 183617 | DPW Maintained 1 | :: 45 | 1411 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983064.0231 | 2105493.3962 | 37.7603025305329 | -122.501693498361 | (37.7603025305329, -122.501693498361) | 1 | 8 | 3 | 56 | 35 | |||
| 2112 | 183619 | DPW Maintained 1 | :: 45 | 1415 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983065.6286 | 2105470.5181 | 37.7602398080473 | -122.501686253156 | (37.7602398080473, -122.501686253156) | 1 | 8 | 3 | 56 | 35 | |||
| 165573 | 183615 | DPW Maintained 1 | :: 45 | 1407 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983066.03 | 2105519.8865 | 37.7603753832784 | -122.501688517419 | (37.7603753832784, -122.501688517419) | 1 | 8 | 3 | 56 | 35 | |||
| 73772 | 183293 | DPW Maintained 1 | :: 45 | 1286 42nd Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983075.6533 | 2106421.6609 | 37.7628519652392 | -122.501721953964 | (37.7628519652392, -122.501721953964) | 1 | 8 | 3 | 56 | 35 | |||
| 112633 | 183717 | DPW Maintained 1 | :: 45 | 1335 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983090.7026 | 2106024.057 | 37.7617611417836 | -122.501640487706 | (37.7617611417836, -122.501640487706) | 1 | 8 | 3 | 56 | 35 | |||
| 119153 | 184329 | DPW Maintained 1 | :: 45 | 1571 42nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983101.4912 | 2104441.3261 | 37.757416043665 | -122.501486086821 | (37.757416043665, -122.501486086821) | 1 | 8 | 3 | 56 | 35 | |||
| 56922 | 184327 | DPW Maintained 1 | :: 45 | 1566 42nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983143.5077 | 2104481.5092 | 37.7575288427339 | -122.501343751719 | (37.7575288427339, -122.501343751719) | 1 | 8 | 3 | 56 | 35 | |||
| 103168 | 184689 | DPW Maintained 1 | :: 45 | 1604 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983149.1774 | 2104191.5453 | 37.7567330163884 | -122.501302696027 | (37.7567330163884, -122.501302696027) | 1 | 8 | 3 | 56 | 35 | |||
| 41529 | 184635 | DPW Maintained 1 | :: 45 | 1646 42nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983160.6342 | 2103926.3557 | 37.7560055530367 | -122.501243460243 | (37.7560055530367, -122.501243460243) | 1 | 8 | 3 | 56 | 35 | |||
| 154532 | 184690 | DPW Maintained 1 | :: 45 | 3545 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983184.2215 | 2104221.535 | 37.7568174176048 | -122.501183720782 | (37.7568174176048, -122.501183720782) | 1 | 8 | 3 | 56 | 35 | |||
| 151772 | 184163 | DPW Maintained 1 | :: 45 | 3544 Lawton St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983184.3019 | 2104274.4825 | 37.7569628012782 | -122.501187358865 | (37.7569628012782, -122.501187358865) | 1 | 8 | 3 | 56 | 35 | |||
| 48082 | 184162 | DPW Maintained 1 | :: 45 | 3542 Lawton St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983197.136 | 2104275.0936 | 37.7569652328272 | -122.501143019632 | (37.7569652328272, -122.501143019632) | 1 | 8 | 3 | 56 | 35 | |||
| 84591 | 184691 | DPW Maintained 1 | :: 45 | 3545 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983203.0915 | 2104221.1981 | 37.7568176006429 | -122.501118437486 | (37.7568176006429, -122.501118437486) | 1 | 8 | 3 | 56 | 35 | |||
| 167719 | 184692 | DPW Maintained 1 | :: 45 | 3545 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983219.9396 | 2104221.872 | 37.7568204402945 | -122.50106022131 | (37.7568204402945, -122.50106022131) | 1 | 8 | 3 | 56 | 35 | |||
| 534 | 183705 | Undocumented 4 | :: 45 | 3628 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983226.2116 | 2105643.5823 | 37.7607244242532 | -122.501143681764 | (37.7607244242532, -122.501143681764) | 1 | 8 | 3 | 56 | 35 | |||
| 25825 | 184687 | DPW Maintained 1 | :: 45 | 3525 Lawton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983292.0496 | 2104225.2416 | 37.756833926206 | -122.500811091458 | (37.756833926206, -122.500811091458) | 1 | 8 | 3 | 56 | 35 | |||
| 105058 | 183348 | DPW Maintained 1 | :: 45 | 1222 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983373.4277 | 2106798.2891 | 37.76390356553 | -122.500719925068 | (37.76390356553, -122.500719925068) | 1 | 8 | 3 | 56 | 35 | |||
| 155188 | 183623 | DPW Maintained 1 | :: 45 | 1443 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983380.9044 | 2105304.9531 | 37.7598037265775 | -122.500583637702 | (37.7598037265775, -122.500583637702) | 1 | 8 | 3 | 56 | 35 | |||
| 153169 | 183285 | DPW Maintained 1 | :: 45 | 1266 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983382.4298 | 2106528.4997 | 37.7631633289333 | -122.50066883897 | (37.7631633289333, -122.50066883897) | 1 | 8 | 3 | 56 | 35 | |||
| 18399 | 115024 | Permitted Site 7 | :: 45 | 2500 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 5983385.7 | 2098079 | 37.7399635443515 | -122.500032889381 | (37.7399635443515, -122.500032889381) | 1 | 8 | 3 | 29491 | 35 | ||||
| 66418 | 183326 | DPW Maintained 1 | :: 45 | 3955 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983391.4319 | 2106949.9604 | 37.7643210688006 | -122.500668871108 | (37.7643210688006, -122.500668871108) | 1 | 8 | 3 | 56 | 35 | |||
| 112296 | 184231 | DPW Maintained 1 | :: 45 | 1523 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983398.5095 | 2104764.9295 | 37.7583220073742 | -122.500482822231 | (37.7583220073742, -122.500482822231) | 1 | 8 | 3 | 56 | 35 | |||
| 158388 | 184302 | DPW Maintained 1 | :: 45 | 1555 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983405.8433 | 2104564.4726 | 37.7577720395933 | -122.50044263805 | (37.7577720395933, -122.50044263805) | 1 | 8 | 3 | 56 | 35 | |||
| 12771 | 184293 | DPW Maintained 1 | :: 45 | 1547 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983406.1489 | 2104611.5311 | 37.7579012669465 | -122.500445060495 | (37.7579012669465, -122.500445060495) | 1 | 8 | 3 | 56 | 35 | |||
| 167984 | 184146 | DPW Maintained 1 | :: 45 | 1583 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983412.2604 | 2104390.9064 | 37.757295852249 | -122.500407612857 | (37.757295852249, -122.500407612857) | 1 | 8 | 3 | 56 | 35 | |||
| 57829 | 183324 | DPW Maintained 1 | :: 45 | 3945 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983417.0741 | 2106949.5512 | 37.7643214505987 | -122.50058015311 | (37.7643214505987, -122.50058015311) | 1 | 8 | 3 | 56 | 35 | |||
| 46276 | 184711 | DPW Maintained 1 | :: 45 | 1619 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983422.7912 | 2104108.9895 | 37.7565224056883 | -122.500350351105 | (37.7565224056883, -122.500350351105) | 1 | 8 | 3 | 56 | 35 | |||
| 50710 | 184609 | DPW Maintained 1 | :: 45 | 3400x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5983436.8063 | 2102896.8371 | 37.7531949966988 | -122.500212272852 | (37.7531949966988, -122.500212272852) | 1 | 8 | 3 | 56 | 35 | |||
| 165579 | 183325 | DPW Maintained 1 | :: 45 | 3945 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983437.8062 | 2106951.4607 | 37.764327910588 | -122.50050858895 | (37.764327910588, -122.50050858895) | 1 | 8 | 3 | 56 | 35 | |||
| 59441 | 184288 | DPW Maintained 1 | :: 45 | 1514 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983440.9844 | 2104806.182 | 37.7584377683924 | -122.500338977609 | (37.7584377683924, -122.500338977609) | 1 | 8 | 3 | 56 | 35 | |||
| 79626 | 184262 | DPW Maintained 1 | :: 45 | 1526 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983444.9569 | 2104728.5661 | 37.7582248901335 | -122.500319500852 | (37.7582248901335, -122.500319500852) | 1 | 8 | 3 | 56 | 35 | |||
| 83110 | 184276 | DPW Maintained 1 | :: 45 | 1534 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983446.4847 | 2104680.2853 | 37.7580924143073 | -122.500310647666 | (37.7580924143073, -122.500310647666) | 1 | 8 | 3 | 56 | 35 | |||
| 13772 | 184591 | DPW Maintained 1 | :: 45 | 1751 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983451.02 | 2103228.4905 | 37.7541064586728 | -122.500187636281 | (37.7541064586728, -122.500187636281) | 1 | 8 | 3 | 56 | 35 | |||
| 129138 | 184602 | DPW Maintained 1 | :: 45 | 1763 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983454.4042 | 2103150.315 | 37.7538920091964 | -122.500170154172 | (37.7538920091964, -122.500170154172) | 1 | 8 | 3 | 56 | 35 | |||
| 164016 | 184139 | DPW Maintained 1 | :: 45 | 1582 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983456.1103 | 2104379.7529 | 37.757267801737 | -122.500255140579 | (37.757267801737, -122.500255140579) | 1 | 8 | 3 | 56 | 35 | |||
| 131432 | 183323 | DPW Maintained 1 | :: 45 | 3939 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983462.9029 | 2106952.2791 | 37.7643316308855 | -122.500421848415 | (37.7643316308855, -122.500421848415) | 1 | 8 | 3 | 56 | 35 | |||
| 95898 | 184710 | DPW Maintained 1 | :: 45 | 1622 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983465.9224 | 2104108.6525 | 37.7565240119929 | -122.500201165533 | (37.7565240119929, -122.500201165533) | 1 | 8 | 3 | 56 | 35 | |||
| 23131 | 184716 | DPW Maintained 1 | :: 45 | 1626 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983467.6072 | 2104060.8038 | 37.7563927317594 | -122.500191801751 | (37.7563927317594, -122.500191801751) | 1 | 8 | 3 | 56 | 35 | |||
| 162942 | 184724 | DPW Maintained 1 | :: 45 | 1638 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983469.292 | 2103986.335 | 37.756188360185 | -122.500180470118 | (37.756188360185, -122.500180470118) | 1 | 8 | 3 | 56 | 35 | |||
| 37615 | 184629 | DPW Maintained 1 | :: 45 | 1646 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983471.6508 | 2103927.0296 | 37.7560256626113 | -122.500167928609 | (37.7560256626113, -122.500167928609) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );