trees
835 rows where qSpecies_id = 122 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
594 | 20063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
942 | 67185 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.7608734252807 | -122.449765371246 | (37.7608734252807, -122.449765371246) | 15 | 5 | 11 | 29492 | 12 | |
1329 | 124750 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.7758081630602 | -122.42740756863 | (37.7758081630602, -122.42740756863) | 7 | 9 | 11 | 28852 | 10 | |||
1353 | 203642 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 349x Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 5993150.97673 | 2103877.75625 | 37.7564537210662 | -122.466690296437 | (37.7564537210662, -122.466690296437) | 1 | 8 | 4 | 56 | 12 | |||
1532 | 219991 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 13 Bronte St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009385.52811 | 2097403.78697 | 37.739601163374 | -122.410088220496 | (37.739601163374, -122.410088220496) | 10 | 7 | 7 | 28859 | 2 | |||
1577 | 19793 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
1762 | 30595 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
1889 | 259158 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
2028 | 76748 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | 1 | 8 | 3 | 56 | 35 | ||
2035 | 68350 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 535 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32169 | 5989368.29935 | 2111675.70215 | 37.7776457288828 | -122.48034272561 | (37.7776457288828, -122.48034272561) | 11 | 6 | 2 | 55 | 26 | |
2364 | 38049 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.7860141835177 | -122.442004950262 | (37.7860141835177, -122.442004950262) | 13 | 6 | 1 | 29490 | 27 | |
2449 | 220048 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 201 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 | |||
2461 | 73754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.409684302662 | (37.8025101678048, -122.409684302662) | 3 | 1 | 10 | 308 | 23 | |||
2542 | 32891 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.7603305839468 | -122.462923499947 | (37.7603305839468, -122.462923499947) | 1 | 5 | 4 | 56 | 12 | ||
2756 | 39703 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.4472036828 | (37.7318275120035, -122.4472036828) | 9 | 7 | 4 | 59 | 40 | ||
2797 | 220079 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4021 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003566.56829 | 2104171.42308 | 37.7578556427516 | -122.430690474488 | (37.7578556427516, -122.430690474488) | 2 | 4 | 5 | 28862 | 3 | |||
2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
2860 | 78000 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | 1 | 8 | 3 | 29491 | 35 | |||
3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
3138 | 71805 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2451 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987333.5642 | 2098599.3879 | 37.7416232962242 | -122.486421183565 | (37.7416232962242, -122.486421183565) | 1 | 8 | 3 | 29491 | 35 | |||
3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3321 | 220066 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002537.11463 | 2102291.14962 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | 2 | 4 | 5 | 28862 | 22 | |||
3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3985 | 69145 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2419 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 6 | Permit Number 33179 | 5983608.7607 | 2098659.5816 | 37.741570751884 | -122.499304541285 | (37.741570751884, -122.499304541285) | 1 | 8 | 3 | 29491 | 35 | |
4389 | 220051 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 399X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006837 | 2098006 | 37.7411115324804 | -122.418942651587 | (37.7411115324804, -122.418942651587) | 2 | 7 | 7 | 28859 | 2 | |||
4487 | 259159 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
4696 | 117040 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
4729 | 38050 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.7860213405762 | -122.441934174319 | (37.7860213405762, -122.441934174319) | 13 | 6 | 1 | 29490 | 27 | |
5032 | 85509 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
5047 | 37814 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) | 9 | 7 | 6 | 28861 | 5 |
5053 | 247838 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 79 Nevada St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | 6009045.88807 | 2098099.79815 | 37.7414932155318 | -122.411311709481 | (37.7414932155318, -122.411311709481) | 10 | 7 | 7 | 28859 | 2 | ||||
5215 | 20061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
5516 | 248395 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 8 | Width 0ft | Permit Number 41881 | 5997659.0251 | 2108142.2349 | 37.7684220306889 | -122.451407517669 | (37.7684220306889, -122.451407517669) | 15 | 5 | 11 | 29492 | 9 | |
5666 | 81675 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013305 | 2104816 | 37.7601724196148 | -122.397055866002 | (37.7601724196148, -122.397055866002) | 10 | 3 | 8 | 28856 | 29 | |||
5685 | 245867 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005023.743 | 2110457.4751 | 37.7751980841556 | -122.426098447818 | (37.7751980841556, -122.426098447818) | 7 | 9 | 11 | 28852 | 10 | |||
5787 | 19577 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
6049 | 35103 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.435437534334 | (37.7168332689419, -122.435437534334) | 9 | 7 | 6 | 28861 | 5 | ||
6360 | 83538 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 243 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004140.21383 | 2089715.70651 | 37.7181960153187 | -122.427676641269 | (37.7181960153187, -122.427676641269) | 9 | 7 | 6 | 28861 | 5 | |||
6554 | 51248 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47625 | 6007471.15651424 | 2105682.67696043 | 37.7622256337552 | -122.417293833991 | (37.7622256337552, -122.417293833991) | 8 | 4 | 7 | 28859 | 19 | ||
6622 | 124083 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3434 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5992631.55645 | 2110040.63137 | 37.7733453553708 | -122.468935093468 | (37.7733453553708, -122.468935093468) | 11 | 6 | 2 | 54 | 11 | |||
6630 | 30591 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 253 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34560 | |||||||||||||
7013 | 220677 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6006108.91147 | 2104316.67896 | 37.758398187544 | -122.421908293434 | (37.758398187544, -122.421908293434) | 2 | 4 | 5 | 28859 | 19 | ||
7171 | 203639 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5992221.12373 | 2089294.63928 | 37.7163584485498 | -122.468844858017 | (37.7163584485498, -122.468844858017) | 9 | 8 | 6 | 64 | 24 | |||
7229 | 73391 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001816.88591 | 2094039.23102 | 37.7299357428343 | -122.43601658702 | (37.7299357428343, -122.43601658702) | 9 | 7 | 6 | 28861 | 25 | |||
7242 | 83227 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.397163015669 | (37.7601232913798, -122.397163015669) | 10 | 3 | 8 | 28856 | 29 | |||
7303 | 220693 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3873 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004694.52758 | 2100732.52355 | 37.7484770663623 | -122.426544650217 | (37.7484770663623, -122.426544650217) | 2 | 4 | 5 | 63 | 22 | |||
7577 | 248396 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 7 | Width 0ft | Permit Number 41881 | 5997671.1383 | 2108143.749 | 37.7684268816356 | -122.451365728625 | (37.7684268816356, -122.451365728625) | 15 | 5 | 11 | 29492 | 9 | |
8295 | 70299 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001826.35316 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | 9 | 7 | 6 | 28861 | 25 | |||
8412 | 203659 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.447256912002 | (37.7320962615306, -122.447256912002) | 9 | 7 | 4 | 59 | 40 | |||
8433 | 220003 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1001 Jarboe Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 8ft | 6009413 | 2096866 | 37.738126056693 | -122.40995527996 | (37.738126056693, -122.40995527996) | 10 | 7 | 7 | 28859 | 2 | |||
8463 | 203650 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5993848.38247 | 2094813.02416 | 37.7316044735649 | -122.463620576647 | (37.7316044735649, -122.463620576647) | 9 | 8 | 4 | 59 | 40 | |||
8576 | 32346 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
8595 | 66640 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.7562136300125 | -122.407049963033 | (37.7562136300125, -122.407049963033) | 10 | 4 | 7 | 28859 | 19 | ||
8738 | 44456 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.7103071803111 | -122.432895389109 | (37.7103071803111, -122.432895389109) | 9 | 7 | 6 | 28861 | 5 | |
9025 | 30594 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
9093 | 33190 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | 1 | 5 | 4 | 59 | 40 | ||
9399 | 188509 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 6014325.64698 | 2106424.64729 | 37.7646461780098 | -122.393638496141 | (37.7646461780098, -122.393638496141) | 14 | 3 | 8 | 310 | 29 | ||||
9783 | 261822 | Significant Tree 6 | Acacia baileyana :: Bailey's Acacia 122 | 3580 21st St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | Permit Number 785112 | 6004538.52309 | 2103691.84305 | 37.7565938462521 | -122.427294885373 | (37.7565938462521, -122.427294885373) | 2 | 4 | 5 | 28862 | 3 | |||
9936 | 203633 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997727.84983 | 2094119.15999 | 37.7299220605503 | -122.450158563772 | (37.7299220605503, -122.450158563772) | 9 | 7 | 4 | 28861 | 40 | |||
10056 | 188508 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6014332.46782 | 2106283.64375 | 37.764259392178 | -122.393605035044 | (37.764259392178, -122.393605035044) | 14 | 3 | 8 | 310 | 29 | ||||
10295 | 188526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1427x Innes Ave | 12 | Median : Yard | Tree | DPW 1 | 13 | 6016254.90623 | 2096663.38381 | 37.7379507994938 | -122.386285047323 | (37.7379507994938, -122.386285047323) | 10 | 3 | 8 | 58 | 1 | ||||
10486 | 38055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2779 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 5 | Permit Number 40250 | 6000228.6146 | 2114392.8852 | 37.7857315284908 | -122.442968502827 | (37.7857315284908, -122.442968502827) | 15 | 6 | 1 | 29490 | 27 | |
11039 | 19285 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
11302 | 34144 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39666 | 6003955.69985192 | 2098004.27278913 | 37.7409441243389 | -122.428905023889 | (37.7409441243389, -122.428905023889) | 2 | 7 | 5 | 63 | 7 | ||
11831 | 66789 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1405 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30063 | 6006130.65101914 | 2119658.78326709 | 37.8005250955758 | -122.42292350049 | (37.8005250955758, -122.42292350049) | 13 | 9 | 1 | 28858 | 32 |
11891 | 38044 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1523 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 11 | Permit Number 40245 | 6000092.6356 | 2114341.0582 | 37.7855814713487 | -122.443435225951 | (37.7855814713487, -122.443435225951) | 15 | 6 | 1 | 29490 | 31 | |
11908 | 220089 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Ord Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6000884.7117 | 2105729.84303 | 37.7619823797984 | -122.440077179831 | (37.7619823797984, -122.440077179831) | 15 | 5 | 5 | 28862 | 3 | |||
12288 | 199070 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1130 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 0 | 6013384.89381 | 2101721.18884 | 37.7516791861622 | -122.3965626049 | (37.7516791861622, -122.3965626049) | 10 | 3 | 8 | 28856 | 29 | ||||
12666 | 48033 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 61 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2002 12:00:00 AM | Permit Number 45754 | 6001724.06677399 | 2105480.90222389 | 37.7613465972478 | -122.437156358638 | (37.7613465972478, -122.437156358638) | 15 | 4 | 5 | 28862 | 3 | |||
12702 | 32557 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3822 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 770192 | 6002956.41958884 | 2103022.59282687 | 37.7546666427143 | -122.432718557235 | (37.7546666427143, -122.432718557235) | 2 | 4 | 5 | 28862 | 22 | |||
13029 | 20056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
13093 | 54840 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 236 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1972 12:00:00 AM | 6 | 3x3 | Permit Number 10695 | 5998822.5685 | 2109866.5256 | 37.7732230519388 | -122.447507074191 | (37.7732230519388, -122.447507074191) | 15 | 5 | 11 | 29492 | 16 |
13298 | 75250 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994476.95751 | 2086787.32717 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | 9 | 8 | 6 | 28861 | 25 | |||
13307 | 37952 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1308 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40191 | 6013419.73141926 | 2106176.98186548 | 37.7639157629311 | -122.396754475262 | (37.7639157629311, -122.396754475262) | 14 | 3 | 8 | 28856 | 29 | ||
13458 | 37949 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.397224649796 | (37.7586622221997, -122.397224649796) | 10 | 3 | 8 | 28856 | 29 | |
13475 | 20057 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
13642 | 78061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 107 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6006671.07774 | 2094291.78297 | 37.7309037694737 | -122.419252940787 | (37.7309037694737, -122.419252940787) | 9 | 3 | 7 | 309 | 28 | |||
14412 | 71308 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1949 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000243.5 | 2111616.6716 | 37.7781096083019 | -122.442717588877 | (37.7781096083019, -122.442717588877) | 15 | 5 | 11 | 29490 | 16 | |||
14481 | 123124 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 798 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2019 12:00:00 AM | 3 | Width 4ft | 5992601.67217 | 2110090.43708 | 37.773480381816 | -122.469042091828 | (37.773480381816, -122.469042091828) | 11 | 6 | 2 | 54 | 11 | ||
14833 | 20055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
14981 | 20060 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
15280 | 124754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2077 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784537 | 6003727.74275 | 2117577.18944 | 37.7946736966861 | -122.431089877801 | (37.7946736966861, -122.431089877801) | 13 | 9 | 1 | 29490 | 27 | |
15282 | 220063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.7541717777287 | -122.432223106309 | (37.7541717777287, -122.432223106309) | 2 | 4 | 5 | 28862 | 22 | |||
15287 | 40295 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 48 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41439 | 6005981.28847445 | 2102313.08870522 | 37.7528895951686 | -122.422207325088 | (37.7528895951686, -122.422207325088) | 2 | 4 | 5 | 28859 | 19 | ||
15295 | 220081 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 780 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003049.24321 | 2103668.76893 | 37.7564461523878 | -122.432443698342 | (37.7564461523878, -122.432443698342) | 2 | 4 | 5 | 28862 | 3 | |||
15560 | 261375 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 434 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | 7 | 9 | 11 | 28852 | 10 | ||||
15606 | 174964 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1645 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006075.21093 | 2092385.59149 | 37.7256362082245 | -122.421177650028 | (37.7256362082245, -122.421177650028) | 9 | 7 | 7 | 309 | 5 | |||
15666 | 44745 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1520 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2001 12:00:00 AM | 8 | Permit Number 43862 | 6006829.6851 | 2117719.85237 | 37.7952406976494 | -122.420366856354 | (37.7952406976494, -122.420366856354) | 13 | 9 | 10 | 28858 | 32 | ||
16044 | 19729 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
16325 | 38333 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | 7 | 9 | 9 | 28852 | 36 | |||
16364 | 203625 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997311.4729 | 2099621.76413 | 37.7450070466421 | -122.451994860675 | (37.7450070466421, -122.451994860675) | 9 | 7 | 4 | 59 | 40 | |||
16365 | 203647 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993596.72892 | 2093377.09996 | 37.7276472749004 | -122.464386369131 | (37.7276472749004, -122.464386369131) | 9 | 8 | 4 | 59 | 40 | |||
16553 | 75408 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994441.08765 | 2086786.63151 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | 9 | 8 | 6 | 28861 | 25 | |||
16743 | 50472 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
17237 | 123125 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 798 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2019 12:00:00 AM | 3 | Width 4ft | 5992603.0812 | 2110069.8115 | 37.7734238309341 | -122.469035716481 | (37.7734238309341, -122.469035716481) | 11 | 6 | 2 | 54 | 11 | ||
17907 | 70572 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 421 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5999717.91 | 2110099.0732 | 37.773912694204 | -122.444426694754 | (37.773912694204, -122.444426694754) | 15 | 5 | 11 | 29492 | 16 | |||
17915 | 35351 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1274 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 11 | 5x5 | Permit Number 38813 | 6012220.8536 | 2102461.75759 | 37.7536477760478 | -122.400640051912 | (37.7536477760478, -122.400640051912) | 10 | 3 | 8 | 28856 | 29 |
18343 | 38054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | 15 | 6 | 1 | 29490 | 27 | |
18718 | 262041 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1550 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5993090.57371 | 2104919.01452 | 37.7593092592319 | -122.466974886903 | (37.7593092592319, -122.466974886903) | 1 | 8 | 4 | 56 | 12 | ||||
18917 | 220049 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 201 Rivoli St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 |
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) );