trees
7,157 rows where qSpecies_id = 36 sorted by YCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27955 | 98783 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003517.50088 | 2121237.52457 | 37.80471211193 | -122.432078855049 | (37.80471211193, -122.432078855049) | 13 | 9 | 1 | 57 | 17 | |||
75351 | 132543 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Prado St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000738.025 | 2121236.40419 | 37.8045510631517 | -122.441697402908 | (37.8045510631517, -122.441697402908) | 13 | 9 | 1 | 57 | 17 | |||
118925 | 132542 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Prado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000719.09431 | 2121234.21114 | 37.8045439630017 | -122.441762756646 | (37.8045439630017, -122.441762756646) | 13 | 9 | 1 | 57 | 17 | |||
817 | 132762 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003038.53227 | 2121230.80772 | 37.8046665028104 | -122.43373589191 | (37.8046665028104, -122.43373589191) | 13 | 9 | 1 | 57 | 17 | |||
174683 | 132541 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Prado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000698.95451 | 2121230.63283 | 37.8045329903671 | -122.441832195112 | (37.8045329903671, -122.441832195112) | 13 | 9 | 1 | 57 | 17 | |||
155393 | 132540 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Prado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000678.86835 | 2121229.63931 | 37.8045291178891 | -122.441901633567 | (37.8045291178891, -122.441901633567) | 13 | 9 | 1 | 57 | 17 | |||
24959 | 98573 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
47784 | 98579 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
79751 | 98566 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/04/2013 12:00:00 AM | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | ||
152258 | 98578 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:53:00 AM | 3 | 6x7 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
152503 | 98570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:47:00 AM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
155011 | 98574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
156452 | 98568 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:55:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
160459 | 98572 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
175355 | 98575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
80723 | 142526 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | Width 0ft | 6009810.3798 | 2121222.957 | 37.8050268727325 | -122.410300597206 | (37.8050268727325, -122.410300597206) | 3 | 1 | 10 | 308 | 23 | |||
124851 | 98773 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003452.6 | 2121222.8 | 37.8046680023994 | -122.432302398634 | (37.8046680023994, -122.432302398634) | 13 | 9 | 1 | 57 | 17 | ||||
107284 | 143207 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010351.5667 | 2121221.8584 | 37.8050541777689 | -122.408427671693 | (37.8050541777689, -122.408427671693) | 3 | 1 | 10 | 308 | 23 | |||
165782 | 98784 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003528.38693 | 2121221.7367 | 37.8046693797454 | -122.43204005471 | (37.8046693797454, -122.43204005471) | 13 | 9 | 1 | 57 | 17 | |||
83356 | 142550 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/26/2016 09:53:00 AM | 22 | Width 0ft | 6009784.6811 | 2121219.3711 | 37.8050155861628 | -122.410389277522 | (37.8050155861628, -122.410389277522) | 3 | 1 | 10 | 308 | 23 | ||
139149 | 65527 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3741 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1990 12:00:00 AM | 7 | Permit Number 28425 | 6003040.03045 | 2121216.48482 | 37.8046272609043 | -122.433729683003 | (37.8046272609043, -122.433729683003) | 13 | 9 | 1 | 57 | 17 | ||
170071 | 66121 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 341 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 10 | Permit Number 29183 | 6000875.659 | 2121214.03728 | 37.8044974905357 | -122.441219503176 | (37.8044974905357, -122.441219503176) | 13 | 9 | 1 | 57 | 17 | ||
11570 | 66036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3737 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1990 12:00:00 AM | 7 | Permit Number 29073 | 6000613.44807 | 2121211.22675 | 37.8044748339084 | -122.442126703295 | (37.8044748339084, -122.442126703295) | 13 | 9 | 1 | 57 | 17 | ||
102799 | 143206 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010352.4449 | 2121209.5628 | 37.8050204662791 | -122.408423764738 | (37.8050204662791, -122.408423764738) | 3 | 1 | 10 | 308 | 23 | |||
8590 | 142524 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/23/2016 02:52:00 PM | 20 | Width 0ft | 6009733.2838 | 2121208.6135 | 37.8049831671154 | -122.410566384357 | (37.8049831671154, -122.410566384357) | 3 | 1 | 10 | 308 | 23 | ||
99299 | 142522 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | Width 0ft | 6009689.0581 | 2121206.8206 | 37.8049757647303 | -122.410719306308 | (37.8049757647303, -122.410719306308) | 3 | 1 | 10 | 308 | 23 | |||
125465 | 142523 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009712.3662 | 2121206.8206 | 37.8049770715314 | -122.410638645677 | (37.8049770715314, -122.410638645677) | 3 | 1 | 10 | 308 | 23 | |||
52051 | 100288 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
73467 | 100290 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
92764 | 100287 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
108094 | 100289 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
159235 | 100291 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
69868 | 142549 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 9 | Width 0ft | 6009666.9453 | 2121202.0395 | 37.8049613971858 | -122.410795492578 | (37.8049613971858, -122.410795492578) | 3 | 1 | 10 | 308 | 23 | |||
56126 | 132539 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1999 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999735.73415 | 2121201.4853 | 37.8043980273161 | -122.445163399071 | (37.8043980273161, -122.445163399071) | 13 | 9 | 1 | 57 | 17 | |||
167327 | 98785 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003521.84096 | 2121200.89529 | 37.8046117835793 | -122.432061218465 | (37.8046117835793, -122.432061218465) | 13 | 9 | 1 | 57 | 17 | |||
165062 | 142548 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009639.4537 | 2121197.2583 | 37.8049467277157 | -122.410890292822 | (37.8049467277157, -122.410890292822) | 3 | 1 | 10 | 308 | 23 | |||
95762 | 65536 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3750 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 7 | Permit Number 29012 | 6000660.38848 | 2121196.27662 | 37.804436459834 | -122.44196318856 | (37.804436459834, -122.44196318856) | 13 | 9 | 1 | 57 | 17 | |
23511 | 132749 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2068 Jefferson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999296.53972 | 2121195.84078 | 37.8043574507926 | -122.446682856733 | (37.8043574507926, -122.446682856733) | 13 | 9 | 1 | 57 | 17 | |||
121500 | 98779 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3700X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003247.3 | 2121194.2 | 37.8045778314901 | -122.433010814251 | (37.8045778314901, -122.433010814251) | 13 | 9 | 1 | 57 | 17 | ||||
71668 | 142546 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/26/2016 09:47:00 AM | 23 | Width 0ft | 6009592.8375 | 2121191.8795 | 37.8049293448711 | -122.411051233847 | (37.8049293448711, -122.411051233847) | 3 | 1 | 10 | 308 | 23 | ||
135095 | 143205 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010355.0797 | 2121190.6804 | 37.8049687674386 | -122.408413313951 | (37.8049687674386, -122.408413313951) | 3 | 1 | 10 | 308 | 23 | |||
50188 | 132742 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3737 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000616.2484 | 2121189.59851 | 37.8044156081446 | -122.442115459069 | (37.8044156081446, -122.442115459069) | 13 | 9 | 1 | 57 | 17 | |||
85565 | 98786 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003533.09447 | 2121186.45287 | 37.8045727664737 | -122.432021242695 | (37.8045727664737, -122.432021242695) | 13 | 9 | 1 | 57 | 17 | |||
98442 | 142544 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/23/2016 02:55:00 PM | 26 | Width 0ft | 6009534.8661 | 2121184.7078 | 37.8049064021217 | -122.411251344133 | (37.8049064021217, -122.411251344133) | 3 | 1 | 10 | 308 | 23 | ||
137735 | 66049 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 333 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 10 | Permit Number 29182 | 6000880.15791 | 2121180.56294 | 37.8044058352172 | -122.441201531147 | (37.8044058352172, -122.441201531147) | 13 | 9 | 1 | 57 | 17 | ||
5801 | 68207 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2048 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1993 12:00:00 AM | 10 | Permit Number 31989 | 6009891.7858 | 2121179.0457 | 37.8049108661303 | -122.410015779346 | (37.8049108661303, -122.410015779346) | 3 | 1 | 10 | 308 | 23 | |
159642 | 132538 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2015 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999553.84029 | 2121177.76729 | 37.8043225202228 | -122.445791149248 | (37.8043225202228, -122.445791149248) | 13 | 9 | 1 | 57 | 17 | |||
55266 | 142521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/04/2013 12:00:00 AM | 0 | Width 0ft | 6009485.2617 | 2121177.5361 | 37.8048839283261 | -122.411422499274 | (37.8048839283261, -122.411422499274) | 3 | 1 | 10 | 308 | 23 | ||
47465 | 132537 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2015 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999535.53321 | 2121174.61585 | 37.8043128219315 | -122.445854275378 | (37.8043128219315, -122.445854275378) | 13 | 9 | 1 | 57 | 17 | |||
27927 | 132763 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3735 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003047.69207 | 2121172.45725 | 37.8045068075103 | -122.433700020641 | (37.8045068075103, -122.433700020641) | 13 | 9 | 1 | 57 | 17 | |||
140422 | 132747 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2100 Jefferson St | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 5999125.84165 | 2121169.76474 | 37.8042761008346 | -122.447271691431 | (37.8042761008346, -122.447271691431) | 13 | 9 | 1 | 57 | 17 | ||||
172592 | 143204 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010358.5927 | 2121168.7241 | 37.804908677608 | -122.408399607103 | (37.804908677608, -122.408399607103) | 3 | 1 | 10 | 308 | 23 | |||
27406 | 44181 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3731 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2000 12:00:00 AM | 8 | Permit Number 43642 | 6000618.49035 | 2121167.17319 | 37.8043541619898 | -122.442106089925 | (37.8043541619898, -122.442106089925) | 13 | 9 | 1 | 57 | 17 | ||
68344 | 98787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003526.90224 | 2121166.28084 | 37.8045170283068 | -122.432041230117 | (37.8045170283068, -122.432041230117) | 13 | 9 | 1 | 57 | 17 | |||
97772 | 249771 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 2 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | 3 | 1 | 10 | 308 | 23 | |||
136364 | 249772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 3 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.408121373518 | (37.8049001107042, -122.408121373518) | 3 | 1 | 10 | 308 | 23 | |||
133932 | 132748 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2100 Jefferson St | 5 | Front Yard : Yard | Tree | Private 2 | 35 | 5999067.6485 | 2121161.91588 | 37.8042512246639 | -122.447472507359 | (37.8042512246639, -122.447472507359) | 13 | 9 | 1 | 57 | 17 | ||||
70422 | 65642 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 324 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1990 12:00:00 AM | 9 | Permit Number 28555 | 6000917.13129 | 2121158.05026 | 37.8043461274204 | -122.441071965805 | (37.8043461274204, -122.441071965805) | 13 | 9 | 1 | 57 | 17 | ||
148731 | 65863 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3738 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 2 | Permit Number 28855 | 6000664.77895 | 2121157.36382 | 37.8043298658938 | -122.441945200307 | (37.8043298658938, -122.441945200307) | 13 | 9 | 1 | 57 | 17 | |
59893 | 132764 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3735 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003049.36463 | 2121156.9395 | 37.8044642947518 | -122.433693122861 | (37.8044642947518, -122.433693122861) | 13 | 9 | 1 | 57 | 17 | |||
192800 | 249773 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 4 | Side Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.8048710311487 | -122.408142559726 | (37.8048710311487, -122.408142559726) | 3 | 1 | 10 | 308 | 23 | |||
352 | 98788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003538.80686 | 2121150.47161 | 37.804474295204 | -122.431998903525 | (37.804474295204, -122.431998903525) | 13 | 9 | 1 | 57 | 17 | |||
122724 | 143226 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1931 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010322.1986 | 2121149.6678 | 37.804854315613 | -122.408524208369 | (37.804854315613, -122.408524208369) | 3 | 1 | 10 | 308 | 23 | |||
150250 | 110301 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3727 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775502 | 6003051.71719 | 2121145.37774 | 37.8044326826855 | -122.4336841548 | (37.8044326826855, -122.4336841548) | 13 | 9 | 1 | 57 | 17 | |
167772 | 249779 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Pfeiffer St | 3 | Back Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6010421.07006 | 2121139.10534 | 37.8048308503332 | -122.408181306135 | (37.8048308503332, -122.408181306135) | 3 | 1 | 10 | 308 | 23 | |||
191247 | 142717 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008054.1886 | 2121138.8091 | 37.8046972234707 | -122.41637215184 | (37.8046972234707, -122.41637215184) | 5 | 1 | 10 | 308 | 23 | |||
66053 | 249778 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Pfeiffer St | 4 | Back Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6010409.80858 | 2121137.78544 | 37.804826595643 | -122.408220184708 | (37.804826595643, -122.408220184708) | 3 | 1 | 10 | 308 | 23 | |||
100486 | 4737 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1120 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6008092.82938 | 2121137.35417 | 37.804695401428 | -122.416238328085 | (37.804695401428, -122.416238328085) | 5 | 1 | 10 | 308 | 23 | |||
145521 | 4739 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1120 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/1992 12:00:00 AM | 8 | 3X3 | 6008092.82938 | 2121137.35417 | 37.804695401428 | -122.416238328085 | (37.804695401428, -122.416238328085) | 5 | 1 | 10 | 308 | 23 | ||
120001 | 249777 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Pfeiffer St | 5 | Back Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6010400.42707 | 2121136.58311 | 37.8048227690275 | -122.40825256571 | (37.8048227690275, -122.40825256571) | 3 | 1 | 10 | 308 | 23 | |||
131186 | 110302 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3727 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003053.67126 | 2121133.82421 | 37.804401070605 | -122.433676566343 | (37.804401070605, -122.433676566343) | 13 | 9 | 1 | 57 | 17 | |||
30378 | 110304 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3735 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002991 | 2121133 | 37.8043952513031 | -122.433893386438 | (37.8043952513031, -122.433893386438) | 13 | 9 | 1 | 57 | 17 | ||||
139972 | 110303 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3735 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002991 | 2121133 | 37.8043952513031 | -122.433893386438 | (37.8043952513031, -122.433893386438) | 13 | 9 | 1 | 57 | 17 | ||||
22170 | 100293 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3725 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003057 | 2121128 | 37.8043852677309 | -122.433664630457 | (37.8043852677309, -122.433664630457) | 13 | 9 | 1 | 57 | 17 | |||
105159 | 100295 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3725 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003057 | 2121128 | 37.8043852677309 | -122.433664630457 | (37.8043852677309, -122.433664630457) | 13 | 9 | 1 | 57 | 17 | |||
120461 | 142715 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008089.7742 | 2121106.9415 | 37.8046117241212 | -122.416246745544 | (37.8046117241212, -122.416246745544) | 5 | 1 | 10 | 308 | 23 | |||
181051 | 100303 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3727 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769497 | 6003057.09868 | 2121106.75706 | 37.804326945799 | -122.43366276982 | (37.804326945799, -122.43366276982) | 13 | 9 | 1 | 57 | 17 | |
137450 | 99107 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1766 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | 3x3 | Permit Number 775193 | 6001658.68735 | 2121105.16624 | 37.8042431316708 | -122.438501963298 | (37.8042431316708, -122.438501963298) | 13 | 9 | 1 | 57 | 17 | |
151919 | 132757 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601 Laguna St | 10 | : | Tree | Private 2 | 8 | Width 4ft | 6003537.25934 | 2121091.97197 | 37.8043135827752 | -122.432000078959 | (37.8043135827752, -122.432000078959) | 13 | 9 | 1 | 57 | 17 | |||
70734 | 100297 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3725 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003062 | 2121090 | 37.8042812134182 | -122.43364461008 | (37.8042812134182, -122.43364461008) | 13 | 9 | 1 | 57 | 17 | |||
92515 | 100299 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3725 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003062 | 2121090 | 37.8042812134182 | -122.43364461008 | (37.8042812134182, -122.43364461008) | 13 | 9 | 1 | 57 | 17 | |||
105008 | 98776 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003515.54038 | 2121088.88501 | 37.8043038754771 | -122.43207501857 | (37.8043038754771, -122.43207501857) | 13 | 9 | 1 | 57 | 17 | |||
61844 | 98775 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003497.24376 | 2121086.80663 | 37.8042971314615 | -122.432138186954 | (37.8042971314615, -122.432138186954) | 13 | 9 | 1 | 57 | 17 | |||
59066 | 98774 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 13 | 3x3 | 6003476.9646 | 2121084.27758 | 37.8042890375842 | -122.432208183857 | (37.8042890375842, -122.432208183857) | 13 | 9 | 1 | 57 | 17 | |||
10596 | 98772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003427.71574 | 2121076.45183 | 37.804264757687 | -122.432378054112 | (37.804264757687, -122.432378054112) | 13 | 9 | 1 | 57 | 17 | |||
186125 | 98780 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003551.8 | 2121073.9 | 37.8042647862028 | -122.431948468614 | (37.8042647862028, -122.431948468614) | 13 | 9 | 1 | 57 | 17 | ||||
24556 | 132754 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3676 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002135.81287 | 2121072.95141 | 37.8041818069102 | -122.436848528261 | (37.8041818069102, -122.436848528261) | 13 | 9 | 1 | 57 | 17 | |||
109366 | 98771 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003408.14062 | 2121072.18905 | 37.8042519432217 | -122.432445490669 | (37.8042519432217, -122.432445490669) | 13 | 9 | 1 | 57 | 17 | |||
86790 | 133076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 929 Bay St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006356.93871 | 2121072.04496 | 37.8044183178065 | -122.422240916685 | (37.8044183178065, -122.422240916685) | 5 | 1 | 1 | 28858 | 32 | |||
139572 | 98770 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003379.21654 | 2121069.10166 | 37.8042418258748 | -122.432545363992 | (37.8042418258748, -122.432545363992) | 13 | 9 | 1 | 57 | 17 | |||
175944 | 98769 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003355.72677 | 2121066.39367 | 37.8042330583593 | -122.432626458567 | (37.8042330583593, -122.432626458567) | 13 | 9 | 1 | 57 | 17 | |||
114628 | 98768 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003334.44122 | 2121062.90291 | 37.8042222665138 | -122.432699869304 | (37.8042222665138, -122.432699869304) | 13 | 9 | 1 | 57 | 17 | |||
101751 | 98767 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6003313.43742 | 2121061.12622 | 37.8042161969888 | -122.432772427524 | (37.8042161969888, -122.432772427524) | 13 | 9 | 1 | 57 | 17 | |||
92277 | 100973 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 0 | Permit Number 37341 | 6009614 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | 3 | 1 | 10 | 308 | 23 | ||
80428 | 67461 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1913 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1992 12:00:00 AM | 9 | Permit Number 30972 | 6010350.2843 | 2121059.4182 | 37.8046080854206 | -122.408420644539 | (37.8046080854206, -122.408420644539) | 3 | 1 | 10 | 308 | 23 | ||
147101 | 98766 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003296.85169 | 2121058.27535 | 37.8042074285801 | -122.43282961989 | (37.8042074285801, -122.43282961989) | 13 | 9 | 1 | 57 | 17 | |||
67329 | 41182 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1781 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 10 | Permit Number 41900 | 6001635.93315 | 2121055.71029 | 37.8041060444241 | -122.438577160103 | (37.8041060444241, -122.438577160103) | 13 | 9 | 1 | 57 | 17 | |
36648 | 98765 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 17 | 3x3 | 6003279.0227 | 2121054.95921 | 37.8041973121189 | -122.432891081376 | (37.8041973121189, -122.432891081376) | 13 | 9 | 1 | 57 | 17 | |||
103684 | 98764 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003256.03634 | 2121052.73189 | 37.804189892713 | -122.432970468136 | (37.804189892713, -122.432970468136) | 13 | 9 | 1 | 57 | 17 | |||
97144 | 98763 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6003235.74698 | 2121049.71225 | 37.8041804507317 | -122.433040465073 | (37.8041804507317, -122.433040465073) | 13 | 9 | 1 | 57 | 17 |
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) );