sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5256 253838 2 141 1458 46th Ave 1 1 1 1 1     5.5x4   5981900.0 2105162.0 37.759324170949604 -122.505694672765 (37.7593241709496, -122.505694672765)
5176 253818 2 3 219 Concord St 2 1 1 1 1         5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318)
4844 253688 1 37 999 Natoma St 3 1 1 1 1         6007970.79373767 2109754.69864739 37.7734345505501 -122.415854130267 (37.7734345505501, -122.415854130267)
4555 253633 1 37 1907 Judah St 1 1 1 1 1 01/21/2016 12:00:00 AM   3x3 Permit Number 777409          
4771 253556 1 17 27 Ceres St 2 7 1 1 1 10/25/2017 12:00:00 AM 3   Permit Number 780682 6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
3759 253555 1 71 27 Ceres St 1 7 1 1 1         6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
1846 251738 1 108 859 Prague St 14 1 1 1 1         6002345.06488 2087027.78932 37.7107138789231 -122.433689697349 (37.7107138789231, -122.433689697349)
1801 251699 4 11 1230 Chestnut St 3 1 1 1 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6005943.79297 2120373.7363400003 37.8024776288704 -122.423620966152 (37.8024776288704, -122.423620966152)
1659 251643 2 17 2701 Leavenworth St 1 1 1 1 1     3x3   6007328.0 2121670.0 37.8061148757045 -122.418922903139 (37.8061148757045, -122.418922903139)
22409 249318 1 135 198X Prospect Ave 1 1 1 1 1     3x3            
13344 187697 1 68 1256 Treat Ave 2 1 1 1 1         6008667.10840058 2101226.16540452 37.7500562758063 -122.41284238591601 (37.7500562758063, -122.412842385916)
4787 180979 2 219 646 Vienna St 1 1 1 1 1 10/25/2017 11:41:00 AM 3 Width 4ft   6002832.2917599995 2089747.0840099999 37.7182081004084 -122.432199805772 (37.7182081004084, -122.432199805772)
4643 180958 2 207 778 Madrid St 1 1 1 1 1 10/18/2017 12:11:00 PM 3 Width 2ft   6001688.47401 2089452.0208 37.71733300339179 -122.43613238641001 (37.7173330033918, -122.43613238641)
3931 179081 2 26 72 Edinburgh St 4 1 1 1 1 10/04/2017 10:13:00 AM 3 Width 3ft   6004328.31139 2093147.65709 37.7276300348981 -122.42727080240499 (37.7276300348981, -122.427270802405)
3942 179080 2 26 72X Edinburgh St 3 1 1 1 1 10/04/2017 10:09:00 AM 3 Width 3ft   6004338.45578 2093161.16244 37.7276676912897 -122.42723669472099 (37.7276676912897, -122.427236694721)
4350 178825 2 73 927 Brazil Ave 1 1 1 1 1 10/11/2017 09:33:00 AM 3 Width 3ft   6004370.89542 2090731.88415 37.7209992632754 -122.42695160693998 (37.7209992632754, -122.42695160694)
4417 178030 2 207 745 Brazil Ave 1 1 1 1 1 10/11/2017 10:06:00 AM 3 Width 3ft   6003911.3035 2091023.37584 37.7217736371229 -122.42856104714899 (37.7217736371229, -122.428561047149)
10035 173805 1 64 221 Stillings Ave 2 1 1 1 1         5999380.73268965 2095746.24622826 37.7344841059817 -122.444561268208 (37.7344841059817, -122.444561268208)
9954 173752 1 15 1291 05th Ave 2 1 1 1 1     3x3   5994529.13136199 2106735.38069373 37.7643794565111 -122.46213141846201 (37.7643794565111, -122.462131418462)
9956 173750 1 11 989 South Van Ness Ave 2 1 1 1 1         6007621.28893018 2103912.36255672 37.7573732040434 -122.41664916584601 (37.7573732040434, -122.416649165846)
9827 173704 1 11 99x Majestic Ave 2 1 1 1 1     3x3   5997184.0 2089426.0 37.7170046100656 -122.451700294591 (37.7170046100656, -122.451700294591)
1809 172747 4 11 1230 Chestnut St 2 1 1 1 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006022.78943 2120387.12776 37.802518857014704 -122.423348551388 (37.8025188570147, -122.423348551388)
1812 172746 4 11 1230 Chestnut St 1 1 1 1 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006038.86692 2120389.38612 37.8025259652646 -122.423293075825 (37.8025259652646, -122.423293075825)
4778 161374 2 219 566 Madrid St 1 1 1 1 1 10/25/2017 03:36:00 PM 3 Width 0ft   6002430.61836 2090633.99378 37.720620574950296 -122.43365156969101 (37.7206205749503, -122.433651569691)
4356 161318 2 134 530 Edinburgh St 1 1 1 1 1 10/11/2017 08:04:00 AM 3 Width 0ft   6002775.65928 2090671.8623400002 37.7207441256113 -122.432461575944 (37.7207441256113, -122.432461575944)
4749 161284 2 8 567 Naples St 1 1 1 1 1 10/25/2017 03:30:00 PM 3 Width 0ft   6002918.80865 2090311.02788 37.7197614706043 -122.43194100068199 (37.7197614706043, -122.431941000682)
4828 161283 2 8 571 Naples St 1 1 1 1 1 10/25/2017 03:40:00 PM 3 Width 0ft   6002905.32345 2090290.85572 37.719705317820896 -122.431986174531 (37.7197053178209, -122.431986174531)
4766 161282 2 8 579 Naples St 1 1 1 1 1 10/25/2017 03:28:00 PM 3 Width 0ft   6002876.7147 2090246.5176400002 37.7195819533337 -122.432081900155 (37.7195819533337, -122.432081900155)
4744 161281 2 8 587 Naples St 1 1 1 1 1 10/25/2017 12:04:00 PM 3 Width 0ft   6002852.8609 2090206.41919 37.719470499446395 -122.432161491969 (37.7194704994464, -122.432161491969)
4800 161279 2 56 594 Naples St 1 1 1 1 1 10/25/2017 12:18:00 PM 3 Width 0ft   6002806.05279 2090211.99508 37.7194831555901 -122.43232368828998 (37.7194831555901, -122.43232368829)
4742 161277 2 135 582 Naples St 1 1 1 1 1 10/25/2017 12:23:00 PM 3 Width 0ft   6002834.75222 2090259.2052900002 37.7196144116499 -122.432227854755 (37.7196144116499, -122.432227854755)
4748 161275 2 135 574 Naples St 1 1 1 1 1 10/25/2017 12:26:00 PM 3 Width 0ft   6002859.417719999 2090297.5513900002 37.7197211000357 -122.432145332055 (37.7197211000357, -122.432145332055)
3387 161273 2 66 566 Naples St 1 1 1 1 1   0 Width 0ft   6002889.180369999 2090346.5289900003 37.719857269085104 -122.432045948864 (37.7198572690851, -122.432045948864)
4825 161272 2 135 562 Naples St 1 1 1 1 1 10/25/2017 03:33:00 PM 3 Width 0ft   6002894.24566 2090355.62698 37.719882537321 -122.43202908927499 (37.719882537321, -122.432029089275)
4786 161115 2 207 580 Vienna St 1 1 1 1 1 10/25/2017 03:13:00 PM 3 Width 0ft   6003070.44185 2090129.12968 37.719270613428705 -122.431403880597 (37.7192706134287, -122.431403880597)
4750 160919 2 49 656 Madrid St 1 1 1 1 1 10/25/2017 11:14:00 AM 3 Width 0ft   6002115.87134 2090131.5374900002 37.719223077968294 -122.43470363886001 (37.7192230779683, -122.43470363886)
4754 160918 2 49 650 Madrid St 1 1 1 1 1 10/25/2017 11:50:00 AM 3 Width 0ft   6002126.85051 2090151.3483900002 37.7192780975889 -122.43466710393 (37.7192780975889, -122.43466710393)
4770 160917 2 49 646 Madrid St 1 1 1 1 1 10/25/2017 11:31:00 AM 3 Width 0ft   6002146.555269999 2090180.2898900001 37.719358683138 -122.434601060409 (37.719358683138, -122.434601060409)
4761 160908 2 49 615 Madrid St 1 1 1 1 1 10/25/2017 12:06:00 PM 3 Width 0ft   6002284.55838 2090317.50092 37.7197432674186 -122.434133839205 (37.7197432674186, -122.434133839205)
4732 160902 2 51 687 Madrid St 1 1 1 1 1 10/24/2017 03:13:00 PM 3 Width 0ft   6002042.96964 2089934.48855 37.718677886450294 -122.43494154733101 (37.7186778864503, -122.434941547331)
4318 160894 2 7 642 Edinburgh St 1 1 1 1 1 10/11/2017 08:21:00 AM 3 Width 0ft   6002380.66916 2090044.6321900003 37.7189994849067 -122.43378212606702 (37.7189994849067, -122.433782126067)
4402 160893 2 7 634 Edinburgh St 1 1 1 1 1 10/11/2017 08:15:00 AM 3 Width 0ft   6002406.55833 2090085.42086 37.719112950580296 -122.433695551007 (37.7191129505803, -122.433695551007)
4376 160888 2 49 679 Edinburgh St 1 1 1 1 1 10/11/2017 08:26:00 AM 3 Width 0ft   6002304.816330001 2089843.73714 37.7184435671833 -122.43402996661999 (37.7184435671833, -122.43402996662)
4426 160887 2 49 687 Edinburgh St 1 1 1 1 1 10/11/2017 08:35:00 AM 3 Width 0ft   6002277.9096800005 2089801.2576099997 37.7183254007788 -122.434119936579 (37.7183254007788, -122.434119936579)
4815 160876 2 69 623 Naples St 1 1 1 1 1 10/25/2017 11:58:00 AM 3 Width 0ft   6002712.67368 2089986.17958 37.7188578210185 -122.43263034363702 (37.7188578210185, -122.432630343637)
4798 160859 2 219 618 Vienna St 1 1 1 1 1 10/25/2017 11:55:00 AM 3 Width 0ft   6002917.16918 2089882.76457 37.7185854613346 -122.43191610384 (37.7185854613346, -122.43191610384)
4807 160857 2 219 600 Vienna St 2 1 1 1 1 10/25/2017 11:39:00 AM 3 Width 0ft   6002958.77513 2089948.27932 37.718767708935296 -122.431776964359 (37.7187677089353, -122.431776964359)
4801 160856 2 219 600 Vienna St 1 1 1 1 1 10/25/2017 11:46:00 AM 3 Width 0ft   6002966.83908 2089959.0451 37.718797726500796 -122.431749858776 (37.7187977265008, -122.431749858776)
4652 160855 2 219 605 Vienna St 2 1 1 1 1 10/18/2017 03:32:00 PM 3 Width 0ft   6002988.68917 2089915.90653 37.7186805160719 -122.43167125353399 (37.7186805160719, -122.431671253534)
4666 160854 2 219 605 Vienna St 1 1 1 1 1 10/18/2017 03:30:00 PM 3 Width 0ft   6002981.40369 2089904.8646099998 37.71864978443121 -122.43169564854799 (37.7186497844312, -122.431695648548)
4728 160846 2 49 669 Vienna St 2 1 1 1 1 10/24/2017 12:20:00 PM 3 Width 0ft   6002781.71244 2089588.8302099998 37.717770702526295 -122.432363340291 (37.7177707025263, -122.432363340291)
4718 160845 2 49 669 Vienna St 1 1 1 1 1 10/24/2017 03:09:00 PM 3 Width 0ft   6002769.79165 2089568.5134700001 37.7177142412877 -122.432403094831 (37.7177142412877, -122.432403094831)
4637 160693 2 51 700 Russia Ave 1 1 1 1 1 10/18/2017 03:34:00 PM 3 Width 0ft   6003044.40323 2089957.59001 37.7187981275985 -122.431481646786 (37.7187981275985, -122.431481646786)
4796 160687 2 11 400 Russia Ave 1 1 1 1 1 10/25/2017 12:00:00 PM 3 Width 0ft   6002383.98515 2090374.0075 37.7199040644127 -122.433794193158 (37.7199040644127, -122.433794193158)
4686 160611 2 13 750X France Ave 4 1 1 1 1 10/18/2017 04:11:00 PM 3 Width 0ft   6002821.1864599995 2089320.8920099998 37.717037241564 -122.432207771993 (37.717037241564, -122.432207771993)
4644 160608 2 13 750X France Ave 1 1 1 1 1 10/18/2017 03:37:00 PM 3 Width 0ft   6002772.883169999 2089351.94517 37.717119767831505 -122.43237694973499 (37.7171197678315, -122.432376949735)
3455 160606 2 207 745 Vienna St 1 1 1 1 1   0 Width 0ft   6002538.27018 2089198.0058799998 37.716683778298 -122.43317690119301 (37.716683778298, -122.433176901193)
4636 160605 2 207 753 Vienna St 1 1 1 1 1 10/18/2017 01:48:00 PM 3 Width 0ft   6002503.48745 2089141.9591700002 37.7165279132188 -122.43329312510201 (37.7165279132188, -122.433293125102)
4649 160603 2 207 771 Vienna St 1 1 1 1 1 10/18/2017 12:20:00 PM 3 Width 0ft   6002439.45935 2089043.6154099999 37.7162542504093 -122.43350741373399 (37.7162542504093, -122.433507413734)
4646 160597 2 8 766 Vienna St 1 1 1 1 1 10/18/2017 01:25:00 PM 3 Width 0ft   6002414.55284 2089084.1537799998 37.716364146664205 -122.433596398053 (37.7163641466642, -122.433596398053)
4650 160596 2 8 762 Vienna St 1 1 1 1 1 10/18/2017 01:30:00 PM 3 Width 0ft   6002428.15191 2089106.63112 37.71642663607071 -122.43355099850599 (37.7164266360707, -122.433550998506)
4656 160582 2 26 725 Naples St 1 1 1 1 1 10/18/2017 03:12:00 PM 3 Width 0ft   6002352.537690001 2089413.73171 37.7172655758154 -122.433834295726 (37.7172655758154, -122.433834295726)
4688 160571 2 26 793 Naples St 1 1 1 1 1 10/18/2017 11:54:00 AM 3 Width 0ft   6002167.83829 2089121.34733 37.716452270331295 -122.43445182061899 (37.7164522703313, -122.434451820619)
4633 160570 2 26 795 Naples St 1 1 1 1 1 10/18/2017 11:41:00 AM 3 Width 0ft   6002146.9194 2089087.66438 37.716358596934796 -122.43452171951598 (37.7163585969348, -122.434521719516)
4676 160569 2 26 797 Naples St 1 1 1 1 1 10/18/2017 11:33:00 AM 3 Width 0ft   6002135.10796 2089068.7183299998 37.7163059047739 -122.434561191648 (37.7163059047739, -122.434561191648)
4635 160567 2 49 790 Naples St 1 1 1 1 1 10/18/2017 11:57:00 AM 3 Width 0ft   6002104.08605 2089098.7371 37.716386568565 -122.43467056358999 (37.716386568565, -122.43467056359)
4654 160563 2 49 750 Naples St 1 1 1 1 1 10/18/2017 01:34:00 PM 3 Width 0ft   6002231.24921 2089300.0903 37.7169466582377 -122.434245412715 (37.7169466582377, -122.434245412715)
4653 160561 2 49 730 Naples St 1 1 1 1 1 10/18/2017 01:42:00 PM 3 Width 0ft   6002306.04947 2089419.84324 37.7172797185636 -122.43399542008001 (37.7172797185636, -122.43399542008)
4648 160560 2 49 718 Naples St 1 1 1 1 1 10/18/2017 01:51:00 PM 3 Width 0ft   6002343.44923 2089479.7194599998 37.7174462478135 -122.43387042418301 (37.7174462478135, -122.433870424183)
4665 160559 2 49 710 Naples St 1 1 1 1 1 10/18/2017 03:15:00 PM 3 Width 0ft   6002373.4779900005 2089525.5110400002 37.7175736853632 -122.433769899784 (37.7175736853632, -122.433769899784)
4655 160555 2 174 500 France Ave 3 1 1 1 1 10/18/2017 03:28:00 PM 3 Width 0ft   6002272.40257 2089666.1121 37.7179540086612 -122.43412931651599 (37.7179540086612, -122.434129316516)
4640 160554 2 174 500 France Ave 2 1 1 1 1 10/18/2017 03:23:00 PM 3 Width 0ft   6002263.49591 2089671.42563 37.717968092930995 -122.43416048254299 (37.717968092931, -122.434160482543)
4645 160553 2 174 500 France Ave 1 1 1 1 1 10/18/2017 03:20:00 PM 3 Width 0ft   6002250.4874599995 2089679.2270400003 37.7179887755522 -122.434206004421 (37.7179887755522, -122.434206004421)
4363 160546 2 69 755 Edinburgh St 1 1 1 1 1 10/11/2017 08:38:00 AM 3 Width 0ft   6002026.63127 2089400.9055 37.7172118584185 -122.434959882691 (37.7172118584185, -122.434959882691)
4333 160542 2 69 787 Edinburgh St 1 1 1 1 1 10/11/2017 08:58:00 AM 3 Width 0ft   6001926.33849 2089244.2387299999 37.716775991190794 -122.435295346912 (37.7167759911908, -122.435295346912)
4423 160541 2 69 795 Edinburgh St 1 1 1 1 1 10/11/2017 09:01:00 AM 3 Width 0ft   6001897.94252 2089197.43685 37.7166458709939 -122.435390151656 (37.7166458709939, -122.435390151656)
4436 160539 2 155 766 Edinburgh St 1 1 1 1 1 10/11/2017 08:48:00 AM 3 Width 0ft   6001957.37061 2089373.1576 37.717131736014 -122.435197300138 (37.717131736014, -122.435197300138)
4429 160538 2 155 762 Edinburgh St 1 1 1 1 1 10/11/2017 08:54:00 AM 3 Width 0ft   6001968.73126 2089389.7304599998 37.7171778865305 -122.435159216538 (37.7171778865305, -122.435159216538)
4631 160530 2 174 420X France Ave 1 1 1 1 1 10/18/2017 04:06:00 PM 3 Width 0ft   6002060.6240300005 2089797.75117 37.7183034384358 -122.434870749998 (37.7183034384358, -122.434870749998)
4675 160521 2 207 786 Madrid St 1 1 1 1 1 10/18/2017 11:59:00 AM 3 Width 0ft   6001662.29271 2089410.30964 37.7172169863455 -122.436219899452 (37.7172169863455, -122.436219899452)
4678 160520 2 207 782 Madrid St 1 1 1 1 1 10/18/2017 12:02:00 PM 3 Width 0ft   6001673.45326 2089428.5205599999 37.7172676235708 -122.436182625252 (37.7172676235708, -122.436182625252)
4672 160512 2 51 718 Madrid St 1 1 1 1 1 10/18/2017 03:07:00 PM 3 Width 0ft   6001887.21385 2089766.7884 37.7182085743334 -122.43546794121 (37.7182085743334, -122.43546794121)
4681 160510 2 73 706 Madrid St 1 1 1 1 1 10/18/2017 03:18:00 PM 3 Width 0ft   6001927.69711 2089831.3140900002 37.7183880466434 -122.435332621096 (37.7183880466434, -122.435332621096)
4720 160434 2 51 401 France Ave 4 1 1 1 1 10/24/2017 12:17:00 PM 3 Width 0ft   6002057.78511 2089843.09143 37.7184277715106 -122.434883803643 (37.7184277715106, -122.434883803643)
4722 160433 2 73 401 France Ave 3 1 1 1 1 10/24/2017 12:12:00 PM 3 Width 0ft   6002070.28716 2089835.8834 37.7184086896908 -122.43484007413 (37.7184086896908, -122.43484007413)
4803 160423 2 73 525 France Ave 1 1 1 1 1 10/25/2017 03:43:00 PM 3 Width 0ft   6002340.52441 2089668.33181 37.7179639695305 -122.433894007997 (37.7179639695305, -122.433894007997)
4632 160422 2 73 591 France Ave 2 1 1 1 1 10/18/2017 03:59:00 PM 3 Width 0ft   6002364.11048 2089653.5699900002 37.7179247752893 -122.43381142685 (37.7179247752893, -122.43381142685)
4680 160421 2 73 591 France Ave 1 1 1 1 1 10/18/2017 04:04:00 PM 3 Width 0ft   6002387.355359999 2089638.81491 37.7178855801363 -122.433730025613 (37.7178855801363, -122.433730025613)
4827 160418 2 155 645 France Ave 1 1 1 1 1 10/25/2017 04:39:00 PM 3 Width 0ft   6002625.21582 2089488.7759200002 37.7174871004251 -122.43289713470199 (37.7174871004251, -122.432897134702)
4462 160324 2 174 510X Italy Ave 1 1 1 1 1 10/13/2017 02:10:00 PM 3 Width 0ft   6001907.38785 2089113.4382599997 37.7164157659386 -122.435351498769 (37.7164157659386, -122.435351498769)
4490 160323 2 174 510X Italy Ave 2 1 1 1 1 10/13/2017 01:57:00 PM 3 Width 0ft   6001921.46763 2089105.50941 37.7163947946735 -122.43530226538999 (37.7163947946735, -122.43530226539)
4687 160322 2 174 510X Italy Ave 3 1 1 1 1 10/18/2017 11:36:00 AM 3 Width 0ft   6001932.580630001 2089099.8242400002 37.716379815556294 -122.435263447059 (37.7163798155563, -122.435263447059)
4505 160320 2 174 550X Italy Ave 1 1 1 1 1 10/13/2017 02:08:00 PM 3 Width 0ft   6001986.11056 2089065.71241 37.716289191780795 -122.435075983386 (37.7162891917808, -122.435075983386)
4664 160319 2 174 550X Italy Ave 2 1 1 1 1 10/18/2017 11:39:00 AM 3 Width 0ft   6002000.464380001 2089057.1552900001 37.7162665108705 -122.435025758047 (37.7162665108705, -122.435025758047)
4674 148023 2 174 553X Italy Ave 1 1 1 1 1 10/18/2017 11:52:00 AM 3 Width 3ft   6001969.852469999 2089122.8198900002 37.716445073051894 -122.435136261339 (37.7164450730519, -122.435136261339)
4743 148019 2 8 605 Italy Ave 1 1 1 1 1 10/25/2017 12:12:00 PM 3 Width 3ft   6002175.19846 2088993.45658 37.7161015284444 -122.43441724168301 (37.7161015284444, -122.434417241683)
58276 122823 1 79 1736 Stockton St 3 1 1 1 1   7 4x4   6010043.2132 2120098.5684 37.8019526289989 -122.409415446027 (37.8019526289989, -122.409415446027)
169377 122822 1 79 1736 Stockton St 2 1 1 1 1   10     6010044.5984 2120081.0225 37.8019045299018 -122.40940941357799 (37.8019045299018, -122.409409413578)
82635 122813 1 161 889 York St 3 1 1 1 1         6009956.83094511 2104043.07852524 37.757863199609794 -122.40858112241999 (37.7578631996098, -122.40858112242)
85902 122812 1 225 889 York St 2 1 1 1 1         6009956.83094511 2104043.07852524 37.757863199609794 -122.40858112241999 (37.7578631996098, -122.40858112242)
130667 122798 1 32 1458 Kansas St 2 1 1 1 1   16 4x4   6011711.28615 2101551.94693 37.7511212018046 -122.40233829389099 (37.7511212018046, -122.402338293891)
Powered by Datasette · Query took 73.089ms · Data source: data.sfgov.org