trees
835 rows where qSpecies_id = 122 sorted by TreeID descending
This data as json, CSV (advanced)
rowid | TreeID ▲ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117885 | 99760 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 4247 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Most likely planted/permitted with tree no. 1 on same day/permit. | 6002269 | 2101186 | 37.7495847859814 | -122.434964495609 | (37.7495847859814, -122.434964495609) | 2 | 4 | 5 | 28862 | 22 | |||
25439 | 98708 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 105X Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | 15 | 5 | 5 | 28862 | 3 | |||||
90689 | 98707 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 105X Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | 15 | 5 | 5 | 28862 | 3 | ||||
182428 | 98341 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 790X 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | 11 | 6 | 2 | 54 | 11 | |||
50159 | 98340 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 790X 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | 11 | 6 | 2 | 54 | 11 | |||
107205 | 98339 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3434 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992637 | 2110058.2 | 37.7733939086093 | -122.468917542393 | (37.7733939086093, -122.468917542393) | 11 | 6 | 2 | 54 | 11 | ||||
89407 | 98217 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
183386 | 95791 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 25 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767534 | 6005461 | 2104579 | 37.7590818984674 | -122.424167716579 | (37.7590818984674, -122.424167716579) | 2 | 4 | 5 | 28859 | 19 | |
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 | |
102533 | 94017 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3951 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53436 | 6004200 | 2100707 | 37.7483790153575 | -122.428252898939 | (37.7483790153575, -122.428252898939) | 2 | 4 | 5 | 63 | 22 | ||
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 | |
63385 | 87024 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 650 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49965 | 6001199 | 2102605 | 37.7534202073623 | -122.438766252724 | (37.7534202073623, -122.438766252724) | 2 | 4 | 5 | 28862 | 22 | |||
178294 | 859 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 400X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008091.17818 | 2095049.40427 | 37.7330639095777 | -122.414396992023 | (37.7330639095777, -122.414396992023) | 2 | 7 | 7 | 28859 | 2 | |||
23452 | 85510 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | 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 | ||||
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 | ||||
159060 | 85502 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
169039 | 85501 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
114424 | 85500 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
172612 | 84098 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3800 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51813 | 6003059.47886598 | 2103613.0333106 | 37.7562936960779 | -122.432404319205 | (37.7562936960779, -122.432404319205) | 2 | 4 | 5 | 28862 | 3 | ||
73895 | 84017 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50426 | 6002531.06648038 | 2102355.71188239 | 37.7528114140683 | -122.434141870719 | (37.7528114140683, -122.434141870719) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
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 | |||
151699 | 82779 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50449 | 6003096.61110421 | 2102822.62624393 | 37.7541255317067 | -122.432219457549 | (37.7541255317067, -122.432219457549) | 2 | 4 | 5 | 28862 | 22 | ||
113519 | 8188 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1272 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/1997 12:00:00 AM | 10 | 3X4 | 6001679.2828 | 2111174.9406 | 37.7769784708042 | -122.437719062833 | (37.7769784708042, -122.437719062833) | 15 | 5 | 11 | 29492 | 41 | ||
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 | |||
22711 | 81348 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 561 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774387 | 6002774.12023878 | 2102081.98215915 | 37.7520736087499 | -122.433281789286 | (37.7520736087499, -122.433281789286) | 2 | 4 | 5 | 28862 | 22 | |
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 | |||
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 | |||
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 | ||
106096 | 75790 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2080 FOLSOM ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/15/1997 12:00:00 AM | 3x3 | 6008075 | 2106289 | 37.7639244108872 | -122.415248284425 | (37.7639244108872, -122.415248284425) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
166730 | 71427 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.8029973115711 | -122.409613538987 | (37.8029973115711, -122.409613538987) | 3 | 1 | 10 | 308 | 23 | |
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 | |||
172731 | 70953 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2008 12:00:00 AM | 3x3 | Permit Number 50393 | 5992532.60289704 | 2098624.81220808 | 37.7419947820759 | -122.468446668857 | (37.7419947820759, -122.468446668857) | 1 | 8 | 4 | 29491 | 40 | ||
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 | |||
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 | |||
157212 | 69308 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1550 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | Permit Number 33387 | 5986864.5682116 | 2104707.11140573 | 37.7583661086574 | -122.488491577304 | (37.7583661086574, -122.488491577304) | 1 | 8 | 3 | 56 | 35 | ||
185229 | 69216 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1144 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33267 | 6008630.78048604 | 2101877.2067938 | 37.7518418503447 | -122.413014037434 | (37.7518418503447, -122.413014037434) | 2 | 4 | 7 | 28859 | 19 | ||
84611 | 69196 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1463 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33243 | 6009335.03931842 | 2100741.36404906 | 37.7487625875096 | -122.410498405401 | (37.7487625875096, -122.410498405401) | 2 | 4 | 7 | 28859 | 19 | ||
158466 | 69194 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1455 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33240 | 6009333.22604202 | 2100774.20133137 | 37.7488526497517 | -122.410506994166 | (37.7488526497517, -122.410506994166) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |
103337 | 69125 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 447 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33148 | 6005264.64007943 | 2110758.08466494 | 37.7760370972093 | -122.425286525812 | (37.7760370972093, -122.425286525812) | 7 | 9 | 11 | 28852 | 10 | ||
171024 | 68908 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 67 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32883 | 6001725.7944262 | 2105449.29562811 | 37.7612599114424 | -122.43714812038 | (37.7612599114424, -122.43714812038) | 15 | 4 | 5 | 28862 | 3 | ||
30127 | 68814 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32757 | 6002131.57604717 | 2095277.55167817 | 37.7333537609923 | -122.435017196532 | (37.7333537609923, -122.435017196532) | 9 | 7 | 5 | 63 | 40 | ||
62374 | 68758 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 216 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32681 | 6004133.43114203 | 2105726.5811327 | 37.762157835439 | -122.428840893 | (37.762157835439, -122.428840893) | 8 | 4 | 5 | 28862 | 3 | ||
101106 | 68703 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2081 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32615 | 6003689.8407303 | 2107120.9618087 | 37.7659613518454 | -122.430474597791 | (37.7659613518454, -122.430474597791) | 8 | 4 | 5 | 28862 | 3 | ||
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 | |
145443 | 68329 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1342 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 12 | Permit Number 32144 | 5991421.402 | 2110674.853 | 37.7750167634254 | -122.473167407124 | (37.7750167634254, -122.473167407124) | 11 | 6 | 2 | 54 | 26 | |
41100 | 68174 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 449 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/01/1995 12:00:00 AM | Permit Number 31945 | 5997091.52876923 | 2111801.84543591 | 37.778437859612 | -122.45363471008 | (37.778437859612, -122.45363471008) | 15 | 6 | 2 | 54 | 16 | ||
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 | |
82896 | 68073 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31811 | 5993016.05828809 | 2103198.83445662 | 37.7545817907356 | -122.467107528535 | (37.7545817907356, -122.467107528535) | 1 | 8 | 4 | 56 | 12 | ||
111234 | 67937 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 82 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31650 | 6004338.16538286 | 2095684.17990183 | 37.7345953163648 | -122.427417358908 | (37.7345953163648, -122.427417358908) | 2 | 7 | 5 | 28861 | 2 | ||
56879 | 67907 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 557 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 31610 | 5997734.62104287 | 2094370.88558597 | 37.7306136268107 | -122.450153291964 | (37.7306136268107, -122.450153291964) | 9 | 7 | 4 | 28861 | 40 | ||
177748 | 67906 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 351 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31609 | 5999092.51556245 | 2094349.39726639 | 37.7306322373229 | -122.44545731887 | (37.7306322373229, -122.44545731887) | 9 | 7 | 4 | 28861 | 40 | ||
126242 | 67849 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 418 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31518 | 6003175.81702239 | 2098647.04119394 | 37.7426648441893 | -122.431647448577 | (37.7426648441893, -122.431647448577) | 2 | 7 | 5 | 63 | 22 | ||
84697 | 67840 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3848 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31508 | 6004878.46361538 | 2100495.10573235 | 37.7478355684339 | -122.425891704855 | (37.7478355684339, -122.425891704855) | 2 | 4 | 5 | 63 | 22 | ||
136546 | 67831 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 567 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31588 | 6002790.53126483 | 2100024.99041055 | 37.7464265249041 | -122.433078083896 | (37.7464265249041, -122.433078083896) | 2 | 7 | 5 | 63 | 22 | ||
54989 | 67804 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 215 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1994 12:00:00 AM | Permit Number 31453 | 6003763.62243652 | 2100965.95054031 | 37.7490653321175 | -122.429780349464 | (37.7490653321175, -122.429780349464) | 2 | 4 | 5 | 28862 | 22 | ||
113788 | 67803 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 211 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2015 12:00:00 AM | Permit Number 776671 | 6003788.24539392 | 2100967.25400369 | 37.7490703054266 | -122.429695296026 | (37.7490703054266, -122.429695296026) | 2 | 4 | 5 | 28862 | 22 | ||
193476 | 67801 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 881 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31447 | 6000722.4252572 | 2102556.2611987 | 37.7532592580737 | -122.440410849633 | (37.7532592580737, -122.440410849633) | 2 | 4 | 5 | 28862 | 22 | ||
164365 | 67799 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4263 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/11/1995 12:00:00 AM | Permit Number 31443 | 6002203.13479099 | 2100589.02594752 | 37.7479418964289 | -122.435149566646 | (37.7479418964289, -122.435149566646) | 2 | 4 | 5 | 63 | 22 | ||
176387 | 67797 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4545 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31440 | 6000849.66169786 | 2101098.90444447 | 37.7492649509789 | -122.439866358772 | (37.7492649509789, -122.439866358772) | 2 | 4 | 5 | 28862 | 22 | ||
173009 | 67794 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4385 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31436 | 6001403.12898277 | 2101129.53886862 | 37.7493805554463 | -122.437954656615 | (37.7493805554463, -122.437954656615) | 2 | 4 | 5 | 28862 | 22 | ||
94339 | 67793 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4381 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31435 | 6001427.36985446 | 2101130.88060421 | 37.7493856180132 | -122.437870927363 | (37.7493856180132, -122.437870927363) | 2 | 4 | 5 | 28862 | 22 | ||
108593 | 67774 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 50 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31407 | 6003128.8589186 | 2108744.804056 | 37.7703882320696 | -122.43253091541 | (37.7703882320696, -122.43253091541) | 15 | 5 | 5 | 29492 | 9 | ||
119589 | 67746 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1479 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31365 | 5994572.72013397 | 2105470.39847949 | 37.7609086531136 | -122.461888924556 | (37.7609086531136, -122.461888924556) | 1 | 5 | 11 | 56 | 12 | ||
61987 | 67673 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969016 | -122.393277319642 | (37.733518969016, -122.393277319642) | 10 | 3 | 8 | 58 | 1 | ||
176078 | 67651 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1919 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31250 | 6013521.72915428 | 2095881.08409425 | 37.7356511027367 | -122.395680256471 | (37.7356511027367, -122.395680256471) | 10 | 3 | 8 | 58 | 1 | ||
66532 | 67603 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 168 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | Permit Number 31174 | 6013416.46891349 | 2106299.39948246 | 37.7642517131045 | -122.39677434216 | (37.7642517131045, -122.39677434216) | 14 | 3 | 8 | 28856 | 29 | ||
126712 | 67589 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1005 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31156 | 6015546.93269222 | 2104381.58378925 | 37.7591041527051 | -122.389271681432 | (37.7591041527051, -122.389271681432) | 10 | 3 | 8 | 28856 | 29 | ||
166756 | 67583 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1081 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31148 | 6011670.33317 | 2103332.09659 | 37.7560068164771 | -122.402605084052 | (37.7560068164771, -122.402605084052) | 10 | 3 | 8 | 28856 | 29 | |
134490 | 67563 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1067 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31115 | 6011664.16143038 | 2103412.99241656 | 37.7562285940169 | -122.402632116673 | (37.7562285940169, -122.402632116673) | 10 | 3 | 8 | 28856 | 29 | ||
67998 | 67547 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.7555368181877 | -122.401581480218 | (37.7555368181877, -122.401581480218) | 10 | 3 | 8 | 28856 | 29 | |
41465 | 67531 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 55 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31069 | 6014000.26557437 | 2106870.40644282 | 37.7658520487611 | -122.394795132512 | (37.7658520487611, -122.394795132512) | 14 | 3 | 8 | 28856 | 20 | ||
32263 | 67530 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 12 | Permit Number 31068 | 6013998.45944 | 2106956.61768 | 37.7660886653923 | -122.394807417822 | (37.7660886653923, -122.394807417822) | 14 | 3 | 8 | 28856 | 20 | |
186914 | 67491 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1053 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 11 | Permit Number 31016 | 6011662.71218 | 2103457.28078 | 37.7563501191849 | -122.402640243074 | (37.7563501191849, -122.402640243074) | 10 | 3 | 8 | 28856 | 29 | |
41217 | 67483 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 556 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 7 | Permit Number 31006 | 6002164.8912 | 2110413.7271 | 37.7749159685838 | -122.435984714323 | (37.7749159685838, -122.435984714323) | 15 | 5 | 11 | 29492 | 10 | |
190113 | 67397 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 615 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1992 12:00:00 AM | Permit Number 30894 | 5990626.25534689 | 2111189.00376145 | 37.7763824092147 | -122.475955520815 | (37.7763824092147, -122.475955520815) | 11 | 6 | 2 | 55 | 26 | ||
96296 | 67367 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 622 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30860 | 5991947.66141854 | 2111184.68459598 | 37.7764470789457 | -122.471384134831 | (37.7764470789457, -122.471384134831) | 11 | 6 | 2 | 54 | 11 | ||
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 | |
85548 | 67164 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1550 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30604 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | 2 | 7 | 7 | 28859 | 2 | ||
30776 | 67143 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 303 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30573 | 6006940.4062177 | 2097313.36453869 | 37.7392155318486 | -122.418536006241 | (37.7392155318486, -122.418536006241) | 2 | 7 | 7 | 28859 | 2 | ||
97588 | 67124 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1616 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1992 12:00:00 AM | 3x3 | Permit Number 50077 | 6009627.64848121 | 2100263.06396072 | 37.7474656808625 | -122.409452808897 | (37.7474656808625, -122.409452808897) | 2 | 7 | 7 | 28859 | 2 | ||
79363 | 67088 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 104 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30490 | 6010217.49465897 | 2100245.63061 | 37.7474508447186 | -122.407411920985 | (37.7474508447186, -122.407411920985) | 2 | 7 | 7 | 28859 | 2 | ||
121997 | 66907 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 541 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1992 12:00:00 AM | Permit Number 30285 | 5999680.75570363 | 2110323.09068481 | 37.7745256692579 | -122.444571321093 | (37.7745256692579, -122.444571321093) | 15 | 5 | 11 | 29492 | 16 | ||
107016 | 66876 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30186 | 6001155.37730733 | 2104574.8455135 | 37.7588264440048 | -122.439058274593 | (37.7588264440048, -122.439058274593) | 2 | 4 | 5 | 28862 | 3 | ||
166751 | 66874 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 315 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30184 | 6001156.85774168 | 2104547.18862288 | 37.7587505891563 | -122.439051172455 | (37.7587505891563, -122.439051172455) | 2 | 4 | 5 | 28862 | 3 | ||
68294 | 66858 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 103 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1991 12:00:00 AM | 9 | Permit Number 30164 | 5998644.577 | 2110362.2819 | 37.7745740983013 | -122.448158471707 | (37.7745740983013, -122.448158471707) | 15 | 5 | 11 | 29492 | 16 | ||
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 |
144059 | 66784 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 20 Culebra Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1992 12:00:00 AM | Permit Number 30056 | 6006381.97640479 | 2120210.98917161 | 37.8020554906142 | -122.422093063103 | (37.8020554906142, -122.422093063103) | 5 | 9 | 1 | 28858 | 32 | ||
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 | ||
122035 | 66522 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 655 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29693 | 6002138.34041494 | 2102625.09065905 | 37.7535287667473 | -122.435519256653 | (37.7535287667473, -122.435519256653) | 2 | 4 | 5 | 28862 | 22 | ||
110083 | 66324 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 88 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1995 12:00:00 AM | Permit Number 29443 | 6000832.40008628 | 2095235.41670142 | 37.7331642137768 | -122.439505779041 | (37.7331642137768, -122.439505779041) | 9 | 7 | 5 | 63 | 40 | ||
71322 | 66256 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | 9 | 7 | 4 | 59 | 40 | ||
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 |
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) );