trees
835 rows where qSpecies_id = 122 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 |
6049 | 35103 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.435437534334 | (37.7168332689419, -122.435437534334) | 9 | 7 | 6 | 28861 | 5 | ||
6360 | 83538 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 243 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004140.21383 | 2089715.70651 | 37.7181960153187 | -122.427676641269 | (37.7181960153187, -122.427676641269) | 9 | 7 | 6 | 28861 | 5 | |||
7171 | 203639 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5992221.12373 | 2089294.63928 | 37.7163584485498 | -122.468844858017 | (37.7163584485498, -122.468844858017) | 9 | 8 | 6 | 64 | 24 | |||
7229 | 73391 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001816.88591 | 2094039.23102 | 37.7299357428343 | -122.43601658702 | (37.7299357428343, -122.43601658702) | 9 | 7 | 6 | 28861 | 25 | |||
8295 | 70299 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001826.35316 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | 9 | 7 | 6 | 28861 | 25 | |||
8412 | 203659 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.447256912002 | (37.7320962615306, -122.447256912002) | 9 | 7 | 4 | 59 | 40 | |||
8463 | 203650 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5993848.38247 | 2094813.02416 | 37.7316044735649 | -122.463620576647 | (37.7316044735649, -122.463620576647) | 9 | 8 | 4 | 59 | 40 | |||
8738 | 44456 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.7103071803111 | -122.432895389109 | (37.7103071803111, -122.432895389109) | 9 | 7 | 6 | 28861 | 5 | |
9936 | 203633 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997727.84983 | 2094119.15999 | 37.7299220605503 | -122.450158563772 | (37.7299220605503, -122.450158563772) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |||
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 | |||
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 | |||
16364 | 203625 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997311.4729 | 2099621.76413 | 37.7450070466421 | -122.451994860675 | (37.7450070466421, -122.451994860675) | 9 | 7 | 4 | 59 | 40 | |||
16365 | 203647 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993596.72892 | 2093377.09996 | 37.7276472749004 | -122.464386369131 | (37.7276472749004, -122.464386369131) | 9 | 8 | 4 | 59 | 40 | |||
16553 | 75408 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994441.08765 | 2086786.63151 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | 9 | 8 | 6 | 28861 | 25 | |||
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 | |||
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 | ||
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 | ||||
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 | |
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 | ||
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 | ||
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 | |||
30081 | 203635 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 418 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997950.41926 | 2094116.13567 | 37.7299264906077 | -122.449388900582 | (37.7299264906077, -122.449388900582) | 9 | 7 | 4 | 28861 | 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 | ||
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 | |||
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 | ||||
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 |
36745 | 203631 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1400 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 5993837.01835 | 2094842.09298 | 37.7316836345786 | -122.463661973318 | (37.7316836345786, -122.463661973318) | 9 | 8 | 4 | 59 | 40 | |||
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 |
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 | ||
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 | ||
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 | ||
43553 | 203651 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1390 Monterey Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993846.97887 | 2094818.60593 | 37.7316197188557 | -122.463625834087 | (37.7316197188557, -122.463625834087) | 9 | 8 | 4 | 59 | 40 | |||
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 | ||
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 | |||
44577 | 203627 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 133 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994260.23727 | 2095673.9858 | 37.7339921852793 | -122.462259143365 | (37.7339921852793, -122.462259143365) | 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 | ||
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 | ||
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 |
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 | |||
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 | |||
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 | ||
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 | |
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 | |||
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 | ||
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 | |||
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 | ||
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 | |
63154 | 203629 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 138 Encline Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998295.84832 | 2098462.32087 | 37.7418798313816 | -122.448507597342 | (37.7418798313816, -122.448507597342) | 9 | 7 | 4 | 59 | 40 | |||
64077 | 40191 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008969.32072 | 2093798.8519 | 37.7296794522306 | -122.411272698701 | (37.7296794522306, -122.411272698701) | 9 | 3 | 7 | 309 | 28 | ||
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 | ||
65997 | 203662 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 337 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999398.70847 | 2094267.55477 | 37.7304249920009 | -122.444392887823 | (37.7304249920009, -122.444392887823) | 9 | 7 | 4 | 28861 | 40 | |||
67158 | 203624 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5997319.6106 | 2099609.0427 | 37.7449725828299 | -122.451965804492 | (37.7449725828299, -122.451965804492) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | |||
70641 | 203634 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 432 Flood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | 11 | Width 2ft | Permit Number 42544 | 5997859.03229 | 2094116.10367 | 37.7299211747225 | -122.449704832412 | (37.7299211747225, -122.449704832412) | 9 | 7 | 4 | 28861 | 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 | ||
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 | ||
75953 | 40189 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008978.52665 | 2093804.69628 | 37.7296960159571 | -122.411241285381 | (37.7296960159571, -122.411241285381) | 9 | 3 | 7 | 309 | 28 | ||
76179 | 121723 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 199 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6001086 | 2095247 | 37.7332104486713 | -122.438629847451 | (37.7332104486713, -122.438629847451) | 9 | 7 | 5 | 63 | 40 | ||||
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 |
81817 | 42334 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 207 Flood Ave | 2 | 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 | ||
83995 | 42373 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | 9 | 7 | 4 | 59 | 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 | ||
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 | ||
90906 | 203628 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 133 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994258.53071 | 2095683.80268 | 37.734019041749 | -122.462265755167 | (37.734019041749, -122.462265755167) | 9 | 8 | 4 | 59 | 40 | |||
91942 | 30799 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 131 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 8 | Permit Number 34665 | 6002107.11402 | 2095231.84638 | 37.7332268757153 | -122.43509850062 | (37.7332268757153, -122.43509850062) | 9 | 7 | 5 | 63 | 40 | |
93770 | 203623 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997330.81089 | 2099592.07349 | 37.744926631064 | -122.45192585212 | (37.744926631064, -122.45192585212) | 9 | 7 | 4 | 59 | 40 | |||
93860 | 203660 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998582.52704 | 2094910.55882 | 37.7321439273893 | -122.447260791654 | (37.7321439273893, -122.447260791654) | 9 | 7 | 4 | 59 | 40 | |||
94584 | 203626 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 12 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5997325.36011 | 2099393.71244 | 37.7443816679834 | -122.451930391889 | (37.7443816679834, -122.451930391889) | 9 | 7 | 4 | 59 | 40 | |||
94890 | 203655 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 230 Edna St | 8 | Side Yard : Yard | Tree | Private 2 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | 9 | 7 | 4 | 59 | 40 | ||||
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 | ||||
95221 | 40190 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008992.69015 | 2093809.01989 | 37.729708681998 | -122.411192625738 | (37.729708681998, -122.411192625738) | 9 | 3 | 7 | 309 | 28 | ||
98362 | 203630 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1400 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 5993843.17005 | 2094826.47883 | 37.7316411164345 | -122.46363957301 | (37.7316411164345, -122.46363957301) | 9 | 8 | 4 | 59 | 40 | |||
99217 | 203656 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 232 Edna St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | 5998785.56076 | 2095387.29688 | 37.7334645368524 | -122.446593149381 | (37.7334645368524, -122.446593149381) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |
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 | |||
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 | ||
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 | ||
104939 | 203661 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 582 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5997537.55728 | 2095290.58786 | 37.7331276310309 | -122.450900858796 | (37.7331276310309, -122.450900858796) | 9 | 7 | 4 | 59 | 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 | ||
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 | |||
107495 | 203637 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 270 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998290.1238 | 2093810.02027 | 37.7291053960882 | -122.448192473116 | (37.7291053960882, -122.448192473116) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
116712 | 203653 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002114.00252 | 2095255.92738 | 37.733293387769 | -122.435076406948 | (37.733293387769, -122.435076406948) | 9 | 7 | 5 | 63 | 40 | |||
117491 | 39702 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 628 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/2004 12:00:00 AM | Permit Number 41087 | 5998596.38137062 | 2094778.55233682 | 37.731782260395 | -122.447203397318 | (37.731782260395, -122.447203397318) | 9 | 7 | 4 | 59 | 40 | ||
118046 | 174966 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 44 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009006.88433 | 2093841.01999 | 37.7297973434756 | -122.411145814235 | (37.7297973434756, -122.411145814235) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
119123 | 203622 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997339.99838 | 2099579.33016 | 37.7448921672303 | -122.45189316446 | (37.7448921672303, -122.45189316446) | 9 | 7 | 4 | 59 | 40 | |||
119770 | 42339 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 432 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42544 | 5997882.68725291 | 2094126.21532195 | 37.7299502922476 | -122.449623783134 | (37.7299502922476, -122.449623783134) | 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) );