trees
1,914 rows where qSpecies_id = 45 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 89 | 259623 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||||||||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||||||||||
| 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 | |
| 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 | ||||||||||||
| 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 | ||
| 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 | ||||||||||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | ||||||||||||
| 11756 | 108765 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
| 11783 | 31192 | Permitted Site 7 | :: 45 | 744 Shields St | 5 | 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 | ||
| 12259 | 259644 | DPW Maintained 1 | :: 45 | 242 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009897.37379 | 2088143.4673 | 37.7142029478201 | -122.40766570902 | (37.7142029478201, -122.40766570902) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | ||||||||||||
| 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 |
| 12908 | 259612 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 13540 | 259645 | DPW Maintained 1 | :: 45 | 243 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009883.66375 | 2088105.89025 | 37.7140990014395 | -122.407710448479 | (37.7140990014395, -122.407710448479) | 9 | 7 | 8 | 309 | 39 | ||
| 14450 | 259622 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 14847 | 259625 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 15847 | 259635 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 16470 | 36527 | Permitted Site 7 | :: 45 | 619 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328 | 2097732 | 37.7403868250383 | -122.417225535064 | (37.7403868250383, -122.417225535064) | 2 | 7 | 7 | 28859 | 2 | ||
| 16880 | 259621 | DPW Maintained 1 | :: 45 | 1398x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 16911 | 259646 | DPW Maintained 1 | :: 45 | 266 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009756.62408 | 2088194.82004 | 37.7143360719186 | -122.408155816313 | (37.7143360719186, -122.408155816313) | 9 | 7 | 8 | 309 | 39 | ||
| 17095 | 259633 | DPW Maintained 1 | :: 45 | 37 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011138.57107 | 2087522.45708 | 37.7125671815686 | -122.403331965599 | (37.7125671815686, -122.403331965599) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | ||||||||||||
| 17929 | 259649 | DPW Maintained 1 | :: 45 | 700 Delta St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 17931 | 259643 | DPW Maintained 1 | :: 45 | 241 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 18354 | 36517 | Permitted Site 7 | :: 45 | 430 Crescent Ave | 2 | 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 | ||
| 18667 | 259652 | DPW Maintained 1 | :: 45 | 99x Cora St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 18887 | 259638 | DPW Maintained 1 | :: 45 | 99x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 19114 | 259651 | DPW Maintained 1 | :: 45 | 598x Rutland St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 20009 | 40513 | Permitted Site 7 | :: 45 | 1620 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41577 | 5999999.85509787 | 2110944.48687978 | 37.7762500681911 | -122.443512144169 | (37.7762500681911, -122.443512144169) | 15 | 5 | 11 | 29492 | 16 | ||
| 21621 | 37520 | Permitted Site 7 | :: 45 | 649 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39973 | 6008796.59183246 | 2114756.17350418 | 37.7872137988014 | -122.413351333091 | (37.7872137988014, -122.413351333091) | 5 | 1 | 10 | 28852 | 36 | ||
| 26512 | 114567 | Permitted Site 7 | :: 45 | 1930 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/2015 12:00:00 AM | 3x3 | 6008702.7 | 2119505.5 | 37.8002490116896 | -122.414012289596 | (37.8002490116896, -122.414012289596) | 3 | 1 | 10 | 308 | 32 | ||
| 26985 | 41854 | Permitted Site 7 | :: 45 | 942 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42241 | 5991990.35837611 | 2105257.12694546 | 37.7601740626082 | -122.470804559297 | (37.7601740626082, -122.470804559297) | 1 | 8 | 4 | 56 | 12 | ||
| 27852 | 37456 | Permitted Site 7 | :: 45 | 442 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39929 | 6010236.40979486 | 2098631.79989851 | 37.7430206762597 | -122.407232767953 | (37.7430206762597, -122.407232767953) | 10 | 7 | 7 | 28859 | 2 | ||
| 29005 | 38003 | Permitted Site 7 | :: 45 | 2478 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2002 12:00:00 AM | Permit Number 40215 | 5992069.67302471 | 2098579.11634993 | 37.7418425623068 | -122.470043991015 | (37.7418425623068, -122.470043991015) | 1 | 8 | 4 | 29491 | 40 | ||
| 29284 | 36507 | Permitted Site 7 | :: 45 | 584 Anderson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.7361990307601 | -122.415517981354 | (37.7361990307601, -122.415517981354) | 2 | 7 | 7 | 28859 | 2 | ||
| 30113 | 33407 | Permitted Site 7 | :: 45 | 100 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 33016 | 31148 | Permitted Site 7 | :: 45 | 500 Hearst Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.7307613077995 | -122.44892931603 | (37.7307613077995, -122.44892931603) | 9 | 7 | 4 | 59 | 40 | ||
| 38005 | 35482 | Permitted Site 7 | :: 45 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | 9 | 3 | 7 | 309 | 28 | ||
| 40795 | 35996 | Permitted Site 7 | :: 45 | 36 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39146 | 6007490.93822931 | 2099869.27557104 | 37.7462644727809 | -122.416813538412 | (37.7462644727809, -122.416813538412) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 42415 | 108792 | Permitted Site 7 | :: 45 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008053.41125 | 2093004.09823 | 37.7274458184293 | -122.414382893832 | (37.7274458184293, -122.414382893832) | 9 | 3 | 7 | 309 | 28 | ||||
| 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 | |
| 46675 | 34454 | DPW Maintained 1 | :: 45 | 881 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 14 | Permit Number 38198 | 6008682.26912 | 2120023.63237 | 37.8016705265302 | -122.414119665415 | (37.8016705265302, -122.414119665415) | 3 | 1 | 10 | 308 | 32 | |
| 47607 | 33409 | Permitted Site 7 | :: 45 | 100 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 47920 | 36532 | Permitted Site 7 | :: 45 | 3734St. Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39405 | 6008419.88910724 | 2097501.78967285 | 37.7398160862313 | -122.413433924041 | (37.7398160862313, -122.413433924041) | 2 | 7 | 7 | 28859 | 2 | ||
| 48114 | 37632 | Permitted Site 7 | :: 45 | 791 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40050 | 5990357.50342651 | 2110002.09732806 | 37.7731079035048 | -122.476798459473 | (37.7731079035048, -122.476798459473) | 11 | 6 | 2 | 55 | 26 | ||
| 49621 | 34737 | Permitted Site 7 | :: 45 | 575 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38387 | 6007300.76294173 | 2103973.10640079 | 37.7575219604166 | -122.417761979765 | (37.7575219604166, -122.417761979765) | 2 | 4 | 7 | 28859 | 19 | ||
| 50379 | 36993 | Permitted Site 7 | :: 45 | 2974 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39613 | 6008419.31343349 | 2103324.4841574 | 37.7558038738313 | -122.413847688409 | (37.7558038738313, -122.413847688409) | 2 | 4 | 7 | 28859 | 19 | ||
| 51165 | 35095 | Permitted Site 7 | :: 45 | 647 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38637 | 6002415.60861753 | 2090011.70468142 | 37.7189110558626 | -122.433659002065 | (37.7189110558626, -122.433659002065) | 9 | 7 | 6 | 28861 | 5 | ||
| 52125 | 32457 | Permitted Site 7 | :: 45 | 210 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36972 | 6003808.4224833 | 2109079.21792679 | 37.7713449641267 | -122.430204165931 | (37.7713449641267, -122.430204165931) | 7 | 9 | 11 | 29492 | 10 | ||
| 55119 | 43025 | Permitted Site 7 | :: 45 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42886 | 6004125.6708626 | 2110297.9605007 | 37.774709297051 | -122.429193705112 | (37.774709297051, -122.429193705112) | 7 | 9 | 11 | 28852 | 10 | ||
| 55800 | 108629 | Undocumented 4 | :: 45 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | 15 | 5 | 5 | 29492 | 9 | |||
| 57586 | 33514 | Permitted Site 7 | :: 45 | 371 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37614 | 6006108.24130768 | 2097930.15080676 | 37.7408622046731 | -122.421457054715 | (37.7408622046731, -122.421457054715) | 2 | 7 | 7 | 28859 | 2 | ||
| 57625 | 52296 | Permitted Site 7 | :: 45 | 677DIAMOND ST Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48457 | 6002165.96993722 | 2099704.44459938 | 37.7455109340163 | -122.435214819168 | (37.7455109340163, -122.435214819168) | 2 | 7 | 5 | 63 | 22 | ||
| 59897 | 41853 | Permitted Site 7 | :: 45 | 936 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42240 | 5992008.2421953 | 2105257.75589238 | 37.7601768237518 | -122.470742754033 | (37.7601768237518, -122.470742754033) | 1 | 8 | 4 | 56 | 12 | ||
| 60026 | 40070 | Permitted Site 7 | :: 45 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | 10 | 3 | 8 | 58 | 1 | ||
| 61663 | 108793 | Permitted Site 7 | :: 45 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008053.41125 | 2093004.09823 | 37.7274458184293 | -122.414382893832 | (37.7274458184293, -122.414382893832) | 9 | 3 | 7 | 309 | 28 | ||||
| 63227 | 33408 | Permitted Site 7 | :: 45 | 100 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 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 | |
| 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 | |
| 66255 | 33411 | Permitted Site 7 | :: 45 | 100 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 66626 | 30705 | Permitted Site 7 | :: 45 | 371 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34615 | 6005225.74804899 | 2110232.43831944 | 37.7745916029272 | -122.425383648395 | (37.7745916029272, -122.425383648395) | 7 | 9 | 11 | 28852 | 10 | ||
| 67063 | 33463 | Permitted Site 7 | :: 45 | 20 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/1996 12:00:00 AM | Permit Number 37562 | 6006978.38557579 | 2099649.65289984 | 37.7456325955283 | -122.418570316182 | (37.7456325955283, -122.418570316182) | 2 | 7 | 7 | 28859 | 2 | ||
| 72881 | 34736 | Permitted Site 7 | :: 45 | 569 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38386 | 6007298.90712997 | 2104006.62448648 | 37.7576138889301 | -122.417770773708 | (37.7576138889301, -122.417770773708) | 2 | 4 | 7 | 28859 | 19 | ||
| 74348 | 36518 | Permitted Site 7 | :: 45 | 430 Crescent Ave | 4 | 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 | ||
| 74354 | 109262 | Permitted Site 7 | :: 45 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |
| 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 | |
| 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 | |
| 88405 | 42090 | Permitted Site 7 | :: 45 | 25 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42397 | 6008240.69863747 | 2099401.70748619 | 37.7450227780609 | -122.414187874949 | (37.7450227780609, -122.414187874949) | 2 | 7 | 7 | 28859 | 2 |
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) );