trees
1,914 rows where qSpecies_id = 45 sorted by DBH descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10776 | 219180 | DPW Maintained 1 | :: 45 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994012.85069 | 2103371.98784 | 37.7551147123942 | -122.463672948647 | (37.7551147123942, -122.463672948647) | 1 | 5 | 4 | 56 | 12 | |||
| 20186 | 248457 | DPW Maintained 1 | :: 45 | 141 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998243.6366 | 2107963.8685 | 37.7679657404514 | -122.44937255538 | (37.7679657404514, -122.44937255538) | 15 | 5 | 11 | 29492 | 9 | |||
| 37319 | 105121 | Undocumented 4 | :: 45 | 721 BEACH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.420969011396 | (37.8064757462399, -122.420969011396) | 5 | 1 | 1 | 28858 | 32 | |||||
| 41310 | 219179 | DPW Maintained 1 | :: 45 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994014.03321 | 2103382.75983 | 37.7551443576498 | -122.463669640952 | (37.7551443576498, -122.463669640952) | 1 | 5 | 4 | 56 | 12 | |||
| 54145 | 111850 | Undocumented 4 | :: 45 | 245 STATES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000624 | 2106601 | 37.764359516173 | -122.441041378606 | (37.764359516173, -122.441041378606) | 15 | 5 | 5 | 28862 | 3 | |||
| 93388 | 228476 | DPW Maintained 1 | :: 45 | 427 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003772.71447 | 2098922.9201 | 37.7434561594686 | -122.429603221106 | (37.7434561594686, -122.429603221106) | 2 | 7 | 5 | 63 | 22 | |||
| 97641 | 228479 | DPW Maintained 1 | :: 45 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998955.25722 | 2107101.19212 | 37.7656377291263 | -122.446849065839 | (37.7656377291263, -122.446849065839) | 15 | 5 | 11 | 29492 | 9 | |||
| 143496 | 190656 | DPW Maintained 1 | :: 45 | 358 Arkansas St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012906.49923 | 2105280.13182 | 37.7614246319699 | -122.398466668421 | (37.7614246319699, -122.398466668421) | 10 | 3 | 8 | 28856 | 29 | |||
| 177747 | 120866 | DPW Maintained 1 | :: 45 | 701 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990027.96558 | 2110538.28947 | 37.7745610189378 | -122.477977567474 | (37.7745610189378, -122.477977567474) | 11 | 6 | 2 | 55 | 26 | |||
| 193887 | 190665 | DPW Maintained 1 | :: 45 | 153 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013152.15167 | 2111293.3784 | 37.777949341814 | -122.398038913074 | (37.777949341814, -122.398038913074) | 6 | 2 | 9 | 28856 | 34 | |||
| 1289 | 190652 | DPW Maintained 1 | :: 45 | 310 Arkansas St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.398528520183 | (37.7621425904374, -122.398528520183) | 10 | 3 | 8 | 28856 | 29 | |||
| 35792 | 25491 | DPW Maintained 1 | :: 45 | 645 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003026.26997 | 2109233.55885 | 37.7717244144917 | -122.43292069335 | (37.7717244144917, -122.43292069335) | 15 | 5 | 11 | 29492 | 9 | ||
| 36523 | 190662 | DPW Maintained 1 | :: 45 | 1498 Fairfax Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6016277.57069 | 2097744.40559 | 37.7409203204163 | -122.386282030116 | (37.7409203204163, -122.386282030116) | 10 | 3 | 8 | 58 | 1 | |||
| 57150 | 10247 | DPW Maintained 1 | :: 45 | 112 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 8 | 3X3 | 6005536.2501 | 2109637.4907 | 37.7729755585516 | -122.424267236647 | (37.7729755585516, -122.424267236647) | 7 | 9 | 11 | 28852 | 10 | ||
| 94011 | 190670 | DPW Maintained 1 | :: 45 | 149 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013247.06653 | 2111383.52028 | 37.7782021367646 | -122.39771689102 | (37.7782021367646, -122.39771689102) | 6 | 2 | 9 | 28856 | 34 | |||
| 106767 | 120865 | DPW Maintained 1 | :: 45 | 701 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990028.78526 | 2110554.03114 | 37.7746042888084 | -122.477975883138 | (37.7746042888084, -122.477975883138) | 11 | 6 | 2 | 55 | 26 | |||
| 124584 | 32479 | DPW Maintained 1 | :: 45 | 81 Saturn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 8 | Permit Number 36987 | 6000177.30918 | 2105965.99025 | 37.7625904842844 | -122.442540757445 | (37.7625904842844, -122.442540757445) | 15 | 5 | 5 | 28862 | 3 | |
| 132635 | 245065 | DPW Maintained 1 | :: 45 | 1150 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000577.9392 | 2108943.6108 | 37.7707891181366 | -122.441368793683 | (37.7707891181366, -122.441368793683) | 15 | 5 | 11 | 29492 | 9 | |||
| 139687 | 51853 | DPW Maintained 1 | :: 45 | 1639 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2005 12:00:00 AM | 8 | Permit Number 48077 | 6012728.89469 | 2105155.76009 | 37.7610732389628 | -122.39907220262 | (37.7610732389628, -122.39907220262) | 10 | 3 | 8 | 28856 | 29 | ||
| 141426 | 228477 | DPW Maintained 1 | :: 45 | 432 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003665.88299 | 2100131.59167 | 37.7467688419068 | -122.430058821276 | (37.7467688419068, -122.430058821276) | 2 | 7 | 5 | 63 | 22 | |||
| 150213 | 120833 | DPW Maintained 1 | :: 45 | 1803 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5989987.953 | 2110566.55394 | 37.7746363029346 | -122.478118044214 | (37.7746363029346, -122.478118044214) | 11 | 6 | 2 | 55 | 26 | |||
| 150483 | 228459 | DPW Maintained 1 | :: 45 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006042.87008 | 2100850.33706 | 37.7488766882238 | -122.421890467095 | (37.7488766882238, -122.421890467095) | 2 | 4 | 5 | 28859 | 19 | |||
| 169898 | 228464 | DPW Maintained 1 | :: 45 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005334.7155 | 2104318.69082 | 37.7583600194211 | -122.424585951974 | (37.7583600194211, -122.424585951974) | 2 | 4 | 5 | 28859 | 19 | |||
| 179071 | 64733 | DPW Maintained 1 | :: 45 | 135 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/1988 12:00:00 AM | 8 | Permit Number 25692 | 5994873.94035 | 2114654.72726 | 37.7861437296173 | -122.461513011375 | (37.7861437296173, -122.461513011375) | 11 | 6 | 1 | 54 | 11 | ||
| 180001 | 182521 | DPW Maintained 1 | :: 45 | 2330 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5986994.5572 | 2104405.9226 | 37.7575467105125 | -122.4880198933 | (37.7575467105125, -122.4880198933) | 1 | 8 | 3 | 56 | 35 | |||
| 191889 | 143026 | DPW Maintained 1 | :: 45 | 2027 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009443.5652 | 2120635.2508 | 37.8033926093321 | -122.411528458224 | (37.8033926093321, -122.411528458224) | 3 | 1 | 10 | 308 | 23 | |||
| 146 | 190658 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6016241.73559 | 2097685.48667 | 37.7407565574799 | -122.386401828788 | (37.7407565574799, -122.386401828788) | 10 | 3 | 8 | 58 | 1 | |||
| 4746 | 67428 | DPW Maintained 1 | :: 45 | 1520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 7 | Permit Number 30930 | 5990841.08394 | 2110656.29148 | 37.7749321810162 | -122.475173477199 | (37.7749321810162, -122.475173477199) | 11 | 6 | 2 | 54 | 26 | |
| 21716 | 228489 | DPW Maintained 1 | :: 45 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001576.28568 | 2101774.2319 | 37.7511605741136 | -122.437402036675 | (37.7511605741136, -122.437402036675) | 2 | 4 | 5 | 28862 | 22 | |||
| 47890 | 190672 | DPW Maintained 1 | :: 45 | 149 Freelon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013276.0134 | 2111408.93876 | 37.7782735420174 | -122.39761853578 | (37.7782735420174, -122.39761853578) | 6 | 2 | 9 | 28856 | 34 | |||
| 70303 | 190657 | DPW Maintained 1 | :: 45 | 301 Mendell St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6016835.36544 | 2097808.79392 | 37.7411279765664 | -122.38435784694 | (37.7411279765664, -122.38435784694) | 10 | 3 | 8 | 58 | 1 | |||
| 93182 | 219177 | DPW Maintained 1 | :: 45 | 1351 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5991107.88095 | 2106214.54011 | 37.7627517902819 | -122.473926451152 | (37.7627517902819, -122.473926451152) | 1 | 8 | 11 | 56 | 12 | |||
| 122209 | 67426 | DPW Maintained 1 | :: 45 | 1502 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 7 | Permit Number 30928 | 5990903.71531 | 2110660.74638 | 37.7749480428024 | -122.474957149423 | (37.7749480428024, -122.474957149423) | 11 | 6 | 2 | 54 | 26 | |
| 124110 | 190653 | DPW Maintained 1 | :: 45 | 320 Arkansas St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6012892.66651 | 2105479.77799 | 37.7619720457008 | -122.398528520179 | (37.7619720457008, -122.398528520179) | 10 | 3 | 8 | 28856 | 29 | |||
| 127885 | 190661 | DPW Maintained 1 | :: 45 | 1400 Fairfax Ave | 12 | : | Tree | Private 2 | 7 | Width 3ft | 6016311.59703 | 2097718.64456 | 37.7408514692121 | -122.386162583062 | (37.7408514692121, -122.386162583062) | 10 | 3 | 8 | 58 | 1 | |||
| 154381 | 67427 | DPW Maintained 1 | :: 45 | 1515 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 7 | Permit Number 30929 | 5990869.16638 | 2110599.51462 | 37.7747779148712 | -122.475072189476 | (37.7747779148712, -122.475072189476) | 11 | 6 | 2 | 54 | 26 | |
| 162351 | 228434 | DPW Maintained 1 | :: 45 | 292 Church St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6004130.46793 | 2107245.14017 | 37.7663272663153 | -122.428959412666 | (37.7663272663153, -122.428959412666) | 8 | 4 | 5 | 28862 | 3 | |||
| 167802 | 190667 | DPW Maintained 1 | :: 45 | 153 Freelon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013174.92981 | 2111315.77599 | 37.7780121091073 | -122.397961686491 | (37.7780121091073, -122.397961686491) | 6 | 2 | 9 | 28856 | 34 | |||
| 191297 | 67430 | DPW Maintained 1 | :: 45 | 1803 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 7 | Permit Number 30932 | 5989942.29027 | 2110566.40136 | 37.7746332333777 | -122.4782759878 | (37.7746332333777, -122.4782759878) | 11 | 6 | 2 | 55 | 26 | |
| 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 | |||
| 326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
| 5962 | 190650 | DPW Maintained 1 | :: 45 | 501 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012697.31498 | 2105105.25182 | 37.7609327945277 | -122.399177878376 | (37.7609327945277, -122.399177878376) | 10 | 3 | 8 | 28856 | 29 | |||
| 8481 | 70091 | DPW Maintained 1 | :: 45 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | 11 | 6 | 2 | 55 | 26 | ||
| 11022 | 25490 | DPW Maintained 1 | :: 45 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 6 | 3x3 | 6003008.9663 | 2109230.97801 | 37.771716346673 | -122.432980363376 | (37.771716346673, -122.432980363376) | 15 | 5 | 11 | 29492 | 9 | ||
| 25229 | 182520 | DPW Maintained 1 | :: 45 | 2330 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5987008.0531 | 2104405.4872 | 37.7575463023109 | -122.487973187655 | (37.7575463023109, -122.487973187655) | 1 | 8 | 3 | 56 | 35 | |||
| 27689 | 228438 | DPW Maintained 1 | :: 45 | 597 Haight St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6003321.74278 | 2109274.92244 | 37.7718547433349 | -122.431901588786 | (37.7718547433349, -122.431901588786) | 15 | 9 | 11 | 29492 | 10 | |||
| 39265 | 228487 | DPW Maintained 1 | :: 45 | 2880 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008652.20159 | 2106330.0546 | 37.7640695596822 | -122.413254813474 | (37.7640695596822, -122.413254813474) | 8 | 4 | 7 | 28859 | 19 | |||
| 45444 | 10257 | DPW Maintained 1 | :: 45 | 155 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2006 12:00:00 AM | 6 | 3X3 | 6005354.14588 | 2109555.43017 | 37.7727399559066 | -122.424891318606 | (37.7727399559066, -122.424891318606) | 7 | 9 | 11 | 28852 | 10 | ||
| 47594 | 6841 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016176.35578 | 2097734.00436 | 37.7408861578704 | -122.386631271932 | (37.7408861578704, -122.386631271932) | 10 | 3 | 8 | 58 | 1 | ||
| 53806 | 103672 | Undocumented 4 | :: 45 | 2416 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008103.2 | 2104332.6 | 37.7585541718373 | -122.415012265425 | (37.7585541718373, -122.415012265425) | 2 | 4 | 7 | 28859 | 19 | |||
| 63806 | 190668 | DPW Maintained 1 | :: 45 | 151 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013191.282 | 2111332.85089 | 37.7780599035854 | -122.397906316128 | (37.7780599035854, -122.397906316128) | 6 | 2 | 9 | 28856 | 34 | |||
| 65380 | 113382 | Undocumented 4 | :: 45 | 146 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5994461 | 2101055 | 37.7487786662853 | -122.461955122224 | (37.7487786662853, -122.461955122224) | 1 | 8 | 4 | 29491 | 40 | |||
| 82804 | 37655 | DPW Maintained 1 | :: 45 | 1521 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 6 | Permit Number 40065 | 5990857.78217 | 2110597.46577 | 37.7747716294998 | -122.475111419797 | (37.7747716294998, -122.475111419797) | 11 | 6 | 2 | 54 | 26 | |
| 85771 | 67435 | DPW Maintained 1 | :: 45 | 2632 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/1992 12:00:00 AM | 6 | Permit Number 30937 | 5990433.16453 | 2112001.81298 | 37.7786029615899 | -122.476682866062 | (37.7786029615899, -122.476682866062) | 11 | 6 | 2 | 55 | 26 | |
| 87211 | 228488 | DPW Maintained 1 | :: 45 | 2880 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008610.43797 | 2106311.71269 | 37.7640168522296 | -122.413397964868 | (37.7640168522296, -122.413397964868) | 8 | 4 | 7 | 28859 | 19 | |||
| 87831 | 228465 | DPW Maintained 1 | :: 45 | 321 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004210.24642 | 2107036.07535 | 37.7657577400449 | -122.428668569211 | (37.7657577400449, -122.428668569211) | 8 | 4 | 5 | 28862 | 3 | |||
| 92421 | 246180 | DPW Maintained 1 | :: 45 | 1588 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997959.8858 | 2108225.8157 | 37.7686687454483 | -122.450372898384 | (37.7686687454483, -122.450372898384) | 15 | 5 | 11 | 29492 | 9 | |||
| 105257 | 78131 | DPW Maintained 1 | :: 45 | 2040 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53996 | 6000457.66404 | 2121004.4785 | 37.8038982794373 | -122.442650952296 | (37.8038982794373, -122.442650952296) | 13 | 9 | 1 | 57 | 17 |
| 109054 | 244127 | DPW Maintained 1 | :: 45 | 398 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004270.549 | 2109462.5132 | 37.7724235634161 | -122.428632976075 | (37.7724235634161, -122.428632976075) | 7 | 9 | 11 | 28852 | 10 | |||
| 110361 | 6809 | DPW Maintained 1 | :: 45 | 1400X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016539.97847 | 2097547.42551 | 37.7403939741954 | -122.385360989424 | (37.7403939741954, -122.385360989424) | 10 | 3 | 8 | 58 | 1 | ||
| 131471 | 7948 | DPW Maintained 1 | :: 45 | 1701 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2014 12:00:00 AM | 6 | 3X3 | 6005705.32484 | 2116013.75926 | 37.790492771869 | -122.424135933935 | (37.790492771869, -122.424135933935) | 13 | 9 | 1 | 28858 | 27 | ||
| 145345 | 228445 | DPW Maintained 1 | :: 45 | 391 Haight St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004290.10245 | 2109410.45263 | 37.7722817243588 | -122.428561627213 | (37.7722817243588, -122.428561627213) | 7 | 9 | 11 | 28852 | 10 | |||
| 148974 | 228437 | DPW Maintained 1 | :: 45 | 160 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 6 | Width 3ft | 6004091.19769 | 2108012.29591 | 37.7684314676748 | -122.429149946611 | (37.7684314676748, -122.429149946611) | 7 | 9 | 5 | 28862 | 3 | ||
| 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 | |||
| 176151 | 228503 | DPW Maintained 1 | :: 45 | 140 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007243.83648 | 2109064.60146 | 37.7714988123571 | -122.418319846488 | (37.7714988123571, -122.418319846488) | 8 | 2 | 9 | 28853 | 19 | |||
| 178446 | 190659 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6016267.56187 | 2097668.72921 | 37.740711974479 | -122.386311362403 | (37.740711974479, -122.386311362403) | 10 | 3 | 8 | 58 | 1 | |||
| 188054 | 35462 | DPW Maintained 1 | :: 45 | 1016 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 6 | Permit Number 38885 | 6014468.80099 | 2102427.52316 | 37.7536788925865 | -122.392863694223 | (37.7536788925865, -122.392863694223) | 10 | 3 | 8 | 28856 | 29 | |
| 188780 | 228483 | DPW Maintained 1 | :: 45 | 950 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999780.4847 | 2102039.74605 | 37.751787354827 | -122.443631159362 | (37.751787354827, -122.443631159362) | 2 | 5 | 5 | 63 | 38 | |||
| 17409 | 228439 | DPW Maintained 1 | :: 45 | 589 Haight St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003347.45965 | 2109278.2341 | 37.7718652941806 | -122.431812868891 | (37.7718652941806, -122.431812868891) | 15 | 9 | 11 | 29492 | 10 | |||
| 25068 | 246384 | DPW Maintained 1 | :: 45 | 1655 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6006982.6308 | 2109153.3972 | 37.7717279173795 | -122.419229672629 | (37.7717279173795, -122.419229672629) | 8 | 2 | 9 | 28853 | 19 | |||
| 27039 | 228495 | DPW Maintained 1 | :: 45 | 505 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004273.17296 | 2105900.15512 | 37.7626423365047 | -122.42836995112 | (37.7626423365047, -122.42836995112) | 8 | 4 | 5 | 28862 | 3 | |||
| 28980 | 246178 | DPW Maintained 1 | :: 45 | 1588 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997994.7111 | 2108230.9638 | 37.7686848738553 | -122.450252812112 | (37.7686848738553, -122.450252812112) | 15 | 5 | 11 | 29492 | 9 | |||
| 29438 | 183889 | DPW Maintained 1 | :: 45 | 1390 Quintara St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5988959.6443 | 2101014.682 | 37.7483497078007 | -122.480975613562 | (37.7483497078007, -122.480975613562) | 1 | 8 | 3 | 29491 | 35 | |||
| 39375 | 246383 | DPW Maintained 1 | :: 45 | 1655 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6006970.497 | 2109128.1185 | 37.771657824727 | -122.419269850794 | (37.771657824727, -122.419269850794) | 8 | 2 | 9 | 28853 | 19 | |||
| 39743 | 25492 | DPW Maintained 1 | :: 45 | 645 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/2001 12:00:00 AM | 5 | 3X3 | 6003043.5783 | 2109236.3656 | 37.7717331028377 | -122.432861023333 | (37.7717331028377, -122.432861023333) | 15 | 5 | 11 | 29492 | 9 | ||
| 52218 | 129090 | DPW Maintained 1 | :: 45 | 190 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011386.68599 | 2120789.41334 | 37.8039247024384 | -122.404815037597 | (37.8039247024384, -122.404815037597) | 3 | 1 | 10 | 28860 | 6 | |||
| 76329 | 246385 | DPW Maintained 1 | :: 45 | 1655 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6006994.7646 | 2109179.687 | 37.7718007862576 | -122.419189566122 | (37.7718007862576, -122.419189566122) | 8 | 2 | 9 | 28853 | 19 | |||
| 87438 | 219181 | DPW Maintained 1 | :: 45 | 431 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5999211.06214 | 2094946.25439 | 37.7322778337559 | -122.445090379531 | (37.7322778337559, -122.445090379531) | 9 | 7 | 4 | 59 | 40 | |||
| 89757 | 121132 | Undocumented 4 | :: 45 | 645 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002309 | 2100005 | 37.7463443097186 | -122.434741732797 | (37.7463443097186, -122.434741732797) | 2 | 7 | 5 | 63 | 22 | |||
| 106160 | 124473 | DPW Maintained 1 | :: 45 | 356 Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45077 | 5996305.70499 | 2110483.22678 | 37.7747721989488 | -122.456257787006 | (37.7747721989488, -122.456257787006) | 11 | 6 | 2 | 54 | 16 | |
| 113485 | 190671 | DPW Maintained 1 | :: 45 | 149 Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013262.02792 | 2111394.33223 | 37.7782326570475 | -122.397665892288 | (37.7782326570475, -122.397665892288) | 6 | 2 | 9 | 28856 | 34 | |||
| 113799 | 228442 | DPW Maintained 1 | :: 45 | 413 Haight St | 1 | : | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004129.64861 | 2109389.34953 | 37.7722146987825 | -122.429115146464 | (37.7722146987825, -122.429115146464) | 7 | 9 | 11 | 29492 | 10 | ||
| 117031 | 228446 | DPW Maintained 1 | :: 45 | 379 Haight St | 1 | : | Tree | Private 2 | 5 | Width 5ft | 6004344.90177 | 2109415.20014 | 37.7722978608825 | -122.428372409862 | (37.7722978608825, -122.428372409862) | 7 | 9 | 11 | 28852 | 10 | |||
| 127479 | 228492 | DPW Maintained 1 | :: 45 | 3746 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003450.5613 | 2103629.24333 | 37.7563603732352 | -122.431052978634 | (37.7563603732352, -122.431052978634) | 2 | 4 | 5 | 28862 | 3 | |||
| 129732 | 228443 | DPW Maintained 1 | :: 45 | 401 Haight St | 1 | : | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004157.65728 | 2109393.74469 | 37.7722283522845 | -122.429018575473 | (37.7722283522845, -122.429018575473) | 7 | 9 | 11 | 29492 | 10 | ||
| 134703 | 129088 | DPW Maintained 1 | :: 45 | 190 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011425.38411 | 2120792.86026 | 37.8039363297663 | -122.40468136238 | (37.8039363297663, -122.40468136238) | 3 | 1 | 10 | 28860 | 6 | |||
| 135422 | 123610 | DPW Maintained 1 | :: 45 | 135 03rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994873.21088 | 2114645.23418 | 37.7861176222016 | -122.461514846643 | (37.7861176222016, -122.461514846643) | 11 | 6 | 1 | 54 | 11 | |||
| 141371 | 129087 | DPW Maintained 1 | :: 45 | 190 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011445.1234 | 2120796.34037 | 37.8039469885131 | -122.404613298068 | (37.8039469885131, -122.404613298068) | 3 | 1 | 10 | 28860 | 6 | |||
| 147088 | 24920 | DPW Maintained 1 | :: 45 | 430 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6004056.545 | 2109425.8569 | 37.7723108006121 | -122.429370621982 | (37.7723108006121, -122.429370621982) | 7 | 9 | 11 | 29492 | 10 | |||
| 155136 | 228490 | DPW Maintained 1 | :: 45 | 512 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004210.50257 | 2105904.81342 | 37.762651580625 | -122.428587037577 | (37.762651580625, -122.428587037577) | 8 | 4 | 5 | 28862 | 3 | |||
| 155672 | 228496 | DPW Maintained 1 | :: 45 | 505 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004270.14488 | 2105926.96043 | 37.762715766133 | -122.428382334783 | (37.762715766133, -122.428382334783) | 8 | 4 | 5 | 28862 | 3 | |||
| 166746 | 228499 | DPW Maintained 1 | :: 45 | 38 Levant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000241.54312 | 2106649.97851 | 37.7644722077423 | -122.442367702717 | (37.7644722077423, -122.442367702717) | 15 | 5 | 5 | 28862 | 3 | |||
| 176137 | 244228 | DPW Maintained 1 | :: 45 | 500 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003580.1475 | 2109359.8483 | 37.7721025743544 | -122.431013811567 | (37.7721025743544, -122.431013811567) | 15 | 9 | 11 | 29492 | 10 | |||
| 188269 | 244494 | DPW Maintained 1 | :: 45 | 400 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 0ft | 6004177.5073 | 2109444.407 | 37.7723685822151 | -122.428953525151 | (37.7723685822151, -122.428953525151) | 7 | 9 | 11 | 29492 | 10 | ||
| 320 | 228444 | DPW Maintained 1 | :: 45 | 399 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004268.91864 | 2109406.82097 | 37.7722705538615 | -122.428634644993 | (37.7722705538615, -122.428634644993) | 7 | 9 | 11 | 28852 | 10 | |||
| 402 | 183817 | DPW Maintained 1 | :: 45 | 2133 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5986490.2175 | 2100252.0265 | 37.7461118053863 | -122.489458644673 | (37.7461118053863, -122.489458644673) | 1 | 8 | 3 | 29491 | 35 | |||
| 13385 | 244231 | DPW Maintained 1 | :: 45 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003405.9505 | 2109334.219 | 37.7720223304628 | -122.431614542708 | (37.7720223304628, -122.431614542708) | 15 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 28735 | 228493 | DPW Maintained 1 | :: 45 | 3748 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003428.54428 | 2103628.48028 | 37.7563570304699 | -122.431129066663 | (37.7563570304699, -122.431129066663) | 2 | 4 | 5 | 28862 | 3 | |||
| 30439 | 10286 | DPW Maintained 1 | :: 45 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6004126.8809 | 2109434.3591 | 37.7723381274034 | -122.429127930043 | (37.7723381274034, -122.429127930043) | 7 | 9 | 11 | 29492 | 10 |
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) );