trees
1,069 rows where qSpecies_id = 93 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
18752 | 51349 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2004 12:00:00 AM | Permit Number 47697 | |||||||||||||
101559 | 179477 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5994326.32135 | 2086634.18047 | 37.7091748582933 | -122.461375565754 | (37.7091748582933, -122.461375565754) | 9 | 8 | 6 | 28861 | 25 | ||||
162504 | 179476 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5994306.08107 | 2086649.96822 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | 9 | 8 | 6 | 28861 | 25 | ||||
97410 | 179475 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5994292.07601 | 2086663.34927 | 37.7092529779255 | -122.461496035314 | (37.7092529779255, -122.461496035314) | 9 | 8 | 6 | 28861 | 25 | ||||
79502 | 179456 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 39 Melra Ct | 1 | : | Tree | Private 2 | 18 | Width 4ft | 6008986.48136 | 2086460.78308 | 37.7095316094729 | -122.410695358215 | (37.7095316094729, -122.410695358215) | 9 | 7 | 8 | 309 | 39 | |||
2071 | 179437 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006551.53826 | 2086713.55756 | 37.7100888527847 | -122.419128872099 | (37.7100888527847, -122.419128872099) | 9 | 7 | 8 | 309 | 39 | |||
2724 | 179436 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006488.6944 | 2086721.59328 | 37.7101073779209 | -122.419346642943 | (37.7101073779209, -122.419346642943) | 9 | 7 | 8 | 309 | 39 | |||
91581 | 179435 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006500.60842 | 2086740.91409 | 37.710161099825 | -122.41930683535 | (37.710161099825, -122.41930683535) | 9 | 7 | 8 | 309 | 39 | |||
186007 | 179434 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6006514.55403 | 2086760.19323 | 37.7102148217155 | -122.419260003144 | (37.7102148217155, -122.419260003144) | 9 | 7 | 8 | 309 | 39 | |||
50406 | 179433 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006535.42412 | 2086786.75181 | 37.7102889213719 | -122.419189754426 | (37.7102889213719, -122.419189754426) | 9 | 7 | 8 | 309 | 39 | |||
1203 | 179432 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6006549.42501 | 2086808.72834 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | 9 | 7 | 8 | 309 | 39 | |||
167833 | 44448 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 6 | Permit Number 43777 | 6002641.71413 | 2086935.0699 | 37.7104761197367 | -122.432657792736 | (37.7104761197367, -122.432657792736) | 9 | 7 | 6 | 28861 | 5 | |
153889 | 179441 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007125.21698 | 2086870.4635 | 37.7105519739575 | -122.417157231746 | (37.7105519739575, -122.417157231746) | 9 | 7 | 8 | 309 | 39 | |||
41453 | 179438 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 163 Santos St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6006665.75653 | 2086898.09687 | 37.7106019906608 | -122.418747189045 | (37.7106019906608, -122.418747189045) | 9 | 7 | 8 | 309 | 39 | |||
63033 | 179440 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | 9 | 7 | 8 | 309 | 39 | |||
97645 | 179431 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006605.70519 | 2086910.12298 | 37.7106316305231 | -122.418955592547 | (37.7106316305231, -122.418955592547) | 9 | 7 | 8 | 309 | 39 | |||
126536 | 179439 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006794.78813 | 2086912.99237 | 37.7106501547416 | -122.418302281839 | (37.7106501547416, -122.418302281839) | 9 | 7 | 8 | 309 | 39 | |||
93783 | 179490 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002435.0144 | 2087009.10974 | 37.7106676924198 | -122.433377477905 | (37.7106676924198, -122.433377477905) | 9 | 7 | 6 | 28861 | 5 | |||
186974 | 179491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002422.82198 | 2087024.8993 | 37.7107103553801 | -122.433420745181 | (37.7107103553801, -122.433420745181) | 9 | 7 | 6 | 28861 | 5 | |||
158647 | 69407 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 795 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 12 | Permit Number 33511 | 6002413.58939 | 2087078.56796 | 37.7108571939861 | -122.43345648782 | (37.7108571939861, -122.43345648782) | 9 | 7 | 6 | 28861 | 5 | |
152421 | 179430 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 Blythdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006173.52059 | 2087002.57891 | 37.7108611491941 | -122.420455879341 | (37.7108611491941, -122.420455879341) | 9 | 7 | 8 | 309 | 39 | |||
69697 | 69405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 11 | Permit Number 33509 | 6002439.0824 | 2087100.62464 | 37.7109192031396 | -122.43336995327 | (37.7109192031396, -122.43336995327) | 9 | 7 | 6 | 28861 | 5 | |
156434 | 179492 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002448.84708 | 2087107.83027 | 37.7109395422009 | -122.433336718839 | (37.7109395422009, -122.433336718839) | 9 | 7 | 6 | 28861 | 5 | |||
180689 | 179493 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6002457.74986 | 2087117.22162 | 37.710965833866 | -122.433306619399 | (37.710965833866, -122.433306619399) | 9 | 7 | 6 | 28861 | 5 | |||
68847 | 179445 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 50 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006641.641 | 2087043.64286 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | 9 | 7 | 8 | 309 | 39 | |||
88114 | 179444 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 50 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006641.4754 | 2087068.60877 | 37.7110688134384 | -122.418843195273 | (37.7110688134384, -122.418843195273) | 9 | 7 | 8 | 309 | 39 | |||
20941 | 179443 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006639.5983 | 2087274.41681 | 37.7116338134302 | -122.418864269997 | (37.7116338134302, -122.418864269997) | 9 | 7 | 8 | 309 | 39 | |||
67473 | 179442 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006642.58468 | 2087353.9641 | 37.7118524017357 | -122.418859586325 | (37.7118524017357, -122.418859586325) | 9 | 7 | 8 | 309 | 39 | |||
122596 | 179449 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006550.96819 | 2087379.45579 | 37.711917237452 | -122.419178046153 | (37.711917237452, -122.419178046153) | 9 | 7 | 8 | 309 | 39 | |||
18053 | 179450 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006580.77916 | 2087379.51909 | 37.7119190900695 | -122.419075015325 | (37.7119190900695, -122.419075015325) | 9 | 7 | 8 | 309 | 39 | |||
38419 | 179448 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006504.26821 | 2087381.76307 | 37.7119209426602 | -122.419339618327 | (37.7119209426602, -122.419339618327) | 9 | 7 | 8 | 309 | 39 | |||
7806 | 179447 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 154 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6006213.66342 | 2087416.73528 | 37.7120005974198 | -122.420346512779 | (37.7120005974198, -122.420346512779) | 9 | 7 | 8 | 309 | 39 | |||
83445 | 179427 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006362.44693 | 2087442.7546 | 37.7120804239565 | -122.419834118658 | (37.7120804239565, -122.419834118658) | 9 | 7 | 8 | 309 | 39 | |||
112551 | 179428 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006287.8718 | 2087448.27209 | 37.7120913722811 | -122.420092263655 | (37.7120913722811, -122.420092263655) | 9 | 7 | 8 | 309 | 39 | |||
174056 | 179446 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006032.90525 | 2087456.20206 | 37.712098777304 | -122.420974066009 | (37.712098777304, -122.420974066009) | 9 | 7 | 8 | 309 | 39 | |||
17515 | 179429 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6006237.48001 | 2087456.42565 | 37.7121109208587 | -122.420267010915 | (37.7121109208587, -122.420267010915) | 9 | 7 | 8 | 309 | 39 | |||
118357 | 179426 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Santos St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 6ft | 6006719.22339 | 2087474.42971 | 37.7121874900245 | -122.418603238164 | (37.7121874900245, -122.418603238164) | 9 | 7 | 8 | 309 | 39 | |||
23628 | 179425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006737.87137 | 2087492.25298 | 37.7122374788398 | -122.418540048182 | (37.7122374788398, -122.418540048182) | 9 | 7 | 8 | 309 | 39 | |||
152072 | 179455 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1651 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6006947.07452 | 2087492.65331 | 37.7122503535477 | -122.417817006765 | (37.7122503535477, -122.417817006765) | 9 | 7 | 8 | 309 | 39 | |||
181402 | 179454 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1657 Sunnydale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6006909.47125 | 2087494.69484 | 37.7122538429007 | -122.417947119763 | (37.7122538429007, -122.417947119763) | 9 | 7 | 8 | 309 | 39 | |||
162846 | 179453 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1657 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6006878.87058 | 2087495.95749 | 37.7122555876031 | -122.418052974468 | (37.7122555876031, -122.418052974468) | 9 | 7 | 8 | 309 | 39 | |||
7566 | 264756 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
55798 | 179451 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1848 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6006175.92265 | 2087836.63994 | 37.7131514400558 | -122.420506743187 | (37.7131514400558, -122.420506743187) | 9 | 7 | 8 | 309 | 39 | |||
31474 | 179452 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1851 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6006040.88882 | 2087844.33942 | 37.7131649703554 | -122.420974012957 | (37.7131649703554, -122.420974012957) | 9 | 7 | 8 | 309 | 39 | |||
174971 | 76749 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
67016 | 179457 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 949 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6002045.64816 | 2088406.8974 | 37.714483612097 | -122.434823106621 | (37.714483612097, -122.434823106621) | 9 | 7 | 6 | 28861 | 5 | |||
94247 | 179474 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 279 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009762.57781 | 2088424.36617 | 37.7149666919301 | -122.408151417155 | (37.7149666919301, -122.408151417155) | 9 | 7 | 8 | 309 | 39 | |||
66788 | 179470 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 755 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002483.16702 | 2089112.03412 | 37.7164445928267 | -122.43336122534 | (37.7164445928267, -122.43336122534) | 9 | 7 | 6 | 28861 | 5 | |||
191088 | 179469 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 750 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6002474.00901 | 2089177.35967 | 37.7166234427928 | -122.433397545354 | (37.7166234427928, -122.433397545354) | 9 | 7 | 6 | 28861 | 5 | |||
8923 | 81053 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 735 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6002545.69492 | 2089214.07107 | 37.7167283109449 | -122.433152384794 | (37.7167283109449, -122.433152384794) | 9 | 7 | 6 | 28861 | 5 | |||
80210 | 114872 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 735 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6002556.26502 | 2089229.80958 | 37.7167721250182 | -122.433116973091 | (37.7167721250182, -122.433116973091) | 9 | 7 | 6 | 28861 | 5 | ||||
172022 | 35126 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.7174791459225 | -122.43602056561 | (37.7174791459225, -122.43602056561) | 9 | 7 | 6 | 28861 | 5 | |
79942 | 35125 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 5 | Permit Number 38660 | 6001731.36417 | 2089519.53162 | 37.7175208097275 | -122.43598896344 | (37.7175208097275, -122.43598896344) | 9 | 7 | 6 | 28861 | 5 | |
157646 | 35120 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 679 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 11 | Permit Number 38655 | 6001477.30735 | 2089545.09865 | 37.7175765748797 | -122.436868949145 | (37.7175765748797, -122.436868949145) | 9 | 7 | 6 | 28861 | 5 | |
129821 | 35123 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 752 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 9 | Permit Number 38658 | 6001767.50485 | 2089578.0778 | 37.7176836175692 | -122.435868228557 | (37.7176836175692, -122.435868228557) | 9 | 7 | 6 | 28861 | 5 | |
57929 | 179458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6001021.22839 | 2089673.68312 | 37.7179037068739 | -122.438454610411 | (37.7179037068739, -122.438454610411) | 9 | 7 | 6 | 28861 | 5 | |||
144560 | 179459 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001007.64891 | 2089683.17948 | 37.7179290093058 | -122.438502228612 | (37.7179290093058, -122.438502228612) | 9 | 7 | 6 | 28861 | 5 | |||
157153 | 179460 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.438538393947 | (37.7179436214658, -122.438538393947) | 9 | 7 | 6 | 28861 | 5 | |||
74066 | 179461 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000982.14926 | 2089697.75779 | 37.7179675875255 | -122.43859141349 | (37.7179675875255, -122.43859141349) | 9 | 7 | 6 | 28861 | 5 | |||
167640 | 179462 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 90 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000856.84082 | 2089774.26479 | 37.7181705294179 | -122.43903002902 | (37.7181705294179, -122.43903002902) | 9 | 7 | 6 | 28861 | 5 | |||
31319 | 179463 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 90 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000843.6616 | 2089782.45527 | 37.7181922687385 | -122.439076170523 | (37.7181922687385, -122.439076170523) | 9 | 7 | 6 | 28861 | 5 | |||
85248 | 69541 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 643 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38636 | 6002429.0315791 | 2090033.16165602 | 37.7189707335787 | -122.43361413687 | (37.7189707335787, -122.43361413687) | 9 | 7 | 6 | 28861 | 5 | ||
47132 | 179464 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001719.61303 | 2090058.37784 | 37.7189996935499 | -122.436068119042 | (37.7189996935499, -122.436068119042) | 9 | 7 | 6 | 28861 | 5 | |||
102339 | 179465 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001702.1853 | 2090068.84403 | 37.7190274412447 | -122.436129108381 | (37.7190274412447, -122.436129108381) | 9 | 7 | 6 | 28861 | 5 | |||
23898 | 35110 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
31895 | 35112 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
94617 | 38649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
165237 | 35113 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
166144 | 35111 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
112158 | 179483 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5988918.91652 | 2090347.02209 | 37.7190566943955 | -122.480335749404 | (37.7190566943955, -122.480335749404) | 1 | 8 | 4 | 64 | 14 | ||||
112256 | 179466 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001678.49541 | 2090085.4444 | 37.7190716762026 | -122.436212182343 | (37.7190716762026, -122.436212182343) | 9 | 7 | 6 | 28861 | 5 | |||
17944 | 179467 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001663.65352 | 2090093.9083 | 37.7190940729046 | -122.436264090339 | (37.7190940729046, -122.436264090339) | 9 | 7 | 6 | 28861 | 5 | |||
176933 | 179484 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5988536.49014 | 2090373.27915 | 37.7191065591004 | -122.481659555971 | (37.7191065591004, -122.481659555971) | 1 | 8 | 4 | 64 | 14 | ||||
94767 | 179482 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5988878.80429 | 2090370.98469 | 37.7191201586413 | -122.48047615337 | (37.7191201586413, -122.48047615337) | 1 | 8 | 4 | 64 | 14 | ||||
167893 | 179468 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001647.16213 | 2090105.12517 | 37.7191239348993 | -122.436321896962 | (37.7191239348993, -122.436321896962) | 9 | 7 | 6 | 28861 | 5 | |||
127628 | 179481 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988902.49405 | 2090393.59661 | 37.7191836220039 | -122.480395922129 | (37.7191836220039, -122.480395922129) | 1 | 8 | 4 | 64 | 14 | ||||
119678 | 215005 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995603.15885 | 2090386.73113 | 37.7195518880809 | -122.457233926015 | (37.7195518880809, -122.457233926015) | 9 | 8 | 6 | 28861 | 24 | |||
67112 | 105255 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 162 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004396.67956 | 2090207.02373 | 37.7195595692124 | -122.426825119088 | (37.7195595692124, -122.426825119088) | 9 | 7 | 6 | 28861 | 5 | |||
182122 | 179471 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003207.64888 | 2090265.05426 | 37.7196516076204 | -122.430939303405 | (37.7196516076204, -122.430939303405) | 9 | 7 | 6 | 28861 | 5 | |||
101349 | 103464 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 543 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x9 | 6003223.19269 | 2090290.89193 | 37.7197234328838 | -122.430887417037 | (37.7197234328838, -122.430887417037) | 9 | 7 | 6 | 28861 | 5 | |||
140571 | 114382 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 402X SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
152373 | 197576 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013293.0543 | 2090118.55817 | 37.7198156565414 | -122.396067168381 | (37.7198156565414, -122.396067168381) | 10 | 3 | 8 | 58 | 1 | ||||
7784 | 197575 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6013269.3073 | 2090137.6242 | 37.7198666867704 | -122.396150589498 | (37.7198666867704, -122.396150589498) | 10 | 3 | 8 | 58 | 1 | ||||
51974 | 215003 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996037.07731 | 2090573.06283 | 37.7200884227106 | -122.45574749866 | (37.7200884227106, -122.45574749866) | 9 | 8 | 6 | 28861 | 24 | |||
22787 | 215004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996022.14356 | 2090574.20231 | 37.7200906944015 | -122.455799201591 | (37.7200906944015, -122.455799201591) | 9 | 8 | 6 | 28861 | 24 | |||
69528 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Garfield St | 1 | Side Yard : Yard | Tree | Private 2 | 10x2 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |||
162222 | 179478 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | 1 | 8 | 4 | 64 | 14 | ||||
112112 | 66607 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | 1 | 8 | 4 | 64 | 14 | ||
169793 | 179479 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989502.72531 | 2090743.34169 | 37.7201787974032 | -122.478346734135 | (37.7201787974032, -122.478346734135) | 1 | 8 | 4 | 64 | 14 | ||||
163290 | 114214 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 SERRANO DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5988981 | 2090766 | 37.7202107101289 | -122.480151800691 | (37.7202107101289, -122.480151800691) | 1 | 8 | 4 | 64 | 14 | ||||
102044 | 179480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989599 | 2090767 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | 1 | 8 | 4 | 64 | 14 | ||||
6032 | 50628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
152092 | 50629 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
132607 | 66239 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548 | -122.456225313763 | (37.720469900548, -122.456225313763) | 9 | 8 | 6 | 28861 | 24 | ||
4235 | 215001 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995907.45606 | 2090967.94562 | 37.7211652376617 | -122.45622408897 | (37.7211652376617, -122.45622408897) | 9 | 8 | 6 | 28861 | 24 | |||
44330 | 67999 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31724 | 5995906.21686349 | 2090968.00525531 | 37.7211653302718 | -122.456228376798 | (37.7211653302718, -122.456228376798) | 9 | 8 | 6 | 28861 | 24 | ||
101282 | 215002 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995954.15999 | 2091115.97449 | 37.7215743707347 | -122.456073344621 | (37.7215743707347, -122.456073344621) | 9 | 8 | 6 | 28861 | 24 | |||
32927 | 179473 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011506.9921 | 2090808.93918 | 37.7216117663527 | -122.402289508352 | (37.7216117663527, -122.402289508352) | 10 | 3 | 7 | 309 | 28 | |||
193575 | 50422 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 549 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778616 | 5995097 | 2091149 | 37.721615813455 | -122.459038685652 | (37.721615813455, -122.459038685652) | 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) );