trees
1,914 rows where qSpecies_id = 45 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 253 | 200884 | DPW Maintained 1 | :: 45 | 1200 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6012817.0471 | 2107089.1245 | 37.7663867409086 | -122.39890301604 | (37.7663867409086, -122.39890301604) | 14 | 3 | 8 | 28856 | 20 | |||
| 410 | 183338 | DPW Maintained 1 | :: 45 | 1200 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5980889.0479 | 2106803.3028 | 37.7637711641625 | -122.509312865514 | (37.7637711641625, -122.509312865514) | 1 | 8 | 3 | 56 | 35 | |||
| 65205 | 185601 | DPW Maintained 1 | :: 45 | 1200 Quintara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989640.5487 | 2101098.6399 | 37.7486197911777 | -122.478627227884 | (37.7486197911777, -122.478627227884) | 1 | 8 | 3 | 29491 | 35 | |||
| 175541 | 185599 | DPW Maintained 1 | :: 45 | 1200 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989708.1577 | 2101099.3093 | 37.7486255543569 | -122.47839348828 | (37.7486255543569, -122.47839348828) | 1 | 8 | 3 | 29491 | 35 | |||
| 19781 | 186781 | DPW Maintained 1 | :: 45 | 1200 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984857.4742 | 2106824.783 | 37.7640633248358 | -122.495589084984 | (37.7640633248358, -122.495589084984) | 1 | 8 | 3 | 56 | 35 | |||
| 28545 | 186800 | DPW Maintained 1 | :: 45 | 1200 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984846.2035 | 2106925.1049 | 37.7643381205783 | -122.495635466651 | (37.7643381205783, -122.495635466651) | 1 | 8 | 3 | 56 | 35 | |||
| 74718 | 186771 | DPW Maintained 1 | :: 45 | 1200 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984865.2362 | 2106774.8154 | 37.7639265823683 | -122.495558553205 | (37.7639265823683, -122.495558553205) | 1 | 8 | 3 | 56 | 35 | |||
| 10803 | 259618 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 12379 | 259619 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 17295 | 259617 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 16705 | 186840 | DPW Maintained 1 | :: 45 | 1201 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984884.6409 | 2106758.5555 | 37.763883073514 | -122.495490239842 | (37.763883073514, -122.495490239842) | 1 | 8 | 3 | 56 | 35 | |||
| 108994 | 183316 | DPW Maintained 1 | :: 45 | 1201 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983946.4232 | 2106931.1378 | 37.7643019535521 | -122.498747951587 | (37.7643019535521, -122.498747951587) | 1 | 8 | 3 | 56 | 35 | |||
| 67611 | 129086 | DPW Maintained 1 | :: 45 | 1201 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008124.6291 | 2115843.7412 | 37.7901622440508 | -122.415753223646 | (37.7901622440508, -122.415753223646) | 13 | 1 | 10 | 28858 | 21 | |||
| 85790 | 66597 | DPW Maintained 1 | :: 45 | 1201 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 14 | Permit Number 29790 | 6008070.41503 | 2115836.67012 | 37.7901397807808 | -122.415940299715 | (37.7901397807808, -122.415940299715) | 13 | 1 | 10 | 28858 | 21 | |
| 193926 | 129085 | DPW Maintained 1 | :: 45 | 1201 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008098.74192 | 2115839.1342 | 37.790148139064 | -122.415842465177 | (37.790148139064, -122.415842465177) | 13 | 1 | 10 | 28858 | 21 | |||
| 117686 | 184891 | DPW Maintained 1 | :: 45 | 1201 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984723.2958 | 2106746.9726 | 37.7638418212229 | -122.496047420943 | (37.7638418212229, -122.496047420943) | 1 | 8 | 3 | 56 | 35 | |||
| 129771 | 253008 | DPW Maintained 1 | :: 45 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | ||
| 45114 | 109367 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 66039 | 109366 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 152658 | 109368 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 154649 | 109365 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 166540 | 109364 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 19220 | 122819 | Undocumented 4 | :: 45 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003309 | 2094407 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | 9 | 7 | 5 | 28861 | 25 | ||||
| 80930 | 140087 | DPW Maintained 1 | :: 45 | 1210 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001853.1286 | 2112643.6389 | 37.7810210292677 | -122.43722286326 | (37.7810210292677, -122.43722286326) | 15 | 5 | 11 | 29490 | 41 | |||
| 32891 | 181714 | DPW Maintained 1 | :: 45 | 1215 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987051.5149 | 2106949.2334 | 37.764533265698 | -122.488009786224 | (37.764533265698, -122.488009786224) | 1 | 8 | 3 | 56 | 35 | |||
| 142443 | 181751 | DPW Maintained 1 | :: 45 | 1215 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985811.8134 | 2106917.8782 | 37.7643747762944 | -122.492295207753 | (37.7643747762944, -122.492295207753) | 1 | 8 | 3 | 56 | 35 | |||
| 68100 | 183339 | DPW Maintained 1 | :: 45 | 1219 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983948.7419 | 2106852.4379 | 37.7640860018935 | -122.498734117688 | (37.7640860018935, -122.498734117688) | 1 | 8 | 3 | 56 | 35 | |||
| 86983 | 183340 | DPW Maintained 1 | :: 45 | 1219 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983949.2875 | 2106832.797 | 37.7640321055392 | -122.498730779597 | (37.7640321055392, -122.498730779597) | 1 | 8 | 3 | 56 | 35 | |||
| 3194 | 259639 | DPW Maintained 1 | :: 45 | 122 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010584.82353 | 2087852.62198 | 37.7134428042481 | -122.405269135112 | (37.7134428042481, -122.405269135112) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | |||
| 118498 | 139245 | Undocumented 4 | :: 45 | 1223 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003686.6496 | 2113074.8565 | 37.7823091017787 | -122.430910590356 | (37.7823091017787, -122.430910590356) | 15 | 9 | 11 | 29490 | 41 | |||
| 112407 | 181758 | DPW Maintained 1 | :: 45 | 1230 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984924.827 | 2106814.5562 | 37.7640391887322 | -122.495355380579 | (37.7640391887322, -122.495355380579) | 1 | 8 | 3 | 56 | 35 | |||
| 49821 | 228500 | DPW Maintained 1 | :: 45 | 1230 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6002502.46383 | 2101939.70334 | 37.7516675300559 | -122.434211046008 | (37.7516675300559, -122.434211046008) | 2 | 4 | 5 | 28862 | 22 | |||
| 7856 | 259620 | DPW Maintained 1 | :: 45 | 1230 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008944.20258 | 2087484.57598 | 37.7123403644372 | -122.410913742428 | (37.7123403644372, -122.410913742428) | 9 | 7 | 8 | 309 | 39 | ||
| 64175 | 109535 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 78553 | 109534 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 123221 | 109536 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 119699 | 181768 | DPW Maintained 1 | :: 45 | 1235 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985194.4062 | 2106785.0805 | 37.7639740372115 | -122.494420826151 | (37.7639740372115, -122.494420826151) | 1 | 8 | 3 | 56 | 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 | |||
| 31704 | 111759 | DPW Maintained 1 | :: 45 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard | Landscaping | Private 2 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.507284463143 | (37.7634442160317, -122.507284463143) | 1 | 8 | 3 | 56 | 35 | ||
| 152691 | 111758 | DPW Maintained 1 | :: 45 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.507284463143 | (37.7634442160317, -122.507284463143) | 1 | 8 | 3 | 56 | 35 | ||
| 9389 | 66602 | DPW Maintained 1 | :: 45 | 1235 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 13 | Permit Number 29795 | 6008012.17093 | 2115828.01912 | 37.7901127525459 | -122.416141207354 | (37.7901127525459, -122.416141207354) | 13 | 1 | 10 | 28858 | 21 | |
| 12904 | 37151 | Permitted Site 7 | :: 45 | 124 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2015 12:00:00 AM | 3 | 4.5x10 | Permit Number 775446 | 6005712.42544702 | 2100249.055732 | 37.7472070660376 | -122.42299041598 | (37.7472070660376, -122.42299041598) | 2 | 7 | 5 | 28859 | 22 |
| 109223 | 141119 | DPW Maintained 1 | :: 45 | 124 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998714.1818 | 2112720.5452 | 37.7810532591781 | -122.448087532266 | (37.7810532591781, -122.448087532266) | 15 | 6 | 2 | 54 | 16 | |||
| 36578 | 181754 | DPW Maintained 1 | :: 45 | 1240 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987099.9397 | 2106850.6122 | 37.7642653039062 | -122.487835053811 | (37.7642653039062, -122.487835053811) | 1 | 8 | 3 | 56 | 35 | |||
| 153908 | 181610 | DPW Maintained 1 | :: 45 | 1242 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984929.7396 | 2106734.1122 | 37.7638185997313 | -122.49533245658 | (37.7638185997313, -122.49533245658) | 1 | 8 | 3 | 56 | 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 | |||
| 66610 | 181614 | DPW Maintained 1 | :: 45 | 1246 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984927.2833 | 2106710.1633 | 37.7637526989564 | -122.495339185736 | (37.7637526989564, -122.495339185736) | 1 | 8 | 3 | 56 | 35 | |||
| 173720 | 183670 | DPW Maintained 1 | :: 45 | 1247 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984264.9056 | 2106671.7145 | 37.7636083244569 | -122.497627272298 | (37.7636083244569, -122.497627272298) | 1 | 8 | 3 | 56 | 35 | |||
| 110069 | 116528 | Planning Code 138.1 required 2 | :: 45 | 125 CROWN TER | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 5998841 | 2104182 | 37.7576158290564 | -122.447034160915 | (37.7576158290564, -122.447034160915) | 2 | 5 | 5 | 28862 | 3 | |||
| 31751 | 184810 | DPW Maintained 1 | :: 45 | 1250 37th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984625.0742 | 2106537.48 | 37.7632608599862 | -122.49637167575 | (37.7632608599862, -122.49637167575) | 1 | 8 | 3 | 56 | 35 | |||
| 19878 | 140091 | DPW Maintained 1 | :: 45 | 1250 Scott St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001831.6388 | 2112795.421 | 37.7814365628361 | -122.437308078448 | (37.7814365628361, -122.437308078448) | 15 | 5 | 11 | 29490 | 41 | |||
| 9802 | 245988 | Undocumented 4 | :: 45 | 1250 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999884.6674 | 2108495.9392 | 37.7695204065663 | -122.443734660449 | (37.7695204065663, -122.443734660449) | 15 | 5 | 11 | 29492 | 9 | |||
| 165298 | 219178 | DPW Maintained 1 | :: 45 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991732.81966 | 2106918.29037 | 37.7647202794542 | -122.471816321464 | (37.7647202794542, -122.471816321464) | 11 | 8 | 11 | 56 | 12 | |||
| 167072 | 181608 | DPW Maintained 1 | :: 45 | 1251 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986743.9567 | 2106741.3672 | 37.7639445762818 | -122.489058249622 | (37.7639445762818, -122.489058249622) | 1 | 8 | 3 | 56 | 35 | |||
| 78177 | 181617 | DPW Maintained 1 | :: 45 | 1251 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985198.7047 | 2106674.5469 | 37.7636707944731 | -122.494397810738 | (37.7636707944731, -122.494397810738) | 1 | 8 | 3 | 56 | 35 | |||
| 112355 | 181616 | DPW Maintained 1 | :: 45 | 1251 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985196.2484 | 2106684.3721 | 37.76369762797 | -122.494407030493 | (37.76369762797, -122.494407030493) | 1 | 8 | 3 | 56 | 35 | |||
| 121597 | 186842 | DPW Maintained 1 | :: 45 | 1251 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984888.6931 | 2106439.91 | 37.7630083996638 | -122.495452722177 | (37.7630083996638, -122.495452722177) | 1 | 8 | 3 | 56 | 35 | |||
| 54366 | 184811 | DPW Maintained 1 | :: 45 | 1251 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984734.8773 | 2106435.4128 | 37.7629870438781 | -122.495984378629 | (37.7629870438781, -122.495984378629) | 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 | |||
| 185065 | 183277 | DPW Maintained 1 | :: 45 | 1255 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981785.9112 | 2106543.1909 | 37.7631098104891 | -122.506191655726 | (37.7631098104891, -122.506191655726) | 1 | 8 | 3 | 56 | 35 | |||
| 71082 | 246042 | DPW Maintained 1 | :: 45 | 1257 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999431.9379 | 2108484.7346 | 37.7694638090143 | -122.445299822785 | (37.7694638090143, -122.445299822785) | 15 | 5 | 11 | 29492 | 9 | |||
| 150823 | 183287 | DPW Maintained 1 | :: 45 | 1259 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981476.8749 | 2106516.0091 | 37.7630169795519 | -122.507258472509 | (37.7630169795519, -122.507258472509) | 1 | 8 | 3 | 56 | 35 | |||
| 11414 | 173708 | DPW Maintained 1 | :: 45 | 126 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001214 | 2098705 | 37.7427125900371 | -122.438434982469 | (37.7427125900371, -122.438434982469) | 2 | 7 | 5 | 63 | 7 | ||||
| 47069 | 117591 | Undocumented 4 | :: 45 | 1262 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999100 | 2105386 | 37.7609365084256 | -122.446225043361 | (37.7609365084256, -122.446225043361) | 15 | 5 | 5 | 28862 | 3 | ||||
| 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 | |||
| 19909 | 139776 | DPW Maintained 1 | :: 45 | 1265 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004800.935 | 2113296.4778 | 37.7829806915655 | -122.427071445409 | (37.7829806915655, -122.427071445409) | 7 | 9 | 11 | 28858 | 41 | |||
| 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 | |||
| 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 | |||
| 36365 | 181665 | DPW Maintained 1 | :: 45 | 1275 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985511.3315 | 2106531.7973 | 37.7632971348656 | -122.493306030015 | (37.7632971348656, -122.493306030015) | 1 | 8 | 3 | 56 | 35 | |||
| 130099 | 6759 | DPW Maintained 1 | :: 45 | 1275 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2015 12:51:00 PM | 3 | 3x3 | 6017200.09768 | 2096971.16598 | 37.7388481798969 | -122.383038438091 | (37.7388481798969, -122.383038438091) | 10 | 3 | 8 | 58 | 1 | ||
| 58292 | 181670 | DPW Maintained 1 | :: 45 | 1278 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984935.2663 | 2106495.8509 | 37.763164724632 | -122.495295769501 | (37.763164724632, -122.495295769501) | 1 | 8 | 3 | 56 | 35 | |||
| 111303 | 181669 | DPW Maintained 1 | :: 45 | 1278 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984937.1085 | 2106485.4116 | 37.7631361691005 | -122.495288628135 | (37.7631361691005, -122.495288628135) | 1 | 8 | 3 | 56 | 35 | |||
| 148429 | 37485 | Permitted Site 7 | :: 45 | 1279 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39954 | 5990777.53023366 | 2106701.87780849 | 37.7640707487715 | -122.47510458341 | (37.7640707487715, -122.47510458341) | 11 | 8 | 3 | 56 | 12 | ||
| 98251 | 181667 | DPW Maintained 1 | :: 45 | 1279 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985203.0032 | 2106516.7295 | 37.7632377236324 | -122.494371309886 | (37.7632377236324, -122.494371309886) | 1 | 8 | 3 | 56 | 35 | |||
| 166250 | 181522 | DPW Maintained 1 | :: 45 | 1279 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984580.8884 | 2106481.9946 | 37.7631059241302 | -122.496520402894 | (37.7631059241302, -122.496520402894) | 1 | 8 | 3 | 56 | 35 | |||
| 57102 | 181666 | DPW Maintained 1 | :: 45 | 1282 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985866.1245 | 2106507.5934 | 37.7632514235254 | -122.492077152789 | (37.7632514235254, -122.492077152789) | 1 | 8 | 3 | 56 | 35 | |||
| 173647 | 181679 | DPW Maintained 1 | :: 45 | 1282 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984937.7226 | 2106471.2879 | 37.7630974253349 | -122.495285462568 | (37.7630974253349, -122.495285462568) | 1 | 8 | 3 | 56 | 35 | |||
| 268 | 247892 | DPW Maintained 1 | :: 45 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.7715514711219 | -122.441841814274 | (37.7715514711219, -122.441841814274) | 15 | 5 | 11 | 29492 | 9 | |||
| 41062 | 181674 | DPW Maintained 1 | :: 45 | 1286 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985866.1245 | 2106482.2089 | 37.7631817247551 | -122.492075283673 | (37.7631817247551, -122.492075283673) | 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 | |||
| 50142 | 248555 | DPW Maintained 1 | :: 45 | 129 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5997396.7751 | 2107759.6103 | 37.767356421122 | -122.452286999337 | (37.767356421122, -122.452286999337) | 15 | 5 | 11 | 29492 | 9 | |||
| 69302 | 181680 | DPW Maintained 1 | :: 45 | 1290 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985868.4858 | 2106459.7761 | 37.7631202685599 | -122.492065465074 | (37.7631202685599, -122.492065465074) | 1 | 8 | 3 | 56 | 35 | |||
| 130214 | 181678 | DPW Maintained 1 | :: 45 | 1295 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985204.8455 | 2106401.8973 | 37.7629225343509 | -122.49435647305 | (37.7629225343509, -122.49435647305) | 1 | 8 | 3 | 56 | 35 | |||
| 42253 | 38110 | Permitted Site 7 | :: 45 | 1296 29th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.487755232649 | (37.763186144894, -122.487755232649) | 1 | 8 | 3 | 56 | 35 | ||
| 141009 | 38111 | Permitted Site 7 | :: 45 | 1296 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.487755232649 | (37.763186144894, -122.487755232649) | 1 | 8 | 3 | 56 | 35 | ||
| 121158 | 183255 | DPW Maintained 1 | :: 45 | 1300 La Playa | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5980911.3073 | 2106159.7216 | 37.7620053885736 | -122.509188082818 | (37.7620053885736, -122.509188082818) | 1 | 8 | 3 | 56 | 35 | |||
| 133142 | 183254 | DPW Maintained 1 | :: 45 | 1300 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5980911.6607 | 2106131.1023 | 37.7619268290686 | -122.509184735204 | (37.7619268290686, -122.509184735204) | 1 | 8 | 3 | 56 | 35 | |||
| 96207 | 137524 | DPW Maintained 1 | :: 45 | 1300 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002282.6726 | 2113052.5281 | 37.7821681439649 | -122.435766122963 | (37.7821681439649, -122.435766122963) | 15 | 5 | 11 | 29490 | 41 | |||
| 1851 | 200636 | DPW Maintained 1 | :: 45 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.7291810369364 | -122.384238246013 | (37.7291810369364, -122.384238246013) | 10 | 3 | 8 | 58 | 1 | |||
| 7664 | 261543 | Permitted Site 7 | :: 45 | 1305 Lombard St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 20x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
| 8883 | 261542 | Permitted Site 7 | :: 45 | 1305 Lombard St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 10x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
| 94170 | 139765 | DPW Maintained 1 | :: 45 | 1306 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004663.7345 | 2113397.522 | 37.7832503745299 | -122.427553303818 | (37.7832503745299, -122.427553303818) | 7 | 9 | 11 | 28858 | 41 | |||
| 94636 | 139766 | DPW Maintained 1 | :: 45 | 1308 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004662.1567 | 2113418.8231 | 37.7833087728144 | -122.427560280444 | (37.7833087728144, -122.427560280444) | 7 | 9 | 11 | 28858 | 41 | |||
| 258 | 139105 | DPW Maintained 1 | :: 45 | 1310 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999792.0294 | 2113376.32 | 37.7829154028675 | -122.444405875371 | (37.7829154028675, -122.444405875371) | 15 | 6 | 1 | 29490 | 31 | |||
| 165371 | 182612 | Undocumented 4 | :: 45 | 1310 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5989941.9442 | 2102468.0868 | 37.7523974262194 | -122.477685104484 | (37.7523974262194, -122.477685104484) | 1 | 8 | 3 | 56 | 35 | |||
| 183430 | 182036 | DPW Maintained 1 | :: 45 | 1314 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987424.9672 | 2106327.6806 | 37.7628484313073 | -122.486672489667 | (37.7628484313073, -122.486672489667) | 1 | 8 | 3 | 56 | 35 | |||
| 262 | 141330 | DPW Maintained 1 | :: 45 | 1314 HAYES ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 0 | Width 0ft | 6001510.5734 | 2110463.2514 | 37.7750147569158 | -122.438251682494 | (37.7750147569158, -122.438251682494) | 15 | 5 | 11 | 29492 | 10 | |||
| 126828 | 139746 | DPW Maintained 1 | :: 45 | 1314 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2013 12:00:00 AM | 2 | Width 0ft | 6004648.3504 | 2113539.1351 | 37.783638338735 | -122.427616619318 | (37.783638338735, -122.427616619318) | 7 | 9 | 11 | 28858 | 41 | ||
| 183022 | 182038 | DPW Maintained 1 | :: 45 | 1319 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987384.8091 | 2106266.2339 | 37.7626773744039 | -122.486806868235 | (37.7626773744039, -122.486806868235) | 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) );