trees
2,694 rows where qSpecies_id = 84 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
884 | 261406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
3071 | 31851 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
4023 | 31850 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
4740 | 119761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
4940 | 39332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
5244 | 261407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
6169 | 39333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
11366 | 53918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
12262 | 261408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
3526 | 65715 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 735 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1996 12:00:00 AM | Permit Number 28647 | 6009189.05467178 | 2115445.35577198 | 37.7891281538301 | -122.412042214215 | (37.7891281538301, -122.412042214215) | 5 | 1 | 10 | 28858 | 21 | ||
3665 | 261403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 746 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010031.95335 | 2118510.77151 | 37.797592298166 | -122.409342294069 | (37.797592298166, -122.409342294069) | 3 | 1 | 10 | 308 | 4 | |||||
4516 | 259272 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1705 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2019 12:00:00 AM | 3 | 6009597.7323 | 2119503.87292 | 37.8002947722719 | -122.410914999374 | (37.8002947722719, -122.410914999374) | 3 | 1 | 10 | 308 | 4 | |||
4562 | 261421 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009867.40288 | 2118488.04976 | 37.7975206891225 | -122.409910080478 | (37.7975206891225, -122.409910080478) | 3 | 1 | 10 | 308 | 4 | |||||
5710 | 261400 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 730 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010100.55131 | 2118520.19892 | 37.7976220266446 | -122.409105591228 | (37.7976220266446, -122.409105591228) | 3 | 1 | 10 | 308 | 4 | |||||
7392 | 261325 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 644 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010473 | 2118597 | 37.79785376133 | -122.407822230627 | (37.79785376133, -122.407822230627) | 3 | 1 | 10 | 308 | 4 | ||||
7700 | 261404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 754 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009997.65437 | 2118506.05781 | 37.7975774337622 | -122.409460645418 | (37.7975774337622, -122.409460645418) | 3 | 1 | 10 | 308 | 4 | |||||
8968 | 261399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 715 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010168.78657 | 2118489.20051 | 37.7975407349103 | -122.408867289597 | (37.7975407349103, -122.408867289597) | 3 | 1 | 10 | 308 | 4 | |||||
9928 | 261390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 638 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010519.78547 | 2118576.37921 | 37.7977997607314 | -122.407658884309 | (37.7977997607314, -122.407658884309) | 3 | 1 | 10 | 308 | 4 | |||||
10250 | 261397 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 720 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010143.42503 | 2118526.09105 | 37.7976406066987 | -122.408957651874 | (37.7976406066987, -122.408957651874) | 3 | 1 | 10 | 308 | 4 | |||||
10978 | 261419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 781 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009855.16282 | 2118445.96033 | 37.7974044358704 | -122.409949461749 | (37.7974044358704, -122.409949461749) | 3 | 1 | 10 | 308 | 4 | |||||
11519 | 261392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 670 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010377.23792 | 2118557.51621 | 37.7977399869991 | -122.408150809713 | (37.7977399869991, -122.408150809713) | 3 | 1 | 10 | 308 | 4 | |||||
11993 | 261391 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 660 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010421.78403 | 2118563.41089 | 37.7977586664904 | -122.407997083107 | (37.7977586664904, -122.407997083107) | 3 | 1 | 10 | 308 | 4 | |||||
12502 | 261420 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009867.40288 | 2118488.04976 | 37.7975206891225 | -122.409910080478 | (37.7975206891225, -122.409910080478) | 3 | 1 | 10 | 308 | 4 | |||||
14300 | 261393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 661 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010427.0314 | 2118523.75657 | 37.7976500791874 | -122.407976127788 | (37.7976500791874, -122.407976127788) | 3 | 1 | 10 | 308 | 4 | |||||
16091 | 261396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010229.17248 | 2118537.87531 | 37.7976777662505 | -122.408661772909 | (37.7976777662505, -122.408661772909) | 3 | 1 | 10 | 308 | 4 | |||||
17648 | 261398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 711 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010187.59569 | 2118491.78545 | 37.7975488860672 | -122.408802387211 | (37.7975488860672, -122.408802387211) | 3 | 1 | 10 | 308 | 4 | |||||
22816 | 142584 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2232 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008967.5673 | 2120856.1596 | 37.8039724587948 | -122.413191303597 | (37.8039724587948, -122.413191303597) | 3 | 1 | 10 | 308 | 23 | |||
23229 | 101446 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
23610 | 135902 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | 5 | 1 | 10 | 308 | 32 | ||||
23950 | 113748 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | ||||
25617 | 135906 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007265.47268 | 2119876.05587 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | 5 | 1 | 1 | 28858 | 32 | |||
28356 | 113747 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 6009570.41641 | 2118454.83114 | 37.7974128301892 | -122.410935389082 | (37.7974128301892, -122.410935389082) | 3 | 1 | 10 | 308 | 4 | |||
36608 | 142760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010826.0266 | 2120017.8226 | 37.8017747502564 | -122.406700835434 | (37.8017747502564, -122.406700835434) | 3 | 1 | 10 | 308 | 23 | |||
37145 | 73572 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52275 | 6010586 | 2116213 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | 5 | 1 | 10 | 28857 | 6 | |
41559 | 135907 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007940.29606 | 2119623.01107 | 37.80052881831 | -122.416658842755 | (37.80052881831, -122.416658842755) | 5 | 1 | 1 | 308 | 32 | |||
42153 | 143053 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6008940.2059 | 2120454.0688 | 37.8028668818708 | -122.413257538683 | (37.8028668818708, -122.413257538683) | 3 | 1 | 10 | 308 | 23 | |||
47408 | 142582 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2236 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008972.9977 | 2120827.456 | 37.8038939507527 | -122.413170480356 | (37.8038939507527, -122.413170480356) | 3 | 1 | 10 | 308 | 23 | |||
47793 | 142583 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2234 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008971.4462 | 2120841.4199 | 37.8039322050278 | -122.413176837453 | (37.8039322050278, -122.413176837453) | 3 | 1 | 10 | 308 | 23 | |||
51219 | 51045 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 8 | 3x3 | Permit Number 47518 | 6009984 | 2120227 | 37.8023019525749 | -122.4096294226 | (37.8023019525749, -122.4096294226) | 3 | 1 | 10 | 308 | 23 | |
53299 | 135909 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011530.70294 | 2119058.88107 | 37.79918113116 | -122.404194785955 | (37.79918113116, -122.404194785955) | 3 | 1 | 10 | 308 | 23 | ||||
67178 | 142764 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010752.149 | 2120007.2027 | 37.8017414569096 | -122.406955738459 | (37.8017414569096, -122.406955738459) | 3 | 1 | 10 | 308 | 23 | |||
76787 | 142761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010807.5572 | 2120014.5904 | 37.8017648420531 | -122.406764520508 | (37.8017648420531, -122.406764520508) | 3 | 1 | 10 | 308 | 23 | |||
78261 | 250308 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10 Redfield Aly | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.414769923808 | (37.8002391853351, -122.414769923808) | 5 | 1 | 10 | 308 | 32 | |||
78657 | 44057 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 708 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | 7 | Permit Number 43584 | 6007279.94096 | 2121616.88851 | 37.8059663388498 | -122.419085450154 | (37.8059663388498, -122.419085450154) | 5 | 1 | 1 | 28858 | 32 | ||
79248 | 91520 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 520 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52125 | 6011001.0511 | 2118999.3767 | 37.7989881374692 | -122.406023377789 | (37.7989881374692, -122.406023377789) | 3 | 1 | 10 | 308 | 23 | |
80951 | 135910 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6011521.09538 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | 3 | 1 | 10 | 308 | 23 | ||||
85441 | 142759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010846.8046 | 2120020.1312 | 37.801782251607 | -122.406629096352 | (37.801782251607, -122.406629096352) | 3 | 1 | 10 | 308 | 23 | |||
87841 | 135908 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | 3 | 1 | 10 | 308 | 23 | |||
88001 | 250309 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 12 Redfield Aly | 1 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | 5 | 1 | 10 | 308 | 32 | |||
94021 | 135911 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6011511.78534 | 2119057.53898 | 37.7991763890443 | -122.404260153176 | (37.7991763890443, -122.404260153176) | 3 | 1 | 10 | 308 | 23 | ||||
94594 | 135912 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011493.6768 | 2119059.8121 | 37.7991816185927 | -122.404322975344 | (37.7991816185927, -122.404322975344) | 3 | 1 | 10 | 308 | 23 | ||||
99785 | 135913 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 414 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011476.87781 | 2119044.52353 | 37.7991387011458 | -122.404380029217 | (37.7991387011458, -122.404380029217) | 3 | 1 | 10 | 308 | 23 | ||||
105171 | 143089 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 616 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009932.6738 | 2120241.3728 | 37.8023385404989 | -122.409808052185 | (37.8023385404989, -122.409808052185) | 3 | 1 | 10 | 308 | 23 | |||
106176 | 48786 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1405 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
110623 | 256194 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | |||||
111122 | 143052 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008958.7736 | 2120458.7538 | 37.8028807881226 | -122.413193616152 | (37.8028807881226, -122.413193616152) | 3 | 1 | 10 | 308 | 23 | |||
111704 | 34473 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1725 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1997 12:00:00 AM | 3 | Permit Number 38203 | 6008692.20922 | 2118946.49843 | 37.7987135430497 | -122.414009024508 | (37.7987135430497, -122.414009024508) | 5 | 1 | 10 | 308 | 21 | ||
116508 | 142480 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1656 POWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009655.9931 | 2119387.8477 | 37.7999794623587 | -122.410705194848 | (37.7999794623587, -122.410705194848) | 3 | 1 | 10 | 308 | 4 | |||
124134 | 44525 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1125 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2001 12:00:00 AM | Permit Number 43825 | 6008743.61210523 | 2117943.22188109 | 37.7959616805463 | -122.413760149906 | (37.7959616805463, -122.413760149906) | 5 | 1 | 10 | 308 | 21 | ||
129210 | 64402 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | FUF | 05/14/1988 12:00:00 AM | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||
131346 | 143091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 620 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009899.7854 | 2120236.6745 | 37.8023237969803 | -122.409921530777 | (37.8023237969803, -122.409921530777) | 3 | 1 | 10 | 308 | 23 | |||
131585 | 52827 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 750WASHINGTON Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2006 12:00:00 AM | 2 | 3x3 | Permit Number 48852 | 6011323.0636 | 2117546.9613 | 37.7950181606921 | -122.404806791825 | (37.7950181606921, -122.404806791825) | 3 | 1 | 10 | 28857 | 4 | |
137443 | 48787 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1405 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
138401 | 135903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 8 Marion Pl | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6008339.85894 | 2119440.03353 | 37.8000488717233 | -122.41526322892 | (37.8000488717233, -122.41526322892) | 5 | 1 | 10 | 308 | 32 | ||||
139388 | 142758 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6010864.8123 | 2120023.3634 | 37.8017921339071 | -122.406567008949 | (37.8017921339071, -122.406567008949) | 3 | 1 | 10 | 308 | 23 | |||
152362 | 116779 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1031 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2016 12:00:00 AM | 3 | 3x3 | 6008650 | 2118281 | 37.7968838784408 | -122.414107975451 | (37.7968838784408, -122.414107975451) | 5 | 1 | 10 | 308 | 21 | ||
153658 | 52828 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 750WASHINGTON Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2006 12:00:00 AM | 2 | Permit Number 48852 | 6011319.3348 | 2117592.1734 | 37.7951420938167 | -122.404822878731 | (37.7951420938167, -122.404822878731) | 3 | 1 | 10 | 28857 | 4 | ||
156989 | 113745 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009609.4912 | 2118458.30583 | 37.797424561837 | -122.410800425125 | (37.797424561837, -122.410800425125) | 3 | 1 | 10 | 308 | 4 | ||||
158039 | 135901 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 8 Marion Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008342.53499 | 2119419.33537 | 37.7999921901354 | -122.415252502723 | (37.7999921901354, -122.415252502723) | 5 | 1 | 10 | 308 | 32 | ||||
160756 | 73592 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586 | 2116213 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | 5 | 1 | 10 | 28857 | 6 | |
161443 | 256195 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 858X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009435 | 2118466 | 37.7974359028634 | -122.411404756359 | (37.7974359028634, -122.411404756359) | 3 | 1 | 10 | 308 | 4 | |||||
172388 | 135914 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 414 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6011471.49553 | 2119063.8107 | 37.7991913582649 | -122.404400012157 | (37.7991913582649, -122.404400012157) | 3 | 1 | 10 | 308 | 23 | |||
172565 | 113746 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009590.33174 | 2118455.97825 | 37.7974170965836 | -122.410866557642 | (37.7974170965836, -122.410866557642) | 3 | 1 | 10 | 308 | 4 | ||||
177460 | 142763 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010767.3863 | 2120009.5113 | 37.8017486483835 | -122.406903172911 | (37.8017486483835, -122.406903172911) | 3 | 1 | 10 | 308 | 23 | |||
178146 | 66596 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1166 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 2 | Permit Number 29789 | 6008318.17747093 | 2115921.39203862 | 37.7903863327738 | -122.415089057915 | (37.7903863327738, -122.415089057915) | 5 | 1 | 10 | 28858 | 21 | |
181217 | 101447 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
189039 | 82029 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586 | 2116213 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | 5 | 1 | 10 | 28857 | 6 | |
190450 | 52532 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1636@ UNION Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5x5 | Permit Number 48631 | 6009676.39438666 | 2119273.10665206 | 37.7996655555567 | -122.410626491106 | (37.7996655555567, -122.410626491106) | 3 | 1 | 10 | 308 | 4 | |
192813 | 60884 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 811 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2013 12:00:00 AM | 4 | Permit Number 769979 | 6009011.35018 | 2119721.10568 | 37.8008583416072 | -122.412959487805 | (37.8008583416072, -122.412959487805) | 3 | 1 | 10 | 308 | 32 | |
193098 | 13090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 724 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2004 12:00:00 AM | 12 | 3X3 | 6008885.9219 | 2120447.4555 | 37.8028456756355 | -122.413444921903 | (37.8028456756355, -122.413444921903) | 3 | 1 | 10 | 308 | 23 | ||
45122 | 87992 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 230 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51030 | 6008092 | 2113193 | 37.7828821185058 | -122.41567835443 | (37.7828821185058, -122.41567835443) | 7 | 10 | 9 | 28852 | 36 | ||
7694 | 44088 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | 6 | 2 | 9 | 28856 | 34 | |
9392 | 70671 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 73 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6010033.5172 | 2110899.92735 | 37.7766948289379 | -122.408799654802 | (37.7766948289379, -122.408799654802) | 8 | 2 | 9 | 28853 | 34 | |||
11747 | 66492 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 8 | Permit Number 29653 | 6009972.98695 | 2110931.16988 | 37.7767772230325 | -122.409011252663 | (37.7767772230325, -122.409011252663) | 8 | 2 | 9 | 28853 | 34 | |
11798 | 66507 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 64 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | Permit Number 29671 | 6009973.94739461 | 2110908.31483893 | 37.7767145222423 | -122.409006317188 | (37.7767145222423, -122.409006317188) | 8 | 2 | 9 | 28853 | 34 | ||
13963 | 63055 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 3 | Permit Number 29651 | 6010016.44472 | 2110878.7775 | 37.7766358001278 | -122.408857221277 | (37.7766358001278, -122.408857221277) | 8 | 2 | 9 | 28853 | 34 | |
16541 | 73456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009946.95062 | 2110955.66255 | 37.776843015637 | -122.409103049163 | (37.776843015637, -122.409103049163) | 8 | 2 | 9 | 28853 | 34 |
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) );