trees
835 rows where qSpecies_id = 122 sorted by qLegalStatus_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 | |||||||||||||
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 | |||||||||||||
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 | |||
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 | ||||
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 | |
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 | |||||||||||||
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 | |||||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||||
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 | ||
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 | ||||
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 | |||
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 | |||
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 | |||||||||||||
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 | |||
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 | |||
19224 | 261621 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1821 25th St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
19365 | 75331 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994458.53323 | 2086786.74836 | 37.7096013824613 | -122.460929674682 | (37.7096013824613, -122.460929674682) | 9 | 8 | 6 | 28861 | 25 | |||
19563 | 261622 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1281x Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012916 | 2101714 | 37.7516333407735 | -122.398183607514 | (37.7516333407735, -122.398183607514) | 10 | 3 | 8 | 28856 | 29 | ||||
19723 | 103888 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999371.6507 | 2110859.3099 | 37.7759803474835 | -122.445679140757 | (37.7759803474835, -122.445679140757) | 15 | 5 | 11 | 29492 | 16 | |||
20170 | 137728 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1989 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999638.3271 | 2111189.948 | 37.7769034171043 | -122.444780412241 | (37.7769034171043, -122.444780412241) | 15 | 5 | 11 | 29492 | 16 | |||
20429 | 220024 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4273 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002125.33793 | 2101175.24323 | 37.749547092337 | -122.435460513693 | (37.749547092337, -122.435460513693) | 2 | 4 | 5 | 28862 | 22 | |||
20553 | 68132 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1526 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 0 | Permit Number 31884 | 6000696.86081651 | 2113890.04393367 | 37.7843775414062 | -122.44131241544 | (37.7843775414062, -122.44131241544) | 15 | 6 | 11 | 29490 | 13 | |
20868 | 10688 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1221 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1991 12:00:00 AM | 6 | 3X3 | 6002001.6656 | 2110480.73 | 37.7750906677438 | -122.43655414222 | (37.7750906677438, -122.43655414222) | 15 | 5 | 11 | 29492 | 10 | ||
20947 | 42897 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2016 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 7 | Permit Number 42813 | 5986657.8903 | 2096958.6583 | 37.737078880033 | -122.488636837876 | (37.737078880033, -122.488636837876) | 1 | 8 | 3 | 29491 | 35 | |
22960 | 54500 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.397179019096 | (37.760298732933, -122.397179019096) | 10 | 3 | 8 | 28856 | 29 | |
23139 | 188511 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 33 | Front Yard : Yard | Tree | Private 2 | 2 | 6014272.76615 | 2106665.73514 | 37.7653052137955 | -122.393838275126 | (37.7653052137955, -122.393838275126) | 14 | 3 | 8 | 310 | 29 | ||||
23190 | 188515 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1401 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6014455.23285 | 2101981.54762 | 37.7524535851846 | -122.392879417078 | (37.7524535851846, -122.392879417078) | 10 | 3 | 8 | 28856 | 1 | ||||
23876 | 60312 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 545 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1982 12:00:00 AM | 10 | Permit Number 19882 | 5999669.64 | 2110412.2941 | 37.774769964844 | -122.444616185093 | (37.774769964844, -122.444616185093) | 15 | 5 | 11 | 29492 | 16 | ||
24541 | 43172 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 370 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 2 | Permit Number 42981 | 6005806.0739 | 2092004.68571 | 37.7245751476096 | -122.422080988441 | (37.7245751476096, -122.422080988441) | 9 | 7 | 7 | 309 | 5 | |
24732 | 219998 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 60 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005981.24616 | 2097649.70039 | 37.7400849896219 | -122.421876240696 | (37.7400849896219, -122.421876240696) | 2 | 7 | 7 | 28859 | 2 | |||
25189 | 251472 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589 | 2096875 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | 2 | 7 | 5 | 63 | 7 | |
25803 | 35250 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.8006015626823 | -122.42238315977 | (37.8006015626823, -122.42238315977) | 13 | 9 | 1 | 28858 | 32 | |
26074 | 220045 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 160 Marview Way | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5998323.68704 | 2103258.27383 | 37.755049936933 | -122.448756699664 | (37.755049936933, -122.448756699664) | 1 | 5 | 4 | 63 | 38 | |||
26523 | 40816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | 13 | 6 | 1 | 29490 | 27 | ||
27735 | 38526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199241 | -122.437330933595 | (37.797420199241, -122.437330933595) | 13 | 9 | 1 | 57 | 17 | ||
27905 | 220056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009277.43373 | 2100868.30065 | 37.7491078976199 | -122.410706569176 | (37.7491078976199, -122.410706569176) | 2 | 4 | 7 | 28859 | 19 | |||
28491 | 220050 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006755.51813 | 2098027.45978 | 37.741165867704 | -122.419225908968 | (37.741165867704, -122.419225908968) | 2 | 7 | 7 | 28859 | 2 | |||
28674 | 220021 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1334 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001964.61353 | 2100084.23013 | 37.7465422991033 | -122.435938247064 | (37.7465422991033, -122.435938247064) | 2 | 7 | 5 | 63 | 22 | |||
28804 | 44452 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 81 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002608.32736 | 2086901.11124 | 37.7103809831624 | -122.432770760164 | (37.7103809831624, -122.432770760164) | 9 | 7 | 6 | 28861 | 5 |
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) );