trees
835 rows where qSpecies_id = 122 sorted by YCoord
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 | |||||||||||||
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 | |||||||||||||
2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
5215 | 20061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
5787 | 19577 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
13029 | 20056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
13475 | 20057 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
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 | |||||||||||||
16044 | 19729 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
144396 | 31059 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 301 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34810 | 6001654.06728241 | 2086489.02532865 | 37.7091953182451 | -122.436039409516 | (37.7091953182451, -122.436039409516) | 9 | 7 | 6 | 28861 | 5 |
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 | |||
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 | |||
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 | |||
118536 | 174959 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 103 De Long St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 10ft | 5994397.11424 | 2086788.06602 | 37.7096014661041 | -122.461142043293 | (37.7096014661041, -122.461142043293) | 9 | 8 | 6 | 28861 | 25 | |||
185826 | 174960 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 103 De Long St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 10ft | 5994409.59914 | 2086788.11813 | 37.7096023276577 | -122.461098897396 | (37.7096023276577, -122.461098897396) | 9 | 8 | 6 | 28861 | 25 | |||
120603 | 95590 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767380 | 6002599.7 | 2086870.1 | 37.7102953437444 | -122.432798364191 | (37.7102953437444, -122.432798364191) | 9 | 7 | 6 | 28861 | 5 | |
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 | |
182859 | 44451 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 81 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 10 | Permit Number 48336 | 6002602.78622 | 2086898.2858 | 37.7103729108497 | -122.43278970978 | (37.7103729108497, -122.43278970978) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||
70503 | 50653 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 151 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47235 | 5996872.39579561 | 2087134.54464453 | 37.710694953359 | -122.452612074363 | (37.710694953359, -122.452612074363) | 9 | 7 | 6 | 28861 | 25 | |||
88116 | 32739 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 137 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37122 | 5995581.47746257 | 2088674.4560737 | 37.7148491391882 | -122.457185072361 | (37.7148491391882, -122.457185072361) | 9 | 8 | 6 | 28861 | 24 | ||
40096 | 32740 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 139 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37123 | 5995564.95354615 | 2088674.66529796 | 37.7148487646576 | -122.457242200681 | (37.7148487646576, -122.457242200681) | 9 | 8 | 6 | 28861 | 24 | ||
43669 | 43708 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 503 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | 9 | 8 | 6 | 28861 | 24 | ||
110437 | 43707 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 503 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | 9 | 8 | 6 | 28861 | 24 | ||
189981 | 43706 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 503 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | 9 | 8 | 6 | 28861 | 24 | ||
122748 | 35134 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 849 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38664 | 6001545.25839951 | 2089134.40240899 | 37.716452756426 | -122.43660469328 | (37.716452756426, -122.43660469328) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
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 | |||
171790 | 203640 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 5992221.60329 | 2089317.43063 | 37.7164210557753 | -122.468844858002 | (37.7164210557753, -122.468844858002) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
62316 | 31180 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 344 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34878 | 5993129.55455829 | 2089868.58886975 | 37.717986817508 | -122.465746580217 | (37.717986817508, -122.465746580217) | 9 | 8 | 6 | 64 | 24 | ||
113238 | 43731 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 766 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43368 | 5994373.49554275 | 2089956.67715953 | 37.7183003625969 | -122.461453233071 | (37.7183003625969, -122.461453233071) | 9 | 8 | 6 | 28861 | 24 | ||
154114 | 37833 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 20 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003832.66245 | 2090342.46114 | 37.7198995444156 | -122.428784371324 | (37.7198995444156, -122.428784371324) | 9 | 7 | 6 | 28861 | 5 |
36159 | 37832 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 19 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48867 | 6003860.1558 | 2090386.44981 | 37.7200218836872 | -122.42869247048 | (37.7200218836872, -122.42869247048) | 9 | 7 | 6 | 28861 | 5 |
106618 | 203641 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 608 Garfield St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992400.09934 | 2090515.70507 | 37.7197215370907 | -122.468315017932 | (37.7197215370907, -122.468315017932) | 9 | 8 | 6 | 64 | 24 | |||
37421 | 37816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003955.66683 | 2090537.19552 | 37.720441203374 | -122.428373060073 | (37.720441203374, -122.428373060073) | 9 | 7 | 6 | 28861 | 5 |
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 |
184336 | 37815 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003965.72194 | 2090553.13154 | 37.7204855291627 | -122.428339438009 | (37.7204855291627, -122.428339438009) | 9 | 7 | 6 | 28861 | 5 |
101682 | 66237 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29335 | 5995558.06563814 | 2090587.62307484 | 37.7201008998033 | -122.45740432201 | (37.7201008998033, -122.45740432201) | 9 | 8 | 6 | 28861 | 24 | ||
100046 | 203638 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994537.11563 | 2090599.09131 | 37.7200736945131 | -122.460934206371 | (37.7200736945131, -122.460934206371) | 9 | 8 | 6 | 28861 | 24 | |||
32895 | 109672 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994496 | 2090624 | 37.7201397218642 | -122.461078132621 | (37.7201397218642, -122.461078132621) | 9 | 8 | 6 | 28861 | 24 | ||||
95101 | 109671 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 798x GRAFTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994496 | 2090624 | 37.7201397218642 | -122.461078132621 | (37.7201397218642, -122.461078132621) | 9 | 8 | 6 | 28861 | 24 | ||||
49903 | 37828 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2006 12:00:00 AM | 8 | 3x3 | Permit Number 48867 | 6003752 | 2090699 | 37.720873955994 | -122.429088601305 | (37.720873955994, -122.429088601305) | 9 | 7 | 6 | 28861 | 5 |
80555 | 37837 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 23 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752 | 2090699 | 37.720873955994 | -122.429088601305 | (37.720873955994, -122.429088601305) | 9 | 7 | 6 | 28861 | 5 |
187446 | 37835 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752 | 2090699 | 37.720873955994 | -122.429088601305 | (37.720873955994, -122.429088601305) | 9 | 7 | 6 | 28861 | 5 |
163529 | 45313 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 359 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44150 | 5991933.83383604 | 2090925.21902291 | 37.7208190204058 | -122.469956518243 | (37.7208190204058, -122.469956518243) | 9 | 8 | 6 | 64 | 24 | ||
165658 | 17229 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1880X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6000980.93913 | 2091103.33988 | 37.7218269300432 | -122.438696258244 | (37.7218269300432, -122.438696258244) | 9 | 7 | 6 | 28861 | 25 | |||
161026 | 174958 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 60 Onondaga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000890.31977 | 2091107.65045 | 37.7218336102096 | -122.439009814053 | (37.7218336102096, -122.439009814053) | 9 | 7 | 6 | 28861 | 25 | |||
130218 | 17224 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1880X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6001029.5778 | 2091188.70927 | 37.7220641019562 | -122.438534240876 | (37.7220641019562, -122.438534240876) | 9 | 7 | 6 | 28861 | 25 | |||
42433 | 30931 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 407 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34744 | 5995614.80249177 | 2091194.83311768 | 37.7217714131354 | -122.457252106382 | (37.7217714131354, -122.457252106382) | 9 | 8 | 6 | 28861 | 24 | ||
192293 | 35368 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 627 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38828 | 6011631.82829511 | 2091600.41039567 | 37.72379195201 | -122.401913589843 | (37.72379195201, -122.401913589843) | 10 | 3 | 7 | 309 | 28 | ||
41929 | 35367 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.7237949110596 | -122.401914809778 | (37.7237949110596, -122.401914809778) | 10 | 3 | 7 | 309 | 28 | ||
73002 | 37857 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 50 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.424964225997 | (37.7235254489092, -122.424964225997) | 9 | 7 | 6 | 28861 | 5 | ||
41811 | 37853 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 639 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40143 | 6003947.74961722 | 2091786.98448726 | 37.7238724004315 | -122.428489463759 | (37.7238724004315, -122.428489463759) | 9 | 7 | 6 | 28861 | 5 | ||
149598 | 37852 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 639 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40143 | 6003947.74961722 | 2091786.98448726 | 37.7238724004315 | -122.428489463759 | (37.7238724004315, -122.428489463759) | 9 | 7 | 6 | 28861 | 5 | ||
24178 | 50663 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
64398 | 50661 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
175410 | 50664 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
192367 | 50662 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
123669 | 92754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 880 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52983 | 6005536.79298 | 2091854.05704 | 37.7241463625482 | -122.423001157676 | (37.7241463625482, -122.423001157676) | 9 | 7 | 6 | 309 | 5 | |
62902 | 43173 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 382 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42982 | 6005820.96717 | 2091946.15603 | 37.7244152778362 | -122.42202534829 | (37.7244152778362, -122.42202534829) | 9 | 7 | 7 | 309 | 5 | |
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 | |
99566 | 43170 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 364 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 2 | Permit Number 42979 | 6005800.19112 | 2092023.15601 | 37.7246255312328 | -122.422102636037 | (37.7246255312328, -122.422102636037) | 9 | 7 | 7 | 309 | 5 | |
171199 | 174961 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 54 Santa Ynez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6000769.59798 | 2092028.99302 | 37.7243565377 | -122.439493130409 | (37.7243565377, -122.439493130409) | 9 | 7 | 6 | 28861 | 25 | ||||
133936 | 174962 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 114 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000450.3974 | 2092235.26707 | 37.7249047473371 | -122.440611347459 | (37.7249047473371, -122.440611347459) | 9 | 7 | 6 | 28861 | 25 | |||
144249 | 43150 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 301 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 7 | Permit Number 43804 | 6006064.01993 | 2092337.88288 | 37.7255045798588 | -122.421212950242 | (37.7255045798588, -122.421212950242) | 9 | 7 | 7 | 309 | 5 | |
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 | |||
135721 | 43148 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 301 Gambier St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | Permit Number 42961 | 6006052.5972483 | 2092387.2151737 | 37.7256393916299 | -122.421255939073 | (37.7256393916299, -122.421255939073) | 9 | 7 | 7 | 309 | 5 | |||
158963 | 43149 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 301 Gambier St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | Permit Number 42961 | 6006052.5972483 | 2092387.2151737 | 37.7256393916299 | -122.421255939073 | (37.7256393916299, -122.421255939073) | 9 | 7 | 7 | 309 | 5 | |||
134400 | 174965 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1645 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006090.3331 | 2092391.29935 | 37.7256527332703 | -122.421125778931 | (37.7256527332703, -122.421125778931) | 9 | 7 | 7 | 309 | 5 | |||
54060 | 108677 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Otsego Ave | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.82413 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | 9 | 7 | 6 | 28861 | 25 | |
142807 | 108678 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 11 Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773206 | 6000980.19802 | 2092997.83802 | 37.7270287484854 | -122.438834512765 | (37.7270287484854, -122.438834512765) | 9 | 7 | 6 | 28861 | 25 |
113974 | 43143 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 140 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | Permit Number 42956 | 6005786.06556581 | 2093081.91758291 | 37.7275318626033 | -122.422226653074 | (37.7275318626033, -122.422226653074) | 9 | 7 | 7 | 309 | 5 | ||
131370 | 64173 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 30 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1987 12:00:00 AM | Permit Number 24955 | 5992735.52734942 | 2093091.96966529 | 37.7268146975842 | -122.467342804105 | (37.7268146975842, -122.467342804105) | 9 | 8 | 4 | 59 | 40 | ||
114869 | 64176 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 7 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2000 12:00:00 AM | Permit Number 24959 | 5992913.91992547 | 2093156.51419592 | 37.7270022179247 | -122.466730800624 | (37.7270022179247, -122.466730800624) | 9 | 8 | 4 | 59 | 40 | ||
50530 | 174963 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 27 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005106.80972 | 2093312.66064 | 37.7281270946664 | -122.424591254394 | (37.7281270946664, -122.424591254394) | 9 | 7 | 6 | 28861 | 5 | |||
115504 | 40071 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1459 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41297 | 6015490.41779177 | 2093366.98866113 | 37.7288572181843 | -122.388698234625 | (37.7288572181843, -122.388698234625) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
102174 | 41993 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 75 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42333 | 5993572.90365136 | 2093435.37616672 | 37.7278059137082 | -122.464472962263 | (37.7278059137082, -122.464472962263) | 9 | 8 | 4 | 59 | 40 | ||
46532 | 42111 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
64639 | 42110 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 100@ Detroit Judson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
106487 | 42112 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 100@ Detroit Judson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
55913 | 203667 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999360.3584 | 2093511.22392 | 37.7283460957947 | -122.444471133337 | (37.7283460957947, -122.444471133337) | 9 | 7 | 4 | 28861 | 40 | |||
85645 | 42113 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 136 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | 9 | 7 | 4 | 28861 | 40 | ||
123091 | 42114 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 136 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2006 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | 9 | 7 | 4 | 28861 | 40 | ||
139274 | 30763 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1542 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34644 | 6014903.15895955 | 2093519.78776627 | 37.7292442091543 | -122.390739119468 | (37.7292442091543, -122.390739119468) | 10 | 3 | 8 | 58 | 1 | ||
20938 | 33356 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 200 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37493 | 5994058.57591139 | 2093537.34847989 | 37.7281138896418 | -122.462801390817 | (37.7281138896418, -122.462801390817) | 9 | 8 | 4 | 59 | 40 | ||
50536 | 203666 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999405.93855 | 2093561.74161 | 37.7284874062446 | -122.4443171901 | (37.7284874062446, -122.4443171901) | 9 | 7 | 4 | 28861 | 40 | |||
28963 | 203665 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999403.44951 | 2093584.38933 | 37.7285494495997 | -122.444327421686 | (37.7285494495997, -122.444327421686) | 9 | 7 | 4 | 28861 | 40 | |||
60994 | 203664 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999403.20337 | 2093610.52776 | 37.7286212055976 | -122.444330150233 | (37.7286212055976, -122.444330150233) | 9 | 7 | 4 | 28861 | 40 | |||
32638 | 203223 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994463.96401 | 2093754.28831 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | 9 | 8 | 4 | 59 | 40 | |||
98134 | 30758 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1557 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34639 | 6014967.84012217 | 2093755.65118605 | 37.7298954311335 | -122.390531983655 | (37.7298954311335, -122.390531983655) | 10 | 3 | 8 | 58 | 1 | ||
44328 | 203663 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 271 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998288.80546 | 2093783.09686 | 37.7290313953773 | -122.448195092827 | (37.7290313953773, -122.448195092827) | 9 | 7 | 4 | 28861 | 40 |
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) );