trees
221 rows where Fire Prevention Districts = 9 and qSpecies_id = 95 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108910 | 49653 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 483 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | 5 | Permit Number 46506 | 6010094.54091 | 2089412.62479 | 37.71769882961 | -122.407073624648 | (37.71769882961, -122.407073624648) | 9 | 7 | 8 | 309 | 39 | |
62143 | 2164 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 725X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009812.0626049 | 2090077.874838 | 37.7195096568823 | -122.408096919848 | (37.7195096568823, -122.408096919848) | 9 | 3 | 8 | 309 | 18 | |||
155941 | 50022 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 736 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3 | Permit Number 46756 | 6009379.93201 | 2091040.43268 | 37.7221284349621 | -122.409658546911 | (37.7221284349621, -122.409658546911) | 9 | 3 | 7 | 309 | 28 | |
71884 | 13374 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 940 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x10 | 6009133.6559802 | 2090011.862437 | 37.7192903922619 | -122.41043727411 | (37.7192903922619, -122.41043727411) | 9 | 3 | 7 | 309 | 28 | |||
182250 | 13373 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 930 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X10 | 6009096.55006 | 2089989.80349 | 37.7192277427566 | -122.410563978962 | (37.7192277427566, -122.410563978962) | 9 | 3 | 7 | 309 | 28 | |||
2234 | 49760 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 366@ REY Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46555 | 6008968.34582 | 2087920.09571 | 37.7135375657916 | -122.410861035806 | (37.7135375657916, -122.410861035806) | 9 | 7 | 8 | 309 | 39 | |
57860 | 13384 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1000X Mansell St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
119057 | 178391 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Gaven St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6008930.41728 | 2094862.45857 | 37.7325977064018 | -122.411482306357 | (37.7325977064018, -122.411482306357) | 9 | 3 | 7 | 309 | 28 | |||
67869 | 43159 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 252 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 7 | Permit Number 46761 | 6006227.85589 | 2092666.05204 | 37.7264148961281 | -122.42066986853 | (37.7264148961281, -122.42066986853) | 9 | 7 | 7 | 309 | 5 | |
11743 | 50027 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
20039 | 50025 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
140060 | 50026 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
73309 | 178390 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 747 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6005444.06932 | 2092330.23568 | 37.725448612348 | -122.423355524742 | (37.725448612348, -122.423355524742) | 9 | 7 | 7 | 309 | 5 | |||
30725 | 178389 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 327 Craut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 7ft | 6004068.75731 | 2093681.57282 | 37.7290813662096 | -122.428206118922 | (37.7290813662096, -122.428206118922) | 9 | 7 | 6 | 28861 | 5 | |||
12757 | 27231 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 319X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003407.79227 | 2093529.1013 | 37.7286252931888 | -122.430480251933 | (37.7286252931888, -122.430480251933) | 9 | 7 | 6 | 28861 | 5 | |||
112479 | 178388 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 327 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003406.21695 | 2093529.35449 | 37.7286258991527 | -122.430485715962 | (37.7286258991527, -122.430485715962) | 9 | 7 | 6 | 28861 | 5 | |||
5688 | 15705 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4275 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003304.89544 | 2093685.57074 | 37.729049093647 | -122.430847134016 | (37.729049093647, -122.430847134016) | 9 | 7 | 6 | 28861 | 5 | |||
123128 | 43311 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003068.93568 | 2092663.25214 | 37.7262286645003 | -122.431589908071 | (37.7262286645003, -122.431589908071) | 9 | 7 | 6 | 28861 | 5 |
75088 | 80866 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 167 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50662 | 6003060.92852227 | 2092556.70085542 | 37.7259356446911 | -122.43160998466 | (37.7259356446911, -122.43160998466) | 9 | 7 | 6 | 28861 | 5 | ||
149448 | 43312 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003053.84834 | 2092643.73268 | 37.7261742132654 | -122.431640671199 | (37.7261742132654, -122.431640671199) | 9 | 7 | 6 | 28861 | 5 |
23641 | 43313 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6003041.97819 | 2092624.14713 | 37.7261197629015 | -122.431680307904 | (37.7261197629015, -122.431680307904) | 9 | 7 | 6 | 28861 | 5 |
18509 | 76705 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6003030.53484 | 2092605.75448 | 37.7260686121528 | -122.431718554264 | (37.7260686121528, -122.431718554264) | 9 | 7 | 6 | 28861 | 5 | ||
7380 | 75048 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6003019.45241 | 2092585.35122 | 37.7260119611657 | -122.431755409402 | (37.7260119611657, -122.431755409402) | 9 | 7 | 6 | 28861 | 5 | ||
194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 | ||
14855 | 75049 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6003005.92399 | 2092563.39586 | 37.7259509097926 | -122.431800609333 | (37.7259509097926, -122.431800609333) | 9 | 7 | 6 | 28861 | 5 | ||
159783 | 178387 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002886.68942 | 2092797.68104 | 37.7265874445442 | -122.432229519385 | (37.7265874445442, -122.432229519385) | 9 | 7 | 6 | 28861 | 5 | |||
170884 | 178386 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002873.11956 | 2092775.20615 | 37.7265249641326 | -122.432274825446 | (37.7265249641326, -122.432274825446) | 9 | 7 | 6 | 28861 | 5 | |||
101378 | 178385 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002858.54896 | 2092753.087 | 37.7264634037409 | -122.432323616338 | (37.7264634037409, -122.432323616338) | 9 | 7 | 6 | 28861 | 5 | |||
190992 | 178384 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002851.22923 | 2092740.35479 | 37.726428028905 | -122.432348011369 | (37.726428028905, -122.432348011369) | 9 | 7 | 6 | 28861 | 5 | |||
79676 | 75385 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 163X London St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
84632 | 77991 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 163X London St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
50176 | 99498 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6002794.02408 | 2092508.79842 | 37.7257889832596 | -122.432529234659 | (37.7257889832596, -122.432529234659) | 9 | 7 | 6 | 28861 | 5 | ||
155256 | 178383 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002791.95484 | 2092644.53526 | 37.7261615687975 | -122.43254607895 | (37.7261615687975, -122.43254607895) | 9 | 7 | 6 | 28861 | 5 | |||
153384 | 43310 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 150X Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6002773.36898986 | 2092525.07870875 | 37.7258325139415 | -122.432601800105 | (37.7258325139415, -122.432601800105) | 9 | 7 | 6 | 28861 | 5 |
28372 | 180665 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 316 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 02:13:00 PM | 3 | Width 6ft | 6002643.65919 | 2086652.61793 | 37.7097006784091 | -122.432630907484 | (37.7097006784091, -122.432630907484) | 9 | 7 | 6 | 28861 | 5 | ||
8749 | 934 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1295 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X6 | 6002685.65968 | 2093990.26069 | 37.7298505986268 | -122.43300963811 | (37.7298505986268, -122.43300963811) | 9 | 7 | 6 | 28861 | 25 | |||
22975 | 44428 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | 9 | 7 | 6 | 28861 | 5 | |
186383 | 251738 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | 9 | 7 | 6 | 28861 | 5 | ||||
121881 | 44429 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002292.23602 | 2086990.00901 | 37.7106071446722 | -122.433869586918 | (37.7106071446722, -122.433869586918) | 9 | 7 | 6 | 28861 | 5 | |
186446 | 44425 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002264.41887 | 2086971.04816 | 37.7105535037251 | -122.433964374559 | (37.7105535037251, -122.433964374559) | 9 | 7 | 6 | 28861 | 5 | |
53065 | 44430 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002242.73231 | 2086958.14042 | 37.7105168311469 | -122.434038405862 | (37.7105168311469, -122.434038405862) | 9 | 7 | 6 | 28861 | 5 | |
83787 | 44436 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 445 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43769 | 6002209.45256 | 2087683.95984 | 37.7125078834094 | -122.434205282273 | (37.7125078834094, -122.434205282273) | 9 | 7 | 6 | 28861 | 5 | |
191044 | 44433 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002157.33037 | 2086913.45824 | 37.7103892965003 | -122.434330380639 | (37.7103892965003, -122.434330380639) | 9 | 7 | 6 | 28861 | 5 | |
29456 | 44432 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
41816 | 44422 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
82780 | 44427 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
85575 | 44435 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
160852 | 44424 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
164639 | 44426 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
144843 | 44434 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002147.41851 | 2086908.48033 | 37.7103750656342 | -122.434364282404 | (37.7103750656342, -122.434364282404) | 9 | 7 | 6 | 28861 | 5 | |
187397 | 44423 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002132.44633 | 2086900.81583 | 37.7103531707288 | -122.4344154817 | (37.7103531707288, -122.4344154817) | 9 | 7 | 6 | 28861 | 5 | |
150367 | 44421 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002090.25454 | 2086883.74706 | 37.7103039085691 | -122.434560085477 | (37.7103039085691, -122.434560085477) | 9 | 7 | 6 | 28861 | 5 | |
57997 | 44419 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002078.76238 | 2086879.79851 | 37.7102924143218 | -122.434599522549 | (37.7102924143218, -122.434599522549) | 9 | 7 | 6 | 28861 | 5 | |
92641 | 44418 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002034.50312 | 2086862.32419 | 37.7102419210068 | -122.434751242692 | (37.7102419210068, -122.434751242692) | 9 | 7 | 6 | 28861 | 5 | |
114509 | 65331 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 141 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28154 | 6002111.55813884 | 2095203.52869324 | 37.7331493741938 | -122.435081111485 | (37.7331493741938, -122.435081111485) | 9 | 7 | 5 | 63 | 40 | ||
106463 | 975 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1599 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X5 | 6001957.29298 | 2093112.49768 | 37.7273991195728 | -122.43546491497 | (37.7273991195728, -122.43546491497) | 9 | 7 | 6 | 28861 | 25 | |||
52610 | 977 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1599 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001822.91607 | 2092853.3598 | 37.7266799530333 | -122.43591092131 | (37.7266799530333, -122.43591092131) | 9 | 7 | 6 | 28861 | 25 | |||
2340 | 969 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1594 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6001782.25409 | 2092939.24295 | 37.7269134586749 | -122.436057631174 | (37.7269134586749, -122.436057631174) | 9 | 7 | 6 | 28861 | 25 | |||
186096 | 65343 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 184 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28175 | 6001750.39660253 | 2095029.30684218 | 37.7326504865842 | -122.436317277562 | (37.7326504865842, -122.436317277562) | 9 | 7 | 5 | 63 | 40 | ||
39199 | 65341 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 188 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28173 | 6001746.6239921 | 2095001.97603702 | 37.732575228117 | -122.436328365067 | (37.732575228117, -122.436328365067) | 9 | 7 | 5 | 63 | 40 | ||
49102 | 65342 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 186 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28174 | 6001746.84094237 | 2095012.67377274 | 37.7326046139677 | -122.436328380361 | (37.7326046139677, -122.436328380361) | 9 | 7 | 5 | 63 | 40 | ||
27313 | 178374 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 65 Leo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6001329.59125 | 2091462.81855 | 37.7228338056295 | -122.437516790173 | (37.7228338056295, -122.437516790173) | 9 | 7 | 6 | 28861 | 25 | |||
155794 | 52524 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 107 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | Permit Number 48624 | 6000729.49329 | 2092545.62188 | 37.7257727999708 | -122.439668786882 | (37.7257727999708, -122.439668786882) | 9 | 7 | 6 | 28861 | 25 | |
79738 | 62193 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 117 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1985 12:00:00 AM | Permit Number 22312 | 6000450.83413219 | 2092179.07109151 | 37.7247504709162 | -122.440605808871 | (37.7247504709162, -122.440605808871) | 9 | 7 | 6 | 28861 | 25 | ||
12721 | 1063 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2065X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000404.00413 | 2090092.28699 | 37.7190179700695 | -122.440618085581 | (37.7190179700695, -122.440618085581) | 9 | 7 | 6 | 28861 | 25 | |||
73850 | 178375 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 195 Allison St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6000082.16906 | 2087746.81309 | 37.712559495501 | -122.441562317569 | (37.712559495501, -122.441562317569) | 9 | 7 | 6 | 28861 | 5 | |||
192945 | 178376 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 195 Allison St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6000081.42891 | 2087748.87485 | 37.712565114463 | -122.441565023612 | (37.712565114463, -122.441565023612) | 9 | 7 | 6 | 28861 | 5 | |||
95152 | 211430 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 192 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000196.52602 | 2095258.93091 | 37.7331925683786 | -122.441705847568 | (37.7331925683786, -122.441705847568) | 9 | 7 | 5 | 63 | 40 | ||||
5223 | 62183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1957 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1985 12:00:00 AM | Permit Number 22301 | 5999981.22618008 | 2092577.81268407 | 37.7258185704465 | -122.44225779266 | (37.7258185704465, -122.44225779266) | 9 | 7 | 6 | 28861 | 25 | ||
15446 | 69493 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 328 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33616 | 5999811.39724946 | 2091920.22474562 | 37.7240033047922 | -122.44279767888 | (37.7240033047922, -122.44279767888) | 9 | 7 | 6 | 28861 | 25 | ||
82541 | 211427 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 65 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5999709.39376 | 2097376.92843 | 37.7389803226746 | -122.443542082395 | (37.7389803226746, -122.443542082395) | 9 | 7 | 4 | 59 | 40 | |||
162707 | 37343 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 517 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 4 | Permit Number 39851 | 5999456.75939 | 2086965.30426 | 37.7103779965068 | -122.443667813037 | (37.7103779965068, -122.443667813037) | 9 | 7 | 6 | 28861 | 5 | |
149214 | 13412 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 424 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999639.6116279 | 2097094.1286968 | 37.7381998416451 | -122.443763044504 | (37.7381998416451, -122.443763044504) | 9 | 7 | 4 | 59 | 40 | |||
155077 | 211431 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 278 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5999570.66466 | 2095256.06899 | 37.7331490303839 | -122.443869406865 | (37.7331490303839, -122.443869406865) | 9 | 7 | 4 | 63 | 40 | |||
107387 | 211428 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 53 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999583.37084 | 2097473.06947 | 37.7392371150928 | -122.443984716141 | (37.7392371150928, -122.443984716141) | 9 | 7 | 4 | 59 | 40 | |||
161820 | 211429 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 52 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999576.15591 | 2097477.53164 | 37.739248955579 | -122.44400998258 | (37.739248955579, -122.44400998258) | 9 | 7 | 4 | 59 | 40 | |||
122160 | 13413 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Marietta Dr | 2 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999541.98598 | 2097031.37514 | 37.7380219664255 | -122.444096076493 | (37.7380219664255, -122.444096076493) | 9 | 7 | 4 | 59 | 40 | |||
97985 | 13414 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Marietta Dr | 3 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999540.96545 | 2097034.36116 | 37.7380301071099 | -122.444099819458 | (37.7380301071099, -122.444099819458) | 9 | 7 | 4 | 59 | 40 | |||
140703 | 57948 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 14 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 9 | Permit Number 16907 | 5999317.87409 | 2086697.21796 | 37.709633969409 | -122.444128577089 | (37.709633969409, -122.444128577089) | 9 | 7 | 6 | 28861 | 5 | ||
28558 | 45475 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1355 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44760 | 5999364.2117528 | 2089872.65901255 | 37.7183556553422 | -122.444196457807 | (37.7183556553422, -122.444196457807) | 9 | 7 | 6 | 28861 | 25 | ||
141150 | 211426 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400x Marietta Dr | 8 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999504.16591 | 2097034.85619 | 37.7380293669502 | -122.444227088834 | (37.7380293669502, -122.444227088834) | 9 | 7 | 4 | 59 | 40 | |||
78601 | 57949 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 16 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 8 | Permit Number 16908 | 5999256.00799 | 2086683.69155 | 37.7095932993484 | -122.444341425011 | (37.7095932993484, -122.444341425011) | 9 | 7 | 6 | 28861 | 5 | ||
142073 | 211358 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 43 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 5999479.63051 | 2097509.53542 | 37.739331323589 | -122.444346022364 | (37.739331323589, -122.444346022364) | 9 | 7 | 4 | 59 | 40 | |||
181046 | 211357 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 42 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5999475.8897 | 2097510.54989 | 37.7393338956504 | -122.444359029265 | (37.7393338956504, -122.444359029265) | 9 | 7 | 4 | 59 | 40 | |||
50474 | 211356 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 41 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5999471.52853 | 2097511.88906 | 37.7393373238643 | -122.444374204418 | (37.7393373238643, -122.444374204418) | 9 | 7 | 4 | 59 | 40 | |||
122243 | 57951 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 20 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 8 | Permit Number 16910 | 5999175.28724 | 2086654.44563 | 37.7095083907733 | -122.444618308297 | (37.7095083907733, -122.444618308297) | 9 | 7 | 6 | 28861 | 5 | ||
42846 | 57952 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 22 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 9 | Permit Number 16911 | 5999137.45603 | 2086642.23911 | 37.7094727155743 | -122.444748182092 | (37.7094727155743, -122.444748182092) | 9 | 7 | 6 | 28861 | 5 | ||
122921 | 57953 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 24 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 15 | Permit Number 16912 | 5999096.91395 | 2086625.15148 | 37.7094234830895 | -122.444887074305 | (37.7094234830895, -122.444887074305) | 9 | 7 | 6 | 28861 | 5 | ||
188822 | 211355 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 30 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5999309.78108 | 2097559.20163 | 37.7394580029801 | -122.444936853564 | (37.7394580029801, -122.444936853564) | 9 | 7 | 4 | 59 | 40 | |||
56038 | 211354 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 23 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5999278.01006 | 2097568.54324 | 37.7394818395234 | -122.445047374833 | (37.7394818395234, -122.445047374833) | 9 | 7 | 4 | 59 | 40 | |||
142311 | 1120 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2445 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999090.26548 | 2088844.34196 | 37.7155164987647 | -122.445069485575 | (37.7155164987647, -122.445069485575) | 9 | 7 | 6 | 28861 | 25 | |||
75349 | 211433 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 136 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999107.76452 | 2093515.11915 | 37.7283423752978 | -122.445344638542 | (37.7283423752978, -122.445344638542) | 9 | 7 | 4 | 28861 | 40 | |||
133754 | 211353 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 9 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999190.61493 | 2097593.0278 | 37.7395440797867 | -122.445351307915 | (37.7395440797867, -122.445351307915) | 9 | 7 | 4 | 59 | 40 | |||
109006 | 178362 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 108 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5998943.86052 | 2088042.92429 | 37.7133076307222 | -122.445517930731 | (37.7133076307222, -122.445517930731) | 9 | 7 | 6 | 28861 | 25 | |||
96911 | 178363 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 108 Foote Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998929.00366 | 2088057.1044 | 37.7133457179055 | -122.445570300043 | (37.7133457179055, -122.445570300043) | 9 | 7 | 6 | 28861 | 25 | |||
568 | 78813 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 110 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998921.12979 | 2088066.27223 | 37.713370441156 | -122.445598173631 | (37.713370441156, -122.445598173631) | 9 | 7 | 6 | 28861 | 25 | |||
7430 | 78727 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 110 Foote Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998904.8782 | 2088083.88832 | 37.7134178830944 | -122.445655610625 | (37.7134178830944, -122.445655610625) | 9 | 7 | 6 | 28861 | 25 | |||
96099 | 159380 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 321 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 09:55:00 AM | 3 | Width 0ft | 5998873.83978 | 2087899.28592 | 37.7129092346593 | -122.445749622169 | (37.7129092346593, -122.445749622169) | 9 | 7 | 6 | 28861 | 25 | ||
101738 | 65671 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 759 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28591 | 5999036.51165566 | 2095907.91255274 | 37.7349083558011 | -122.445762972308 | (37.7349083558011, -122.445762972308) | 9 | 7 | 4 | 59 | 40 | ||
9322 | 159377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 339 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:19:00 AM | 3 | Width 0ft | 5998814.07521 | 2087846.21352 | 37.7127600973784 | -122.445952372517 | (37.7127600973784, -122.445952372517) | 9 | 7 | 6 | 28861 | 25 |
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) );