trees
835 rows where qSpecies_id = 122 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1762 | 30595 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
1889 | 259158 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
2542 | 32891 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.7603305839468 | -122.462923499947 | (37.7603305839468, -122.462923499947) | 1 | 5 | 4 | 56 | 12 | ||
2756 | 39703 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.4472036828 | (37.7318275120035, -122.4472036828) | 9 | 7 | 4 | 59 | 40 | ||
4487 | 259159 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
4696 | 117040 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
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 | ||||
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 | ||
6554 | 51248 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47625 | 6007471.15651424 | 2105682.67696043 | 37.7622256337552 | -122.417293833991 | (37.7622256337552, -122.417293833991) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||||||||||||
8576 | 32346 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
8595 | 66640 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.7562136300125 | -122.407049963033 | (37.7562136300125, -122.407049963033) | 10 | 4 | 7 | 28859 | 19 | ||
9025 | 30594 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
9093 | 33190 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | 1 | 5 | 4 | 59 | 40 | ||
9783 | 261822 | Significant Tree 6 | Acacia baileyana :: Bailey's Acacia 122 | 3580 21st St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | Permit Number 785112 | 6004538.52309 | 2103691.84305 | 37.7565938462521 | -122.427294885373 | (37.7565938462521, -122.427294885373) | 2 | 4 | 5 | 28862 | 3 | |||
11302 | 34144 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39666 | 6003955.69985192 | 2098004.27278913 | 37.7409441243389 | -122.428905023889 | (37.7409441243389, -122.428905023889) | 2 | 7 | 5 | 63 | 7 | ||
12666 | 48033 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 61 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2002 12:00:00 AM | Permit Number 45754 | 6001724.06677399 | 2105480.90222389 | 37.7613465972478 | -122.437156358638 | (37.7613465972478, -122.437156358638) | 15 | 4 | 5 | 28862 | 3 | |||
12702 | 32557 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3822 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 770192 | 6002956.41958884 | 2103022.59282687 | 37.7546666427143 | -122.432718557235 | (37.7546666427143, -122.432718557235) | 2 | 4 | 5 | 28862 | 22 | |||
13307 | 37952 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1308 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40191 | 6013419.73141926 | 2106176.98186548 | 37.7639157629311 | -122.396754475262 | (37.7639157629311, -122.396754475262) | 14 | 3 | 8 | 28856 | 29 | ||
15287 | 40295 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 48 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41439 | 6005981.28847445 | 2102313.08870522 | 37.7528895951686 | -122.422207325088 | (37.7528895951686, -122.422207325088) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||||
16325 | 38333 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | 7 | 9 | 9 | 28852 | 36 | |||
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 | ||||
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 | ||||
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 | ||||
20408 | 39701 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 625 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41086 | 5998544.21434681 | 2094768.39031032 | 37.7317513769747 | -122.447383017512 | (37.7317513769747, -122.447383017512) | 9 | 7 | 4 | 59 | 40 | ||
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 | ||
21427 | 49185 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 220 Palo Alto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46291 | 5997532.34805472 | 2103898.27952644 | 37.7567619489163 | -122.451539524782 | (37.7567619489163, -122.451539524782) | 15 | 5 | 4 | 63 | 38 | |||
21787 | 32344 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
22337 | 43381 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 706 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43129 | 6001854.12345529 | 2102032.01903245 | 37.7518841875031 | -122.436459694241 | (37.7518841875031, -122.436459694241) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||||
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 | ||||
24211 | 35786 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 580 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39038 | 6002648.18507624 | 2102127.11023082 | 37.7521903746122 | -122.433720516444 | (37.7521903746122, -122.433720516444) | 2 | 4 | 5 | 28862 | 22 | |||
24313 | 36920 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 699 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900 | 2102596 | 37.7534353511669 | -122.436341406283 | (37.7534353511669, -122.436341406283) | 2 | 4 | 5 | 28862 | 22 | ||
24531 | 43380 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 700 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43128 | 6001853.17321705 | 2102048.95584272 | 37.751930637944 | -122.436464192392 | (37.751930637944, -122.436464192392) | 2 | 4 | 5 | 28862 | 22 | ||
24848 | 63851 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24548 | 6001965.88884277 | 2110471.51360831 | 37.775063328726 | -122.43667724184 | (37.775063328726, -122.43667724184) | 15 | 5 | 11 | 29492 | 10 | ||
25315 | 33658 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 575 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37746 | 6004659.15076187 | 2110673.58419475 | 37.7757708537128 | -122.427375053318 | (37.7757708537128, -122.427375053318) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||||
25580 | 117035 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
26802 | 37051 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 364 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39656 | 6003583.41460965 | 2098669.49042288 | 37.7427495797017 | -122.430239695512 | (37.7427495797017, -122.430239695512) | 2 | 7 | 5 | 63 | 22 | ||
27101 | 52597 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 421@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/2006 12:00:00 AM | Permit Number 48691 | 6005029.01915461 | 2110416.12997637 | 37.7750848587198 | -122.426077252438 | (37.7750848587198, -122.426077252438) | 7 | 9 | 11 | 28852 | 10 | ||
27399 | 39221 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1143 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.7529009461356 | -122.422831161336 | (37.7529009461356, -122.422831161336) | 2 | 4 | 5 | 28859 | 19 | ||
27992 | 49579 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
28414 | 36508 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 584 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.7361990307601 | -122.415517981354 | (37.7361990307601, -122.415517981354) | 2 | 7 | 7 | 28859 | 2 | ||
28426 | 33399 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 300 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37517 | 5992600.35501271 | 2094892.48894855 | 37.7317506732587 | -122.467940993296 | (37.7317506732587, -122.467940993296) | 9 | 8 | 4 | 59 | 40 | ||
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 | ||
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 | ||
31049 | 66174 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 70 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29247 | 6009314.15806324 | 2097044.09702117 | 37.7386095323365 | -122.410309598587 | (37.7386095323365, -122.410309598587) | 10 | 7 | 7 | 28859 | 2 | ||
32201 | 117042 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
32668 | 36576 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2959 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39438 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||||
33013 | 51076 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 232 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2006 12:00:00 AM | Permit Number 47538 | 6006664.07662334 | 2104758.9078781 | 37.7596437391075 | -122.420019665049 | (37.7596437391075, -122.420019665049) | 2 | 4 | 7 | 28859 | 19 | ||
33613 | 49479 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
35601 | 39507 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 216 Jersey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.429990180024 | (37.7508086831914, -122.429990180024) | 2 | 4 | 5 | 28862 | 22 | ||
37537 | 32890 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.7603305839468 | -122.462923499947 | (37.7603305839468, -122.462923499947) | 1 | 5 | 4 | 56 | 12 | ||
38603 | 32274 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 623 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39911 | 6007825.97257693 | 2096019.31993336 | 37.7357121847697 | -122.415382520688 | (37.7357121847697, -122.415382520688) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
42343 | 39503 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 216 Jersey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.429990180024 | (37.7508086831914, -122.429990180024) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
43083 | 248977 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 748 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999650 | 2111146 | 37.7767834132689 | -122.444736872581 | (37.7767834132689, -122.444736872581) | 15 | 5 | 11 | 29492 | 16 | ||||
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 | ||
44531 | 64135 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 674 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31501 | 6002183.05937143 | 2098884.5643421 | 37.7432607055203 | -122.435097097554 | (37.7432607055203, -122.435097097554) | 2 | 7 | 5 | 63 | 22 | ||
46210 | 63850 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1259 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24547 | 6001845.15733033 | 2110454.5773622 | 37.7750099641834 | -122.437093665021 | (37.7750099641834, -122.437093665021) | 15 | 5 | 11 | 29492 | 10 | ||
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 | ||
48530 | 38069 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1654X SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001625 | 2114095 | 37.7849931264589 | -122.438116069267 | (37.7849931264589, -122.438116069267) | 15 | 6 | 11 | 29490 | 13 | |||
49476 | 42106 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 305 Hearst Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191214 | -122.444453504412 | (37.730636191214, -122.444453504412) | 9 | 7 | 4 | 28861 | 40 | ||
49717 | 42335 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 207 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | 9 | 7 | 4 | 28861 | 40 | ||
52547 | 65160 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 878 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27140 | 6000731.49768107 | 2102608.84071127 | 37.7534041452721 | -122.440383246008 | (37.7534041452721, -122.440383246008) | 2 | 4 | 5 | 28862 | 22 | ||
52636 | 46270 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 16 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/2002 12:00:00 AM | Permit Number 44554 | 6001971.15717323 | 2094954.12044598 | 37.7324565829795 | -122.435548678389 | (37.7324565829795, -122.435548678389) | 9 | 7 | 5 | 63 | 40 | ||
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 | ||
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 | ||
58697 | 45250 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 200 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44097 | 5996410.1880044 | 2098465.43898756 | 37.7417803963921 | -122.455027784646 | (37.7417803963921, -122.455027784646) | 9 | 7 | 4 | 59 | 40 | ||
59224 | 61737 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 213 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1993 12:00:00 AM | Permit Number 31452 | 6003775.93391522 | 2100966.602272 | 37.7490678187798 | -122.429737822747 | (37.7490678187798, -122.429737822747) | 2 | 4 | 5 | 28862 | 22 | ||
59827 | 117033 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
59945 | 33582 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37690 | 6007165.20249785 | 2098095.43390853 | 37.7413755735349 | -122.417814180983 | (37.7413755735349, -122.417814180983) | 2 | 7 | 7 | 28859 | 2 | |||
60595 | 49477 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
60882 | 61342 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21247 | 6004909.43277367 | 2110408.16939621 | 37.7750562413416 | -122.426490361334 | (37.7750562413416, -122.426490361334) | 7 | 9 | 11 | 28852 | 10 | ||
61503 | 64794 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 700 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25792 | 6001971.04512503 | 2100046.68918075 | 37.7464395858784 | -122.435913321642 | (37.7464395858784, -122.435913321642) | 2 | 7 | 5 | 63 | 22 | ||
61974 | 37714 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 879 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 3x3 | Permit Number 40084 | 6007585.89861945 | 2104551.15151716 | 37.7591251811896 | -122.416816815015 | (37.7591251811896, -122.416816815015) | 2 | 4 | 7 | 28859 | 19 | |
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 | ||
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 | ||
62359 | 61344 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21249 | 6004697.33191231 | 2110333.09347915 | 37.7748381087345 | -122.427218716009 | (37.7748381087345, -122.427218716009) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
63342 | 48833 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | Permit Number 46053 | 6002516.40077061 | 2102618.9246623 | 37.7535333013465 | -122.434211402781 | (37.7535333013465, -122.434211402781) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
63797 | 49970 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 577 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2003 12:00:00 AM | 3x3 | Permit Number 46721 | 5984701.98485126 | 2111935.6867193 | 37.7780873043924 | -122.496504036563 | (37.7780873043924, -122.496504036563) | 11 | 6 | 2 | 55 | 26 | ||
64191 | 51723 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1148 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2005 12:00:00 AM | Permit Number 47992 | 6008632.05923166 | 2101854.75826991 | 37.7517802835227 | -122.413008028247 | (37.7517802835227, -122.413008028247) | 2 | 4 | 7 | 28859 | 19 | ||
64202 | 253615 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221 | 2118816 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | 13 | 9 | 10 | 28858 | 32 | ||
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 | ||||
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 | ||
64962 | 66113 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | 7 | 9 | 11 | 29492 | 10 | ||
64977 | 34443 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38187 | 6004317.14831895 | 2097838.60614012 | 37.7405096935375 | -122.427643467723 | (37.7405096935375, -122.427643467723) | 2 | 7 | 5 | 63 | 7 | ||
65063 | 50320 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3615 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47024 | 6006189.66048824 | 2104317.6075576 | 37.7584052908739 | -122.421629093037 | (37.7584052908739, -122.421629093037) | 2 | 4 | 5 | 28859 | 19 | |||
65212 | 33257 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2669 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.487622710626 | (37.7377581609646, -122.487622710626) | 1 | 8 | 3 | 29491 | 35 | ||
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 | ||
67846 | 51518 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 622 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | Permit Number 47821 | 5998596.12110377 | 2094762.07724114 | 37.7317370088004 | -122.447203111837 | (37.7317370088004, -122.447203111837) | 9 | 7 | 4 | 59 | 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) );