trees
1,914 rows where qSpecies_id = 45 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 314 | 184219 | DPW Maintained 1 | :: 45 | 3439 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984114.8945 | 2104934.4274 | 37.7588294281219 | -122.498017803137 | (37.7588294281219, -122.498017803137) | 1 | 8 | 3 | 56 | 35 | |||
| 316 | 245380 | DPW Maintained 1 | :: 45 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005334.5439 | 2097112.3285 | 37.7385729952273 | -122.424074069598 | (37.7385729952273, -122.424074069598) | 2 | 7 | 5 | 28859 | 2 | |||
| 325 | 248307 | DPW Maintained 1 | :: 45 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.445507509409 | (37.7691713129844, -122.445507509409) | 15 | 5 | 11 | 29492 | 9 | |||
| 354 | 141882 | DPW Maintained 1 | :: 45 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | 7 | 9 | 11 | 29490 | 41 | |||
| 360 | 181895 | DPW Maintained 1 | :: 45 | 2366 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986431.1624 | 2099136.6325 | 37.7430457847891 | -122.489580839702 | (37.7430457847891, -122.489580839702) | 1 | 8 | 3 | 29491 | 35 | |||
| 370 | 183768 | DPW Maintained 1 | :: 45 | 2295 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987606.9921 | 2099698.5467 | 37.744657229257 | -122.485556419265 | (37.744657229257, -122.485556419265) | 1 | 8 | 3 | 29491 | 35 | |||
| 373 | 200940 | DPW Maintained 1 | :: 45 | 1515 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6008432.2434 | 2109068.8895 | 37.7715774111529 | -122.414209373869 | (37.7715774111529, -122.414209373869) | 8 | 2 | 9 | 28853 | 19 | |||
| 375 | 115067 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 377 | 142111 | DPW Maintained 1 | :: 45 | 36 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998636.7696 | 2110968.1942 | 37.7762373313333 | -122.448229118378 | (37.7762373313333, -122.448229118378) | 15 | 6 | 2 | 29492 | 16 | |||
| 380 | 116339 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
| 386 | 143336 | DPW Maintained 1 | :: 45 | 1858 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004106.6848 | 2118733.7418 | 37.797870758582 | -122.429861223474 | (37.797870758582, -122.429861223474) | 13 | 9 | 1 | 57 | 17 | |||
| 388 | 109369 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
| 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 | ||||||
| 392 | 108811 | Undocumented 4 | :: 45 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 396 | 182481 | DPW Maintained 1 | :: 45 | 1556 36th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985002.9582 | 2104611.8375 | 37.7579957124827 | -122.494922727233 | (37.7579957124827, -122.494922727233) | 1 | 8 | 3 | 56 | 35 | |||
| 401 | 183745 | DPW Maintained 1 | :: 45 | 2267 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986363.4761 | 2099812.4858 | 37.7448975449574 | -122.489864573201 | (37.7448975449574, -122.489864573201) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 423 | 140125 | DPW Maintained 1 | :: 45 | 1321 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001271.8045 | 2112891.6174 | 37.7816688523257 | -122.439251726799 | (37.7816688523257, -122.439251726799) | 15 | 5 | 11 | 29490 | 41 | |||
| 426 | 183962 | DPW Maintained 1 | :: 45 | 2158 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5989481.017 | 2100669.218 | 37.7474314478739 | -122.479147472521 | (37.7474314478739, -122.479147472521) | 1 | 8 | 3 | 29491 | 35 | |||
| 427 | 114621 | Undocumented 4 | :: 45 | 2400X Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
| 452 | 182004 | DPW Maintained 1 | :: 45 | 3220 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986004.751 | 2098249.2905 | 37.7405844772428 | -122.490989950641 | (37.7405844772428, -122.490989950641) | 1 | 8 | 3 | 29491 | 35 | |||
| 466 | 116275 | Undocumented 4 | :: 45 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 468 | 121614 | Undocumented 4 | :: 45 | 800X Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001168 | 2102650 | 37.7535420028484 | -122.438876681597 | (37.7535420028484, -122.438876681597) | 2 | 4 | 5 | 28862 | 22 | ||||
| 519 | 259637 | DPW Maintained 1 | :: 45 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | |||
| 570 | 259611 | DPW Maintained 1 | :: 45 | 1420 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008434.50928 | 2087674.99824 | 37.7128346308013 | -122.412688855365 | (37.7128346308013, -122.412688855365) | 9 | 7 | 8 | 309 | 39 | ||
| 610 | 182578 | DPW Maintained 1 | :: 45 | 2451 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5988885.5665 | 2098636.2758 | 37.7418149236633 | -122.481057645938 | (37.7418149236633, -122.481057645938) | 1 | 8 | 3 | 29491 | 35 | |||
| 758 | 228462 | DPW Maintained 1 | :: 45 | 227 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.7683047783783 | -122.418472926402 | (37.7683047783783, -122.418472926402) | 8 | 4 | 7 | 28853 | 19 | |||
| 1432 | 228461 | Planning Code 138.1 required 2 | :: 45 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 782329 | 6005355.14245 | 2107219.1964 | 37.7663252752163 | -122.424721643507 | (37.7663252752163, -122.424721643507) | 8 | 4 | 5 | 28853 | 19 | ||
| 1482 | 29956 | DPW Maintained 1 | :: 45 | 600 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 6003212.3178 | 2109308.4177 | 37.7719405092432 | -122.432282489737 | (37.7719405092432, -122.432282489737) | 15 | 5 | 11 | 29492 | 9 | ||
| 1503 | 33210 | Permitted Site 7 | :: 45 | 80 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.7446507048802 | -122.454762009134 | (37.7446507048802, -122.454762009134) | 1 | 5 | 4 | 59 | 40 | |||
| 1764 | 184684 | DPW Maintained 1 | :: 45 | 3341 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983838.0977 | 2104243.1006 | 37.7569150061 | -122.498924003867 | (37.7569150061, -122.498924003867) | 1 | 8 | 3 | 56 | 35 | |||
| 1914 | 116946 | Undocumented 4 | :: 45 | 3676 23RD ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005238 | 2102584 | 37.7535915013127 | -122.424797029407 | (37.7535915013127, -122.424797029407) | 2 | 4 | 5 | 28859 | 19 | ||||
| 2002 | 182728 | DPW Maintained 1 | :: 45 | 1726 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985974.3316 | 2103468.8168 | 37.7549141067074 | -122.491479220658 | (37.7549141067074, -122.491479220658) | 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 | |||
| 2263 | 31189 | Permitted Site 7 | :: 45 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 2292 | 182145 | DPW Maintained 1 | :: 45 | 1452 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5989717.6723 | 2103818.6604 | 37.7560927247983 | -122.478559421541 | (37.7560927247983, -122.478559421541) | 1 | 8 | 3 | 56 | 35 | |||
| 2338 | 260969 | Permitted Site 7 | :: 45 | 897 37th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 11/05/2019 12:00:00 AM | 3 | 10X27 | 5984476.51719 | 2109749.52706 | 37.7720715265353 | -122.497122586729 | (37.7720715265353, -122.497122586729) | 11 | 6 | 2 | 55 | 26 | ||
| 2448 | 181960 | DPW Maintained 1 | :: 45 | 2455 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985784.4384 | 2098510.2137 | 37.7412880286271 | -122.491770899478 | (37.7412880286271, -122.491770899478) | 1 | 8 | 3 | 29491 | 35 | |||
| 2459 | 181830 | DPW Maintained 1 | :: 45 | 2319 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987925.2947 | 2099497.0517 | 37.7441225177456 | -122.484441029001 | (37.7441225177456, -122.484441029001) | 1 | 8 | 3 | 29491 | 35 | |||
| 2626 | 259634 | DPW Maintained 1 | :: 45 | 83 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010826.96041 | 2087682.93228 | 37.7129904051639 | -122.404420283412 | (37.7129904051639, -122.404420283412) | 9 | 7 | 8 | 309 | 39 | ||
| 2635 | 259636 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 2779 | 117319 | Permitted Site 7 | :: 45 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | 1 | 8 | 4 | 29491 | 12 | |||||
| 2785 | 261137 | DPW Maintained 1 | :: 45 | 2454 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981796.50413 | 2098381.86438 | 37.7407017304597 | -122.505550019662 | (37.7407017304597, -122.505550019662) | 1 | 8 | 3 | 29491 | 35 | |||||
| 2802 | 181592 | DPW Maintained 1 | :: 45 | 1659 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984670.7327 | 2103886.5941 | 37.7559849420617 | -122.496018183642 | (37.7559849420617, -122.496018183642) | 1 | 8 | 3 | 56 | 35 | |||
| 2959 | 141420 | DPW Maintained 1 | :: 45 | 550 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004578.5445 | 2111046.5078 | 37.7767902513835 | -122.427680466931 | (37.7767902513835, -122.427680466931) | 7 | 9 | 11 | 28852 | 10 | |||
| 3035 | 259640 | DPW Maintained 1 | :: 45 | 198x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | ||
| 3262 | 143122 | DPW Maintained 1 | :: 45 | 1965 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003008.0203 | 2119542.9474 | 37.8000303489096 | -122.433720773421 | (37.8000303489096, -122.433720773421) | 13 | 9 | 1 | 57 | 17 | |||
| 3520 | 259641 | DPW Maintained 1 | :: 45 | 234 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009944.29036 | 2088126.34972 | 37.7141585726669 | -122.407502340313 | (37.7141585726669, -122.407502340313) | 9 | 7 | 8 | 309 | 39 | ||
| 3549 | 141425 | DPW Maintained 1 | :: 45 | 301 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005907.6073 | 2110863.9151 | 37.7763639855674 | -122.423069853164 | (37.7763639855674, -122.423069853164) | 7 | 9 | 11 | 28852 | 10 | |||
| 3621 | 259642 | DPW Maintained 1 | :: 45 | 238 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009920.83207 | 2088134.90851 | 37.7141807602716 | -122.407584024659 | (37.7141807602716, -122.407584024659) | 9 | 7 | 8 | 309 | 39 | ||
| 3862 | 260676 | DPW Maintained 1 | :: 45 | 108 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2019 12:00:00 AM | 3 | 3x3 | 5992434.1895 | 2114741.52104 | 37.7862413120358 | -122.469960148163 | (37.7862413120358, -122.469960148163) | 11 | 6 | 2 | 54 | 11 | ||
| 4234 | 259615 | DPW Maintained 1 | :: 45 | 935 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009702.19768 | 2087158.08788 | 37.7114863694621 | -122.408270858441 | (37.7114863694621, -122.408270858441) | 9 | 7 | 8 | 309 | 39 | ||
| 4471 | 259626 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 4568 | 253833 | DPW Maintained 1 | :: 45 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
| 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 | |
| 4838 | 142080 | DPW Maintained 1 | :: 45 | 560 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000142.3776 | 2110889.4402 | 37.7761070510385 | -122.44301516716 | (37.7761070510385, -122.44301516716) | 15 | 5 | 11 | 29492 | 16 | |||
| 4944 | 259613 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 5006 | 259624 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 5098 | 251531 | DPW Maintained 1 | :: 45 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
| 5302 | 36500 | Permitted Site 7 | :: 45 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39380 | 6007942.28499887 | 2098248.55652594 | 37.7418397151309 | -122.41513812883 | (37.7418397151309, -122.41513812883) | 2 | 7 | 7 | 28859 | 2 | ||
| 5583 | 244247 | Undocumented 4 | :: 45 | 200 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005673.0642 | 2110022.689 | 37.7740409443959 | -122.423821374378 | (37.7740409443959, -122.423821374378) | 7 | 9 | 11 | 28852 | 10 | |||
| 5914 | 254656 | Private 9 | :: 45 | 640 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004524 | 2112776 | 37.781535924842 | -122.427992425483 | (37.781535924842, -122.427992425483) | 7 | 9 | 11 | 29490 | 41 | ||||
| 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 | |||
| 5982 | 259609 | DPW Maintained 1 | :: 45 | 1035 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009443.72066 | 2087255.36906 | 37.711739006489 | -122.40917108656 | (37.711739006489, -122.40917108656) | 9 | 7 | 8 | 309 | 39 | ||
| 6014 | 38201 | Permitted Site 7 | :: 45 | 254X Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40328 | 6010721.34684579 | 2091489.60477168 | 37.7234368466837 | -122.405053190481 | (37.7234368466837, -122.405053190481) | 10 | 3 | 7 | 309 | 28 | ||
| 6300 | 259616 | DPW Maintained 1 | :: 45 | 941 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009687.32277 | 2087163.71083 | 37.7115009759818 | -122.408322666595 | (37.7115009759818, -122.408322666595) | 9 | 7 | 8 | 309 | 39 | ||
| 6535 | 259627 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
| 6678 | 183829 | DPW Maintained 1 | :: 45 | 2214 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987634.5167 | 2100198.0441 | 37.7460303199634 | -122.485497894293 | (37.7460303199634, -122.485497894293) | 1 | 8 | 3 | 29491 | 35 | |||
| 6909 | 184218 | DPW Maintained 1 | :: 45 | 3441 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984096.8823 | 2104933.319 | 37.758825328706 | -122.49808001485 | (37.758825328706, -122.49808001485) | 1 | 8 | 3 | 56 | 35 | |||
| 7054 | 259630 | DPW Maintained 1 | :: 45 | 25 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011219.86081 | 2087480.59399 | 37.7124567737707 | -122.403048058633 | (37.7124567737707, -122.403048058633) | 9 | 7 | 8 | 309 | 39 | ||
| 7167 | 120669 | Undocumented 4 | :: 45 | 61 Paradise Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2016 12:00:00 AM | 3 | 3x3 | 6000974 | 2096001 | 37.7352743855737 | -122.439071080789 | (37.7352743855737, -122.439071080789) | 2 | 7 | 5 | 63 | 7 | ||
| 7226 | 139441 | DPW Maintained 1 | :: 45 | 501 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005361.8674 | 2111299.9206 | 37.7775303390293 | -122.424988750303 | (37.7775303390293, -122.424988750303) | 7 | 9 | 11 | 28852 | 10 | |||
| 7270 | 115892 | DPW Maintained 1 | :: 45 | 1900X Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.60834 | 37.75961937033 | -122.481684343854 | (37.75961937033, -122.481684343854) | 1 | 8 | 3 | 56 | 35 | |||
| 7294 | 259631 | DPW Maintained 1 | :: 45 | 86 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010819.87099 | 2087731.57587 | 37.7131235744523 | -122.404448208813 | (37.7131235744523, -122.404448208813) | 9 | 7 | 8 | 309 | 39 | ||
| 7483 | 116947 | Undocumented 4 | :: 45 | 3676 23RD ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005238 | 2102584 | 37.7535915013127 | -122.424797029407 | (37.7535915013127, -122.424797029407) | 2 | 4 | 5 | 28859 | 19 | ||||
| 7500 | 253261 | DPW Maintained 1 | :: 45 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2019 12:00:00 AM | 3 | 3x3 | 5990256 | 2113097 | 37.7815997636542 | -122.477375802178 | (37.7815997636542, -122.477375802178) | 11 | 6 | 2 | 55 | 26 | ||
| 7704 | 140222 | DPW Maintained 1 | :: 45 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003683.3616 | 2110416.1551 | 37.7750087812949 | -122.430732178175 | (37.7750087812949, -122.430732178175) | 7 | 9 | 11 | 29492 | 10 | |||
| 7724 | 259614 | DPW Maintained 1 | :: 45 | 928 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009731.2164 | 2087189.88087 | 37.7115752914499 | -122.408172802554 | (37.7115752914499, -122.408172802554) | 9 | 7 | 8 | 309 | 39 | ||
| 7759 | 181568 | DPW Maintained 1 | :: 45 | 1349 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984597.8609 | 2105995.9427 | 37.7617723563961 | -122.496425834494 | (37.7617723563961, -122.496425834494) | 1 | 8 | 3 | 56 | 35 | |||
| 7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | ||
| 8130 | 261244 | Permitted Site 7 | :: 45 | 1166 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 3 | 3x3 | 6009198.71093 | 2102367.64119 | 37.75322033811 | -122.41108468628 | (37.75322033811, -122.41108468628) | 2 | 4 | 7 | 28859 | 19 | ||
| 8417 | 259628 | DPW Maintained 1 | :: 45 | 100 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008465.19154 | 2087632.83273 | 37.7127205750598 | -122.412579828323 | (37.7127205750598, -122.412579828323) | 9 | 7 | 8 | 309 | 39 | ||
| 8424 | 261322 | Private 9 | :: 45 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2020 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 8458 | 259610 | DPW Maintained 1 | :: 45 | 1107 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009254.2033 | 2087326.13058 | 37.7119226839796 | -122.409831104788 | (37.7119226839796, -122.409831104788) | 9 | 7 | 8 | 309 | 39 | ||||
| 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 | ||
| 8915 | 253260 | DPW Maintained 1 | :: 45 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993234 | 2110465 | 37.7745453462497 | -122.466882031228 | (37.7745453462497, -122.466882031228) | 11 | 6 | 2 | 54 | 11 | ||||
| 8942 | 259632 | DPW Maintained 1 | :: 45 | 31 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011179.21594 | 2087501.52553 | 37.7125119777417 | -122.40319001201 | (37.7125119777417, -122.40319001201) | 9 | 7 | 8 | 309 | 39 | ||
| 9359 | 114615 | Undocumented 4 | :: 45 | 2400X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 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 | |
| 9699 | 139024 | DPW Maintained 1 | :: 45 | 2511 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000470.0552 | 2114083.3913 | 37.7848955007169 | -122.442110965396 | (37.7848955007169, -122.442110965396) | 15 | 6 | 11 | 29490 | 13 | |||
| 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 | |||
| 10228 | 142720 | Undocumented 4 | :: 45 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | 5 | 1 | 10 | 308 | 23 | ||||
| 10340 | 36516 | Permitted Site 7 | :: 45 | 430 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | 2 | 7 | 7 | 28859 | 2 | ||
| 10564 | 114630 | Undocumented 4 | :: 45 | 2400X Post St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 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 |
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) );